123: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
124: UPDATE XDP_ORDER_HEADERS yt SET
125: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
126: , LAST_UPDATE_DATE=SYSDATE
127: , last_updated_by=arp_standard.profile.user_id
128: , last_update_login=arp_standard.profile.last_update_login
129: -- , REQUEST_ID=request_id
130: -- , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
131: -- , PROGRAM_ID=arp_standard.profile.program_id
124: UPDATE XDP_ORDER_HEADERS yt SET
125: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
126: , LAST_UPDATE_DATE=SYSDATE
127: , last_updated_by=arp_standard.profile.user_id
128: , last_update_login=arp_standard.profile.last_update_login
129: -- , REQUEST_ID=request_id
130: -- , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
131: -- , PROGRAM_ID=arp_standard.profile.program_id
132: -- , PROGRAM_UPDATE_DATE=SYSDATE
126: , LAST_UPDATE_DATE=SYSDATE
127: , last_updated_by=arp_standard.profile.user_id
128: , last_update_login=arp_standard.profile.last_update_login
129: -- , REQUEST_ID=request_id
130: -- , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
131: -- , PROGRAM_ID=arp_standard.profile.program_id
132: -- , PROGRAM_UPDATE_DATE=SYSDATE
133: WHERE ORDER_ID=PRIMARY_KEY_ID_LIST(I)
134: ;
127: , last_updated_by=arp_standard.profile.user_id
128: , last_update_login=arp_standard.profile.last_update_login
129: -- , REQUEST_ID=request_id
130: -- , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
131: -- , PROGRAM_ID=arp_standard.profile.program_id
132: -- , PROGRAM_UPDATE_DATE=SYSDATE
133: WHERE ORDER_ID=PRIMARY_KEY_ID_LIST(I)
134: ;
135: l_count := l_count + SQL%ROWCOUNT;
201: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
202: UPDATE XDP_ORDER_LINE_ITEMS yt SET
203: SITE_USE_ID=NUM_COL1_NEW_LIST1(I)
204: , LAST_UPDATE_DATE=SYSDATE
205: , last_updated_by=arp_standard.profile.user_id
206: , last_update_login=arp_standard.profile.last_update_login
207: -- , REQUEST_ID=request_id
208: -- , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
209: -- , PROGRAM_ID=arp_standard.profile.program_id
202: UPDATE XDP_ORDER_LINE_ITEMS yt SET
203: SITE_USE_ID=NUM_COL1_NEW_LIST1(I)
204: , LAST_UPDATE_DATE=SYSDATE
205: , last_updated_by=arp_standard.profile.user_id
206: , last_update_login=arp_standard.profile.last_update_login
207: -- , REQUEST_ID=request_id
208: -- , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
209: -- , PROGRAM_ID=arp_standard.profile.program_id
210: -- , PROGRAM_UPDATE_DATE=SYSDATE
204: , LAST_UPDATE_DATE=SYSDATE
205: , last_updated_by=arp_standard.profile.user_id
206: , last_update_login=arp_standard.profile.last_update_login
207: -- , REQUEST_ID=request_id
208: -- , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
209: -- , PROGRAM_ID=arp_standard.profile.program_id
210: -- , PROGRAM_UPDATE_DATE=SYSDATE
211: WHERE LINE_ITEM_ID=PRIMARY_KEY_ID_LIST1(I)
212: ;
205: , last_updated_by=arp_standard.profile.user_id
206: , last_update_login=arp_standard.profile.last_update_login
207: -- , REQUEST_ID=request_id
208: -- , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
209: -- , PROGRAM_ID=arp_standard.profile.program_id
210: -- , PROGRAM_UPDATE_DATE=SYSDATE
211: WHERE LINE_ITEM_ID=PRIMARY_KEY_ID_LIST1(I)
212: ;
213: l_count := l_count + SQL%ROWCOUNT;