APPS.AMS_SCHEDULERULES_PVT dependencies on AS_IMP_LINES_INTERFACE

Line 4519: SELECT AS_IMP_LINES_INTERFACE_S.NEXTVAL

4515: WHERE EXISTS (SELECT 1 FROM as_import_interface
4516: WHERE import_interface_id = l_id);
4517:
4518: CURSOR c_lead_line_id_csr IS
4519: SELECT AS_IMP_LINES_INTERFACE_S.NEXTVAL
4520: FROM dual;
4521:
4522: CURSOR c_lead_line_id_exists_csr (l_id IN NUMBER) IS
4523: SELECT 1 FROM dual

Line 4524: WHERE EXISTS (SELECT 1 FROM as_imp_lines_interface

4520: FROM dual;
4521:
4522: CURSOR c_lead_line_id_exists_csr (l_id IN NUMBER) IS
4523: SELECT 1 FROM dual
4524: WHERE EXISTS (SELECT 1 FROM as_imp_lines_interface
4525: WHERE imp_lines_interface_id = l_id);
4526:
4527: CURSOR c_loaded_rows_for_lead (batch_id_in IN NUMBER) IS
4528: SELECT COUNT(*)

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

4749:
4750: l_no_of_prods := l_no_of_prods+1;
4751:
4752: FORALL j IN l_lead_header_ids.FIRST..l_lead_header_ids.LAST
4753: --bulk insert each Product/Product Category in as_imp_lines_interface table
4754: INSERT INTO as_imp_lines_interface
4755: (
4756: IMP_LINES_INTERFACE_ID --NOT NULL NUMBER
4757: , IMPORT_INTERFACE_ID --NOT NULL NUMBER

Line 4754: INSERT INTO as_imp_lines_interface

4750: l_no_of_prods := l_no_of_prods+1;
4751:
4752: FORALL j IN l_lead_header_ids.FIRST..l_lead_header_ids.LAST
4753: --bulk insert each Product/Product Category in as_imp_lines_interface table
4754: INSERT INTO as_imp_lines_interface
4755: (
4756: IMP_LINES_INTERFACE_ID --NOT NULL NUMBER
4757: , IMPORT_INTERFACE_ID --NOT NULL NUMBER
4758: , LAST_UPDATE_DATE --NOT NULL DATE

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

4766: , SOURCE_PROMOTION_ID --NUMBER
4767: )
4768: VALUES
4769: (
4770: AS_IMP_LINES_INTERFACE_S.NEXTVAL --IMP_LINES_INTERFACE_ID --NOT NULL NUMBER
4771: , l_lead_header_ids(j) --IMPORT_INTERFACE_ID --NOT NULL NUMBER
4772: , SYSDATE --LAST_UPDATE_DATE --NOT NULL DATE
4773: , FND_GLOBAL.user_id --LAST_UPDATED_BY --NOT NULL NUMBER
4774: , SYSDATE --CREATION_DATE --NOT NULL DATE