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