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 8622: okl_sif_fees fee

8618: okl_sif_lines line,
8619: okc_k_lines_b cle,
8620: okl_k_lines kle,
8621: okc_line_styles_b lse,
8622: okl_sif_fees fee
8623: WHERE lev.sir_id = ret.id
8624: AND lev.level_type = 'Payment'
8625: AND ret.transaction_number = sif.transaction_number
8626: AND sif.id = line.sif_id

Line 13664: -- Solution: Passing the Fee Start Date in okl_sif_fees_b.date_paid to pass it to SuperTrump

13660: END IF;
13661:
13662: -- RGOOTY: Bug 7552496: Start
13663: -- Issue: Periodic Income Streams are not correct when Fee starts later Contract Start Date
13664: -- Solution: Passing the Fee Start Date in okl_sif_fees_b.date_paid to pass it to SuperTrump
13665: -- using the StartAccrual tag only for the First Cash flow level
13666: IF idx = 1
13667: THEN
13668: IF(l_rl_rec.rule_information2 IS NULL OR

Line 15329: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;

15325: khr.id = p_chr_id;
15326:
15327: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
15328: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
15329: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
15330: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
15331: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
15332: l_variable_rate okl_sif_fees.rate%TYPE;
15333: l_total_oec okl_k_lines_full_v.oec%TYPE;

Line 15330: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;

15326:
15327: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
15328: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
15329: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
15330: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
15331: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
15332: l_variable_rate okl_sif_fees.rate%TYPE;
15333: l_total_oec okl_k_lines_full_v.oec%TYPE;
15334: --Added by kthiruva for the VR build

Line 15331: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;

15327: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
15328: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
15329: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
15330: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
15331: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
15332: l_variable_rate okl_sif_fees.rate%TYPE;
15333: l_total_oec okl_k_lines_full_v.oec%TYPE;
15334: --Added by kthiruva for the VR build
15335: l_ppd_assigned VARCHAR2(1) := 'N';

Line 15332: l_variable_rate okl_sif_fees.rate%TYPE;

15328: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
15329: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
15330: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
15331: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
15332: l_variable_rate okl_sif_fees.rate%TYPE;
15333: l_total_oec okl_k_lines_full_v.oec%TYPE;
15334: --Added by kthiruva for the VR build
15335: l_ppd_assigned VARCHAR2(1) := 'N';
15336: l_rent_sty_id strm_rec_type;

Line 17614: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;

17610: khr.id = p_chr_id;
17611:
17612: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
17613: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
17614: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
17615: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
17616: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
17617: l_variable_rate okl_sif_fees.rate%TYPE;
17618: l_total_oec okl_k_lines_full_v.oec%TYPE;

Line 17615: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;

17611:
17612: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
17613: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
17614: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
17615: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
17616: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
17617: l_variable_rate okl_sif_fees.rate%TYPE;
17618: l_total_oec okl_k_lines_full_v.oec%TYPE;
17619: --Added by kthiruva for the VR build

Line 17616: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;

17612: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
17613: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
17614: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
17615: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
17616: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
17617: l_variable_rate okl_sif_fees.rate%TYPE;
17618: l_total_oec okl_k_lines_full_v.oec%TYPE;
17619: --Added by kthiruva for the VR build
17620: l_rent_sty_id strm_rec_type;

Line 17617: l_variable_rate okl_sif_fees.rate%TYPE;

17613: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
17614: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
17615: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
17616: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
17617: l_variable_rate okl_sif_fees.rate%TYPE;
17618: l_total_oec okl_k_lines_full_v.oec%TYPE;
17619: --Added by kthiruva for the VR build
17620: l_rent_sty_id strm_rec_type;
17621: l_prev_ppd NUMBER := 0;