185: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
186: ,INVOICE_TO_CUST_ACCOUNT_ID=NUM_COL2_NEW_LIST(I)
187: ,END_CUSTOMER_CUST_ACCOUNT_ID=NUM_COL3_NEW_LIST(I)
188: , LAST_UPDATE_DATE=SYSDATE
189: , last_updated_by=arp_standard.profile.user_id
190: , last_update_login=arp_standard.profile.last_update_login
191: , REQUEST_ID=req_id
192: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
193: , PROGRAM_ID=arp_standard.profile.program_id
186: ,INVOICE_TO_CUST_ACCOUNT_ID=NUM_COL2_NEW_LIST(I)
187: ,END_CUSTOMER_CUST_ACCOUNT_ID=NUM_COL3_NEW_LIST(I)
188: , LAST_UPDATE_DATE=SYSDATE
189: , last_updated_by=arp_standard.profile.user_id
190: , last_update_login=arp_standard.profile.last_update_login
191: , REQUEST_ID=req_id
192: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
193: , PROGRAM_ID=arp_standard.profile.program_id
194: , PROGRAM_UPDATE_DATE=SYSDATE
188: , LAST_UPDATE_DATE=SYSDATE
189: , last_updated_by=arp_standard.profile.user_id
190: , last_update_login=arp_standard.profile.last_update_login
191: , REQUEST_ID=req_id
192: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
193: , PROGRAM_ID=arp_standard.profile.program_id
194: , PROGRAM_UPDATE_DATE=SYSDATE
195: WHERE QUOTE_HEADER_ID=PRIMARY_KEY_ID_LIST(I)
196: ;
189: , last_updated_by=arp_standard.profile.user_id
190: , last_update_login=arp_standard.profile.last_update_login
191: , REQUEST_ID=req_id
192: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
193: , PROGRAM_ID=arp_standard.profile.program_id
194: , PROGRAM_UPDATE_DATE=SYSDATE
195: WHERE QUOTE_HEADER_ID=PRIMARY_KEY_ID_LIST(I)
196: ;
197:
375: UPDATE ASO_QUOTE_LINES yt SET
376: INVOICE_TO_CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
377: , END_CUSTOMER_CUST_ACCOUNT_ID=NUM_COL2_NEW_LIST(I)
378: , LAST_UPDATE_DATE=SYSDATE
379: , last_updated_by=arp_standard.profile.user_id
380: , last_update_login=arp_standard.profile.last_update_login
381: , REQUEST_ID=req_id
382: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
383: , PROGRAM_ID=arp_standard.profile.program_id
376: INVOICE_TO_CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
377: , END_CUSTOMER_CUST_ACCOUNT_ID=NUM_COL2_NEW_LIST(I)
378: , LAST_UPDATE_DATE=SYSDATE
379: , last_updated_by=arp_standard.profile.user_id
380: , last_update_login=arp_standard.profile.last_update_login
381: , REQUEST_ID=req_id
382: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
383: , PROGRAM_ID=arp_standard.profile.program_id
384: , PROGRAM_UPDATE_DATE=SYSDATE
378: , LAST_UPDATE_DATE=SYSDATE
379: , last_updated_by=arp_standard.profile.user_id
380: , last_update_login=arp_standard.profile.last_update_login
381: , REQUEST_ID=req_id
382: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
383: , PROGRAM_ID=arp_standard.profile.program_id
384: , PROGRAM_UPDATE_DATE=SYSDATE
385: WHERE QUOTE_LINE_ID=PRIMARY_KEY_ID_LIST(I)
386: ;
379: , last_updated_by=arp_standard.profile.user_id
380: , last_update_login=arp_standard.profile.last_update_login
381: , REQUEST_ID=req_id
382: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
383: , PROGRAM_ID=arp_standard.profile.program_id
384: , PROGRAM_UPDATE_DATE=SYSDATE
385: WHERE QUOTE_LINE_ID=PRIMARY_KEY_ID_LIST(I)
386: ;
387:
536: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
537: UPDATE ASO_SHIPMENTS yt SET
538: SHIP_TO_CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
539: , LAST_UPDATE_DATE=SYSDATE
540: , last_updated_by=arp_standard.profile.user_id
541: , last_update_login=arp_standard.profile.last_update_login
542: , REQUEST_ID=req_id
543: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
544: , PROGRAM_ID=arp_standard.profile.program_id
537: UPDATE ASO_SHIPMENTS yt SET
538: SHIP_TO_CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
539: , LAST_UPDATE_DATE=SYSDATE
540: , last_updated_by=arp_standard.profile.user_id
541: , last_update_login=arp_standard.profile.last_update_login
542: , REQUEST_ID=req_id
543: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
544: , PROGRAM_ID=arp_standard.profile.program_id
545: , PROGRAM_UPDATE_DATE=SYSDATE
539: , LAST_UPDATE_DATE=SYSDATE
540: , last_updated_by=arp_standard.profile.user_id
541: , last_update_login=arp_standard.profile.last_update_login
542: , REQUEST_ID=req_id
543: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
544: , PROGRAM_ID=arp_standard.profile.program_id
545: , PROGRAM_UPDATE_DATE=SYSDATE
546: WHERE SHIPMENT_ID=PRIMARY_KEY_ID_LIST(I)
547: ;
540: , last_updated_by=arp_standard.profile.user_id
541: , last_update_login=arp_standard.profile.last_update_login
542: , REQUEST_ID=req_id
543: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
544: , PROGRAM_ID=arp_standard.profile.program_id
545: , PROGRAM_UPDATE_DATE=SYSDATE
546: WHERE SHIPMENT_ID=PRIMARY_KEY_ID_LIST(I)
547: ;
548: l_count := l_count + SQL%ROWCOUNT;