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 980: 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);

976: RAISE OKL_API.G_EXCEPTION_ERROR;
977: END IF;
978:
979: --Bug 7022258-Added by kkorrapo
980: 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);
981:
982: IF (l_refno_unq_chk = 'N') THEN
983: RAISE OKL_API.G_EXCEPTION_ERROR;
984: END IF;

Line 1091: lv_status okl_lease_quotes_b.status%TYPE;

1087: l_copy_lse_qte lease_qte_rec_type;
1088:
1089: lb_handle_subpool BOOLEAN := FALSE;
1090: lb_validate BOOLEAN := TRUE;
1091: lv_status okl_lease_quotes_b.status%TYPE;
1092: lv_leaseapp_status okl_lease_applications_b.application_status%TYPE;
1093: ln_parent_object_id okl_lease_quotes_b.parent_object_id%TYPE;
1094:
1095: --gboomina Bug 7033915 start

Line 1093: ln_parent_object_id okl_lease_quotes_b.parent_object_id%TYPE;

1089: lb_handle_subpool BOOLEAN := FALSE;
1090: lb_validate BOOLEAN := TRUE;
1091: lv_status okl_lease_quotes_b.status%TYPE;
1092: lv_leaseapp_status okl_lease_applications_b.application_status%TYPE;
1093: ln_parent_object_id okl_lease_quotes_b.parent_object_id%TYPE;
1094:
1095: --gboomina Bug 7033915 start
1096: CURSOR lease_qte_credit_app_csr (p_lap_id OKL_LEASE_QUOTES_B.parent_object_id%TYPE) IS
1097: SELECT 'Y'

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

1092: lv_leaseapp_status okl_lease_applications_b.application_status%TYPE;
1093: ln_parent_object_id okl_lease_quotes_b.parent_object_id%TYPE;
1094:
1095: --gboomina Bug 7033915 start
1096: CURSOR lease_qte_credit_app_csr (p_lap_id OKL_LEASE_QUOTES_B.parent_object_id%TYPE) IS
1097: SELECT 'Y'
1098: FROM okl_lease_quotes_b
1099: WHERE status = 'CR-DECLINED'
1100: AND parent_object_code = 'LEASEAPP'

Line 1098: FROM okl_lease_quotes_b

1094:
1095: --gboomina Bug 7033915 start
1096: CURSOR lease_qte_credit_app_csr (p_lap_id OKL_LEASE_QUOTES_B.parent_object_id%TYPE) IS
1097: SELECT 'Y'
1098: FROM okl_lease_quotes_b
1099: WHERE status = 'CR-DECLINED'
1100: AND parent_object_code = 'LEASEAPP'
1101: AND PARENT_OBJECT_ID = p_lap_id;
1102:

Line 1546: AND SOURCE_TABLE = 'OKL_LEASE_QUOTES_B'

1542: CURSOR c_chk_payments IS
1543: SELECT 'Y'
1544: FROM OKL_CASH_FLOW_OBJECTS
1545: WHERE SOURCE_ID = p_source_quote_id
1546: AND SOURCE_TABLE = 'OKL_LEASE_QUOTES_B'
1547: AND OTY_CODE = 'LEASE_QUOTE';
1548:
1549: CURSOR c_chk_payments_cons IS
1550: SELECT 'Y'

Line 1553: AND SOURCE_TABLE = 'OKL_LEASE_QUOTES_B'

1549: CURSOR c_chk_payments_cons IS
1550: SELECT 'Y'
1551: FROM OKL_CASH_FLOW_OBJECTS
1552: WHERE SOURCE_ID = p_source_quote_id
1553: AND SOURCE_TABLE = 'OKL_LEASE_QUOTES_B'
1554: AND OTY_CODE = 'LEASE_QUOTE_CONSOLIDATED';
1555:
1556: BEGIN
1557:

Line 1891: okl_lease_quotes_b

1887: -- are also not not copied
1888: SELECT end_of_term_option_id
1889: INTO ln_src_eot_id
1890: FROM
1891: okl_lease_quotes_b
1892: WHERE
1893: id = p_source_quote_id;
1894:
1895: SELECT end_of_term_option_id

Line 1898: okl_lease_quotes_b

1894:
1895: SELECT end_of_term_option_id
1896: INTO ln_tgt_eot_id
1897: FROM
1898: okl_lease_quotes_b
1899: WHERE
1900: id = p_target_quote_id;
1901:
1902: IF (ln_src_eot_id <> ln_tgt_eot_id) THEN

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

2034: END IF;
2035: --Bug # 5021937 ssdeshpa end
2036:
2037: --Bug 7022258-Added by kkorrapo
2038: --l_lease_qte_rec.reference_number := okl_util.get_next_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER');
2039: --Bug 7022258--Addition end
2040:
2041: create_lease_qte (p_api_version => p_api_version,
2042: p_init_msg_list => p_init_msg_list,

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

2200: -- Generate reference number
2201:
2202: --Bug 7022258-Modified by kkorrapo
2203: -- SELECT OKL_LSQ_SEQ.nextval INTO l_quote_rec.reference_number FROM dual;
2204: l_quote_rec.reference_number := okl_util.get_next_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER');
2205: --Bug 7022258--Modification end
2206:
2207: l_quote_rec.status := 'PR-INCOMPLETE';
2208:

Line 2467: CURSOR c_chk_tax_calculation (p_quote_id OKL_LEASE_QUOTES_B.ID%TYPE) IS

2463: SELECT NVL(tax_upfront_yn,'N')
2464: FROM OKL_SYSTEM_PARAMS;
2465:
2466: -- Check if upfront tax calculation has happened for this quote
2467: CURSOR c_chk_tax_calculation (p_quote_id OKL_LEASE_QUOTES_B.ID%TYPE) IS
2468: SELECT 'X'
2469: FROM OKL_TAX_SOURCES
2470: WHERE tax_call_type_code = 'UPFRONT_TAX'
2471: AND ENTITY_CODE ='SALES_QUOTES'

Line 2625: FROM okl_lease_quotes_b

2621: l_chk_lease_qte VARCHAR2(1) := 'N';
2622:
2623: CURSOR c_chk_accept_lease_qte(p_leaseopp_id IN NUMBER) IS
2624: SELECT 'Y'
2625: FROM okl_lease_quotes_b
2626: WHERE parent_object_code = 'LEASEOPP'
2627: AND parent_object_id = p_leaseopp_id
2628: AND status = 'CT-ACCEPTED';
2629:

Line 2767: FROM OKL_LEASE_QUOTES_B

2763: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
2764:
2765: CURSOR c_get_quotes IS
2766: SELECT id
2767: FROM OKL_LEASE_QUOTES_B
2768: WHERE PARENT_OBJECT_ID = p_source_leaseopp_id
2769: AND PARENT_OBJECT_CODE = 'LEASEOPP';
2770:
2771: l_quote_rec lease_qte_rec_type;

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

2796: -- Generate reference number
2797:
2798: --Bug 7022258-Changed by kkorrapo
2799: -- SELECT OKL_LSQ_SEQ.nextval INTO l_quote_rec.reference_number FROM dual;
2800: l_quote_rec.reference_number := okl_util.get_next_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER');
2801: --Bug 7022258--Change end
2802:
2803: l_quote_rec.parent_object_id := p_target_leaseopp_id;
2804: l_quote_rec.status := 'PR-INCOMPLETE';

Line 2883: FROM okl_lease_quotes_b

2879: -- Bug 4713798 - Added cursor
2880: CURSOR c_obj
2881: IS
2882: SELECT object_version_number
2883: FROM okl_lease_quotes_b
2884: WHERE id = p_quote_id;
2885:
2886: BEGIN
2887:

Line 2957: FROM okl_lease_quotes_b

2953: l_chk_lease_qte VARCHAR2(1) := 'N';
2954:
2955: CURSOR c_chk_accept_lease_qte(p_leaseopp_id IN NUMBER) IS
2956: SELECT 'Y'
2957: FROM okl_lease_quotes_b
2958: WHERE parent_object_code = 'LEASEOPP'
2959: AND parent_object_id = p_leaseopp_id
2960: AND status = 'CT-ACCEPTED';
2961:

Line 3209: lp_source_table := 'OKL_LEASE_QUOTES_B';

3205: BEGIN
3206: IF(p_source_object_code = 'QUOTED_ASSET') THEN
3207: lp_source_table := 'OKL_ASSETS_B';
3208: ELSIF(p_source_object_code = 'LEASE_QUOTE') THEN
3209: lp_source_table := 'OKL_LEASE_QUOTES_B';
3210: END IF;
3211: i := 1;
3212: FOR l_get_cashflow_object_info IN c_get_cashflow_info(p_src_id => p_source_object_id
3213: ,p_oty_code => p_source_object_code

Line 3293: FROM OKL_LEASE_QUOTES_B OLQ,OKL_ASSETS_B OAB

3289: AND parent_object_id = lp_quote_id;
3290:
3291: CURSOR c_get_quote_assets(p_parent_object_id NUMBER) IS
3292: select OAB.id
3293: FROM OKL_LEASE_QUOTES_B OLQ,OKL_ASSETS_B OAB
3294: where OAB.PARENT_OBJECT_ID = OLQ.ID
3295: AND OAB.PARENT_OBJECT_CODE='LEASEQUOTE'
3296: AND OLQ.ID= p_parent_object_id;
3297:

Line 3610: FROM okl_lease_quotes_b

3606:
3607: CURSOR l_get_tax_treatment(cp_quote_id IN NUMBER) IS
3608: SELECT upfront_tax_treatment, upfront_tax_stream_type,
3609: pricing_method, parent_object_code, parent_object_id
3610: FROM okl_lease_quotes_b
3611: WHERE id = cp_quote_id;
3612:
3613: CURSOR l_get_assets(cp_quote_id IN NUMBER) IS
3614: SELECT id, asset_number

Line 3681: p_source_table => 'OKL_LEASE_QUOTES_B');

3677: x_msg_count => x_msg_count,
3678: x_msg_data => x_msg_data,
3679: p_source_trx_id => p_quote_id,
3680: p_source_trx_name => 'Sales Quote',
3681: p_source_table => 'OKL_LEASE_QUOTES_B');
3682: IF(x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3683: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3684: ELSIF(x_return_status = G_RET_STS_ERROR) THEN
3685: RAISE OKL_API.G_EXCEPTION_ERROR;