APPS.AMS_SCHEDULERULES_PVT dependencies on AS_IMP_LINES_INTERFACE

Line 4549: SELECT AS_IMP_LINES_INTERFACE_S.NEXTVAL

4545: WHERE EXISTS (SELECT 1 FROM as_import_interface
4546: WHERE import_interface_id = l_id);
4547:
4548: CURSOR c_lead_line_id_csr IS
4549: SELECT AS_IMP_LINES_INTERFACE_S.NEXTVAL
4550: FROM dual;
4551:
4552: CURSOR c_lead_line_id_exists_csr (l_id IN NUMBER) IS
4553: SELECT 1 FROM dual

Line 4554: WHERE EXISTS (SELECT 1 FROM as_imp_lines_interface

4550: FROM dual;
4551:
4552: CURSOR c_lead_line_id_exists_csr (l_id IN NUMBER) IS
4553: SELECT 1 FROM dual
4554: WHERE EXISTS (SELECT 1 FROM as_imp_lines_interface
4555: WHERE imp_lines_interface_id = l_id);
4556:
4557: CURSOR c_loaded_rows_for_lead (batch_id_in IN NUMBER) IS
4558: SELECT COUNT(*)

Line 4783: --bulk insert each Product/Product Category in as_imp_lines_interface table

4779:
4780: l_no_of_prods := l_no_of_prods+1;
4781:
4782: FORALL j IN l_lead_header_ids.FIRST..l_lead_header_ids.LAST
4783: --bulk insert each Product/Product Category in as_imp_lines_interface table
4784: INSERT INTO as_imp_lines_interface
4785: (
4786: IMP_LINES_INTERFACE_ID --NOT NULL NUMBER
4787: , IMPORT_INTERFACE_ID --NOT NULL NUMBER

Line 4784: INSERT INTO as_imp_lines_interface

4780: l_no_of_prods := l_no_of_prods+1;
4781:
4782: FORALL j IN l_lead_header_ids.FIRST..l_lead_header_ids.LAST
4783: --bulk insert each Product/Product Category in as_imp_lines_interface table
4784: INSERT INTO as_imp_lines_interface
4785: (
4786: IMP_LINES_INTERFACE_ID --NOT NULL NUMBER
4787: , IMPORT_INTERFACE_ID --NOT NULL NUMBER
4788: , LAST_UPDATE_DATE --NOT NULL DATE

Line 4800: AS_IMP_LINES_INTERFACE_S.NEXTVAL --IMP_LINES_INTERFACE_ID --NOT NULL NUMBER

4796: , SOURCE_PROMOTION_ID --NUMBER
4797: )
4798: VALUES
4799: (
4800: AS_IMP_LINES_INTERFACE_S.NEXTVAL --IMP_LINES_INTERFACE_ID --NOT NULL NUMBER
4801: , l_lead_header_ids(j) --IMPORT_INTERFACE_ID --NOT NULL NUMBER
4802: , SYSDATE --LAST_UPDATE_DATE --NOT NULL DATE
4803: , FND_GLOBAL.user_id --LAST_UPDATED_BY --NOT NULL NUMBER
4804: , SYSDATE --CREATION_DATE --NOT NULL DATE