APPS.OKL_REV_LOSS_PROV_PVT dependencies on OKL_TRX_CONTRACTS

Line 27: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

23: l_sysdate DATE := SYSDATE;
24: l_reversal_date DATE;
25: l_COUNT NUMBER :=0;
26: /* record and table structure variables */
27: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
28: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
29: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
30: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
31: l_source_id_tbl OKL_REVERSAL_PUB.source_id_tbl_type;

Line 28: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

24: l_reversal_date DATE;
25: l_COUNT NUMBER :=0;
26: /* record and table structure variables */
27: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
28: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
29: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
30: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
31: l_source_id_tbl OKL_REVERSAL_PUB.source_id_tbl_type;
32: --

Line 29: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

25: l_COUNT NUMBER :=0;
26: /* record and table structure variables */
27: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
28: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
29: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
30: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
31: l_source_id_tbl OKL_REVERSAL_PUB.source_id_tbl_type;
32: --
33: TYPE t_date IS TABLE OF DATE INDEX BY BINARY_INTEGER;

Line 30: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

26: /* record and table structure variables */
27: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
28: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
29: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
30: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
31: l_source_id_tbl OKL_REVERSAL_PUB.source_id_tbl_type;
32: --
33: TYPE t_date IS TABLE OF DATE INDEX BY BINARY_INTEGER;
34: l_trx_date_tbl t_date;

Line 39: FROM OKL_TRX_CONTRACTS

35: --
36: -- Cursor to select transaction headers for reversal
37: CURSOR reverse_trx_csr(p_khr_id NUMBER, p_tcn_type VARCHAR2) IS
38: SELECT id, date_transaction_occurred, transaction_date
39: FROM OKL_TRX_CONTRACTS
40: WHERE khr_id = p_khr_id
41: AND tsu_code = 'PROCESSED'
42: AND tcn_type = p_tcn_type
43: AND representation_type = G_PRIMARY;

Line 48: FROM OKL_TXL_CNTRCT_LNS txl, OKL_TRX_CONTRACTS trx

44:
45: -- Cursor to select transaction lines for reversal
46: CURSOR reverse_txl_csr(p_khr_id NUMBER, p_tcn_id NUMBER, p_tcn_type VARCHAR2) IS
47: SELECT txl.id, txl.amount, txl.currency_code
48: FROM OKL_TXL_CNTRCT_LNS txl, OKL_TRX_CONTRACTS trx
49: WHERE trx.khr_id = p_khr_id
50: AND txl.tcn_id = trx.id
51: AND txl.tcn_id = p_tcn_id --trx.id
52: AND trx.tsu_code = 'PROCESSED'

Line 59: FROM OKL_TRX_CONTRACTS

55:
56: -- Cursor to select all transaction headers for reversal
57: CURSOR reverse_all_trx_csr(p_khr_id NUMBER) IS
58: SELECT id, date_transaction_occurred, transaction_date
59: FROM OKL_TRX_CONTRACTS
60: WHERE khr_id = p_khr_id
61: AND tsu_code = 'PROCESSED'
62: AND (tcn_type = 'PSP' OR tcn_type = 'PGL')
63: AND representation_type = G_PRIMARY;

Line 68: FROM OKL_TXL_CNTRCT_LNS txl, OKL_TRX_CONTRACTS trx

64:
65: -- Cursor to select all transaction lines for reversal
66: CURSOR reverse_all_txl_csr(p_khr_id NUMBER, p_tcn_id NUMBER) IS
67: SELECT txl.id, txl.amount, txl.currency_code
68: FROM OKL_TXL_CNTRCT_LNS txl, OKL_TRX_CONTRACTS trx
69: WHERE trx.khr_id = p_khr_id
70: AND txl.tcn_id = trx.id
71: AND txl.tcn_id = p_tcn_id --trx.id
72: AND trx.tsu_code = 'PROCESSED'

Line 232: Okl_Trx_Contracts_Pub.update_trx_contracts

228:
229: END LOOP; -- new logic for reversing by tcn_id.
230:
231: --Call the transaction public api to update tsu_code
232: Okl_Trx_Contracts_Pub.update_trx_contracts
233: (p_api_version => p_api_version,
234: p_init_msg_list => p_init_msg_list,
235: x_return_status => l_return_status,
236: x_msg_count => x_msg_count,