CREATE PACKAGE MO_MO7105_ADJUST_PROC_PKG AS
|
PROC_TYPE_01 NUMBER := 1;
|
PROC_TYPE_02 NUMBER := 2;
|
PROC_TYPE_03 NUMBER := 3;
|
PROC_TYPE_04 NUMBER := 4;
|
|
PROC_TYPE_FLG_SIZE NUMBER := 1;
|
PROC_TYPE_FLG_DATA CHAR(1) := '1';
|
|
TYPE REF_ADJUST_PROC_INFO IS REF CURSOR;
|
|
PROCEDURE DL_ADJUST_PROC_DATA (
|
I_EXEC_USER IN WRAP_UPL_DOWNL_MNG.LAST_EXEC_USER%TYPE
|
, I_BASE_DATE IN DATE
|
, I_BASE_PROCCESSTYPE IN VARCHAR2
|
, O_ADJUST_PROC_INFO OUT REF_ADJUST_PROC_INFO
|
, O_STATUS OUT NUMBER
|
);
|
|
END MO_MO7105_ADJUST_PROC_PKG;
|
/
|