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_CONTRACT_TOP_LINE_PVT dependencies on OKC_K_HEADERS_B

Line 60: from okc_k_headers_b k

56: x_cle_id OUT NOCOPY NUMBER ) IS
57:
58: CURSOR l_serv_contract_csr IS
59: select id
60: from okc_k_headers_b k
61: where contract_number = p_contract_number
62: and scs_code = 'SERVICE';
63:
64: CURSOR l_rel_vers_csr IS

Line 72: from okc_k_headers_b k

68: and opn_code = 'CHECK_RULE';
69:
70: CURSOR l_serv_contract9_csr IS
71: select id
72: from okc_k_headers_b k
73: where contract_number = p_contract_number
74: and scs_code = 'SERVICE';
75:
76: CURSOR l_serv_line_csr IS

Line 89: from OKC_K_HEADERS_B K,

85: where name = p_supplier_name;
86:
87: CURSOR l_k_sts_csr IS
88: select k.sts_code, sts.ste_code
89: from OKC_K_HEADERS_B K,
90: OKC_STATUSES_B STS
91: where STS.CODE = K.STS_CODE
92: and K.ID = p_chr_id;
93:

Line 99: FROM OKC_K_HEADERS_B chr,

95: SELECT sty_id
96: FROM okl_strm_tmpt_full_uv
97: WHERE STY_PURPOSE = 'SERVICE_PAYMENT'
98: and exists (SELECT 1
99: FROM OKC_K_HEADERS_B chr,
100: OKL_K_HEADERS khr
101: WHERE chr.id = khr.id
102: AND khr.pdt_id = okl_strm_tmpt_full_uv.PDT_ID
103: AND trunc(chr.start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE) AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),chr.start_date+1)

Line 107: l_chr_id okc_k_headers_b.id%type := null;

103: AND trunc(chr.start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE) AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),chr.start_date+1)
104: AND chr.id = p_chr_id)
105: and sty_name = p_item_name;
106:
107: l_chr_id okc_k_headers_b.id%type := null;
108: l_s_chr_id okc_k_headers_b.id%type := null;
109: l_s_cle_id okc_k_lines_b.id%type := null;
110: l_supp_id okx_vendors_v.id1%type := null;
111: x_okl_cle_id okc_k_lines_b.id%type := null;

Line 108: l_s_chr_id okc_k_headers_b.id%type := null;

104: AND chr.id = p_chr_id)
105: and sty_name = p_item_name;
106:
107: l_chr_id okc_k_headers_b.id%type := null;
108: l_s_chr_id okc_k_headers_b.id%type := null;
109: l_s_cle_id okc_k_lines_b.id%type := null;
110: l_supp_id okx_vendors_v.id1%type := null;
111: x_okl_cle_id okc_k_lines_b.id%type := null;
112: l_rel_vers_id number := null;

Line 114: l_sts_code OKC_K_HEADERS_B.sts_code%type:= null;

110: l_supp_id okx_vendors_v.id1%type := null;
111: x_okl_cle_id okc_k_lines_b.id%type := null;
112: l_rel_vers_id number := null;
113: l_strmtyp_id okl_strm_tmpt_full_uv.sty_id%type := null;
114: l_sts_code OKC_K_HEADERS_B.sts_code%type:= null;
115: l_ste_code OKC_STATUSES_B.STE_CODE%type:= null;
116:
117: l_api_name CONSTANT VARCHAR2(30) := 'create_contract_link_serv';
118: l_api_version CONSTANT NUMBER := 1.0;

Line 362: from okc_k_headers_b k

358: x_cle_id OUT NOCOPY NUMBER ) IS
359:
360: CURSOR l_serv_contract_csr IS
361: select id
362: from okc_k_headers_b k
363: where contract_number = p_contract_number
364: and scs_code = 'SERVICE';
365:
366: CURSOR l_rel_vers_csr IS

Line 374: from okc_k_headers_b k

370: and opn_code = 'CHECK_RULE';
371:
372: CURSOR l_serv_contract9_csr IS
373: select id
374: from okc_k_headers_b k
375: where contract_number = p_contract_number
376: and scs_code = 'SERVICE';
377:
378: CURSOR l_serv_line_csr IS

Line 389: l_chr_id okc_k_headers_b.id%type := null;

385: select id1
386: from okx_vendors_v
387: where name = p_supplier_name;
388:
389: l_chr_id okc_k_headers_b.id%type := null;
390: l_s_chr_id okc_k_headers_b.id%type := null;
391: l_s_cle_id okc_k_lines_b.id%type := null;
392: l_supp_id okx_vendors_v.id1%type := null;
393: x_okl_cle_id okc_k_lines_b.id%type := null;

Line 390: l_s_chr_id okc_k_headers_b.id%type := null;

386: from okx_vendors_v
387: where name = p_supplier_name;
388:
389: l_chr_id okc_k_headers_b.id%type := null;
390: l_s_chr_id okc_k_headers_b.id%type := null;
391: l_s_cle_id okc_k_lines_b.id%type := null;
392: l_supp_id okx_vendors_v.id1%type := null;
393: x_okl_cle_id okc_k_lines_b.id%type := null;
394: l_rel_vers_id number := null;

Line 614: from okc_k_headers_b chr

610: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
611:
612: CURSOR get_k_dates_csr(l_id NUMBER) IS
613: select chr.start_date, chr.end_date
614: from okc_k_headers_b chr
615: where chr.id = l_id;
616:
617: l_start_date okc_k_headers_b.start_date%type := null;
618: l_end_date okc_k_headers_b.end_date%type := null;

Line 617: l_start_date okc_k_headers_b.start_date%type := null;

613: select chr.start_date, chr.end_date
614: from okc_k_headers_b chr
615: where chr.id = l_id;
616:
617: l_start_date okc_k_headers_b.start_date%type := null;
618: l_end_date okc_k_headers_b.end_date%type := null;
619:
620: l_cap_yn OKL_STRMTYP_SOURCE_V.CAPITALIZE_YN%type := null;
621: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%type := null;

Line 618: l_end_date okc_k_headers_b.end_date%type := null;

614: from okc_k_headers_b chr
615: where chr.id = l_id;
616:
617: l_start_date okc_k_headers_b.start_date%type := null;
618: l_end_date okc_k_headers_b.end_date%type := null;
619:
620: l_cap_yn OKL_STRMTYP_SOURCE_V.CAPITALIZE_YN%type := null;
621: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%type := null;
622:

Line 950: from okc_k_headers_b chr

946: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
947:
948: CURSOR get_k_dates_csr(l_id number) IS
949: select chr.start_date, chr.end_date
950: from okc_k_headers_b chr
951: where chr.id = l_id;
952:
953: l_start_date okc_k_headers_b.start_date%type := null;
954: l_end_date okc_k_headers_b.end_date%type := null;

Line 953: l_start_date okc_k_headers_b.start_date%type := null;

949: select chr.start_date, chr.end_date
950: from okc_k_headers_b chr
951: where chr.id = l_id;
952:
953: l_start_date okc_k_headers_b.start_date%type := null;
954: l_end_date okc_k_headers_b.end_date%type := null;
955:
956: l_cap_yn OKL_STRMTYP_SOURCE_V.CAPITALIZE_YN%type := null;
957: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%type := null;

Line 954: l_end_date okc_k_headers_b.end_date%type := null;

950: from okc_k_headers_b chr
951: where chr.id = l_id;
952:
953: l_start_date okc_k_headers_b.start_date%type := null;
954: l_end_date okc_k_headers_b.end_date%type := null;
955:
956: l_cap_yn OKL_STRMTYP_SOURCE_V.CAPITALIZE_YN%type := null;
957: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%type := null;
958:

Line 1702: scscode OKC_K_HEADERS_B.SCS_CODE%TYPE ;

1698: l_proc_name VARCHAR2(35) := 'VALIDATE_FEE_EXPENSE_RULE';
1699: l_api_version NUMBER := 1.0;
1700:
1701: l_id1 VARCHAR2(30);
1702: scscode OKC_K_HEADERS_B.SCS_CODE%TYPE ;
1703:
1704: CURSOR contract_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1705: p_line_id OKC_K_LINES_V.ID%TYPE) IS
1706: SELECT line.start_date,

Line 1713: FROM okc_k_headers_b head,

1709: line.capital_amount,
1710: style.lty_code,
1711: line.initial_direct_cost,
1712: line.fee_type
1713: FROM okc_k_headers_b head,
1714: okl_k_lines_full_v line,
1715: okc_line_styles_b style
1716: WHERE head.id = line.dnz_chr_id
1717: AND line.lse_id = style.id

Line 1722: FROM okc_k_headers_b head

1718: AND head.id = p_chr_id
1719: AND line.id = p_line_id;
1720: CURSOR scscode_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE ) IS
1721: SELECT head.scs_code
1722: FROM okc_k_headers_b head
1723: WHERE head.id = p_chr_id ;
1724:
1725: CURSOR strm_cap_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE,
1726: p_line_id OKC_K_LINES_B.ID%TYPE) IS

Line 1725: CURSOR strm_cap_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE,

1721: SELECT head.scs_code
1722: FROM okc_k_headers_b head
1723: WHERE head.id = p_chr_id ;
1724:
1725: CURSOR strm_cap_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE,
1726: p_line_id OKC_K_LINES_B.ID%TYPE) IS
1727: SELECT stream.capitalize_yn
1728: FROM okl_k_lines_full_v line,
1729: okc_k_items_v item,