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.FV_CMERGE dependencies on ARP_STANDARD

Line 166: , last_updated_by=arp_standard.profile.user_id

162: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
163: UPDATE FV_CUST_FINANCE_CHRGS yt SET
164: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
165: , LAST_UPDATE_DATE=SYSDATE
166: , last_updated_by=arp_standard.profile.user_id
167: , last_update_login=arp_standard.profile.last_update_login
168: WHERE CUSTOMER_ID=PRIMARY_KEY1_LIST(I)
169: AND CHARGE_ID=PRIMARY_KEY2_LIST(I)
170: ;

Line 167: , last_update_login=arp_standard.profile.last_update_login

163: UPDATE FV_CUST_FINANCE_CHRGS yt SET
164: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
165: , LAST_UPDATE_DATE=SYSDATE
166: , last_updated_by=arp_standard.profile.user_id
167: , last_update_login=arp_standard.profile.last_update_login
168: WHERE CUSTOMER_ID=PRIMARY_KEY1_LIST(I)
169: AND CHARGE_ID=PRIMARY_KEY2_LIST(I)
170: ;
171: l_count := l_count + SQL%ROWCOUNT;

Line 320: , last_updated_by=arp_standard.profile.user_id

316: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
317: UPDATE FV_CUST_VEND_XREFS yt SET
318: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
319: , LAST_UPDATE_DATE=SYSDATE
320: , last_updated_by=arp_standard.profile.user_id
321: , last_update_login=arp_standard.profile.last_update_login
322: WHERE CUST_VEND_XREF_ID=PRIMARY_KEY_ID_LIST(I)
323: ;
324: l_count := l_count + SQL%ROWCOUNT;

Line 321: , last_update_login=arp_standard.profile.last_update_login

317: UPDATE FV_CUST_VEND_XREFS yt SET
318: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
319: , LAST_UPDATE_DATE=SYSDATE
320: , last_updated_by=arp_standard.profile.user_id
321: , last_update_login=arp_standard.profile.last_update_login
322: WHERE CUST_VEND_XREF_ID=PRIMARY_KEY_ID_LIST(I)
323: ;
324: l_count := l_count + SQL%ROWCOUNT;
325: IF l_last_fetch THEN

Line 451: , last_updated_by=arp_standard.profile.user_id

447: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
448: UPDATE FV_INTERAGENCY_FUNDS yt SET
449: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
450: , LAST_UPDATE_DATE=SYSDATE
451: , last_updated_by=arp_standard.profile.user_id
452: , last_update_login=arp_standard.profile.last_update_login
453: WHERE INTERAGENCY_FUND_ID=PRIMARY_KEY_ID_LIST(I)
454: ;
455: l_count := l_count + SQL%ROWCOUNT;

Line 452: , last_update_login=arp_standard.profile.last_update_login

448: UPDATE FV_INTERAGENCY_FUNDS yt SET
449: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
450: , LAST_UPDATE_DATE=SYSDATE
451: , last_updated_by=arp_standard.profile.user_id
452: , last_update_login=arp_standard.profile.last_update_login
453: WHERE INTERAGENCY_FUND_ID=PRIMARY_KEY_ID_LIST(I)
454: ;
455: l_count := l_count + SQL%ROWCOUNT;
456: IF l_last_fetch THEN

Line 622: , last_updated_by=arp_standard.profile.user_id

618: UPDATE FV_INTERIM_CASH_RECEIPTS yt SET
619: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
620: ,SITE_USE_ID=NUM_COL2_NEW_LIST(I)
621: , LAST_UPDATE_DATE=SYSDATE
622: , last_updated_by=arp_standard.profile.user_id
623: , last_update_login=arp_standard.profile.last_update_login
624: WHERE BATCH_ID=PRIMARY_KEY1_LIST(I)
625: AND CUSTOMER_ID=PRIMARY_KEY2_LIST(I)
626: AND CUSTOMER_TRX_ID=PRIMARY_KEY3_LIST(I)

Line 623: , last_update_login=arp_standard.profile.last_update_login

619: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
620: ,SITE_USE_ID=NUM_COL2_NEW_LIST(I)
621: , LAST_UPDATE_DATE=SYSDATE
622: , last_updated_by=arp_standard.profile.user_id
623: , last_update_login=arp_standard.profile.last_update_login
624: WHERE BATCH_ID=PRIMARY_KEY1_LIST(I)
625: AND CUSTOMER_ID=PRIMARY_KEY2_LIST(I)
626: AND CUSTOMER_TRX_ID=PRIMARY_KEY3_LIST(I)
627: AND RECEIPT_NUMBER=PRIMARY_KEY4_LIST(I)

Line 774: , last_updated_by=arp_standard.profile.user_id

770: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
771: UPDATE FV_INVOICE_FINANCE_CHRGS yt SET
772: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
773: , LAST_UPDATE_DATE=SYSDATE
774: , last_updated_by=arp_standard.profile.user_id
775: , last_update_login=arp_standard.profile.last_update_login
776: WHERE CUSTOMER_TRX_ID=PRIMARY_KEY1_LIST(I)
777: AND CUSTOMER_ID=PRIMARY_KEY2_LIST(I)
778: AND CHARGE_ID=PRIMARY_KEY3_LIST(I)

Line 775: , last_update_login=arp_standard.profile.last_update_login

771: UPDATE FV_INVOICE_FINANCE_CHRGS yt SET
772: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
773: , LAST_UPDATE_DATE=SYSDATE
774: , last_updated_by=arp_standard.profile.user_id
775: , last_update_login=arp_standard.profile.last_update_login
776: WHERE CUSTOMER_TRX_ID=PRIMARY_KEY1_LIST(I)
777: AND CUSTOMER_ID=PRIMARY_KEY2_LIST(I)
778: AND CHARGE_ID=PRIMARY_KEY3_LIST(I)
779: ;

Line 908: , last_updated_by=arp_standard.profile.user_id

904: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
905: UPDATE FV_IPAC_TRX yt SET
906: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
907: , LAST_UPDATE_DATE=SYSDATE
908: , last_updated_by=arp_standard.profile.user_id
909: , last_update_login=arp_standard.profile.last_update_login
910: WHERE IPAC_BILLING_ID=PRIMARY_KEY1_LIST(I)
911: ;
912: l_count := l_count + SQL%ROWCOUNT;

Line 909: , last_update_login=arp_standard.profile.last_update_login

905: UPDATE FV_IPAC_TRX yt SET
906: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
907: , LAST_UPDATE_DATE=SYSDATE
908: , last_updated_by=arp_standard.profile.user_id
909: , last_update_login=arp_standard.profile.last_update_login
910: WHERE IPAC_BILLING_ID=PRIMARY_KEY1_LIST(I)
911: ;
912: l_count := l_count + SQL%ROWCOUNT;
913: IF l_last_fetch THEN