APPS.OKL_SEC_AGREEMENT_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 129: l_currency_code okl_txl_cntrct_lns.currency_code%TYPE;

125: l_amount NUMBER;
126: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
127: l_msg_count NUMBER;
128: l_msg_data VARCHAR2(2000);
129: l_currency_code okl_txl_cntrct_lns.currency_code%TYPE;
130: l_fnd_profile VARCHAR2(256);
131: l_cust_trx_type_id NUMBER;
132:
133: l_msg_index_out NUMBER; --TBR

Line 221: okl_txl_cntrct_lns txl

217: SELECT txh.ID HeaderTransID,
218: txl.ID LineTransID,
219: txh.date_transaction_occurred date_transaction_occurred
220: FROM okl_trx_contracts txh,
221: okl_txl_cntrct_lns txl
222: WHERE txl.tcn_id = txh.id
223: AND txh.tcn_type = tcntype
224: --rkuttiya added for 12.1.1 Multi GAAP
225: AND txh.representation_type = 'PRIMARY'

Line 668: l_dist_info_tbl(i).SOURCE_TABLE := 'OKL_TXL_CNTRCT_LNS';

664: END IF;
665:
666: l_dist_info_tbl(i).SOURCE_ID := x_tclv_tbl(i).id;
667: l_dist_info_tbl(i).ACCOUNTING_DATE := l_trxH_out_rec.date_transaction_occurred;
668: l_dist_info_tbl(i).SOURCE_TABLE := 'OKL_TXL_CNTRCT_LNS';
669: l_dist_info_tbl(i).GL_REVERSAL_FLAG := 'N';
670: l_dist_info_tbl(i).POST_TO_GL := l_post_to_gl_yn;
671: l_dist_info_tbl(i).CONTRACT_ID := p_contract_id;
672: l_dist_info_tbl(i).currency_conversion_rate := x_currency_conversion_rate;