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 STANDARD

Line 114: , last_updated_by=arp_standard.profile.user_id

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
116: WHERE BOOKING_DEAL_ID=PRIMARY_KEY_ID_LIST(I)
117: ;
118: l_count := l_count + SQL%ROWCOUNT;

Line 115: , last_update_login=arp_standard.profile.last_update_login

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
116: WHERE BOOKING_DEAL_ID=PRIMARY_KEY_ID_LIST(I)
117: ;
118: l_count := l_count + SQL%ROWCOUNT;
119: IF l_last_fetch THEN

Line 285: , last_updated_by=arp_standard.profile.user_id

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)
284: , LAST_UPDATE_DATE=SYSDATE
285: , last_updated_by=arp_standard.profile.user_id
286: , last_update_login=arp_standard.profile.last_update_login
287: WHERE BOOKING_ID=PRIMARY_KEY_ID_LIST(I)
288: ;
289: l_count := l_count + SQL%ROWCOUNT;

Line 286: , last_update_login=arp_standard.profile.last_update_login

282: ,CONTACT_ADDRESS_ID=NUM_COL3_NEW_LIST(I)
283: ,THIRD_PARTY_ADDRESS_ID=NUM_COL4_NEW_LIST(I)
284: , LAST_UPDATE_DATE=SYSDATE
285: , last_updated_by=arp_standard.profile.user_id
286: , last_update_login=arp_standard.profile.last_update_login
287: WHERE BOOKING_ID=PRIMARY_KEY_ID_LIST(I)
288: ;
289: l_count := l_count + SQL%ROWCOUNT;
290: IF l_last_fetch THEN

Line 473: , last_updated_by=arp_standard.profile.user_id

469: -- Bug 3590109 Address Merge
470: , ADDRESS_ID=NUM_COL2_NEW_LIST(I)
471: , INVOICE_ADDRESS=VCHAR_COL1_NEW_LIST(I)
472: , LAST_UPDATE_DATE=SYSDATE
473: , last_updated_by=arp_standard.profile.user_id
474: , last_update_login=arp_standard.profile.last_update_login
475: WHERE FINANCE_HEADER_ID=PRIMARY_KEY_ID_LIST(I)
476: ;
477: l_count := l_count + SQL%ROWCOUNT;

Line 474: , last_update_login=arp_standard.profile.last_update_login

470: , ADDRESS_ID=NUM_COL2_NEW_LIST(I)
471: , INVOICE_ADDRESS=VCHAR_COL1_NEW_LIST(I)
472: , LAST_UPDATE_DATE=SYSDATE
473: , last_updated_by=arp_standard.profile.user_id
474: , last_update_login=arp_standard.profile.last_update_login
475: WHERE FINANCE_HEADER_ID=PRIMARY_KEY_ID_LIST(I)
476: ;
477: l_count := l_count + SQL%ROWCOUNT;
478: IF l_last_fetch THEN

Line 789: , last_updated_by=arp_standard.profile.user_id

785: END IF;
786: UPDATE OTA_EVENT_ASSOCIATIONS yt SET
787: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
788: , LAST_UPDATE_DATE=SYSDATE
789: , last_updated_by=arp_standard.profile.user_id
790: , last_update_login=arp_standard.profile.last_update_login
791: WHERE EVENT_ASSOCIATION_ID=PRIMARY_KEY_ID1_LIST(I)
792: ;
793: l_count := l_count + SQL%ROWCOUNT;

Line 790: , last_update_login=arp_standard.profile.last_update_login

786: UPDATE OTA_EVENT_ASSOCIATIONS yt SET
787: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
788: , LAST_UPDATE_DATE=SYSDATE
789: , last_updated_by=arp_standard.profile.user_id
790: , last_update_login=arp_standard.profile.last_update_login
791: WHERE EVENT_ASSOCIATION_ID=PRIMARY_KEY_ID1_LIST(I)
792: ;
793: l_count := l_count + SQL%ROWCOUNT;
794: IF l_last_fetch THEN

Line 914: , last_updated_by=arp_standard.profile.user_id

910: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
911: UPDATE OTA_NOTRNG_HISTORIES yt SET
912: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
913: , LAST_UPDATE_DATE=SYSDATE
914: , last_updated_by=arp_standard.profile.user_id
915: , last_update_login=arp_standard.profile.last_update_login
916: WHERE NOTA_HISTORY_ID=PRIMARY_KEY_ID1_LIST(I)
917: ;
918: l_count := l_count + SQL%ROWCOUNT;

Line 915: , last_update_login=arp_standard.profile.last_update_login

911: UPDATE OTA_NOTRNG_HISTORIES yt SET
912: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
913: , LAST_UPDATE_DATE=SYSDATE
914: , last_updated_by=arp_standard.profile.user_id
915: , last_update_login=arp_standard.profile.last_update_login
916: WHERE NOTA_HISTORY_ID=PRIMARY_KEY_ID1_LIST(I)
917: ;
918: l_count := l_count + SQL%ROWCOUNT;
919: IF l_last_fetch THEN