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_LOSS_PROV_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 655: l_source_table CONSTANT OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';

651: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
652: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
653: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
654: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
655: l_source_table CONSTANT OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
656: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
657: --START: Added by nikshah 19-Feb-2007 for SLA Uptake, Bug #5707866
658: l_tcn_id NUMBER;
659: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;

Line 1004: l_tcl_type CONSTANT OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'PGL';

1000: l_api_name CONSTANT VARCHAR2(40) := 'GENERAL_LOSS_PROVISION';
1001: l_api_version CONSTANT NUMBER := 1.0;
1002: l_try_name CONSTANT OKL_TRX_TYPES_V.NAME%TYPE := 'General Loss Provision';
1003: l_tcn_type CONSTANT OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'PGL';
1004: l_tcl_type CONSTANT OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'PGL';
1005: ----Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
1006: l_tsu_code CONSTANT OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
1007: l_oper_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LEASEOP';
1008: l_df_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LEASEDF';

Line 1531: l_sty_id OKL_TXL_CNTRCT_LNS.STY_ID%TYPE; --:= to_number(p_sty_id);

1527: l_inv_loss_amt NUMBER :=0;
1528: l_loss_rate OKL_BUCKETS_V.LOSS_RATE%TYPE;
1529: l_trx_header_total OKL_TRX_CONTRACTS.AMOUNT%TYPE := 0;
1530: l_converted_net_book_value NUMBER;
1531: l_sty_id OKL_TXL_CNTRCT_LNS.STY_ID%TYPE; --:= to_number(p_sty_id);
1532: l_sty_name OKL_STRM_TYPE_V.NAME%TYPE;
1533:
1534:
1535: -- creating variable required by okl_accounting_util.convert_to_contract_currency

Line 2299: l_tcl_type CONSTANT OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'PSP';

2295: l_api_name CONSTANT VARCHAR2(40) := 'SPECIFIC_LOSS_PROVISION';
2296: l_api_version CONSTANT NUMBER := 1.0;
2297: l_tcn_type CONSTANT OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'PSP';
2298: l_try_name CONSTANT OKL_TRX_TYPES_TL.NAME%TYPE := 'Specific Loss Provision';
2299: l_tcl_type CONSTANT OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'PSP';
2300: l_source_table CONSTANT OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
2301: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
2302: l_tsu_code CONSTANT OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
2303:

Line 2300: l_source_table CONSTANT OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';

2296: l_api_version CONSTANT NUMBER := 1.0;
2297: l_tcn_type CONSTANT OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'PSP';
2298: l_try_name CONSTANT OKL_TRX_TYPES_TL.NAME%TYPE := 'Specific Loss Provision';
2299: l_tcl_type CONSTANT OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'PSP';
2300: l_source_table CONSTANT OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
2301: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
2302: l_tsu_code CONSTANT OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
2303:
2304: --variables

Line 2367: -- FROM OKL_STRM_TYPE_B sty, OKL_TRX_CONTRACTS_V trx, OKL_TXL_CNTRCT_LNS_V txl

2363:
2364: -- Cursor to verify if the stream type selected is the same as used earlier
2365: -- CURSOR sty_id_csr(p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
2366: -- SELECT DISTINCT sty.id id
2367: -- FROM OKL_STRM_TYPE_B sty, OKL_TRX_CONTRACTS_V trx, OKL_TXL_CNTRCT_LNS_V txl
2368: -- WHERE trx.khr_id = p_ctr_id
2369: -- AND trx.tcn_type = 'PSP'
2370: -- AND trx.tsu_code = l_tsu_code
2371: -- AND trx.id = txl.tcn_id