45: FOR UPDATE NOWAIT;
46:
47:
48: BEGIN
49: arp_message.set_line( 'INVP_CMERGE_SPDM.INV_MD()+' );
50:
51: /*------------+
52: | MTL_DEMAND |
53: +------------*/
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');
57: arp_message.set_token( 'TABLE_NAME', 'MTL_DEMAND', FALSE );
58:
59: OPEN C1;
60: CLOSE C1;
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:
68: ELSE
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
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
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
78: from ra_customer_merges racm
116:
117: g_count := sql%rowcount;
118:
119: /* Number of rows updates */
120: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
121: arp_message.set_token('NUM_ROWS', to_char(g_count));
122:
123:
124: /* site level update */
117: g_count := sql%rowcount;
118:
119: /* Number of rows updates */
120: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
121: arp_message.set_token('NUM_ROWS', to_char(g_count));
122:
123:
124: /* site level update */
125: /* for bill to site use id */
122:
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
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,
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,
132: bill_to_site_use_id) = (select distinct racm.customer_id,
158:
159: g_count := sql%rowcount;
160:
161: /* Number of rows updates */
162: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
163: arp_message.set_token('NUM_ROWS', to_char(g_count));
164:
165:
166: /* site level update */
159: g_count := sql%rowcount;
160:
161: /* Number of rows updates */
162: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
163: arp_message.set_token('NUM_ROWS', to_char(g_count));
164:
165:
166: /* site level update */
167: /* for ship to site use id */
165:
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
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,
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,
175: ship_to_site_use_id) = (select distinct racm.customer_id,
201:
202: g_count := sql%rowcount;
203:
204: /* Number of rows updates */
205: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
206: arp_message.set_token('NUM_ROWS', to_char(g_count));
207:
208: /* customer level update */
209:
202: g_count := sql%rowcount;
203:
204: /* Number of rows updates */
205: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
206: arp_message.set_token('NUM_ROWS', to_char(g_count));
207:
208: /* customer level update */
209:
210: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
206: arp_message.set_token('NUM_ROWS', to_char(g_count));
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
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
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
216: from ra_customer_merges racm
236:
237: g_count := sql%rowcount;
238:
239: /* Number of rows updates */
240: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
241: arp_message.set_token('NUM_ROWS', to_char(g_count));
242:
243: END IF;
244:
237: g_count := sql%rowcount;
238:
239: /* Number of rows updates */
240: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
241: arp_message.set_token('NUM_ROWS', to_char(g_count));
242:
243: END IF;
244:
245: arp_message.set_line( 'INVP_CMERGE_SPDM.INV_MD()-' );
241: arp_message.set_token('NUM_ROWS', to_char(g_count));
242:
243: END IF;
244:
245: arp_message.set_line( 'INVP_CMERGE_SPDM.INV_MD()-' );
246:
247:
248: EXCEPTION
249: when others then
246:
247:
248: EXCEPTION
249: when others then
250: arp_message.set_error( 'INVP_CMERGE_SPDM.INV_MD');
251: raise;
252:
253: END;
254:
257:
258: PROCEDURE MERGE (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
259: BEGIN
260:
261: arp_message.set_line( 'INVP_CMERGE_SPDM.MERGE()+' );
262:
263: INV_MD( req_id, set_num, process_mode );
264:
265: arp_message.set_line( 'INVP_CMERGE_SPDM.MERGE()-' );
261: arp_message.set_line( 'INVP_CMERGE_SPDM.MERGE()+' );
262:
263: INV_MD( req_id, set_num, process_mode );
264:
265: arp_message.set_line( 'INVP_CMERGE_SPDM.MERGE()-' );
266:
267: END MERGE;
268: end INVP_CMERGE_SPDM;