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

Line 119: lv_parent_object_code okl_lease_quotes_b.parent_object_code%TYPE;

115: l_start_date DATE;
116: l_cf_hdr_rec cashflow_hdr_rec_type;
117: l_cashflow_level_tbl cashflow_level_tbl_type;
118: l_adj_assets_rec okl_cdj_pvt.cdjv_rec_type;
119: lv_parent_object_code okl_lease_quotes_b.parent_object_code%TYPE;
120:
121: CURSOR get_quote_rec(p_quote_id NUMBER) IS
122: SELECT qte.id, qte.expected_start_date, qte.parent_object_code
123: FROM okl_assets_b ast,

Line 124: okl_lease_quotes_b qte

120:
121: CURSOR get_quote_rec(p_quote_id NUMBER) IS
122: SELECT qte.id, qte.expected_start_date, qte.parent_object_code
123: FROM okl_assets_b ast,
124: okl_lease_quotes_b qte
125: WHERE qte.id = ast.parent_object_id
126: AND ast.id= p_quote_id;
127:
128: BEGIN

Line 288: from okl_lease_quotes_b

284: lv_target_pricing_type VARCHAR2(15);
285: BEGIN
286: select pricing_method
287: into lv_source_pricing_type
288: from okl_lease_quotes_b
289: where id = p_source_quote_id;
290:
291: select pricing_method
292: into lv_target_pricing_type

Line 293: from okl_lease_quotes_b

289: where id = p_source_quote_id;
290:
291: select pricing_method
292: into lv_target_pricing_type
293: from okl_lease_quotes_b
294: where id = p_target_quote_id;
295:
296: IF (lv_source_pricing_type = lv_target_pricing_type) THEN
297: RETURN 'Y';

Line 323: lv_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;

319: l_compare_amt NUMBER;
320: l_diff NUMBER;
321: l_adj_rec BINARY_INTEGER;
322: lx_return_status VARCHAR2(1);
323: lv_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;
324: l_quote_id NUMBER;
325:
326: ln_index NUMBER;
327:

Line 336: FROM okl_lease_quotes_b

332: AND PARENT_OBJECT_CODE='LEASEQUOTE';
333:
334: CURSOR c_get_parent_object_code(p_quote_id NUMBER) IS
335: SELECT parent_object_code
336: FROM okl_lease_quotes_b
337: WHERE id = p_quote_id;
338: BEGIN
339:
340: l_assoc_total := 0;

Line 360: okl_lease_quotes_b lsq

356: IF (lv_parent_object_code = 'LEASEOPP') THEN
357: SELECT currency_code
358: INTO l_currency_code
359: FROM okl_lease_opportunities_b lop,
360: okl_lease_quotes_b lsq
361: WHERE lsq.parent_object_code = lv_parent_object_code
362: AND lsq.parent_object_id = lop.id
363: AND lsq.id = l_quote_id;
364: ELSIF (lv_parent_object_code = 'LEASEAPP') THEN

Line 368: okl_lease_quotes_b lsq

364: ELSIF (lv_parent_object_code = 'LEASEAPP') THEN
365: SELECT currency_code
366: INTO l_currency_code
367: FROM okl_lease_applications_b lap,
368: okl_lease_quotes_b lsq
369: WHERE lsq.parent_object_code = lv_parent_object_code
370: AND lsq.parent_object_id = lap.id
371: AND lsq.id = l_quote_id;
372: END IF;

Line 494: lv_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;

490: l_compare_amt NUMBER;
491: l_diff NUMBER;
492: l_adj_rec BINARY_INTEGER;
493: lx_return_status VARCHAR2(1);
494: lv_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;
495: l_quote_id NUMBER;
496: ln_index NUMBER;
497:
498: BEGIN

Line 627: okl_lease_quotes_b quote,

623: leaseopp.SALES_REP_ID
624: FROM
625: okl_assets_b asset,
626: okl_asset_components_b assetcomp,
627: okl_lease_quotes_b quote,
628: okl_lease_opportunities_b leaseopp
629: WHERE
630: asset.id = p_asset_id
631: AND asset.id = assetcomp.asset_id

Line 649: okl_lease_quotes_b quote,

645: leaseapp.SALES_REP_ID
646: FROM
647: okl_assets_b asset,
648: okl_asset_components_b assetcomp,
649: okl_lease_quotes_b quote,
650: okl_lease_applications_b leaseapp
651: WHERE
652: asset.id = p_asset_id
653: AND asset.id = assetcomp.asset_id

Line 671: FROM okl_assets_b ast, okl_lease_quotes_b lsq

667: l_input_adj_tbl := p_input_adj_tbl;
668:
669: SELECT lsq.parent_object_code
670: INTO lv_parent_code
671: FROM okl_assets_b ast, okl_lease_quotes_b lsq
672: where ast.parent_object_id = lsq.id
673: and ast.parent_object_code = 'LEASEQUOTE'
674: and ast.id = p_asset_id;
675:

Line 792: okl_lease_quotes_b quote,

788: leaseopp.SALES_REP_ID
789: FROM
790: okl_assets_b asset,
791: okl_asset_components_b assetcomp,
792: okl_lease_quotes_b quote,
793: okl_lease_opportunities_b leaseopp
794: WHERE
795: asset.id = p_asset_id
796: AND asset.id = assetcomp.asset_id

Line 814: okl_lease_quotes_b quote,

810: leaseapp.SALES_REP_ID
811: FROM
812: okl_assets_b asset,
813: okl_asset_components_b assetcomp,
814: okl_lease_quotes_b quote,
815: okl_lease_applications_b leaseapp
816: WHERE
817: asset.id = p_asset_id
818: AND asset.id = assetcomp.asset_id

Line 836: FROM okl_assets_b ast, okl_lease_quotes_b lsq

832: l_input_adj_rec := p_input_adj_rec;
833:
834: SELECT lsq.parent_object_code
835: INTO lv_parent_code
836: FROM okl_assets_b ast, okl_lease_quotes_b lsq
837: where ast.parent_object_id = lsq.id
838: and ast.parent_object_code = 'LEASEQUOTE'
839: and ast.id = p_asset_id;
840:

Line 1082: OKL_LEASE_QUOTES_B QTE

1078: SELECT
1079: EOT.EOT_TYPE_CODE
1080: FROM OKL_FE_EO_TERMS_ALL_B EOT,
1081: OKL_FE_EO_TERM_VERS EOT_VER,
1082: OKL_LEASE_QUOTES_B QTE
1083: WHERE
1084: EOT_VER.END_OF_TERM_VER_ID = QTE.END_OF_TERM_OPTION_ID
1085: AND EOT_VER.END_OF_TERM_ID = EOT.END_OF_TERM_ID
1086: AND QTE.ID = p_quote_id;

Line 1155: okl_lease_quotes_b quote,

1151: leaseopp.CUST_ACCT_ID,
1152: quote.product_id,
1153: leaseopp.SALES_REP_ID
1154: FROM
1155: okl_lease_quotes_b quote,
1156: okl_lease_opportunities_b leaseopp
1157: WHERE
1158: quote.id = p_quote_id
1159: AND quote.parent_object_id = leaseopp.id

Line 1171: okl_lease_quotes_b quote,

1167: leaseapp.CUST_ACCT_ID,
1168: quote.product_id,
1169: leaseapp.SALES_REP_ID
1170: FROM
1171: okl_lease_quotes_b quote,
1172: okl_lease_applications_b leaseapp
1173: WHERE
1174: quote.id = p_quote_id
1175: AND quote.parent_object_id = leaseapp.id

Line 1191: FROM okl_lease_quotes_b

1187:
1188: BEGIN
1189: SELECT parent_object_code
1190: INTO lv_parent_code
1191: FROM okl_lease_quotes_b
1192: where id = p_quote_id;
1193:
1194: IF (lv_parent_code = 'LEASEOPP') THEN
1195: OPEN c_get_quote_lop_info;

Line 1270: okl_lease_quotes_b quote,

1266: leaseopp.SALES_REP_ID
1267: FROM
1268: okl_assets_b asset,
1269: okl_asset_components_b assetcomp,
1270: okl_lease_quotes_b quote,
1271: okl_lease_opportunities_b leaseopp
1272: WHERE
1273: asset.id = p_asset_id
1274: AND asset.id = assetcomp.asset_id

Line 1292: okl_lease_quotes_b quote,

1288: leaseapp.SALES_REP_ID
1289: FROM
1290: okl_assets_b asset,
1291: okl_asset_components_b assetcomp,
1292: okl_lease_quotes_b quote,
1293: okl_lease_applications_b leaseapp
1294: WHERE
1295: asset.id = p_asset_id
1296: AND asset.id = assetcomp.asset_id

Line 1305: FROM okl_assets_b ast, okl_lease_quotes_b lsq

1301:
1302: BEGIN
1303: SELECT lsq.parent_object_code
1304: INTO lv_parent_code
1305: FROM okl_assets_b ast, okl_lease_quotes_b lsq
1306: where ast.parent_object_id = lsq.id
1307: and ast.parent_object_code = 'LEASEQUOTE'
1308: and ast.id = p_asset_id;
1309:

Line 1778: FROM okl_lease_quotes_b

1774: lv_parent_object_code VARCHAR2(30);
1775:
1776: CURSOR c_get_parent_object_code(parent_object_id NUMBER) IS
1777: SELECT parent_object_code
1778: FROM okl_lease_quotes_b
1779: WHERE id = p_asset_rec.parent_object_id;
1780:
1781: BEGIN
1782:

Line 1809: okl_lease_quotes_b lsq

1805: IF (lv_parent_object_code = 'LEASEOPP') THEN
1806: SELECT currency_code
1807: INTO l_currency_code
1808: FROM okl_lease_opportunities_b lop,
1809: okl_lease_quotes_b lsq
1810: WHERE lsq.parent_object_code = lv_parent_object_code
1811: AND lsq.parent_object_id = lop.id
1812: AND lsq.id = p_asset_rec.parent_object_id;
1813: ELSIF (lv_parent_object_code = 'LEASEAPP') THEN

Line 1817: okl_lease_quotes_b lsq

1813: ELSIF (lv_parent_object_code = 'LEASEAPP') THEN
1814: SELECT currency_code
1815: INTO l_currency_code
1816: FROM okl_lease_applications_b lap,
1817: okl_lease_quotes_b lsq
1818: WHERE lsq.parent_object_code = lv_parent_object_code
1819: AND lsq.parent_object_id = lap.id
1820: AND lsq.id = p_asset_rec.parent_object_id;
1821: END IF;

Line 1982: lv_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;

1978:
1979: l_program_name CONSTANT VARCHAR2(30) := 'validate';
1980: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
1981:
1982: lv_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;
1983: ln_check_pec_percentage NUMBER;
1984: ln_sum_oec_percentage NUMBER;
1985:
1986: BEGIN

Line 2001: FROM OKL_LEASE_QUOTES_B

1997: -- Validate Asset percentage in case of 'Solve for Financed Amount'
1998: -- pricng method scenario
1999: SELECT PRICING_METHOD
2000: INTO lv_pricing_method
2001: FROM OKL_LEASE_QUOTES_B
2002: WHERE ID = p_asset_rec.parent_object_id;
2003:
2004: IF (lv_pricing_method = 'SF') THEN
2005:

Line 2104: l_quote_id okl_lease_quotes_b.id%TYPE;

2100: and parent_object_code='LEASEQUOTE';
2101:
2102: l_cost_adj_desc okl_cost_adjustments_tl.description%TYPE;
2103: l_sync_desc VARCHAR2(1):='N';
2104: l_quote_id okl_lease_quotes_b.id%TYPE;
2105: --Bug 7291307 : Adding end
2106:
2107: BEGIN
2108: IF p_transaction_control = G_TRUE THEN

Line 2277: FROM okl_assets_b ast,okl_lease_quotes_b qte

2273: --Bug # 5142940 ssdeshpa end
2274:
2275: /*SELECT qte.parent_object_id,qte.parent_object_code
2276: INTO l_p_id,l_p_code
2277: FROM okl_assets_b ast,okl_lease_quotes_b qte
2278: WHERE qte.id = ast.parent_object_id
2279: AND ast.id= l_asset_adj_tbl(1).parent_object_id;
2280:
2281:

Line 2384: l_quote_id okl_lease_quotes_b.id%TYPE;

2380: ln_index NUMBER;
2381: --Bug 7291307 : Adding start
2382: l_cost_adj_desc okl_cost_adjustments_tl.description%TYPE;
2383: l_sync_desc VARCHAR2(1):='N';
2384: l_quote_id okl_lease_quotes_b.id%TYPE;
2385: --Bug 7291307 : Adding end
2386:
2387: BEGIN
2388: IF p_transaction_control = G_TRUE THEN

Line 2648: FROM okl_assets_b ast,okl_lease_quotes_b qte

2644: END IF;
2645:
2646: /*SELECT qte.parent_object_id,qte.parent_object_code
2647: INTO l_p_id,l_p_code
2648: FROM okl_assets_b ast,okl_lease_quotes_b qte
2649: WHERE qte.id = ast.parent_object_id
2650: AND ast.id= l_asset_adj_tbl(1).parent_object_id;
2651:
2652:

Line 2818: FROM okl_lease_quotes_b where ID = p_quote_id;

2814: --Bug # 5142940 ssdeshpa start
2815: END IF;
2816:
2817: /*SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code
2818: FROM okl_lease_quotes_b where ID = p_quote_id;
2819:
2820: OKL_LEASE_QUOTE_PRICING_PVT.handle_parent_object_status(
2821: p_api_version => G_API_VERSION
2822: ,p_init_msg_list => G_FALSE

Line 2963: FROM okl_lease_quotes_b

2959: END IF;
2960:
2961: SELECT parent_object_code
2962: INTO lv_parent_object_code
2963: FROM okl_lease_quotes_b
2964: where id = p_quote_id;
2965:
2966: IF (lv_parent_object_code = 'LEASEOPP') THEN
2967: l_cashflow_header_rec.quote_type_code := 'LQ';

Line 3349: l_parent_object_code okl_lease_quotes_b.parent_object_code%TYPE;

3345: ln_src_pdt_id NUMBER;
3346: ln_tgt_pdt_id NUMBER;
3347: lv_src_pricing_type VARCHAR2(30);
3348: lv_tgt_pricing_type VARCHAR2(30);
3349: l_parent_object_code okl_lease_quotes_b.parent_object_code%TYPE;
3350: ln_src_eot_id NUMBER;
3351: ln_tgt_eot_id NUMBER;
3352:
3353: BEGIN

Line 3372: okl_lease_quotes_b quote

3368: quote.end_of_term_option_id
3369: INTO ld_src_start_date, ln_src_pdt_id, lv_src_pricing_type, ln_src_eot_id
3370: FROM
3371: okl_assets_b asset,
3372: okl_lease_quotes_b quote
3373: WHERE
3374: asset.id = p_source_asset_id
3375: AND asset.parent_object_id = quote.id
3376: AND asset.parent_object_code = 'LEASEQUOTE';

Line 3385: okl_lease_quotes_b

3381: parent_object_code,
3382: end_of_term_option_id
3383: INTO ld_tgt_start_date, ln_tgt_pdt_id, lv_tgt_pricing_type,l_parent_object_code, ln_tgt_eot_id
3384: FROM
3385: okl_lease_quotes_b
3386: WHERE
3387: id = p_target_quote_id;
3388:
3389: IF ((ld_src_start_date <> ld_tgt_start_date) OR (ln_src_pdt_id <> ln_tgt_pdt_id)) THEN

Line 3964: FROM okl_lease_quotes_b where ID = l_asset_rec.parent_object_id;

3960: END IF;
3961: END IF;
3962:
3963: /*SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code
3964: FROM okl_lease_quotes_b where ID = l_asset_rec.parent_object_id;
3965:
3966: OKL_LEASE_QUOTE_PRICING_PVT.handle_parent_object_status(
3967: p_api_version => G_API_VERSION
3968: ,p_init_msg_list => G_FALSE

Line 4133: FROM okl_lease_quotes_b qte,

4129: -- End
4130:
4131: /*SELECT qte.parent_object_id,qte.parent_object_code
4132: INTO l_p_id,l_p_code
4133: FROM okl_lease_quotes_b qte,
4134: okl_assets_b ast
4135: WHERE ast.parent_object_id = qte.id
4136: AND ast.ID = l_asset_id;
4137:

Line 4516: FROM okl_lease_quotes_b where ID = l_asset_rec.parent_object_id;

4512: END IF;
4513: END IF;
4514:
4515: /*SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code
4516: FROM okl_lease_quotes_b where ID = l_asset_rec.parent_object_id;
4517:
4518: OKL_LEASE_QUOTE_PRICING_PVT.handle_parent_object_status(
4519: p_api_version => G_API_VERSION
4520: ,p_init_msg_list => G_FALSE

Line 4609: CURSOR c_get_supplier_id(p_qte_id IN OKL_LEASE_QUOTES_B.ID%TYPE) IS

4605:
4606: l_return_status VARCHAR2(1);
4607: ln_index NUMBER;
4608:
4609: CURSOR c_get_supplier_id(p_qte_id IN OKL_LEASE_QUOTES_B.ID%TYPE) IS
4610: SELECT LOP.SUPPLIER_ID supplier_id
4611: FROM OKL_LEASE_OPPORTUNITIES_B LOP,
4612: OKL_LEASE_QUOTES_B QTE
4613: WHERE LOP.ID = QTE.parent_object_id

Line 4612: OKL_LEASE_QUOTES_B QTE

4608:
4609: CURSOR c_get_supplier_id(p_qte_id IN OKL_LEASE_QUOTES_B.ID%TYPE) IS
4610: SELECT LOP.SUPPLIER_ID supplier_id
4611: FROM OKL_LEASE_OPPORTUNITIES_B LOP,
4612: OKL_LEASE_QUOTES_B QTE
4613: WHERE LOP.ID = QTE.parent_object_id
4614: AND qte.id = p_qte_id;
4615:
4616: BEGIN