APPS.OE_CUST_MERGE dependencies on OE_HOLD_SOURCES

Line 4984: from oe_hold_sources

4980: )
4981: IS
4982: CURSOR c1 is
4983: select hold_source_id
4984: from oe_hold_sources
4985: where hold_entity_id in (select m.duplicate_site_id
4986: from ra_customer_merges m
4987: where m.process_flag = 'N'
4988: and m.request_id = req_id

Line 4995: from oe_hold_sources

4991: for update nowait;
4992:
4993: CURSOR c2 is
4994: select hold_source_id
4995: from oe_hold_sources
4996: where hold_entity_id in (select m.duplicate_site_id
4997: from ra_customer_merges m
4998: where m.process_flag = 'N'
4999: and m.request_id = req_id

Line 5007: from oe_hold_sources

5003:
5004:
5005: CURSOR c3 is
5006: select hold_source_id
5007: from oe_hold_sources
5008: where hold_entity_id in (select m.duplicate_id
5009: from ra_customer_merges m
5010: where m.process_flag = 'N'
5011: and m.request_id = req_id

Line 5022: | OE_HOLD_SOURCES |

5018: BEGIN
5019:
5020: arp_message.set_line( 'OE_CUST_MERGE.OE_Hold_Merge()+' );
5021: /*-----------------------------+
5022: | OE_HOLD_SOURCES |
5023: +-----------------------------*/
5024: /* both customer and site level */
5025:
5026: IF( process_mode = 'LOCK' ) THEN

Line 5029: arp_message.set_token( 'TABLE_NAME', 'OE_HOLD_SOURCES', FALSE );

5025:
5026: IF( process_mode = 'LOCK' ) THEN
5027:
5028: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
5029: arp_message.set_token( 'TABLE_NAME', 'OE_HOLD_SOURCES', FALSE );
5030:
5031: open c1;
5032: close c1;
5033:

Line 5063: 'OE_HOLD_SOURCES',

5059: LAST_UPDATED_BY
5060: )
5061: select
5062: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5063: 'OE_HOLD_SOURCES',
5064: m.customer_merge_header_id,
5065: a.hold_source_id,
5066: to_char(a.hold_entity_id),
5067: to_char(m.customer_site_id),

Line 5075: from OE_HOLD_SOURCES a,

5071: hz_utility_pub.CREATION_DATE,
5072: hz_utility_pub.LAST_UPDATE_LOGIN,
5073: hz_utility_pub.LAST_UPDATE_DATE,
5074: hz_utility_pub.LAST_UPDATED_BY
5075: from OE_HOLD_SOURCES a,
5076: ra_customer_merges m
5077: where a.hold_entity_id = to_char(m.duplicate_site_id)
5078: and m.process_flag = 'N'
5079: and m.request_id = req_id

Line 5087: arp_message.set_token( 'TABLE_NAME', 'OE_HOLD_SOURCES', FALSE );

5083: END IF;
5084:
5085: /* site level update */
5086: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5087: arp_message.set_token( 'TABLE_NAME', 'OE_HOLD_SOURCES', FALSE );
5088:
5089: UPDATE OE_HOLD_SOURCES a
5090: set (hold_entity_id) = (select distinct m.customer_site_id
5091: from ra_customer_merges m

Line 5089: UPDATE OE_HOLD_SOURCES a

5085: /* site level update */
5086: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5087: arp_message.set_token( 'TABLE_NAME', 'OE_HOLD_SOURCES', FALSE );
5088:
5089: UPDATE OE_HOLD_SOURCES a
5090: set (hold_entity_id) = (select distinct m.customer_site_id
5091: from ra_customer_merges m
5092: where a.hold_entity_id =
5093: m.duplicate_site_id

Line 5131: 'OE_HOLD_SOURCES',

5127: LAST_UPDATED_BY
5128: )
5129: select
5130: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5131: 'OE_HOLD_SOURCES',
5132: m.customer_merge_header_id,
5133: a.hold_source_id,
5134: to_char(a.hold_entity_id),
5135: to_char(m.customer_site_id),

Line 5143: from OE_HOLD_SOURCES a,

5139: hz_utility_pub.CREATION_DATE,
5140: hz_utility_pub.LAST_UPDATE_LOGIN,
5141: hz_utility_pub.LAST_UPDATE_DATE,
5142: hz_utility_pub.LAST_UPDATED_BY
5143: from OE_HOLD_SOURCES a,
5144: ra_customer_merges m
5145: where a.hold_entity_id = to_char(m.duplicate_site_id)
5146: and m.process_flag = 'N'
5147: and m.request_id = req_id

Line 5157: UPDATE OE_HOLD_SOURCES a

5153: /* site level update */
5154: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5155: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
5156:
5157: UPDATE OE_HOLD_SOURCES a
5158: set (hold_entity_id) = (select distinct m.customer_site_id
5159: from ra_customer_merges m
5160: where a.hold_entity_id =
5161:

Line 5200: 'OE_HOLD_SOURCES',

5196: LAST_UPDATED_BY
5197: )
5198: select
5199: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5200: 'OE_HOLD_SOURCES',
5201: m.customer_merge_header_id,
5202: a.hold_source_id,
5203: to_char(a.hold_entity_id),
5204: to_char(m.customer_id),

Line 5212: from OE_HOLD_SOURCES a,

5208: hz_utility_pub.CREATION_DATE,
5209: hz_utility_pub.LAST_UPDATE_LOGIN,
5210: hz_utility_pub.LAST_UPDATE_DATE,
5211: hz_utility_pub.LAST_UPDATED_BY
5212: from OE_HOLD_SOURCES a,
5213: ra_customer_merges m
5214: where a.hold_entity_id = to_char(m.duplicate_id)
5215: and m.process_flag = 'N'
5216: and m.request_id = req_id

Line 5226: UPDATE OE_HOLD_SOURCES a

5222: /* customer level update */
5223: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5224: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
5225:
5226: UPDATE OE_HOLD_SOURCES a
5227: set hold_entity_id = (select distinct m.customer_id
5228: from ra_customer_merges m
5229: where a.hold_entity_id =
5230: m.duplicate_id