APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_I_PRICING_ATTRIBS

Line 1288: select CSI_I_PRICING_ATTRIBS_H_S.nextval

1284: l_count NUMBER;
1285: l_hist_id NUMBER;
1286: BEGIN
1287: l_count := p_pricing_hist_tbl.count + 1;
1288: select CSI_I_PRICING_ATTRIBS_H_S.nextval
1289: into l_hist_id
1290: from sys.dual;
1291:
1292: p_pricing_hist_tbl(l_count).PRICE_ATTRIB_HISTORY_ID := l_hist_id;

Line 4705: INSERT INTO CSI_I_PRICING_ATTRIBS(

4701: --
4702: l_ctr := l_pricing_rec_tab.pricing_attribute_id.count;
4703: --
4704: FORALL i in 1 .. l_ctr
4705: INSERT INTO CSI_I_PRICING_ATTRIBS(
4706: PRICING_ATTRIBUTE_ID,
4707: INSTANCE_ID,
4708: ACTIVE_START_DATE,
4709: ACTIVE_END_DATE,

Line 4974: INSERT INTO CSI_I_PRICING_ATTRIBS_H(

4970: --
4971: l_ctr := l_pricing_hist_rec_tab.price_attrib_history_id.count;
4972: --
4973: FORALL i in 1 .. l_ctr
4974: INSERT INTO CSI_I_PRICING_ATTRIBS_H(
4975: PRICE_ATTRIB_HISTORY_ID,
4976: PRICING_ATTRIBUTE_ID,
4977: TRANSACTION_ID,
4978: OLD_PRICING_CONTEXT,

Line 8084: DELETE FROM CSI_I_PRICING_ATTRIBS WHERE instance_id = l_del_inst_tbl(j);

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);
8087: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8088: DELETE FROM CSI_IEA_VALUES WHERE instance_id = l_del_inst_tbl(j);

Line 8100: DELETE FROM CSI_I_PRICING_ATTRIBS_H WHERE transaction_id = l_del_txn_tbl(j);

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);
8103: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8104: DELETE FROM CSI_IEA_VALUES_H WHERE transaction_id = l_del_txn_tbl(j);