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

Line 162: -- FUNCTION get_chrv_rec for: OKC_K_HEADERS_V

158: ------------------------------------------------------------------
159: --Functions to Fetch Data from Tables.
160: -----------------------------------------------------------------
161: ---------------------------------------------------------------------------
162: -- FUNCTION get_chrv_rec for: OKC_K_HEADERS_V
163: ---------------------------------------------------------------------------
164: FUNCTION get_chrv_rec (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
165: x_return_status OUT NOCOPY VARCHAR2)
166: RETURN chrv_rec_type IS

Line 164: FUNCTION get_chrv_rec (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

160: -----------------------------------------------------------------
161: ---------------------------------------------------------------------------
162: -- FUNCTION get_chrv_rec for: OKC_K_HEADERS_V
163: ---------------------------------------------------------------------------
164: FUNCTION get_chrv_rec (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
165: x_return_status OUT NOCOPY VARCHAR2)
166: RETURN chrv_rec_type IS
167: CURSOR okc_chrv_pk_csr(p_id OKC_K_HEADERS_V.ID%TYPE) IS
168: SELECT ID,

Line 167: CURSOR okc_chrv_pk_csr(p_id OKC_K_HEADERS_V.ID%TYPE) IS

163: ---------------------------------------------------------------------------
164: FUNCTION get_chrv_rec (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
165: x_return_status OUT NOCOPY VARCHAR2)
166: RETURN chrv_rec_type IS
167: CURSOR okc_chrv_pk_csr(p_id OKC_K_HEADERS_V.ID%TYPE) IS
168: SELECT ID,
169: OBJECT_VERSION_NUMBER,
170: SFWT_FLAG,
171: CHR_ID_RESPONSE,

Line 246: FROM okc_k_headers_v chrv

242: CREATION_DATE,
243: LAST_UPDATED_BY,
244: LAST_UPDATE_DATE,
245: LAST_UPDATE_LOGIN
246: FROM okc_k_headers_v chrv
247: WHERE chrv.id = p_id;
248: x_chrv_rec chrv_rec_type;
249: BEGIN
250: OPEN okc_chrv_pk_csr (p_chr_id);

Line 523: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

519: x_chr_id OUT NOCOPY NUMBER)
520: AS
521: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_WORKING_COPY';
522: l_seq_no NUMBER;
523: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
524: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
525: l_khrv_rec khrv_rec_type;
526: x_khrv_rec khrv_rec_type;
527: l_chrv_rec chrv_rec_type;

Line 524: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

520: AS
521: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_WORKING_COPY';
522: l_seq_no NUMBER;
523: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
524: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
525: l_khrv_rec khrv_rec_type;
526: x_khrv_rec khrv_rec_type;
527: l_chrv_rec chrv_rec_type;
528: x_chrv_rec chrv_rec_type;

Line 532: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

528: x_chrv_rec chrv_rec_type;
529:
530:
531:
532: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
533: SELECT contract_number
534: FROM okc_k_headers_v
535: WHERE id = p_chr_id;
536:

Line 534: FROM okc_k_headers_v

530:
531:
532: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
533: SELECT contract_number
534: FROM okc_k_headers_v
535: WHERE id = p_chr_id;
536:
537:
538: BEGIN

Line 664: p_working_copy_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

660: PROCEDURE update_hdr_info(
661: x_return_status OUT NOCOPY VARCHAR2,
662: x_msg_count OUT NOCOPY NUMBER,
663: x_msg_data OUT NOCOPY VARCHAR2,
664: p_working_copy_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
665: p_start_date IN OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
666: p_end_date IN OKL_K_HEADERS_FULL_V.END_DATE%TYPE,
667: p_term_duration IN OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE
668: )