APPS.OEP_CMERGE_OEORD dependencies on SO_HEADERS

Line 16: from so_headers

12: PROCEDURE oe_sh (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
13:
14: CURSOR c1 is
15: select header_id
16: from so_headers
17: where ship_to_site_use_id in (select m.duplicate_site_id
18: from ra_customer_merges m
19: where m.process_flag = 'N'
20: and m.request_id = req_id

Line 26: from so_headers

22: for update nowait;
23:
24: CURSOR c2 is
25: select header_id
26: from so_headers
27: where invoice_to_site_use_id in (select m.duplicate_site_id
28: from ra_customer_merges m
29: where m.process_flag = 'N'
30: and m.request_id = req_id

Line 36: from so_headers

32: for update nowait;
33:
34: CURSOR c3 is
35: select header_id
36: from so_headers
37: where customer_id in (select m.duplicate_id
38: from ra_customer_merges m
39: where m.process_flag = 'N'
40: and m.request_id = req_id

Line 49: | SO_HEADERS |

45:
46: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_SH()+' );
47:
48: /*-----------------------------+
49: | SO_HEADERS |
50: +-----------------------------*/
51: /* both customer and site level */
52:
53: IF( process_mode = 'LOCK' ) THEN

Line 56: arp_message.set_token( 'TABLE_NAME', 'SO_HEADERS', FALSE );

52:
53: IF( process_mode = 'LOCK' ) THEN
54:
55: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
56: arp_message.set_token( 'TABLE_NAME', 'SO_HEADERS', FALSE );
57:
58: open c1;
59: close c1;
60:

Line 72: arp_message.set_token( 'TABLE_NAME', 'SO_HEADERS', FALSE );

68:
69:
70: /* site level update */
71: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
72: arp_message.set_token( 'TABLE_NAME', 'SO_HEADERS', FALSE );
73:
74: UPDATE SO_HEADERS a
75: set (ship_to_site_use_id) = (select distinct m.customer_site_id
76: from ra_customer_merges m

Line 74: UPDATE SO_HEADERS a

70: /* site level update */
71: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
72: arp_message.set_token( 'TABLE_NAME', 'SO_HEADERS', FALSE );
73:
74: UPDATE SO_HEADERS a
75: set (ship_to_site_use_id) = (select distinct m.customer_site_id
76: from ra_customer_merges m
77: where a.ship_to_site_use_id =
78: m.duplicate_site_id

Line 101: arp_message.set_token( 'TABLE_NAME', 'SO_HEADERS', FALSE );

97: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
98: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
99:
100: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
101: arp_message.set_token( 'TABLE_NAME', 'SO_HEADERS', FALSE );
102:
103: UPDATE SO_HEADERS a
104: set (invoice_to_site_use_id) = (select distinct m.customer_site_id
105: from ra_customer_merges m

Line 103: UPDATE SO_HEADERS a

99:
100: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
101: arp_message.set_token( 'TABLE_NAME', 'SO_HEADERS', FALSE );
102:
103: UPDATE SO_HEADERS a
104: set (invoice_to_site_use_id) = (select distinct m.customer_site_id
105: from ra_customer_merges m
106: where a.invoice_to_site_use_id =
107: m.duplicate_site_id

Line 131: arp_message.set_token( 'TABLE_NAME', 'SO_HEADERS', FALSE );

127: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
128:
129: /* customer level update */
130: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
131: arp_message.set_token( 'TABLE_NAME', 'SO_HEADERS', FALSE );
132:
133: UPDATE SO_HEADERS a
134: set customer_id = (select distinct m.customer_id
135: from ra_customer_merges m

Line 133: UPDATE SO_HEADERS a

129: /* customer level update */
130: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
131: arp_message.set_token( 'TABLE_NAME', 'SO_HEADERS', FALSE );
132:
133: UPDATE SO_HEADERS a
134: set customer_id = (select distinct m.customer_id
135: from ra_customer_merges m
136: where a.customer_id =
137: m.duplicate_id