APPS.CSI_ML_UTIL_PVT dependencies on CSI_TRANSACTIONS

Line 2705: -- ,csi_ii_relationships_h and csi_transactions

2701: ELSIF p_mode='INSERT'
2702: THEN
2703: FND_File.Put_Line(Fnd_File.LOG,'Inside for Insert mode');
2704: -- This run also has to insert records into csi_ii_relationships
2705: -- ,csi_ii_relationships_h and csi_transactions
2706: l_ins:=0;
2707: l_txn_type_id := csi_ml_util_pvt.get_txn_type_id('OPEN_INTERFACE','CSI');
2708:
2709: FOR l_ins_rel_csr IN ins_rel_csr(p_worker_id, l_txn_from_date, l_txn_to_date)

Line 2720: SELECT csi_transactions_s.NEXTVAL

2716: SELECT csi_ii_relationships_s.NEXTVAL
2717: INTO l_ii_relationship_rec_tab.rel_interface_id(l_ins)
2718: FROM dual;
2719:
2720: SELECT csi_transactions_s.NEXTVAL
2721: INTO l_txn_id_tbl(l_ins)
2722: FROM dual;
2723:
2724: l_status_array(l_ins) := 'P';

Line 2888: INSERT INTO CSI_TRANSACTIONS(

2884: ,1);
2885:
2886:
2887: FORALL i in 1 .. l_txn_id_tbl.count
2888: INSERT INTO CSI_TRANSACTIONS(
2889: TRANSACTION_ID
2890: ,TRANSACTION_DATE
2891: ,SOURCE_TRANSACTION_DATE
2892: ,SOURCE_HEADER_REF