eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PROPERTY_TAX_STATEMENT_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 291: l_curr_code := okl_accounting_util.get_func_curr_code;

287: some_data VARCHAR2(1);
288:
289: BEGIN
290: -- one time initializations
291: l_curr_code := okl_accounting_util.get_func_curr_code;
292: l_request_id := Fnd_Global.CONC_REQUEST_ID;
293:
294: --Product Title for the report: Oracle Lease and Finance Management
295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ', 63 , ' ' ) || fnd_message.get_string('OKL','OKL_TITLE') || RPAD(' ', 63 , ' ' ));

Line 369: GET_PROPER_LENGTH(okl_accounting_util.format_amount(p_act_ppt_tax.amount_imp,l_curr_code) ,l_apt_amount_len,'DATA')||

365: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,GET_PROPER_LENGTH(p_act_ppt_tax.contract_number,l_Contract#_len,'DATA')||
366: GET_PROPER_LENGTH(p_act_ppt_tax.name,l_asset_name_len,'DATA')||
367: GET_PROPER_LENGTH(p_act_ppt_tax.JURSDCTN_NAME ,l_jurisd_name_len,'DATA')||
368: GET_PROPER_LENGTH(p_act_ppt_tax.lien_date ,l_lien_date_len,'DATA')||
369: GET_PROPER_LENGTH(okl_accounting_util.format_amount(p_act_ppt_tax.amount_imp,l_curr_code) ,l_apt_amount_len,'DATA')||
370: GET_PROPER_LENGTH(okl_accounting_util.format_amount(p_act_ppt_tax.amount_billed,l_curr_code),l_amt_billable_len,'DATA')||
371: RPAD( ' ', 2, ' ') ||
372: GET_PROPER_LENGTH(p_act_ppt_tax.STREAM_TYPE_PURPOSE,l_strm_purpose_len,'DATA')||
373: GET_PROPER_LENGTH(p_act_ppt_tax.STREAM_TYPE,l_strm_type_len,'DATA')||

Line 370: GET_PROPER_LENGTH(okl_accounting_util.format_amount(p_act_ppt_tax.amount_billed,l_curr_code),l_amt_billable_len,'DATA')||

366: GET_PROPER_LENGTH(p_act_ppt_tax.name,l_asset_name_len,'DATA')||
367: GET_PROPER_LENGTH(p_act_ppt_tax.JURSDCTN_NAME ,l_jurisd_name_len,'DATA')||
368: GET_PROPER_LENGTH(p_act_ppt_tax.lien_date ,l_lien_date_len,'DATA')||
369: GET_PROPER_LENGTH(okl_accounting_util.format_amount(p_act_ppt_tax.amount_imp,l_curr_code) ,l_apt_amount_len,'DATA')||
370: GET_PROPER_LENGTH(okl_accounting_util.format_amount(p_act_ppt_tax.amount_billed,l_curr_code),l_amt_billable_len,'DATA')||
371: RPAD( ' ', 2, ' ') ||
372: GET_PROPER_LENGTH(p_act_ppt_tax.STREAM_TYPE_PURPOSE,l_strm_purpose_len,'DATA')||
373: GET_PROPER_LENGTH(p_act_ppt_tax.STREAM_TYPE,l_strm_type_len,'DATA')||
374: GET_PROPER_LENGTH(p_act_ppt_tax.stream_element_date,l_date_len,'DATA')||

Line 375: GET_PROPER_LENGTH(okl_accounting_util.format_amount(p_act_ppt_tax.amount,l_curr_code) ,l_bill_amount_len,'DATA'));

371: RPAD( ' ', 2, ' ') ||
372: GET_PROPER_LENGTH(p_act_ppt_tax.STREAM_TYPE_PURPOSE,l_strm_purpose_len,'DATA')||
373: GET_PROPER_LENGTH(p_act_ppt_tax.STREAM_TYPE,l_strm_type_len,'DATA')||
374: GET_PROPER_LENGTH(p_act_ppt_tax.stream_element_date,l_date_len,'DATA')||
375: GET_PROPER_LENGTH(okl_accounting_util.format_amount(p_act_ppt_tax.amount,l_curr_code) ,l_bill_amount_len,'DATA'));
376: l_act_amt := l_act_amt + p_act_ppt_tax.amount;
377: l_imp_amt := l_imp_amt + p_act_ppt_tax.amount_imp;
378: END LOOP;
379: --Fetch Estimated property tax for the asset

Line 392: GET_PROPER_LENGTH(okl_accounting_util.format_amount(p_estm_ppt_tax.amount,l_curr_code) ,l_bill_amount_len,'DATA'));

388: RPAD( ' ', 2, ' ') ||
389: GET_PROPER_LENGTH(p_estm_ppt_tax.STREAM_TYPE_PURPOSE ,l_strm_purpose_len,'DATA')||
390: GET_PROPER_LENGTH(p_estm_ppt_tax.STREAM_TYPE ,l_strm_type_len,'DATA')||
391: GET_PROPER_LENGTH(p_estm_ppt_tax.stream_element_date,l_date_len,'DATA')||
392: GET_PROPER_LENGTH(okl_accounting_util.format_amount(p_estm_ppt_tax.amount,l_curr_code) ,l_bill_amount_len,'DATA'));
393: l_est_amt := l_est_amt + p_estm_ppt_tax.amount;
394: END LOOP;
395: --Fetch Adjusted property tax for the asset
396: FOR p_adjst_ppt_tax IN c_adjst_ppt_tax(l_cont_id,l_asset_id) LOOP

Line 408: GET_PROPER_LENGTH(okl_accounting_util.format_amount(p_adjst_ppt_tax.amount,l_curr_code) ,l_bill_amount_len,'DATA'));

404: RPAD( ' ', 2, ' ') ||
405: GET_PROPER_LENGTH(p_adjst_ppt_tax.STREAM_TYPE_PURPOSE ,l_strm_purpose_len,'DATA')||
406: GET_PROPER_LENGTH(p_adjst_ppt_tax.STREAM_TYPE ,l_strm_type_len,'DATA')||
407: GET_PROPER_LENGTH(p_adjst_ppt_tax.stream_element_date,l_date_len,'DATA')||
408: GET_PROPER_LENGTH(okl_accounting_util.format_amount(p_adjst_ppt_tax.amount,l_curr_code) ,l_bill_amount_len,'DATA'));
409: l_adjst_amt := l_adjst_amt + p_adjst_ppt_tax.amount;
410: END LOOP;
411:
412: -- To avoid unnecessary printing of lines

Line 422: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',132, ' ') || RPAD(fnd_message.get_string('OKL','OKL_BPD_PTAX_RPT_SHORT'),l_strm_type_len,' ') ||RPAD(' ',l_date_len,' ')||okl_accounting_util.format_amount(l_excs_amt,l_curr_code));

418: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-' )||' '||RPAD('-',86,'-' ));
419: --l_excs_amt := l_act_amt - l_est_amt - l_adjst_amt;
420: l_excs_amt := (l_act_amt + l_est_amt)- l_imp_amt; -- l_act_amt - l_est_amt - l_adjst_amt;
421: IF( l_excs_amt < 0) THEN
422: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',132, ' ') || RPAD(fnd_message.get_string('OKL','OKL_BPD_PTAX_RPT_SHORT'),l_strm_type_len,' ') ||RPAD(' ',l_date_len,' ')||okl_accounting_util.format_amount(l_excs_amt,l_curr_code));
423: ELSE
424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',132, ' ') || RPAD(fnd_message.get_string('OKL','OKL_BPD_PTAX_RPT_EXCESS'),l_strm_type_len,' ') ||RPAD(' ',l_date_len,' ')||okl_accounting_util.format_amount(l_excs_amt,l_curr_code));
425: END IF;
426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-' )||' '||RPAD('-',86,'-' ));

Line 424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',132, ' ') || RPAD(fnd_message.get_string('OKL','OKL_BPD_PTAX_RPT_EXCESS'),l_strm_type_len,' ') ||RPAD(' ',l_date_len,' ')||okl_accounting_util.format_amount(l_excs_amt,l_curr_code));

420: l_excs_amt := (l_act_amt + l_est_amt)- l_imp_amt; -- l_act_amt - l_est_amt - l_adjst_amt;
421: IF( l_excs_amt < 0) THEN
422: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',132, ' ') || RPAD(fnd_message.get_string('OKL','OKL_BPD_PTAX_RPT_SHORT'),l_strm_type_len,' ') ||RPAD(' ',l_date_len,' ')||okl_accounting_util.format_amount(l_excs_amt,l_curr_code));
423: ELSE
424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(' ',132, ' ') || RPAD(fnd_message.get_string('OKL','OKL_BPD_PTAX_RPT_EXCESS'),l_strm_type_len,' ') ||RPAD(' ',l_date_len,' ')||okl_accounting_util.format_amount(l_excs_amt,l_curr_code));
425: END IF;
426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 105, '-' )||' '||RPAD('-',86,'-' ));
427: -- END IF;
428: END IF;