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

Line 52: SELECT 'Y' FROM OKL_K_HEADERS khr

48: FUNCTION CHECK_MULTI_GAAP(p_khr_id IN NUMBER) RETURN VARCHAR2 IS
49:
50: -- cursor to check whether contract is a multi gaap contract.
51: CURSOR check_multi_gaap(p_ctr_id NUMBER) IS
52: SELECT 'Y' FROM OKL_K_HEADERS khr
53: WHERE khr.id = p_ctr_id
54: AND khr.multi_gaap_yn = 'Y';
55:
56: l_flag_value VARCHAR2(1) :='N';

Line 273: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;

269: ,p_period_to IN VARCHAR2
270: ,p_batch_name IN VARCHAR2) IS
271:
272: -- declare local variables
273: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
274: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
275: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
276: l_product_name OKL_PRODUCTS_V.name%TYPE;
277: l_rep_product_id OKL_PRODUCTS_V.reporting_pdt_id%TYPE;

Line 274: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

270: ,p_batch_name IN VARCHAR2) IS
271:
272: -- declare local variables
273: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
274: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
275: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
276: l_product_name OKL_PRODUCTS_V.name%TYPE;
277: l_rep_product_id OKL_PRODUCTS_V.reporting_pdt_id%TYPE;
278: l_rep_product_name OKL_PRODUCTS_V.name%TYPE;

Line 275: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

271:
272: -- declare local variables
273: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
274: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
275: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
276: l_product_name OKL_PRODUCTS_V.name%TYPE;
277: l_rep_product_id OKL_PRODUCTS_V.reporting_pdt_id%TYPE;
278: l_rep_product_name OKL_PRODUCTS_V.name%TYPE;
279: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;

Line 279: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;

275: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
276: l_product_name OKL_PRODUCTS_V.name%TYPE;
277: l_rep_product_id OKL_PRODUCTS_V.reporting_pdt_id%TYPE;
278: l_rep_product_name OKL_PRODUCTS_V.name%TYPE;
279: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
280: l_rep_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
281: l_currency_code OKL_TRX_CONTRACTS.currency_code%TYPE;
282: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
283: l_book_type_code OKL_TXD_ASSETS_V.tax_book%TYPE;

Line 280: l_rep_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

276: l_product_name OKL_PRODUCTS_V.name%TYPE;
277: l_rep_product_id OKL_PRODUCTS_V.reporting_pdt_id%TYPE;
278: l_rep_product_name OKL_PRODUCTS_V.name%TYPE;
279: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
280: l_rep_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
281: l_currency_code OKL_TRX_CONTRACTS.currency_code%TYPE;
282: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
283: l_book_type_code OKL_TXD_ASSETS_V.tax_book%TYPE;
284: l_contract_currency OKC_K_HEADERS_B.currency_code%TYPE;

Line 322: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr, OKL_PRODUCTS pdt

318: pdt.name pdt_name,
319: pdt.reporting_pdt_id,
320: khr.deal_type,
321: chr.currency_code
322: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr, OKL_PRODUCTS pdt
323: WHERE chr.id = khr.id
324: AND chr.scs_code = 'LEASE'
325: AND chr.sts_code IN ('BOOKED','EVERGREEN') -- Bug 3448049. removed approved and under revision statuses
326: AND khr.pdt_id = pdt.id

Line 412: OKL_K_HEADERS khr,

408: OKL_STRM_TYPE_B sty,
409: OKL_STREAMS stm,
410: OKL_STRM_ELEMENTS ste,
411: OKL_PROD_STRM_TYPES psty,
412: OKL_K_HEADERS khr,
413: OKC_K_HEADERS_B chr,
414: OKL_PRODUCTS pdt
415: WHERE stm.khr_id = p_khr_id
416: AND khr.id = chr.id

Line 479: OKL_K_HEADERS khr,

475: stytl.name stream_type,
476: decode(trx.accrual_activity,'NON-ACCRUAL','NON-ACCRUAL','ACCRUAL') accrual_activity,
477: SUM(txl.amount) total_amount
478: FROM OKL_STRM_TYPE_TL stytl,
479: OKL_K_HEADERS khr,
480: OKC_K_HEADERS_B chr,
481: OKL_PRODUCTS pdt,
482: OKL_TRX_CONTRACTS trx,
483: OKL_TXL_CNTRCT_LNS txl

Line 510: FROM okl_k_headers

506:
507: -- Cursor to check override status
508: CURSOR override_status_csr(p_khr_id NUMBER) IS
509: SELECT generate_accrual_override_yn
510: FROM okl_k_headers
511: WHERE id = p_khr_id;
512:
513: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE
514: INDEX BY BINARY_INTEGER;

Line 513: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE

509: SELECT generate_accrual_override_yn
510: FROM okl_k_headers
511: WHERE id = p_khr_id;
512:
513: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE
514: INDEX BY BINARY_INTEGER;
515:
516: TYPE gaap_contracts_rec_type IS RECORD(
517: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,

Line 517: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,

513: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE
514: INDEX BY BINARY_INTEGER;
515:
516: TYPE gaap_contracts_rec_type IS RECORD(
517: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
518: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
519: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
520: product_name OKL_PRODUCTS_V.NAME%TYPE,
521: rep_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,

Line 518: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,

514: INDEX BY BINARY_INTEGER;
515:
516: TYPE gaap_contracts_rec_type IS RECORD(
517: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
518: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
519: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
520: product_name OKL_PRODUCTS_V.NAME%TYPE,
521: rep_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
522: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,

Line 519: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,

515:
516: TYPE gaap_contracts_rec_type IS RECORD(
517: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
518: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
519: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
520: product_name OKL_PRODUCTS_V.NAME%TYPE,
521: rep_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
522: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
523: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE);

Line 521: rep_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,

517: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
518: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
519: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
520: product_name OKL_PRODUCTS_V.NAME%TYPE,
521: rep_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
522: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
523: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE);
524:
525: TYPE gaap_contracts_tbl_type IS TABLE OF gaap_contracts_rec_type

Line 522: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,

518: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
519: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
520: product_name OKL_PRODUCTS_V.NAME%TYPE,
521: rep_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
522: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
523: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE);
524:
525: TYPE gaap_contracts_tbl_type IS TABLE OF gaap_contracts_rec_type
526: INDEX BY BINARY_INTEGER;

Line 523: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE);

519: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
520: product_name OKL_PRODUCTS_V.NAME%TYPE,
521: rep_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
522: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
523: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE);
524:
525: TYPE gaap_contracts_tbl_type IS TABLE OF gaap_contracts_rec_type
526: INDEX BY BINARY_INTEGER;
527: