[Home] [Help]
PACKAGE: APPS.MSD_PURGE_LEG
Source
1 PACKAGE MSD_PURGE_LEG AUTHID CURRENT_USER AS
2 /* $Header: MSDPURS.pls 115.3 2003/01/20 04:19:31 jarora ship $ */
3
4
5
6 SYS_YES CONSTANT NUMBER := 1;
7 SYS_NO CONSTANT NUMBER := 2;
8
9 -- ================== Process Flag ===================
10 G_NEW CONSTANT NUMBER := 1;
11 G_IN_PROCESS CONSTANT NUMBER := 2;
12 G_ERROR_FLG CONSTANT NUMBER := 3;
13 G_PROPAGATION CONSTANT NUMBER := 4;
14 G_VALID CONSTANT NUMBER := 5;
15
16
17 -- ================== Staging Table Status===================
18 G_ST_EMPTY CONSTANT NUMBER := 0; -- no instance data exists;
19 G_ST_PULLING CONSTANT NUMBER := 1;
20 G_ST_READY CONSTANT NUMBER := 2;
21 G_ST_COLLECTING CONSTANT NUMBER := 3;
22 G_ST_PURGING CONSTANT NUMBER := 4;
23 G_ST_PRE_PROCESSING CONSTANT NUMBER := 5;
24
25 -- ================== Program Status ===================
26 G_SUCCESS CONSTANT NUMBER := 0;
27 G_WARNING CONSTANT NUMBER := 1;
28 G_ERROR CONSTANT NUMBER := 2;
29
30 -- ================== Instance Types ===================
31 G_INS_DISCRETE CONSTANT NUMBER := 1;
32 G_INS_PROCESS CONSTANT NUMBER := 2;
33 G_INS_OTHER CONSTANT NUMBER := 3;
34 G_INS_MIXED CONSTANT NUMBER := 4;
35 G_INS_EXCHANGE CONSTANT NUMBER := 5;
36
37
38 PROCEDURE LAUNCH_PROCEDURE( ERRBUF OUT NOCOPY VARCHAR2,
39 RETCODE OUT NOCOPY NUMBER,
40 p_instance_id IN NUMBER,
41 p_del_rej_rec IN NUMBER DEFAULT SYS_YES);
42
43 END MSD_PURGE_LEG;