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_PRICING_PVT dependencies on OKL_STREAMS

Line 34: okl_streams stm,

30: FROM okc_k_headers_b chr_so,
31: okc_line_styles_b lse_so,
32: okc_k_lines_b cle_so,
33: okl_strm_type_b sty,
34: okl_streams stm,
35: okl_strm_elements ele,
36: okl_strm_elements rte
37: WHERE stm.khr_id = chr_so.id
38: AND chr_so.id = p_khr_id

Line 95: okl_streams stm,

91: FROM okc_k_headers_b chr_so,
92: okc_line_styles_b lse_so,
93: okc_k_lines_b cle_so,
94: okl_strm_type_b sty,
95: okl_streams stm,
96: okl_strm_elements ele,
97: okl_strm_elements rte
98: WHERE stm.khr_id = chr_so.id
99: AND chr_so.id = p_khr_id

Line 156: x_principal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,

152: p_residual_value IN NUMBER,
153: p_start_date IN DATE,
154: p_asset_start_date IN DATE,
155: p_term_duration IN NUMBER,
156: x_principal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
157: x_interest_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
158: x_prin_bal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
159: x_termination_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
160: x_pre_tax_inc_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,

Line 157: x_interest_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,

153: p_start_date IN DATE,
154: p_asset_start_date IN DATE,
155: p_term_duration IN NUMBER,
156: x_principal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
157: x_interest_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
158: x_prin_bal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
159: x_termination_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
160: x_pre_tax_inc_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
161: x_interim_interest OUT NOCOPY NUMBER,

Line 158: x_prin_bal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,

154: p_asset_start_date IN DATE,
155: p_term_duration IN NUMBER,
156: x_principal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
157: x_interest_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
158: x_prin_bal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
159: x_termination_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
160: x_pre_tax_inc_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
161: x_interim_interest OUT NOCOPY NUMBER,
162: x_interim_days OUT NOCOPY NUMBER,

Line 159: x_termination_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,

155: p_term_duration IN NUMBER,
156: x_principal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
157: x_interest_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
158: x_prin_bal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
159: x_termination_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
160: x_pre_tax_inc_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
161: x_interim_interest OUT NOCOPY NUMBER,
162: x_interim_days OUT NOCOPY NUMBER,
163: x_interim_dpp OUT NOCOPY NUMBER,

Line 160: x_pre_tax_inc_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,

156: x_principal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
157: x_interest_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
158: x_prin_bal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
159: x_termination_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
160: x_pre_tax_inc_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
161: x_interim_interest OUT NOCOPY NUMBER,
162: x_interim_days OUT NOCOPY NUMBER,
163: x_interim_dpp OUT NOCOPY NUMBER,
164: x_iir OUT NOCOPY NUMBER,

Line 206: okl_streams stm,

202: sel.stream_element_date se_date,
203: sel.comments se_arrears,
204: sel.sel_id se_sel_id
205: FROM okl_strm_elements sel,
206: okl_streams stm,
207: okl_strm_type_b sty,
208: okl_strm_type_tl styt
209: WHERE stm.kle_id = p_kle_id
210: AND stm.say_code = 'CURR'

Line 222: from okl_streams stm,

218: ORDER BY sel.stream_element_date;
219:
220: Cursor c_stub IS
221: Select sel.id
222: from okl_streams stm,
223: okl_strm_elements sel
224: where stm.khr_id = p_khr_id
225: and stm.say_code = 'HIST'
226: and stm.SGN_CODE = 'MANL'

Line 1242: x_principal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,

1238: p_currency_code IN VARCHAR2, --USED?
1239: p_deal_type IN VARCHAR2, --USED?
1240: p_asset_iir_guess IN NUMBER DEFAULT NULL,
1241: p_bkg_yield_guess IN NUMBER DEFAULT NULL,
1242: x_principal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1243: x_interest_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1244: x_prin_bal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1245: x_termination_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1246: x_pre_tax_inc_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,

Line 1243: x_interest_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,

1239: p_deal_type IN VARCHAR2, --USED?
1240: p_asset_iir_guess IN NUMBER DEFAULT NULL,
1241: p_bkg_yield_guess IN NUMBER DEFAULT NULL,
1242: x_principal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1243: x_interest_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1244: x_prin_bal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1245: x_termination_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1246: x_pre_tax_inc_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1247: x_interim_interest OUT NOCOPY NUMBER,

Line 1244: x_prin_bal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,

1240: p_asset_iir_guess IN NUMBER DEFAULT NULL,
1241: p_bkg_yield_guess IN NUMBER DEFAULT NULL,
1242: x_principal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1243: x_interest_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1244: x_prin_bal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1245: x_termination_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1246: x_pre_tax_inc_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1247: x_interim_interest OUT NOCOPY NUMBER,
1248: x_interim_days OUT NOCOPY NUMBER,

Line 1245: x_termination_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,

1241: p_bkg_yield_guess IN NUMBER DEFAULT NULL,
1242: x_principal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1243: x_interest_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1244: x_prin_bal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1245: x_termination_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1246: x_pre_tax_inc_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1247: x_interim_interest OUT NOCOPY NUMBER,
1248: x_interim_days OUT NOCOPY NUMBER,
1249: x_interim_dpp OUT NOCOPY NUMBER,

Line 1246: x_pre_tax_inc_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,

1242: x_principal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1243: x_interest_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1244: x_prin_bal_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1245: x_termination_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1246: x_pre_tax_inc_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1247: x_interim_interest OUT NOCOPY NUMBER,
1248: x_interim_days OUT NOCOPY NUMBER,
1249: x_interim_dpp OUT NOCOPY NUMBER,
1250: x_iir OUT NOCOPY NUMBER,

Line 1307: okl_streams stm,

1303: 'DOWN_PAYMENT','DOWN_PMNT',
1304: 'PRINCIPAL_PAYMENT', 'PRIN_PMNT',
1305: 'RENT' ) cf_purpose
1306: FROM okl_strm_elements sel,
1307: okl_streams stm,
1308: okl_strm_type_b sty,
1309: okl_strm_type_tl styt
1310: WHERE stm.kle_id = p_kle_id
1311: AND stm.say_code = 'WORK'

Line 1328: from okl_streams stm,

1324:
1325: /* Commented by prasjain for bug 5474827
1326: Cursor c_stub IS
1327: Select sel.id
1328: from okl_streams stm,
1329: okl_strm_elements sel
1330: where stm.khr_id = p_khr_id
1331: and stm.say_code = 'HIST'
1332: and stm.SGN_CODE = 'MANL'

Line 1540: okl_streams stm

1536: sel.stream_element_date se_date,
1537: sel.comments se_arrears,
1538: sel.sel_id se_sel_id
1539: FROM okl_strm_elements sel,
1540: okl_streams stm
1541: WHERE stm.kle_id = p_kle_id
1542: AND stm.khr_id = p_khr_id
1543: AND stm.sty_id = p_sty_id
1544: AND DECODE(stm.purpose_code,

Line 2359: FROM okl_streams stm,

2355: trunc(sel_amt.stream_element_date) se_date,
2356: DECODE(sel_amt.sel_id,NULL,'N','Y') stub,
2357: sel_amt.comments se_arrears,
2358: sel_rate.comments payment_missing_yn
2359: FROM okl_streams stm,
2360: okl_strm_type_b sty,
2361: okl_strm_elements sel_amt,
2362: okl_strm_elements sel_rate,
2363: okc_k_headers_b chr_so,

Line 2892: FROM okl_streams stm,

2888: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
2889: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
2890: chr_so.start_date,
2891: chr_so.end_date
2892: FROM okl_streams stm,
2893: okl_strm_type_b sty,
2894: okl_strm_elements sel_rate,
2895: okl_strm_elements sel_amt,
2896: okc_k_headers_b chr_so,

Line 2944: FROM okl_streams stm,

2940: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
2941: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
2942: chr_so.start_date,
2943: lse.lty_code
2944: FROM okl_streams stm,
2945: okl_strm_type_b sty,
2946: okl_strm_elements sel_rate,
2947: okl_strm_elements sel_amt,
2948: okc_k_headers_b chr_so,

Line 2996: FROM okl_streams stm,

2992: sty.stream_type_purpose cf_purpose,
2993: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
2994: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
2995: chr_so.start_date
2996: FROM okl_streams stm,
2997: okl_strm_type_b sty,
2998: okl_strm_elements sel_rate,
2999: okl_strm_elements sel_amt,
3000: okc_k_headers_b chr_so,

Line 3108: FROM okl_streams stm,

3104: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
3105: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
3106: NVL(TO_NUMBER(laptpr.rule_information1), 100) pass_through_percentage,
3107: sll.rule_information10 arrears_yn
3108: FROM okl_streams stm,
3109: okl_strm_type_b sty,
3110: okl_strm_elements sel_amt,
3111: okl_strm_elements sel,
3112: okc_k_headers_b chr_so,

Line 4222: FROM okl_streams stm,

4218: sel.comments cf_arrear,
4219: sty.stream_type_purpose cf_purpose,
4220: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
4221: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
4222: FROM okl_streams stm,
4223: okl_strm_type_b sty,
4224: okl_strm_elements sel,
4225: okc_rules_b sll,
4226: okc_rules_b slh,

Line 4273: FROM okl_streams stm,

4269: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
4270: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
4271: cle.id kleId,
4272: lse.lty_code
4273: FROM okl_streams stm,
4274: okl_strm_type_b sty,
4275: okl_strm_elements sel,
4276: okc_k_lines_b cle,
4277: okc_line_styles_b lse,

Line 4444: FROM okl_streams stm,

4440: sty.stream_type_purpose cf_purpose,
4441: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
4442: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
4443: NVL(TO_NUMBER(laptpr.rule_information1), 100) pass_through_percentage
4444: FROM okl_streams stm,
4445: okl_strm_type_b sty,
4446: okl_strm_elements sel,
4447: okc_k_lines_b cle,
4448: okc_line_styles_b lse,

Line 5869: okl_streams stm,

5865: sel.amount se_amount,
5866: sel.stream_element_date se_date,
5867: sel.comments se_arrears
5868: FROM okl_strm_elements sel,
5869: okl_streams stm,
5870: okl_strm_type_b sty
5871: WHERE stm.kle_id = p_kle_id
5872: AND stm.say_code = 'CURR'
5873: AND stm.active_yn = 'Y'

Line 5896: x_principal_tbl okl_streams_pub.selv_tbl_type;

5892:
5893: TYPE loan_rec IS RECORD (se_amount NUMBER, se_date DATE, se_days NUMBER, se_arrears VARCHAR2(1));
5894: TYPE loan_tbl IS TABLE OF loan_rec INDEX BY BINARY_INTEGER;
5895:
5896: x_principal_tbl okl_streams_pub.selv_tbl_type;
5897: x_interest_tbl okl_streams_pub.selv_tbl_type;
5898: x_prin_bal_tbl okl_streams_pub.selv_tbl_type;
5899:
5900: x_interim_interest NUMBER;

Line 5897: x_interest_tbl okl_streams_pub.selv_tbl_type;

5893: TYPE loan_rec IS RECORD (se_amount NUMBER, se_date DATE, se_days NUMBER, se_arrears VARCHAR2(1));
5894: TYPE loan_tbl IS TABLE OF loan_rec INDEX BY BINARY_INTEGER;
5895:
5896: x_principal_tbl okl_streams_pub.selv_tbl_type;
5897: x_interest_tbl okl_streams_pub.selv_tbl_type;
5898: x_prin_bal_tbl okl_streams_pub.selv_tbl_type;
5899:
5900: x_interim_interest NUMBER;
5901: x_interim_days NUMBER;

Line 5898: x_prin_bal_tbl okl_streams_pub.selv_tbl_type;

5894: TYPE loan_tbl IS TABLE OF loan_rec INDEX BY BINARY_INTEGER;
5895:
5896: x_principal_tbl okl_streams_pub.selv_tbl_type;
5897: x_interest_tbl okl_streams_pub.selv_tbl_type;
5898: x_prin_bal_tbl okl_streams_pub.selv_tbl_type;
5899:
5900: x_interim_interest NUMBER;
5901: x_interim_days NUMBER;
5902: x_interim_dpp NUMBER;

Line 6328: FROM okl_streams stm,

6324: sty.stream_type_purpose cf_purpose,
6325: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
6326: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
6327: chr_so.start_date
6328: FROM okl_streams stm,
6329: okl_strm_type_b sty,
6330: okl_strm_elements sel_rate,
6331: okl_strm_elements sel_amt,
6332: okc_k_headers_b chr_so,

Line 7110: from okl_streams

7106: l_start_date DATE;
7107:
7108: Cursor l_strms_csr Is
7109: Select id
7110: from okl_streams
7111: where khr_id = p_khr_id
7112: --and kle_id = p_kle_id
7113: and purpose_code in ('PLOW', 'FLOW', 'STUBS');
7114:

Line 7134: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

7130: l_interim_dpp NUMBER;
7131:
7132: l_interim_tbl interim_interest_tbl_type;
7133:
7134: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
7135: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
7136:
7137: --Added sll.rule_information2 in order by clause by djanaswa for bug 6007644
7138:

Line 7135: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

7131:
7132: l_interim_tbl interim_interest_tbl_type;
7133:
7134: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
7135: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
7136:
7137: --Added sll.rule_information2 in order by clause by djanaswa for bug 6007644
7138:
7139: Cursor c_fee IS

Line 7603: Okl_Streams_pub.delete_streams(

7599:
7600: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7601: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || i || '# of streams are getting deleted ' );
7602: END IF;
7603: Okl_Streams_pub.delete_streams(
7604: p_api_version => p_api_version,
7605: p_init_msg_list => p_init_msg_list,
7606: x_return_status => x_return_status,
7607: x_msg_count => x_msg_count,

Line 7642: Okl_Streams_pub.delete_streams(

7638: END LOOP;
7639:
7640: If ( i > 0 ) Then
7641:
7642: Okl_Streams_pub.delete_streams(
7643: p_api_version => p_api_version,
7644: p_init_msg_list => p_init_msg_list,
7645: x_return_status => x_return_status,
7646: x_msg_count => x_msg_count,

Line 7673: Okl_Streams_pub.delete_streams(

7669: END LOOP;
7670:
7671: If ( i > 0 ) Then
7672:
7673: Okl_Streams_pub.delete_streams(
7674: p_api_version => p_api_version,
7675: p_init_msg_list => p_init_msg_list,
7676: x_return_status => x_return_status,
7677: x_msg_count => x_msg_count,

Line 7704: Okl_Streams_pub.delete_streams(

7700: END LOOP;
7701:
7702: If ( i > 0 ) Then
7703:
7704: Okl_Streams_pub.delete_streams(
7705: p_api_version => p_api_version,
7706: p_init_msg_list => p_init_msg_list,
7707: x_return_status => x_return_status,
7708: x_msg_count => x_msg_count,

Line 7789: FROM okl_streams stm,

7785: AND cle.lse_id = lse.id
7786: AND lse.lty_code = 'FREE_FORM1'
7787: AND cle.id IN (
7788: SELECT distinct stm.kle_id
7789: FROM okl_streams stm,
7790: okl_strm_elements ele,
7791: okl_strm_type_b sty
7792: WHERE stm.khr_id = p_khr_id
7793: AND stm.say_code = 'CURR'

Line 7802: from okl_streams stm,

7798: AND ele.stream_element_date > p_ppd_date );
7799:
7800: Cursor c_stub IS
7801: Select sel.id
7802: from okl_streams stm,
7803: okl_strm_elements sel
7804: where stm.khr_id = p_khr_id
7805: and stm.say_code = 'HIST'
7806: and stm.SGN_CODE = 'MANL'

Line 7915: l_selv_tbl okl_streams_pub.selv_tbl_type;

7911:
7912: l_blnStretch VARCHAR2(1) := 'N';
7913: xpay NUMBER := 0;
7914:
7915: l_selv_tbl okl_streams_pub.selv_tbl_type;
7916: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
7917: l_pt_tbl okl_streams_pub.selv_tbl_type;
7918: lx_selv_tbl okl_streams_pub.selv_tbl_type;
7919:

Line 7916: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;

7912: l_blnStretch VARCHAR2(1) := 'N';
7913: xpay NUMBER := 0;
7914:
7915: l_selv_tbl okl_streams_pub.selv_tbl_type;
7916: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
7917: l_pt_tbl okl_streams_pub.selv_tbl_type;
7918: lx_selv_tbl okl_streams_pub.selv_tbl_type;
7919:
7920: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 7917: l_pt_tbl okl_streams_pub.selv_tbl_type;

7913: xpay NUMBER := 0;
7914:
7915: l_selv_tbl okl_streams_pub.selv_tbl_type;
7916: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
7917: l_pt_tbl okl_streams_pub.selv_tbl_type;
7918: lx_selv_tbl okl_streams_pub.selv_tbl_type;
7919:
7920: l_stmv_rec okl_streams_pub.stmv_rec_type;
7921: l_pt_rec okl_streams_pub.stmv_rec_type;

Line 7918: lx_selv_tbl okl_streams_pub.selv_tbl_type;

7914:
7915: l_selv_tbl okl_streams_pub.selv_tbl_type;
7916: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
7917: l_pt_tbl okl_streams_pub.selv_tbl_type;
7918: lx_selv_tbl okl_streams_pub.selv_tbl_type;
7919:
7920: l_stmv_rec okl_streams_pub.stmv_rec_type;
7921: l_pt_rec okl_streams_pub.stmv_rec_type;
7922: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 7920: l_stmv_rec okl_streams_pub.stmv_rec_type;

7916: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
7917: l_pt_tbl okl_streams_pub.selv_tbl_type;
7918: lx_selv_tbl okl_streams_pub.selv_tbl_type;
7919:
7920: l_stmv_rec okl_streams_pub.stmv_rec_type;
7921: l_pt_rec okl_streams_pub.stmv_rec_type;
7922: lx_stmv_rec okl_streams_pub.stmv_rec_type;
7923:
7924: l_principal_balance NUMBER;

Line 7921: l_pt_rec okl_streams_pub.stmv_rec_type;

7917: l_pt_tbl okl_streams_pub.selv_tbl_type;
7918: lx_selv_tbl okl_streams_pub.selv_tbl_type;
7919:
7920: l_stmv_rec okl_streams_pub.stmv_rec_type;
7921: l_pt_rec okl_streams_pub.stmv_rec_type;
7922: lx_stmv_rec okl_streams_pub.stmv_rec_type;
7923:
7924: l_principal_balance NUMBER;
7925: l_advance_arrears VARCHAR2(256);

Line 7922: lx_stmv_rec okl_streams_pub.stmv_rec_type;

7918: lx_selv_tbl okl_streams_pub.selv_tbl_type;
7919:
7920: l_stmv_rec okl_streams_pub.stmv_rec_type;
7921: l_pt_rec okl_streams_pub.stmv_rec_type;
7922: lx_stmv_rec okl_streams_pub.stmv_rec_type;
7923:
7924: l_principal_balance NUMBER;
7925: l_advance_arrears VARCHAR2(256);
7926: L_ACCUMULATED_INT NUMBER;

Line 8157: FROM okl_streams stm,

8153: sel.comments cf_arrear,
8154: sty.stream_type_purpose cf_purpose,
8155: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
8156: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
8157: FROM okl_streams stm,
8158: okl_strm_type_b sty,
8159: okl_strm_elements sel,
8160: okc_rules_b sll,
8161: okc_rules_b slh,

Line 8206: FROM okl_streams stm,

8202: sel.comments cf_arrear,
8203: sty.stream_type_purpose cf_purpose,
8204: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
8205: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
8206: FROM okl_streams stm,
8207: okl_strm_type_b sty,
8208: okl_strm_elements sel,
8209: okc_k_lines_b cle,
8210: okc_line_styles_b lse,

Line 8250: FROM okl_streams stm,

8246: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
8247: cle.id kleId,
8248: lse.lty_code,
8249: kle.fee_type
8250: FROM okl_streams stm,
8251: okl_strm_type_b sty,
8252: okl_strm_elements sel,
8253: okc_k_lines_b cle,
8254: okl_k_lines kle,

Line 9619: from okl_streams

9615: l_start_date DATE;
9616:
9617: Cursor l_strms_csr Is
9618: Select id
9619: from okl_streams
9620: where khr_id = p_khr_id
9621: --and kle_id = p_kle_id
9622: and purpose_code in ('PLOW', 'FLOW', 'STUBS');
9623:

Line 9643: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

9639: l_interim_dpp NUMBER;
9640:
9641: l_interim_tbl interim_interest_tbl_type;
9642:
9643: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
9644: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
9645:
9646: Cursor c_rollover_fee IS
9647: SELECT DISTINCT

Line 9644: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

9640:
9641: l_interim_tbl interim_interest_tbl_type;
9642:
9643: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
9644: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
9645:
9646: Cursor c_rollover_fee IS
9647: SELECT DISTINCT
9648: cle.id kleId,

Line 10187: Okl_Streams_pub.delete_streams(

10183:
10184: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
10185: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || i || '# of streams are getting deleted ' );
10186: END IF;
10187: Okl_Streams_pub.delete_streams(
10188: p_api_version => p_api_version,
10189: p_init_msg_list => p_init_msg_list,
10190: x_return_status => x_return_status,
10191: x_msg_count => x_msg_count,

Line 10210: update okl_streams

10206:
10207: For r_rollover_fee in c_rollover_fee
10208: LOOP
10209:
10210: update okl_streams
10211: set say_code = 'HIST',
10212: date_history = SYSDATE,
10213: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
10214: last_update_date = sysdate,

Line 10220: update okl_streams

10216:
10217: where khr_id = p_khr_id
10218: and kle_id = p_kle_id;
10219:
10220: update okl_streams
10221: set active_yn = 'N',
10222: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
10223: last_update_date = sysdate,
10224: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here

Line 10267: Okl_Streams_pub.delete_streams(

10263: END LOOP;
10264:
10265: If ( i > 0 ) Then
10266:
10267: Okl_Streams_pub.delete_streams(
10268: p_api_version => p_api_version,
10269: p_init_msg_list => p_init_msg_list,
10270: x_return_status => x_return_status,
10271: x_msg_count => x_msg_count,

Line 10298: Okl_Streams_pub.delete_streams(

10294: END LOOP;
10295:
10296: If ( i > 0 ) Then
10297:
10298: Okl_Streams_pub.delete_streams(
10299: p_api_version => p_api_version,
10300: p_init_msg_list => p_init_msg_list,
10301: x_return_status => x_return_status,
10302: x_msg_count => x_msg_count,

Line 10329: Okl_Streams_pub.delete_streams(

10325: END LOOP;
10326:
10327: If ( i > 0 ) Then
10328:
10329: Okl_Streams_pub.delete_streams(
10330: p_api_version => p_api_version,
10331: p_init_msg_list => p_init_msg_list,
10332: x_return_status => x_return_status,
10333: x_msg_count => x_msg_count,

Line 10416: l_selv_tbl okl_streams_pub.selv_tbl_type;

10412: l_prev_diff_sign NUMBER ;
10413: l_purpose_code VARCHAR2(30) := 'FLOW';
10414: lv_adv_arr VARCHAR2(30);
10415: lv_currency_code okc_k_headers_b.currency_code%TYPE;
10416: l_selv_tbl okl_streams_pub.selv_tbl_type;
10417: l_pt_tbl okl_streams_pub.selv_tbl_type;
10418: l_pay_level payment_tbl_type := p_pay_level;
10419: lx_pay_level payment_tbl_type;
10420: l_cash_flow_tbl cash_flow_tbl_type;

Line 10417: l_pt_tbl okl_streams_pub.selv_tbl_type;

10413: l_purpose_code VARCHAR2(30) := 'FLOW';
10414: lv_adv_arr VARCHAR2(30);
10415: lv_currency_code okc_k_headers_b.currency_code%TYPE;
10416: l_selv_tbl okl_streams_pub.selv_tbl_type;
10417: l_pt_tbl okl_streams_pub.selv_tbl_type;
10418: l_pay_level payment_tbl_type := p_pay_level;
10419: lx_pay_level payment_tbl_type;
10420: l_cash_flow_tbl cash_flow_tbl_type;
10421: k NUMBER :=1;

Line 10794: okl_streams stm,

10790: sel.comments se_arrears,
10791: sty.stream_type_purpose,
10792: decode(sty.stream_type_purpose,'LOAN_PAYMENT',1,'UNSCHEDULED_PRINCIPAL_PAYMENT',2,'UNSCHEDULED_LOAN_PAYMENT',2,'VARIABLE_LOAN_PAYMENT',3,4) stream_ordr
10793: FROM okl_strm_elements sel,
10794: okl_streams stm,
10795: okl_strm_type_b sty,
10796: okl_strm_type_tl styt
10797: WHERE stm.khr_id =p_khr_id
10798: AND stm.say_code = 'CURR'

Line 10833: round_interest_tbl Okl_Streams_Pub.selv_tbl_type;

10829: se_purpose okl_strm_type_b.stream_type_purpose%type);
10830:
10831: TYPE loan_tbl IS TABLE OF loan_rec INDEX BY BINARY_INTEGER;
10832:
10833: round_interest_tbl Okl_Streams_Pub.selv_tbl_type;
10834: rounded_interest_tbl Okl_Streams_Pub.selv_tbl_type;
10835:
10836: interest_rate_tbl OKL_VARIABLE_INTEREST_PVT.interest_rate_tbl_type;
10837:

Line 10834: rounded_interest_tbl Okl_Streams_Pub.selv_tbl_type;

10830:
10831: TYPE loan_tbl IS TABLE OF loan_rec INDEX BY BINARY_INTEGER;
10832:
10833: round_interest_tbl Okl_Streams_Pub.selv_tbl_type;
10834: rounded_interest_tbl Okl_Streams_Pub.selv_tbl_type;
10835:
10836: interest_rate_tbl OKL_VARIABLE_INTEREST_PVT.interest_rate_tbl_type;
10837:
10838: asset_rents loan_tbl;