APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_TRANSACTIONS

Line 3376: INSERT INTO CSI_TRANSACTIONS(

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

Line 6979: select CSI_TRANSACTIONS_S.nextval

6975: l_bulk_inst_count := l_bulk_inst_count + 1;
6976: l_bulk_inst_tbl(l_bulk_inst_count) := p_instance_tbl(inst_tab_row);
6977: IF p_txn_tbl(inst_tab_row).transaction_id IS NULL OR
6978: p_txn_tbl(inst_tab_row).transaction_id = FND_API.G_MISS_NUM THEN
6979: select CSI_TRANSACTIONS_S.nextval
6980: into p_txn_tbl(inst_tab_row).transaction_id
6981: from sys.dual;
6982: END IF;
6983: --

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

7132: l_temp_asset_tbl.DELETE;
7133: l_temp_ext_tbl.DELETE;
7134: x_return_status := FND_API.G_RET_STS_SUCCESS;
7135: --
7136: -- l_txn_exists_tbl contains those transactions exist in CSI_TRANSACTIONS
7137: -- x_bulk_txn_tbl contains the transactions that need to be inserted in CSI_TRANSACTIONS
7138: IF l_bulk_inst_tbl.count > 0 THEN
7139: -- Loop thru' the l_bulk_txn_tbl and eliminate duplicate txn id's.
7140: FOR j in l_bulk_txn_tbl.FIRST .. l_bulk_txn_tbl.LAST LOOP

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

7133: l_temp_ext_tbl.DELETE;
7134: x_return_status := FND_API.G_RET_STS_SUCCESS;
7135: --
7136: -- l_txn_exists_tbl contains those transactions exist in CSI_TRANSACTIONS
7137: -- x_bulk_txn_tbl contains the transactions that need to be inserted in CSI_TRANSACTIONS
7138: IF l_bulk_inst_tbl.count > 0 THEN
7139: -- Loop thru' the l_bulk_txn_tbl and eliminate duplicate txn id's.
7140: FOR j in l_bulk_txn_tbl.FIRST .. l_bulk_txn_tbl.LAST LOOP
7141: l_exists := 'N';

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

7159: END IF;
7160: END IF;
7161: --
7162: IF l_exists <> 'Y' THEN
7163: csi_gen_utility_pvt.put_line('Checking against csi_transactions..');
7164: Begin
7165: select 'Y'
7166: into l_exists
7167: from csi_transactions

Line 7167: from csi_transactions

7163: csi_gen_utility_pvt.put_line('Checking against csi_transactions..');
7164: Begin
7165: select 'Y'
7166: into l_exists
7167: from csi_transactions
7168: where transaction_id = l_bulk_txn_tbl(j).transaction_id;
7169: --
7170: l_txn_ctr := l_txn_exists_tbl.count;
7171: l_txn_ctr := l_txn_ctr + 1;

Line 7483: UPDATE CSI_TRANSACTIONS

7479: END IF;
7480: --
7481: IF l_upd_txn_tbl.count > 0 THEN
7482: FORALL K IN l_upd_txn_tbl.FIRST .. l_upd_txn_tbl.LAST
7483: UPDATE CSI_TRANSACTIONS
7484: set contracts_invoked = 'Y'
7485: where transaction_id = l_upd_txn_tbl(K);
7486: END IF;
7487: --

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

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

Line 9105: UPDATE CSI_TRANSACTIONS

9101: l_batch_id := NULL;
9102: l_batch_type := NULL;
9103: END IF;
9104: --
9105: UPDATE CSI_TRANSACTIONS
9106: set contracts_invoked = 'Y'
9107: where transaction_id = p_txn_rec.transaction_id;
9108: --
9109: OKS_IBINT_PUB.IB_interface

Line 9376: UPDATE CSI_TRANSACTIONS

9372: l_batch_id := NULL;
9373: l_batch_type := NULL;
9374: END IF;
9375: --
9376: UPDATE CSI_TRANSACTIONS
9377: set contracts_invoked = 'Y'
9378: where transaction_id = p_txn_rec.transaction_id;
9379: --
9380: OKS_IBINT_PUB.IB_interface