APPS.INVP_CMERGE_SPDM dependencies on MTL_DEMAND

Line 9: /*--------------------------- MTL_DEMAND ------------------------------------*/

5: g_count NUMBER := 0;
6:
7: /*--------------------------- PRIVATE ROUTINES ------------------------------*/
8:
9: /*--------------------------- MTL_DEMAND ------------------------------------*/
10:
11: procedure INV_MD (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
12:
13: --Split the cursor C1 into three cursors C1, C1 and C3 for BUG # 1084777

Line 17: FROM MTL_DEMAND

13: --Split the cursor C1 into three cursors C1, C1 and C3 for BUG # 1084777
14:
15: CURSOR C1 IS
16: SELECT NULL
17: FROM MTL_DEMAND
18: WHERE bill_to_site_use_id in (select racm.duplicate_site_id
19: from ra_customer_merges racm
20: where racm.process_flag = 'N'
21: and racm.request_id = req_id

Line 27: FROM MTL_DEMAND

23: FOR UPDATE NOWAIT;
24:
25: CURSOR C2 IS
26: SELECT NULL
27: FROM MTL_DEMAND
28: WHERE ship_to_site_use_id in (select racm.duplicate_site_id
29: from ra_customer_merges racm
30: where racm.process_flag = 'N'
31: and racm.request_id = req_id

Line 37: FROM MTL_DEMAND

33: FOR UPDATE NOWAIT;
34:
35: CURSOR C3 IS
36: SELECT NULL
37: FROM MTL_DEMAND
38: WHERE customer_id in (select racm.duplicate_id
39: from ra_customer_merges racm
40: where racm.process_flag = 'N'
41: and racm.request_id = req_id

Line 52: | MTL_DEMAND |

48: BEGIN
49: arp_message.set_line( 'INVP_CMERGE_SPDM.INV_MD()+' );
50:
51: /*------------+
52: | MTL_DEMAND |
53: +------------*/
54: /* try to lock the table first */
55: IF (process_mode = 'LOCK') then
56: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

Line 57: arp_message.set_token( 'TABLE_NAME', 'MTL_DEMAND', FALSE );

53: +------------*/
54: /* try to lock the table first */
55: IF (process_mode = 'LOCK') then
56: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
57: arp_message.set_token( 'TABLE_NAME', 'MTL_DEMAND', FALSE );
58:
59: OPEN C1;
60: CLOSE C1;
61:

Line 73: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND',FALSE);

69:
70: /* customer and site level */
71:
72: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
73: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND',FALSE);
74: arp_message.set_line('site level update : ship to and bill to site use id');
75:
76: UPDATE MTL_DEMAND yt
77: set customer_id = (select distinct racm.customer_id

Line 76: UPDATE MTL_DEMAND yt

72: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
73: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND',FALSE);
74: arp_message.set_line('site level update : ship to and bill to site use id');
75:
76: UPDATE MTL_DEMAND yt
77: set customer_id = (select distinct racm.customer_id
78: from ra_customer_merges racm
79: where yt.customer_id = racm.duplicate_id
80: and (yt.ship_to_site_use_id = racm.duplicate_site_id

Line 127: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND',FALSE);

123:
124: /* site level update */
125: /* for bill to site use id */
126: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
127: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND',FALSE);
128: arp_message.set_line('site level update : bill to site use id');
129:
130: UPDATE MTL_DEMAND yt
131: set (customer_id,

Line 130: UPDATE MTL_DEMAND yt

126: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
127: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND',FALSE);
128: arp_message.set_line('site level update : bill to site use id');
129:
130: UPDATE MTL_DEMAND yt
131: set (customer_id,
132: bill_to_site_use_id) = (select distinct racm.customer_id,
133: racm.customer_site_id
134: from ra_customer_merges racm

Line 170: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND',FALSE);

166: /* site level update */
167: /* for ship to site use id */
168:
169: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
170: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND',FALSE);
171: arp_message.set_line('site level update : ship to site use id');
172:
173: UPDATE MTL_DEMAND yt
174: set (customer_id,

Line 173: UPDATE MTL_DEMAND yt

169: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
170: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND',FALSE);
171: arp_message.set_line('site level update : ship to site use id');
172:
173: UPDATE MTL_DEMAND yt
174: set (customer_id,
175: ship_to_site_use_id) = (select distinct racm.customer_id,
176: racm.customer_site_id
177: from ra_customer_merges racm

Line 211: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND', FALSE);

207:
208: /* customer level update */
209:
210: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
211: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND', FALSE);
212: arp_message.set_line('customer level : customer_id');
213:
214: UPDATE MTL_DEMAND yt
215: set customer_id = (select distinct racm.customer_id

Line 214: UPDATE MTL_DEMAND yt

210: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
211: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND', FALSE);
212: arp_message.set_line('customer level : customer_id');
213:
214: UPDATE MTL_DEMAND yt
215: set customer_id = (select distinct racm.customer_id
216: from ra_customer_merges racm
217: where yt.customer_id =
218: racm.duplicate_id