[Home] [Help]
1390: l_attendant_for_lead_rec c_get_attendant_for_lead%ROWTYPE;
1391:
1392: CURSOR c_loaded_rows_for_lead (batch_id_in IN NUMBER) IS
1393: SELECT COUNT(*)
1394: FROM as_import_interface
1395: WHERE batch_id = batch_id_in;
1396:
1397: -- dbiswas 23-apr-2003 added cursor for NI bug# 2610067 carryforward to next releases
1398: CURSOR c_get_person_id (rel_party_id_in IN NUMBER) IS
1602: CLOSE c_get_reg_att_for_lead;
1603:
1604:
1605:
1606: -- At this point we will have added all the records in as_import_interface table.
1607: -- Now we can call the concurrent program for lead process.
1608:
1609: OPEN c_loaded_rows_for_lead(l_lit_batch_id);
1610: FETCH c_loaded_rows_for_lead INTO l_loaded_rows;
1671: l_party_type VARCHAR2(30); --party_type for the p_party_id.
1672: l_party_site_id NUMBER; --primary party_site_id for the party_id from hz_party_sites table.
1673:
1674: CURSOR c_rec_id IS --Cursor to pick up the next value in the sequence.
1675: SELECT as_import_interface_s.NEXTVAL
1676: FROM DUAL;
1677:
1678: --Cursor to pick up the data from HZ_PARTIES table.
1679: CURSOR c_party_info (party_id_in IN NUMBER) IS
1707: OPEN c_party_site_info(p_party_id);
1708: FETCH c_party_site_info INTO l_party_site_id;
1709: CLOSE c_party_site_info;
1710:
1711: -- insert the record in as_import_interface table.
1712:
1713: INSERT INTO as_import_interface
1714: (
1715: IMPORT_INTERFACE_ID --NOT NULL NUMBER
1709: CLOSE c_party_site_info;
1710:
1711: -- insert the record in as_import_interface table.
1712:
1713: INSERT INTO as_import_interface
1714: (
1715: IMPORT_INTERFACE_ID --NOT NULL NUMBER
1716: , LAST_UPDATE_DATE --NOT NULL DATE
1717: , LAST_UPDATED_BY --NOT NULL NUMBER