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_LEASE_QUOTE_PVT dependencies on OKL_LEASE_QUOTES_B

Line 49: FROM okl_lease_quotes_b

45: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
46:
47: CURSOR l_get_tax_treatment(cp_quote_id IN NUMBER) IS
48: SELECT upfront_tax_treatment
49: FROM okl_lease_quotes_b
50: WHERE id = cp_quote_id;
51:
52: CURSOR l_check_tax_fee_exists(cp_quote_id IN NUMBER) IS
53: SELECT id

Line 200: from okl_lease_quotes_b

196: lv_source_pricing_type VARCHAR2(15);
197: BEGIN
198: select pricing_method
199: into lv_source_pricing_type
200: from okl_lease_quotes_b
201: where id = p_source_quote_id;
202:
203: IF (lv_source_pricing_type = p_target_pricing_type) THEN
204: RETURN 'Y';

Line 223: from okl_lease_quotes_b

219: ld_source_exp_date DATE;
220: BEGIN
221: select product_id, expected_start_date
222: into ln_source_pdt_id, ld_source_exp_date
223: from okl_lease_quotes_b
224: where id = p_source_quote_id;
225:
226: IF (ln_source_pdt_id = p_target_pdt_id AND ld_source_exp_date = p_target_exp_start_date) THEN
227: RETURN 'Y';

Line 242: AND cfo.source_table = 'OKL_LEASE_QUOTES_B'

238: SELECT cf.id caf_id
239: FROM OKL_CASH_FLOWS cf,
240: OKL_CASH_FLOW_OBJECTS cfo
241: WHERE cf.cfo_id = cfo.id
242: AND cfo.source_table = 'OKL_LEASE_QUOTES_B'
243: AND cfo.source_id = p_quote_id;
244:
245: -- Cursor to fetch the Cash Flow Details
246: CURSOR lq_cash_flow_det_csr(p_caf_id NUMBER) IS

Line 325: FROM okl_lease_quotes_b

321: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
322:
323: CURSOR chk_uniquness IS
324: SELECT '1'
325: FROM okl_lease_quotes_b
326: WHERE reference_number = p_lease_qte_rec.reference_number
327: AND id <> NVL(p_lease_qte_rec.id, -9999);
328:
329: CURSOR chk_parent_dates_leaseopp IS

Line 970: l_refno_unq_chk := okl_util.validate_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER',l_lease_qte_rec.reference_number);

966: RAISE OKL_API.G_EXCEPTION_ERROR;
967: END IF;
968:
969: --Bug 7022258-Added by kkorrapo
970: l_refno_unq_chk := okl_util.validate_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER',l_lease_qte_rec.reference_number);
971:
972: IF (l_refno_unq_chk = 'N') THEN
973: RAISE OKL_API.G_EXCEPTION_ERROR;
974: END IF;

Line 1081: lv_status okl_lease_quotes_b.status%TYPE;

1077: l_copy_lse_qte lease_qte_rec_type;
1078:
1079: lb_handle_subpool BOOLEAN := FALSE;
1080: lb_validate BOOLEAN := TRUE;
1081: lv_status okl_lease_quotes_b.status%TYPE;
1082: lv_leaseapp_status okl_lease_applications_b.application_status%TYPE;
1083: ln_parent_object_id okl_lease_quotes_b.parent_object_id%TYPE;
1084:
1085: --gboomina Bug 7033915 start

Line 1083: ln_parent_object_id okl_lease_quotes_b.parent_object_id%TYPE;

1079: lb_handle_subpool BOOLEAN := FALSE;
1080: lb_validate BOOLEAN := TRUE;
1081: lv_status okl_lease_quotes_b.status%TYPE;
1082: lv_leaseapp_status okl_lease_applications_b.application_status%TYPE;
1083: ln_parent_object_id okl_lease_quotes_b.parent_object_id%TYPE;
1084:
1085: --gboomina Bug 7033915 start
1086: CURSOR lease_qte_credit_app_csr (p_lap_id OKL_LEASE_QUOTES_B.parent_object_id%TYPE) IS
1087: SELECT 'Y'

Line 1086: CURSOR lease_qte_credit_app_csr (p_lap_id OKL_LEASE_QUOTES_B.parent_object_id%TYPE) IS

1082: lv_leaseapp_status okl_lease_applications_b.application_status%TYPE;
1083: ln_parent_object_id okl_lease_quotes_b.parent_object_id%TYPE;
1084:
1085: --gboomina Bug 7033915 start
1086: CURSOR lease_qte_credit_app_csr (p_lap_id OKL_LEASE_QUOTES_B.parent_object_id%TYPE) IS
1087: SELECT 'Y'
1088: FROM okl_lease_quotes_b
1089: WHERE status = 'CR-APPROVED'
1090: AND parent_object_code = 'LEASEAPP'

Line 1088: FROM okl_lease_quotes_b

1084:
1085: --gboomina Bug 7033915 start
1086: CURSOR lease_qte_credit_app_csr (p_lap_id OKL_LEASE_QUOTES_B.parent_object_id%TYPE) IS
1087: SELECT 'Y'
1088: FROM okl_lease_quotes_b
1089: WHERE status = 'CR-APPROVED'
1090: AND parent_object_code = 'LEASEAPP'
1091: AND PARENT_OBJECT_ID = p_lap_id;
1092:

Line 1520: AND SOURCE_TABLE = 'OKL_LEASE_QUOTES_B'

1516: CURSOR c_chk_payments IS
1517: SELECT 'Y'
1518: FROM OKL_CASH_FLOW_OBJECTS
1519: WHERE SOURCE_ID = p_source_quote_id
1520: AND SOURCE_TABLE = 'OKL_LEASE_QUOTES_B'
1521: AND OTY_CODE = 'LEASE_QUOTE';
1522:
1523: CURSOR c_chk_payments_cons IS
1524: SELECT 'Y'

Line 1527: AND SOURCE_TABLE = 'OKL_LEASE_QUOTES_B'

1523: CURSOR c_chk_payments_cons IS
1524: SELECT 'Y'
1525: FROM OKL_CASH_FLOW_OBJECTS
1526: WHERE SOURCE_ID = p_source_quote_id
1527: AND SOURCE_TABLE = 'OKL_LEASE_QUOTES_B'
1528: AND OTY_CODE = 'LEASE_QUOTE_CONSOLIDATED';
1529:
1530: BEGIN
1531:

Line 1835: okl_lease_quotes_b

1831: -- are also not not copied
1832: SELECT end_of_term_option_id
1833: INTO ln_src_eot_id
1834: FROM
1835: okl_lease_quotes_b
1836: WHERE
1837: id = p_source_quote_id;
1838:
1839: SELECT end_of_term_option_id

Line 1842: okl_lease_quotes_b

1838:
1839: SELECT end_of_term_option_id
1840: INTO ln_tgt_eot_id
1841: FROM
1842: okl_lease_quotes_b
1843: WHERE
1844: id = p_target_quote_id;
1845:
1846: IF (ln_src_eot_id <> ln_tgt_eot_id) THEN

Line 1982: --l_lease_qte_rec.reference_number := okl_util.get_next_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER');

1978: END IF;
1979: --Bug # 5021937 ssdeshpa end
1980:
1981: --Bug 7022258-Added by kkorrapo
1982: --l_lease_qte_rec.reference_number := okl_util.get_next_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER');
1983: --Bug 7022258--Addition end
1984:
1985: create_lease_qte (p_api_version => p_api_version,
1986: p_init_msg_list => p_init_msg_list,

Line 2148: l_quote_rec.reference_number := okl_util.get_next_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER');

2144: -- Generate reference number
2145:
2146: --Bug 7022258-Modified by kkorrapo
2147: -- SELECT OKL_LSQ_SEQ.nextval INTO l_quote_rec.reference_number FROM dual;
2148: l_quote_rec.reference_number := okl_util.get_next_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER');
2149: --Bug 7022258--Modification end
2150:
2151: l_quote_rec.status := 'PR-INCOMPLETE';
2152:

Line 2526: FROM okl_lease_quotes_b

2522: l_chk_lease_qte VARCHAR2(1) := 'N';
2523:
2524: CURSOR c_chk_accept_lease_qte(p_leaseopp_id IN NUMBER) IS
2525: SELECT 'Y'
2526: FROM okl_lease_quotes_b
2527: WHERE parent_object_code = 'LEASEOPP'
2528: AND parent_object_id = p_leaseopp_id
2529: AND status = 'CT-ACCEPTED';
2530:

Line 2667: FROM OKL_LEASE_QUOTES_B

2663: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
2664:
2665: CURSOR c_get_quotes IS
2666: SELECT id
2667: FROM OKL_LEASE_QUOTES_B
2668: WHERE PARENT_OBJECT_ID = p_source_leaseopp_id
2669: AND PARENT_OBJECT_CODE = 'LEASEOPP';
2670:
2671: l_quote_rec lease_qte_rec_type;

Line 2700: l_quote_rec.reference_number := okl_util.get_next_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER');

2696: -- Generate reference number
2697:
2698: --Bug 7022258-Changed by kkorrapo
2699: -- SELECT OKL_LSQ_SEQ.nextval INTO l_quote_rec.reference_number FROM dual;
2700: l_quote_rec.reference_number := okl_util.get_next_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER');
2701: --Bug 7022258--Change end
2702:
2703: l_quote_rec.parent_object_id := p_target_leaseopp_id;
2704: l_quote_rec.status := 'PR-INCOMPLETE';

Line 2783: FROM okl_lease_quotes_b

2779: -- Bug 4713798 - Added cursor
2780: CURSOR c_obj
2781: IS
2782: SELECT object_version_number
2783: FROM okl_lease_quotes_b
2784: WHERE id = p_quote_id;
2785:
2786: BEGIN
2787:

Line 2857: FROM okl_lease_quotes_b

2853: l_chk_lease_qte VARCHAR2(1) := 'N';
2854:
2855: CURSOR c_chk_accept_lease_qte(p_leaseopp_id IN NUMBER) IS
2856: SELECT 'Y'
2857: FROM okl_lease_quotes_b
2858: WHERE parent_object_code = 'LEASEOPP'
2859: AND parent_object_id = p_leaseopp_id
2860: AND status = 'CT-ACCEPTED';
2861:

Line 3109: lp_source_table := 'OKL_LEASE_QUOTES_B';

3105: BEGIN
3106: IF(p_source_object_code = 'QUOTED_ASSET') THEN
3107: lp_source_table := 'OKL_ASSETS_B';
3108: ELSIF(p_source_object_code = 'LEASE_QUOTE') THEN
3109: lp_source_table := 'OKL_LEASE_QUOTES_B';
3110: END IF;
3111: i := 1;
3112: FOR l_get_cashflow_object_info IN c_get_cashflow_info(p_src_id => p_source_object_id
3113: ,p_oty_code => p_source_object_code

Line 3193: FROM OKL_LEASE_QUOTES_B OLQ,OKL_ASSETS_B OAB

3189: AND parent_object_id = lp_quote_id;
3190:
3191: CURSOR c_get_quote_assets(p_parent_object_id NUMBER) IS
3192: select OAB.id
3193: FROM OKL_LEASE_QUOTES_B OLQ,OKL_ASSETS_B OAB
3194: where OAB.PARENT_OBJECT_ID = OLQ.ID
3195: AND OAB.PARENT_OBJECT_CODE='LEASEQUOTE'
3196: AND OLQ.ID= p_parent_object_id;
3197:

Line 3510: FROM okl_lease_quotes_b

3506:
3507: CURSOR l_get_tax_treatment(cp_quote_id IN NUMBER) IS
3508: SELECT upfront_tax_treatment, upfront_tax_stream_type,
3509: pricing_method, parent_object_code, parent_object_id
3510: FROM okl_lease_quotes_b
3511: WHERE id = cp_quote_id;
3512:
3513: CURSOR l_get_assets(cp_quote_id IN NUMBER) IS
3514: SELECT id, asset_number

Line 3580: p_source_table => 'OKL_LEASE_QUOTES_B');

3576: x_msg_count => x_msg_count,
3577: x_msg_data => x_msg_data,
3578: p_source_trx_id => p_quote_id,
3579: p_source_trx_name => 'Sales Quote',
3580: p_source_table => 'OKL_LEASE_QUOTES_B');
3581: IF(x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3582: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3583: ELSIF(x_return_status = G_RET_STS_ERROR) THEN
3584: RAISE OKL_API.G_EXCEPTION_ERROR;