DBA Data[Home] [Help]

APPS.POP_CMERGE_REQ dependencies on STANDARD

Line 252: LAST_UPDATED_BY = arp_standard.profile.user_id,

248: UPDATE PO_REQUISITION_LINES yt
249: SET -- DELIVER_TO_LOCATION_ID = l_deliver_to_location_id,
250: DELIVER_TO_LOCATION_ID = NEW_DELIVER_TO_LOC_LIST(I),
251: LAST_UPDATE_DATE = SYSDATE,
252: LAST_UPDATED_BY = arp_standard.profile.user_id,
253: LAST_UPDATE_LOGIN = arp_standard.profile.last_update_login,
254: REQUEST_ID = req_id,
255: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id,
256: PROGRAM_ID = arp_standard.profile.program_id,

Line 253: LAST_UPDATE_LOGIN = arp_standard.profile.last_update_login,

249: SET -- DELIVER_TO_LOCATION_ID = l_deliver_to_location_id,
250: DELIVER_TO_LOCATION_ID = NEW_DELIVER_TO_LOC_LIST(I),
251: LAST_UPDATE_DATE = SYSDATE,
252: LAST_UPDATED_BY = arp_standard.profile.user_id,
253: LAST_UPDATE_LOGIN = arp_standard.profile.last_update_login,
254: REQUEST_ID = req_id,
255: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id,
256: PROGRAM_ID = arp_standard.profile.program_id,
257: PROGRAM_UPDATE_DATE = SYSDATE

Line 255: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id,

251: LAST_UPDATE_DATE = SYSDATE,
252: LAST_UPDATED_BY = arp_standard.profile.user_id,
253: LAST_UPDATE_LOGIN = arp_standard.profile.last_update_login,
254: REQUEST_ID = req_id,
255: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id,
256: PROGRAM_ID = arp_standard.profile.program_id,
257: PROGRAM_UPDATE_DATE = SYSDATE
258: WHERE REQUISITION_LINE_ID = PRIMARY_KEY_ID_LIST(I);
259:

Line 256: PROGRAM_ID = arp_standard.profile.program_id,

252: LAST_UPDATED_BY = arp_standard.profile.user_id,
253: LAST_UPDATE_LOGIN = arp_standard.profile.last_update_login,
254: REQUEST_ID = req_id,
255: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id,
256: PROGRAM_ID = arp_standard.profile.program_id,
257: PROGRAM_UPDATE_DATE = SYSDATE
258: WHERE REQUISITION_LINE_ID = PRIMARY_KEY_ID_LIST(I);
259:
260: g_count := g_count + SQL%ROWCOUNT;

Line 872: last_updated_by = arp_standard.profile.user_id,

868: UPDATE PO_LOCATION_ASSOCIATIONS yt
869: SET CUSTOMER_ID=NEW_CUST_ID_LIST(I), --Bug 4009128
870: SITE_USE_ID=NEW_CUST_SITE_ID_LIST(I), --Bug 4009128
871: LAST_UPDATE_DATE = SYSDATE,
872: last_updated_by = arp_standard.profile.user_id,
873: last_update_login = arp_standard.profile.last_update_login,
874: REQUEST_ID = req_id,
875: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id,
876: PROGRAM_ID = arp_standard.profile.program_id,

Line 873: last_update_login = arp_standard.profile.last_update_login,

869: SET CUSTOMER_ID=NEW_CUST_ID_LIST(I), --Bug 4009128
870: SITE_USE_ID=NEW_CUST_SITE_ID_LIST(I), --Bug 4009128
871: LAST_UPDATE_DATE = SYSDATE,
872: last_updated_by = arp_standard.profile.user_id,
873: last_update_login = arp_standard.profile.last_update_login,
874: REQUEST_ID = req_id,
875: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id,
876: PROGRAM_ID = arp_standard.profile.program_id,
877: PROGRAM_UPDATE_DATE = SYSDATE

Line 875: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id,

871: LAST_UPDATE_DATE = SYSDATE,
872: last_updated_by = arp_standard.profile.user_id,
873: last_update_login = arp_standard.profile.last_update_login,
874: REQUEST_ID = req_id,
875: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id,
876: PROGRAM_ID = arp_standard.profile.program_id,
877: PROGRAM_UPDATE_DATE = SYSDATE
878: WHERE LOCATION_ID = PRIMARY_KEY_ID_LIST(I);
879:

Line 876: PROGRAM_ID = arp_standard.profile.program_id,

872: last_updated_by = arp_standard.profile.user_id,
873: last_update_login = arp_standard.profile.last_update_login,
874: REQUEST_ID = req_id,
875: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id,
876: PROGRAM_ID = arp_standard.profile.program_id,
877: PROGRAM_UPDATE_DATE = SYSDATE
878: WHERE LOCATION_ID = PRIMARY_KEY_ID_LIST(I);
879:
880: g_count := g_count + SQL%ROWCOUNT;