DBA Data[Home] [Help]

APPS.OE_CUST_MERGE_DATA_FIX dependencies on OE_ORDER_HEADERS_ALL

Line 20: from oe_order_headers_all

16: Process_Mode IN VARCHAR2)
17: IS
18: CURSOR c1 is
19: select HEADER_ID
20: from oe_order_headers_all
21: where ship_to_org_id in
22: (select m.duplicate_site_id
23: from ra_customer_merges m
24: where m.process_flag = 'Y'

Line 32: from oe_order_headers_all

28:
29:
30: CURSOR c2 is
31: select HEADER_ID
32: from oe_order_headers_all
33: where invoice_to_org_id in
34: (select m.duplicate_site_id
35: from ra_customer_merges m
36: where m.process_flag = 'Y'

Line 44: from oe_order_headers_all

40:
41:
42: CURSOR c3 is
43: select HEADER_ID
44: from oe_order_headers_all
45: where deliver_to_org_id in
46: (select m.duplicate_site_id
47: from ra_customer_merges m
48: where m.process_flag = 'Y'

Line 55: from oe_order_headers_all

51: for update nowait;
52:
53: CURSOR c4 is
54: select HEADER_ID
55: from oe_order_headers_all
56: where sold_to_org_id in
57: (select m.duplicate_id
58: from ra_customer_merges m
59: where m.process_flag = 'Y'

Line 81: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_headers_all', FALSE );

77:
78: IF( process_mode = 'LOCK' ) THEN
79:
80: -- arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
81: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_headers_all', FALSE );
82: IF l_debug_level > 0 THEN
83: oe_debug_pub.add( 'LOCKING TABLE OE_ORDER_HEADERS_ALL' ) ;
84: END IF;
85:

Line 83: oe_debug_pub.add( 'LOCKING TABLE OE_ORDER_HEADERS_ALL' ) ;

79:
80: -- arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
81: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_headers_all', FALSE );
82: IF l_debug_level > 0 THEN
83: oe_debug_pub.add( 'LOCKING TABLE OE_ORDER_HEADERS_ALL' ) ;
84: END IF;
85:
86: open c1;
87: close c1;

Line 106: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_headers_all', FALSE );

102: IF l_debug_level > 0 THEN
103: oe_debug_pub.add( 'SITE LEVEL UPDATE' ) ;
104: END IF;
105: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
106: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_headers_all', FALSE );
107: IF l_debug_level > 0 THEN
108: oe_debug_pub.add( 'UPDATING OE_ORDER_HEADERS_ALL.SHIP_TO_ORG_ID' ) ;
109: END IF;
110:

Line 108: oe_debug_pub.add( 'UPDATING OE_ORDER_HEADERS_ALL.SHIP_TO_ORG_ID' ) ;

104: END IF;
105: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
106: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_headers_all', FALSE );
107: IF l_debug_level > 0 THEN
108: oe_debug_pub.add( 'UPDATING OE_ORDER_HEADERS_ALL.SHIP_TO_ORG_ID' ) ;
109: END IF;
110:
111: UPDATE oe_order_headers_all a
112: set ship_to_org_id = (select distinct m.customer_site_id

Line 111: UPDATE oe_order_headers_all a

107: IF l_debug_level > 0 THEN
108: oe_debug_pub.add( 'UPDATING OE_ORDER_HEADERS_ALL.SHIP_TO_ORG_ID' ) ;
109: END IF;
110:
111: UPDATE oe_order_headers_all a
112: set ship_to_org_id = (select distinct m.customer_site_id
113: from ra_customer_merges m
114: where a.ship_to_org_id = m.duplicate_site_id
115: and m.request_id = req_id

Line 138: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_headers_all', FALSE );

134: oe_debug_pub.add( G_COUNT || ' ROWS UPDATED' ) ;
135: END IF;
136:
137: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
138: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_headers_all', FALSE );
139:
140: IF l_debug_level > 0 THEN
141: oe_debug_pub.add( 'UPDATING OE_ORDER_HEADERS_ALL.INVOICE_TO_ORG_ID' ) ;
142: END IF;

Line 141: oe_debug_pub.add( 'UPDATING OE_ORDER_HEADERS_ALL.INVOICE_TO_ORG_ID' ) ;

137: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
138: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_headers_all', FALSE );
139:
140: IF l_debug_level > 0 THEN
141: oe_debug_pub.add( 'UPDATING OE_ORDER_HEADERS_ALL.INVOICE_TO_ORG_ID' ) ;
142: END IF;
143:
144: UPDATE oe_order_headers_all a
145: set invoice_to_org_id = (select distinct m.customer_site_id

Line 144: UPDATE oe_order_headers_all a

140: IF l_debug_level > 0 THEN
141: oe_debug_pub.add( 'UPDATING OE_ORDER_HEADERS_ALL.INVOICE_TO_ORG_ID' ) ;
142: END IF;
143:
144: UPDATE oe_order_headers_all a
145: set invoice_to_org_id = (select distinct m.customer_site_id
146: from ra_customer_merges m
147: where a.invoice_to_org_id = m.duplicate_site_id
148: and m.request_id = req_id

Line 171: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_headers_all', FALSE );

167: oe_debug_pub.add( G_COUNT || ' ROWS UPDATED' ) ;
168: END IF;
169:
170: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
171: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_headers_all', FALSE );
172:
173: IF l_debug_level > 0 THEN
174: oe_debug_pub.add( 'UPDATING OE_ORDER_HEADERS_ALL.DELIVER_TO_ORG_ID' ) ;
175: END IF;

Line 174: oe_debug_pub.add( 'UPDATING OE_ORDER_HEADERS_ALL.DELIVER_TO_ORG_ID' ) ;

170: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
171: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_headers_all', FALSE );
172:
173: IF l_debug_level > 0 THEN
174: oe_debug_pub.add( 'UPDATING OE_ORDER_HEADERS_ALL.DELIVER_TO_ORG_ID' ) ;
175: END IF;
176:
177: UPDATE oe_order_headers_all a
178: set deliver_to_org_id = (select distinct m.customer_site_id

Line 177: UPDATE oe_order_headers_all a

173: IF l_debug_level > 0 THEN
174: oe_debug_pub.add( 'UPDATING OE_ORDER_HEADERS_ALL.DELIVER_TO_ORG_ID' ) ;
175: END IF;
176:
177: UPDATE oe_order_headers_all a
178: set deliver_to_org_id = (select distinct m.customer_site_id
179: from ra_customer_merges m
180: where a.deliver_to_org_id = m.duplicate_site_id
181: and m.request_id = req_id

Line 203: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_headers_all', FALSE );

199: IF l_debug_level > 0 THEN
200: oe_debug_pub.add( G_COUNT || ' ROWS UPDATED' ) ;
201: END IF;
202: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
203: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_headers_all', FALSE );
204:
205:
206: /* customer level update */
207: IF l_debug_level > 0 THEN

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

207: IF l_debug_level > 0 THEN
208: oe_debug_pub.add( 'CUSTOMER LEVEL UPDATE' ) ;
209: END IF;
210: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
211: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_headers_all', FALSE );
212: IF l_debug_level > 0 THEN
213: oe_debug_pub.add( 'UPDATING OE_ORDER_HEADERS_ALL.SOLD_TO_ORG_ID' ) ;
214: END IF;
215:

Line 213: oe_debug_pub.add( 'UPDATING OE_ORDER_HEADERS_ALL.SOLD_TO_ORG_ID' ) ;

209: END IF;
210: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
211: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_headers_all', FALSE );
212: IF l_debug_level > 0 THEN
213: oe_debug_pub.add( 'UPDATING OE_ORDER_HEADERS_ALL.SOLD_TO_ORG_ID' ) ;
214: END IF;
215:
216: UPDATE oe_order_headers_all a
217: set sold_to_org_id = (select distinct m.customer_id

Line 216: UPDATE oe_order_headers_all a

212: IF l_debug_level > 0 THEN
213: oe_debug_pub.add( 'UPDATING OE_ORDER_HEADERS_ALL.SOLD_TO_ORG_ID' ) ;
214: END IF;
215:
216: UPDATE oe_order_headers_all a
217: set sold_to_org_id = (select distinct m.customer_id
218: from ra_customer_merges m
219: where a.sold_to_org_id = m.duplicate_id
220: and m.process_flag = 'Y'