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_PUB

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 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 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 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 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 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 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 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;