APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_I_PARTIES_H

Line 1095: select CSI_I_PARTIES_H_S.nextval

1091: l_count NUMBER;
1092: l_hist_id NUMBER;
1093: BEGIN
1094: l_count := p_party_hist_tbl.count + 1;
1095: select CSI_I_PARTIES_H_S.nextval
1096: into l_hist_id
1097: from sys.dual;
1098: --
1099: p_party_hist_tbl(l_count).INSTANCE_PARTY_HISTORY_ID := l_hist_id;

Line 4173: INSERT INTO CSI_I_PARTIES_H(

4169: --
4170: l_ctr := l_party_hist_rec_tab.instance_party_history_id.count;
4171: --
4172: FORALL i in 1 .. l_ctr
4173: INSERT INTO CSI_I_PARTIES_H(
4174: INSTANCE_PARTY_HISTORY_ID,
4175: INSTANCE_PARTY_ID,
4176: TRANSACTION_ID,
4177: OLD_PARTY_SOURCE_TABLE,

Line 8094: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_del_txn_tbl(j);

8090: DELETE FROM CSI_I_ASSETS WHERE instance_id = l_del_inst_tbl(j);
8091: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8092: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_del_txn_tbl(j);
8093: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8094: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_del_txn_tbl(j);
8095: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8096: DELETE FROM CSI_IP_ACCOUNTS_H WHERE transaction_id = l_del_txn_tbl(j);
8097: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8098: DELETE FROM CSI_I_ORG_ASSIGNMENTS_H WHERE transaction_id = l_del_txn_tbl(j);