APPS.AMS_IS_LINE_PVT dependencies on AS_IMPORT_INTERFACE_S

Line 531: SELECT AS_IMPORT_INTERFACE_S.NEXTVAL

527: FROM AMS_IMP_SOURCE_LINES
528: where import_source_line_id=p_is_line_rec.import_source_line_id;
529:
530: CURSOR c_get_batch_id IS
531: SELECT AS_IMPORT_INTERFACE_S.NEXTVAL
532: FROM DUAL;
533:
534: -- Hint: Developer need to provide Where clause
535:

Line 958: --1. Increment BATCH_ID FROM AS_IMPORT_INTERFACE_S SEQUENCE.

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:
962: /* OPEN c_get_batch_id;