APPS.OE_CUST_MERGE dependencies on OE_CUST_ITEM_SETTINGS

Line 5375: from oe_cust_item_settings

5371: Process_Mode IN VARCHAR2)
5372: IS
5373: CURSOR c1 is
5374: select CUST_ITEM_SETTING_ID
5375: from oe_cust_item_settings
5376: where site_use_id in
5377: (select m.duplicate_site_id
5378: from ra_customer_merges m
5379: where m.process_flag = 'N'

Line 5386: from oe_cust_item_settings

5382: for update nowait;
5383:
5384: CURSOR c2 is
5385: select CUST_ITEM_SETTING_ID
5386: from oe_cust_item_settings
5387: where customer_id in
5388: (select m.duplicate_id
5389: from ra_customer_merges m
5390: where m.process_flag = 'N'

Line 5405: arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );

5401:
5402: IF( process_mode = 'LOCK' ) THEN
5403:
5404: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
5405: arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );
5406:
5407: open c1;
5408: close c1;
5409:

Line 5438: 'OE_CUST_ITEM_SETTINGS',

5434: LAST_UPDATED_BY
5435: )
5436: select
5437: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5438: 'OE_CUST_ITEM_SETTINGS',
5439: m.customer_merge_header_id,
5440: a.cust_item_setting_id,
5441: a.site_use_id,
5442: m.customer_site_id,

Line 5450: from OE_CUST_ITEM_SETTINGS a,

5446: hz_utility_pub.CREATION_DATE,
5447: hz_utility_pub.LAST_UPDATE_LOGIN,
5448: hz_utility_pub.LAST_UPDATE_DATE,
5449: hz_utility_pub.LAST_UPDATED_BY
5450: from OE_CUST_ITEM_SETTINGS a,
5451: ra_customer_merges m
5452: where a.site_use_id = m.duplicate_site_id
5453: and m.process_flag = 'N'
5454: and m.request_id = req_id

Line 5461: arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );

5457: END IF;
5458:
5459: /* site level update */
5460: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5461: arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );
5462:
5463: UPDATE OE_CUST_ITEM_SETTINGS a
5464: set site_use_id = (select distinct m.customer_site_id
5465: from ra_customer_merges m

Line 5463: UPDATE OE_CUST_ITEM_SETTINGS a

5459: /* site level update */
5460: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5461: arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );
5462:
5463: UPDATE OE_CUST_ITEM_SETTINGS a
5464: set site_use_id = (select distinct m.customer_site_id
5465: from ra_customer_merges m
5466: where a.site_use_id = m.duplicate_site_id
5467: and m.request_id = req_id

Line 5500: 'OE_CUST_ITEM_SETTINGS',

5496: LAST_UPDATED_BY
5497: )
5498: select
5499: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5500: 'OE_CUST_ITEM_SETTINGS',
5501: m.customer_merge_header_id,
5502: a.cust_item_setting_id,
5503: a.customer_id,
5504: m.customer_id,

Line 5512: from OE_CUST_ITEM_SETTINGS a,

5508: hz_utility_pub.CREATION_DATE,
5509: hz_utility_pub.LAST_UPDATE_LOGIN,
5510: hz_utility_pub.LAST_UPDATE_DATE,
5511: hz_utility_pub.LAST_UPDATED_BY
5512: from OE_CUST_ITEM_SETTINGS a,
5513: ra_customer_merges m
5514: where a.customer_id = m.duplicate_id
5515: and m.process_flag = 'N'
5516: and m.request_id = req_id

Line 5523: arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );

5519: END IF;
5520:
5521: /* customer level update */
5522: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5523: arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );
5524:
5525: UPDATE OE_CUST_ITEM_SETTINGS a
5526: set customer_id = (select distinct m.customer_id
5527: from ra_customer_merges m

Line 5525: UPDATE OE_CUST_ITEM_SETTINGS a

5521: /* customer level update */
5522: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5523: arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );
5524:
5525: UPDATE OE_CUST_ITEM_SETTINGS a
5526: set customer_id = (select distinct m.customer_id
5527: from ra_customer_merges m
5528: where a.customer_id = m.duplicate_id
5529: and m.request_id = req_id