APPS.AMS_IS_LINE_PVT dependencies on AMS_IMP_LIST_HEADERS_ALL

Line 957: --In AMS_IMP_LIST_HEADERS_ALL

953:
954: ); --For Error handling and Correction Update LOAD_STATUS = 'RELOAD'
955:
956:
957: --In AMS_IMP_LIST_HEADERS_ALL
958: --1. Increment BATCH_ID FROM AS_IMPORT_INTERFACE_S SEQUENCE.
959: --2. Update the STATUS_CODE = 'STAGED'
960: --3. Update EXECUTE_MODE = 'R'
961:

Line 972: UPDATE ams_imp_list_headers_all

968: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
969: system_status_code = 'STAGED';
970: */
971:
972: UPDATE ams_imp_list_headers_all
973: SET
974: -- batch_id =l_batchId
975: -- , status_code = 'STAGED'
976: execute_mode = 'R'