APPS.AR_CMGT_ACCOUNT_MERGE dependencies on ARP_STANDARD

Line 137: , last_updated_by=arp_standard.profile.user_id

133: UPDATE AR_CMGT_CASE_FOLDERS yt SET
134: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
135: ,SITE_USE_ID=DECODE( SITE_USE_ID, -99,-99,NUM_COL2_NEW_LIST(I))
136: , LAST_UPDATE_DATE=SYSDATE
137: , last_updated_by=arp_standard.profile.user_id
138: , last_update_login=arp_standard.profile.last_update_login
139: WHERE CASE_FOLDER_ID=PRIMARY_KEY_ID_LIST(I)
140: ;
141: l_count := l_count + SQL%ROWCOUNT;

Line 138: , last_update_login=arp_standard.profile.last_update_login

134: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
135: ,SITE_USE_ID=DECODE( SITE_USE_ID, -99,-99,NUM_COL2_NEW_LIST(I))
136: , LAST_UPDATE_DATE=SYSDATE
137: , last_updated_by=arp_standard.profile.user_id
138: , last_update_login=arp_standard.profile.last_update_login
139: WHERE CASE_FOLDER_ID=PRIMARY_KEY_ID_LIST(I)
140: ;
141: l_count := l_count + SQL%ROWCOUNT;
142: IF l_last_fetch THEN

Line 275: , last_updated_by=arp_standard.profile.user_id

271: UPDATE AR_CMGT_CREDIT_REQUESTS yt SET
272: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
273: ,SITE_USE_ID=DECODE(SITE_USE_ID,-99,-99, NUM_COL2_NEW_LIST(I))
274: , LAST_UPDATE_DATE=SYSDATE
275: , last_updated_by=arp_standard.profile.user_id
276: , last_update_login=arp_standard.profile.last_update_login
277: WHERE CREDIT_REQUEST_ID=PRIMARY_KEY_ID_LIST(I)
278: ;
279: l_count := l_count + SQL%ROWCOUNT;

Line 276: , last_update_login=arp_standard.profile.last_update_login

272: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
273: ,SITE_USE_ID=DECODE(SITE_USE_ID,-99,-99, NUM_COL2_NEW_LIST(I))
274: , LAST_UPDATE_DATE=SYSDATE
275: , last_updated_by=arp_standard.profile.user_id
276: , last_update_login=arp_standard.profile.last_update_login
277: WHERE CREDIT_REQUEST_ID=PRIMARY_KEY_ID_LIST(I)
278: ;
279: l_count := l_count + SQL%ROWCOUNT;
280: IF l_last_fetch THEN

Line 844: , last_updated_by=arp_standard.profile.user_id

840: UPDATE AR_TRX_BAL_SUMMARY yt SET
841: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
842: ,SITE_USE_ID=DECODE(SITE_USE_ID, -99, -99, NUM_COL2_NEW_LIST(I))
843: , LAST_UPDATE_DATE=SYSDATE
844: , last_updated_by=arp_standard.profile.user_id
845: , last_update_login=arp_standard.profile.last_update_login
846: WHERE CUST_ACCOUNT_ID=PRIMARY_KEY1_LIST(I)
847: AND SITE_USE_ID=PRIMARY_KEY2_LIST(I)
848: AND CURRENCY=PRIMARY_KEY3_LIST(I)

Line 845: , last_update_login=arp_standard.profile.last_update_login

841: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
842: ,SITE_USE_ID=DECODE(SITE_USE_ID, -99, -99, NUM_COL2_NEW_LIST(I))
843: , LAST_UPDATE_DATE=SYSDATE
844: , last_updated_by=arp_standard.profile.user_id
845: , last_update_login=arp_standard.profile.last_update_login
846: WHERE CUST_ACCOUNT_ID=PRIMARY_KEY1_LIST(I)
847: AND SITE_USE_ID=PRIMARY_KEY2_LIST(I)
848: AND CURRENCY=PRIMARY_KEY3_LIST(I)
849: AND ORG_ID=PRIMARY_KEY4_LIST(I)

Line 1476: , last_updated_by=arp_standard.profile.user_id

1472: UPDATE AR_TRX_SUMMARY yt SET
1473: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
1474: ,SITE_USE_ID=NUM_COL2_NEW_LIST(I)
1475: , LAST_UPDATE_DATE=SYSDATE
1476: , last_updated_by=arp_standard.profile.user_id
1477: , last_update_login=arp_standard.profile.last_update_login
1478: WHERE CUST_ACCOUNT_ID=PRIMARY_KEY1_LIST(I)
1479: AND SITE_USE_ID=PRIMARY_KEY2_LIST(I)
1480: AND CURRENCY=PRIMARY_KEY3_LIST(I)

Line 1477: , last_update_login=arp_standard.profile.last_update_login

1473: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
1474: ,SITE_USE_ID=NUM_COL2_NEW_LIST(I)
1475: , LAST_UPDATE_DATE=SYSDATE
1476: , last_updated_by=arp_standard.profile.user_id
1477: , last_update_login=arp_standard.profile.last_update_login
1478: WHERE CUST_ACCOUNT_ID=PRIMARY_KEY1_LIST(I)
1479: AND SITE_USE_ID=PRIMARY_KEY2_LIST(I)
1480: AND CURRENCY=PRIMARY_KEY3_LIST(I)
1481: AND AS_OF_DATE=PRIMARY_KEY4_LIST(I)