APPS.OTAP_CMERGE dependencies on OTA_BOOKING_DEALS

Line 16: | Account merge procedure for the table, OTA_BOOKING_DEALS

12: |
13: | PROCEDURE
14: | OTA_TBD
15: | DESCRIPTION :
16: | Account merge procedure for the table, OTA_BOOKING_DEALS
17: |
18: | NOTES:
19: |--------------------------------------------------------------*/
20: PROCEDURE OTA_TBD (

Line 31: OTA_BOOKING_DEALS.BOOKING_DEAL_ID%TYPE

27: INDEX BY BINARY_INTEGER;
28: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
29:
30: TYPE BOOKING_DEAL_ID_LIST_TYPE IS TABLE OF
31: OTA_BOOKING_DEALS.BOOKING_DEAL_ID%TYPE
32: INDEX BY BINARY_INTEGER;
33: PRIMARY_KEY_ID_LIST BOOKING_DEAL_ID_LIST_TYPE;
34:
35: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 36: OTA_BOOKING_DEALS.CUSTOMER_ID%TYPE

32: INDEX BY BINARY_INTEGER;
33: PRIMARY_KEY_ID_LIST BOOKING_DEAL_ID_LIST_TYPE;
34:
35: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
36: OTA_BOOKING_DEALS.CUSTOMER_ID%TYPE
37: INDEX BY BINARY_INTEGER;
38: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
39: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
40:

Line 46: FROM OTA_BOOKING_DEALS yt, ra_customer_merges m

42: CURSOR merged_records IS
43: SELECT distinct CUSTOMER_MERGE_HEADER_ID
44: ,BOOKING_DEAL_ID
45: ,yt.CUSTOMER_ID
46: FROM OTA_BOOKING_DEALS yt, ra_customer_merges m
47: WHERE (
48: yt.CUSTOMER_ID = m.DUPLICATE_ID
49: ) AND m.process_flag = 'N'
50: AND m.request_id = req_id

Line 59: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_BOOKING_DEALS',FALSE);

55: IF process_mode='LOCK' THEN
56: NULL;
57: ELSE
58: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
59: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_BOOKING_DEALS',FALSE);
60: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
61: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
62:
63: open merged_records;

Line 96: 'OTA_BOOKING_DEALS',

92: LAST_UPDATE_LOGIN,
93: LAST_UPDATE_DATE,
94: LAST_UPDATED_BY
95: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
96: 'OTA_BOOKING_DEALS',
97: MERGE_HEADER_ID_LIST(I),
98: PRIMARY_KEY_ID_LIST(I),
99: NUM_COL1_ORIG_LIST(I),
100: NUM_COL1_NEW_LIST(I),

Line 111: UPDATE OTA_BOOKING_DEALS yt SET

107: hz_utility_pub.LAST_UPDATED_BY
108: );
109:
110: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
111: UPDATE OTA_BOOKING_DEALS yt SET
112: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
113: , LAST_UPDATE_DATE=SYSDATE
114: , last_updated_by=arp_standard.profile.user_id
115: , last_update_login=arp_standard.profile.last_update_login