140: customer_id=NUM_COL1_NEW_LIST(I)
141: ,ship_id=NUM_COL2_NEW_LIST(I)
142: ,bill_id=NUM_COL3_NEW_LIST(I)
143: , LAST_UPDATE_DATE=SYSDATE
144: , last_updated_by=arp_standard.profile.user_id
145: , last_update_login=arp_standard.profile.last_update_login
146: , REQUEST_ID=req_id
147: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
148: , PROGRAM_ID=arp_standard.profile.program_id
141: ,ship_id=NUM_COL2_NEW_LIST(I)
142: ,bill_id=NUM_COL3_NEW_LIST(I)
143: , LAST_UPDATE_DATE=SYSDATE
144: , last_updated_by=arp_standard.profile.user_id
145: , last_update_login=arp_standard.profile.last_update_login
146: , REQUEST_ID=req_id
147: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
148: , PROGRAM_ID=arp_standard.profile.program_id
149: , PROGRAM_UPDATE_DATE=SYSDATE
143: , LAST_UPDATE_DATE=SYSDATE
144: , last_updated_by=arp_standard.profile.user_id
145: , last_update_login=arp_standard.profile.last_update_login
146: , REQUEST_ID=req_id
147: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
148: , PROGRAM_ID=arp_standard.profile.program_id
149: , PROGRAM_UPDATE_DATE=SYSDATE
150: WHERE TRANSACTION_ID=PRIMARY_KEY_ID_LIST(I)
151: ;
144: , last_updated_by=arp_standard.profile.user_id
145: , last_update_login=arp_standard.profile.last_update_login
146: , REQUEST_ID=req_id
147: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
148: , PROGRAM_ID=arp_standard.profile.program_id
149: , PROGRAM_UPDATE_DATE=SYSDATE
150: WHERE TRANSACTION_ID=PRIMARY_KEY_ID_LIST(I)
151: ;
152: l_count := l_count + SQL%ROWCOUNT;
309: customer_id=NUM_COL1_NEW_LIST(I)
310: ,ship_id=NUM_COL2_NEW_LIST(I)
311: ,bill_id=NUM_COL3_NEW_LIST(I)
312: , LAST_UPDATE_DATE=SYSDATE
313: , last_updated_by=arp_standard.profile.user_id
314: , last_update_login=arp_standard.profile.last_update_login
315: , REQUEST_ID=req_id
316: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
317: , PROGRAM_ID=arp_standard.profile.program_id
310: ,ship_id=NUM_COL2_NEW_LIST(I)
311: ,bill_id=NUM_COL3_NEW_LIST(I)
312: , LAST_UPDATE_DATE=SYSDATE
313: , last_updated_by=arp_standard.profile.user_id
314: , last_update_login=arp_standard.profile.last_update_login
315: , REQUEST_ID=req_id
316: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
317: , PROGRAM_ID=arp_standard.profile.program_id
318: , PROGRAM_UPDATE_DATE=SYSDATE
312: , LAST_UPDATE_DATE=SYSDATE
313: , last_updated_by=arp_standard.profile.user_id
314: , last_update_login=arp_standard.profile.last_update_login
315: , REQUEST_ID=req_id
316: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
317: , PROGRAM_ID=arp_standard.profile.program_id
318: , PROGRAM_UPDATE_DATE=SYSDATE
319: WHERE ORGANIZATION_ID=PRIMARY_KEY1_LIST(I)
320: AND FORECAST_DESIGNATOR=PRIMARY_KEY2_LIST(I)
313: , last_updated_by=arp_standard.profile.user_id
314: , last_update_login=arp_standard.profile.last_update_login
315: , REQUEST_ID=req_id
316: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
317: , PROGRAM_ID=arp_standard.profile.program_id
318: , PROGRAM_UPDATE_DATE=SYSDATE
319: WHERE ORGANIZATION_ID=PRIMARY_KEY1_LIST(I)
320: AND FORECAST_DESIGNATOR=PRIMARY_KEY2_LIST(I)
321: ;
471: customer_id=NUM_COL1_NEW_LIST(I)
472: ,ship_id=NUM_COL2_NEW_LIST(I)
473: ,bill_id=NUM_COL3_NEW_LIST(I)
474: , LAST_UPDATE_DATE=SYSDATE
475: , last_updated_by=arp_standard.profile.user_id
476: , last_update_login=arp_standard.profile.last_update_login
477: , REQUEST_ID=req_id
478: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
479: , PROGRAM_ID=arp_standard.profile.program_id
472: ,ship_id=NUM_COL2_NEW_LIST(I)
473: ,bill_id=NUM_COL3_NEW_LIST(I)
474: , LAST_UPDATE_DATE=SYSDATE
475: , last_updated_by=arp_standard.profile.user_id
476: , last_update_login=arp_standard.profile.last_update_login
477: , REQUEST_ID=req_id
478: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
479: , PROGRAM_ID=arp_standard.profile.program_id
480: , PROGRAM_UPDATE_DATE=SYSDATE
474: , LAST_UPDATE_DATE=SYSDATE
475: , last_updated_by=arp_standard.profile.user_id
476: , last_update_login=arp_standard.profile.last_update_login
477: , REQUEST_ID=req_id
478: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
479: , PROGRAM_ID=arp_standard.profile.program_id
480: , PROGRAM_UPDATE_DATE=SYSDATE
481: WHERE TRANSACTION_ID=PRIMARY_KEY_ID_LIST(I)
482: AND CUSTOMER_ID=NUM_COL1_ORIG_LIST(I)
475: , last_updated_by=arp_standard.profile.user_id
476: , last_update_login=arp_standard.profile.last_update_login
477: , REQUEST_ID=req_id
478: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
479: , PROGRAM_ID=arp_standard.profile.program_id
480: , PROGRAM_UPDATE_DATE=SYSDATE
481: WHERE TRANSACTION_ID=PRIMARY_KEY_ID_LIST(I)
482: AND CUSTOMER_ID=NUM_COL1_ORIG_LIST(I)
483: AND NVL(SHIP_ID,-23453)=NVL(NUM_COL2_ORIG_LIST(I),-23453)
678: ,previous_customer_id=NUM_COL4_NEW_LIST(I)
679: ,previous_bill_id=NUM_COL5_NEW_LIST(I)
680: ,previous_ship_id=NUM_COL6_NEW_LIST(I)
681: , LAST_UPDATE_DATE=SYSDATE
682: , last_updated_by=arp_standard.profile.user_id
683: , last_update_login=arp_standard.profile.last_update_login
684: , REQUEST_ID=req_id
685: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
686: , PROGRAM_ID=arp_standard.profile.program_id
679: ,previous_bill_id=NUM_COL5_NEW_LIST(I)
680: ,previous_ship_id=NUM_COL6_NEW_LIST(I)
681: , LAST_UPDATE_DATE=SYSDATE
682: , last_updated_by=arp_standard.profile.user_id
683: , last_update_login=arp_standard.profile.last_update_login
684: , REQUEST_ID=req_id
685: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
686: , PROGRAM_ID=arp_standard.profile.program_id
687: , PROGRAM_UPDATE_DATE=SYSDATE
681: , LAST_UPDATE_DATE=SYSDATE
682: , last_updated_by=arp_standard.profile.user_id
683: , last_update_login=arp_standard.profile.last_update_login
684: , REQUEST_ID=req_id
685: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
686: , PROGRAM_ID=arp_standard.profile.program_id
687: , PROGRAM_UPDATE_DATE=SYSDATE
688: WHERE UPDATE_SEQ_NUM=PRIMARY_KEY_ID_LIST(I)
689: ;
682: , last_updated_by=arp_standard.profile.user_id
683: , last_update_login=arp_standard.profile.last_update_login
684: , REQUEST_ID=req_id
685: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
686: , PROGRAM_ID=arp_standard.profile.program_id
687: , PROGRAM_UPDATE_DATE=SYSDATE
688: WHERE UPDATE_SEQ_NUM=PRIMARY_KEY_ID_LIST(I)
689: ;
690: l_count := l_count + SQL%ROWCOUNT;
823: UPDATE MRP_SR_ASSIGNMENTS yt SET
824: customer_id=NUM_COL1_NEW_LIST(I)
825: ,ship_to_site_id=NUM_COL2_NEW_LIST(I)
826: , LAST_UPDATE_DATE=SYSDATE
827: , last_updated_by=arp_standard.profile.user_id
828: , last_update_login=arp_standard.profile.last_update_login
829: , REQUEST_ID=req_id
830: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
831: , PROGRAM_ID=arp_standard.profile.program_id
824: customer_id=NUM_COL1_NEW_LIST(I)
825: ,ship_to_site_id=NUM_COL2_NEW_LIST(I)
826: , LAST_UPDATE_DATE=SYSDATE
827: , last_updated_by=arp_standard.profile.user_id
828: , last_update_login=arp_standard.profile.last_update_login
829: , REQUEST_ID=req_id
830: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
831: , PROGRAM_ID=arp_standard.profile.program_id
832: , PROGRAM_UPDATE_DATE=SYSDATE
826: , LAST_UPDATE_DATE=SYSDATE
827: , last_updated_by=arp_standard.profile.user_id
828: , last_update_login=arp_standard.profile.last_update_login
829: , REQUEST_ID=req_id
830: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
831: , PROGRAM_ID=arp_standard.profile.program_id
832: , PROGRAM_UPDATE_DATE=SYSDATE
833: WHERE ASSIGNMENT_ID=PRIMARY_KEY_ID_LIST(I)
834: ;
827: , last_updated_by=arp_standard.profile.user_id
828: , last_update_login=arp_standard.profile.last_update_login
829: , REQUEST_ID=req_id
830: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
831: , PROGRAM_ID=arp_standard.profile.program_id
832: , PROGRAM_UPDATE_DATE=SYSDATE
833: WHERE ASSIGNMENT_ID=PRIMARY_KEY_ID_LIST(I)
834: ;
835: l_count := l_count + SQL%ROWCOUNT;