APPS.OEP_CMERGE_OEORD dependencies on SO_LINE_SERVICE_DETAILS

Line 251: from so_line_service_details

247: PROCEDURE oe_sd (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
248:
249: CURSOR c1 is
250: select line_service_detail_id
251: from so_line_service_details
252: where installation_site_use_id in (select m.duplicate_site_id
253: from ra_customer_merges m
254: where m.process_flag = 'N'
255: and m.request_id = req_id

Line 264: | SO_LINE_SERVICE_DETAILS |

260:
261: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_SD()+' );
262:
263: /*-----------------------------+
264: | SO_LINE_SERVICE_DETAILS |
265: +-----------------------------*/
266: /* both customer and site level */
267:
268: IF( process_mode = 'LOCK' ) THEN

Line 271: arp_message.set_token( 'TABLE_NAME', 'SO_LINE_SERVICE_DETAILS', FALSE );

267:
268: IF( process_mode = 'LOCK' ) THEN
269:
270: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
271: arp_message.set_token( 'TABLE_NAME', 'SO_LINE_SERVICE_DETAILS', FALSE );
272:
273: open c1;
274: close c1;
275:

Line 281: arp_message.set_token( 'TABLE_NAME', 'SO_LINE_SERVICE_DETAILS', FALSE );

277:
278:
279: /* site level update */
280: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
281: arp_message.set_token( 'TABLE_NAME', 'SO_LINE_SERVICE_DETAILS', FALSE );
282:
283: UPDATE SO_LINE_SERVICE_DETAILS a
284: set (installation_site_use_id) = (select distinct m.customer_site_id
285: from ra_customer_merges m

Line 283: UPDATE SO_LINE_SERVICE_DETAILS a

279: /* site level update */
280: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
281: arp_message.set_token( 'TABLE_NAME', 'SO_LINE_SERVICE_DETAILS', FALSE );
282:
283: UPDATE SO_LINE_SERVICE_DETAILS a
284: set (installation_site_use_id) = (select distinct m.customer_site_id
285: from ra_customer_merges m
286: where a.installation_site_use_id =
287: m.duplicate_site_id