APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_I_PARTIES_H

Line 1092: select CSI_I_PARTIES_H_S.nextval

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

Line 4170: INSERT INTO CSI_I_PARTIES_H(

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

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

7553: DELETE FROM CSI_I_ASSETS WHERE instance_id = l_del_inst_tbl(j);
7554: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7555: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_del_txn_tbl(j);
7556: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7557: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_del_txn_tbl(j);
7558: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7559: DELETE FROM CSI_IP_ACCOUNTS_H WHERE transaction_id = l_del_txn_tbl(j);
7560: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7561: DELETE FROM CSI_I_ORG_ASSIGNMENTS_H WHERE transaction_id = l_del_txn_tbl(j);