APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_I_ASSETS

Line 1603: select CSI_I_ASSETS_H_S.nextval

1599: l_count NUMBER;
1600: l_hist_id NUMBER;
1601: BEGIN
1602: l_count := p_asset_hist_tbl.count + 1;
1603: select CSI_I_ASSETS_H_S.nextval
1604: into l_hist_id
1605: from sys.dual;
1606:
1607: p_asset_hist_tbl(l_count).instance_asset_history_id := l_hist_id;

Line 5663: INSERT INTO CSI_I_ASSETS(

5659: --
5660: l_ctr := l_asset_rec_tab.instance_asset_id.count;
5661: --
5662: FORALL i in 1 .. l_ctr
5663: INSERT INTO CSI_I_ASSETS(
5664: INSTANCE_ASSET_ID,
5665: INSTANCE_ID,
5666: FA_ASSET_ID,
5667: FA_BOOK_TYPE_CODE,

Line 5710: INSERT INTO CSI_I_ASSETS_H(

5706: --
5707: l_ctr := l_asset_hist_rec_tab.instance_asset_history_id.count;
5708: --
5709: FORALL i in 1 .. l_ctr
5710: INSERT INTO CSI_I_ASSETS_H(
5711: INSTANCE_ASSET_HISTORY_ID,
5712: INSTANCE_ASSET_ID,
5713: TRANSACTION_ID,
5714: OLD_INSTANCE_ID,

Line 7553: DELETE FROM CSI_I_ASSETS WHERE instance_id = l_del_inst_tbl(j);

7549: DELETE FROM CSI_I_VERSION_LABELS WHERE instance_id = l_del_inst_tbl(j);
7550: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
7551: DELETE FROM CSI_IEA_VALUES WHERE instance_id = l_del_inst_tbl(j);
7552: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
7553: DELETE FROM CSI_I_ASSETS WHERE instance_id = l_del_inst_tbl(j);
7554: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7555: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_del_txn_tbl(j);
7556: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7557: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_del_txn_tbl(j);

Line 7569: DELETE FROM CSI_I_ASSETS_H WHERE transaction_id = l_del_txn_tbl(j);

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);
7568: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7569: DELETE FROM CSI_I_ASSETS_H WHERE transaction_id = l_del_txn_tbl(j);
7570: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7571: DELETE FROM CSI_TRANSACTIONS WHERE transaction_id = l_del_txn_tbl(j);
7572: END;
7573: END IF;

Line 7595: FROM csi_i_assets b

7591: l_upd_stmt := 'UPDATE CSI_I_ASSET_INTERFACE a
7592: SET instance_id = :ins_id
7593: , instance_asset_id =
7594: ( SELECT instance_asset_id
7595: FROM csi_i_assets b
7596: WHERE b.instance_id = :a_ins_id
7597: AND b.fa_asset_id = a.fa_asset_id
7598: AND b.fa_book_type_code = a.fa_book_type_code
7599: AND b.fa_location_id = a.fa_location_id