[Home] [Help]
PACKAGE: APPS.MSC_CL_PURGE_STAGING
Source
1 PACKAGE msc_cl_purge_staging AS
2 /* $Header: MSCCLPSS.pls 120.2.12010000.1 2008/05/02 19:02:12 appldev 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
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_purge ( 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 PROCEDURE PURGE_STAGING_TABLES_TRNC( p_instance_id IN NUMBER);
44
45 PROCEDURE PURGE_STAGING_TABLES_DEL( p_instance_id IN NUMBER);
46
47 PROCEDURE PURGE_STAGING_TABLES_SUB( p_instance_id IN NUMBER,
48 p_Blind_Purge IN NUMBER:=SYS_NO);
49 PROCEDURE TRUNCATE_STAGING_TABLES(ERRBUF OUT NOCOPY VARCHAR2,
50 RETCODE OUT NOCOPY NUMBER);
51
52
53 END msc_cl_purge_staging;