DBA Data[Home] [Help]

APPS.FV_CMERGE dependencies on 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 317: , last_updated_by=arp_standard.profile.user_id

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

Line 318: , last_update_login=arp_standard.profile.last_update_login

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

Line 448: , last_updated_by=arp_standard.profile.user_id

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

Line 449: , last_update_login=arp_standard.profile.last_update_login

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

Line 619: , last_updated_by=arp_standard.profile.user_id

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

Line 620: , last_update_login=arp_standard.profile.last_update_login

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

Line 771: , last_updated_by=arp_standard.profile.user_id

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

Line 772: , last_update_login=arp_standard.profile.last_update_login

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

Line 905: , last_updated_by=arp_standard.profile.user_id

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

Line 906: , last_update_login=arp_standard.profile.last_update_login

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