APPS.CSI_ML_UTIL_PVT dependencies on CSI_II_RELATIONSHIPS_H

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 2712: SELECT csi_ii_relationships_h_s.NEXTVAL

2708:
2709: FOR l_ins_rel_csr IN ins_rel_csr(p_worker_id, l_txn_from_date, l_txn_to_date)
2710: LOOP
2711: l_ins:=l_ins+1;
2712: SELECT csi_ii_relationships_h_s.NEXTVAL
2713: INTO l_rel_hist_tbl(l_ins)
2714: FROM dual;
2715:
2716: SELECT csi_ii_relationships_s.NEXTVAL

Line 2821: INSERT INTO CSI_II_RELATIONSHIPS_H(

2817: ,1);
2818:
2819:
2820: FORALL i in 1 .. l_ii_relationship_rec_tab.rel_interface_id.count
2821: INSERT INTO CSI_II_RELATIONSHIPS_H(
2822: RELATIONSHIP_HISTORY_ID
2823: ,RELATIONSHIP_ID
2824: ,TRANSACTION_ID
2825: ,NEW_SUBJECT_ID