DBA Data[Home] [Help]

APPS.ASO_MERGE_PVT dependencies on STANDARD

Line 189: , last_updated_by=arp_standard.profile.user_id

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

Line 190: , last_update_login=arp_standard.profile.last_update_login

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

Line 192: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

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

Line 193: , PROGRAM_ID=arp_standard.profile.program_id

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:

Line 379: , last_updated_by=arp_standard.profile.user_id

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

Line 380: , last_update_login=arp_standard.profile.last_update_login

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

Line 382: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

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

Line 383: , PROGRAM_ID=arp_standard.profile.program_id

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:

Line 540: , last_updated_by=arp_standard.profile.user_id

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

Line 541: , last_update_login=arp_standard.profile.last_update_login

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

Line 543: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

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

Line 544: , PROGRAM_ID=arp_standard.profile.program_id

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;