APPS.ARP_CMERGE_ARTRX dependencies on ARP_STANDARD

Line 118: , last_updated_by=arp_standard.profile.user_id

114: UPDATE AR_CASH_RECEIPTS yt SET
115: pay_from_customer=NUM_COL1_NEW_LIST(I)
116: ,customer_site_use_id=NUM_COL2_NEW_LIST(I)
117: , LAST_UPDATE_DATE=SYSDATE
118: , last_updated_by=arp_standard.profile.user_id
119: , last_update_login=arp_standard.profile.last_update_login
120: , REQUEST_ID=req_id
121: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
122: , PROGRAM_ID=arp_standard.profile.program_id

Line 119: , last_update_login=arp_standard.profile.last_update_login

115: pay_from_customer=NUM_COL1_NEW_LIST(I)
116: ,customer_site_use_id=NUM_COL2_NEW_LIST(I)
117: , LAST_UPDATE_DATE=SYSDATE
118: , last_updated_by=arp_standard.profile.user_id
119: , last_update_login=arp_standard.profile.last_update_login
120: , REQUEST_ID=req_id
121: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
122: , PROGRAM_ID=arp_standard.profile.program_id
123: , PROGRAM_UPDATE_DATE=SYSDATE

Line 121: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

117: , LAST_UPDATE_DATE=SYSDATE
118: , last_updated_by=arp_standard.profile.user_id
119: , last_update_login=arp_standard.profile.last_update_login
120: , REQUEST_ID=req_id
121: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
122: , PROGRAM_ID=arp_standard.profile.program_id
123: , PROGRAM_UPDATE_DATE=SYSDATE
124: WHERE cash_receipt_id=PRIMARY_KEY_ID_LIST(I)
125: ;

Line 122: , PROGRAM_ID=arp_standard.profile.program_id

118: , last_updated_by=arp_standard.profile.user_id
119: , last_update_login=arp_standard.profile.last_update_login
120: , REQUEST_ID=req_id
121: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
122: , PROGRAM_ID=arp_standard.profile.program_id
123: , PROGRAM_UPDATE_DATE=SYSDATE
124: WHERE cash_receipt_id=PRIMARY_KEY_ID_LIST(I)
125: ;
126: l_count := l_count + SQL%ROWCOUNT;

Line 249: , last_updated_by=arp_standard.profile.user_id

245: UPDATE AR_PAYMENT_SCHEDULES yt SET
246: customer_id=NUM_COL1_NEW_LIST(I)
247: ,customer_site_use_id=NUM_COL2_NEW_LIST(I)
248: , LAST_UPDATE_DATE=SYSDATE
249: , last_updated_by=arp_standard.profile.user_id
250: , last_update_login=arp_standard.profile.last_update_login
251: , REQUEST_ID=req_id
252: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
253: , PROGRAM_ID=arp_standard.profile.program_id

Line 250: , last_update_login=arp_standard.profile.last_update_login

246: customer_id=NUM_COL1_NEW_LIST(I)
247: ,customer_site_use_id=NUM_COL2_NEW_LIST(I)
248: , LAST_UPDATE_DATE=SYSDATE
249: , last_updated_by=arp_standard.profile.user_id
250: , last_update_login=arp_standard.profile.last_update_login
251: , REQUEST_ID=req_id
252: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
253: , PROGRAM_ID=arp_standard.profile.program_id
254: , PROGRAM_UPDATE_DATE=SYSDATE

Line 252: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

248: , LAST_UPDATE_DATE=SYSDATE
249: , last_updated_by=arp_standard.profile.user_id
250: , last_update_login=arp_standard.profile.last_update_login
251: , REQUEST_ID=req_id
252: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
253: , PROGRAM_ID=arp_standard.profile.program_id
254: , PROGRAM_UPDATE_DATE=SYSDATE
255: WHERE payment_schedule_id=PRIMARY_KEY_ID_LIST(I)
256: ;

Line 253: , PROGRAM_ID=arp_standard.profile.program_id

249: , last_updated_by=arp_standard.profile.user_id
250: , last_update_login=arp_standard.profile.last_update_login
251: , REQUEST_ID=req_id
252: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
253: , PROGRAM_ID=arp_standard.profile.program_id
254: , PROGRAM_UPDATE_DATE=SYSDATE
255: WHERE payment_schedule_id=PRIMARY_KEY_ID_LIST(I)
256: ;
257: l_count := l_count + SQL%ROWCOUNT;

Line 501: , last_updated_by=arp_standard.profile.user_id

497: ,sold_to_site_use_id=NUM_COL8_NEW_LIST(I)
498: ,drawee_id=NUM_COL9_NEW_LIST(I)
499: ,drawee_site_use_id=NUM_COL10_NEW_LIST(I)
500: , LAST_UPDATE_DATE=SYSDATE
501: , last_updated_by=arp_standard.profile.user_id
502: , last_update_login=arp_standard.profile.last_update_login
503: , REQUEST_ID=req_id
504: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
505: , PROGRAM_ID=arp_standard.profile.program_id

Line 502: , last_update_login=arp_standard.profile.last_update_login

498: ,drawee_id=NUM_COL9_NEW_LIST(I)
499: ,drawee_site_use_id=NUM_COL10_NEW_LIST(I)
500: , LAST_UPDATE_DATE=SYSDATE
501: , last_updated_by=arp_standard.profile.user_id
502: , last_update_login=arp_standard.profile.last_update_login
503: , REQUEST_ID=req_id
504: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
505: , PROGRAM_ID=arp_standard.profile.program_id
506: , PROGRAM_UPDATE_DATE=SYSDATE

Line 504: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

500: , LAST_UPDATE_DATE=SYSDATE
501: , last_updated_by=arp_standard.profile.user_id
502: , last_update_login=arp_standard.profile.last_update_login
503: , REQUEST_ID=req_id
504: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
505: , PROGRAM_ID=arp_standard.profile.program_id
506: , PROGRAM_UPDATE_DATE=SYSDATE
507: WHERE customer_trx_id=PRIMARY_KEY_ID_LIST(I)
508: ;

Line 505: , PROGRAM_ID=arp_standard.profile.program_id

501: , last_updated_by=arp_standard.profile.user_id
502: , last_update_login=arp_standard.profile.last_update_login
503: , REQUEST_ID=req_id
504: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
505: , PROGRAM_ID=arp_standard.profile.program_id
506: , PROGRAM_UPDATE_DATE=SYSDATE
507: WHERE customer_trx_id=PRIMARY_KEY_ID_LIST(I)
508: ;
509: l_count := l_count + SQL%ROWCOUNT;

Line 641: , last_updated_by=arp_standard.profile.user_id

637:
638: ship_to_customer_id=NUM_COL1_NEW_LIST(I)
639: ,ship_to_site_use_id=NUM_COL2_NEW_LIST(I)
640: , LAST_UPDATE_DATE=SYSDATE
641: , last_updated_by=arp_standard.profile.user_id
642: , last_update_login=arp_standard.profile.last_update_login
643: , REQUEST_ID=req_id
644: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
645: , PROGRAM_ID=arp_standard.profile.program_id

Line 642: , last_update_login=arp_standard.profile.last_update_login

638: ship_to_customer_id=NUM_COL1_NEW_LIST(I)
639: ,ship_to_site_use_id=NUM_COL2_NEW_LIST(I)
640: , LAST_UPDATE_DATE=SYSDATE
641: , last_updated_by=arp_standard.profile.user_id
642: , last_update_login=arp_standard.profile.last_update_login
643: , REQUEST_ID=req_id
644: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
645: , PROGRAM_ID=arp_standard.profile.program_id
646: , PROGRAM_UPDATE_DATE=SYSDATE

Line 644: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

640: , LAST_UPDATE_DATE=SYSDATE
641: , last_updated_by=arp_standard.profile.user_id
642: , last_update_login=arp_standard.profile.last_update_login
643: , REQUEST_ID=req_id
644: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
645: , PROGRAM_ID=arp_standard.profile.program_id
646: , PROGRAM_UPDATE_DATE=SYSDATE
647: WHERE customer_trx_line_id=PRIMARY_KEY_ID_LIST(I)
648: ;

Line 645: , PROGRAM_ID=arp_standard.profile.program_id

641: , last_updated_by=arp_standard.profile.user_id
642: , last_update_login=arp_standard.profile.last_update_login
643: , REQUEST_ID=req_id
644: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
645: , PROGRAM_ID=arp_standard.profile.program_id
646: , PROGRAM_UPDATE_DATE=SYSDATE
647: WHERE customer_trx_line_id=PRIMARY_KEY_ID_LIST(I)
648: ;
649: l_count := l_count + SQL%ROWCOUNT;

Line 777: , last_updated_by=arp_standard.profile.user_id

773: UPDATE ar_receivable_applications yt SET
774: on_acct_cust_id=NUM_COL1_NEW_LIST(I)
775: ,on_acct_cust_site_use_id=NUM_COL2_NEW_LIST(I)
776: , LAST_UPDATE_DATE=SYSDATE
777: , last_updated_by=arp_standard.profile.user_id
778: , last_update_login=arp_standard.profile.last_update_login
779: , REQUEST_ID=req_id
780: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
781: , PROGRAM_ID=arp_standard.profile.program_id

Line 778: , last_update_login=arp_standard.profile.last_update_login

774: on_acct_cust_id=NUM_COL1_NEW_LIST(I)
775: ,on_acct_cust_site_use_id=NUM_COL2_NEW_LIST(I)
776: , LAST_UPDATE_DATE=SYSDATE
777: , last_updated_by=arp_standard.profile.user_id
778: , last_update_login=arp_standard.profile.last_update_login
779: , REQUEST_ID=req_id
780: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
781: , PROGRAM_ID=arp_standard.profile.program_id
782: , PROGRAM_UPDATE_DATE=SYSDATE

Line 780: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

776: , LAST_UPDATE_DATE=SYSDATE
777: , last_updated_by=arp_standard.profile.user_id
778: , last_update_login=arp_standard.profile.last_update_login
779: , REQUEST_ID=req_id
780: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
781: , PROGRAM_ID=arp_standard.profile.program_id
782: , PROGRAM_UPDATE_DATE=SYSDATE
783: WHERE receivable_application_id=PRIMARY_KEY_ID_LIST(I)
784: ;

Line 781: , PROGRAM_ID=arp_standard.profile.program_id

777: , last_updated_by=arp_standard.profile.user_id
778: , last_update_login=arp_standard.profile.last_update_login
779: , REQUEST_ID=req_id
780: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
781: , PROGRAM_ID=arp_standard.profile.program_id
782: , PROGRAM_UPDATE_DATE=SYSDATE
783: WHERE receivable_application_id=PRIMARY_KEY_ID_LIST(I)
784: ;
785: l_count := l_count + SQL%ROWCOUNT;

Line 1268: , last_updated_by=arp_standard.profile.user_id

1264: ,ORIG_SYSTEM_SOLD_CUSTOMER_REF=VCHAR_COL3_NEW_LIST(I)
1265: ,ORIG_SYSTEM_BILL_ADDRESS_REF=VCHAR_COL4_NEW_LIST(I)
1266: ,ORIG_SYSTEM_SHIP_ADDRESS_REF=VCHAR_COL5_NEW_LIST(I)
1267: , LAST_UPDATE_DATE=SYSDATE
1268: , last_updated_by=arp_standard.profile.user_id
1269: , last_update_login=arp_standard.profile.last_update_login
1270: WHERE ROWID=PRIMARY_KEY1_LIST(I)
1271: ;
1272: l_count := l_count + SQL%ROWCOUNT;

Line 1269: , last_update_login=arp_standard.profile.last_update_login

1265: ,ORIG_SYSTEM_BILL_ADDRESS_REF=VCHAR_COL4_NEW_LIST(I)
1266: ,ORIG_SYSTEM_SHIP_ADDRESS_REF=VCHAR_COL5_NEW_LIST(I)
1267: , LAST_UPDATE_DATE=SYSDATE
1268: , last_updated_by=arp_standard.profile.user_id
1269: , last_update_login=arp_standard.profile.last_update_login
1270: WHERE ROWID=PRIMARY_KEY1_LIST(I)
1271: ;
1272: l_count := l_count + SQL%ROWCOUNT;
1273: IF l_last_fetch THEN

Line 1395: , last_updated_by=arp_standard.profile.user_id

1391: UPDATE AR_DISTRIBUTIONS yt SET
1392: third_party_id=NUM_COL1_NEW_LIST(I)
1393: ,third_party_sub_id=NUM_COL2_NEW_LIST(I)
1394: , LAST_UPDATE_DATE=SYSDATE
1395: , last_updated_by=arp_standard.profile.user_id
1396: , last_update_login=arp_standard.profile.last_update_login
1397: WHERE line_id=PRIMARY_KEY_ID_LIST(I)
1398: ;
1399: l_count := l_count + SQL%ROWCOUNT;

Line 1396: , last_update_login=arp_standard.profile.last_update_login

1392: third_party_id=NUM_COL1_NEW_LIST(I)
1393: ,third_party_sub_id=NUM_COL2_NEW_LIST(I)
1394: , LAST_UPDATE_DATE=SYSDATE
1395: , last_updated_by=arp_standard.profile.user_id
1396: , last_update_login=arp_standard.profile.last_update_login
1397: WHERE line_id=PRIMARY_KEY_ID_LIST(I)
1398: ;
1399: l_count := l_count + SQL%ROWCOUNT;
1400: IF l_last_fetch THEN