APPS.OEP_CMERGE_OEORD dependencies on SO_ORDER_APPROVALS

Line 322: from so_order_approvals

318: PROCEDURE oe_oa (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
319:
320: CURSOR c1 is
321: select order_approval_id
322: from so_order_approvals
323: where customer_id in (select m.duplicate_id
324: from ra_customer_merges m
325: where m.process_flag = 'N'
326: and m.request_id = req_id

Line 335: | SO_ORDER_APPROVALS |

331:
332: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_OA()+' );
333:
334: /*-----------------------------+
335: | SO_ORDER_APPROVALS |
336: +-----------------------------*/
337: /* both customer and site level */
338:
339: IF( process_mode = 'LOCK' ) THEN

Line 342: arp_message.set_token( 'TABLE_NAME', 'SO_ORDER_APPROVALS', FALSE );

338:
339: IF( process_mode = 'LOCK' ) THEN
340:
341: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
342: arp_message.set_token( 'TABLE_NAME', 'SO_ORDER_APPROVALS', FALSE );
343:
344: open c1;
345: close c1;
346:

Line 351: arp_message.set_token( 'TABLE_NAME', 'SO_ORDER_APPROVALS', FALSE );

347: ELSE
348:
349: /* customer level update */
350: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
351: arp_message.set_token( 'TABLE_NAME', 'SO_ORDER_APPROVALS', FALSE );
352:
353: UPDATE SO_ORDER_APPROVALS a
354: set customer_id = (select distinct m.customer_id
355: from ra_customer_merges m

Line 353: UPDATE SO_ORDER_APPROVALS a

349: /* customer level update */
350: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
351: arp_message.set_token( 'TABLE_NAME', 'SO_ORDER_APPROVALS', FALSE );
352:
353: UPDATE SO_ORDER_APPROVALS a
354: set customer_id = (select distinct m.customer_id
355: from ra_customer_merges m
356: where a.customer_id =
357: m.duplicate_id