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_OPEN_INTERFACE_PVT dependencies on DUAL

Line 300: ,CALCULATE_RESIDUAL_INSURANCE OKL_HEADER_INTERFACE.CALCULATE_RESIDUAL_INSURANCE%TYPE

296: ,MASTER_LEASE_AGREEMENT_NUMBER OKL_HEADER_INTERFACE.MASTER_LEASE_AGREEMENT_NUMBER%TYPE
297: ,MASTER_LEASE_AGREEMENT_ID OKL_HEADER_INTERFACE.MASTER_LEASE_AGREEMENT_ID%TYPE
298: ,PRODUCT_NAME OKL_HEADER_INTERFACE.PRODUCT_NAME%TYPE
299: ,PRODUCT_ID OKL_HEADER_INTERFACE.PRODUCT_ID%TYPE
300: ,CALCULATE_RESIDUAL_INSURANCE OKL_HEADER_INTERFACE.CALCULATE_RESIDUAL_INSURANCE%TYPE
301: ,REBOOK_LIMIT_DATE OKL_HEADER_INTERFACE.REBOOK_LIMIT_DATE%TYPE
302: ,IMPORT_REQUEST_ID OKL_HEADER_INTERFACE.IMPORT_REQUEST_ID%TYPE
303: ,END_OF_TERM_OPTION OKL_HEADER_INTERFACE.END_OF_TERM_OPTION%TYPE
304: ,END_OF_TERM_AMOUNT OKL_HEADER_INTERFACE.END_OF_TERM_AMOUNT%TYPE

Line 861: FROM dual;

857: l_canonical_date := NULL;
858:
859: SELECT TO_CHAR(p_from_date ,fnd_date.canonical_mask)
860: INTO l_canonical_date
861: FROM dual;
862:
863: RETURN l_canonical_date;
864:
865: EXCEPTION

Line 3137: x_return_status := OKL_API.G_RET_STS_SUCCESS; -- individual validaiton status

3133: -- DO NOT CALL THIS PROCEDURE FOR IMPORT
3134: --
3135:
3136: l_proc_name := 'CHECK_INPUT_RECORD';
3137: x_return_status := OKL_API.G_RET_STS_SUCCESS; -- individual validaiton status
3138: l_record_status := OKL_API.G_RET_STS_SUCCESS; -- record level status
3139: l_batch_status := OKL_API.G_RET_STS_SUCCESS; -- batch level status
3140:
3141: okl_api.init_msg_list(p_init_msg_list => OKL_API.G_TRUE);

Line 26214: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,

26210: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
26211: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
26212: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26213: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26214: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26215: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26216: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26217: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26218: p_tax_book IN okl_lines_interface.tax_book%TYPE,

Line 26215: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,

26211: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
26212: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26213: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26214: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26215: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26216: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26217: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26218: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26219: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,

Line 26216: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,

26212: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26213: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26214: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26215: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26216: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26217: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26218: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26219: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,
26220: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,

Line 26217: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,

26213: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26214: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26215: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26216: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26217: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26218: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26219: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,
26220: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,
26221: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,

Line 26283: debug_message('------> Residual : '||p_residual_ptg||'/'||p_residual_amt);

26279:
26280: debug_message('------> Contract id: '||p_chr_id);
26281: debug_message('------> Asset id: '||p_asset_id);
26282:
26283: debug_message('------> Residual : '||p_residual_ptg||'/'||p_residual_amt);
26284: debug_message('------> Unit Price : '||p_unit_price);
26285: l_cimv_fa_rec.object1_id1 := p_asset_id;
26286: l_cimv_fa_rec.object1_id2 := '#';
26287: l_clev_fin_rec.dnz_chr_id := p_chr_id;

Line 26294: IF (p_residual_grnty_amt IS NOT NULL) THEN

26290: l_clev_fin_rec.price_unit := p_unit_price;
26291: l_talv_fa_rec.original_cost := p_unit_price;
26292: END IF;
26293:
26294: IF (p_residual_grnty_amt IS NOT NULL) THEN
26295: l_klev_fin_rec.residual_grnty_amount := p_residual_grnty_amt;
26296: END IF;
26297:
26298: IF (p_residual_ptg IS NOT NULL) THEN

Line 26295: l_klev_fin_rec.residual_grnty_amount := p_residual_grnty_amt;

26291: l_talv_fa_rec.original_cost := p_unit_price;
26292: END IF;
26293:
26294: IF (p_residual_grnty_amt IS NOT NULL) THEN
26295: l_klev_fin_rec.residual_grnty_amount := p_residual_grnty_amt;
26296: END IF;
26297:
26298: IF (p_residual_ptg IS NOT NULL) THEN
26299: l_klev_fin_rec.residual_percentage := p_residual_ptg;

Line 26298: IF (p_residual_ptg IS NOT NULL) THEN

26294: IF (p_residual_grnty_amt IS NOT NULL) THEN
26295: l_klev_fin_rec.residual_grnty_amount := p_residual_grnty_amt;
26296: END IF;
26297:
26298: IF (p_residual_ptg IS NOT NULL) THEN
26299: l_klev_fin_rec.residual_percentage := p_residual_ptg;
26300: END IF;
26301:
26302: IF (p_residual_amt IS NOT NULL) THEN

Line 26299: l_klev_fin_rec.residual_percentage := p_residual_ptg;

26295: l_klev_fin_rec.residual_grnty_amount := p_residual_grnty_amt;
26296: END IF;
26297:
26298: IF (p_residual_ptg IS NOT NULL) THEN
26299: l_klev_fin_rec.residual_percentage := p_residual_ptg;
26300: END IF;
26301:
26302: IF (p_residual_amt IS NOT NULL) THEN
26303: l_klev_fin_rec.residual_value := p_residual_amt;

Line 26302: IF (p_residual_amt IS NOT NULL) THEN

26298: IF (p_residual_ptg IS NOT NULL) THEN
26299: l_klev_fin_rec.residual_percentage := p_residual_ptg;
26300: END IF;
26301:
26302: IF (p_residual_amt IS NOT NULL) THEN
26303: l_klev_fin_rec.residual_value := p_residual_amt;
26304: END IF;
26305: l_klev_fin_rec.residual_code := NVL(p_residual_code,'NONE');
26306:

Line 26303: l_klev_fin_rec.residual_value := p_residual_amt;

26299: l_klev_fin_rec.residual_percentage := p_residual_ptg;
26300: END IF;
26301:
26302: IF (p_residual_amt IS NOT NULL) THEN
26303: l_klev_fin_rec.residual_value := p_residual_amt;
26304: END IF;
26305: l_klev_fin_rec.residual_code := NVL(p_residual_code,'NONE');
26306:
26307: IF (p_deprn_method IS NOT NULL) THEN

Line 26305: l_klev_fin_rec.residual_code := NVL(p_residual_code,'NONE');

26301:
26302: IF (p_residual_amt IS NOT NULL) THEN
26303: l_klev_fin_rec.residual_value := p_residual_amt;
26304: END IF;
26305: l_klev_fin_rec.residual_code := NVL(p_residual_code,'NONE');
26306:
26307: IF (p_deprn_method IS NOT NULL) THEN
26308: l_talv_fa_rec.deprn_method := p_deprn_method;
26309: END IF;

Line 27414: ,CALCULATE_RESIDUAL_INSURANCE

27410: ,MASTER_LEASE_AGREEMENT_NUMBER
27411: ,MASTER_LEASE_AGREEMENT_ID
27412: ,PRODUCT_NAME
27413: ,PRODUCT_ID
27414: ,CALCULATE_RESIDUAL_INSURANCE
27415: ,REBOOK_LIMIT_DATE
27416: ,IMPORT_REQUEST_ID
27417: ,END_OF_TERM_OPTION
27418: ,END_OF_TERM_AMOUNT

Line 27792: ,CALCULATE_RESIDUAL_INSURANCE

27788: ,MASTER_LEASE_AGREEMENT_NUMBER
27789: ,MASTER_LEASE_AGREEMENT_ID
27790: ,PRODUCT_NAME
27791: ,PRODUCT_ID
27792: ,CALCULATE_RESIDUAL_INSURANCE
27793: ,REBOOK_LIMIT_DATE
27794: ,IMPORT_REQUEST_ID
27795: ,END_OF_TERM_OPTION
27796: ,END_OF_TERM_AMOUNT

Line 29369: p_residual_grnty_amt => okl_line_rec.residual_amount_guarantee,

29365: p_asset_loc_segment6 => okl_line_rec.asset_location_segment6,
29366: p_asset_loc_segment7 => okl_line_rec.asset_location_segment7,
29367: p_salvage_value => okl_line_rec.salvage_value,
29368: p_salvage_ptg => okl_line_rec.salvage_value_percent,
29369: p_residual_grnty_amt => okl_line_rec.residual_amount_guarantee,
29370: p_residual_code => okl_line_rec.guarantor_type_code,
29371: p_residual_ptg => okl_line_rec.residual_percent,
29372: p_residual_amt => okl_line_rec.residual_amount,
29373: p_tax_book => okl_line_rec.tax_book,

Line 29370: p_residual_code => okl_line_rec.guarantor_type_code,

29366: p_asset_loc_segment7 => okl_line_rec.asset_location_segment7,
29367: p_salvage_value => okl_line_rec.salvage_value,
29368: p_salvage_ptg => okl_line_rec.salvage_value_percent,
29369: p_residual_grnty_amt => okl_line_rec.residual_amount_guarantee,
29370: p_residual_code => okl_line_rec.guarantor_type_code,
29371: p_residual_ptg => okl_line_rec.residual_percent,
29372: p_residual_amt => okl_line_rec.residual_amount,
29373: p_tax_book => okl_line_rec.tax_book,
29374: p_tax_deprn => okl_line_rec.deprn_method_tax,

Line 29371: p_residual_ptg => okl_line_rec.residual_percent,

29367: p_salvage_value => okl_line_rec.salvage_value,
29368: p_salvage_ptg => okl_line_rec.salvage_value_percent,
29369: p_residual_grnty_amt => okl_line_rec.residual_amount_guarantee,
29370: p_residual_code => okl_line_rec.guarantor_type_code,
29371: p_residual_ptg => okl_line_rec.residual_percent,
29372: p_residual_amt => okl_line_rec.residual_amount,
29373: p_tax_book => okl_line_rec.tax_book,
29374: p_tax_deprn => okl_line_rec.deprn_method_tax,
29375: p_tax_life_in_mnth => okl_line_rec.life_in_months_tax,

Line 29372: p_residual_amt => okl_line_rec.residual_amount,

29368: p_salvage_ptg => okl_line_rec.salvage_value_percent,
29369: p_residual_grnty_amt => okl_line_rec.residual_amount_guarantee,
29370: p_residual_code => okl_line_rec.guarantor_type_code,
29371: p_residual_ptg => okl_line_rec.residual_percent,
29372: p_residual_amt => okl_line_rec.residual_amount,
29373: p_tax_book => okl_line_rec.tax_book,
29374: p_tax_deprn => okl_line_rec.deprn_method_tax,
29375: p_tax_life_in_mnth => okl_line_rec.life_in_months_tax,
29376: p_tax_deprn_rate => okl_line_rec.deprn_rate_tax,

Line 29563: p_klev_fin_rec.residual_percentage := okl_line_rec.residual_percent;

29559: -- Rviriyal - fix for bug 5397754 -- End
29560:
29561: p_klev_fin_rec := NULL;
29562: p_klev_fin_rec.year_of_manufacture := okl_line_rec.year_of_manufacture;
29563: p_klev_fin_rec.residual_percentage := okl_line_rec.residual_percent;
29564: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;
29565: /*
29566: IF (okl_line_rec.residual_amount IS NULL) THEN
29567: --p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / (nvl(okl_line_rec.amount,1) * 100));

Line 29564: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;

29560:
29561: p_klev_fin_rec := NULL;
29562: p_klev_fin_rec.year_of_manufacture := okl_line_rec.year_of_manufacture;
29563: p_klev_fin_rec.residual_percentage := okl_line_rec.residual_percent;
29564: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;
29565: /*
29566: IF (okl_line_rec.residual_amount IS NULL) THEN
29567: --p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / (nvl(okl_line_rec.amount,1) * 100));
29568: p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / 100) * nvl(okl_line_rec.amount,0);

Line 29566: IF (okl_line_rec.residual_amount IS NULL) THEN

29562: p_klev_fin_rec.year_of_manufacture := okl_line_rec.year_of_manufacture;
29563: p_klev_fin_rec.residual_percentage := okl_line_rec.residual_percent;
29564: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;
29565: /*
29566: IF (okl_line_rec.residual_amount IS NULL) THEN
29567: --p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / (nvl(okl_line_rec.amount,1) * 100));
29568: p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / 100) * nvl(okl_line_rec.amount,0);
29569: ELSE
29570: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;

Line 29567: --p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / (nvl(okl_line_rec.amount,1) * 100));

29563: p_klev_fin_rec.residual_percentage := okl_line_rec.residual_percent;
29564: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;
29565: /*
29566: IF (okl_line_rec.residual_amount IS NULL) THEN
29567: --p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / (nvl(okl_line_rec.amount,1) * 100));
29568: p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / 100) * nvl(okl_line_rec.amount,0);
29569: ELSE
29570: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;
29571: END IF;

Line 29568: p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / 100) * nvl(okl_line_rec.amount,0);

29564: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;
29565: /*
29566: IF (okl_line_rec.residual_amount IS NULL) THEN
29567: --p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / (nvl(okl_line_rec.amount,1) * 100));
29568: p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / 100) * nvl(okl_line_rec.amount,0);
29569: ELSE
29570: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;
29571: END IF;
29572: */

Line 29570: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;

29566: IF (okl_line_rec.residual_amount IS NULL) THEN
29567: --p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / (nvl(okl_line_rec.amount,1) * 100));
29568: p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / 100) * nvl(okl_line_rec.amount,0);
29569: ELSE
29570: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;
29571: END IF;
29572: */
29573: p_klev_fin_rec.residual_grnty_amount := okl_line_rec.residual_amount_guarantee;
29574: p_klev_fin_rec.tradein_amount := okl_line_rec.trade_in_amount;

Line 29573: p_klev_fin_rec.residual_grnty_amount := okl_line_rec.residual_amount_guarantee;

29569: ELSE
29570: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;
29571: END IF;
29572: */
29573: p_klev_fin_rec.residual_grnty_amount := okl_line_rec.residual_amount_guarantee;
29574: p_klev_fin_rec.tradein_amount := okl_line_rec.trade_in_amount;
29575:
29576: IF (okl_line_rec.capital_reduction_percent IS NOT NULL) THEN
29577: --p_klev_fin_rec.capital_reduction := (okl_line_rec.capital_reduction_percent / (nvl(okl_line_rec.amount,1) * 100));

Line 29617: p_klev_fin_rec.residual_code := NVL(okl_line_rec.guarantor_type_code,'NONE');

29613: p_klev_fin_rec.oec := okl_line_rec.original_cost;
29614: --p_klev_fin_rec.capital_amount := okl_line_rec.amount;
29615: p_klev_fin_rec.capitalized_interest := okl_line_rec.capitalized_interest;
29616: p_klev_fin_rec.capital_reduction_percent := okl_line_rec.capital_reduction_percent;
29617: p_klev_fin_rec.residual_code := NVL(okl_line_rec.guarantor_type_code,'NONE');
29618: p_cimv_model_rec := NULL;
29619: p_cimv_model_rec.chr_id := x_chrv_rec.id;
29620: p_cimv_model_rec.dnz_chr_id := x_chrv_rec.id;
29621: p_cimv_model_rec.number_of_items := okl_line_rec.total_units;

Line 29845: debug_message('Residual% : '|| p_klev_fin_rec.residual_percentage);

29841: p_itiv_ib_tbl(1).object_id1_new := x_install_site_id;
29842: p_itiv_ib_tbl(1).object_id2_new := '#';
29843:
29844: END IF;
29845: debug_message('Residual% : '|| p_klev_fin_rec.residual_percentage);
29846: debug_message('Residual value : '|| p_klev_fin_rec.residual_value);
29847:
29848: -- Contract addl field, Bug 4558486
29849:

Line 29846: debug_message('Residual value : '|| p_klev_fin_rec.residual_value);

29842: p_itiv_ib_tbl(1).object_id2_new := '#';
29843:
29844: END IF;
29845: debug_message('Residual% : '|| p_klev_fin_rec.residual_percentage);
29846: debug_message('Residual value : '|| p_klev_fin_rec.residual_value);
29847:
29848: -- Contract addl field, Bug 4558486
29849:
29850: debug_message('Contract Asset line DFF...'||'Line#: '||okl_line_rec.line_number);