APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_I_ORG_ASSIGNMENTS_H

Line 1228: select CSI_I_ORG_ASSIGNMENTS_H_S.nextval

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

Line 4591: INSERT INTO CSI_I_ORG_ASSIGNMENTS_H(

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

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

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);
8099: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8100: DELETE FROM CSI_I_PRICING_ATTRIBS_H WHERE transaction_id = l_del_txn_tbl(j);
8101: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8102: DELETE FROM CSI_I_VERSION_LABELS_H WHERE transaction_id = l_del_txn_tbl(j);