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_AM_UTIL_PVT dependencies on OKL_K_HEADERS

Line 36: FROM okl_k_headers h

32: RETURN NUMBER IS
33:
34: CURSOR l_program_csr (cp_chr_id NUMBER) IS
35: SELECT h.khr_id
36: FROM okl_k_headers h
37: WHERE h.id = cp_chr_id;
38:
39: l_formula_chr_id NUMBER;
40:

Line 1898: FROM okl_k_headers khr,

1894: CURSOR l_partner_csr (cp_chr_id NUMBER) IS
1895: SELECT kpr.jtot_object1_code,
1896: kpr.object1_id1,
1897: kpr.object1_id2
1898: FROM okl_k_headers khr,
1899: okc_k_headers_b par,
1900: okc_k_party_roles_b kpr
1901: WHERE khr.id = cp_chr_id
1902: AND par.id = khr.khr_id

Line 3792: l_deal_type okl_k_headers.deal_type%TYPE;

3788: p_message_yn IN BOOLEAN,
3789: p_proration_factor IN NUMBER DEFAULT NULL,
3790: x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER IS
3791:
3792: l_deal_type okl_k_headers.deal_type%TYPE;
3793: l_formula_name VARCHAR2(150) ;
3794: l_net_investment okl_txl_quote_lines_b.asset_value%TYPE;
3795: l_asset_value ak_attributes_vl.attribute_label_long%TYPE;
3796:

Line 3804: FROM okl_k_headers khr, okc_k_headers_b chr

3800:
3801: -- This cursor is used to get the deal type for a contract.
3802: CURSOR l_oklheaders_csr(p_khr_id IN NUMBER) IS
3803: SELECT chr.sts_code,khr.deal_type
3804: FROM okl_k_headers khr, okc_k_headers_b chr
3805: WHERE khr.id = p_khr_id
3806: AND KHR.ID = CHR.ID;
3807:
3808: -- SECHAWLA 09-AUG-05 4304230 : new declaraions end

Line 3814: FROM okl_k_headers

3810: /* SECHAWLA 09-AUG-05 4304230
3811: -- This cursor is used to get the deal type for a contract.
3812: CURSOR l_oklheaders_csr(p_khr_id IN NUMBER) IS
3813: SELECT deal_type
3814: FROM okl_k_headers
3815: WHERE id = p_khr_id;
3816: */
3817:
3818: -- -- rmunjulu LOANS_ENHANCEMENT

Line 3966: p_kle_id IN OKL_K_HEADERS.ID%TYPE)

3962:
3963: FUNCTION get_party_name(
3964: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
3965: p_rle_code IN OKC_K_PARTY_ROLES_B.RLE_CODE%TYPE,
3966: p_kle_id IN OKL_K_HEADERS.ID%TYPE)
3967: RETURN VARCHAR2 IS
3968: lv_object1_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE;
3969: lv_object1_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE;
3970: lv_object1_code OKC_K_PARTY_ROLES_B.JTOT_OBJECT1_CODE%TYPE;

Line 4171: FROM OKL_K_HEADERS khr

4167:
4168: -- get purchase amount for asset
4169: CURSOR get_khr_deal_csr (p_khr_id IN NUMBER) IS
4170: SELECT khr.deal_type
4171: FROM OKL_K_HEADERS khr
4172: WHERE khr.id = p_khr_id;
4173:
4174: -- get accumulated depreciation for the asset on the termination date(AVSINGH)
4175: -- if the FA book period is closed

Line 4268: l_deal_type OKL_K_HEADERS.deal_type%TYPE;

4264: l_quote_id NUMBER;
4265: l_quote_type OKL_TRX_QUOTES_B.qtp_code%TYPE;
4266: l_asset_residual NUMBER;
4267: l_deprn_amt NUMBER;
4268: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
4269: l_cost NUMBER;
4270: l_period_open VARCHAR2(1);
4271:
4272: Expected_error EXCEPTION;

Line 4766: OKL_K_HEADERS KHR

4762: OKL_PDT_PQYS PDQ ,
4763: OKL_PRODUCTS PDT,
4764: OKL_PQY_VALUES QVE,
4765: OKL_PDT_QUALITYS PQY,
4766: OKL_K_HEADERS KHR
4767: WHERE KHR.ID = p_khr_id
4768: AND PQV.PDT_ID = PDT.ID
4769: AND PQV.PDQ_ID = PDQ.ID
4770: AND PQV.QVE_ID = QVE.ID

Line 5173: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;

5169: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5170: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
5171: l_nbv NUMBER;
5172: l_converted_amount NUMBER;
5173: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
5174: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
5175: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
5176: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
5177: p_init_msg_list VARCHAR(1) := 'T';

Line 5174: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;

5170: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
5171: l_nbv NUMBER;
5172: l_converted_amount NUMBER;
5173: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
5174: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
5175: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
5176: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
5177: p_init_msg_list VARCHAR(1) := 'T';
5178:

Line 5175: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;

5171: l_nbv NUMBER;
5172: l_converted_amount NUMBER;
5173: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
5174: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
5175: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
5176: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
5177: p_init_msg_list VARCHAR(1) := 'T';
5178:
5179: BEGIN

Line 5176: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;

5172: l_converted_amount NUMBER;
5173: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
5174: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
5175: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
5176: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
5177: p_init_msg_list VARCHAR(1) := 'T';
5178:
5179: BEGIN
5180: IF p_chr_id IS NULL OR p_chr_id = OKL_API.G_MISS_NUM THEN