78: Return l_lines_tbl;
79: END migrate_lines_tbl;
80: --------------------------------------------------------------------------
81: --Functions to fetch data from okc_k_headers_v, okc_k_lines_v,
82: --okl_k_headers_v and okl_k_lines_v
83: --These Functions are copy of local functions get_rec in
84: --OKC_CHR_PVT and OKL_KHR_PVT. These are repeated here since they have not
85: --been published. Any changes in in these in the original packages will
86: --also heve to be done here.
324: RETURN(get_chrv_rec(p_chrv_id, l_row_notfound));
325: END get_chrv_rec;
326:
327: ---------------------------------------------------------------------------
328: -- FUNCTION get_rec for: OKL_K_HEADERS_V
329: ---------------------------------------------------------------------------
330: FUNCTION get_khrv_rec (
331: p_khrv_id IN NUMBER,
332: x_no_data_found OUT NOCOPY BOOLEAN
421: DATE_TRADEIN,
422: DATE_FUNDING_EXPECTED,
423: --Added by dpsingh for LE Uptake
424: LEGAL_ENTITY_ID
425: FROM Okl_K_Headers_V
426: WHERE okl_k_headers_v.id = p_id;
427: l_okl_khrv_pk okl_khrv_pk_csr%ROWTYPE;
428: l_khrv_rec khrv_rec_type;
429: BEGIN
422: DATE_FUNDING_EXPECTED,
423: --Added by dpsingh for LE Uptake
424: LEGAL_ENTITY_ID
425: FROM Okl_K_Headers_V
426: WHERE okl_k_headers_v.id = p_id;
427: l_okl_khrv_pk okl_khrv_pk_csr%ROWTYPE;
428: l_khrv_rec khrv_rec_type;
429: BEGIN
430: x_no_data_found := TRUE;