95 lines
2.6 KiB
MySQL
95 lines
2.6 KiB
MySQL
|
--------------------------------------------------------
|
||
|
|
-- DDL for Package PKG_SICD_COMMONS
|
||
|
|
--------------------------------------------------------
|
||
|
|
|
||
|
|
CREATE OR REPLACE EDITIONABLE PACKAGE "ENVX_OPER"."PKG_SICD_COMMONS" AS
|
||
|
|
|
||
|
|
/*--------------- FNC01-------------------*/
|
||
|
|
FUNCTION f_rest_call (
|
||
|
|
p_body IN VARCHAR2,
|
||
|
|
p_url IN VARCHAR2,
|
||
|
|
p_http_verb IN VARCHAR2,
|
||
|
|
p_http_version IN VARCHAR2,
|
||
|
|
p_http_content_type IN VARCHAR2 DEFAULT NULL,
|
||
|
|
p_http_accept IN VARCHAR2,
|
||
|
|
p_one_way IN BOOLEAN DEFAULT false,
|
||
|
|
p_response_text OUT CLOB,
|
||
|
|
p_reason_phrase OUT VARCHAR2
|
||
|
|
) RETURN NUMBER;
|
||
|
|
|
||
|
|
/*--------------- FNC02-------------------*/
|
||
|
|
|
||
|
|
FUNCTION f_system_message (
|
||
|
|
pi_id_message NUMBER,
|
||
|
|
pi_message_class VARCHAR2,
|
||
|
|
pi_return_type NUMBER DEFAULT 1
|
||
|
|
-- 0- SIMPLE / 1- COMPLETE / 2- ADDITIONAL INFO
|
||
|
|
) RETURN VARCHAR2;
|
||
|
|
|
||
|
|
/*--------------- FNC03-------------------*/
|
||
|
|
|
||
|
|
FUNCTION get_parameter_value (
|
||
|
|
param_name VARCHAR2
|
||
|
|
) RETURN VARCHAR2;
|
||
|
|
|
||
|
|
/*--------------- FNC04-------------------*/
|
||
|
|
|
||
|
|
FUNCTION get_parameter_list (
|
||
|
|
param_name VARCHAR2
|
||
|
|
) RETURN SYS_REFCURSOR;
|
||
|
|
|
||
|
|
/*--------------- FNC05-------------------*/
|
||
|
|
|
||
|
|
FUNCTION get_parameter_list_q (
|
||
|
|
param_name VARCHAR2
|
||
|
|
) RETURN VARCHAR2;
|
||
|
|
|
||
|
|
/*--------------- FNC06-------------------*/
|
||
|
|
|
||
|
|
FUNCTION fnc_ldap_auth (
|
||
|
|
p_username IN VARCHAR2,
|
||
|
|
p_password IN VARCHAR2
|
||
|
|
) RETURN BOOLEAN;
|
||
|
|
|
||
|
|
/*--------------- FNC07-------------------*/
|
||
|
|
|
||
|
|
FUNCTION f_access_token_sicddb RETURN VARCHAR2;
|
||
|
|
|
||
|
|
/*--------------- FNC08-------------------*/
|
||
|
|
|
||
|
|
FUNCTION fnc_ad_auth (
|
||
|
|
p_username IN VARCHAR2,
|
||
|
|
p_password IN VARCHAR2
|
||
|
|
) RETURN BOOLEAN;
|
||
|
|
|
||
|
|
/*--------------- FNC09-------------------*/
|
||
|
|
FUNCTION fnc_auth_groups (
|
||
|
|
p_js_parameters json DEFAULT NULL
|
||
|
|
) RETURN BOOLEAN;
|
||
|
|
|
||
|
|
/*--------------- FNC10-------------------*/
|
||
|
|
FUNCTION fnc_parameter_validator(pi_value IN CLOB, pi_type IN NUMBER)
|
||
|
|
RETURN BOOLEAN;
|
||
|
|
|
||
|
|
/*--------------- PR01-------------------*/
|
||
|
|
|
||
|
|
PROCEDURE p_rest_call_apim (
|
||
|
|
pi_url IN VARCHAR2,
|
||
|
|
pi_http_method IN VARCHAR2 DEFAULT 'GET',
|
||
|
|
pi_body IN CLOB DEFAULT empty_clob(),
|
||
|
|
po_http_status OUT VARCHAR2,
|
||
|
|
po_http_headers OUT http_headers_tab,
|
||
|
|
po_response OUT CLOB,
|
||
|
|
po_response_code OUT VARCHAR2,
|
||
|
|
po_error_message OUT VARCHAR2
|
||
|
|
);
|
||
|
|
-------------------------------------------
|
||
|
|
|
||
|
|
|
||
|
|
END pkg_sicd_commons;
|
||
|
|
|
||
|
|
/
|
||
|
|
|
||
|
|
GRANT EXECUTE ON "ENVX_OPER"."PKG_SICD_COMMONS" TO "APEX_REST_PUBLIC_USER";
|
||
|
|
GRANT DEBUG ON "ENVX_OPER"."PKG_SICD_COMMONS" TO "APEX_REST_PUBLIC_USER";
|