APPS.OEP_CMERGE_OEPIC dependencies on SO_PICKING_HEADERS

Line 236: from so_picking_headers

232: PROCEDURE oe_ph (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
233:
234: CURSOR c1 is
235: select picking_header_id
236: from so_picking_headers
237: where ship_to_site_use_id in (select m.duplicate_site_id
238: from ra_customer_merges m
239: where m.process_flag = 'N'
240: and m.request_id = req_id

Line 249: | SO_PICKING_HEADERS |

245:
246: arp_message.set_line( 'OEP_CMERGE_OEPIC.OE_PH()+' );
247:
248: /*-----------------------------+
249: | SO_PICKING_HEADERS |
250: +-----------------------------*/
251: /* both customer and site level */
252:
253: IF( process_mode = 'LOCK' ) THEN

Line 256: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_HEADERS', FALSE );

252:
253: IF( process_mode = 'LOCK' ) THEN
254:
255: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
256: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_HEADERS', FALSE );
257:
258: open c1;
259: close c1;
260:

Line 266: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_HEADERS', FALSE );

262:
263:
264: /* site level update */
265: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
266: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_HEADERS', FALSE );
267:
268: UPDATE SO_PICKING_HEADERS a
269: set (ship_to_site_use_id) = (select distinct m.customer_site_id
270: from ra_customer_merges m

Line 268: UPDATE SO_PICKING_HEADERS a

264: /* site level update */
265: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
266: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_HEADERS', FALSE );
267:
268: UPDATE SO_PICKING_HEADERS a
269: set (ship_to_site_use_id) = (select distinct m.customer_site_id
270: from ra_customer_merges m
271: where a.ship_to_site_use_id =
272: m.duplicate_site_id