PACKAGE: APPS.MSC_CL_PROFILE_LOADERS

Source

1 PACKAGE MSC_CL_PROFILE_LOADERS AUTHID CURRENT_USER AS
2 /* $Header: MSCPROFLDS.pls 115.0 2003/01/19 19:00:38 rawasthi noship $ */
3 
4   ----- ARRAY DATA TYPE --------------------------------------------------
5 
6    TYPE NumTblTyp IS TABLE OF NUMBER;
7    TYPE VarcharTblTyp IS TABLE OF VARCHAR2(1000);
8 
9   ----- CONSTANTS --------------------------------------------------------
10 
11    SYS_YES                      CONSTANT NUMBER := 1;
12    SYS_NO                       CONSTANT NUMBER := 2;
13 
14    G_SUCCESS                    CONSTANT NUMBER := 0;
15    G_WARNING                    CONSTANT NUMBER := 1;
16    G_ERROR                      CONSTANT NUMBER := 2;
17 
18    -- NULL VALUE USED IN THE WHERE CLAUSE
19 
20    NULL_DATE             CONSTANT DATE:=   SYSDATE-36500;
21    NULL_VALUE            CONSTANT NUMBER:= -23453;   -- null value for positive number
22    NULL_CHAR             CONSTANT VARCHAR2(6):= '-23453';
23 
24    -- ============ Task Control ================
25 
26    PIPE_TIME_OUT         CONSTANT NUMBER := 30;      -- 30 secs
27    START_TIME            DATE;
28 
29 
30 
31    -- ================== Worker Status ===================
32 
33     OK                    		CONSTANT NUMBER := 1;
34     FAIL                  		CONSTANT NUMBER := 0;
35 
36    --  ================= Procedures ====================
37    PROCEDURE LAUNCH_PROFILE_MON( ERRBUF      OUT NOCOPY VARCHAR2,
38 	         RETCODE                     OUT NOCOPY NUMBER,
39 	         p_timeout                   IN  NUMBER,
40                  p_path_separator            IN  VARCHAR2 DEFAULT '/',
41                  p_ctl_file_path             IN  VARCHAR2,
42 	         p_directory_path            IN  VARCHAR2,
43 	         p_total_worker_num          IN  NUMBER,
44                  p_get_profile_value         IN  VARCHAR2 DEFAULT NULL);
45 
46 
47 
48 END MSC_CL_PROFILE_LOADERS;