APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_TRANSACTIONS

Line 3379: INSERT INTO CSI_TRANSACTIONS(

3375: --
3376: l_ctr := l_txn_rec_tab.transaction_id.count;
3377: --
3378: FORALL i in 1 .. l_ctr
3379: INSERT INTO CSI_TRANSACTIONS(
3380: transaction_id,
3381: transaction_date,
3382: source_transaction_date,
3383: transaction_type_id,

Line 7317: select CSI_TRANSACTIONS_S.nextval

7313: l_bulk_inst_count := l_bulk_inst_count + 1;
7314: l_bulk_inst_tbl(l_bulk_inst_count) := p_instance_tbl(inst_tab_row);
7315: IF p_txn_tbl(inst_tab_row).transaction_id IS NULL OR
7316: p_txn_tbl(inst_tab_row).transaction_id = FND_API.G_MISS_NUM THEN
7317: select CSI_TRANSACTIONS_S.nextval
7318: into p_txn_tbl(inst_tab_row).transaction_id
7319: from sys.dual;
7320: END IF;
7321: --

Line 7522: -- l_txn_exists_tbl contains those transactions exist in CSI_TRANSACTIONS

7518: l_temp_asset_tbl.DELETE;
7519: l_temp_ext_tbl.DELETE;
7520: x_return_status := FND_API.G_RET_STS_SUCCESS;
7521: --
7522: -- l_txn_exists_tbl contains those transactions exist in CSI_TRANSACTIONS
7523: -- x_bulk_txn_tbl contains the transactions that need to be inserted in CSI_TRANSACTIONS
7524: IF l_bulk_inst_tbl.count > 0 THEN
7525: -- Loop thru' the l_bulk_txn_tbl and eliminate duplicate txn id's.
7526: FOR j in l_bulk_txn_tbl.FIRST .. l_bulk_txn_tbl.LAST LOOP

Line 7523: -- x_bulk_txn_tbl contains the transactions that need to be inserted in CSI_TRANSACTIONS

7519: l_temp_ext_tbl.DELETE;
7520: x_return_status := FND_API.G_RET_STS_SUCCESS;
7521: --
7522: -- l_txn_exists_tbl contains those transactions exist in CSI_TRANSACTIONS
7523: -- x_bulk_txn_tbl contains the transactions that need to be inserted in CSI_TRANSACTIONS
7524: IF l_bulk_inst_tbl.count > 0 THEN
7525: -- Loop thru' the l_bulk_txn_tbl and eliminate duplicate txn id's.
7526: FOR j in l_bulk_txn_tbl.FIRST .. l_bulk_txn_tbl.LAST LOOP
7527: l_exists := 'N';

Line 7549: csi_gen_utility_pvt.put_line('Checking against csi_transactions..');

7545: END IF;
7546: END IF;
7547: --
7548: IF l_exists <> 'Y' THEN
7549: csi_gen_utility_pvt.put_line('Checking against csi_transactions..');
7550: Begin
7551: select 'Y'
7552: into l_exists
7553: from csi_transactions

Line 7553: from csi_transactions

7549: csi_gen_utility_pvt.put_line('Checking against csi_transactions..');
7550: Begin
7551: select 'Y'
7552: into l_exists
7553: from csi_transactions
7554: where transaction_id = l_bulk_txn_tbl(j).transaction_id;
7555: --
7556: l_txn_ctr := l_txn_exists_tbl.count;
7557: l_txn_ctr := l_txn_ctr + 1;

Line 8020: UPDATE CSI_TRANSACTIONS

8016: END IF;
8017: --
8018: IF l_upd_txn_tbl.count > 0 THEN
8019: FORALL K IN l_upd_txn_tbl.FIRST .. l_upd_txn_tbl.LAST
8020: UPDATE CSI_TRANSACTIONS
8021: set contracts_invoked = 'Y'
8022: where transaction_id = l_upd_txn_tbl(K);
8023: END IF;
8024: --

Line 8108: DELETE FROM CSI_TRANSACTIONS WHERE transaction_id = l_del_txn_tbl(j);

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;
8111: -- Update Interface Table
8112: IF l_intf_id_array.count > 0 THEN

Line 9660: UPDATE CSI_TRANSACTIONS

9656: l_batch_id := NULL;
9657: l_batch_type := NULL;
9658: END IF;
9659: --
9660: UPDATE CSI_TRANSACTIONS
9661: set contracts_invoked = 'Y'
9662: where transaction_id = p_txn_rec.transaction_id;
9663: --
9664: OKS_IBINT_PUB.IB_interface

Line 9931: UPDATE CSI_TRANSACTIONS

9927: l_batch_id := NULL;
9928: l_batch_type := NULL;
9929: END IF;
9930: --
9931: UPDATE CSI_TRANSACTIONS
9932: set contracts_invoked = 'Y'
9933: where transaction_id = p_txn_rec.transaction_id;
9934: --
9935: OKS_IBINT_PUB.IB_interface