DBA Data[Home] [Help]

APPS.MRPP_CMERGE_FCST dependencies on ARP_STANDARD

Line 144: , last_updated_by=arp_standard.profile.user_id

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

Line 145: , last_update_login=arp_standard.profile.last_update_login

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

Line 147: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

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

Line 148: , PROGRAM_ID=arp_standard.profile.program_id

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;

Line 313: , last_updated_by=arp_standard.profile.user_id

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

Line 314: , last_update_login=arp_standard.profile.last_update_login

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

Line 316: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

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)

Line 317: , PROGRAM_ID=arp_standard.profile.program_id

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

Line 475: , last_updated_by=arp_standard.profile.user_id

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

Line 476: , last_update_login=arp_standard.profile.last_update_login

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

Line 478: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

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)

Line 479: , PROGRAM_ID=arp_standard.profile.program_id

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)

Line 682: , last_updated_by=arp_standard.profile.user_id

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

Line 683: , last_update_login=arp_standard.profile.last_update_login

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

Line 685: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

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

Line 686: , PROGRAM_ID=arp_standard.profile.program_id

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;

Line 987: , last_updated_by=arp_standard.profile.user_id

983: UPDATE MRP_SR_ASSIGNMENTS yt SET
984: customer_id=NUM_COL1_NEW_LIST(I)
985: ,ship_to_site_id=NUM_COL2_NEW_LIST(I)
986: , LAST_UPDATE_DATE=SYSDATE
987: , last_updated_by=arp_standard.profile.user_id
988: , last_update_login=arp_standard.profile.last_update_login
989: , REQUEST_ID=req_id
990: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
991: , PROGRAM_ID=arp_standard.profile.program_id

Line 988: , last_update_login=arp_standard.profile.last_update_login

984: customer_id=NUM_COL1_NEW_LIST(I)
985: ,ship_to_site_id=NUM_COL2_NEW_LIST(I)
986: , LAST_UPDATE_DATE=SYSDATE
987: , last_updated_by=arp_standard.profile.user_id
988: , last_update_login=arp_standard.profile.last_update_login
989: , REQUEST_ID=req_id
990: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
991: , PROGRAM_ID=arp_standard.profile.program_id
992: , PROGRAM_UPDATE_DATE=SYSDATE

Line 990: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

986: , LAST_UPDATE_DATE=SYSDATE
987: , last_updated_by=arp_standard.profile.user_id
988: , last_update_login=arp_standard.profile.last_update_login
989: , REQUEST_ID=req_id
990: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
991: , PROGRAM_ID=arp_standard.profile.program_id
992: , PROGRAM_UPDATE_DATE=SYSDATE
993: WHERE ASSIGNMENT_ID=PRIMARY_KEY_ID_LIST(I)
994: ;

Line 991: , PROGRAM_ID=arp_standard.profile.program_id

987: , last_updated_by=arp_standard.profile.user_id
988: , last_update_login=arp_standard.profile.last_update_login
989: , REQUEST_ID=req_id
990: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
991: , PROGRAM_ID=arp_standard.profile.program_id
992: , PROGRAM_UPDATE_DATE=SYSDATE
993: WHERE ASSIGNMENT_ID=PRIMARY_KEY_ID_LIST(I)
994: ;
995: l_count := l_count + SQL%ROWCOUNT;