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.OKS_SETUP_UTIL_PUB dependencies on OKS_KHR_PVT

Line 90: l_khrv_tbl OKS_KHR_PVT.khrv_tbl_type;

86: from oks_k_headers_b
87: where chr_id=p_chr_id;
88:
89: get_ccr_rec get_ccr%rowtype;
90: l_khrv_tbl OKS_KHR_PVT.khrv_tbl_type;
91: x_khrv_tbl OKS_KHR_PVT.khrv_tbl_type;
92: l_error_tbl OKC_API.ERROR_TBL_TYPE;
93:
94: Begin

Line 91: x_khrv_tbl OKS_KHR_PVT.khrv_tbl_type;

87: where chr_id=p_chr_id;
88:
89: get_ccr_rec get_ccr%rowtype;
90: l_khrv_tbl OKS_KHR_PVT.khrv_tbl_type;
91: x_khrv_tbl OKS_KHR_PVT.khrv_tbl_type;
92: l_error_tbl OKC_API.ERROR_TBL_TYPE;
93:
94: Begin
95: l_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 299: l_khrv_tbl OKS_KHR_PVT.khrv_tbl_type;

295: l_msg_count Number;
296: l_msg_data Varchar2(2000);
297: l_api_version Number := 1;
298: l_init_msg_list Varchar2(1) := 'F';
299: l_khrv_tbl OKS_KHR_PVT.khrv_tbl_type;
300: x_khrv_tbl OKS_KHR_PVT.khrv_tbl_type;
301:
302: CURSOR get_hdr_attr_csr (p_chr_id NUMBER) IS
303: SELECT *

Line 300: x_khrv_tbl OKS_KHR_PVT.khrv_tbl_type;

296: l_msg_data Varchar2(2000);
297: l_api_version Number := 1;
298: l_init_msg_list Varchar2(1) := 'F';
299: l_khrv_tbl OKS_KHR_PVT.khrv_tbl_type;
300: x_khrv_tbl OKS_KHR_PVT.khrv_tbl_type;
301:
302: CURSOR get_hdr_attr_csr (p_chr_id NUMBER) IS
303: SELECT *
304: FROM oks_k_headers_b

Line 2356: l_khrv_tbl oks_khr_pvt.khrv_tbl_type;

2352:
2353: get_topline_rec get_toplines%Rowtype;
2354: --get_qto_rec get_qto%rowtype;
2355: get_cpl_rec get_cpl%rowtype;
2356: l_khrv_tbl oks_khr_pvt.khrv_tbl_type;
2357: x_khrv_tbl oks_khr_pvt.khrv_tbl_type;
2358: l_error_tbl okc_api.error_tbl_type;
2359: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
2360: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

Line 2357: x_khrv_tbl oks_khr_pvt.khrv_tbl_type;

2353: get_topline_rec get_toplines%Rowtype;
2354: --get_qto_rec get_qto%rowtype;
2355: get_cpl_rec get_cpl%rowtype;
2356: l_khrv_tbl oks_khr_pvt.khrv_tbl_type;
2357: x_khrv_tbl oks_khr_pvt.khrv_tbl_type;
2358: l_error_tbl okc_api.error_tbl_type;
2359: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
2360: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
2361: l_clev_rec_in okc_contract_pub.clev_rec_type;

Line 3976: l_khrv_tbl OKS_KHR_PVT.khrv_tbl_type;

3972: l_QUOTE_TO_EMAIL_ID NUMBER;
3973: l_QUOTE_TO_PHONE_ID NUMBER;
3974: l_QUOTE_TO_FAX_ID NUMBER;
3975:
3976: l_khrv_tbl OKS_KHR_PVT.khrv_tbl_type;
3977: x_khrv_tbl OKS_KHR_PVT.khrv_tbl_type;
3978:
3979: BEGIN
3980: x_return_status := 'E';

Line 3977: x_khrv_tbl OKS_KHR_PVT.khrv_tbl_type;

3973: l_QUOTE_TO_PHONE_ID NUMBER;
3974: l_QUOTE_TO_FAX_ID NUMBER;
3975:
3976: l_khrv_tbl OKS_KHR_PVT.khrv_tbl_type;
3977: x_khrv_tbl OKS_KHR_PVT.khrv_tbl_type;
3978:
3979: BEGIN
3980: x_return_status := 'E';
3981: If p_contact_id is not null Then