eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTAP_CMERGE dependencies on OTA_DELEGATE_BOOKINGS

Line 139: | Account merge procedure for the table, OTA_DELEGATE_BOOKINGS

Line 154: OTA_DELEGATE_BOOKINGS.BOOKING_ID%TYPE

150: INDEX BY BINARY_INTEGER;
151: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
152:
153: TYPE BOOKING_ID_LIST_TYPE IS TABLE OF
154: OTA_DELEGATE_BOOKINGS.BOOKING_ID%TYPE
155: INDEX BY BINARY_INTEGER;
156: PRIMARY_KEY_ID_LIST BOOKING_ID_LIST_TYPE;
157:
158: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 159: OTA_DELEGATE_BOOKINGS.CUSTOMER_ID%TYPE

155: INDEX BY BINARY_INTEGER;
156: PRIMARY_KEY_ID_LIST BOOKING_ID_LIST_TYPE;
157:
158: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
159: OTA_DELEGATE_BOOKINGS.CUSTOMER_ID%TYPE
160: INDEX BY BINARY_INTEGER;
161: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
162: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
163:

Line 165: OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CUSTOMER_ID%TYPE

161: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
162: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
163:
164: TYPE THIRD_PARTY_CUST_ID_LIST_TYPE IS TABLE OF
165: OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CUSTOMER_ID%TYPE
166: INDEX BY BINARY_INTEGER;
167: NUM_COL2_ORIG_LIST THIRD_PARTY_CUST_ID_LIST_TYPE;
168: NUM_COL2_NEW_LIST THIRD_PARTY_CUST_ID_LIST_TYPE;
169:

Line 171: OTA_DELEGATE_BOOKINGS.CONTACT_ADDRESS_ID%TYPE

167: NUM_COL2_ORIG_LIST THIRD_PARTY_CUST_ID_LIST_TYPE;
168: NUM_COL2_NEW_LIST THIRD_PARTY_CUST_ID_LIST_TYPE;
169:
170: TYPE CONTACT_ADDRESS_ID_LIST_TYPE IS TABLE OF
171: OTA_DELEGATE_BOOKINGS.CONTACT_ADDRESS_ID%TYPE
172: INDEX BY BINARY_INTEGER;
173: NUM_COL3_ORIG_LIST CONTACT_ADDRESS_ID_LIST_TYPE;
174: NUM_COL3_NEW_LIST CONTACT_ADDRESS_ID_LIST_TYPE;
175:

Line 177: OTA_DELEGATE_BOOKINGS.THIRD_PARTY_ADDRESS_ID%TYPE

173: NUM_COL3_ORIG_LIST CONTACT_ADDRESS_ID_LIST_TYPE;
174: NUM_COL3_NEW_LIST CONTACT_ADDRESS_ID_LIST_TYPE;
175:
176: TYPE THIRD_PARTY_ADDR_ID_LIST_TYPE IS TABLE OF
177: OTA_DELEGATE_BOOKINGS.THIRD_PARTY_ADDRESS_ID%TYPE
178: INDEX BY BINARY_INTEGER;
179: NUM_COL4_ORIG_LIST THIRD_PARTY_ADDR_ID_LIST_TYPE;
180: NUM_COL4_NEW_LIST THIRD_PARTY_ADDR_ID_LIST_TYPE;
181:

Line 190: FROM OTA_DELEGATE_BOOKINGS yt, ra_customer_merges m

186: ,yt.CUSTOMER_ID
187: ,THIRD_PARTY_CUSTOMER_ID
188: ,CONTACT_ADDRESS_ID
189: ,THIRD_PARTY_ADDRESS_ID
190: FROM OTA_DELEGATE_BOOKINGS yt, ra_customer_merges m
191: WHERE (
192: yt.CUSTOMER_ID = m.DUPLICATE_ID
193: OR yt.THIRD_PARTY_CUSTOMER_ID = m.DUPLICATE_ID
194: OR yt.CONTACT_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID

Line 206: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_DELEGATE_BOOKINGS',FALSE);

202: IF process_mode='LOCK' THEN
203: NULL;
204: ELSE
205: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
206: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_DELEGATE_BOOKINGS',FALSE);
207: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
208: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
209:
210:

Line 258: 'OTA_DELEGATE_BOOKINGS',

254: LAST_UPDATE_LOGIN,
255: LAST_UPDATE_DATE,
256: LAST_UPDATED_BY
257: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
258: 'OTA_DELEGATE_BOOKINGS',
259: MERGE_HEADER_ID_LIST(I),
260: PRIMARY_KEY_ID_LIST(I),
261: NUM_COL1_ORIG_LIST(I),
262: NUM_COL1_NEW_LIST(I),

Line 279: UPDATE OTA_DELEGATE_BOOKINGS yt SET

275: hz_utility_pub.LAST_UPDATED_BY
276: );
277:
278: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
279: UPDATE OTA_DELEGATE_BOOKINGS yt SET
280: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
281: ,THIRD_PARTY_CUSTOMER_ID=NUM_COL2_NEW_LIST(I)
282: ,CONTACT_ADDRESS_ID=NUM_COL3_NEW_LIST(I)
283: ,THIRD_PARTY_ADDRESS_ID=NUM_COL4_NEW_LIST(I)