APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_I_ORG_ASSIGNMENTS

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 4521: INSERT INTO CSI_I_ORG_ASSIGNMENTS(

4517: --
4518: l_ctr := l_org_units_rec_tab.instance_ou_id.count;
4519: --
4520: FORALL i in 1 .. l_ctr
4521: INSERT INTO CSI_I_ORG_ASSIGNMENTS(
4522: INSTANCE_OU_ID,
4523: INSTANCE_ID,
4524: OPERATING_UNIT_ID,
4525: RELATIONSHIP_TYPE_CODE,

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 8082: DELETE FROM CSI_I_ORG_ASSIGNMENTS WHERE instance_id = l_del_inst_tbl(j);

8078: from CSI_I_PARTIES WHERE instance_id = l_del_inst_tbl(j));
8079: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8080: DELETE FROM CSI_I_PARTIES WHERE instance_id = l_del_inst_tbl(j);
8081: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8082: DELETE FROM CSI_I_ORG_ASSIGNMENTS WHERE instance_id = l_del_inst_tbl(j);
8083: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8084: DELETE FROM CSI_I_PRICING_ATTRIBS WHERE instance_id = l_del_inst_tbl(j);
8085: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8086: DELETE FROM CSI_I_VERSION_LABELS WHERE instance_id = l_del_inst_tbl(j);

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);