APPS.OEP_CMERGE_OEORD dependencies on SO_STANDARD_VALUE_RULES

Line 392: from so_standard_value_rules

388: PROCEDURE oe_vr (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
389:
390: CURSOR c1 is
391: select standard_value_rule_id
392: from so_standard_value_rules
393: where attribute_value in (select to_char(m.duplicate_site_id)
394: from ra_customer_merges m
395: where m.process_flag = 'N'
396: and m.request_id = req_id

Line 404: from so_standard_value_rules

400: for update nowait;
401:
402: CURSOR c2 is
403: select standard_value_rule_id
404: from so_standard_value_rules
405: where attribute_value in (select to_char(m.duplicate_site_id)
406: from ra_customer_merges m
407: where m.process_flag = 'N'
408: and m.request_id = req_id

Line 422: | SO_STANDARD_VALUE_RULES |

418:
419:
420:
421: /*-----------------------------+
422: | SO_STANDARD_VALUE_RULES |
423: +-----------------------------*/
424: /* both customer and site level */
425:
426: IF( process_mode = 'LOCK' ) THEN

Line 429: arp_message.set_token( 'TABLE_NAME', 'SO_STANDARD_VALUE_RULES', FALSE );

425:
426: IF( process_mode = 'LOCK' ) THEN
427:
428: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
429: arp_message.set_token( 'TABLE_NAME', 'SO_STANDARD_VALUE_RULES', FALSE );
430:
431: open c1;
432: close c1;
433:

Line 443: arp_message.set_token( 'TABLE_NAME', 'SO_STANDARD_VALUE_RULES', FALSE );

439:
440:
441: /* site level update */
442: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
443: arp_message.set_token( 'TABLE_NAME', 'SO_STANDARD_VALUE_RULES', FALSE );
444:
445:
446:
447: UPDATE SO_STANDARD_VALUE_RULES a

Line 447: UPDATE SO_STANDARD_VALUE_RULES a

443: arp_message.set_token( 'TABLE_NAME', 'SO_STANDARD_VALUE_RULES', FALSE );
444:
445:
446:
447: UPDATE SO_STANDARD_VALUE_RULES a
448: set attribute_value = (select distinct to_char(m.customer_site_id)
449: from ra_customer_merges m
450: where a.attribute_value =
451: to_char(m.duplicate_site_id)

Line 474: arp_message.set_token( 'TABLE_NAME', 'SO_STANDARD_VALUE_RULES', FALSE );

470:
471:
472: /* site level update */
473: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
474: arp_message.set_token( 'TABLE_NAME', 'SO_STANDARD_VALUE_RULES', FALSE );
475:
476:
477:
478: UPDATE SO_STANDARD_VALUE_RULES a

Line 478: UPDATE SO_STANDARD_VALUE_RULES a

474: arp_message.set_token( 'TABLE_NAME', 'SO_STANDARD_VALUE_RULES', FALSE );
475:
476:
477:
478: UPDATE SO_STANDARD_VALUE_RULES a
479: set attribute_value = (select distinct to_char(m.customer_site_id)
480: from ra_customer_merges m
481: where a.attribute_value =
482: to_char(m.duplicate_site_id)