APPS.OKL_LA_SALES_TAX_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 1058: l_currency_code okl_txl_cntrct_lns.currency_code%TYPE;

1054: l_amount NUMBER;
1055: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
1056: l_msg_count NUMBER;
1057: l_msg_data VARCHAR2(2000);
1058: l_currency_code okl_txl_cntrct_lns.currency_code%TYPE;
1059: l_fnd_profile VARCHAR2(256);
1060: l_cust_trx_type_id NUMBER;
1061: l_has_trans VARCHAR2(1);
1062:

Line 3351: p_dist_info_tbl(i).SOURCE_TABLE := 'OKL_TXL_CNTRCT_LNS';

3347: -- Populate distribution info
3348: p_dist_info_tbl(i).SOURCE_ID := p_tclv_tbl(i).id;
3349: p_dist_info_tbl(i).amount := p_tclv_tbl(i).amount;
3350: p_dist_info_tbl(i).ACCOUNTING_DATE := p_trxh_out_rec.date_transaction_occurred;
3351: p_dist_info_tbl(i).SOURCE_TABLE := 'OKL_TXL_CNTRCT_LNS';
3352: p_dist_info_tbl(i).GL_REVERSAL_FLAG := 'N';
3353: p_dist_info_tbl(i).POST_TO_GL := 'Y';
3354: p_dist_info_tbl(i).CONTRACT_ID := p_trxh_out_rec.khr_id;
3355: p_dist_info_tbl(i).currency_conversion_rate := p_trxh_out_rec.currency_conversion_rate;

Line 3381: -- 2. TRX lines in OKL_TXL_CNTRCT_LNS for each line in ZX_LINES,

3377: -- This procedure logic will be executed in its entirety, only if SLA accounting
3378: -- option AMB is enabled.
3379: -- When enabled, it creates:
3380: -- 1. TRX header in OKL_TRX_CONTRACTS for type 'Upfront Tax'
3381: -- 2. TRX lines in OKL_TXL_CNTRCT_LNS for each line in ZX_LINES,
3382: -- store values for cle-id, tax_line_id, tax_amount, etc.
3383: -- 3. Identify tax treatment for each asset line, to derive stream type
3384: -- 4. Call a/c API for upfront tax records in OKL_TXL_CNTRCT_LNS
3385: -- Business Rules :

Line 3384: -- 4. Call a/c API for upfront tax records in OKL_TXL_CNTRCT_LNS

3380: -- 1. TRX header in OKL_TRX_CONTRACTS for type 'Upfront Tax'
3381: -- 2. TRX lines in OKL_TXL_CNTRCT_LNS for each line in ZX_LINES,
3382: -- store values for cle-id, tax_line_id, tax_amount, etc.
3383: -- 3. Identify tax treatment for each asset line, to derive stream type
3384: -- 4. Call a/c API for upfront tax records in OKL_TXL_CNTRCT_LNS
3385: -- Business Rules :
3386: -- Parameters :
3387: -- Version : 1.0
3388: -- End of comments

Line 3848: -- this ID will be populated in OKL_TXL_CNTRCT_LNS depending on

3844:
3845: CLOSE fnd_lookups_csr;
3846:
3847: -- Get Stream ID's for 'Financed' and 'Capitalized' Fee stream purposes,
3848: -- this ID will be populated in OKL_TXL_CNTRCT_LNS depending on
3849: -- each inserted record's tax treatment
3850:
3851: IF (G_IS_DEBUG_STATEMENT_ON = TRUE)
3852: THEN