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,
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
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:
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;
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,
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
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:
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;