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

Line 778: RESIDUAL_PERCENTAGE,

774: EVERGREEN_PERCENT,
775: AMOUNT_STAKE,
776: OCCUPANCY,
777: COVERAGE,
778: RESIDUAL_PERCENTAGE,
779: DATE_LAST_INSPECTION,
780: DATE_SOLD,
781: LRV_AMOUNT,
782: CAPITAL_REDUCTION,

Line 784: DATE_RESIDUAL_LAST_REVIEW,

780: DATE_SOLD,
781: LRV_AMOUNT,
782: CAPITAL_REDUCTION,
783: DATE_NEXT_INSPECTION_DUE,
784: DATE_RESIDUAL_LAST_REVIEW,
785: DATE_LAST_REAMORTISATION,
786: VENDOR_ADVANCE_PAID,
787: WEIGHTED_AVERAGE_LIFE,
788: TRADEIN_AMOUNT,

Line 809: RESIDUAL_VALUE,

805: REPURCHASED_AMOUNT,
806: DATE_COMMITMENT_EXPIRATION,
807: DATE_REPURCHASED,
808: DATE_APPRAISAL,
809: RESIDUAL_VALUE,
810: APPRAISAL_VALUE,
811: SECURED_DEAL_YN,
812: GAIN_LOSS,
813: FLOOR_AMOUNT,

Line 816: TRACKED_RESIDUAL,

812: GAIN_LOSS,
813: FLOOR_AMOUNT,
814: RE_LEASE_YN,
815: PREVIOUS_CONTRACT,
816: TRACKED_RESIDUAL,
817: DATE_TITLE_RECEIVED,
818: AMOUNT,
819: ATTRIBUTE_CATEGORY,
820: ATTRIBUTE1,

Line 848: RESIDUAL_GRNTY_AMOUNT,

844: DATE_ACCEPTED,
845: DATE_DELIVERY_EXPECTED,
846: OEC,
847: CAPITAL_AMOUNT,
848: RESIDUAL_GRNTY_AMOUNT,
849: RESIDUAL_CODE,
850: RVI_PREMIUM,
851: CREDIT_NATURE,
852: CAPITALIZED_INTEREST,

Line 849: RESIDUAL_CODE,

845: DATE_DELIVERY_EXPECTED,
846: OEC,
847: CAPITAL_AMOUNT,
848: RESIDUAL_GRNTY_AMOUNT,
849: RESIDUAL_CODE,
850: RVI_PREMIUM,
851: CREDIT_NATURE,
852: CAPITALIZED_INTEREST,
853: CAPITAL_REDUCTION_PERCENT,

Line 920: l_klev_rec.RESIDUAL_PERCENTAGE,

916: l_klev_rec.EVERGREEN_PERCENT,
917: l_klev_rec.AMOUNT_STAKE,
918: l_klev_rec.OCCUPANCY,
919: l_klev_rec.COVERAGE,
920: l_klev_rec.RESIDUAL_PERCENTAGE,
921: l_klev_rec.DATE_LAST_INSPECTION,
922: l_klev_rec.DATE_SOLD,
923: l_klev_rec.LRV_AMOUNT,
924: l_klev_rec.CAPITAL_REDUCTION,

Line 926: l_klev_rec.DATE_RESIDUAL_LAST_REVIEW,

922: l_klev_rec.DATE_SOLD,
923: l_klev_rec.LRV_AMOUNT,
924: l_klev_rec.CAPITAL_REDUCTION,
925: l_klev_rec.DATE_NEXT_INSPECTION_DUE,
926: l_klev_rec.DATE_RESIDUAL_LAST_REVIEW,
927: l_klev_rec.DATE_LAST_REAMORTISATION,
928: l_klev_rec.VENDOR_ADVANCE_PAID,
929: l_klev_rec.WEIGHTED_AVERAGE_LIFE,
930: l_klev_rec.TRADEIN_AMOUNT,

Line 951: l_klev_rec.RESIDUAL_VALUE,

947: l_klev_rec.REPURCHASED_AMOUNT,
948: l_klev_rec.DATE_COMMITMENT_EXPIRATION,
949: l_klev_rec.DATE_REPURCHASED,
950: l_klev_rec.DATE_APPRAISAL,
951: l_klev_rec.RESIDUAL_VALUE,
952: l_klev_rec.APPRAISAL_VALUE,
953: l_klev_rec.SECURED_DEAL_YN,
954: l_klev_rec.GAIN_LOSS,
955: l_klev_rec.FLOOR_AMOUNT,

Line 958: l_klev_rec.TRACKED_RESIDUAL,

954: l_klev_rec.GAIN_LOSS,
955: l_klev_rec.FLOOR_AMOUNT,
956: l_klev_rec.RE_LEASE_YN,
957: l_klev_rec.PREVIOUS_CONTRACT,
958: l_klev_rec.TRACKED_RESIDUAL,
959: l_klev_rec.DATE_TITLE_RECEIVED,
960: l_klev_rec.AMOUNT,
961: l_klev_rec.ATTRIBUTE_CATEGORY,
962: l_klev_rec.ATTRIBUTE1,

Line 990: l_klev_rec.RESIDUAL_GRNTY_AMOUNT,

986: l_klev_rec.DATE_ACCEPTED,
987: l_klev_rec.DATE_DELIVERY_EXPECTED,
988: l_klev_rec.OEC,
989: l_klev_rec.CAPITAL_AMOUNT,
990: l_klev_rec.RESIDUAL_GRNTY_AMOUNT,
991: l_klev_rec.RESIDUAL_CODE,
992: l_klev_rec.RVI_PREMIUM,
993: l_klev_rec.CREDIT_NATURE,
994: l_klev_rec.CAPITALIZED_INTEREST,

Line 991: l_klev_rec.RESIDUAL_CODE,

987: l_klev_rec.DATE_DELIVERY_EXPECTED,
988: l_klev_rec.OEC,
989: l_klev_rec.CAPITAL_AMOUNT,
990: l_klev_rec.RESIDUAL_GRNTY_AMOUNT,
991: l_klev_rec.RESIDUAL_CODE,
992: l_klev_rec.RVI_PREMIUM,
993: l_klev_rec.CREDIT_NATURE,
994: l_klev_rec.CAPITALIZED_INTEREST,
995: l_klev_rec.CAPITAL_REDUCTION_PERCENT,

Line 5906: TYPE l_tbnew_residual_value_type IS TABLE OF okl_txl_assets_b.new_residual_value%TYPE INDEX BY BINARY_INTEGER;

5902: TYPE l_tblast_update_login_type IS TABLE OF okl_txl_assets_b.last_update_login%TYPE INDEX BY BINARY_INTEGER;
5903: TYPE l_tbdepreciate_yn_type IS TABLE OF okl_txl_assets_b.depreciate_yn%TYPE INDEX BY BINARY_INTEGER;
5904: TYPE l_tbhold_period_days_type IS TABLE OF okl_txl_assets_b.hold_period_days%TYPE INDEX BY BINARY_INTEGER;
5905: TYPE l_tbold_salvage_value_type IS TABLE OF okl_txl_assets_b.old_salvage_value%TYPE INDEX BY BINARY_INTEGER;
5906: TYPE l_tbnew_residual_value_type IS TABLE OF okl_txl_assets_b.new_residual_value%TYPE INDEX BY BINARY_INTEGER;
5907: TYPE l_tbold_residual_value_type IS TABLE OF okl_txl_assets_b.old_residual_value%TYPE INDEX BY BINARY_INTEGER;
5908: TYPE l_tbunits_retired_type IS TABLE OF okl_txl_assets_b.units_retired%TYPE INDEX BY BINARY_INTEGER;
5909: TYPE l_tbcost_retired_type IS TABLE OF okl_txl_assets_b.cost_retired%TYPE INDEX BY BINARY_INTEGER;
5910: TYPE l_tbsale_proceeds_type IS TABLE OF okl_txl_assets_b.sale_proceeds%TYPE INDEX BY BINARY_INTEGER;

Line 5907: TYPE l_tbold_residual_value_type IS TABLE OF okl_txl_assets_b.old_residual_value%TYPE INDEX BY BINARY_INTEGER;

5903: TYPE l_tbdepreciate_yn_type IS TABLE OF okl_txl_assets_b.depreciate_yn%TYPE INDEX BY BINARY_INTEGER;
5904: TYPE l_tbhold_period_days_type IS TABLE OF okl_txl_assets_b.hold_period_days%TYPE INDEX BY BINARY_INTEGER;
5905: TYPE l_tbold_salvage_value_type IS TABLE OF okl_txl_assets_b.old_salvage_value%TYPE INDEX BY BINARY_INTEGER;
5906: TYPE l_tbnew_residual_value_type IS TABLE OF okl_txl_assets_b.new_residual_value%TYPE INDEX BY BINARY_INTEGER;
5907: TYPE l_tbold_residual_value_type IS TABLE OF okl_txl_assets_b.old_residual_value%TYPE INDEX BY BINARY_INTEGER;
5908: TYPE l_tbunits_retired_type IS TABLE OF okl_txl_assets_b.units_retired%TYPE INDEX BY BINARY_INTEGER;
5909: TYPE l_tbcost_retired_type IS TABLE OF okl_txl_assets_b.cost_retired%TYPE INDEX BY BINARY_INTEGER;
5910: TYPE l_tbsale_proceeds_type IS TABLE OF okl_txl_assets_b.sale_proceeds%TYPE INDEX BY BINARY_INTEGER;
5911: TYPE l_tbremoval_cost_type IS TABLE OF okl_txl_assets_b.removal_cost%TYPE INDEX BY BINARY_INTEGER;

Line 6604: l_tbnew_residual_value_tab l_tbnew_residual_value_type;

6600: l_tblast_update_login_tab l_tblast_update_login_type;
6601: l_tbdepreciate_yn_tab l_tbdepreciate_yn_type;
6602: l_tbhold_period_days_tab l_tbhold_period_days_type;
6603: l_tbold_salvage_value_tab l_tbold_salvage_value_type;
6604: l_tbnew_residual_value_tab l_tbnew_residual_value_type;
6605: l_tbold_residual_value_tab l_tbold_residual_value_type;
6606: l_tbunits_retired_tab l_tbunits_retired_type;
6607: l_tbcost_retired_tab l_tbcost_retired_type;
6608: l_tbsale_proceeds_tab l_tbsale_proceeds_type;

Line 6605: l_tbold_residual_value_tab l_tbold_residual_value_type;

6601: l_tbdepreciate_yn_tab l_tbdepreciate_yn_type;
6602: l_tbhold_period_days_tab l_tbhold_period_days_type;
6603: l_tbold_salvage_value_tab l_tbold_salvage_value_type;
6604: l_tbnew_residual_value_tab l_tbnew_residual_value_type;
6605: l_tbold_residual_value_tab l_tbold_residual_value_type;
6606: l_tbunits_retired_tab l_tbunits_retired_type;
6607: l_tbcost_retired_tab l_tbcost_retired_type;
6608: l_tbsale_proceeds_tab l_tbsale_proceeds_type;
6609: l_tbremoval_cost_tab l_tbremoval_cost_type;

Line 6683: l_tb2new_residual_value_tab l_tbnew_residual_value_type;

6679: l_tb2last_update_login_tab l_tblast_update_login_type;
6680: l_tb2depreciate_yn_tab l_tbdepreciate_yn_type;
6681: l_tb2hold_period_days_tab l_tbhold_period_days_type;
6682: l_tb2old_salvage_value_tab l_tbold_salvage_value_type;
6683: l_tb2new_residual_value_tab l_tbnew_residual_value_type;
6684: l_tb2old_residual_value_tab l_tbold_residual_value_type;
6685: l_tb2units_retired_tab l_tbunits_retired_type;
6686: l_tb2cost_retired_tab l_tbcost_retired_type;
6687: l_tb2sale_proceeds_tab l_tbsale_proceeds_type;

Line 6684: l_tb2old_residual_value_tab l_tbold_residual_value_type;

6680: l_tb2depreciate_yn_tab l_tbdepreciate_yn_type;
6681: l_tb2hold_period_days_tab l_tbhold_period_days_type;
6682: l_tb2old_salvage_value_tab l_tbold_salvage_value_type;
6683: l_tb2new_residual_value_tab l_tbnew_residual_value_type;
6684: l_tb2old_residual_value_tab l_tbold_residual_value_type;
6685: l_tb2units_retired_tab l_tbunits_retired_type;
6686: l_tb2cost_retired_tab l_tbcost_retired_type;
6687: l_tb2sale_proceeds_tab l_tbsale_proceeds_type;
6688: l_tb2removal_cost_tab l_tbremoval_cost_type;

Line 8225: FROM dual;

8221:
8222: -- cursor to get sequence number for asset number
8223: CURSOR c_asset_no IS
8224: SELECT 'OKL'||OKL_FAN_SEQ.NEXTVAL
8225: FROM dual;
8226:
8227: -- cursor to get check the existence of asset number
8228: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE)
8229: IS

Line 8231: FROM DUAL

8227: -- cursor to get check the existence of asset number
8228: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE)
8229: IS
8230: SELECT 1
8231: FROM DUAL
8232: WHERE EXISTS (SELECT '1'
8233: FROM OKL_TXL_ASSETS_B
8234: WHERE asset_number = p_asset_number);
8235:

Line 8238: FROM DUAL

8234: WHERE asset_number = p_asset_number);
8235:
8236: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) IS
8237: SELECT 1
8238: FROM DUAL
8239: WHERE EXISTS (SELECT '1'
8240: FROM OKX_ASSET_LINES_V
8241: WHERE asset_number = p_asset_number);
8242:

Line 8245: FROM DUAL

8241: WHERE asset_number = p_asset_number);
8242:
8243: CURSOR c_okx_assets_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) IS
8244: SELECT 1
8245: FROM DUAL
8246: WHERE EXISTS (SELECT '1'
8247: FROM OKX_ASSETS_V
8248: WHERE asset_number = p_asset_number);
8249:

Line 10442: a.title_date, a.date_residual_last_review, a.date_last_reamortisation,

10438: CURSOR c8(p_id NUMBER) IS
10439: SELECT
10440: a.id, a.kle_id, a.sty_id,
10441: a.object_version_number, a.lao_amount, a.fee_charge,
10442: a.title_date, a.date_residual_last_review, a.date_last_reamortisation,
10443: a.termination_purchase_amount, a.date_last_cleanup, a.remarketed_amount,
10444: a.date_remarketed, a.remarket_margin, a.repurchased_amount,
10445: a.date_repurchased, a.gain_loss, a.floor_amount,
10446: a.previous_contract, a.tracked_residual, a.date_title_received,

Line 10446: a.previous_contract, a.tracked_residual, a.date_title_received,

10442: a.title_date, a.date_residual_last_review, a.date_last_reamortisation,
10443: a.termination_purchase_amount, a.date_last_cleanup, a.remarketed_amount,
10444: a.date_remarketed, a.remarket_margin, a.repurchased_amount,
10445: a.date_repurchased, a.gain_loss, a.floor_amount,
10446: a.previous_contract, a.tracked_residual, a.date_title_received,
10447: a.estimated_oec, a.residual_percentage, a.capital_reduction,
10448: a.vendor_advance_paid, a.tradein_amount, a.delivered_date,
10449: a.year_of_manufacture, a.initial_direct_cost, a.occupancy,
10450: a.date_last_inspection, a.date_next_inspection_due, a.weighted_average_life,

Line 10447: a.estimated_oec, a.residual_percentage, a.capital_reduction,

10443: a.termination_purchase_amount, a.date_last_cleanup, a.remarketed_amount,
10444: a.date_remarketed, a.remarket_margin, a.repurchased_amount,
10445: a.date_repurchased, a.gain_loss, a.floor_amount,
10446: a.previous_contract, a.tracked_residual, a.date_title_received,
10447: a.estimated_oec, a.residual_percentage, a.capital_reduction,
10448: a.vendor_advance_paid, a.tradein_amount, a.delivered_date,
10449: a.year_of_manufacture, a.initial_direct_cost, a.occupancy,
10450: a.date_last_inspection, a.date_next_inspection_due, a.weighted_average_life,
10451: a.bond_equivalent_yield, a.refinance_amount, a.year_built,

Line 10454: a.appraisal_value, a.residual_value, a.percent,

10450: a.date_last_inspection, a.date_next_inspection_due, a.weighted_average_life,
10451: a.bond_equivalent_yield, a.refinance_amount, a.year_built,
10452: a.coverage_ratio, a.gross_square_footage, a.net_rentable,
10453: a.date_letter_acceptance, a.date_commitment_expiration, a.date_appraisal,
10454: a.appraisal_value, a.residual_value, a.percent,
10455: a.coverage, a.lrv_amount, a.amount,
10456: a.lrs_percent, a.evergreen_percent, a.percent_stake,
10457: a.amount_stake, a.date_sold, a.sty_id_for,
10458: a.attribute_category, a.attribute1, a.attribute2,

Line 10469: a.oec, a.capital_amount, a.residual_grnty_amount,

10465: a.nty_code, a.fcg_code, a.prc_code,
10466: a.re_lease_yn, a.prescribed_asset_yn, a.credit_tenant_yn,
10467: a.secured_deal_yn, a.clg_id, a.date_funding,
10468: a.date_funding_required, a.date_accepted, a.date_delivery_expected,
10469: a.oec, a.capital_amount, a.residual_grnty_amount,
10470: a.residual_code, a.rvi_premium, a.credit_nature,
10471: a.capitalized_interest, a.capital_reduction_percent, a.date_pay_investor_start,
10472: a.pay_investor_frequency, a.pay_investor_event, a.pay_investor_remittance_days,
10473: a.fee_type, a.subsidy_id, a.subsidy_override_amount,

Line 10470: a.residual_code, a.rvi_premium, a.credit_nature,

10466: a.re_lease_yn, a.prescribed_asset_yn, a.credit_tenant_yn,
10467: a.secured_deal_yn, a.clg_id, a.date_funding,
10468: a.date_funding_required, a.date_accepted, a.date_delivery_expected,
10469: a.oec, a.capital_amount, a.residual_grnty_amount,
10470: a.residual_code, a.rvi_premium, a.credit_nature,
10471: a.capitalized_interest, a.capital_reduction_percent, a.date_pay_investor_start,
10472: a.pay_investor_frequency, a.pay_investor_event, a.pay_investor_remittance_days,
10473: a.fee_type, a.subsidy_id, a.subsidy_override_amount,
10474: a.pre_tax_yield, a.after_tax_yield, a.implicit_interest_rate,

Line 10497: TYPE l_date_residual_last_revi_type IS TABLE OF okl_k_lines.date_residual_last_review%TYPE INDEX BY BINARY_INTEGER;

10493: TYPE l_object_version_number_type IS TABLE OF okl_k_lines.object_version_number%TYPE INDEX BY BINARY_INTEGER;
10494: TYPE l_lao_amount_type IS TABLE OF okl_k_lines.lao_amount%TYPE INDEX BY BINARY_INTEGER;
10495: TYPE l_fee_charge_type IS TABLE OF okl_k_lines.fee_charge%TYPE INDEX BY BINARY_INTEGER;
10496: TYPE l_title_date_type IS TABLE OF okl_k_lines.title_date%TYPE INDEX BY BINARY_INTEGER;
10497: TYPE l_date_residual_last_revi_type IS TABLE OF okl_k_lines.date_residual_last_review%TYPE INDEX BY BINARY_INTEGER;
10498: TYPE l_date_last_reamortisatio_type IS TABLE OF okl_k_lines.date_last_reamortisation%TYPE INDEX BY BINARY_INTEGER;
10499: TYPE l_termination_purchase_am_type IS TABLE OF okl_k_lines.termination_purchase_amount%TYPE INDEX BY BINARY_INTEGER;
10500: TYPE l_date_last_cleanup_type IS TABLE OF okl_k_lines.date_last_cleanup%TYPE INDEX BY BINARY_INTEGER;
10501: TYPE l_remarketed_amount_type IS TABLE OF okl_k_lines.remarketed_amount%TYPE INDEX BY BINARY_INTEGER;

Line 10509: TYPE l_tracked_residual_type IS TABLE OF okl_k_lines.tracked_residual%TYPE INDEX BY BINARY_INTEGER;

10505: TYPE l_date_repurchased_type IS TABLE OF okl_k_lines.date_repurchased%TYPE INDEX BY BINARY_INTEGER;
10506: TYPE l_gain_loss_type IS TABLE OF okl_k_lines.gain_loss%TYPE INDEX BY BINARY_INTEGER;
10507: TYPE l_floor_amount_type IS TABLE OF okl_k_lines.floor_amount%TYPE INDEX BY BINARY_INTEGER;
10508: TYPE l_previous_contract_type IS TABLE OF okl_k_lines.previous_contract%TYPE INDEX BY BINARY_INTEGER;
10509: TYPE l_tracked_residual_type IS TABLE OF okl_k_lines.tracked_residual%TYPE INDEX BY BINARY_INTEGER;
10510: TYPE l_date_title_received_type IS TABLE OF okl_k_lines.date_title_received%TYPE INDEX BY BINARY_INTEGER;
10511: TYPE l_estimated_oec_type IS TABLE OF okl_k_lines.estimated_oec%TYPE INDEX BY BINARY_INTEGER;
10512: TYPE l_residual_percentage_type IS TABLE OF okl_k_lines.residual_percentage%TYPE INDEX BY BINARY_INTEGER;
10513: TYPE l_capital_reduction_type IS TABLE OF okl_k_lines.capital_reduction%TYPE INDEX BY BINARY_INTEGER;

Line 10512: TYPE l_residual_percentage_type IS TABLE OF okl_k_lines.residual_percentage%TYPE INDEX BY BINARY_INTEGER;

10508: TYPE l_previous_contract_type IS TABLE OF okl_k_lines.previous_contract%TYPE INDEX BY BINARY_INTEGER;
10509: TYPE l_tracked_residual_type IS TABLE OF okl_k_lines.tracked_residual%TYPE INDEX BY BINARY_INTEGER;
10510: TYPE l_date_title_received_type IS TABLE OF okl_k_lines.date_title_received%TYPE INDEX BY BINARY_INTEGER;
10511: TYPE l_estimated_oec_type IS TABLE OF okl_k_lines.estimated_oec%TYPE INDEX BY BINARY_INTEGER;
10512: TYPE l_residual_percentage_type IS TABLE OF okl_k_lines.residual_percentage%TYPE INDEX BY BINARY_INTEGER;
10513: TYPE l_capital_reduction_type IS TABLE OF okl_k_lines.capital_reduction%TYPE INDEX BY BINARY_INTEGER;
10514: TYPE l_vendor_advance_paid_type IS TABLE OF okl_k_lines.vendor_advance_paid%TYPE INDEX BY BINARY_INTEGER;
10515: TYPE l_tradein_amount_type IS TABLE OF okl_k_lines.tradein_amount%TYPE INDEX BY BINARY_INTEGER;
10516: TYPE l_delivered_date_type IS TABLE OF okl_k_lines.delivered_date%TYPE INDEX BY BINARY_INTEGER;

Line 10533: TYPE l_residual_value_type IS TABLE OF okl_k_lines.residual_value%TYPE INDEX BY BINARY_INTEGER;

10529: TYPE l_date_letter_acceptance_type IS TABLE OF okl_k_lines.date_letter_acceptance%TYPE INDEX BY BINARY_INTEGER;
10530: TYPE l_date_commitment_expirat_type IS TABLE OF okl_k_lines.date_commitment_expiration%TYPE INDEX BY BINARY_INTEGER;
10531: TYPE l_date_appraisal_type IS TABLE OF okl_k_lines.date_appraisal%TYPE INDEX BY BINARY_INTEGER;
10532: TYPE l_appraisal_value_type IS TABLE OF okl_k_lines.appraisal_value%TYPE INDEX BY BINARY_INTEGER;
10533: TYPE l_residual_value_type IS TABLE OF okl_k_lines.residual_value%TYPE INDEX BY BINARY_INTEGER;
10534: TYPE l_percent_type IS TABLE OF okl_k_lines.percent%TYPE INDEX BY BINARY_INTEGER;
10535: TYPE l_coverage_type IS TABLE OF okl_k_lines.coverage%TYPE INDEX BY BINARY_INTEGER;
10536: TYPE l_lrv_amount_type IS TABLE OF okl_k_lines.lrv_amount%TYPE INDEX BY BINARY_INTEGER;
10537: TYPE l_amount_type IS TABLE OF okl_k_lines.amount%TYPE INDEX BY BINARY_INTEGER;

Line 10579: TYPE l_residual_grnty_amount_type IS TABLE OF okl_k_lines.residual_grnty_amount%TYPE INDEX BY BINARY_INTEGER;

10575: TYPE l_date_accepted_type IS TABLE OF okl_k_lines.date_accepted%TYPE INDEX BY BINARY_INTEGER;
10576: TYPE l_date_delivery_expected_type IS TABLE OF okl_k_lines.date_delivery_expected%TYPE INDEX BY BINARY_INTEGER;
10577: TYPE l_oec_type IS TABLE OF okl_k_lines.oec%TYPE INDEX BY BINARY_INTEGER;
10578: TYPE l_capital_amount_type IS TABLE OF okl_k_lines.capital_amount%TYPE INDEX BY BINARY_INTEGER;
10579: TYPE l_residual_grnty_amount_type IS TABLE OF okl_k_lines.residual_grnty_amount%TYPE INDEX BY BINARY_INTEGER;
10580: TYPE l_residual_code_type IS TABLE OF okl_k_lines.residual_code%TYPE INDEX BY BINARY_INTEGER;
10581: TYPE l_rvi_premium_type IS TABLE OF okl_k_lines.rvi_premium%TYPE INDEX BY BINARY_INTEGER;
10582: TYPE l_credit_nature_type IS TABLE OF okl_k_lines.credit_nature%TYPE INDEX BY BINARY_INTEGER;
10583: TYPE l_capitalized_interest_type IS TABLE OF okl_k_lines.capitalized_interest%TYPE INDEX BY BINARY_INTEGER;

Line 10580: TYPE l_residual_code_type IS TABLE OF okl_k_lines.residual_code%TYPE INDEX BY BINARY_INTEGER;

10576: TYPE l_date_delivery_expected_type IS TABLE OF okl_k_lines.date_delivery_expected%TYPE INDEX BY BINARY_INTEGER;
10577: TYPE l_oec_type IS TABLE OF okl_k_lines.oec%TYPE INDEX BY BINARY_INTEGER;
10578: TYPE l_capital_amount_type IS TABLE OF okl_k_lines.capital_amount%TYPE INDEX BY BINARY_INTEGER;
10579: TYPE l_residual_grnty_amount_type IS TABLE OF okl_k_lines.residual_grnty_amount%TYPE INDEX BY BINARY_INTEGER;
10580: TYPE l_residual_code_type IS TABLE OF okl_k_lines.residual_code%TYPE INDEX BY BINARY_INTEGER;
10581: TYPE l_rvi_premium_type IS TABLE OF okl_k_lines.rvi_premium%TYPE INDEX BY BINARY_INTEGER;
10582: TYPE l_credit_nature_type IS TABLE OF okl_k_lines.credit_nature%TYPE INDEX BY BINARY_INTEGER;
10583: TYPE l_capitalized_interest_type IS TABLE OF okl_k_lines.capitalized_interest%TYPE INDEX BY BINARY_INTEGER;
10584: TYPE l_capital_reduction_perce_type IS TABLE OF okl_k_lines.capital_reduction_percent%TYPE INDEX BY BINARY_INTEGER;

Line 10624: l_date_residual_last_revi_tab l_date_residual_last_revi_type;

10620: l_object_version_number_tab l_object_version_number_type;
10621: l_lao_amount_tab l_lao_amount_type;
10622: l_fee_charge_tab l_fee_charge_type;
10623: l_title_date_tab l_title_date_type;
10624: l_date_residual_last_revi_tab l_date_residual_last_revi_type;
10625: l_date_last_reamortisatio_tab l_date_last_reamortisatio_type;
10626: l_termination_purchase_am_tab l_termination_purchase_am_type;
10627: l_date_last_cleanup_tab l_date_last_cleanup_type;
10628: l_remarketed_amount_tab l_remarketed_amount_type;

Line 10636: l_tracked_residual_tab l_tracked_residual_type;

10632: l_date_repurchased_tab l_date_repurchased_type;
10633: l_gain_loss_tab l_gain_loss_type;
10634: l_floor_amount_tab l_floor_amount_type;
10635: l_previous_contract_tab l_previous_contract_type;
10636: l_tracked_residual_tab l_tracked_residual_type;
10637: l_date_title_received_tab l_date_title_received_type;
10638: l_estimated_oec_tab l_estimated_oec_type;
10639: l_residual_percentage_tab l_residual_percentage_type;
10640: l_capital_reduction_tab l_capital_reduction_type;

Line 10639: l_residual_percentage_tab l_residual_percentage_type;

10635: l_previous_contract_tab l_previous_contract_type;
10636: l_tracked_residual_tab l_tracked_residual_type;
10637: l_date_title_received_tab l_date_title_received_type;
10638: l_estimated_oec_tab l_estimated_oec_type;
10639: l_residual_percentage_tab l_residual_percentage_type;
10640: l_capital_reduction_tab l_capital_reduction_type;
10641: l_vendor_advance_paid_tab l_vendor_advance_paid_type;
10642: l_tradein_amount_tab l_tradein_amount_type;
10643: l_delivered_date_tab l_delivered_date_type;

Line 10660: l_residual_value_tab l_residual_value_type;

10656: l_date_letter_acceptance_tab l_date_letter_acceptance_type;
10657: l_date_commitment_expirat_tab l_date_commitment_expirat_type;
10658: l_date_appraisal_tab l_date_appraisal_type;
10659: l_appraisal_value_tab l_appraisal_value_type;
10660: l_residual_value_tab l_residual_value_type;
10661: l_percent_tab l_percent_type;
10662: l_coverage_tab l_coverage_type;
10663: l_lrv_amount_tab l_lrv_amount_type;
10664: l_amount_tab l_amount_type;

Line 10706: l_residual_grnty_amount_tab l_residual_grnty_amount_type;

10702: l_date_accepted_tab l_date_accepted_type;
10703: l_date_delivery_expected_tab l_date_delivery_expected_type;
10704: l_oec_tab l_oec_type;
10705: l_capital_amount_tab l_capital_amount_type;
10706: l_residual_grnty_amount_tab l_residual_grnty_amount_type;
10707: l_residual_code_tab l_residual_code_type;
10708: l_rvi_premium_tab l_rvi_premium_type;
10709: l_credit_nature_tab l_credit_nature_type;
10710: l_capitalized_interest_tab l_capitalized_interest_type;

Line 10707: l_residual_code_tab l_residual_code_type;

10703: l_date_delivery_expected_tab l_date_delivery_expected_type;
10704: l_oec_tab l_oec_type;
10705: l_capital_amount_tab l_capital_amount_type;
10706: l_residual_grnty_amount_tab l_residual_grnty_amount_type;
10707: l_residual_code_tab l_residual_code_type;
10708: l_rvi_premium_tab l_rvi_premium_type;
10709: l_credit_nature_tab l_credit_nature_type;
10710: l_capitalized_interest_tab l_capitalized_interest_type;
10711: l_capital_reduction_perce_tab l_capital_reduction_perce_type;

Line 10750: l_date_residual_last_revi_tab2 l_date_residual_last_revi_type;

10746: l_object_version_number_tab2 l_object_version_number_type;
10747: l_lao_amount_tab2 l_lao_amount_type;
10748: l_fee_charge_tab2 l_fee_charge_type;
10749: l_title_date_tab2 l_title_date_type;
10750: l_date_residual_last_revi_tab2 l_date_residual_last_revi_type;
10751: l_date_last_reamortisatio_tab2 l_date_last_reamortisatio_type;
10752: l_termination_purchase_am_tab2 l_termination_purchase_am_type;
10753: l_date_last_cleanup_tab2 l_date_last_cleanup_type;
10754: l_remarketed_amount_tab2 l_remarketed_amount_type;

Line 10762: l_tracked_residual_tab2 l_tracked_residual_type;

10758: l_date_repurchased_tab2 l_date_repurchased_type;
10759: l_gain_loss_tab2 l_gain_loss_type;
10760: l_floor_amount_tab2 l_floor_amount_type;
10761: l_previous_contract_tab2 l_previous_contract_type;
10762: l_tracked_residual_tab2 l_tracked_residual_type;
10763: l_date_title_received_tab2 l_date_title_received_type;
10764: l_estimated_oec_tab2 l_estimated_oec_type;
10765: l_residual_percentage_tab2 l_residual_percentage_type;
10766: l_capital_reduction_tab2 l_capital_reduction_type;

Line 10765: l_residual_percentage_tab2 l_residual_percentage_type;

10761: l_previous_contract_tab2 l_previous_contract_type;
10762: l_tracked_residual_tab2 l_tracked_residual_type;
10763: l_date_title_received_tab2 l_date_title_received_type;
10764: l_estimated_oec_tab2 l_estimated_oec_type;
10765: l_residual_percentage_tab2 l_residual_percentage_type;
10766: l_capital_reduction_tab2 l_capital_reduction_type;
10767: l_vendor_advance_paid_tab2 l_vendor_advance_paid_type;
10768: l_tradein_amount_tab2 l_tradein_amount_type;
10769: l_delivered_date_tab2 l_delivered_date_type;

Line 10786: l_residual_value_tab2 l_residual_value_type;

10782: l_date_letter_acceptance_tab2 l_date_letter_acceptance_type;
10783: l_date_commitment_expirat_tab2 l_date_commitment_expirat_type;
10784: l_date_appraisal_tab2 l_date_appraisal_type;
10785: l_appraisal_value_tab2 l_appraisal_value_type;
10786: l_residual_value_tab2 l_residual_value_type;
10787: l_percent_tab2 l_percent_type;
10788: l_coverage_tab2 l_coverage_type;
10789: l_lrv_amount_tab2 l_lrv_amount_type;
10790: l_amount_tab2 l_amount_type;

Line 10832: l_residual_grnty_amount_tab2 l_residual_grnty_amount_type;

10828: l_date_accepted_tab2 l_date_accepted_type;
10829: l_date_delivery_expected_tab2 l_date_delivery_expected_type;
10830: l_oec_tab2 l_oec_type;
10831: l_capital_amount_tab2 l_capital_amount_type;
10832: l_residual_grnty_amount_tab2 l_residual_grnty_amount_type;
10833: l_residual_code_tab2 l_residual_code_type;
10834: l_rvi_premium_tab2 l_rvi_premium_type;
10835: l_credit_nature_tab2 l_credit_nature_type;
10836: l_capitalized_interest_tab2 l_capitalized_interest_type;

Line 10833: l_residual_code_tab2 l_residual_code_type;

10829: l_date_delivery_expected_tab2 l_date_delivery_expected_type;
10830: l_oec_tab2 l_oec_type;
10831: l_capital_amount_tab2 l_capital_amount_type;
10832: l_residual_grnty_amount_tab2 l_residual_grnty_amount_type;
10833: l_residual_code_tab2 l_residual_code_type;
10834: l_rvi_premium_tab2 l_rvi_premium_type;
10835: l_credit_nature_tab2 l_credit_nature_type;
10836: l_capitalized_interest_tab2 l_capitalized_interest_type;
10837: l_capital_reduction_perce_tab2 l_capital_reduction_perce_type;

Line 10887: l_title_date_tab2, l_date_residual_last_revi_tab2, l_date_last_reamortisatio_tab2,

10883: LOOP
10884: FETCH c8 bulk collect INTO
10885: l_id_tab2, l_kle_id_tab2, l_sty_id_tab2,
10886: l_object_version_number_tab2, l_lao_amount_tab2, l_fee_charge_tab2,
10887: l_title_date_tab2, l_date_residual_last_revi_tab2, l_date_last_reamortisatio_tab2,
10888: l_termination_purchase_am_tab2, l_date_last_cleanup_tab2, l_remarketed_amount_tab2,
10889: l_date_remarketed_tab2, l_remarket_margin_tab2, l_repurchased_amount_tab2,
10890: l_date_repurchased_tab2, l_gain_loss_tab2, l_floor_amount_tab2,
10891: l_previous_contract_tab2, l_tracked_residual_tab2, l_date_title_received_tab2,

Line 10891: l_previous_contract_tab2, l_tracked_residual_tab2, l_date_title_received_tab2,

10887: l_title_date_tab2, l_date_residual_last_revi_tab2, l_date_last_reamortisatio_tab2,
10888: l_termination_purchase_am_tab2, l_date_last_cleanup_tab2, l_remarketed_amount_tab2,
10889: l_date_remarketed_tab2, l_remarket_margin_tab2, l_repurchased_amount_tab2,
10890: l_date_repurchased_tab2, l_gain_loss_tab2, l_floor_amount_tab2,
10891: l_previous_contract_tab2, l_tracked_residual_tab2, l_date_title_received_tab2,
10892: l_estimated_oec_tab2, l_residual_percentage_tab2, l_capital_reduction_tab2,
10893: l_vendor_advance_paid_tab2, l_tradein_amount_tab2, l_delivered_date_tab2,
10894: l_year_of_manufacture_tab2, l_initial_direct_cost_tab2, l_occupancy_tab2,
10895: l_date_last_inspection_tab2, l_date_next_inspection_du_tab2, l_weighted_average_life_tab2,

Line 10892: l_estimated_oec_tab2, l_residual_percentage_tab2, l_capital_reduction_tab2,

10888: l_termination_purchase_am_tab2, l_date_last_cleanup_tab2, l_remarketed_amount_tab2,
10889: l_date_remarketed_tab2, l_remarket_margin_tab2, l_repurchased_amount_tab2,
10890: l_date_repurchased_tab2, l_gain_loss_tab2, l_floor_amount_tab2,
10891: l_previous_contract_tab2, l_tracked_residual_tab2, l_date_title_received_tab2,
10892: l_estimated_oec_tab2, l_residual_percentage_tab2, l_capital_reduction_tab2,
10893: l_vendor_advance_paid_tab2, l_tradein_amount_tab2, l_delivered_date_tab2,
10894: l_year_of_manufacture_tab2, l_initial_direct_cost_tab2, l_occupancy_tab2,
10895: l_date_last_inspection_tab2, l_date_next_inspection_du_tab2, l_weighted_average_life_tab2,
10896: l_bond_equivalent_yield_tab2, l_refinance_amount_tab2, l_year_built_tab2,

Line 10899: l_appraisal_value_tab2, l_residual_value_tab2, l_percent_tab2,

10895: l_date_last_inspection_tab2, l_date_next_inspection_du_tab2, l_weighted_average_life_tab2,
10896: l_bond_equivalent_yield_tab2, l_refinance_amount_tab2, l_year_built_tab2,
10897: l_coverage_ratio_tab2, l_gross_square_footage_tab2, l_net_rentable_tab2,
10898: l_date_letter_acceptance_tab2, l_date_commitment_expirat_tab2, l_date_appraisal_tab2,
10899: l_appraisal_value_tab2, l_residual_value_tab2, l_percent_tab2,
10900: l_coverage_tab2, l_lrv_amount_tab2, l_amount_tab2,
10901: l_lrs_percent_tab2, l_evergreen_percent_tab2, l_percent_stake_tab2,
10902: l_amount_stake_tab2, l_date_sold_tab2, l_sty_id_for_tab2,
10903: l_attribute_category_tab2, l_attribute1_tab2, l_attribute2_tab2,

Line 10914: l_oec_tab2, l_capital_amount_tab2, l_residual_grnty_amount_tab2,

10910: l_nty_code_tab2, l_fcg_code_tab2, l_prc_code_tab2,
10911: l_re_lease_yn_tab2, l_prescribed_asset_yn_tab2, l_credit_tenant_yn_tab2,
10912: l_secured_deal_yn_tab2, l_clg_id_tab2, l_date_funding_tab2,
10913: l_date_funding_required_tab2, l_date_accepted_tab2, l_date_delivery_expected_tab2,
10914: l_oec_tab2, l_capital_amount_tab2, l_residual_grnty_amount_tab2,
10915: l_residual_code_tab2, l_rvi_premium_tab2, l_credit_nature_tab2,
10916: l_capitalized_interest_tab2, l_capital_reduction_perce_tab2, l_date_pay_investor_start_tab2,
10917: l_pay_investor_frequency_tab2, l_pay_investor_event_tab2, l_pay_investor_remit_days_tab2,
10918: l_fee_type_tab2, l_subsidy_id_tab2, l_subsidy_override_amount_tab2,

Line 10915: l_residual_code_tab2, l_rvi_premium_tab2, l_credit_nature_tab2,

10911: l_re_lease_yn_tab2, l_prescribed_asset_yn_tab2, l_credit_tenant_yn_tab2,
10912: l_secured_deal_yn_tab2, l_clg_id_tab2, l_date_funding_tab2,
10913: l_date_funding_required_tab2, l_date_accepted_tab2, l_date_delivery_expected_tab2,
10914: l_oec_tab2, l_capital_amount_tab2, l_residual_grnty_amount_tab2,
10915: l_residual_code_tab2, l_rvi_premium_tab2, l_credit_nature_tab2,
10916: l_capitalized_interest_tab2, l_capital_reduction_perce_tab2, l_date_pay_investor_start_tab2,
10917: l_pay_investor_frequency_tab2, l_pay_investor_event_tab2, l_pay_investor_remit_days_tab2,
10918: l_fee_type_tab2, l_subsidy_id_tab2, l_subsidy_override_amount_tab2,
10919: l_pre_tax_yield_tab2, l_after_tax_yield_tab2, l_implicit_interest_rate_tab2,

Line 10968: l_date_residual_last_revi_tab(l_okl_k_lines_counter) := l_date_residual_last_revi_tab2(i);

10964: l_object_version_number_tab(l_okl_k_lines_counter) := l_object_version_number_tab2(i);
10965: l_lao_amount_tab(l_okl_k_lines_counter) := l_lao_amount_tab2(i);
10966: l_fee_charge_tab(l_okl_k_lines_counter) := l_fee_charge_tab2(i);
10967: l_title_date_tab(l_okl_k_lines_counter) := l_title_date_tab2(i);
10968: l_date_residual_last_revi_tab(l_okl_k_lines_counter) := l_date_residual_last_revi_tab2(i);
10969: l_date_last_reamortisatio_tab(l_okl_k_lines_counter) := l_date_last_reamortisatio_tab2(i);
10970: l_termination_purchase_am_tab(l_okl_k_lines_counter) := l_termination_purchase_am_tab2(i);
10971: l_date_last_cleanup_tab(l_okl_k_lines_counter) := l_date_last_cleanup_tab2(i);
10972: l_remarketed_amount_tab(l_okl_k_lines_counter) := l_remarketed_amount_tab2(i);

Line 10980: l_tracked_residual_tab(l_okl_k_lines_counter) := l_tracked_residual_tab2(i);

10976: l_date_repurchased_tab(l_okl_k_lines_counter) := l_date_repurchased_tab2(i);
10977: l_gain_loss_tab(l_okl_k_lines_counter) := l_gain_loss_tab2(i);
10978: l_floor_amount_tab(l_okl_k_lines_counter) := l_floor_amount_tab2(i);
10979: l_previous_contract_tab(l_okl_k_lines_counter) := l_previous_contract_tab2(i);
10980: l_tracked_residual_tab(l_okl_k_lines_counter) := l_tracked_residual_tab2(i);
10981: l_date_title_received_tab(l_okl_k_lines_counter) := l_date_title_received_tab2(i);
10982: l_estimated_oec_tab(l_okl_k_lines_counter) := l_estimated_oec_tab2(i);
10983: l_residual_percentage_tab(l_okl_k_lines_counter) := l_residual_percentage_tab2(i);
10984: l_capital_reduction_tab(l_okl_k_lines_counter) := l_capital_reduction_tab2(i);

Line 10983: l_residual_percentage_tab(l_okl_k_lines_counter) := l_residual_percentage_tab2(i);

10979: l_previous_contract_tab(l_okl_k_lines_counter) := l_previous_contract_tab2(i);
10980: l_tracked_residual_tab(l_okl_k_lines_counter) := l_tracked_residual_tab2(i);
10981: l_date_title_received_tab(l_okl_k_lines_counter) := l_date_title_received_tab2(i);
10982: l_estimated_oec_tab(l_okl_k_lines_counter) := l_estimated_oec_tab2(i);
10983: l_residual_percentage_tab(l_okl_k_lines_counter) := l_residual_percentage_tab2(i);
10984: l_capital_reduction_tab(l_okl_k_lines_counter) := l_capital_reduction_tab2(i);
10985: l_vendor_advance_paid_tab(l_okl_k_lines_counter) := l_vendor_advance_paid_tab2(i);
10986: l_tradein_amount_tab(l_okl_k_lines_counter) := l_tradein_amount_tab2(i);
10987: l_delivered_date_tab(l_okl_k_lines_counter) := l_delivered_date_tab2(i);

Line 11004: l_residual_value_tab(l_okl_k_lines_counter) := l_residual_value_tab2(i);

11000: l_date_letter_acceptance_tab(l_okl_k_lines_counter) := l_date_letter_acceptance_tab2(i);
11001: l_date_commitment_expirat_tab(l_okl_k_lines_counter) := l_date_commitment_expirat_tab2(i);
11002: l_date_appraisal_tab(l_okl_k_lines_counter) := l_date_appraisal_tab2(i);
11003: l_appraisal_value_tab(l_okl_k_lines_counter) := l_appraisal_value_tab2(i);
11004: l_residual_value_tab(l_okl_k_lines_counter) := l_residual_value_tab2(i);
11005: l_percent_tab(l_okl_k_lines_counter) := l_percent_tab2(i);
11006: l_coverage_tab(l_okl_k_lines_counter) := l_coverage_tab2(i);
11007: l_lrv_amount_tab(l_okl_k_lines_counter) := l_lrv_amount_tab2(i);
11008: l_amount_tab(l_okl_k_lines_counter) := l_amount_tab2(i);

Line 11050: l_residual_grnty_amount_tab(l_okl_k_lines_counter) := l_residual_grnty_amount_tab2(i);

11046: l_date_accepted_tab(l_okl_k_lines_counter) := l_date_accepted_tab2(i);
11047: l_date_delivery_expected_tab(l_okl_k_lines_counter) := l_date_delivery_expected_tab2(i);
11048: l_oec_tab(l_okl_k_lines_counter) := l_oec_tab2(i);
11049: l_capital_amount_tab(l_okl_k_lines_counter) := l_capital_amount_tab2(i);
11050: l_residual_grnty_amount_tab(l_okl_k_lines_counter) := l_residual_grnty_amount_tab2(i);
11051: l_residual_code_tab(l_okl_k_lines_counter) := l_residual_code_tab2(i);
11052: l_rvi_premium_tab(l_okl_k_lines_counter) := l_rvi_premium_tab2(i);
11053: l_credit_nature_tab(l_okl_k_lines_counter) := l_credit_nature_tab2(i);
11054: l_capitalized_interest_tab(l_okl_k_lines_counter) := l_capitalized_interest_tab2(i);

Line 11051: l_residual_code_tab(l_okl_k_lines_counter) := l_residual_code_tab2(i);

11047: l_date_delivery_expected_tab(l_okl_k_lines_counter) := l_date_delivery_expected_tab2(i);
11048: l_oec_tab(l_okl_k_lines_counter) := l_oec_tab2(i);
11049: l_capital_amount_tab(l_okl_k_lines_counter) := l_capital_amount_tab2(i);
11050: l_residual_grnty_amount_tab(l_okl_k_lines_counter) := l_residual_grnty_amount_tab2(i);
11051: l_residual_code_tab(l_okl_k_lines_counter) := l_residual_code_tab2(i);
11052: l_rvi_premium_tab(l_okl_k_lines_counter) := l_rvi_premium_tab2(i);
11053: l_credit_nature_tab(l_okl_k_lines_counter) := l_credit_nature_tab2(i);
11054: l_capitalized_interest_tab(l_okl_k_lines_counter) := l_capitalized_interest_tab2(i);
11055: l_capital_reduction_perce_tab(l_okl_k_lines_counter) := l_capital_reduction_perce_tab2(i);

Line 11142: title_date, date_residual_last_review, date_last_reamortisation,

11138: forall i IN l_id_tab.first..l_id_tab.last
11139: INSERT INTO okl_k_lines (
11140: id, kle_id, sty_id,
11141: object_version_number, lao_amount, fee_charge,
11142: title_date, date_residual_last_review, date_last_reamortisation,
11143: termination_purchase_amount, date_last_cleanup, remarketed_amount,
11144: date_remarketed, remarket_margin, repurchased_amount,
11145: date_repurchased, gain_loss, floor_amount,
11146: previous_contract, tracked_residual, date_title_received,

Line 11146: previous_contract, tracked_residual, date_title_received,

11142: title_date, date_residual_last_review, date_last_reamortisation,
11143: termination_purchase_amount, date_last_cleanup, remarketed_amount,
11144: date_remarketed, remarket_margin, repurchased_amount,
11145: date_repurchased, gain_loss, floor_amount,
11146: previous_contract, tracked_residual, date_title_received,
11147: estimated_oec, residual_percentage, capital_reduction,
11148: vendor_advance_paid, tradein_amount, delivered_date,
11149: year_of_manufacture, initial_direct_cost, occupancy,
11150: date_last_inspection, date_next_inspection_due, weighted_average_life,

Line 11147: estimated_oec, residual_percentage, capital_reduction,

11143: termination_purchase_amount, date_last_cleanup, remarketed_amount,
11144: date_remarketed, remarket_margin, repurchased_amount,
11145: date_repurchased, gain_loss, floor_amount,
11146: previous_contract, tracked_residual, date_title_received,
11147: estimated_oec, residual_percentage, capital_reduction,
11148: vendor_advance_paid, tradein_amount, delivered_date,
11149: year_of_manufacture, initial_direct_cost, occupancy,
11150: date_last_inspection, date_next_inspection_due, weighted_average_life,
11151: bond_equivalent_yield, refinance_amount, year_built,

Line 11154: appraisal_value, residual_value, percent,

11150: date_last_inspection, date_next_inspection_due, weighted_average_life,
11151: bond_equivalent_yield, refinance_amount, year_built,
11152: coverage_ratio, gross_square_footage, net_rentable,
11153: date_letter_acceptance, date_commitment_expiration, date_appraisal,
11154: appraisal_value, residual_value, percent,
11155: coverage, lrv_amount, amount,
11156: lrs_percent, evergreen_percent, percent_stake,
11157: amount_stake, date_sold, sty_id_for,
11158: attribute_category, attribute1, attribute2,

Line 11169: oec, capital_amount, residual_grnty_amount,

11165: nty_code, fcg_code, prc_code,
11166: re_lease_yn, prescribed_asset_yn, credit_tenant_yn,
11167: secured_deal_yn, clg_id, date_funding,
11168: date_funding_required, date_accepted, date_delivery_expected,
11169: oec, capital_amount, residual_grnty_amount,
11170: residual_code, rvi_premium, credit_nature,
11171: capitalized_interest, capital_reduction_percent,date_pay_investor_start,
11172: pay_investor_frequency, pay_investor_event,pay_investor_remittance_days,
11173: fee_type, subsidy_id, subsidy_override_amount,

Line 11170: residual_code, rvi_premium, credit_nature,

11166: re_lease_yn, prescribed_asset_yn, credit_tenant_yn,
11167: secured_deal_yn, clg_id, date_funding,
11168: date_funding_required, date_accepted, date_delivery_expected,
11169: oec, capital_amount, residual_grnty_amount,
11170: residual_code, rvi_premium, credit_nature,
11171: capitalized_interest, capital_reduction_percent,date_pay_investor_start,
11172: pay_investor_frequency, pay_investor_event,pay_investor_remittance_days,
11173: fee_type, subsidy_id, subsidy_override_amount,
11174: pre_tax_yield, after_tax_yield, implicit_interest_rate,

Line 11185: l_title_date_tab(i), l_date_residual_last_revi_tab(i), l_date_last_reamortisatio_tab(i),

11181: capitalize_down_payment_yn
11182: ) VALUES (
11183: l_id_tab(i), l_kle_id_tab(i), l_sty_id_tab(i),
11184: l_object_version_number_tab(i), l_lao_amount_tab(i), l_fee_charge_tab(i),
11185: l_title_date_tab(i), l_date_residual_last_revi_tab(i), l_date_last_reamortisatio_tab(i),
11186: l_termination_purchase_am_tab(i), l_date_last_cleanup_tab(i), l_remarketed_amount_tab(i),
11187: l_date_remarketed_tab(i), l_remarket_margin_tab(i), l_repurchased_amount_tab(i),
11188: l_date_repurchased_tab(i), l_gain_loss_tab(i), l_floor_amount_tab(i),
11189: l_previous_contract_tab(i), l_tracked_residual_tab(i), l_date_title_received_tab(i),

Line 11189: l_previous_contract_tab(i), l_tracked_residual_tab(i), l_date_title_received_tab(i),

11185: l_title_date_tab(i), l_date_residual_last_revi_tab(i), l_date_last_reamortisatio_tab(i),
11186: l_termination_purchase_am_tab(i), l_date_last_cleanup_tab(i), l_remarketed_amount_tab(i),
11187: l_date_remarketed_tab(i), l_remarket_margin_tab(i), l_repurchased_amount_tab(i),
11188: l_date_repurchased_tab(i), l_gain_loss_tab(i), l_floor_amount_tab(i),
11189: l_previous_contract_tab(i), l_tracked_residual_tab(i), l_date_title_received_tab(i),
11190: l_estimated_oec_tab(i), l_residual_percentage_tab(i), l_capital_reduction_tab(i),
11191: l_vendor_advance_paid_tab(i), l_tradein_amount_tab(i), l_delivered_date_tab(i),
11192: l_year_of_manufacture_tab(i), l_initial_direct_cost_tab(i), l_occupancy_tab(i),
11193: l_date_last_inspection_tab(i), l_date_next_inspection_du_tab(i), l_weighted_average_life_tab(i),

Line 11190: l_estimated_oec_tab(i), l_residual_percentage_tab(i), l_capital_reduction_tab(i),

11186: l_termination_purchase_am_tab(i), l_date_last_cleanup_tab(i), l_remarketed_amount_tab(i),
11187: l_date_remarketed_tab(i), l_remarket_margin_tab(i), l_repurchased_amount_tab(i),
11188: l_date_repurchased_tab(i), l_gain_loss_tab(i), l_floor_amount_tab(i),
11189: l_previous_contract_tab(i), l_tracked_residual_tab(i), l_date_title_received_tab(i),
11190: l_estimated_oec_tab(i), l_residual_percentage_tab(i), l_capital_reduction_tab(i),
11191: l_vendor_advance_paid_tab(i), l_tradein_amount_tab(i), l_delivered_date_tab(i),
11192: l_year_of_manufacture_tab(i), l_initial_direct_cost_tab(i), l_occupancy_tab(i),
11193: l_date_last_inspection_tab(i), l_date_next_inspection_du_tab(i), l_weighted_average_life_tab(i),
11194: l_bond_equivalent_yield_tab(i), l_refinance_amount_tab(i), l_year_built_tab(i),

Line 11197: l_appraisal_value_tab(i), l_residual_value_tab(i), l_percent_tab(i),

11193: l_date_last_inspection_tab(i), l_date_next_inspection_du_tab(i), l_weighted_average_life_tab(i),
11194: l_bond_equivalent_yield_tab(i), l_refinance_amount_tab(i), l_year_built_tab(i),
11195: l_coverage_ratio_tab(i), l_gross_square_footage_tab(i), l_net_rentable_tab(i),
11196: l_date_letter_acceptance_tab(i), l_date_commitment_expirat_tab(i), l_date_appraisal_tab(i),
11197: l_appraisal_value_tab(i), l_residual_value_tab(i), l_percent_tab(i),
11198: l_coverage_tab(i), l_lrv_amount_tab(i), l_amount_tab(i),
11199: l_lrs_percent_tab(i), l_evergreen_percent_tab(i), l_percent_stake_tab(i),
11200: l_amount_stake_tab(i), l_date_sold_tab(i), l_sty_id_for_tab(i),
11201: l_attribute_category_tab(i), l_attribute1_tab(i), l_attribute2_tab(i),

Line 11212: l_oec_tab(i), l_capital_amount_tab(i), l_residual_grnty_amount_tab(i),

11208: l_nty_code_tab(i), l_fcg_code_tab(i), l_prc_code_tab(i),
11209: l_re_lease_yn_tab(i), l_prescribed_asset_yn_tab(i), l_credit_tenant_yn_tab(i),
11210: l_secured_deal_yn_tab(i), l_clg_id_tab(i), l_date_funding_tab(i),
11211: l_date_funding_required_tab(i), l_date_accepted_tab(i), l_date_delivery_expected_tab(i),
11212: l_oec_tab(i), l_capital_amount_tab(i), l_residual_grnty_amount_tab(i),
11213: l_residual_code_tab(i), l_rvi_premium_tab(i), l_credit_nature_tab(i),
11214: l_capitalized_interest_tab(i), l_capital_reduction_perce_tab(i), l_date_pay_investor_start_tab(i),
11215: l_pay_investor_frequency_tab(i), l_pay_investor_event_tab(i), l_pay_investor_remit_days_tab(i),
11216: l_fee_type_tab(i), l_subsidy_id_tab(i), l_subsidy_override_amount_tab(i),

Line 11213: l_residual_code_tab(i), l_rvi_premium_tab(i), l_credit_nature_tab(i),

11209: l_re_lease_yn_tab(i), l_prescribed_asset_yn_tab(i), l_credit_tenant_yn_tab(i),
11210: l_secured_deal_yn_tab(i), l_clg_id_tab(i), l_date_funding_tab(i),
11211: l_date_funding_required_tab(i), l_date_accepted_tab(i), l_date_delivery_expected_tab(i),
11212: l_oec_tab(i), l_capital_amount_tab(i), l_residual_grnty_amount_tab(i),
11213: l_residual_code_tab(i), l_rvi_premium_tab(i), l_credit_nature_tab(i),
11214: l_capitalized_interest_tab(i), l_capital_reduction_perce_tab(i), l_date_pay_investor_start_tab(i),
11215: l_pay_investor_frequency_tab(i), l_pay_investor_event_tab(i), l_pay_investor_remit_days_tab(i),
11216: l_fee_type_tab(i), l_subsidy_id_tab(i), l_subsidy_override_amount_tab(i),
11217: l_pre_tax_yield_tab(i), l_after_tax_yield_tab(i), l_implicit_interest_rate_tab(i),

Line 11251: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_residual_last_revi_tab('||i||')=' || l_date_residual_last_revi_tab(i));

11247: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_object_version_number_tab('||i||')=' || l_object_version_number_tab(i));
11248: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_lao_amount_tab('||i||')=' || l_lao_amount_tab(i));
11249: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_fee_charge_tab('||i||')=' || l_fee_charge_tab(i));
11250: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_title_date_tab('||i||')=' || l_title_date_tab(i));
11251: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_residual_last_revi_tab('||i||')=' || l_date_residual_last_revi_tab(i));
11252: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_last_reamortisatio_tab('||i||')=' || l_date_last_reamortisatio_tab(i));
11253: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_termination_purchase_am_tab('||i||')=' || l_termination_purchase_am_tab(i));
11254: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_last_cleanup_tab('||i||')=' || l_date_last_cleanup_tab(i));
11255: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_remarketed_amount_tab('||i||')=' || l_remarketed_amount_tab(i));

Line 11263: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tracked_residual_tab('||i||')=' || l_tracked_residual_tab(i));

11259: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_repurchased_tab('||i||')=' || l_date_repurchased_tab(i));
11260: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_gain_loss_tab('||i||')=' || l_gain_loss_tab(i));
11261: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_floor_amount_tab('||i||')=' || l_floor_amount_tab(i));
11262: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_previous_contract_tab('||i||')=' || l_previous_contract_tab(i));
11263: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tracked_residual_tab('||i||')=' || l_tracked_residual_tab(i));
11264: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_title_received_tab('||i||')=' || l_date_title_received_tab(i));
11265: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_estimated_oec_tab('||i||')=' || l_estimated_oec_tab(i));
11266: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_residual_percentage_tab('||i||')=' || l_residual_percentage_tab(i));
11267: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_capital_reduction_tab('||i||')=' || l_capital_reduction_tab(i));

Line 11266: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_residual_percentage_tab('||i||')=' || l_residual_percentage_tab(i));

11262: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_previous_contract_tab('||i||')=' || l_previous_contract_tab(i));
11263: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tracked_residual_tab('||i||')=' || l_tracked_residual_tab(i));
11264: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_title_received_tab('||i||')=' || l_date_title_received_tab(i));
11265: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_estimated_oec_tab('||i||')=' || l_estimated_oec_tab(i));
11266: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_residual_percentage_tab('||i||')=' || l_residual_percentage_tab(i));
11267: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_capital_reduction_tab('||i||')=' || l_capital_reduction_tab(i));
11268: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_vendor_advance_paid_tab('||i||')=' || l_vendor_advance_paid_tab(i));
11269: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tradein_amount_tab('||i||')=' || l_tradein_amount_tab(i));
11270: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_delivered_date_tab('||i||')=' || l_delivered_date_tab(i));

Line 11287: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_residual_value_tab('||i||')=' || l_residual_value_tab(i));

11283: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_letter_acceptance_tab('||i||')=' || l_date_letter_acceptance_tab(i));
11284: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_commitment_expirat_tab('||i||')=' || l_date_commitment_expirat_tab(i));
11285: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_appraisal_tab('||i||')=' || l_date_appraisal_tab(i));
11286: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_appraisal_value_tab('||i||')=' || l_appraisal_value_tab(i));
11287: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_residual_value_tab('||i||')=' || l_residual_value_tab(i));
11288: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_percent_tab('||i||')=' || l_percent_tab(i));
11289: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_coverage_tab('||i||')=' || l_coverage_tab(i));
11290: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_lrv_amount_tab('||i||')=' || l_lrv_amount_tab(i));
11291: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_amount_tab('||i||')=' || l_amount_tab(i));

Line 11333: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_residual_grnty_amount_tab('||i||')=' || l_residual_grnty_amount_tab(i));

11329: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_accepted_tab('||i||')=' || l_date_accepted_tab(i));
11330: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_delivery_expected_tab('||i||')=' || l_date_delivery_expected_tab(i));
11331: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_oec_tab('||i||')=' || l_oec_tab(i));
11332: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_capital_amount_tab('||i||')=' || l_capital_amount_tab(i));
11333: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_residual_grnty_amount_tab('||i||')=' || l_residual_grnty_amount_tab(i));
11334: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_residual_code_tab('||i||')=' || l_residual_code_tab(i));
11335: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rvi_premium_tab('||i||')=' || l_rvi_premium_tab(i));
11336: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_credit_nature_tab('||i||')=' || l_credit_nature_tab(i));
11337: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_capitalized_interest_tab('||i||')=' || l_capitalized_interest_tab(i));

Line 11334: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_residual_code_tab('||i||')=' || l_residual_code_tab(i));

11330: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_delivery_expected_tab('||i||')=' || l_date_delivery_expected_tab(i));
11331: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_oec_tab('||i||')=' || l_oec_tab(i));
11332: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_capital_amount_tab('||i||')=' || l_capital_amount_tab(i));
11333: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_residual_grnty_amount_tab('||i||')=' || l_residual_grnty_amount_tab(i));
11334: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_residual_code_tab('||i||')=' || l_residual_code_tab(i));
11335: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rvi_premium_tab('||i||')=' || l_rvi_premium_tab(i));
11336: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_credit_nature_tab('||i||')=' || l_credit_nature_tab(i));
11337: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_capitalized_interest_tab('||i||')=' || l_capitalized_interest_tab(i));
11338: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_capital_reduction_perce_tab('||i||')=' || l_capital_reduction_perce_tab(i));

Line 16449: a.new_residual_value, a.old_residual_value, a.units_retired,

16445: a.attribute12, a.attribute13, a.attribute14,
16446: a.attribute15, a.created_by, a.creation_date,
16447: a.last_updated_by, a.last_update_date, a.last_update_login,
16448: a.depreciate_yn, a.hold_period_days, a.old_salvage_value,
16449: a.new_residual_value, a.old_residual_value, a.units_retired,
16450: a.cost_retired, a.sale_proceeds, a.removal_cost,
16451: a.dnz_asset_id, a.date_due, a.rep_asset_id,
16452: a.lke_asset_id, a.match_amount, a.split_into_singles_flag,
16453: a.split_into_units, a.currency_code, a.currency_conversion_type,

Line 16525: l_tbnew_residual_value_tab2 l_tbnew_residual_value_type;

16521: l_tblast_update_login_tab2 l_tblast_update_login_type;
16522: l_tbdepreciate_yn_tab2 l_tbdepreciate_yn_type;
16523: l_tbhold_period_days_tab2 l_tbhold_period_days_type;
16524: l_tbold_salvage_value_tab2 l_tbold_salvage_value_type;
16525: l_tbnew_residual_value_tab2 l_tbnew_residual_value_type;
16526: l_tbold_residual_value_tab2 l_tbold_residual_value_type;
16527: l_tbunits_retired_tab2 l_tbunits_retired_type;
16528: l_tbcost_retired_tab2 l_tbcost_retired_type;
16529: l_tbsale_proceeds_tab2 l_tbsale_proceeds_type;

Line 16526: l_tbold_residual_value_tab2 l_tbold_residual_value_type;

16522: l_tbdepreciate_yn_tab2 l_tbdepreciate_yn_type;
16523: l_tbhold_period_days_tab2 l_tbhold_period_days_type;
16524: l_tbold_salvage_value_tab2 l_tbold_salvage_value_type;
16525: l_tbnew_residual_value_tab2 l_tbnew_residual_value_type;
16526: l_tbold_residual_value_tab2 l_tbold_residual_value_type;
16527: l_tbunits_retired_tab2 l_tbunits_retired_type;
16528: l_tbcost_retired_tab2 l_tbcost_retired_type;
16529: l_tbsale_proceeds_tab2 l_tbsale_proceeds_type;
16530: l_tbremoval_cost_tab2 l_tbremoval_cost_type;

Line 16575: l_tbnew_residual_value_tab2, l_tbold_residual_value_tab2, l_tbunits_retired_tab2,

16571: l_tbattribute12_tab2, l_tbattribute13_tab2, l_tbattribute14_tab2,
16572: l_tbattribute15_tab2, l_tbcreated_by_tab2, l_tbcreation_date_tab2,
16573: l_tblast_updated_by_tab2, l_tblast_update_date_tab2, l_tblast_update_login_tab2,
16574: l_tbdepreciate_yn_tab2, l_tbhold_period_days_tab2, l_tbold_salvage_value_tab2,
16575: l_tbnew_residual_value_tab2, l_tbold_residual_value_tab2, l_tbunits_retired_tab2,
16576: l_tbcost_retired_tab2, l_tbsale_proceeds_tab2, l_tbremoval_cost_tab2,
16577: l_tbdnz_asset_id_tab2, l_tbdate_due_tab2, l_tbrep_asset_id_tab2,
16578: l_tblke_asset_id_tab2, l_tbmatch_amount_tab2, l_tbsplit_into_singles_fl_tab2,
16579: l_tbsplit_into_units_tab2, l_tbcurrency_code_tab2, l_tbcurrency_convers_type_tab2,

Line 16688: l_tbnew_residual_value_tab(l_txl_assets_b_counter) := l_tbnew_residual_value_tab2(i);

16684: l_tblast_update_login_tab(l_txl_assets_b_counter) := l_tblast_update_login_tab2(i);
16685: l_tbdepreciate_yn_tab(l_txl_assets_b_counter) := l_tbdepreciate_yn_tab2(i);
16686: l_tbhold_period_days_tab(l_txl_assets_b_counter) := l_tbhold_period_days_tab2(i);
16687: l_tbold_salvage_value_tab(l_txl_assets_b_counter) := l_tbold_salvage_value_tab2(i);
16688: l_tbnew_residual_value_tab(l_txl_assets_b_counter) := l_tbnew_residual_value_tab2(i);
16689: l_tbold_residual_value_tab(l_txl_assets_b_counter) := l_tbold_residual_value_tab2(i);
16690: l_tbunits_retired_tab(l_txl_assets_b_counter) := l_tbunits_retired_tab2(i);
16691: l_tbcost_retired_tab(l_txl_assets_b_counter) := l_tbcost_retired_tab2(i);
16692: l_tbsale_proceeds_tab(l_txl_assets_b_counter) := l_tbsale_proceeds_tab2(i);

Line 16689: l_tbold_residual_value_tab(l_txl_assets_b_counter) := l_tbold_residual_value_tab2(i);

16685: l_tbdepreciate_yn_tab(l_txl_assets_b_counter) := l_tbdepreciate_yn_tab2(i);
16686: l_tbhold_period_days_tab(l_txl_assets_b_counter) := l_tbhold_period_days_tab2(i);
16687: l_tbold_salvage_value_tab(l_txl_assets_b_counter) := l_tbold_salvage_value_tab2(i);
16688: l_tbnew_residual_value_tab(l_txl_assets_b_counter) := l_tbnew_residual_value_tab2(i);
16689: l_tbold_residual_value_tab(l_txl_assets_b_counter) := l_tbold_residual_value_tab2(i);
16690: l_tbunits_retired_tab(l_txl_assets_b_counter) := l_tbunits_retired_tab2(i);
16691: l_tbcost_retired_tab(l_txl_assets_b_counter) := l_tbcost_retired_tab2(i);
16692: l_tbsale_proceeds_tab(l_txl_assets_b_counter) := l_tbsale_proceeds_tab2(i);
16693: l_tbremoval_cost_tab(l_txl_assets_b_counter) := l_tbremoval_cost_tab2(i);

Line 16745: new_residual_value, old_residual_value, units_retired,

16741: attribute12, attribute13, attribute14,
16742: attribute15, created_by, creation_date,
16743: last_updated_by, last_update_date, last_update_login,
16744: depreciate_yn, hold_period_days, old_salvage_value,
16745: new_residual_value, old_residual_value, units_retired,
16746: cost_retired, sale_proceeds, removal_cost,
16747: dnz_asset_id, date_due, rep_asset_id,
16748: lke_asset_id, match_amount, split_into_singles_flag,
16749: split_into_units, currency_code, currency_conversion_type,

Line 16772: l_tbnew_residual_value_tab(i), l_tbold_residual_value_tab(i), l_tbunits_retired_tab(i),

16768: l_tbattribute12_tab(i), l_tbattribute13_tab(i), l_tbattribute14_tab(i),
16769: l_tbattribute15_tab(i), l_created_by, SYSDATE,
16770: l_last_updated_by, SYSDATE, l_last_update_login,
16771: l_tbdepreciate_yn_tab(i), l_tbhold_period_days_tab(i), l_tbold_salvage_value_tab(i),
16772: l_tbnew_residual_value_tab(i), l_tbold_residual_value_tab(i), l_tbunits_retired_tab(i),
16773: l_tbcost_retired_tab(i), l_tbsale_proceeds_tab(i), l_tbremoval_cost_tab(i),
16774: l_tbdnz_asset_id_tab(i), l_tbdate_due_tab(i), l_tbrep_asset_id_tab(i),
16775: l_tblke_asset_id_tab(i), l_tbmatch_amount_tab(i), l_tbsplit_into_singles_fl_tab(i),
16776: l_tbsplit_into_units_tab(i), l_tbcurrency_code_tab(i), l_tbcurrency_convers_type_tab(i),

Line 16870: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbnew_residual_value_tab('||i||')=' || l_tbnew_residual_value_tab(i));

16866: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbattribute15_tab('||i||')=' || l_tbattribute15_tab(i));
16867: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbdepreciate_yn_tab('||i||')=' || l_tbdepreciate_yn_tab(i));
16868: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbhold_period_days_tab('||i||')=' || l_tbhold_period_days_tab(i));
16869: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbold_salvage_value_tab('||i||')=' || l_tbold_salvage_value_tab(i));
16870: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbnew_residual_value_tab('||i||')=' || l_tbnew_residual_value_tab(i));
16871: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbold_residual_value_tab('||i||')=' || l_tbold_residual_value_tab(i));
16872: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbunits_retired_tab('||i||')=' || l_tbunits_retired_tab(i));
16873: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbcost_retired_tab('||i||')=' || l_tbcost_retired_tab(i));
16874: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbsale_proceeds_tab('||i||')=' || l_tbsale_proceeds_tab(i));

Line 16871: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbold_residual_value_tab('||i||')=' || l_tbold_residual_value_tab(i));

16867: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbdepreciate_yn_tab('||i||')=' || l_tbdepreciate_yn_tab(i));
16868: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbhold_period_days_tab('||i||')=' || l_tbhold_period_days_tab(i));
16869: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbold_salvage_value_tab('||i||')=' || l_tbold_salvage_value_tab(i));
16870: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbnew_residual_value_tab('||i||')=' || l_tbnew_residual_value_tab(i));
16871: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbold_residual_value_tab('||i||')=' || l_tbold_residual_value_tab(i));
16872: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbunits_retired_tab('||i||')=' || l_tbunits_retired_tab(i));
16873: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbcost_retired_tab('||i||')=' || l_tbcost_retired_tab(i));
16874: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbsale_proceeds_tab('||i||')=' || l_tbsale_proceeds_tab(i));
16875: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbremoval_cost_tab('||i||')=' || l_tbremoval_cost_tab(i));

Line 17350: FROM dual;

17346: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
17347: -- cursor to get sequence number for asset number
17348: CURSOR c_instance_no_ib IS
17349: SELECT TO_CHAR(OKL_IBN_SEQ.NEXTVAL)
17350: FROM dual;
17351: BEGIN
17352: OPEN c_instance_no_ib;
17353: FETCH c_instance_no_ib INTO x_instance_number_ib;
17354: IF (c_instance_no_ib%NOTFOUND) THEN

Line 20495: SELECT okc_k_headers_b_s.NEXTVAL INTO l_copied_id FROM dual;

20491: l_sts_code_orig := c1rec.sts_code;
20492:
20493: l_curr_pos := 'okl_copy_lease_contract:4';
20494: -- kmotepal populating contract id from sys guid instead of using OKC sequence which fixes the bug 4436545 (Reverted back for OKL.H)
20495: SELECT okc_k_headers_b_s.NEXTVAL INTO l_copied_id FROM dual;
20496: --l_copied_id := okc_p_util.raw_to_number(sys_guid());
20497:
20498: l_contract_currency := c1rec.currency_code;
20499: l_contract_start_date := c1rec.start_date;