APPS.OKL_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKC_K_HEADERS_V

Line 254: -- FUNCTION get_chrv_rec for: OKC_K_HEADERS_V

250: ------------------------------------------------------------------
251: --Functions to Fetch Data from Tables.
252: -----------------------------------------------------------------
253: ---------------------------------------------------------------------------
254: -- FUNCTION get_chrv_rec for: OKC_K_HEADERS_V
255: ---------------------------------------------------------------------------
256: FUNCTION get_chrv_rec (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
257: x_return_status OUT NOCOPY VARCHAR2)
258: RETURN chrv_rec_type IS

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

252: -----------------------------------------------------------------
253: ---------------------------------------------------------------------------
254: -- FUNCTION get_chrv_rec for: OKC_K_HEADERS_V
255: ---------------------------------------------------------------------------
256: FUNCTION get_chrv_rec (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
257: x_return_status OUT NOCOPY VARCHAR2)
258: RETURN chrv_rec_type IS
259: CURSOR okc_chrv_pk_csr(p_id OKC_K_HEADERS_V.ID%TYPE) IS
260: SELECT ID,

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

255: ---------------------------------------------------------------------------
256: FUNCTION get_chrv_rec (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
257: x_return_status OUT NOCOPY VARCHAR2)
258: RETURN chrv_rec_type IS
259: CURSOR okc_chrv_pk_csr(p_id OKC_K_HEADERS_V.ID%TYPE) IS
260: SELECT ID,
261: OBJECT_VERSION_NUMBER,
262: SFWT_FLAG,
263: CHR_ID_RESPONSE,

Line 338: FROM okc_k_headers_v chrv

334: CREATION_DATE,
335: LAST_UPDATED_BY,
336: LAST_UPDATE_DATE,
337: LAST_UPDATE_LOGIN
338: FROM okc_k_headers_v chrv
339: WHERE chrv.id = p_id;
340: x_chrv_rec chrv_rec_type;
341: BEGIN
342: OPEN okc_chrv_pk_csr (p_chr_id);

Line 678: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

674: x_chr_id OUT NOCOPY NUMBER)
675: AS
676: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_WORKING_COPY';
677: l_seq_no NUMBER;
678: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
679: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
680: l_khrv_rec khrv_rec_type;
681: x_khrv_rec khrv_rec_type;
682: l_chrv_rec chrv_rec_type;

Line 679: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

675: AS
676: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_WORKING_COPY';
677: l_seq_no NUMBER;
678: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
679: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
680: l_khrv_rec khrv_rec_type;
681: x_khrv_rec khrv_rec_type;
682: l_chrv_rec chrv_rec_type;
683: x_chrv_rec chrv_rec_type;

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

683: x_chrv_rec chrv_rec_type;
684:
685:
686:
687: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
688: SELECT contract_number
689: FROM okc_k_headers_v
690: WHERE id = p_chr_id;
691:

Line 689: FROM okc_k_headers_v

685:
686:
687: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
688: SELECT contract_number
689: FROM okc_k_headers_v
690: WHERE id = p_chr_id;
691:
692:
693: BEGIN

Line 817: p_working_copy_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

813: PROCEDURE update_hdr_info(
814: x_return_status OUT NOCOPY VARCHAR2,
815: x_msg_count OUT NOCOPY NUMBER,
816: x_msg_data OUT NOCOPY VARCHAR2,
817: p_working_copy_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
818: p_start_date IN OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
819: p_end_date IN OKL_K_HEADERS_FULL_V.END_DATE%TYPE,
820: p_term_duration IN OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE
821: )

Line 7177: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

7173: FROM okl_trx_types_tl
7174: WHERE LANGUAGE = 'US'
7175: AND name = 'Principal Paydown';
7176:
7177: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
7178: SELECT currency_code,
7179: authoring_org_id
7180: FROM okl_k_headers_full_v
7181: WHERE id = p_chr_id;