DBA Data[Home] [Help]

APPS.ARP_CMERGE_ARCOL dependencies on STANDARD

Line 119: , last_updated_by=arp_standard.profile.user_id

115: UPDATE AR_CUSTOMER_CALL_TOPICS yt SET
116: customer_id=NUM_COL1_NEW_LIST(I)
117: ,site_use_id=NUM_COL2_NEW_LIST(I)
118: , LAST_UPDATE_DATE=SYSDATE
119: , last_updated_by=arp_standard.profile.user_id
120: , last_update_login=arp_standard.profile.last_update_login
121: WHERE customer_call_topic_id=PRIMARY_KEY_ID_LIST(I) ;
122:
123: l_count := l_count + SQL%ROWCOUNT;

Line 120: , last_update_login=arp_standard.profile.last_update_login

116: customer_id=NUM_COL1_NEW_LIST(I)
117: ,site_use_id=NUM_COL2_NEW_LIST(I)
118: , LAST_UPDATE_DATE=SYSDATE
119: , last_updated_by=arp_standard.profile.user_id
120: , last_update_login=arp_standard.profile.last_update_login
121: WHERE customer_call_topic_id=PRIMARY_KEY_ID_LIST(I) ;
122:
123: l_count := l_count + SQL%ROWCOUNT;
124: IF l_last_fetch THEN

Line 250: , last_updated_by=arp_standard.profile.user_id

246: UPDATE AR_CUSTOMER_CALLS yt SET
247: customer_id=NUM_COL1_NEW_LIST(I)
248: ,site_use_id=NUM_COL2_NEW_LIST(I)
249: , LAST_UPDATE_DATE=SYSDATE
250: , last_updated_by=arp_standard.profile.user_id
251: , last_update_login=arp_standard.profile.last_update_login
252: WHERE customer_call_id=PRIMARY_KEY_ID_LIST(I) ;
253:
254: l_count := l_count + SQL%ROWCOUNT;

Line 251: , last_update_login=arp_standard.profile.last_update_login

247: customer_id=NUM_COL1_NEW_LIST(I)
248: ,site_use_id=NUM_COL2_NEW_LIST(I)
249: , LAST_UPDATE_DATE=SYSDATE
250: , last_updated_by=arp_standard.profile.user_id
251: , last_update_login=arp_standard.profile.last_update_login
252: WHERE customer_call_id=PRIMARY_KEY_ID_LIST(I) ;
253:
254: l_count := l_count + SQL%ROWCOUNT;
255: IF l_last_fetch THEN

Line 386: , last_updated_by=arp_standard.profile.user_id

382: ,bill_to_location = ( select hs.location
383: from hz_cust_site_uses hs
384: where hs.site_use_id = NUM_COL2_NEW_LIST(I))
385: , LAST_UPDATE_DATE=SYSDATE
386: , last_updated_by=arp_standard.profile.user_id
387: , last_update_login=arp_standard.profile.last_update_login
388: WHERE line_cluster_id=PRIMARY_KEY_ID_LIST(I)
389: AND customer_id = NUM_COL1_ORIG_LIST(I) ;
390:

Line 387: , last_update_login=arp_standard.profile.last_update_login

383: from hz_cust_site_uses hs
384: where hs.site_use_id = NUM_COL2_NEW_LIST(I))
385: , LAST_UPDATE_DATE=SYSDATE
386: , last_updated_by=arp_standard.profile.user_id
387: , last_update_login=arp_standard.profile.last_update_login
388: WHERE line_cluster_id=PRIMARY_KEY_ID_LIST(I)
389: AND customer_id = NUM_COL1_ORIG_LIST(I) ;
390:
391: l_count := l_count + SQL%ROWCOUNT;