[Home] [Help]
PACKAGE: APPS.RLM_CUST_MERGE
Source
1 PACKAGE RLM_CUST_MERGE AUTHID CURRENT_USER AS
2 /* $Header: RLMCMRGS.pls 120.1 2005/07/17 18:11:56 rlanka noship $ */
3
4
5
6 /*===========================================================================
7 PACKAGE NAME: RLM_CUST_MERGE
8
9 DESCRIPTION: Contains the server side code for customer merge API
10 of Release Management Customer Merge.
11
12 CLIENT/SERVER: Server
13
14 LIBRARY NAME: None
15
16 OWNER: rvishnuv
17
18 PROCEDURE/FUNCTIONS:
19
20 GLOBALS:
21
22 =========================================================================== */
23 --
24 TYPE g_number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
25 --
26 TYPE g_varchar_tbl_type IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
27 --
28 TYPE t_CuatomerNameTbl IS TABLE OF ra_customer_merges.customer_name%TYPE
29 INDEX BY BINARY_INTEGER;
30
31 /*===========================================================================
32
33 PROCEDURE NAME: Merge
34
35 DESCRIPTION: Cover function for Customer Merge API
36
37 PARAMETERS:
38
39 DESIGN REFERENCES: RLMHLMRG.rtf
40 RLMDLMRG.rtf
41
42 ALGORITHM:
43
44 NOTES:
45
46 OPEN ISSUES:
47
48 CLOSED ISSUES:
49
50 CHANGE HISTORY: created rvishnuv 01/31/01
51 ===========================================================================*/
52 PROCEDURE Merge(REQ_ID NUMBER,
53 SET_NUM NUMBER,
54 PROCESS_MODE VARCHAR2);
55 /*============================================================================
56
57 PROCEDURE NAME: Cust_Item_Cum_Keys
58
59 DESCRIPTION: This procedure will update the ship-to,
60 bill-to and intermediate-ship-to data in
61 the Cum Keys table
62
63 PARAMETERS:
64
65 DESIGN REFERENCES: RLMHLMRG.rtf
66 RLMDLMRG.rtf
67
68 ALGORITHM:
69
70 NOTES:
71
72 OPEN ISSUES:
73
74 CLOSED ISSUES:
75
76 CHANGE HISTORY: created rvishnuv 01/31/01
77
78 ============================================================================*/
79 PROCEDURE Cust_Item_Cum_Keys(REQ_ID NUMBER,
80 SET_NUM NUMBER,
81 PROCESS_MODE VARCHAR2);
82 /*============================================================================
83
84 PROCEDURE NAME: Interface_Headers
85
86 DESCRIPTION: This procedure will update the customer_id
87 in the interface headers table
88 PARAMETERS:
89
90 DESIGN REFERENCES: RLMHLMRG.rtf
91 RLMDLMRG.rtf
92
93 ALGORITHM:
94
95 NOTES:
96
97 OPEN ISSUES:
98
99 CLOSED ISSUES:
100
101 CHANGE HISTORY: created rvishnuv 01/31/01
102
103
104 ============================================================================*/
105 PROCEDURE Interface_Headers(REQ_ID NUMBER,
106 SET_NUM NUMBER,
107 PROCESS_MODE VARCHAR2);
108 /*============================================================================
109
110 PROCEDURE NAME: Interface_Lines
111
112 DESCRIPTION: This procedure will update the bill-to-site-id,
113 bill-to-address-id, intermediate-ship-to-id,
114 intermd-st-site-use-id,ship-to-address-id,
115 ship-to-site-use-id in the interface lines table
116 PARAMETERS:
117
118 DESIGN REFERENCES: RLMHLMRG.rtf
119 RLMDLMRG.rtf
120
121 ALGORITHM:
122
123 NOTES:
124
125 OPEN ISSUES:
126
127 CLOSED ISSUES:
128
129 CHANGE HISTORY: created rvishnuv 01/31/01
130
131
132
133 ============================================================================*/
134 PROCEDURE Interface_Lines(REQ_ID NUMBER,
135 SET_NUM NUMBER,
136 PROCESS_MODE VARCHAR2);
137 /*============================================================================
138
139 PROCEDURE NAME: Schedule_Headers
140
141 DESCRIPTION: This procedure will update the customer_id
142 in the schedule headers table
143 PARAMETERS:
144
145 DESIGN REFERENCES: RLMHLMRG.rtf
146 RLMDLMRG.rtf
147
148 ALGORITHM:
149
150 NOTES:
151
152 OPEN ISSUES:
153
154 CLOSED ISSUES:
155
156 CHANGE HISTORY: created rvishnuv 01/31/01
157
158
159 ============================================================================*/
160 PROCEDURE Schedule_Headers(REQ_ID NUMBER,
161 SET_NUM NUMBER,
162 PROCESS_MODE VARCHAR2);
163 /*============================================================================
164
165 PROCEDURE NAME: Schedule_Lines
166
167 DESCRIPTION: This procedure will update the bill-to-site-id,
168 bill-to-address-id, intermediate-ship-to-id,
169 intermd-st-site-use-id,ship-to-address-id,
170 ship-to-site-use-id in the interface lines table
171 PARAMETERS:
172
173 DESIGN REFERENCES: RLMHLMRG.rtf
174 RLMDLMRG.rtf
175
176 ALGORITHM:
177
178 NOTES:
179
180 OPEN ISSUES:
181
182 CLOSED ISSUES:
183
184 CHANGE HISTORY: created rvishnuv 01/31/01
185
186 ============================================================================*/
187 PROCEDURE Schedule_Lines(REQ_ID NUMBER,
188 SET_NUM NUMBER,
189 PROCESS_MODE VARCHAR2);
190 /*============================================================================
191
192 PROCEDURE NAME: Cust_Shipto_Terms
193
194 DESCRIPTION: This procedure will update the address-id,
195 customer-id in the Customer Rules table
196 PARAMETERS:
197
198 DESIGN REFERENCES: RLMHLMRG.rtf
199 RLMDLMRG.rtf
200
201 ALGORITHM:
202
203 NOTES:
204
205 OPEN ISSUES:
206
207 CLOSED ISSUES:
208
209 CHANGE HISTORY: created rvishnuv 01/31/01
210
211 ============================================================================*/
212 PROCEDURE Cust_Shipto_Terms(p_duplicateAddressIdTab g_number_tbl_type,
213 p_customerAddressIdTab g_number_tbl_type,
214 p_duplicateIdTab g_number_tbl_type,
215 p_customerIdTab g_number_tbl_type,
216 REQ_ID NUMBER,
217 SET_NUM NUMBER,
218 PROCESS_MODE VARCHAR2);
219 /*============================================================================
220
221 PROCEDURE NAME: Cust_Item_Terms
222
223 DESCRIPTION: This procedure will update the address-id,
224 customer-id in the Customer Rules table
225
226 PARAMETERS:
227
228 DESIGN REFERENCES: RLMHLMRG.rtf
229 RLMDLMRG.rtf
230
231 ALGORITHM:
232
233 NOTES:
234
235 OPEN ISSUES:
236
237 CLOSED ISSUES:
238
239 CHANGE HISTORY: created rvishnuv 01/31/01
240
241 ============================================================================*/
242 PROCEDURE Cust_Item_Terms(p_duplicateAddressIdTab g_number_tbl_type,
243 p_customerAddressIdTab g_number_tbl_type,
244 p_duplicateIdTab g_number_tbl_type,
245 p_customerIdTab g_number_tbl_type,
246 REQ_ID NUMBER,
247 SET_NUM NUMBER,
248 PROCESS_MODE VARCHAR2);
249 /*============================================================================
250
251 FUNCTION NAME: getTimeStamp
252
253 DESCRIPTION: This function is used to return the
254 current date and time
255
256 PARAMETERS:
257
258 DESIGN REFERENCES: RLMHLMRG.rtf
259 RLMDLMRG.rtf
260
261 ALGORITHM:
262
263 NOTES:
264
265 OPEN ISSUES:
266
267 CLOSED ISSUES:
268
269 CHANGE HISTORY: created rvishnuv 01/31/01
270
271 ============================================================================*/
272 FUNCTION getTimeStamp RETURN VARCHAR2;
273 /*============================================================================
274
275 PROCEDURE NAME: setARMessageUpdateTable
276
277 DESCRIPTION: This procedure is used to set a message
278 on the stack indicating table being updated
279
280 PARAMETERS:
281
282 DESIGN REFERENCES: RLMHLMRG.rtf
283 RLMDLMRG.rtf
284
285 ALGORITHM:
286
287 NOTES:
288
289 OPEN ISSUES:
290
291 CLOSED ISSUES:
292
293 CHANGE HISTORY: created rvishnuv 01/31/01
294
295 ============================================================================*/
296
297 PROCEDURE setARMessageUpdateTable(p_tableName IN VARCHAR2);
298
299 /*============================================================================
300
301 PROCEDURE NAME: setARMessageDeleteTable
302
303 DESCRIPTION: This procedure is used to set a message
304 on the stack indicating table being Deleted
305
306 PARAMETERS:
307
308 DESIGN REFERENCES: RLMHLMRG.rtf
309 RLMDLMRG.rtf
310
311 ALGORITHM:
312
313 NOTES:
314
315 OPEN ISSUES:
316
317 CLOSED ISSUES:
318
319 CHANGE HISTORY: created rvishnuv 01/31/01
320
321 ============================================================================*/
322
323 PROCEDURE setARMessageDeleteTable(p_tableName IN VARCHAR2);
324 /*============================================================================
325
326 PROCEDURE NAME: setARMessageLockTable
327
328 DESCRIPTION: This procedure is used to set a message
329 on the stack indicating table record being locked
330
331 PARAMETERS:
332
333 DESIGN REFERENCES: RLMHLMRG.rtf
334 RLMDLMRG.rtf
335
336 ALGORITHM:
337
338 NOTES:
339
340 OPEN ISSUES:
341
342 CLOSED ISSUES:
343
344 CHANGE HISTORY: created rvishnuv 01/31/01
345
346 ============================================================================*/
347
348 PROCEDURE setARMessageLockTable(p_tableName IN VARCHAR2);
349
350 /*============================================================================
351
352 PROCEDURE NAME: setARMessageRowCount
353
354 DESCRIPTION: This procedure is used to set a message
355 on the stack indicating number of rows
356 updated in the table
357
358 PARAMETERS:
359
360 DESIGN REFERENCES: RLMHLMRG.rtf
361 RLMDLMRG.rtf
362
363 ALGORITHM:
364
365 NOTES:
366
367 OPEN ISSUES:
368
369 CLOSED ISSUES:
370
371 CHANGE HISTORY: created rvishnuv 01/31/01
372
373 ============================================================================*/
374
375 PROCEDURE setARMessageRowCount(p_rowCount IN NUMBER);
376
377 /*============================================================================
378
379 FUNCTION NAME: getMessage
380
381 DESCRIPTION: This function is used to return the
382 current date and time
383
384 PARAMETERS:
385
386 DESIGN REFERENCES: RLMHLMRG.rtf
387 RLMDLMRG.rtf
388
389 ALGORITHM:
390
391 NOTES:
392
393 OPEN ISSUES:
394
395 CLOSED ISSUES:
396
397 CHANGE HISTORY: created rvishnuv 01/31/01
398
399 ============================================================================*/
400 FUNCTION getMessage(p_messageName IN VARCHAR2,
401 p_token1 IN VARCHAR2 DEFAULT NULL,
402 p_value1 IN VARCHAR2 DEFAULT NULL,
403 p_token2 IN VARCHAR2 DEFAULT NULL,
404 p_value2 IN VARCHAR2 DEFAULT NULL,
405 p_token3 IN VARCHAR2 DEFAULT NULL,
406 p_value3 IN VARCHAR2 DEFAULT NULL
407 )
408 RETURN VARCHAR2;
409 /*===========================================================================
410
411 FUNCTION NAME: IS_RLM_INSTALLED
412
413 DESCRIPTION: Checks whether RLM is installed
414
415 PARAMETERS:
416
417 DESIGN REFERENCES: RLMHLMRG.rtf
418 RLMDLMRG.rtf
419
420 ALGORITHM:
421
422 NOTES:
423
424 OPEN ISSUES:
425
426 CLOSED ISSUES:
427
428 CHANGE HISTORY: created rvishnuv 01/31/01
429 ===========================================================================*/
430 FUNCTION IS_RLM_INSTALLED
431 RETURN BOOLEAN;
432
433 /*2447493*/
434
435 PROCEDURE RLM_CUST_ITEM_CUM_KEYS_LOG (
436 req_id NUMBER,
437 set_num NUMBER,
438 process_mode VARCHAR2);
439
440 PROCEDURE RLM_INTERFACE_HEADERS_LOG (
441 req_id NUMBER,
442 set_num NUMBER,
443 process_mode VARCHAR2);
444
445 PROCEDURE RLM_INTERFACE_LINES_LOG (
446 req_id NUMBER,
447 set_num NUMBER,
448 process_mode VARCHAR2);
449
450 PROCEDURE RLM_SCHEDULE_HEADERS_LOG (
451 req_id NUMBER,
452 set_num NUMBER,
453 process_mode VARCHAR2);
454
455 PROCEDURE RLM_SCHEDULE_LINES_LOG (
456 req_id NUMBER,
457 set_num NUMBER,
458 process_mode VARCHAR2);
459
460 /*2447493*/
461
462 END RLM_CUST_MERGE;