APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_I_PRICING_ATTRIBS_H

Line 1285: select CSI_I_PRICING_ATTRIBS_H_S.nextval

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

Line 4971: INSERT INTO CSI_I_PRICING_ATTRIBS_H(

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

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

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