APPS.OEP_CMERGE_OESET dependencies on SO_AGREEMENTS

Line 14: from so_agreements

10: PROCEDURE oe_ag (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
11:
12: CURSOR c1 is
13: select agreement_id
14: from so_agreements
15: where invoice_to_site_use_id in (select m.duplicate_site_id
16: from ra_customer_merges m
17: where m.process_flag = 'N'
18: and m.request_id = req_id

Line 24: from so_agreements

20: for update nowait;
21:
22: CURSOR c2 is
23: select agreement_id
24: from so_agreements
25: where customer_id in (select m.duplicate_id
26: from ra_customer_merges m
27: where m.process_flag = 'N'
28: and m.request_id = req_id

Line 37: | SO_AGREEMENTS |

33:
34: arp_message.set_line( 'OEP_CMERGE_OESET.OE_AG()+' );
35:
36: /*-----------------------------+
37: | SO_AGREEMENTS |
38: +-----------------------------*/
39: /* both customer and site level */
40:
41: IF( process_mode = 'LOCK' ) THEN

Line 44: arp_message.set_token( 'TABLE_NAME', 'SO_AGREEMENTS', FALSE );

40:
41: IF( process_mode = 'LOCK' ) THEN
42:
43: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
44: arp_message.set_token( 'TABLE_NAME', 'SO_AGREEMENTS', FALSE );
45:
46: open c1;
47: close c1;
48:

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

53:
54:
55: /* site level update */
56: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
57: arp_message.set_token( 'TABLE_NAME', 'SO_AGREEMENTS', FALSE );
58:
59: UPDATE SO_AGREEMENTS a
60: set (invoice_to_site_use_id) = (select distinct m.customer_site_id
61: from ra_customer_merges m

Line 59: UPDATE SO_AGREEMENTS a

55: /* site level update */
56: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
57: arp_message.set_token( 'TABLE_NAME', 'SO_AGREEMENTS', FALSE );
58:
59: UPDATE SO_AGREEMENTS a
60: set (invoice_to_site_use_id) = (select distinct m.customer_site_id
61: from ra_customer_merges m
62: where a.invoice_to_site_use_id =
63: m.duplicate_site_id

Line 83: arp_message.set_token( 'TABLE_NAME', 'SO_AGREEMENTS', FALSE );

79: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
80:
81: /* customer level update */
82: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
83: arp_message.set_token( 'TABLE_NAME', 'SO_AGREEMENTS', FALSE );
84:
85: UPDATE SO_AGREEMENTS a
86: set customer_id = (select distinct m.customer_id
87: from ra_customer_merges m

Line 85: UPDATE SO_AGREEMENTS a

81: /* customer level update */
82: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
83: arp_message.set_token( 'TABLE_NAME', 'SO_AGREEMENTS', FALSE );
84:
85: UPDATE SO_AGREEMENTS a
86: set customer_id = (select distinct m.customer_id
87: from ra_customer_merges m
88: where a.customer_id =
89: m.duplicate_id