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 303: ,CALCULATE_RESIDUAL_INSURANCE OKL_HEADER_INTERFACE.CALCULATE_RESIDUAL_INSURANCE%TYPE

299: ,MASTER_LEASE_AGREEMENT_NUMBER OKL_HEADER_INTERFACE.MASTER_LEASE_AGREEMENT_NUMBER%TYPE
300: ,MASTER_LEASE_AGREEMENT_ID OKL_HEADER_INTERFACE.MASTER_LEASE_AGREEMENT_ID%TYPE
301: ,PRODUCT_NAME OKL_HEADER_INTERFACE.PRODUCT_NAME%TYPE
302: ,PRODUCT_ID OKL_HEADER_INTERFACE.PRODUCT_ID%TYPE
303: ,CALCULATE_RESIDUAL_INSURANCE OKL_HEADER_INTERFACE.CALCULATE_RESIDUAL_INSURANCE%TYPE
304: ,REBOOK_LIMIT_DATE OKL_HEADER_INTERFACE.REBOOK_LIMIT_DATE%TYPE
305: ,IMPORT_REQUEST_ID OKL_HEADER_INTERFACE.IMPORT_REQUEST_ID%TYPE
306: ,END_OF_TERM_OPTION OKL_HEADER_INTERFACE.END_OF_TERM_OPTION%TYPE
307: ,END_OF_TERM_AMOUNT OKL_HEADER_INTERFACE.END_OF_TERM_AMOUNT%TYPE

Line 864: FROM dual;

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

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

3298: -- DO NOT CALL THIS PROCEDURE FOR IMPORT
3299: --
3300:
3301: l_proc_name := 'CHECK_INPUT_RECORD';
3302: x_return_status := OKL_API.G_RET_STS_SUCCESS; -- individual validaiton status
3303: l_record_status := OKL_API.G_RET_STS_SUCCESS; -- record level status
3304: l_batch_status := OKL_API.G_RET_STS_SUCCESS; -- batch level status
3305:
3306: okl_api.init_msg_list(p_init_msg_list => OKL_API.G_TRUE);

Line 26470: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,

26466: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
26467: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
26468: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26469: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26470: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26471: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26472: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26473: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26474: p_tax_book IN okl_lines_interface.tax_book%TYPE,

Line 26471: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,

26467: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
26468: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26469: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26470: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26471: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26472: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26473: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26474: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26475: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,

Line 26472: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,

26468: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26469: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26470: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26471: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26472: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26473: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26474: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26475: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,
26476: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,

Line 26473: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,

26469: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26470: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26471: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26472: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26473: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26474: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26475: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,
26476: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,
26477: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,

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

26539:
26540: debug_message('------> Contract id: '||p_chr_id);
26541: debug_message('------> Asset id: '||p_asset_id);
26542:
26543: debug_message('------> Residual : '||p_residual_ptg||'/'||p_residual_amt);
26544: debug_message('------> Unit Price : '||p_unit_price);
26545: l_cimv_fa_rec.object1_id1 := p_asset_id;
26546: l_cimv_fa_rec.object1_id2 := '#';
26547: l_clev_fin_rec.dnz_chr_id := p_chr_id;

Line 26554: IF (p_residual_grnty_amt IS NOT NULL) THEN

26550: l_clev_fin_rec.price_unit := p_unit_price;
26551: l_talv_fa_rec.original_cost := p_unit_price;
26552: END IF;
26553:
26554: IF (p_residual_grnty_amt IS NOT NULL) THEN
26555: l_klev_fin_rec.residual_grnty_amount := p_residual_grnty_amt;
26556: END IF;
26557:
26558: IF (p_residual_ptg IS NOT NULL) THEN

Line 26555: l_klev_fin_rec.residual_grnty_amount := p_residual_grnty_amt;

26551: l_talv_fa_rec.original_cost := p_unit_price;
26552: END IF;
26553:
26554: IF (p_residual_grnty_amt IS NOT NULL) THEN
26555: l_klev_fin_rec.residual_grnty_amount := p_residual_grnty_amt;
26556: END IF;
26557:
26558: IF (p_residual_ptg IS NOT NULL) THEN
26559: l_klev_fin_rec.residual_percentage := p_residual_ptg;

Line 26558: IF (p_residual_ptg IS NOT NULL) THEN

26554: IF (p_residual_grnty_amt IS NOT NULL) THEN
26555: l_klev_fin_rec.residual_grnty_amount := p_residual_grnty_amt;
26556: END IF;
26557:
26558: IF (p_residual_ptg IS NOT NULL) THEN
26559: l_klev_fin_rec.residual_percentage := p_residual_ptg;
26560: END IF;
26561:
26562: IF (p_residual_amt IS NOT NULL) THEN

Line 26559: l_klev_fin_rec.residual_percentage := p_residual_ptg;

26555: l_klev_fin_rec.residual_grnty_amount := p_residual_grnty_amt;
26556: END IF;
26557:
26558: IF (p_residual_ptg IS NOT NULL) THEN
26559: l_klev_fin_rec.residual_percentage := p_residual_ptg;
26560: END IF;
26561:
26562: IF (p_residual_amt IS NOT NULL) THEN
26563: l_klev_fin_rec.residual_value := p_residual_amt;

Line 26562: IF (p_residual_amt IS NOT NULL) THEN

26558: IF (p_residual_ptg IS NOT NULL) THEN
26559: l_klev_fin_rec.residual_percentage := p_residual_ptg;
26560: END IF;
26561:
26562: IF (p_residual_amt IS NOT NULL) THEN
26563: l_klev_fin_rec.residual_value := p_residual_amt;
26564: END IF;
26565: l_klev_fin_rec.residual_code := NVL(p_residual_code,'NONE');
26566:

Line 26563: l_klev_fin_rec.residual_value := p_residual_amt;

26559: l_klev_fin_rec.residual_percentage := p_residual_ptg;
26560: END IF;
26561:
26562: IF (p_residual_amt IS NOT NULL) THEN
26563: l_klev_fin_rec.residual_value := p_residual_amt;
26564: END IF;
26565: l_klev_fin_rec.residual_code := NVL(p_residual_code,'NONE');
26566:
26567: IF (p_deprn_method IS NOT NULL) THEN

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

26561:
26562: IF (p_residual_amt IS NOT NULL) THEN
26563: l_klev_fin_rec.residual_value := p_residual_amt;
26564: END IF;
26565: l_klev_fin_rec.residual_code := NVL(p_residual_code,'NONE');
26566:
26567: IF (p_deprn_method IS NOT NULL) THEN
26568: l_talv_fa_rec.deprn_method := p_deprn_method;
26569: END IF;

Line 27711: ,CALCULATE_RESIDUAL_INSURANCE

27707: ,MASTER_LEASE_AGREEMENT_NUMBER
27708: ,MASTER_LEASE_AGREEMENT_ID
27709: ,PRODUCT_NAME
27710: ,PRODUCT_ID
27711: ,CALCULATE_RESIDUAL_INSURANCE
27712: ,REBOOK_LIMIT_DATE
27713: ,IMPORT_REQUEST_ID
27714: ,END_OF_TERM_OPTION
27715: ,END_OF_TERM_AMOUNT

Line 28089: ,CALCULATE_RESIDUAL_INSURANCE

28085: ,MASTER_LEASE_AGREEMENT_NUMBER
28086: ,MASTER_LEASE_AGREEMENT_ID
28087: ,PRODUCT_NAME
28088: ,PRODUCT_ID
28089: ,CALCULATE_RESIDUAL_INSURANCE
28090: ,REBOOK_LIMIT_DATE
28091: ,IMPORT_REQUEST_ID
28092: ,END_OF_TERM_OPTION
28093: ,END_OF_TERM_AMOUNT

Line 29705: p_residual_grnty_amt => okl_line_rec.residual_amount_guarantee,

29701: p_asset_loc_segment6 => okl_line_rec.asset_location_segment6,
29702: p_asset_loc_segment7 => okl_line_rec.asset_location_segment7,
29703: p_salvage_value => okl_line_rec.salvage_value,
29704: p_salvage_ptg => okl_line_rec.salvage_value_percent,
29705: p_residual_grnty_amt => okl_line_rec.residual_amount_guarantee,
29706: p_residual_code => okl_line_rec.guarantor_type_code,
29707: p_residual_ptg => okl_line_rec.residual_percent,
29708: p_residual_amt => okl_line_rec.residual_amount,
29709: p_tax_book => okl_line_rec.tax_book,

Line 29706: p_residual_code => okl_line_rec.guarantor_type_code,

29702: p_asset_loc_segment7 => okl_line_rec.asset_location_segment7,
29703: p_salvage_value => okl_line_rec.salvage_value,
29704: p_salvage_ptg => okl_line_rec.salvage_value_percent,
29705: p_residual_grnty_amt => okl_line_rec.residual_amount_guarantee,
29706: p_residual_code => okl_line_rec.guarantor_type_code,
29707: p_residual_ptg => okl_line_rec.residual_percent,
29708: p_residual_amt => okl_line_rec.residual_amount,
29709: p_tax_book => okl_line_rec.tax_book,
29710: p_tax_deprn => okl_line_rec.deprn_method_tax,

Line 29707: p_residual_ptg => okl_line_rec.residual_percent,

29703: p_salvage_value => okl_line_rec.salvage_value,
29704: p_salvage_ptg => okl_line_rec.salvage_value_percent,
29705: p_residual_grnty_amt => okl_line_rec.residual_amount_guarantee,
29706: p_residual_code => okl_line_rec.guarantor_type_code,
29707: p_residual_ptg => okl_line_rec.residual_percent,
29708: p_residual_amt => okl_line_rec.residual_amount,
29709: p_tax_book => okl_line_rec.tax_book,
29710: p_tax_deprn => okl_line_rec.deprn_method_tax,
29711: p_tax_life_in_mnth => okl_line_rec.life_in_months_tax,

Line 29708: p_residual_amt => okl_line_rec.residual_amount,

29704: p_salvage_ptg => okl_line_rec.salvage_value_percent,
29705: p_residual_grnty_amt => okl_line_rec.residual_amount_guarantee,
29706: p_residual_code => okl_line_rec.guarantor_type_code,
29707: p_residual_ptg => okl_line_rec.residual_percent,
29708: p_residual_amt => okl_line_rec.residual_amount,
29709: p_tax_book => okl_line_rec.tax_book,
29710: p_tax_deprn => okl_line_rec.deprn_method_tax,
29711: p_tax_life_in_mnth => okl_line_rec.life_in_months_tax,
29712: p_tax_deprn_rate => okl_line_rec.deprn_rate_tax,

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

29899: -- Rviriyal - fix for bug 5397754 -- End
29900:
29901: p_klev_fin_rec := NULL;
29902: p_klev_fin_rec.year_of_manufacture := okl_line_rec.year_of_manufacture;
29903: p_klev_fin_rec.residual_percentage := okl_line_rec.residual_percent;
29904: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;
29905: /*
29906: IF (okl_line_rec.residual_amount IS NULL) THEN
29907: --p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / (nvl(okl_line_rec.amount,1) * 100));

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

29900:
29901: p_klev_fin_rec := NULL;
29902: p_klev_fin_rec.year_of_manufacture := okl_line_rec.year_of_manufacture;
29903: p_klev_fin_rec.residual_percentage := okl_line_rec.residual_percent;
29904: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;
29905: /*
29906: IF (okl_line_rec.residual_amount IS NULL) THEN
29907: --p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / (nvl(okl_line_rec.amount,1) * 100));
29908: p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / 100) * nvl(okl_line_rec.amount,0);

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

29902: p_klev_fin_rec.year_of_manufacture := okl_line_rec.year_of_manufacture;
29903: p_klev_fin_rec.residual_percentage := okl_line_rec.residual_percent;
29904: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;
29905: /*
29906: IF (okl_line_rec.residual_amount IS NULL) THEN
29907: --p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / (nvl(okl_line_rec.amount,1) * 100));
29908: p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / 100) * nvl(okl_line_rec.amount,0);
29909: ELSE
29910: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;

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

29903: p_klev_fin_rec.residual_percentage := okl_line_rec.residual_percent;
29904: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;
29905: /*
29906: IF (okl_line_rec.residual_amount IS NULL) THEN
29907: --p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / (nvl(okl_line_rec.amount,1) * 100));
29908: p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / 100) * nvl(okl_line_rec.amount,0);
29909: ELSE
29910: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;
29911: END IF;

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

29904: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;
29905: /*
29906: IF (okl_line_rec.residual_amount IS NULL) THEN
29907: --p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / (nvl(okl_line_rec.amount,1) * 100));
29908: p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / 100) * nvl(okl_line_rec.amount,0);
29909: ELSE
29910: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;
29911: END IF;
29912: */

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

29906: IF (okl_line_rec.residual_amount IS NULL) THEN
29907: --p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / (nvl(okl_line_rec.amount,1) * 100));
29908: p_klev_fin_rec.residual_value := (okl_line_rec.residual_percent / 100) * nvl(okl_line_rec.amount,0);
29909: ELSE
29910: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;
29911: END IF;
29912: */
29913: p_klev_fin_rec.residual_grnty_amount := okl_line_rec.residual_amount_guarantee;
29914: p_klev_fin_rec.tradein_amount := okl_line_rec.trade_in_amount;

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

29909: ELSE
29910: p_klev_fin_rec.residual_value := okl_line_rec.residual_amount;
29911: END IF;
29912: */
29913: p_klev_fin_rec.residual_grnty_amount := okl_line_rec.residual_amount_guarantee;
29914: p_klev_fin_rec.tradein_amount := okl_line_rec.trade_in_amount;
29915:
29916: IF (okl_line_rec.capital_reduction_percent IS NOT NULL) THEN
29917: --p_klev_fin_rec.capital_reduction := (okl_line_rec.capital_reduction_percent / (nvl(okl_line_rec.amount,1) * 100));

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

29953: p_klev_fin_rec.oec := okl_line_rec.original_cost;
29954: --p_klev_fin_rec.capital_amount := okl_line_rec.amount;
29955: p_klev_fin_rec.capitalized_interest := okl_line_rec.capitalized_interest;
29956: p_klev_fin_rec.capital_reduction_percent := okl_line_rec.capital_reduction_percent;
29957: p_klev_fin_rec.residual_code := NVL(okl_line_rec.guarantor_type_code,'NONE');
29958: p_cimv_model_rec := NULL;
29959: p_cimv_model_rec.chr_id := x_chrv_rec.id;
29960: p_cimv_model_rec.dnz_chr_id := x_chrv_rec.id;
29961: p_cimv_model_rec.number_of_items := okl_line_rec.total_units;

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

30195: p_itiv_ib_tbl(1).object_id1_new := x_install_site_id;
30196: p_itiv_ib_tbl(1).object_id2_new := '#';
30197:
30198: END IF;
30199: debug_message('Residual% : '|| p_klev_fin_rec.residual_percentage);
30200: debug_message('Residual value : '|| p_klev_fin_rec.residual_value);
30201:
30202: -- Contract addl field, Bug 4558486
30203:

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

30196: p_itiv_ib_tbl(1).object_id2_new := '#';
30197:
30198: END IF;
30199: debug_message('Residual% : '|| p_klev_fin_rec.residual_percentage);
30200: debug_message('Residual value : '|| p_klev_fin_rec.residual_value);
30201:
30202: -- Contract addl field, Bug 4558486
30203:
30204: debug_message('Contract Asset line DFF...'||'Line#: '||okl_line_rec.line_number);