DBA Data[Home] [Help]

APPS.IBE_MERGE_PVT dependencies on ARP_STANDARD

Line 295: , last_updated_by=arp_standard.profile.user_id

291: UPDATE IBE_SH_SHP_LISTS_ALL yt SET
292: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
293: ,PARTY_ID=NUM_COL2_NEW_LIST(I)
294: , LAST_UPDATE_DATE=SYSDATE
295: , last_updated_by=arp_standard.profile.user_id
296: , last_update_login=arp_standard.profile.last_update_login
297: , REQUEST_ID=request_id
298: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
299: , PROGRAM_ID=arp_standard.profile.program_id

Line 296: , last_update_login=arp_standard.profile.last_update_login

292: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
293: ,PARTY_ID=NUM_COL2_NEW_LIST(I)
294: , LAST_UPDATE_DATE=SYSDATE
295: , last_updated_by=arp_standard.profile.user_id
296: , last_update_login=arp_standard.profile.last_update_login
297: , REQUEST_ID=request_id
298: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
299: , PROGRAM_ID=arp_standard.profile.program_id
300: , PROGRAM_UPDATE_DATE=SYSDATE

Line 298: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

294: , LAST_UPDATE_DATE=SYSDATE
295: , last_updated_by=arp_standard.profile.user_id
296: , last_update_login=arp_standard.profile.last_update_login
297: , REQUEST_ID=request_id
298: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
299: , PROGRAM_ID=arp_standard.profile.program_id
300: , PROGRAM_UPDATE_DATE=SYSDATE
301: WHERE SHP_LIST_ID=PRIMARY_KEY_ID_LIST(I);
302:

Line 299: , PROGRAM_ID=arp_standard.profile.program_id

295: , last_updated_by=arp_standard.profile.user_id
296: , last_update_login=arp_standard.profile.last_update_login
297: , REQUEST_ID=request_id
298: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
299: , PROGRAM_ID=arp_standard.profile.program_id
300: , PROGRAM_UPDATE_DATE=SYSDATE
301: WHERE SHP_LIST_ID=PRIMARY_KEY_ID_LIST(I);
302:
303: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN