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_LA_STREAM_PVT dependencies on OKL_SIF_FEES

Line 52: advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKL_CREATE_STREAMS_PVT.G_ARREARS,

48: -----------------------------------------------------------------------------------
49: -- Start of Bug#2757289 modification bakuchib
50: TYPE stub_rec_type IS RECORD (
51: number_of_periods NUMBER := 1,
52: advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKL_CREATE_STREAMS_PVT.G_ARREARS,
53: period OKL_SIF_FEES_V.period%TYPE := 'T');
54: g_stub_rec stub_rec_type;
55: SUBTYPE pdtv_rec_type IS okl_setupproducts_pvt.pdtv_rec_type;
56: SUBTYPE ast_dtl_tbl_type IS okl_activate_asset_pvt.ast_dtl_tbl_type;

Line 53: period OKL_SIF_FEES_V.period%TYPE := 'T');

49: -- Start of Bug#2757289 modification bakuchib
50: TYPE stub_rec_type IS RECORD (
51: number_of_periods NUMBER := 1,
52: advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKL_CREATE_STREAMS_PVT.G_ARREARS,
53: period OKL_SIF_FEES_V.period%TYPE := 'T');
54: g_stub_rec stub_rec_type;
55: SUBTYPE pdtv_rec_type IS okl_setupproducts_pvt.pdtv_rec_type;
56: SUBTYPE ast_dtl_tbl_type IS okl_activate_asset_pvt.ast_dtl_tbl_type;
57: SUBTYPE pdt_param_rec_type IS okl_setupproducts_pvt.pdt_parameters_rec_type;

Line 7128: okl_sif_fees fee

7124: okl_sif_lines line,
7125: okc_k_lines_b cle,
7126: okl_k_lines kle,
7127: okc_line_styles_b lse,
7128: okl_sif_fees fee
7129: WHERE lev.sir_id = ret.id
7130: AND lev.level_type = 'Payment'
7131: AND ret.transaction_number = sif.transaction_number
7132: AND sif.id = line.sif_id

Line 13226: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;

13222: khr.id = p_chr_id;
13223:
13224: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
13225: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
13226: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
13227: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
13228: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
13229: l_variable_rate okl_sif_fees.rate%TYPE;
13230: l_total_oec okl_k_lines_full_v.oec%TYPE;

Line 13227: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;

13223:
13224: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
13225: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
13226: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
13227: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
13228: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
13229: l_variable_rate okl_sif_fees.rate%TYPE;
13230: l_total_oec okl_k_lines_full_v.oec%TYPE;
13231: --Added by kthiruva for the VR build

Line 13228: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;

13224: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
13225: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
13226: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
13227: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
13228: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
13229: l_variable_rate okl_sif_fees.rate%TYPE;
13230: l_total_oec okl_k_lines_full_v.oec%TYPE;
13231: --Added by kthiruva for the VR build
13232: l_ppd_assigned VARCHAR2(1) := 'N';

Line 13229: l_variable_rate okl_sif_fees.rate%TYPE;

13225: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
13226: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
13227: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
13228: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
13229: l_variable_rate okl_sif_fees.rate%TYPE;
13230: l_total_oec okl_k_lines_full_v.oec%TYPE;
13231: --Added by kthiruva for the VR build
13232: l_ppd_assigned VARCHAR2(1) := 'N';
13233: l_rent_sty_id strm_rec_type;

Line 15301: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;

15297: khr.id = p_chr_id;
15298:
15299: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
15300: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
15301: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
15302: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
15303: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
15304: l_variable_rate okl_sif_fees.rate%TYPE;
15305: l_total_oec okl_k_lines_full_v.oec%TYPE;

Line 15302: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;

15298:
15299: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
15300: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
15301: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
15302: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
15303: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
15304: l_variable_rate okl_sif_fees.rate%TYPE;
15305: l_total_oec okl_k_lines_full_v.oec%TYPE;
15306: --Added by kthiruva for the VR build

Line 15303: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;

15299: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
15300: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
15301: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
15302: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
15303: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
15304: l_variable_rate okl_sif_fees.rate%TYPE;
15305: l_total_oec okl_k_lines_full_v.oec%TYPE;
15306: --Added by kthiruva for the VR build
15307: l_rent_sty_id strm_rec_type;

Line 15304: l_variable_rate okl_sif_fees.rate%TYPE;

15300: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
15301: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
15302: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
15303: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
15304: l_variable_rate okl_sif_fees.rate%TYPE;
15305: l_total_oec okl_k_lines_full_v.oec%TYPE;
15306: --Added by kthiruva for the VR build
15307: l_rent_sty_id strm_rec_type;
15308: l_prev_ppd NUMBER := 0;