APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_I_ASSETS

Line 1606: select CSI_I_ASSETS_H_S.nextval

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

Line 5666: INSERT INTO CSI_I_ASSETS(

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

Line 5713: INSERT INTO CSI_I_ASSETS_H(

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

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

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);
8089: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8090: DELETE FROM CSI_I_ASSETS WHERE instance_id = l_del_inst_tbl(j);
8091: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8092: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_del_txn_tbl(j);
8093: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8094: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_del_txn_tbl(j);

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

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);
8105: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8106: DELETE FROM CSI_I_ASSETS_H WHERE transaction_id = l_del_txn_tbl(j);
8107: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8108: DELETE FROM CSI_TRANSACTIONS WHERE transaction_id = l_del_txn_tbl(j);
8109: END;
8110: END IF;

Line 8132: FROM csi_i_assets b

8128: l_upd_stmt := 'UPDATE CSI_I_ASSET_INTERFACE a
8129: SET instance_id = :ins_id
8130: , instance_asset_id =
8131: ( SELECT instance_asset_id
8132: FROM csi_i_assets b
8133: WHERE b.instance_id = :a_ins_id
8134: AND b.fa_asset_id = a.fa_asset_id
8135: AND b.fa_book_type_code = a.fa_book_type_code
8136: AND b.fa_location_id = a.fa_location_id