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_VP_TERMINATE_PVT dependencies on OKC_K_HEADERS_V

Line 66: l_k_num okc_k_headers_v.contract_number%TYPE;

62: AND A.object_chr_id=p_chr_id AND
63: C.id=B.cop_id and C.opn_code='RENEWAL'
64: AND B.id=A.oie_id AND A.active_yn='Y' AND
65: A.subject_cle_id IS NULL AND A.object_cle_id IS NULL;
66: l_k_num okc_k_headers_v.contract_number%TYPE;
67: l_k_mod okc_k_headers_v.contract_number_modifier%TYPE;
68:
69: -- Find out which statuses are valid FOR termination to continue
70:

Line 67: l_k_mod okc_k_headers_v.contract_number_modifier%TYPE;

63: C.id=B.cop_id and C.opn_code='RENEWAL'
64: AND B.id=A.oie_id AND A.active_yn='Y' AND
65: A.subject_cle_id IS NULL AND A.object_cle_id IS NULL;
66: l_k_num okc_k_headers_v.contract_number%TYPE;
67: l_k_mod okc_k_headers_v.contract_number_modifier%TYPE;
68:
69: -- Find out which statuses are valid FOR termination to continue
70:
71: l_chg_request_in_process VARCHAR2(1);

Line 350: SELECT contract_number,scs_code,sts_code,end_date from okc_k_headers_v

346: l1_return_status VARCHAR2(3);
347:
348:
349: CURSOR cur_k_header(p_id NUMBER) IS
350: SELECT contract_number,scs_code,sts_code,end_date from okc_k_headers_v
351: WHERE id=p_id;
352:
353:
354: -- begin of block