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

Line 60: -- SUBTYPE khr_id_type IS okl_k_headers_full_v.id%type;

56: lux_tapv_rec Okl_tap_pvt.tapv_rec_type;
57:
58: -- sjalasut, commented the subtype declaration. changed the usages to point
59: -- to the table.column names.
60: -- SUBTYPE khr_id_type IS okl_k_headers_full_v.id%type;
61: l_khr_id okc_k_headers_b.id%TYPE;
62: l_currency_code okl_k_headers_full_v.currency_code%type;
63: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;
64: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;

Line 62: l_currency_code okl_k_headers_full_v.currency_code%type;

58: -- sjalasut, commented the subtype declaration. changed the usages to point
59: -- to the table.column names.
60: -- SUBTYPE khr_id_type IS okl_k_headers_full_v.id%type;
61: l_khr_id okc_k_headers_b.id%TYPE;
62: l_currency_code okl_k_headers_full_v.currency_code%type;
63: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;
64: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;
65: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;
66:

Line 63: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;

59: -- to the table.column names.
60: -- SUBTYPE khr_id_type IS okl_k_headers_full_v.id%type;
61: l_khr_id okc_k_headers_b.id%TYPE;
62: l_currency_code okl_k_headers_full_v.currency_code%type;
63: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;
64: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;
65: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;
66:
67: l_created_tap BOOLEAN := TRUE;

Line 64: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;

60: -- SUBTYPE khr_id_type IS okl_k_headers_full_v.id%type;
61: l_khr_id okc_k_headers_b.id%TYPE;
62: l_currency_code okl_k_headers_full_v.currency_code%type;
63: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;
64: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;
65: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;
66:
67: l_created_tap BOOLEAN := TRUE;
68: l_created_tpl BOOLEAN := TRUE;

Line 65: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;

61: l_khr_id okc_k_headers_b.id%TYPE;
62: l_currency_code okl_k_headers_full_v.currency_code%type;
63: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;
64: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;
65: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;
66:
67: l_created_tap BOOLEAN := TRUE;
68: l_created_tpl BOOLEAN := TRUE;
69: l_created_dist BOOLEAN := TRUE;

Line 81: FROM okl_k_headers khr

77: lx_tldv_rec okl_txd_ar_ln_dtls_pub.tldv_rec_type;
78:
79: CURSOR pdt_id_csr (p_khr_id NUMBER) IS
80: SELECT khr.pdt_id
81: FROM okl_k_headers khr
82: WHERE khr.id = p_khr_id;
83:
84: -- sjalasut, modified the below cursor to have khr_id be picked up from
85: -- okl_txl_ap_inv_lns_v instead of okl_trx_ap_invoices_v

Line 149: FROM okl_k_headers_full_v

145: SELECT currency_code
146: ,currency_conversion_type
147: ,currency_conversion_rate
148: ,currency_conversion_date
149: FROM okl_k_headers_full_v
150: WHERE id = cp_khr_id;
151:
152: cnt NUMBER;
153: BEGIN

Line 415: okl_k_headers khl,

411: FROM okl_strm_elements ste,
412: okl_streams stm,
413: okl_strm_type_v sty,
414: okc_k_headers_b khr,
415: okl_k_headers khl,
416: okc_k_lines_b kle,
417: okc_statuses_b khs
418: WHERE trunc(ste.stream_element_date) > trunc(nvl(cp_term_date_from, ste.stream_element_date))
419: AND trunc(ste.stream_element_date) <= trunc(nvl(cp_term_date_to, ste.stream_element_date))

Line 566: okl_k_headers khl,

562: FROM okl_strm_elements ste,
563: okl_streams stm,
564: okl_strm_type_v sty,
565: okc_k_headers_b khr,
566: okl_k_headers khl,
567: okc_k_lines_b kle,
568: okc_statuses_b khs
569: WHERE trunc(ste.stream_element_date) >= trunc(nvl(cp_term_date_from, ste.stream_element_date))
570: AND trunc(ste.stream_element_date) <= trunc(nvl(cp_term_date_to, ste.stream_element_date))

Line 773: okl_k_headers khl,

769: FROM okl_strm_elements ste,
770: okl_streams stm,
771: okl_strm_type_v sty,
772: okc_k_headers_b khr,
773: okl_k_headers khl,
774: okc_k_lines_b kle,
775: okc_statuses_b khs
776: WHERE trunc(ste.stream_element_date) >= trunc(nvl(cp_term_date_from, ste.stream_element_date))
777: AND trunc(ste.stream_element_date) <= trunc(nvl(cp_term_date_to, ste.stream_element_date))

Line 893: ,OKL_K_HEADERS khr

889: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
890: ,khr.legal_entity_id
891: FROM okc_k_headers_b chr,hr_operating_units hr
892: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
893: ,OKL_K_HEADERS khr
894: WHERE chr.authoring_org_id = hr.organization_id
895: AND chr.id = p_chr_id
896: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
897: AND khr.id = chr.id;

Line 903: l_legal_entity_id okl_k_headers.legal_entity_id%TYPE;

899: l_authoring_org_id okc_k_headers_b.authoring_org_id%TYPE;
900: l_currency_code okc_k_headers_b.currency_code%TYPE;
901: l_set_of_books_id hr_operating_units.set_of_books_id%TYPE;
902: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
903: l_legal_entity_id okl_k_headers.legal_entity_id%TYPE;
904:
905: CURSOR get_passthru_csr (p_chr_id NUMBER, p_cle_id NUMBER) IS
906: SELECT id,
907: passthru_stream_type_id,