260 lines
7.2 KiB
MySQL
260 lines
7.2 KiB
MySQL
|
--------------------------------------------------------
|
||
|
|
-- DDL for Package PKG_DEPLOY_COORDINATOR
|
||
|
|
--------------------------------------------------------
|
||
|
|
|
||
|
|
CREATE OR REPLACE EDITIONABLE PACKAGE "ENVX_OPER"."PKG_DEPLOY_COORDINATOR" AS
|
||
|
|
|
||
|
|
------------- FUNCTIONS ------------------
|
||
|
|
|
||
|
|
/*--------------- FNC01-------------------*/
|
||
|
|
FUNCTION request_hgroup_name (
|
||
|
|
pi_id_request IN NUMBER,
|
||
|
|
pi_id_enviroment_type IN NUMBER,
|
||
|
|
pi_creation_date IN DATE
|
||
|
|
) RETURN VARCHAR2;
|
||
|
|
|
||
|
|
/*--------------- FNC02-------------------*/
|
||
|
|
|
||
|
|
FUNCTION next_step_status (
|
||
|
|
pi_id_pattern IN NUMBER,
|
||
|
|
pi_id_pattern_step IN NUMBER,
|
||
|
|
pi_id_status IN NUMBER,
|
||
|
|
pi_result IN NUMBER
|
||
|
|
) RETURN NUMBER;
|
||
|
|
|
||
|
|
/*--------------- FNC03-------------------*/
|
||
|
|
|
||
|
|
FUNCTION step_status_result (
|
||
|
|
pi_pattern IN NUMBER,
|
||
|
|
pi_id_pattern_step IN NUMBER,
|
||
|
|
pi_id_status IN NUMBER
|
||
|
|
) RETURN VARCHAR2;
|
||
|
|
|
||
|
|
/*--------------- FNC04-------------------*/
|
||
|
|
|
||
|
|
FUNCTION step_status_category (
|
||
|
|
pi_id_pattern IN NUMBER,
|
||
|
|
pi_id_pattern_step IN NUMBER,
|
||
|
|
pi_id_status IN NUMBER
|
||
|
|
) RETURN NUMBER;
|
||
|
|
|
||
|
|
/*--------------- FNC05-------------------*/
|
||
|
|
|
||
|
|
FUNCTION step_status_retry (
|
||
|
|
pi_id_pattern IN NUMBER,
|
||
|
|
pi_id_pattern_step IN NUMBER,
|
||
|
|
pi_id_status IN NUMBER
|
||
|
|
) RETURN NUMBER;
|
||
|
|
|
||
|
|
/*--------------- FNC06-------------------*/
|
||
|
|
|
||
|
|
FUNCTION step_exec_category (
|
||
|
|
pi_id_pattern IN NUMBER,
|
||
|
|
pi_id_pattern_step IN NUMBER,
|
||
|
|
pi_result IN NUMBER
|
||
|
|
) RETURN NUMBER;
|
||
|
|
|
||
|
|
/*--------------- FNC07-------------------*/
|
||
|
|
|
||
|
|
FUNCTION sch_job_name (
|
||
|
|
pi_id_schedule IN NUMBER,
|
||
|
|
pi_id_schedule_detail IN NUMBER,
|
||
|
|
pi_schedule_fequency IN NUMBER
|
||
|
|
) RETURN VARCHAR2;
|
||
|
|
|
||
|
|
|
||
|
|
/*--------------- FNC08-------------------*/
|
||
|
|
|
||
|
|
FUNCTION schedule_fequency_name (
|
||
|
|
pi_schedule_fequency IN NUMBER,
|
||
|
|
pi_schedule_init_date IN DATE
|
||
|
|
) RETURN VARCHAR2;
|
||
|
|
|
||
|
|
/*--------------- FNC09-------------------*/
|
||
|
|
|
||
|
|
FUNCTION schedule_fequency_job (
|
||
|
|
pi_schedule_fequency IN NUMBER,
|
||
|
|
pi_schedule_init_date IN DATE
|
||
|
|
) RETURN VARCHAR2;
|
||
|
|
|
||
|
|
/*--------------- FNC10-------------------*/
|
||
|
|
FUNCTION fnc_request_icon_deploy (
|
||
|
|
pi_id_status number
|
||
|
|
) return varchar2;
|
||
|
|
|
||
|
|
|
||
|
|
/*--------------- FNC11-------------------*/
|
||
|
|
|
||
|
|
FUNCTION fnc_request_status (
|
||
|
|
pi_id_control_deploy NUMBER
|
||
|
|
) RETURN VARCHAR2;
|
||
|
|
|
||
|
|
/*--------------- FNC12-------------------*/
|
||
|
|
|
||
|
|
FUNCTION fnc_request_progress (
|
||
|
|
pi_id_request number
|
||
|
|
) return varchar2;
|
||
|
|
|
||
|
|
/*--------------- FNC13-------------------*/
|
||
|
|
|
||
|
|
FUNCTION fnc_icon_flag (
|
||
|
|
pi_id_request number,
|
||
|
|
pi_env_hgroup varchar2
|
||
|
|
) return varchar2;
|
||
|
|
|
||
|
|
------------ PROCEDURES ------------------
|
||
|
|
/*--------------- DPCP1-------------------*/
|
||
|
|
|
||
|
|
PROCEDURE manage_enviroment_pattern (
|
||
|
|
pi_id_pattern IN NUMBER,
|
||
|
|
pi_id_enviroment IN NUMBER,
|
||
|
|
po_warning OUT NOCOPY VARCHAR2
|
||
|
|
);
|
||
|
|
/*--------------- DPCP2-------------------*/
|
||
|
|
|
||
|
|
PROCEDURE manage_enviroment_request (
|
||
|
|
pi_id_request IN NUMBER,
|
||
|
|
pi_id_req_hgroup IN VARCHAR2,
|
||
|
|
pi_id_deploying_tech IN NUMBER,
|
||
|
|
pi_id_enviroment IN NUMBER,
|
||
|
|
po_warning OUT NOCOPY VARCHAR2
|
||
|
|
);
|
||
|
|
/*--------------- DPCP3-------------------*/
|
||
|
|
|
||
|
|
PROCEDURE manage_object_request (
|
||
|
|
pi_id_request IN NUMBER,
|
||
|
|
pi_id_req_hgroup IN VARCHAR2,
|
||
|
|
pi_id_pattern IN NUMBER,
|
||
|
|
pi_object_path IN VARCHAR2,
|
||
|
|
pi_object_name IN VARCHAR2,
|
||
|
|
pi_object_version IN VARCHAR2,
|
||
|
|
pi_id_object_repo IN VARCHAR2,
|
||
|
|
po_warning OUT NOCOPY VARCHAR2
|
||
|
|
);
|
||
|
|
/*--------------- DPCP4-------------------*/
|
||
|
|
|
||
|
|
PROCEDURE automatic_dep_control (
|
||
|
|
pi_id_request IN INTEGER,
|
||
|
|
pi_id_control_deploy IN INTEGER,
|
||
|
|
pi_id_status IN INTEGER,
|
||
|
|
pi_exec_message IN VARCHAR2,
|
||
|
|
pi_exec_date IN VARCHAR2,
|
||
|
|
po_warning OUT NOCOPY VARCHAR2
|
||
|
|
);
|
||
|
|
|
||
|
|
/*--------------- DPCP5-------------------*/
|
||
|
|
|
||
|
|
PROCEDURE first_dep_control (
|
||
|
|
pi_id_request IN NUMBER,
|
||
|
|
pi_id_user IN NUMBER,
|
||
|
|
pi_queue_alias IN VARCHAR2,
|
||
|
|
n_red OUT NOCOPY request_exec_deploy%rowtype
|
||
|
|
);
|
||
|
|
|
||
|
|
/*--------------- DPCP6-------------------*/
|
||
|
|
|
||
|
|
PROCEDURE next_dep_control (
|
||
|
|
n_red IN OUT NOCOPY request_exec_deploy%rowtype
|
||
|
|
);
|
||
|
|
|
||
|
|
/*--------------- DPCP7-------------------*/
|
||
|
|
|
||
|
|
PROCEDURE update_dep_control (
|
||
|
|
pi_id_request IN NUMBER,
|
||
|
|
pi_id_control_deploy IN NUMBER,
|
||
|
|
pi_id_prc_exec IN VARCHAR2,
|
||
|
|
pi_status IN NUMBER,
|
||
|
|
pi_exec_message IN VARCHAR2,
|
||
|
|
po_result OUT INTEGER -- 0: Sin actualizaciones , 1: Con actualizaciones
|
||
|
|
);
|
||
|
|
|
||
|
|
/*--------------- DPCP8-------------------*/
|
||
|
|
|
||
|
|
PROCEDURE execution_status (
|
||
|
|
pi_id_request IN NUMBER,
|
||
|
|
pi_environment_alias IN VARCHAR2,
|
||
|
|
pi_id_det_req IN NUMBER,
|
||
|
|
pi_id_prc_exec IN VARCHAR2,
|
||
|
|
pi_status IN NUMBER,
|
||
|
|
pi_exec_message IN VARCHAR2,
|
||
|
|
pi_exec_date IN VARCHAR2
|
||
|
|
);
|
||
|
|
|
||
|
|
/*--------------- DPCP9-------------------*/
|
||
|
|
|
||
|
|
PROCEDURE delete_references (
|
||
|
|
pi_id_request IN NUMBER,
|
||
|
|
pi_id_reference IN VARCHAR2,
|
||
|
|
po_warning OUT NOCOPY VARCHAR2
|
||
|
|
);
|
||
|
|
|
||
|
|
/*--------------- DPCP10-------------------*/
|
||
|
|
|
||
|
|
PROCEDURE manage_references (
|
||
|
|
pi_id_request IN NUMBER,
|
||
|
|
pi_id_reference IN VARCHAR2,
|
||
|
|
pi_id_reference_des IN VARCHAR2,
|
||
|
|
po_warning OUT NOCOPY VARCHAR2
|
||
|
|
);
|
||
|
|
|
||
|
|
/*--------------- DPCP11-------------------*/
|
||
|
|
|
||
|
|
PROCEDURE manage_dep_queue (
|
||
|
|
pi_id_request IN NUMBER
|
||
|
|
);
|
||
|
|
|
||
|
|
/*--------------- DPCP12-------------------*/
|
||
|
|
|
||
|
|
PROCEDURE first_dep_queue (
|
||
|
|
pi_job_name IN VARCHAR2
|
||
|
|
);
|
||
|
|
|
||
|
|
/*--------------- DPCP13-------------------*/
|
||
|
|
|
||
|
|
PROCEDURE next_dep_queue (
|
||
|
|
pi_id_request IN NUMBER DEFAULT 0,
|
||
|
|
pi_queue_alias IN VARCHAR2
|
||
|
|
);
|
||
|
|
|
||
|
|
/*--------------- DPCP14-------------------*/
|
||
|
|
|
||
|
|
PROCEDURE manage_dep_job (
|
||
|
|
pi_job_n_name IN VARCHAR2,
|
||
|
|
pi_job_o_name IN VARCHAR2,
|
||
|
|
pi_job_status IN NUMBER,
|
||
|
|
pi_freq IN NUMBER,
|
||
|
|
pi_start_date IN DATE
|
||
|
|
);
|
||
|
|
|
||
|
|
/*---------------DPCP15--------------------*/
|
||
|
|
PROCEDURE manage_req_object_order (
|
||
|
|
pi_id_dep_req_object IN NUMBER,
|
||
|
|
pi_id_req_hgroup IN VARCHAR2
|
||
|
|
);
|
||
|
|
|
||
|
|
/*---------------DPCP16--------------------*/
|
||
|
|
PROCEDURE manage_req_hgroup_order (
|
||
|
|
pi_id_request IN NUMBER,
|
||
|
|
pi_id_req_hgroup_level IN VARCHAR2,
|
||
|
|
pi_id_parent_req_hgroup IN VARCHAR2
|
||
|
|
);
|
||
|
|
|
||
|
|
/*---------------DPCP17--------------------*/
|
||
|
|
PROCEDURE p_genera_job(
|
||
|
|
|
||
|
|
pi_job_nombre IN VARCHAR2,
|
||
|
|
pi_job_accion IN VARCHAR2,
|
||
|
|
pi_job_tipo_frecuencia IN NUMBER,
|
||
|
|
pi_job_fecha_inicio IN TIMESTAMP,
|
||
|
|
po_estado OUT NUMBER
|
||
|
|
);
|
||
|
|
|
||
|
|
/*---------------DPCP18--------------------*/
|
||
|
|
PROCEDURE p_elimina_job(
|
||
|
|
pi_nombre_job IN OUT CLOB
|
||
|
|
);
|
||
|
|
|
||
|
|
END pkg_deploy_coordinator;
|
||
|
|
|
||
|
|
/
|