APPS.OE_CUST_MERGE dependencies on OE_CUST_ITEM_SETTINGS

Line 5923: from oe_cust_item_settings

5919: Process_Mode IN VARCHAR2)
5920: IS
5921: CURSOR c1 is
5922: select CUST_ITEM_SETTING_ID
5923: from oe_cust_item_settings
5924: where site_use_id in
5925: (select m.duplicate_site_id
5926: from ra_customer_merges m
5927: where m.process_flag = 'N'

Line 5934: from oe_cust_item_settings

5930: for update nowait;
5931:
5932: CURSOR c2 is
5933: select CUST_ITEM_SETTING_ID
5934: from oe_cust_item_settings
5935: where customer_id in
5936: (select m.duplicate_id
5937: from ra_customer_merges m
5938: where m.process_flag = 'N'

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

5949:
5950: IF( process_mode = 'LOCK' ) THEN
5951:
5952: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
5953: arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );
5954:
5955: open c1;
5956: close c1;
5957:

Line 5986: 'OE_CUST_ITEM_SETTINGS',

5982: LAST_UPDATED_BY
5983: )
5984: select
5985: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5986: 'OE_CUST_ITEM_SETTINGS',
5987: m.customer_merge_header_id,
5988: a.cust_item_setting_id,
5989: a.site_use_id,
5990: m.customer_site_id,

Line 5998: from OE_CUST_ITEM_SETTINGS a,

5994: hz_utility_pub.CREATION_DATE,
5995: hz_utility_pub.LAST_UPDATE_LOGIN,
5996: hz_utility_pub.LAST_UPDATE_DATE,
5997: hz_utility_pub.LAST_UPDATED_BY
5998: from OE_CUST_ITEM_SETTINGS a,
5999: ra_customer_merges m
6000: where a.site_use_id = m.duplicate_site_id
6001: and m.process_flag = 'N'
6002: and m.request_id = req_id

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

6005: END IF;
6006:
6007: /* site level update */
6008: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6009: arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );
6010:
6011: UPDATE OE_CUST_ITEM_SETTINGS a
6012: set site_use_id = (select distinct m.customer_site_id
6013: from ra_customer_merges m

Line 6011: UPDATE OE_CUST_ITEM_SETTINGS a

6007: /* site level update */
6008: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6009: arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );
6010:
6011: UPDATE OE_CUST_ITEM_SETTINGS a
6012: set site_use_id = (select distinct m.customer_site_id
6013: from ra_customer_merges m
6014: where a.site_use_id = m.duplicate_site_id
6015: and m.request_id = req_id

Line 6048: 'OE_CUST_ITEM_SETTINGS',

6044: LAST_UPDATED_BY
6045: )
6046: select
6047: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6048: 'OE_CUST_ITEM_SETTINGS',
6049: m.customer_merge_header_id,
6050: a.cust_item_setting_id,
6051: a.customer_id,
6052: m.customer_id,

Line 6060: from OE_CUST_ITEM_SETTINGS a,

6056: hz_utility_pub.CREATION_DATE,
6057: hz_utility_pub.LAST_UPDATE_LOGIN,
6058: hz_utility_pub.LAST_UPDATE_DATE,
6059: hz_utility_pub.LAST_UPDATED_BY
6060: from OE_CUST_ITEM_SETTINGS a,
6061: ra_customer_merges m
6062: where a.customer_id = m.duplicate_id
6063: and m.process_flag = 'N'
6064: and m.request_id = req_id

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

6067: END IF;
6068:
6069: /* customer level update */
6070: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6071: arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );
6072:
6073: UPDATE OE_CUST_ITEM_SETTINGS a
6074: set customer_id = (select distinct m.customer_id
6075: from ra_customer_merges m

Line 6073: UPDATE OE_CUST_ITEM_SETTINGS a

6069: /* customer level update */
6070: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6071: arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );
6072:
6073: UPDATE OE_CUST_ITEM_SETTINGS a
6074: set customer_id = (select distinct m.customer_id
6075: from ra_customer_merges m
6076: where a.customer_id = m.duplicate_id
6077: and m.request_id = req_id