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 1294: okl_streams stm,

1290: sel.comments se_arrears,
1291: sel.sel_id se_sel_id,
1292: sty.stream_type_purpose
1293: FROM okl_strm_elements sel,
1294: okl_streams stm,
1295: okl_strm_type_b sty,
1296: okl_strm_type_tl styt
1297: WHERE stm.kle_id = p_kle_id
1298: AND stm.say_code = 'WORK'

Line 1315: from okl_streams stm,

1311:
1312: /* Commented by prasjain for bug 5474827
1313: Cursor c_stub IS
1314: Select sel.id
1315: from okl_streams stm,
1316: okl_strm_elements sel
1317: where stm.khr_id = p_khr_id
1318: and stm.say_code = 'HIST'
1319: and stm.SGN_CODE = 'MANL'

Line 2759: FROM okl_streams stm,

2755: trunc(sel_amt.stream_element_date) se_date,
2756: DECODE(sel_amt.sel_id,NULL,'N','Y') stub,
2757: sel_amt.comments se_arrears,
2758: sel_rate.comments payment_missing_yn
2759: FROM okl_streams stm,
2760: okl_strm_type_b sty,
2761: okl_strm_elements sel_amt,
2762: okl_strm_elements sel_rate,
2763: okc_k_headers_b chr_so,

Line 3292: FROM okl_streams stm,

3288: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
3289: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
3290: chr_so.start_date,
3291: chr_so.end_date
3292: FROM okl_streams stm,
3293: okl_strm_type_b sty,
3294: okl_strm_elements sel_rate,
3295: okl_strm_elements sel_amt,
3296: okc_k_headers_b chr_so,

Line 3344: FROM okl_streams stm,

3340: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
3341: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
3342: chr_so.start_date,
3343: lse.lty_code
3344: FROM okl_streams stm,
3345: okl_strm_type_b sty,
3346: okl_strm_elements sel_rate,
3347: okl_strm_elements sel_amt,
3348: okc_k_headers_b chr_so,

Line 3396: FROM okl_streams stm,

3392: sty.stream_type_purpose cf_purpose,
3393: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
3394: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
3395: chr_so.start_date
3396: FROM okl_streams stm,
3397: okl_strm_type_b sty,
3398: okl_strm_elements sel_rate,
3399: okl_strm_elements sel_amt,
3400: okc_k_headers_b chr_so,

Line 3508: FROM okl_streams stm,

3504: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
3505: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
3506: NVL(TO_NUMBER(laptpr.rule_information1), 100) pass_through_percentage,
3507: sll.rule_information10 arrears_yn
3508: FROM okl_streams stm,
3509: okl_strm_type_b sty,
3510: okl_strm_elements sel_amt,
3511: okl_strm_elements sel,
3512: okc_k_headers_b chr_so,

Line 4622: FROM okl_streams stm,

4618: sel.comments cf_arrear,
4619: sty.stream_type_purpose cf_purpose,
4620: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
4621: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
4622: FROM okl_streams stm,
4623: okl_strm_type_b sty,
4624: okl_strm_elements sel,
4625: okc_rules_b sll,
4626: okc_rules_b slh,

Line 4673: FROM okl_streams stm,

4669: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
4670: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
4671: cle.id kleId,
4672: lse.lty_code
4673: FROM okl_streams stm,
4674: okl_strm_type_b sty,
4675: okl_strm_elements sel,
4676: okc_k_lines_b cle,
4677: okc_line_styles_b lse,

Line 4844: FROM okl_streams stm,

4840: sty.stream_type_purpose cf_purpose,
4841: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
4842: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
4843: NVL(TO_NUMBER(laptpr.rule_information1), 100) pass_through_percentage
4844: FROM okl_streams stm,
4845: okl_strm_type_b sty,
4846: okl_strm_elements sel,
4847: okc_k_lines_b cle,
4848: okc_line_styles_b lse,

Line 6259: okl_streams stm,

6255: sel.amount se_amount,
6256: sel.stream_element_date se_date,
6257: sel.comments se_arrears
6258: FROM okl_strm_elements sel,
6259: okl_streams stm,
6260: okl_strm_type_b sty
6261: WHERE stm.kle_id = p_kle_id
6262: AND stm.say_code = 'CURR'
6263: AND stm.active_yn = 'Y'

Line 6286: x_principal_tbl okl_streams_pub.selv_tbl_type;

6282:
6283: TYPE loan_rec IS RECORD (se_amount NUMBER, se_date DATE, se_days NUMBER, se_arrears VARCHAR2(1));
6284: TYPE loan_tbl IS TABLE OF loan_rec INDEX BY BINARY_INTEGER;
6285:
6286: x_principal_tbl okl_streams_pub.selv_tbl_type;
6287: x_interest_tbl okl_streams_pub.selv_tbl_type;
6288: x_prin_bal_tbl okl_streams_pub.selv_tbl_type;
6289:
6290: x_interim_interest NUMBER;

Line 6287: x_interest_tbl okl_streams_pub.selv_tbl_type;

6283: TYPE loan_rec IS RECORD (se_amount NUMBER, se_date DATE, se_days NUMBER, se_arrears VARCHAR2(1));
6284: TYPE loan_tbl IS TABLE OF loan_rec INDEX BY BINARY_INTEGER;
6285:
6286: x_principal_tbl okl_streams_pub.selv_tbl_type;
6287: x_interest_tbl okl_streams_pub.selv_tbl_type;
6288: x_prin_bal_tbl okl_streams_pub.selv_tbl_type;
6289:
6290: x_interim_interest NUMBER;
6291: x_interim_days NUMBER;

Line 6288: x_prin_bal_tbl okl_streams_pub.selv_tbl_type;

6284: TYPE loan_tbl IS TABLE OF loan_rec INDEX BY BINARY_INTEGER;
6285:
6286: x_principal_tbl okl_streams_pub.selv_tbl_type;
6287: x_interest_tbl okl_streams_pub.selv_tbl_type;
6288: x_prin_bal_tbl okl_streams_pub.selv_tbl_type;
6289:
6290: x_interim_interest NUMBER;
6291: x_interim_days NUMBER;
6292: x_interim_dpp NUMBER;

Line 6718: FROM okl_streams stm,

6714: sty.stream_type_purpose cf_purpose,
6715: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
6716: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
6717: chr_so.start_date
6718: FROM okl_streams stm,
6719: okl_strm_type_b sty,
6720: okl_strm_elements sel_rate,
6721: okl_strm_elements sel_amt,
6722: okc_k_headers_b chr_so,

Line 7500: from okl_streams

7496: l_start_date DATE;
7497:
7498: Cursor l_strms_csr Is
7499: Select id
7500: from okl_streams
7501: where khr_id = p_khr_id
7502: --and kle_id = p_kle_id
7503: and purpose_code in ('PLOW', 'FLOW', 'STUBS');
7504:

Line 7524: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

7520: l_interim_dpp NUMBER;
7521:
7522: l_interim_tbl interim_interest_tbl_type;
7523:
7524: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
7525: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
7526:
7527: --Added sll.rule_information2 in order by clause by djanaswa for bug 6007644
7528:

Line 7525: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

7521:
7522: l_interim_tbl interim_interest_tbl_type;
7523:
7524: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
7525: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
7526:
7527: --Added sll.rule_information2 in order by clause by djanaswa for bug 6007644
7528:
7529: Cursor c_fee IS

Line 7993: Okl_Streams_pub.delete_streams(

7989:
7990: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7991: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || i || '# of streams are getting deleted ' );
7992: END IF;
7993: Okl_Streams_pub.delete_streams(
7994: p_api_version => p_api_version,
7995: p_init_msg_list => p_init_msg_list,
7996: x_return_status => x_return_status,
7997: x_msg_count => x_msg_count,

Line 8032: Okl_Streams_pub.delete_streams(

8028: END LOOP;
8029:
8030: If ( i > 0 ) Then
8031:
8032: Okl_Streams_pub.delete_streams(
8033: p_api_version => p_api_version,
8034: p_init_msg_list => p_init_msg_list,
8035: x_return_status => x_return_status,
8036: x_msg_count => x_msg_count,

Line 8063: Okl_Streams_pub.delete_streams(

8059: END LOOP;
8060:
8061: If ( i > 0 ) Then
8062:
8063: Okl_Streams_pub.delete_streams(
8064: p_api_version => p_api_version,
8065: p_init_msg_list => p_init_msg_list,
8066: x_return_status => x_return_status,
8067: x_msg_count => x_msg_count,

Line 8094: Okl_Streams_pub.delete_streams(

8090: END LOOP;
8091:
8092: If ( i > 0 ) Then
8093:
8094: Okl_Streams_pub.delete_streams(
8095: p_api_version => p_api_version,
8096: p_init_msg_list => p_init_msg_list,
8097: x_return_status => x_return_status,
8098: x_msg_count => x_msg_count,

Line 8179: FROM okl_streams stm,

8175: AND cle.lse_id = lse.id
8176: AND lse.lty_code = 'FREE_FORM1'
8177: AND cle.id IN (
8178: SELECT distinct stm.kle_id
8179: FROM okl_streams stm,
8180: okl_strm_elements ele,
8181: okl_strm_type_b sty
8182: WHERE stm.khr_id = p_khr_id
8183: AND stm.say_code = 'CURR'

Line 8192: from okl_streams stm,

8188: AND ele.stream_element_date > p_ppd_date );
8189:
8190: Cursor c_stub IS
8191: Select sel.id
8192: from okl_streams stm,
8193: okl_strm_elements sel
8194: where stm.khr_id = p_khr_id
8195: and stm.say_code = 'HIST'
8196: and stm.SGN_CODE = 'MANL'

Line 8305: l_selv_tbl okl_streams_pub.selv_tbl_type;

8301:
8302: l_blnStretch VARCHAR2(1) := 'N';
8303: xpay NUMBER := 0;
8304:
8305: l_selv_tbl okl_streams_pub.selv_tbl_type;
8306: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
8307: l_pt_tbl okl_streams_pub.selv_tbl_type;
8308: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8309:

Line 8306: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;

8302: l_blnStretch VARCHAR2(1) := 'N';
8303: xpay NUMBER := 0;
8304:
8305: l_selv_tbl okl_streams_pub.selv_tbl_type;
8306: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
8307: l_pt_tbl okl_streams_pub.selv_tbl_type;
8308: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8309:
8310: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 8307: l_pt_tbl okl_streams_pub.selv_tbl_type;

8303: xpay NUMBER := 0;
8304:
8305: l_selv_tbl okl_streams_pub.selv_tbl_type;
8306: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
8307: l_pt_tbl okl_streams_pub.selv_tbl_type;
8308: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8309:
8310: l_stmv_rec okl_streams_pub.stmv_rec_type;
8311: l_pt_rec okl_streams_pub.stmv_rec_type;

Line 8308: lx_selv_tbl okl_streams_pub.selv_tbl_type;

8304:
8305: l_selv_tbl okl_streams_pub.selv_tbl_type;
8306: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
8307: l_pt_tbl okl_streams_pub.selv_tbl_type;
8308: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8309:
8310: l_stmv_rec okl_streams_pub.stmv_rec_type;
8311: l_pt_rec okl_streams_pub.stmv_rec_type;
8312: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 8310: l_stmv_rec okl_streams_pub.stmv_rec_type;

8306: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
8307: l_pt_tbl okl_streams_pub.selv_tbl_type;
8308: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8309:
8310: l_stmv_rec okl_streams_pub.stmv_rec_type;
8311: l_pt_rec okl_streams_pub.stmv_rec_type;
8312: lx_stmv_rec okl_streams_pub.stmv_rec_type;
8313:
8314: l_principal_balance NUMBER;

Line 8311: l_pt_rec okl_streams_pub.stmv_rec_type;

8307: l_pt_tbl okl_streams_pub.selv_tbl_type;
8308: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8309:
8310: l_stmv_rec okl_streams_pub.stmv_rec_type;
8311: l_pt_rec okl_streams_pub.stmv_rec_type;
8312: lx_stmv_rec okl_streams_pub.stmv_rec_type;
8313:
8314: l_principal_balance NUMBER;
8315: l_advance_arrears VARCHAR2(256);

Line 8312: lx_stmv_rec okl_streams_pub.stmv_rec_type;

8308: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8309:
8310: l_stmv_rec okl_streams_pub.stmv_rec_type;
8311: l_pt_rec okl_streams_pub.stmv_rec_type;
8312: lx_stmv_rec okl_streams_pub.stmv_rec_type;
8313:
8314: l_principal_balance NUMBER;
8315: l_advance_arrears VARCHAR2(256);
8316: L_ACCUMULATED_INT NUMBER;

Line 8547: FROM okl_streams stm,

8543: sel.comments cf_arrear,
8544: sty.stream_type_purpose cf_purpose,
8545: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
8546: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
8547: FROM okl_streams stm,
8548: okl_strm_type_b sty,
8549: okl_strm_elements sel,
8550: okc_rules_b sll,
8551: okc_rules_b slh,

Line 8596: FROM okl_streams stm,

8592: sel.comments cf_arrear,
8593: sty.stream_type_purpose cf_purpose,
8594: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
8595: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
8596: FROM okl_streams stm,
8597: okl_strm_type_b sty,
8598: okl_strm_elements sel,
8599: okc_k_lines_b cle,
8600: okc_line_styles_b lse,

Line 8640: FROM okl_streams stm,

8636: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
8637: cle.id kleId,
8638: lse.lty_code,
8639: kle.fee_type
8640: FROM okl_streams stm,
8641: okl_strm_type_b sty,
8642: okl_strm_elements sel,
8643: okc_k_lines_b cle,
8644: okl_k_lines kle,

Line 10004: from okl_streams

10000: l_start_date DATE;
10001:
10002: Cursor l_strms_csr Is
10003: Select id
10004: from okl_streams
10005: where khr_id = p_khr_id
10006: --and kle_id = p_kle_id
10007: and purpose_code in ('PLOW', 'FLOW', 'STUBS');
10008:

Line 10028: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

10024: l_interim_dpp NUMBER;
10025:
10026: l_interim_tbl interim_interest_tbl_type;
10027:
10028: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
10029: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
10030:
10031: Cursor c_rollover_fee IS
10032: SELECT DISTINCT

Line 10029: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

10025:
10026: l_interim_tbl interim_interest_tbl_type;
10027:
10028: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
10029: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
10030:
10031: Cursor c_rollover_fee IS
10032: SELECT DISTINCT
10033: cle.id kleId,

Line 10572: Okl_Streams_pub.delete_streams(

10568:
10569: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
10570: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || i || '# of streams are getting deleted ' );
10571: END IF;
10572: Okl_Streams_pub.delete_streams(
10573: p_api_version => p_api_version,
10574: p_init_msg_list => p_init_msg_list,
10575: x_return_status => x_return_status,
10576: x_msg_count => x_msg_count,

Line 10595: update okl_streams

10591:
10592: For r_rollover_fee in c_rollover_fee
10593: LOOP
10594:
10595: update okl_streams
10596: set say_code = 'HIST'
10597: ,date_history = SYSDATE
10598: where khr_id = p_khr_id
10599: and kle_id = p_kle_id;

Line 10601: update okl_streams

10597: ,date_history = SYSDATE
10598: where khr_id = p_khr_id
10599: and kle_id = p_kle_id;
10600:
10601: update okl_streams
10602: set active_yn = 'N'
10603: where khr_id = p_khr_id
10604: and kle_id = p_kle_id;
10605:

Line 10645: Okl_Streams_pub.delete_streams(

10641: END LOOP;
10642:
10643: If ( i > 0 ) Then
10644:
10645: Okl_Streams_pub.delete_streams(
10646: p_api_version => p_api_version,
10647: p_init_msg_list => p_init_msg_list,
10648: x_return_status => x_return_status,
10649: x_msg_count => x_msg_count,

Line 10676: Okl_Streams_pub.delete_streams(

10672: END LOOP;
10673:
10674: If ( i > 0 ) Then
10675:
10676: Okl_Streams_pub.delete_streams(
10677: p_api_version => p_api_version,
10678: p_init_msg_list => p_init_msg_list,
10679: x_return_status => x_return_status,
10680: x_msg_count => x_msg_count,

Line 10707: Okl_Streams_pub.delete_streams(

10703: END LOOP;
10704:
10705: If ( i > 0 ) Then
10706:
10707: Okl_Streams_pub.delete_streams(
10708: p_api_version => p_api_version,
10709: p_init_msg_list => p_init_msg_list,
10710: x_return_status => x_return_status,
10711: x_msg_count => x_msg_count,

Line 10794: l_selv_tbl okl_streams_pub.selv_tbl_type;

10790: l_prev_diff_sign NUMBER ;
10791: l_purpose_code VARCHAR2(30) := 'FLOW';
10792: lv_adv_arr VARCHAR2(30);
10793: lv_currency_code okc_k_headers_b.currency_code%TYPE;
10794: l_selv_tbl okl_streams_pub.selv_tbl_type;
10795: l_pt_tbl okl_streams_pub.selv_tbl_type;
10796: l_pay_level payment_tbl_type := p_pay_level;
10797: lx_pay_level payment_tbl_type;
10798: l_cash_flow_tbl cash_flow_tbl_type;

Line 10795: l_pt_tbl okl_streams_pub.selv_tbl_type;

10791: l_purpose_code VARCHAR2(30) := 'FLOW';
10792: lv_adv_arr VARCHAR2(30);
10793: lv_currency_code okc_k_headers_b.currency_code%TYPE;
10794: l_selv_tbl okl_streams_pub.selv_tbl_type;
10795: l_pt_tbl okl_streams_pub.selv_tbl_type;
10796: l_pay_level payment_tbl_type := p_pay_level;
10797: lx_pay_level payment_tbl_type;
10798: l_cash_flow_tbl cash_flow_tbl_type;
10799: k NUMBER :=1;

Line 11172: okl_streams stm,

11168: sel.comments se_arrears,
11169: sty.stream_type_purpose,
11170: decode(sty.stream_type_purpose,'LOAN_PAYMENT',1,'UNSCHEDULED_PRINCIPAL_PAYMENT',2,'UNSCHEDULED_LOAN_PAYMENT',2,'VARIABLE_LOAN_PAYMENT',3,4) stream_ordr
11171: FROM okl_strm_elements sel,
11172: okl_streams stm,
11173: okl_strm_type_b sty,
11174: okl_strm_type_tl styt
11175: WHERE stm.khr_id =p_khr_id
11176: AND stm.say_code = 'CURR'

Line 11211: round_interest_tbl Okl_Streams_Pub.selv_tbl_type;

11207: se_purpose okl_strm_type_b.stream_type_purpose%type);
11208:
11209: TYPE loan_tbl IS TABLE OF loan_rec INDEX BY BINARY_INTEGER;
11210:
11211: round_interest_tbl Okl_Streams_Pub.selv_tbl_type;
11212: rounded_interest_tbl Okl_Streams_Pub.selv_tbl_type;
11213:
11214: interest_rate_tbl OKL_VARIABLE_INTEREST_PVT.interest_rate_tbl_type;
11215:

Line 11212: rounded_interest_tbl Okl_Streams_Pub.selv_tbl_type;

11208:
11209: TYPE loan_tbl IS TABLE OF loan_rec INDEX BY BINARY_INTEGER;
11210:
11211: round_interest_tbl Okl_Streams_Pub.selv_tbl_type;
11212: rounded_interest_tbl Okl_Streams_Pub.selv_tbl_type;
11213:
11214: interest_rate_tbl OKL_VARIABLE_INTEREST_PVT.interest_rate_tbl_type;
11215:
11216: asset_rents loan_tbl;