1 PACKAGE MSC_PURGE_LID AUTHID CURRENT_USER AS
2 /*$Header: MSCPPURS.pls 120.5 2010/08/13 12:02:42 lsindhur ship $ */
3 -- ================== CONSTANTS =====================
4 G_ST_EMPTY CONSTANT NUMBER:= 0;
5 G_ST_PULLING CONSTANT NUMBER:= 1;
6 G_ST_READY CONSTANT NUMBER:= 2;
7 G_ST_COLLECTING CONSTANT NUMBER:= 3;
8 G_ST_PURGING CONSTANT NUMBER:= 4;
9 G_ST_PRE_PROCESSING CONSTANT NUMBER:= 5;
10 G_INS_OTHER CONSTANT NUMBER:= 3;
11 G_INS_EXCH CONSTANT NUMBER:= 5;
12
13 G_ERROR CONSTANT NUMBER:= 2;
14 G_SUCCESS CONSTANT NUMBER:= 0;
15
16 ----- CONSTANTS --------------------------------------------------------
17 SYS_YES CONSTANT NUMBER := 1;
18 SYS_NO CONSTANT NUMBER := 2;
19
20 type entity_list is TABLE OF varchar2(255) INDEX BY BINARY_INTEGER;
21
22 -- ================= Procedures ====================
23 PROCEDURE PURGE_LID_TABLES(ERRBUF OUT NOCOPY VARCHAR2,
24 RETCODE OUT NOCOPY NUMBER,
25 p_instance_id IN NUMBER,
26 p_complete_refresh IN NUMBER DEFAULT SYS_NO,
27 p_date IN VARCHAR2,
28 p_supply_flag IN NUMBER DEFAULT SYS_NO,
29 p_demand_flag IN NUMBER DEFAULT SYS_NO);
30
31
32 PROCEDURE PURGE_ODS_TABLES_DEL( p_instance_id IN NUMBER);
33
34 -- Added for purge_instance_plan_data, purge_instance_data and purge_plan_data
35
36 TYPE tblTyp IS TABLE OF NUMBER;
37
38 PROCEDURE PURGE_INSTANCE_DATA( ERRBUF OUT NOCOPY VARCHAR2,
39
40 RETCODE OUT NOCOPY NUMBER,
41
42 pInstList tblTyp);
43
44
45
46 PROCEDURE PURGE_PLAN_DATA( ERRBUF OUT NOCOPY VARCHAR2,
47
48 RETCODE OUT NOCOPY NUMBER,
49
50 pPlanList tblTyp);
51
52
53
54 PROCEDURE PURGE_INSTANCE_PLAN_DATA( ERRBUF OUT NOCOPY VARCHAR2,
55
56 RETCODE OUT NOCOPY NUMBER,
57
58 pInstanceId NUMBER,
59
60 pPlanId NUMBER) ;
61
62 PROCEDURE Purge_localid_table( pMode NUMBER,
63 pTable_name VARCHAR2,
64 pInstance_id NUMBER,
65 pPlan_id NUMBER,
66 pWhereClause VARCHAR2
67 );
68
69 PROCEDURE PURGE_ODS_DATA(
70 ERRBUF OUT NOCOPY VARCHAR2,
71 RETCODE OUT NOCOPY NUMBER,
72 pINSTANCE_ID IN NUMBER,
73 ppurgeglobalflag IN NUMBER,
74 pAPPROV_SUPPLIER_CAP_ENABLED IN NUMBER ,
75 pATP_RULES_ENABLED IN NUMBER ,
76 pBOM_ENABLED IN NUMBER ,
77 pBOR_ENABLED IN NUMBER ,
78 pCALENDAR_ENABLED IN NUMBER ,
79 pDEMAND_CLASS_ENABLED IN NUMBER ,
80 pITEM_SUBST_ENABLED IN NUMBER ,
81 pFORECAST_ENABLED IN NUMBER ,
82 pITEM_ENABLED IN NUMBER ,
83 pKPI_BIS_ENABLED IN NUMBER ,
84 pMDS_ENABLED IN NUMBER ,
85 pMPS_ENABLED IN NUMBER ,
86 pOH_ENABLED IN NUMBER ,
87 pPARAMETER_ENABLED IN NUMBER ,
88 pPLANNER_ENABLED IN NUMBER ,
89 pPO_RECEIPTS_ENABLED IN NUMBER ,
90 pPROJECT_ENABLED IN NUMBER ,
91 pPUR_REQ_PO_ENABLED IN NUMBER ,
92 pRESERVES_HARD_ENABLED IN NUMBER ,
93 pRESOURCE_NRA_ENABLED IN NUMBER ,
94 pSafeStock_ENABLED IN NUMBER ,
95 pSalesOrder_ENABLED IN NUMBER ,
96 pSH_ENABLED IN NUMBER ,
97 pSOURCING_ENABLED IN NUMBER ,
98 pSUB_INV_ENABLED IN NUMBER ,
99 pSUPPLIER_RESPONSE_ENABLED IN NUMBER ,
100 pTP_ENABLED IN NUMBER ,
101 pTRIP_ENABLED IN NUMBER ,
102 pUNIT_NO_ENABLED IN NUMBER ,
103 pUOM_ENABLED IN NUMBER ,
104 pUSER_COMPANY_ENABLED IN NUMBER ,
105 pUSER_SUPPLY_DEMAND IN NUMBER ,
106 pWIP_ENABLED IN NUMBER ,
107 pSALES_CHANNEL_ENABLED IN NUMBER ,
108 pFISCAL_CALENDAR_ENABLED IN NUMBER ,
109 pINTERNAL_REPAIR_ENABLED IN NUMBER ,
110 pEXTERNAL_REPAIR_ENABLED IN NUMBER ,
111 pPAYBACK_DEMAND_SUPPLY_ENABLED IN NUMBER ,
112 pCURRENCY_CONVERSION_ENABLED IN NUMBER ,
113 pDELIVERY_DETAILS_ENABLED IN NUMBER ,
114 pIBUC_ENABLED IN NUMBER ,
115 pNOTES_ENABLED IN NUMBER
116 ) ;
117
118 PROCEDURE PURGE_ODS_LEG_DATA(
119 ERRBUF OUT NOCOPY VARCHAR2,
120 RETCODE OUT NOCOPY NUMBER,
121 pINSTANCE_ID IN NUMBER,
122 ppurgelocalidflag IN NUMBER,
123 ppurgeglobalflag IN NUMBER,
124 pAPPROV_SUPPLIER_CAP_ENABLED IN NUMBER ,
125 pATP_RULES_ENABLED IN NUMBER ,
126 pBOM_ENABLED IN NUMBER ,
127 pRESOURCE_ENABLED IN NUMBER ,
128 pROUTING_ENABLED IN NUMBER ,
129 pOPERATION_ENABLED IN NUMBER ,
130 pBOR_ENABLED IN NUMBER ,
131 pCALENDAR_ENABLED IN NUMBER ,
132 pCALENDAR_ASSIGN_ENABLED IN NUMBER ,
133 pDEMAND_CLASS_ENABLED IN NUMBER ,
134 pITEM_SUBST_ENABLED IN NUMBER ,
135 pDESIGNATORS_ENABLED IN NUMBER ,
136 pFORECAST_ENABLED IN NUMBER ,
137 pITEM_ENABLED IN NUMBER ,
138 pITEM_CATEGORIES_ENABLED IN NUMBER ,
139 pCATEGORY_SETS_ENABLED IN NUMBER ,
140 pKPI_BIS_ENABLED IN NUMBER ,
141 pMDS_ENABLED IN NUMBER ,
142 pMPS_ENABLED IN NUMBER ,
143 pOH_ENABLED IN NUMBER ,
144 pPARAMETER_ENABLED IN NUMBER ,
145 pPLANNER_ENABLED IN NUMBER ,
146 pPO_RECEIPTS_ENABLED IN NUMBER ,
147 pPROJECT_ENABLED IN NUMBER ,
148 pPUR_REQ_PO_ENABLED IN NUMBER ,
149 pRESERVES_HARD_ENABLED IN NUMBER ,
150 pRESOURCE_NRA_ENABLED IN NUMBER ,
151 pSafeStock_ENABLED IN NUMBER ,
152 pSalesOrder_ENABLED IN NUMBER ,
153 pSH_ENABLED IN NUMBER ,
154 pSHIP_METHOD_ENABLED IN NUMBER ,
155 pSOURCING_ENABLED IN NUMBER ,
156 pSUB_INV_ENABLED IN NUMBER ,
157 pSUPPLIER_RESPONSE_ENABLED IN NUMBER ,
158 pTP_ENABLED IN NUMBER ,
159 pTRIP_ENABLED IN NUMBER ,
160 pUNIT_NO_ENABLED IN NUMBER ,
161 pUOM_ENABLED IN NUMBER ,
162 pUOM_CONVERSIONS_ENABLED IN NUMBER ,
163 pUSER_COMPANY_ENABLED IN NUMBER ,
164 pUSER_DEMAND IN NUMBER ,
165 pUSER_SUPPLY IN NUMBER ,
166 pWIP_ENABLED IN NUMBER ,
167 pSALES_CHANNEL_ENABLED IN NUMBER ,
168 pFISCAL_CALENDAR_ENABLED IN NUMBER ,
169 pINTERNAL_REPAIR_ENABLED IN NUMBER ,
170 pEXTERNAL_REPAIR_ENABLED IN NUMBER ,
171 pPAYBACK_DEMAND_SUPPLY_ENABLED IN NUMBER ,
172 pCURRENCY_CONVERSION_ENABLED IN NUMBER ,
173 pDELIVERY_DETAILS_ENABLED IN NUMBER
174 ) ;
175
176 PROCEDURE PURGE_INST_ENTITY_ODS_DATA (
177 pINSTANCE_ID IN NUMBER,
178 parray IN entity_list,
179 ppurgelocalidflag IN NUMBER,
180 ppurgeglobalflag IN NUMBER,
181 pstatusflag OUT NOCOPY NUMBER
182 );
183
184 END MSC_PURGE_LID;