1 PACKAGE MSD_CL_PRE_PROCESS AS -- specification
2 /* $Header: MSDCLPPS.pls 120.3 2007/09/07 09:22:43 abhikuma ship $ */
3
4 ----- CONSTANTS ------------------------------------------------
5 G_ERROR CONSTANT NUMBER := 2;
6 G_WARNING CONSTANT NUMBER := 1;
7
8 NULL_CHAR CONSTANT VARCHAR2(6) := '-23453';
9 NULL_VALUE CONSTANT NUMBER := -23453;
10
11 SYS_YES CONSTANT NUMBER := 1;
12 SYS_NO CONSTANT NUMBER := 2;
13
14 G_NEW_REQUEST CONSTANT NUMBER :=0; -- new request
15 G_DP_LV_REQ_DATA CONSTANT NUMBER :=2; -- DP Level Values sub-request
16 G_DP_CS_REQ_DATA CONSTANT NUMBER :=3; -- DP custom stream sub-request
17 G_NO_PLAN_PERCENTAGE CONSTANT NUMBER :=1; -- Profile option choice 1 for profile MSD_PLANNING_PERCENTAGE.
18 G_INS_OTHER CONSTANT NUMBER :=3; -- Legacy Instance Type
19
20 -- Calling module --------------------------------------------------
21
22 G_APS CONSTANT NUMBER := 1;
23 G_DP CONSTANT NUMBER := 2;
24
25 ----- GLobal Variable -------------------------------------------------
26 v_link NUMBER;
27
28 -- ================== Process Flag ===================
29 G_NEW CONSTANT NUMBER := 1;
30 G_IN_PROCESS CONSTANT NUMBER := 2;
31 G_ERROR_FLG CONSTANT NUMBER := 3;
32 G_VALID CONSTANT NUMBER := 5;
33
34 G_BUCKET_TYPE CONSTANT NUMBER := 1;
35 G_MFG_CAL CONSTANT NUMBER := 2;
36 G_FISCAL_CAL CONSTANT NUMBER := 3;
37 G_COMPOSITE_CAL CONSTANT NUMBER := 4;
38
39
40
41 G_SEV3_ERROR CONSTANT NUMBER := 3;
42 G_SEV_ERROR CONSTANT NUMBER := 1;
43
44 --========================PROCEDURES=================
45 PROCEDURE LOAD_ORG_CUST (ERRBUF OUT NOCOPY VARCHAR,
46 RETCODE OUT NOCOPY NUMBER,
47 p_instance_id IN NUMBER,
48 p_batch_id IN NUMBER);
49
50
51 PROCEDURE LOAD_ITEMS (ERRBUF OUT NOCOPY VARCHAR,
52 RETCODE OUT NOCOPY NUMBER,
53 p_instance_id IN NUMBER,
54 p_batch_id IN NUMBER);
55
56 PROCEDURE LOAD_CATEGORY (ERRBUF OUT NOCOPY VARCHAR,
57 RETCODE OUT NOCOPY NUMBER,
58 p_instance_id IN NUMBER,
59 p_batch_id IN NUMBER,
60 p_link IN NUMBER);
61
62 PROCEDURE LOAD_SITE (ERRBUF OUT NOCOPY VARCHAR,
63 RETCODE OUT NOCOPY NUMBER,
64 p_instance_id IN NUMBER,
65 p_batch_id IN NUMBER);
66
67
68 PROCEDURE LOAD_LEVEL_VALUE (ERRBUF OUT NOCOPY VARCHAR,
69 RETCODE OUT NOCOPY NUMBER,
70 p_instance_code IN VARCHAR,
71 p_instance_id IN NUMBER,
72 p_batch_id IN NUMBER);
73
74 PROCEDURE LOAD_LEVEL_ASSOC( ERRBUF OUT NOCOPY VARCHAR,
75 RETCODE OUT NOCOPY VARCHAR,
76 p_instance_code IN VARCHAR,
77 p_instance_id IN NUMBER,
78 p_batch_id IN NUMBER);
79
80
81 PROCEDURE LOAD_BOOKING_DATA(ERRBUF OUT NOCOPY VARCHAR,
82 RETCODE OUT NOCOPY NUMBER,
83 p_instance_code IN VARCHAR,
84 p_instance_id IN NUMBER,
85 p_batch_id IN NUMBER);
86
87
88 PROCEDURE LOAD_SHIPMENT_DATA(ERRBUF OUT NOCOPY VARCHAR,
89 RETCODE OUT NOCOPY NUMBER,
90 p_instance_code IN VARCHAR,
91 p_instance_id IN NUMBER,
92 p_batch_id IN NUMBER);
93
94 PROCEDURE LOAD_MFG_FORECAST(ERRBUF OUT NOCOPY VARCHAR,
95 RETCODE OUT NOCOPY NUMBER,
96 p_instance_code IN VARCHAR,
97 p_instance_id IN NUMBER,
98 p_batch_id IN NUMBER);
99
100 PROCEDURE LOAD_MFG_TIME (ERRBUF OUT NOCOPY VARCHAR,
101 RETCODE OUT NOCOPY NUMBER,
102 p_instance_id IN NUMBER,
103 p_calendar_code IN VARCHAR);
104
105 PROCEDURE LOAD_FISCAL_TIME (ERRBUF OUT NOCOPY VARCHAR,
106 RETCODE OUT NOCOPY NUMBER,
107 p_instance_code IN VARCHAR,
108 p_instance_id IN NUMBER);
109
110 PROCEDURE LOAD_COMPOSITE_TIME (ERRBUF OUT NOCOPY VARCHAR,
111 RETCODE OUT NOCOPY NUMBER,
112 p_instance_code IN VARCHAR,
113 p_instance_id IN NUMBER);
114
115 PROCEDURE LOAD_CURRENCY_CONV (ERRBUF OUT NOCOPY VARCHAR,
116 RETCODE OUT NOCOPY NUMBER,
117 p_instance_code IN VARCHAR,
118 p_instance_id IN NUMBER,
119 p_batch_id IN NUMBER);
120
121 PROCEDURE LOAD_CS_DATA (ERRBUF OUT NOCOPY VARCHAR,
122 RETCODE OUT NOCOPY NUMBER,
123 p_instance_code IN VARCHAR,
124 p_instance_id IN NUMBER,
125 p_batch_id IN NUMBER);
126
127 PROCEDURE LOAD_PRICE_LIST (ERRBUF OUT NOCOPY VARCHAR,
128 RETCODE OUT NOCOPY NUMBER,
129 p_instance_code IN VARCHAR,
130 p_instance_id IN NUMBER,
131 p_batch_id IN NUMBER);
132
133
134 PROCEDURE LOAD_UOM_CONV (ERRBUF OUT NOCOPY VARCHAR,
135 RETCODE OUT NOCOPY NUMBER,
136 p_instance_code IN VARCHAR,
137 p_instance_id IN NUMBER,
138 p_batch_id IN NUMBER);
139
140
141 PROCEDURE LOAD_SETUP_PARAMETER(ERRBUF OUT NOCOPY VARCHAR,
142 RETCODE OUT NOCOPY NUMBER,
143 p_instance_code IN VARCHAR,
144 p_instance_id IN NUMBER);
145
146 PROCEDURE LOAD_ITEM_RELATIONSHIP ( p_instance_code IN VARCHAR,
147 p_instance_id IN NUMBER );
148
149 PROCEDURE LOAD_LEVEL_ORG_ASSCNS ( p_instance_code IN VARCHAR,
150 p_instance_id IN NUMBER );
151
152 PROCEDURE LOAD_DEMAND_CLASS (ERRBUF OUT NOCOPY VARCHAR,
153 RETCODE OUT NOCOPY NUMBER,
154 p_instance_code IN VARCHAR,
155 p_instance_id IN NUMBER,
156 p_batch_id IN NUMBER );
157
158
159 PROCEDURE LAUNCH_PULL_PROGRAM(ERRBUF OUT NOCOPY VARCHAR2,
160 RETCODE OUT NOCOPY NUMBER,
161 p_instance_id IN NUMBER ,
162 p_request_id IN NUMBER ,
163 p_launch_lvalue IN NUMBER DEFAULT SYS_NO,
164 p_launch_booking IN NUMBER DEFAULT SYS_NO,
165 p_launch_shipment IN NUMBER DEFAULT SYS_NO,
166 p_launch_forecast IN NUMBER DEFAULT SYS_NO,
167 p_launch_time IN NUMBER DEFAULT SYS_NO,
168 p_launch_pricing IN NUMBER DEFAULT SYS_NO,
169 p_launch_curr_conv IN NUMBER DEFAULT SYS_NO,
170 p_launch_uom_conv IN NUMBER DEFAULT SYS_NO,
171 p_launch_cs_data IN NUMBER DEFAULT SYS_NO,
172 p_cs_refresh IN NUMBER DEFAULT SYS_NO) ;
173
174 PROCEDURE LAUNCH_MONITOR( ERRBUF OUT NOCOPY VARCHAR2,
175 RETCODE OUT NOCOPY NUMBER,
176 p_instance_id IN NUMBER,
177 p_timeout IN NUMBER DEFAULT 1440,
178 p_batch_size IN NUMBER DEFAULT 1000,
179 p_total_worker_num IN NUMBER DEFAULT 3,
180 p_ascp_ins_dummy IN VARCHAR2 DEFAULT NULL,
181 p_dummy1 IN VARCHAR2 DEFAULT NULL,
182 p_dummy2 IN VARCHAR2 DEFAULT NULL,
183 p_cal_enabled IN NUMBER DEFAULT SYS_NO,
184 p_dmd_class_enabled IN NUMBER DEFAULT SYS_YES,
185 p_tp_enabled IN NUMBER DEFAULT SYS_YES,
186 p_list_price_enabled IN NUMBER DEFAULT SYS_NO,
187 p_ctg_enabled IN NUMBER DEFAULT SYS_YES,
188 p_item_enabled IN NUMBER DEFAULT SYS_YES,
189 p_item_cat_enabled IN NUMBER DEFAULT SYS_YES,
190 p_rollup_dummy IN VARCHAR2 DEFAULT NULL,
191 p_item_rollup IN NUMBER DEFAULT SYS_YES,
192 p_bom_enabled IN NUMBER DEFAULT SYS_YES,
193 p_uom_enabled IN NUMBER DEFAULT SYS_YES,
194 p_uom_conv_enabled IN NUMBER DEFAULT SYS_NO ,
195 p_curr_conv_enabled IN NUMBER DEFAULT SYS_NO,
196 p_setup_enabled IN NUMBER DEFAULT SYS_NO,
197 p_fiscal_cal_enabled IN NUMBER DEFAULT SYS_NO,
198 p_comp_cal_enabled IN NUMBER DEFAULT SYS_NO,
199 p_level_value_enabled IN NUMBER DEFAULT SYS_NO,
200 p_level_assoc_enabled IN NUMBER DEFAULT SYS_NO,
201 p_booking_enabled IN NUMBER DEFAULT SYS_NO,
202 p_shipment_enabled IN NUMBER DEFAULT SYS_NO,
203 p_mfg_fct_enabled IN NUMBER DEFAULT SYS_NO,
204 p_cs_data_enabled IN NUMBER DEFAULT SYS_NO,
205 p_cs_dummy IN VARCHAR2 DEFAULT NULL,
206 p_cs_refresh IN NUMBER DEFAULT SYS_NO,
207 p_parent_request_id IN NUMBER DEFAULT -1,
208 p_calling_module IN NUMBER DEFAULT G_DP);
209
210 PROCEDURE LAUNCH_DELETE_DUPLICATES(ERRBUF OUT NOCOPY VARCHAR2,
211 RETCODE OUT NOCOPY NUMBER,
212 p_instance_id IN NUMBER);
213
214 END MSD_CL_PRE_PROCESS;
215