APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_I_ORG_ASSIGNMENTS_H

Line 1225: select CSI_I_ORG_ASSIGNMENTS_H_S.nextval

1221: l_count NUMBER;
1222: l_hist_id NUMBER;
1223: BEGIN
1224: l_count := p_org_hist_tbl.count + 1;
1225: select CSI_I_ORG_ASSIGNMENTS_H_S.nextval
1226: into l_hist_id
1227: from sys.dual;
1228:
1229: p_org_hist_tbl(l_count).instance_ou_history_id := l_hist_id;

Line 4588: INSERT INTO CSI_I_ORG_ASSIGNMENTS_H(

4584: --
4585: l_ctr := l_org_hist_rec_tab.instance_ou_history_id.count;
4586: --
4587: FORALL i in 1 .. l_ctr
4588: INSERT INTO CSI_I_ORG_ASSIGNMENTS_H(
4589: INSTANCE_OU_HISTORY_ID,
4590: INSTANCE_OU_ID,
4591: TRANSACTION_ID,
4592: OLD_OPERATING_UNIT_ID,

Line 7561: DELETE FROM CSI_I_ORG_ASSIGNMENTS_H WHERE transaction_id = l_del_txn_tbl(j);

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);
7562: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7563: DELETE FROM CSI_I_PRICING_ATTRIBS_H WHERE transaction_id = l_del_txn_tbl(j);
7564: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7565: DELETE FROM CSI_I_VERSION_LABELS_H WHERE transaction_id = l_del_txn_tbl(j);