APPS.AMS_SCHEDULERULES_PVT dependencies on AS_IMPORT_INTERFACE

Line 4501: FROM as_import_interface

4497:
4498: -- soagrawa 09-dec-2005 added this cursor for bug 4461415
4499: cursor c_lead_headers(srccd VARCHAR2) is
4500: SELECT IMPORT_INTERFACE_ID
4501: FROM as_import_interface
4502: where promotion_code = srccd;
4503:
4504:
4505: CURSOR c_batch_id IS

Line 4510: SELECT AS_IMPORT_INTERFACE_S.NEXTVAL

4506: SELECT as_sl_imp_batch_s.NEXTVAL
4507: FROM DUAL;
4508:
4509: CURSOR c_lead_header_id_csr IS
4510: SELECT AS_IMPORT_INTERFACE_S.NEXTVAL
4511: FROM dual;
4512:
4513: CURSOR c_lead_header_id_exists_csr (l_id IN NUMBER) IS
4514: SELECT 1 FROM dual

Line 4515: WHERE EXISTS (SELECT 1 FROM as_import_interface

4511: FROM dual;
4512:
4513: CURSOR c_lead_header_id_exists_csr (l_id IN NUMBER) IS
4514: SELECT 1 FROM dual
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

Line 4529: FROM as_import_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(*)
4529: FROM as_import_interface
4530: WHERE batch_id = batch_id_in;
4531:
4532: l_assoc_product_row c_assoc_products_csr%ROWTYPE;
4533: l_schedule_details c_schedule_details_csr%ROWTYPE;

Line 4536: TYPE Lead_Header_Id_Table IS TABLE OF as_import_interface.IMPORT_INTERFACE_ID%TYPE;

4532: l_assoc_product_row c_assoc_products_csr%ROWTYPE;
4533: l_schedule_details c_schedule_details_csr%ROWTYPE;
4534: l_contact_party_details c_party_relationships_csr%ROWTYPE;
4535:
4536: TYPE Lead_Header_Id_Table IS TABLE OF as_import_interface.IMPORT_INTERFACE_ID%TYPE;
4537: l_lead_header_ids Lead_Header_Id_Table; -- no need to initialize
4538:
4539: TYPE Main_Party_Id_Table IS TABLE OF hz_parties.PARTY_ID%TYPE;
4540: l_main_party_ids Main_Party_Id_Table; -- no need to initialize

Line 4666: -- insert in as_import_interface based on target group entry details

4662: );
4663:
4664: --now generate lead headers for all parties by bulk insert
4665: FORALL j IN l_main_party_ids.FIRST..l_main_party_ids.LAST
4666: -- insert in as_import_interface based on target group entry details
4667: INSERT INTO as_import_interface
4668: (
4669: IMPORT_INTERFACE_ID --NOT NULL NUMBER
4670: , LAST_UPDATE_DATE --NOT NULL DATE

Line 4667: INSERT INTO as_import_interface

4663:
4664: --now generate lead headers for all parties by bulk insert
4665: FORALL j IN l_main_party_ids.FIRST..l_main_party_ids.LAST
4666: -- insert in as_import_interface based on target group entry details
4667: INSERT INTO as_import_interface
4668: (
4669: IMPORT_INTERFACE_ID --NOT NULL NUMBER
4670: , LAST_UPDATE_DATE --NOT NULL DATE
4671: , LAST_UPDATED_BY --NOT NULL NUMBER

Line 4694: AS_IMPORT_INTERFACE_S.NEXTVAL --IMPORT_INTERFACE_ID --NOT NULL NUMBER

4690: ,offer_id --anchaudh added for bug#4957178
4691: )
4692: VALUES
4693: (
4694: AS_IMPORT_INTERFACE_S.NEXTVAL --IMPORT_INTERFACE_ID --NOT NULL NUMBER
4695: , SYSDATE --LAST_UPDATE_DATE --NOT NULL DATE
4696: , FND_GLOBAL.user_id --LAST_UPDATED_BY --NOT NULL NUMBER
4697: , SYSDATE --CREATION_DATE --NOT NULL DATE
4698: , FND_GLOBAL.user_id --CREATED_BY --NOT NULL NUMBER

Line 4798: -- At this point we will have added all the records in as_import_interface table.

4794: IF (AMS_DEBUG_HIGH_ON) THEN
4795: AMS_UTILITY_Pvt.debug_message('generate_leads: No. of Products/Categories : '||TO_CHAR(l_no_of_prods));
4796: END IF;
4797:
4798: -- At this point we will have added all the records in as_import_interface table.
4799: -- Now we can call the concurrent program for lead process.
4800: OPEN c_loaded_rows_for_lead(l_batch_id);
4801: FETCH c_loaded_rows_for_lead INTO l_loaded_rows;
4802: CLOSE c_loaded_rows_for_lead;