DBA Data[Home] [Help]

APPS.OKL_COPY_CONTRACT_PVT dependencies on OKL_K_LINES_V

Line 82: --okl_k_headers_v and okl_k_lines_v

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.

Line 757: -- FUNCTION get_rec for: OKL_K_LINES_V

753: ----------------------------------------------------------------------
754: --end get_clev_rec
755: -----------------------------------------------------------------------
756: ---------------------------------------------------------------------------
757: -- FUNCTION get_rec for: OKL_K_LINES_V
758: ---------------------------------------------------------------------------
759: FUNCTION get_klev_rec (
760: p_klev_id IN NUMBER,
761: x_no_data_found OUT NOCOPY BOOLEAN

Line 902: FROM Okl_K_Lines_V

898: --Bug# 8677460
899: ORIG_CONTRACT_LINE_ID,
900: -- Bug 12938353: RGOOTY: Income Fee Enhancement
901: ORIGINATION_INCOME
902: FROM Okl_K_Lines_V
903: WHERE okl_k_lines_v.id = p_id;
904: l_okl_klev_pk okl_klev_pk_csr%ROWTYPE;
905: l_klev_rec klev_rec_type;
906: BEGIN

Line 903: WHERE okl_k_lines_v.id = p_id;

899: ORIG_CONTRACT_LINE_ID,
900: -- Bug 12938353: RGOOTY: Income Fee Enhancement
901: ORIGINATION_INCOME
902: FROM Okl_K_Lines_V
903: WHERE okl_k_lines_v.id = p_id;
904: l_okl_klev_pk okl_klev_pk_csr%ROWTYPE;
905: l_klev_rec klev_rec_type;
906: BEGIN
907: x_no_data_found := TRUE;

Line 10603: TYPE l_vendor_advance_paid_type IS TABLE OF okl_k_lines.vendor_advance_paid%TYPE INDEX BY BINARY_INTEGER;

10599: TYPE l_date_title_received_type IS TABLE OF okl_k_lines.date_title_received%TYPE INDEX BY BINARY_INTEGER;
10600: TYPE l_estimated_oec_type IS TABLE OF okl_k_lines.estimated_oec%TYPE INDEX BY BINARY_INTEGER;
10601: TYPE l_residual_percentage_type IS TABLE OF okl_k_lines.residual_percentage%TYPE INDEX BY BINARY_INTEGER;
10602: TYPE l_capital_reduction_type IS TABLE OF okl_k_lines.capital_reduction%TYPE INDEX BY BINARY_INTEGER;
10603: TYPE l_vendor_advance_paid_type IS TABLE OF okl_k_lines.vendor_advance_paid%TYPE INDEX BY BINARY_INTEGER;
10604: TYPE l_tradein_amount_type IS TABLE OF okl_k_lines.tradein_amount%TYPE INDEX BY BINARY_INTEGER;
10605: TYPE l_delivered_date_type IS TABLE OF okl_k_lines.delivered_date%TYPE INDEX BY BINARY_INTEGER;
10606: TYPE l_year_of_manufacture_type IS TABLE OF okl_k_lines.year_of_manufacture%TYPE INDEX BY BINARY_INTEGER;
10607: TYPE l_initial_direct_cost_type IS TABLE OF okl_k_lines.initial_direct_cost%TYPE INDEX BY BINARY_INTEGER;