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 784: RESIDUAL_PERCENTAGE,

780: EVERGREEN_PERCENT,
781: AMOUNT_STAKE,
782: OCCUPANCY,
783: COVERAGE,
784: RESIDUAL_PERCENTAGE,
785: DATE_LAST_INSPECTION,
786: DATE_SOLD,
787: LRV_AMOUNT,
788: CAPITAL_REDUCTION,

Line 790: DATE_RESIDUAL_LAST_REVIEW,

786: DATE_SOLD,
787: LRV_AMOUNT,
788: CAPITAL_REDUCTION,
789: DATE_NEXT_INSPECTION_DUE,
790: DATE_RESIDUAL_LAST_REVIEW,
791: DATE_LAST_REAMORTISATION,
792: VENDOR_ADVANCE_PAID,
793: WEIGHTED_AVERAGE_LIFE,
794: TRADEIN_AMOUNT,

Line 815: RESIDUAL_VALUE,

811: REPURCHASED_AMOUNT,
812: DATE_COMMITMENT_EXPIRATION,
813: DATE_REPURCHASED,
814: DATE_APPRAISAL,
815: RESIDUAL_VALUE,
816: APPRAISAL_VALUE,
817: SECURED_DEAL_YN,
818: GAIN_LOSS,
819: FLOOR_AMOUNT,

Line 822: TRACKED_RESIDUAL,

818: GAIN_LOSS,
819: FLOOR_AMOUNT,
820: RE_LEASE_YN,
821: PREVIOUS_CONTRACT,
822: TRACKED_RESIDUAL,
823: DATE_TITLE_RECEIVED,
824: AMOUNT,
825: ATTRIBUTE_CATEGORY,
826: ATTRIBUTE1,

Line 854: RESIDUAL_GRNTY_AMOUNT,

850: DATE_ACCEPTED,
851: DATE_DELIVERY_EXPECTED,
852: OEC,
853: CAPITAL_AMOUNT,
854: RESIDUAL_GRNTY_AMOUNT,
855: RESIDUAL_CODE,
856: RVI_PREMIUM,
857: CREDIT_NATURE,
858: CAPITALIZED_INTEREST,

Line 855: RESIDUAL_CODE,

851: DATE_DELIVERY_EXPECTED,
852: OEC,
853: CAPITAL_AMOUNT,
854: RESIDUAL_GRNTY_AMOUNT,
855: RESIDUAL_CODE,
856: RVI_PREMIUM,
857: CREDIT_NATURE,
858: CAPITALIZED_INTEREST,
859: CAPITAL_REDUCTION_PERCENT,

Line 930: l_klev_rec.RESIDUAL_PERCENTAGE,

926: l_klev_rec.EVERGREEN_PERCENT,
927: l_klev_rec.AMOUNT_STAKE,
928: l_klev_rec.OCCUPANCY,
929: l_klev_rec.COVERAGE,
930: l_klev_rec.RESIDUAL_PERCENTAGE,
931: l_klev_rec.DATE_LAST_INSPECTION,
932: l_klev_rec.DATE_SOLD,
933: l_klev_rec.LRV_AMOUNT,
934: l_klev_rec.CAPITAL_REDUCTION,

Line 936: l_klev_rec.DATE_RESIDUAL_LAST_REVIEW,

932: l_klev_rec.DATE_SOLD,
933: l_klev_rec.LRV_AMOUNT,
934: l_klev_rec.CAPITAL_REDUCTION,
935: l_klev_rec.DATE_NEXT_INSPECTION_DUE,
936: l_klev_rec.DATE_RESIDUAL_LAST_REVIEW,
937: l_klev_rec.DATE_LAST_REAMORTISATION,
938: l_klev_rec.VENDOR_ADVANCE_PAID,
939: l_klev_rec.WEIGHTED_AVERAGE_LIFE,
940: l_klev_rec.TRADEIN_AMOUNT,

Line 961: l_klev_rec.RESIDUAL_VALUE,

957: l_klev_rec.REPURCHASED_AMOUNT,
958: l_klev_rec.DATE_COMMITMENT_EXPIRATION,
959: l_klev_rec.DATE_REPURCHASED,
960: l_klev_rec.DATE_APPRAISAL,
961: l_klev_rec.RESIDUAL_VALUE,
962: l_klev_rec.APPRAISAL_VALUE,
963: l_klev_rec.SECURED_DEAL_YN,
964: l_klev_rec.GAIN_LOSS,
965: l_klev_rec.FLOOR_AMOUNT,

Line 968: l_klev_rec.TRACKED_RESIDUAL,

964: l_klev_rec.GAIN_LOSS,
965: l_klev_rec.FLOOR_AMOUNT,
966: l_klev_rec.RE_LEASE_YN,
967: l_klev_rec.PREVIOUS_CONTRACT,
968: l_klev_rec.TRACKED_RESIDUAL,
969: l_klev_rec.DATE_TITLE_RECEIVED,
970: l_klev_rec.AMOUNT,
971: l_klev_rec.ATTRIBUTE_CATEGORY,
972: l_klev_rec.ATTRIBUTE1,

Line 1000: l_klev_rec.RESIDUAL_GRNTY_AMOUNT,

996: l_klev_rec.DATE_ACCEPTED,
997: l_klev_rec.DATE_DELIVERY_EXPECTED,
998: l_klev_rec.OEC,
999: l_klev_rec.CAPITAL_AMOUNT,
1000: l_klev_rec.RESIDUAL_GRNTY_AMOUNT,
1001: l_klev_rec.RESIDUAL_CODE,
1002: l_klev_rec.RVI_PREMIUM,
1003: l_klev_rec.CREDIT_NATURE,
1004: l_klev_rec.CAPITALIZED_INTEREST,

Line 1001: l_klev_rec.RESIDUAL_CODE,

997: l_klev_rec.DATE_DELIVERY_EXPECTED,
998: l_klev_rec.OEC,
999: l_klev_rec.CAPITAL_AMOUNT,
1000: l_klev_rec.RESIDUAL_GRNTY_AMOUNT,
1001: l_klev_rec.RESIDUAL_CODE,
1002: l_klev_rec.RVI_PREMIUM,
1003: l_klev_rec.CREDIT_NATURE,
1004: l_klev_rec.CAPITALIZED_INTEREST,
1005: l_klev_rec.CAPITAL_REDUCTION_PERCENT,

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

5978: TYPE l_tblast_update_login_type IS TABLE OF okl_txl_assets_b.last_update_login%TYPE INDEX BY BINARY_INTEGER;
5979: TYPE l_tbdepreciate_yn_type IS TABLE OF okl_txl_assets_b.depreciate_yn%TYPE INDEX BY BINARY_INTEGER;
5980: TYPE l_tbhold_period_days_type IS TABLE OF okl_txl_assets_b.hold_period_days%TYPE INDEX BY BINARY_INTEGER;
5981: TYPE l_tbold_salvage_value_type IS TABLE OF okl_txl_assets_b.old_salvage_value%TYPE INDEX BY BINARY_INTEGER;
5982: TYPE l_tbnew_residual_value_type IS TABLE OF okl_txl_assets_b.new_residual_value%TYPE INDEX BY BINARY_INTEGER;
5983: TYPE l_tbold_residual_value_type IS TABLE OF okl_txl_assets_b.old_residual_value%TYPE INDEX BY BINARY_INTEGER;
5984: TYPE l_tbunits_retired_type IS TABLE OF okl_txl_assets_b.units_retired%TYPE INDEX BY BINARY_INTEGER;
5985: TYPE l_tbcost_retired_type IS TABLE OF okl_txl_assets_b.cost_retired%TYPE INDEX BY BINARY_INTEGER;
5986: TYPE l_tbsale_proceeds_type IS TABLE OF okl_txl_assets_b.sale_proceeds%TYPE INDEX BY BINARY_INTEGER;

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

5979: TYPE l_tbdepreciate_yn_type IS TABLE OF okl_txl_assets_b.depreciate_yn%TYPE INDEX BY BINARY_INTEGER;
5980: TYPE l_tbhold_period_days_type IS TABLE OF okl_txl_assets_b.hold_period_days%TYPE INDEX BY BINARY_INTEGER;
5981: TYPE l_tbold_salvage_value_type IS TABLE OF okl_txl_assets_b.old_salvage_value%TYPE INDEX BY BINARY_INTEGER;
5982: TYPE l_tbnew_residual_value_type IS TABLE OF okl_txl_assets_b.new_residual_value%TYPE INDEX BY BINARY_INTEGER;
5983: TYPE l_tbold_residual_value_type IS TABLE OF okl_txl_assets_b.old_residual_value%TYPE INDEX BY BINARY_INTEGER;
5984: TYPE l_tbunits_retired_type IS TABLE OF okl_txl_assets_b.units_retired%TYPE INDEX BY BINARY_INTEGER;
5985: TYPE l_tbcost_retired_type IS TABLE OF okl_txl_assets_b.cost_retired%TYPE INDEX BY BINARY_INTEGER;
5986: TYPE l_tbsale_proceeds_type IS TABLE OF okl_txl_assets_b.sale_proceeds%TYPE INDEX BY BINARY_INTEGER;
5987: TYPE l_tbremoval_cost_type IS TABLE OF okl_txl_assets_b.removal_cost%TYPE INDEX BY BINARY_INTEGER;

Line 6684: l_tbnew_residual_value_tab l_tbnew_residual_value_type;

6680: l_tblast_update_login_tab l_tblast_update_login_type;
6681: l_tbdepreciate_yn_tab l_tbdepreciate_yn_type;
6682: l_tbhold_period_days_tab l_tbhold_period_days_type;
6683: l_tbold_salvage_value_tab l_tbold_salvage_value_type;
6684: l_tbnew_residual_value_tab l_tbnew_residual_value_type;
6685: l_tbold_residual_value_tab l_tbold_residual_value_type;
6686: l_tbunits_retired_tab l_tbunits_retired_type;
6687: l_tbcost_retired_tab l_tbcost_retired_type;
6688: l_tbsale_proceeds_tab l_tbsale_proceeds_type;

Line 6685: l_tbold_residual_value_tab l_tbold_residual_value_type;

6681: l_tbdepreciate_yn_tab l_tbdepreciate_yn_type;
6682: l_tbhold_period_days_tab l_tbhold_period_days_type;
6683: l_tbold_salvage_value_tab l_tbold_salvage_value_type;
6684: l_tbnew_residual_value_tab l_tbnew_residual_value_type;
6685: l_tbold_residual_value_tab l_tbold_residual_value_type;
6686: l_tbunits_retired_tab l_tbunits_retired_type;
6687: l_tbcost_retired_tab l_tbcost_retired_type;
6688: l_tbsale_proceeds_tab l_tbsale_proceeds_type;
6689: l_tbremoval_cost_tab l_tbremoval_cost_type;

Line 6763: l_tb2new_residual_value_tab l_tbnew_residual_value_type;

6759: l_tb2last_update_login_tab l_tblast_update_login_type;
6760: l_tb2depreciate_yn_tab l_tbdepreciate_yn_type;
6761: l_tb2hold_period_days_tab l_tbhold_period_days_type;
6762: l_tb2old_salvage_value_tab l_tbold_salvage_value_type;
6763: l_tb2new_residual_value_tab l_tbnew_residual_value_type;
6764: l_tb2old_residual_value_tab l_tbold_residual_value_type;
6765: l_tb2units_retired_tab l_tbunits_retired_type;
6766: l_tb2cost_retired_tab l_tbcost_retired_type;
6767: l_tb2sale_proceeds_tab l_tbsale_proceeds_type;

Line 6764: l_tb2old_residual_value_tab l_tbold_residual_value_type;

6760: l_tb2depreciate_yn_tab l_tbdepreciate_yn_type;
6761: l_tb2hold_period_days_tab l_tbhold_period_days_type;
6762: l_tb2old_salvage_value_tab l_tbold_salvage_value_type;
6763: l_tb2new_residual_value_tab l_tbnew_residual_value_type;
6764: l_tb2old_residual_value_tab l_tbold_residual_value_type;
6765: l_tb2units_retired_tab l_tbunits_retired_type;
6766: l_tb2cost_retired_tab l_tbcost_retired_type;
6767: l_tb2sale_proceeds_tab l_tbsale_proceeds_type;
6768: l_tb2removal_cost_tab l_tbremoval_cost_type;

Line 8312: FROM dual;

8308:
8309: -- cursor to get sequence number for asset number
8310: CURSOR c_asset_no IS
8311: SELECT 'OKL'||OKL_FAN_SEQ.NEXTVAL
8312: FROM dual;
8313:
8314: -- cursor to get check the existence of asset number
8315: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE)
8316: IS

Line 8318: FROM DUAL

8314: -- cursor to get check the existence of asset number
8315: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE)
8316: IS
8317: SELECT 1
8318: FROM DUAL
8319: WHERE EXISTS (SELECT '1'
8320: FROM OKL_TXL_ASSETS_B
8321: WHERE asset_number = p_asset_number);
8322:

Line 8325: FROM DUAL

8321: WHERE asset_number = p_asset_number);
8322:
8323: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) IS
8324: SELECT 1
8325: FROM DUAL
8326: WHERE EXISTS (SELECT '1'
8327: FROM OKX_ASSET_LINES_V
8328: WHERE asset_number = p_asset_number);
8329:

Line 8332: FROM DUAL

8328: WHERE asset_number = p_asset_number);
8329:
8330: CURSOR c_okx_assets_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) IS
8331: SELECT 1
8332: FROM DUAL
8333: WHERE EXISTS (SELECT '1'
8334: FROM OKX_ASSETS_V
8335: WHERE asset_number = p_asset_number);
8336:

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

10525: CURSOR c8(p_id NUMBER) IS
10526: SELECT
10527: a.id, a.kle_id, a.sty_id,
10528: a.object_version_number, a.lao_amount, a.fee_charge,
10529: a.title_date, a.date_residual_last_review, a.date_last_reamortisation,
10530: a.termination_purchase_amount, a.date_last_cleanup, a.remarketed_amount,
10531: a.date_remarketed, a.remarket_margin, a.repurchased_amount,
10532: a.date_repurchased, a.gain_loss, a.floor_amount,
10533: a.previous_contract, a.tracked_residual, a.date_title_received,

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

10529: a.title_date, a.date_residual_last_review, a.date_last_reamortisation,
10530: a.termination_purchase_amount, a.date_last_cleanup, a.remarketed_amount,
10531: a.date_remarketed, a.remarket_margin, a.repurchased_amount,
10532: a.date_repurchased, a.gain_loss, a.floor_amount,
10533: a.previous_contract, a.tracked_residual, a.date_title_received,
10534: a.estimated_oec, a.residual_percentage, a.capital_reduction,
10535: a.vendor_advance_paid, a.tradein_amount, a.delivered_date,
10536: a.year_of_manufacture, a.initial_direct_cost, a.occupancy,
10537: a.date_last_inspection, a.date_next_inspection_due, a.weighted_average_life,

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

10530: a.termination_purchase_amount, a.date_last_cleanup, a.remarketed_amount,
10531: a.date_remarketed, a.remarket_margin, a.repurchased_amount,
10532: a.date_repurchased, a.gain_loss, a.floor_amount,
10533: a.previous_contract, a.tracked_residual, a.date_title_received,
10534: a.estimated_oec, a.residual_percentage, a.capital_reduction,
10535: a.vendor_advance_paid, a.tradein_amount, a.delivered_date,
10536: a.year_of_manufacture, a.initial_direct_cost, a.occupancy,
10537: a.date_last_inspection, a.date_next_inspection_due, a.weighted_average_life,
10538: a.bond_equivalent_yield, a.refinance_amount, a.year_built,

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

10537: a.date_last_inspection, a.date_next_inspection_due, a.weighted_average_life,
10538: a.bond_equivalent_yield, a.refinance_amount, a.year_built,
10539: a.coverage_ratio, a.gross_square_footage, a.net_rentable,
10540: a.date_letter_acceptance, a.date_commitment_expiration, a.date_appraisal,
10541: a.appraisal_value, a.residual_value, a.percent,
10542: a.coverage, a.lrv_amount, a.amount,
10543: a.lrs_percent, a.evergreen_percent, a.percent_stake,
10544: a.amount_stake, a.date_sold, a.sty_id_for,
10545: a.attribute_category, a.attribute1, a.attribute2,

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

10552: a.nty_code, a.fcg_code, a.prc_code,
10553: a.re_lease_yn, a.prescribed_asset_yn, a.credit_tenant_yn,
10554: a.secured_deal_yn, a.clg_id, a.date_funding,
10555: a.date_funding_required, a.date_accepted, a.date_delivery_expected,
10556: a.oec, a.capital_amount, a.residual_grnty_amount,
10557: a.residual_code, a.rvi_premium, a.credit_nature,
10558: a.capitalized_interest, a.capital_reduction_percent, a.date_pay_investor_start,
10559: a.pay_investor_frequency, a.pay_investor_event, a.pay_investor_remittance_days,
10560: a.fee_type, a.subsidy_id, a.subsidy_override_amount,

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

10553: a.re_lease_yn, a.prescribed_asset_yn, a.credit_tenant_yn,
10554: a.secured_deal_yn, a.clg_id, a.date_funding,
10555: a.date_funding_required, a.date_accepted, a.date_delivery_expected,
10556: a.oec, a.capital_amount, a.residual_grnty_amount,
10557: a.residual_code, a.rvi_premium, a.credit_nature,
10558: a.capitalized_interest, a.capital_reduction_percent, a.date_pay_investor_start,
10559: a.pay_investor_frequency, a.pay_investor_event, a.pay_investor_remittance_days,
10560: a.fee_type, a.subsidy_id, a.subsidy_override_amount,
10561: a.pre_tax_yield, a.after_tax_yield, a.implicit_interest_rate,

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

10582: TYPE l_object_version_number_type IS TABLE OF okl_k_lines.object_version_number%TYPE INDEX BY BINARY_INTEGER;
10583: TYPE l_lao_amount_type IS TABLE OF okl_k_lines.lao_amount%TYPE INDEX BY BINARY_INTEGER;
10584: TYPE l_fee_charge_type IS TABLE OF okl_k_lines.fee_charge%TYPE INDEX BY BINARY_INTEGER;
10585: TYPE l_title_date_type IS TABLE OF okl_k_lines.title_date%TYPE INDEX BY BINARY_INTEGER;
10586: TYPE l_date_residual_last_revi_type IS TABLE OF okl_k_lines.date_residual_last_review%TYPE INDEX BY BINARY_INTEGER;
10587: TYPE l_date_last_reamortisatio_type IS TABLE OF okl_k_lines.date_last_reamortisation%TYPE INDEX BY BINARY_INTEGER;
10588: TYPE l_termination_purchase_am_type IS TABLE OF okl_k_lines.termination_purchase_amount%TYPE INDEX BY BINARY_INTEGER;
10589: TYPE l_date_last_cleanup_type IS TABLE OF okl_k_lines.date_last_cleanup%TYPE INDEX BY BINARY_INTEGER;
10590: TYPE l_remarketed_amount_type IS TABLE OF okl_k_lines.remarketed_amount%TYPE INDEX BY BINARY_INTEGER;

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

10594: TYPE l_date_repurchased_type IS TABLE OF okl_k_lines.date_repurchased%TYPE INDEX BY BINARY_INTEGER;
10595: TYPE l_gain_loss_type IS TABLE OF okl_k_lines.gain_loss%TYPE INDEX BY BINARY_INTEGER;
10596: TYPE l_floor_amount_type IS TABLE OF okl_k_lines.floor_amount%TYPE INDEX BY BINARY_INTEGER;
10597: TYPE l_previous_contract_type IS TABLE OF okl_k_lines.previous_contract%TYPE INDEX BY BINARY_INTEGER;
10598: TYPE l_tracked_residual_type IS TABLE OF okl_k_lines.tracked_residual%TYPE INDEX BY BINARY_INTEGER;
10599: TYPE l_date_title_received_type IS TABLE OF okl_k_lines.date_title_received%TYPE INDEX BY BINARY_INTEGER;
10600: TYPE l_estimated_oec_type IS TABLE OF okl_k_lines.estimated_oec%TYPE INDEX BY BINARY_INTEGER;
10601: TYPE l_residual_percentage_type IS TABLE OF okl_k_lines.residual_percentage%TYPE INDEX BY BINARY_INTEGER;
10602: TYPE l_capital_reduction_type IS TABLE OF okl_k_lines.capital_reduction%TYPE INDEX BY BINARY_INTEGER;

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

10597: TYPE l_previous_contract_type IS TABLE OF okl_k_lines.previous_contract%TYPE INDEX BY BINARY_INTEGER;
10598: TYPE l_tracked_residual_type IS TABLE OF okl_k_lines.tracked_residual%TYPE INDEX BY BINARY_INTEGER;
10599: TYPE l_date_title_received_type IS TABLE OF okl_k_lines.date_title_received%TYPE INDEX BY BINARY_INTEGER;
10600: TYPE l_estimated_oec_type IS TABLE OF okl_k_lines.estimated_oec%TYPE INDEX BY BINARY_INTEGER;
10601: TYPE l_residual_percentage_type IS TABLE OF okl_k_lines.residual_percentage%TYPE INDEX BY BINARY_INTEGER;
10602: TYPE l_capital_reduction_type IS TABLE OF okl_k_lines.capital_reduction%TYPE INDEX BY BINARY_INTEGER;
10603: TYPE l_vendor_advance_paid_type IS TABLE OF okl_k_lines.vendor_advance_paid%TYPE INDEX BY BINARY_INTEGER;
10604: TYPE l_tradein_amount_type IS TABLE OF okl_k_lines.tradein_amount%TYPE INDEX BY BINARY_INTEGER;
10605: TYPE l_delivered_date_type IS TABLE OF okl_k_lines.delivered_date%TYPE INDEX BY BINARY_INTEGER;

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

10618: TYPE l_date_letter_acceptance_type IS TABLE OF okl_k_lines.date_letter_acceptance%TYPE INDEX BY BINARY_INTEGER;
10619: TYPE l_date_commitment_expirat_type IS TABLE OF okl_k_lines.date_commitment_expiration%TYPE INDEX BY BINARY_INTEGER;
10620: TYPE l_date_appraisal_type IS TABLE OF okl_k_lines.date_appraisal%TYPE INDEX BY BINARY_INTEGER;
10621: TYPE l_appraisal_value_type IS TABLE OF okl_k_lines.appraisal_value%TYPE INDEX BY BINARY_INTEGER;
10622: TYPE l_residual_value_type IS TABLE OF okl_k_lines.residual_value%TYPE INDEX BY BINARY_INTEGER;
10623: TYPE l_percent_type IS TABLE OF okl_k_lines.percent%TYPE INDEX BY BINARY_INTEGER;
10624: TYPE l_coverage_type IS TABLE OF okl_k_lines.coverage%TYPE INDEX BY BINARY_INTEGER;
10625: TYPE l_lrv_amount_type IS TABLE OF okl_k_lines.lrv_amount%TYPE INDEX BY BINARY_INTEGER;
10626: TYPE l_amount_type IS TABLE OF okl_k_lines.amount%TYPE INDEX BY BINARY_INTEGER;

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

10667: TYPE l_date_accepted_type IS TABLE OF okl_k_lines.date_accepted%TYPE INDEX BY BINARY_INTEGER;
10668: TYPE l_date_delivery_expected_type IS TABLE OF okl_k_lines.date_delivery_expected%TYPE INDEX BY BINARY_INTEGER;
10669: TYPE l_oec_type IS TABLE OF okl_k_lines.oec%TYPE INDEX BY BINARY_INTEGER;
10670: TYPE l_capital_amount_type IS TABLE OF okl_k_lines.capital_amount%TYPE INDEX BY BINARY_INTEGER;
10671: TYPE l_residual_grnty_amount_type IS TABLE OF okl_k_lines.residual_grnty_amount%TYPE INDEX BY BINARY_INTEGER;
10672: TYPE l_residual_code_type IS TABLE OF okl_k_lines.residual_code%TYPE INDEX BY BINARY_INTEGER;
10673: TYPE l_rvi_premium_type IS TABLE OF okl_k_lines.rvi_premium%TYPE INDEX BY BINARY_INTEGER;
10674: TYPE l_credit_nature_type IS TABLE OF okl_k_lines.credit_nature%TYPE INDEX BY BINARY_INTEGER;
10675: TYPE l_capitalized_interest_type IS TABLE OF okl_k_lines.capitalized_interest%TYPE INDEX BY BINARY_INTEGER;

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

10668: TYPE l_date_delivery_expected_type IS TABLE OF okl_k_lines.date_delivery_expected%TYPE INDEX BY BINARY_INTEGER;
10669: TYPE l_oec_type IS TABLE OF okl_k_lines.oec%TYPE INDEX BY BINARY_INTEGER;
10670: TYPE l_capital_amount_type IS TABLE OF okl_k_lines.capital_amount%TYPE INDEX BY BINARY_INTEGER;
10671: TYPE l_residual_grnty_amount_type IS TABLE OF okl_k_lines.residual_grnty_amount%TYPE INDEX BY BINARY_INTEGER;
10672: TYPE l_residual_code_type IS TABLE OF okl_k_lines.residual_code%TYPE INDEX BY BINARY_INTEGER;
10673: TYPE l_rvi_premium_type IS TABLE OF okl_k_lines.rvi_premium%TYPE INDEX BY BINARY_INTEGER;
10674: TYPE l_credit_nature_type IS TABLE OF okl_k_lines.credit_nature%TYPE INDEX BY BINARY_INTEGER;
10675: TYPE l_capitalized_interest_type IS TABLE OF okl_k_lines.capitalized_interest%TYPE INDEX BY BINARY_INTEGER;
10676: TYPE l_capital_reduction_perce_type IS TABLE OF okl_k_lines.capital_reduction_percent%TYPE INDEX BY BINARY_INTEGER;

Line 10719: l_date_residual_last_revi_tab l_date_residual_last_revi_type;

10715: l_object_version_number_tab l_object_version_number_type;
10716: l_lao_amount_tab l_lao_amount_type;
10717: l_fee_charge_tab l_fee_charge_type;
10718: l_title_date_tab l_title_date_type;
10719: l_date_residual_last_revi_tab l_date_residual_last_revi_type;
10720: l_date_last_reamortisatio_tab l_date_last_reamortisatio_type;
10721: l_termination_purchase_am_tab l_termination_purchase_am_type;
10722: l_date_last_cleanup_tab l_date_last_cleanup_type;
10723: l_remarketed_amount_tab l_remarketed_amount_type;

Line 10731: l_tracked_residual_tab l_tracked_residual_type;

10727: l_date_repurchased_tab l_date_repurchased_type;
10728: l_gain_loss_tab l_gain_loss_type;
10729: l_floor_amount_tab l_floor_amount_type;
10730: l_previous_contract_tab l_previous_contract_type;
10731: l_tracked_residual_tab l_tracked_residual_type;
10732: l_date_title_received_tab l_date_title_received_type;
10733: l_estimated_oec_tab l_estimated_oec_type;
10734: l_residual_percentage_tab l_residual_percentage_type;
10735: l_capital_reduction_tab l_capital_reduction_type;

Line 10734: l_residual_percentage_tab l_residual_percentage_type;

10730: l_previous_contract_tab l_previous_contract_type;
10731: l_tracked_residual_tab l_tracked_residual_type;
10732: l_date_title_received_tab l_date_title_received_type;
10733: l_estimated_oec_tab l_estimated_oec_type;
10734: l_residual_percentage_tab l_residual_percentage_type;
10735: l_capital_reduction_tab l_capital_reduction_type;
10736: l_vendor_advance_paid_tab l_vendor_advance_paid_type;
10737: l_tradein_amount_tab l_tradein_amount_type;
10738: l_delivered_date_tab l_delivered_date_type;

Line 10755: l_residual_value_tab l_residual_value_type;

10751: l_date_letter_acceptance_tab l_date_letter_acceptance_type;
10752: l_date_commitment_expirat_tab l_date_commitment_expirat_type;
10753: l_date_appraisal_tab l_date_appraisal_type;
10754: l_appraisal_value_tab l_appraisal_value_type;
10755: l_residual_value_tab l_residual_value_type;
10756: l_percent_tab l_percent_type;
10757: l_coverage_tab l_coverage_type;
10758: l_lrv_amount_tab l_lrv_amount_type;
10759: l_amount_tab l_amount_type;

Line 10804: l_residual_grnty_amount_tab l_residual_grnty_amount_type;

10800: l_date_accepted_tab l_date_accepted_type;
10801: l_date_delivery_expected_tab l_date_delivery_expected_type;
10802: l_oec_tab l_oec_type;
10803: l_capital_amount_tab l_capital_amount_type;
10804: l_residual_grnty_amount_tab l_residual_grnty_amount_type;
10805: l_residual_code_tab l_residual_code_type;
10806: l_rvi_premium_tab l_rvi_premium_type;
10807: l_credit_nature_tab l_credit_nature_type;
10808: l_capitalized_interest_tab l_capitalized_interest_type;

Line 10805: l_residual_code_tab l_residual_code_type;

10801: l_date_delivery_expected_tab l_date_delivery_expected_type;
10802: l_oec_tab l_oec_type;
10803: l_capital_amount_tab l_capital_amount_type;
10804: l_residual_grnty_amount_tab l_residual_grnty_amount_type;
10805: l_residual_code_tab l_residual_code_type;
10806: l_rvi_premium_tab l_rvi_premium_type;
10807: l_credit_nature_tab l_credit_nature_type;
10808: l_capitalized_interest_tab l_capitalized_interest_type;
10809: l_capital_reduction_perce_tab l_capital_reduction_perce_type;

Line 10852: l_date_residual_last_revi_tab2 l_date_residual_last_revi_type;

10848: l_object_version_number_tab2 l_object_version_number_type;
10849: l_lao_amount_tab2 l_lao_amount_type;
10850: l_fee_charge_tab2 l_fee_charge_type;
10851: l_title_date_tab2 l_title_date_type;
10852: l_date_residual_last_revi_tab2 l_date_residual_last_revi_type;
10853: l_date_last_reamortisatio_tab2 l_date_last_reamortisatio_type;
10854: l_termination_purchase_am_tab2 l_termination_purchase_am_type;
10855: l_date_last_cleanup_tab2 l_date_last_cleanup_type;
10856: l_remarketed_amount_tab2 l_remarketed_amount_type;

Line 10864: l_tracked_residual_tab2 l_tracked_residual_type;

10860: l_date_repurchased_tab2 l_date_repurchased_type;
10861: l_gain_loss_tab2 l_gain_loss_type;
10862: l_floor_amount_tab2 l_floor_amount_type;
10863: l_previous_contract_tab2 l_previous_contract_type;
10864: l_tracked_residual_tab2 l_tracked_residual_type;
10865: l_date_title_received_tab2 l_date_title_received_type;
10866: l_estimated_oec_tab2 l_estimated_oec_type;
10867: l_residual_percentage_tab2 l_residual_percentage_type;
10868: l_capital_reduction_tab2 l_capital_reduction_type;

Line 10867: l_residual_percentage_tab2 l_residual_percentage_type;

10863: l_previous_contract_tab2 l_previous_contract_type;
10864: l_tracked_residual_tab2 l_tracked_residual_type;
10865: l_date_title_received_tab2 l_date_title_received_type;
10866: l_estimated_oec_tab2 l_estimated_oec_type;
10867: l_residual_percentage_tab2 l_residual_percentage_type;
10868: l_capital_reduction_tab2 l_capital_reduction_type;
10869: l_vendor_advance_paid_tab2 l_vendor_advance_paid_type;
10870: l_tradein_amount_tab2 l_tradein_amount_type;
10871: l_delivered_date_tab2 l_delivered_date_type;

Line 10888: l_residual_value_tab2 l_residual_value_type;

10884: l_date_letter_acceptance_tab2 l_date_letter_acceptance_type;
10885: l_date_commitment_expirat_tab2 l_date_commitment_expirat_type;
10886: l_date_appraisal_tab2 l_date_appraisal_type;
10887: l_appraisal_value_tab2 l_appraisal_value_type;
10888: l_residual_value_tab2 l_residual_value_type;
10889: l_percent_tab2 l_percent_type;
10890: l_coverage_tab2 l_coverage_type;
10891: l_lrv_amount_tab2 l_lrv_amount_type;
10892: l_amount_tab2 l_amount_type;

Line 10937: l_residual_grnty_amount_tab2 l_residual_grnty_amount_type;

10933: l_date_accepted_tab2 l_date_accepted_type;
10934: l_date_delivery_expected_tab2 l_date_delivery_expected_type;
10935: l_oec_tab2 l_oec_type;
10936: l_capital_amount_tab2 l_capital_amount_type;
10937: l_residual_grnty_amount_tab2 l_residual_grnty_amount_type;
10938: l_residual_code_tab2 l_residual_code_type;
10939: l_rvi_premium_tab2 l_rvi_premium_type;
10940: l_credit_nature_tab2 l_credit_nature_type;
10941: l_capitalized_interest_tab2 l_capitalized_interest_type;

Line 10938: l_residual_code_tab2 l_residual_code_type;

10934: l_date_delivery_expected_tab2 l_date_delivery_expected_type;
10935: l_oec_tab2 l_oec_type;
10936: l_capital_amount_tab2 l_capital_amount_type;
10937: l_residual_grnty_amount_tab2 l_residual_grnty_amount_type;
10938: l_residual_code_tab2 l_residual_code_type;
10939: l_rvi_premium_tab2 l_rvi_premium_type;
10940: l_credit_nature_tab2 l_credit_nature_type;
10941: l_capitalized_interest_tab2 l_capitalized_interest_type;
10942: l_capital_reduction_perce_tab2 l_capital_reduction_perce_type;

Line 10995: l_title_date_tab2, l_date_residual_last_revi_tab2, l_date_last_reamortisatio_tab2,

10991: LOOP
10992: FETCH c8 bulk collect INTO
10993: l_id_tab2, l_kle_id_tab2, l_sty_id_tab2,
10994: l_object_version_number_tab2, l_lao_amount_tab2, l_fee_charge_tab2,
10995: l_title_date_tab2, l_date_residual_last_revi_tab2, l_date_last_reamortisatio_tab2,
10996: l_termination_purchase_am_tab2, l_date_last_cleanup_tab2, l_remarketed_amount_tab2,
10997: l_date_remarketed_tab2, l_remarket_margin_tab2, l_repurchased_amount_tab2,
10998: l_date_repurchased_tab2, l_gain_loss_tab2, l_floor_amount_tab2,
10999: l_previous_contract_tab2, l_tracked_residual_tab2, l_date_title_received_tab2,

Line 10999: l_previous_contract_tab2, l_tracked_residual_tab2, l_date_title_received_tab2,

10995: l_title_date_tab2, l_date_residual_last_revi_tab2, l_date_last_reamortisatio_tab2,
10996: l_termination_purchase_am_tab2, l_date_last_cleanup_tab2, l_remarketed_amount_tab2,
10997: l_date_remarketed_tab2, l_remarket_margin_tab2, l_repurchased_amount_tab2,
10998: l_date_repurchased_tab2, l_gain_loss_tab2, l_floor_amount_tab2,
10999: l_previous_contract_tab2, l_tracked_residual_tab2, l_date_title_received_tab2,
11000: l_estimated_oec_tab2, l_residual_percentage_tab2, l_capital_reduction_tab2,
11001: l_vendor_advance_paid_tab2, l_tradein_amount_tab2, l_delivered_date_tab2,
11002: l_year_of_manufacture_tab2, l_initial_direct_cost_tab2, l_occupancy_tab2,
11003: l_date_last_inspection_tab2, l_date_next_inspection_du_tab2, l_weighted_average_life_tab2,

Line 11000: l_estimated_oec_tab2, l_residual_percentage_tab2, l_capital_reduction_tab2,

10996: l_termination_purchase_am_tab2, l_date_last_cleanup_tab2, l_remarketed_amount_tab2,
10997: l_date_remarketed_tab2, l_remarket_margin_tab2, l_repurchased_amount_tab2,
10998: l_date_repurchased_tab2, l_gain_loss_tab2, l_floor_amount_tab2,
10999: l_previous_contract_tab2, l_tracked_residual_tab2, l_date_title_received_tab2,
11000: l_estimated_oec_tab2, l_residual_percentage_tab2, l_capital_reduction_tab2,
11001: l_vendor_advance_paid_tab2, l_tradein_amount_tab2, l_delivered_date_tab2,
11002: l_year_of_manufacture_tab2, l_initial_direct_cost_tab2, l_occupancy_tab2,
11003: l_date_last_inspection_tab2, l_date_next_inspection_du_tab2, l_weighted_average_life_tab2,
11004: l_bond_equivalent_yield_tab2, l_refinance_amount_tab2, l_year_built_tab2,

Line 11007: l_appraisal_value_tab2, l_residual_value_tab2, l_percent_tab2,

11003: l_date_last_inspection_tab2, l_date_next_inspection_du_tab2, l_weighted_average_life_tab2,
11004: l_bond_equivalent_yield_tab2, l_refinance_amount_tab2, l_year_built_tab2,
11005: l_coverage_ratio_tab2, l_gross_square_footage_tab2, l_net_rentable_tab2,
11006: l_date_letter_acceptance_tab2, l_date_commitment_expirat_tab2, l_date_appraisal_tab2,
11007: l_appraisal_value_tab2, l_residual_value_tab2, l_percent_tab2,
11008: l_coverage_tab2, l_lrv_amount_tab2, l_amount_tab2,
11009: l_lrs_percent_tab2, l_evergreen_percent_tab2, l_percent_stake_tab2,
11010: l_amount_stake_tab2, l_date_sold_tab2, l_sty_id_for_tab2,
11011: l_attribute_category_tab2, l_attribute1_tab2, l_attribute2_tab2,

Line 11022: l_oec_tab2, l_capital_amount_tab2, l_residual_grnty_amount_tab2,

11018: l_nty_code_tab2, l_fcg_code_tab2, l_prc_code_tab2,
11019: l_re_lease_yn_tab2, l_prescribed_asset_yn_tab2, l_credit_tenant_yn_tab2,
11020: l_secured_deal_yn_tab2, l_clg_id_tab2, l_date_funding_tab2,
11021: l_date_funding_required_tab2, l_date_accepted_tab2, l_date_delivery_expected_tab2,
11022: l_oec_tab2, l_capital_amount_tab2, l_residual_grnty_amount_tab2,
11023: l_residual_code_tab2, l_rvi_premium_tab2, l_credit_nature_tab2,
11024: l_capitalized_interest_tab2, l_capital_reduction_perce_tab2, l_date_pay_investor_start_tab2,
11025: l_pay_investor_frequency_tab2, l_pay_investor_event_tab2, l_pay_investor_remit_days_tab2,
11026: l_fee_type_tab2, l_subsidy_id_tab2, l_subsidy_override_amount_tab2,

Line 11023: l_residual_code_tab2, l_rvi_premium_tab2, l_credit_nature_tab2,

11019: l_re_lease_yn_tab2, l_prescribed_asset_yn_tab2, l_credit_tenant_yn_tab2,
11020: l_secured_deal_yn_tab2, l_clg_id_tab2, l_date_funding_tab2,
11021: l_date_funding_required_tab2, l_date_accepted_tab2, l_date_delivery_expected_tab2,
11022: l_oec_tab2, l_capital_amount_tab2, l_residual_grnty_amount_tab2,
11023: l_residual_code_tab2, l_rvi_premium_tab2, l_credit_nature_tab2,
11024: l_capitalized_interest_tab2, l_capital_reduction_perce_tab2, l_date_pay_investor_start_tab2,
11025: l_pay_investor_frequency_tab2, l_pay_investor_event_tab2, l_pay_investor_remit_days_tab2,
11026: l_fee_type_tab2, l_subsidy_id_tab2, l_subsidy_override_amount_tab2,
11027: l_pre_tax_yield_tab2, l_after_tax_yield_tab2, l_implicit_interest_rate_tab2,

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

11078: l_object_version_number_tab(l_okl_k_lines_counter) := l_object_version_number_tab2(i);
11079: l_lao_amount_tab(l_okl_k_lines_counter) := l_lao_amount_tab2(i);
11080: l_fee_charge_tab(l_okl_k_lines_counter) := l_fee_charge_tab2(i);
11081: l_title_date_tab(l_okl_k_lines_counter) := l_title_date_tab2(i);
11082: l_date_residual_last_revi_tab(l_okl_k_lines_counter) := l_date_residual_last_revi_tab2(i);
11083: l_date_last_reamortisatio_tab(l_okl_k_lines_counter) := l_date_last_reamortisatio_tab2(i);
11084: l_termination_purchase_am_tab(l_okl_k_lines_counter) := l_termination_purchase_am_tab2(i);
11085: l_date_last_cleanup_tab(l_okl_k_lines_counter) := l_date_last_cleanup_tab2(i);
11086: l_remarketed_amount_tab(l_okl_k_lines_counter) := l_remarketed_amount_tab2(i);

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

11090: l_date_repurchased_tab(l_okl_k_lines_counter) := l_date_repurchased_tab2(i);
11091: l_gain_loss_tab(l_okl_k_lines_counter) := l_gain_loss_tab2(i);
11092: l_floor_amount_tab(l_okl_k_lines_counter) := l_floor_amount_tab2(i);
11093: l_previous_contract_tab(l_okl_k_lines_counter) := l_previous_contract_tab2(i);
11094: l_tracked_residual_tab(l_okl_k_lines_counter) := l_tracked_residual_tab2(i);
11095: l_date_title_received_tab(l_okl_k_lines_counter) := l_date_title_received_tab2(i);
11096: l_estimated_oec_tab(l_okl_k_lines_counter) := l_estimated_oec_tab2(i);
11097: l_residual_percentage_tab(l_okl_k_lines_counter) := l_residual_percentage_tab2(i);
11098: l_capital_reduction_tab(l_okl_k_lines_counter) := l_capital_reduction_tab2(i);

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

11093: l_previous_contract_tab(l_okl_k_lines_counter) := l_previous_contract_tab2(i);
11094: l_tracked_residual_tab(l_okl_k_lines_counter) := l_tracked_residual_tab2(i);
11095: l_date_title_received_tab(l_okl_k_lines_counter) := l_date_title_received_tab2(i);
11096: l_estimated_oec_tab(l_okl_k_lines_counter) := l_estimated_oec_tab2(i);
11097: l_residual_percentage_tab(l_okl_k_lines_counter) := l_residual_percentage_tab2(i);
11098: l_capital_reduction_tab(l_okl_k_lines_counter) := l_capital_reduction_tab2(i);
11099: l_vendor_advance_paid_tab(l_okl_k_lines_counter) := l_vendor_advance_paid_tab2(i);
11100: l_tradein_amount_tab(l_okl_k_lines_counter) := l_tradein_amount_tab2(i);
11101: l_delivered_date_tab(l_okl_k_lines_counter) := l_delivered_date_tab2(i);

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

11114: l_date_letter_acceptance_tab(l_okl_k_lines_counter) := l_date_letter_acceptance_tab2(i);
11115: l_date_commitment_expirat_tab(l_okl_k_lines_counter) := l_date_commitment_expirat_tab2(i);
11116: l_date_appraisal_tab(l_okl_k_lines_counter) := l_date_appraisal_tab2(i);
11117: l_appraisal_value_tab(l_okl_k_lines_counter) := l_appraisal_value_tab2(i);
11118: l_residual_value_tab(l_okl_k_lines_counter) := l_residual_value_tab2(i);
11119: l_percent_tab(l_okl_k_lines_counter) := l_percent_tab2(i);
11120: l_coverage_tab(l_okl_k_lines_counter) := l_coverage_tab2(i);
11121: l_lrv_amount_tab(l_okl_k_lines_counter) := l_lrv_amount_tab2(i);
11122: l_amount_tab(l_okl_k_lines_counter) := l_amount_tab2(i);

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

11176: l_date_accepted_tab(l_okl_k_lines_counter) := l_date_accepted_tab2(i);
11177: l_date_delivery_expected_tab(l_okl_k_lines_counter) := l_date_delivery_expected_tab2(i);
11178: l_oec_tab(l_okl_k_lines_counter) := l_oec_tab2(i);
11179: l_capital_amount_tab(l_okl_k_lines_counter) := l_capital_amount_tab2(i);
11180: l_residual_grnty_amount_tab(l_okl_k_lines_counter) := l_residual_grnty_amount_tab2(i);
11181: l_residual_code_tab(l_okl_k_lines_counter) := l_residual_code_tab2(i);
11182: l_rvi_premium_tab(l_okl_k_lines_counter) := l_rvi_premium_tab2(i);
11183: l_credit_nature_tab(l_okl_k_lines_counter) := l_credit_nature_tab2(i);
11184: l_capitalized_interest_tab(l_okl_k_lines_counter) := l_capitalized_interest_tab2(i);

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

11177: l_date_delivery_expected_tab(l_okl_k_lines_counter) := l_date_delivery_expected_tab2(i);
11178: l_oec_tab(l_okl_k_lines_counter) := l_oec_tab2(i);
11179: l_capital_amount_tab(l_okl_k_lines_counter) := l_capital_amount_tab2(i);
11180: l_residual_grnty_amount_tab(l_okl_k_lines_counter) := l_residual_grnty_amount_tab2(i);
11181: l_residual_code_tab(l_okl_k_lines_counter) := l_residual_code_tab2(i);
11182: l_rvi_premium_tab(l_okl_k_lines_counter) := l_rvi_premium_tab2(i);
11183: l_credit_nature_tab(l_okl_k_lines_counter) := l_credit_nature_tab2(i);
11184: l_capitalized_interest_tab(l_okl_k_lines_counter) := l_capitalized_interest_tab2(i);
11185: l_capital_reduction_perce_tab(l_okl_k_lines_counter) := l_capital_reduction_perce_tab2(i);

Line 11281: title_date, date_residual_last_review, date_last_reamortisation,

11277: forall i IN l_id_tab.first..l_id_tab.last
11278: INSERT INTO okl_k_lines (
11279: id, kle_id, sty_id,
11280: object_version_number, lao_amount, fee_charge,
11281: title_date, date_residual_last_review, date_last_reamortisation,
11282: termination_purchase_amount, date_last_cleanup, remarketed_amount,
11283: date_remarketed, remarket_margin, repurchased_amount,
11284: date_repurchased, gain_loss, floor_amount,
11285: previous_contract, tracked_residual, date_title_received,

Line 11285: previous_contract, tracked_residual, date_title_received,

11281: title_date, date_residual_last_review, date_last_reamortisation,
11282: termination_purchase_amount, date_last_cleanup, remarketed_amount,
11283: date_remarketed, remarket_margin, repurchased_amount,
11284: date_repurchased, gain_loss, floor_amount,
11285: previous_contract, tracked_residual, date_title_received,
11286: estimated_oec, residual_percentage, capital_reduction,
11287: vendor_advance_paid, tradein_amount, delivered_date,
11288: year_of_manufacture, initial_direct_cost, occupancy,
11289: date_last_inspection, date_next_inspection_due, weighted_average_life,

Line 11286: estimated_oec, residual_percentage, capital_reduction,

11282: termination_purchase_amount, date_last_cleanup, remarketed_amount,
11283: date_remarketed, remarket_margin, repurchased_amount,
11284: date_repurchased, gain_loss, floor_amount,
11285: previous_contract, tracked_residual, date_title_received,
11286: estimated_oec, residual_percentage, capital_reduction,
11287: vendor_advance_paid, tradein_amount, delivered_date,
11288: year_of_manufacture, initial_direct_cost, occupancy,
11289: date_last_inspection, date_next_inspection_due, weighted_average_life,
11290: bond_equivalent_yield, refinance_amount, year_built,

Line 11293: appraisal_value, residual_value, percent,

11289: date_last_inspection, date_next_inspection_due, weighted_average_life,
11290: bond_equivalent_yield, refinance_amount, year_built,
11291: coverage_ratio, gross_square_footage, net_rentable,
11292: date_letter_acceptance, date_commitment_expiration, date_appraisal,
11293: appraisal_value, residual_value, percent,
11294: coverage, lrv_amount, amount,
11295: lrs_percent, evergreen_percent, percent_stake,
11296: amount_stake, date_sold, sty_id_for,
11297: attribute_category, attribute1, attribute2,

Line 11308: oec, capital_amount, residual_grnty_amount,

11304: nty_code, fcg_code, prc_code,
11305: re_lease_yn, prescribed_asset_yn, credit_tenant_yn,
11306: secured_deal_yn, clg_id, date_funding,
11307: date_funding_required, date_accepted, date_delivery_expected,
11308: oec, capital_amount, residual_grnty_amount,
11309: residual_code, rvi_premium, credit_nature,
11310: capitalized_interest, capital_reduction_percent,date_pay_investor_start,
11311: pay_investor_frequency, pay_investor_event,pay_investor_remittance_days,
11312: fee_type, subsidy_id, subsidy_override_amount,

Line 11309: residual_code, rvi_premium, credit_nature,

11305: re_lease_yn, prescribed_asset_yn, credit_tenant_yn,
11306: secured_deal_yn, clg_id, date_funding,
11307: date_funding_required, date_accepted, date_delivery_expected,
11308: oec, capital_amount, residual_grnty_amount,
11309: residual_code, rvi_premium, credit_nature,
11310: capitalized_interest, capital_reduction_percent,date_pay_investor_start,
11311: pay_investor_frequency, pay_investor_event,pay_investor_remittance_days,
11312: fee_type, subsidy_id, subsidy_override_amount,
11313: pre_tax_yield, after_tax_yield, implicit_interest_rate,

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

11323: ,ORIGINATION_INCOME -- Bug 12938353
11324: ) VALUES (
11325: l_id_tab(i), l_kle_id_tab(i), l_sty_id_tab(i),
11326: l_object_version_number_tab(i), l_lao_amount_tab(i), l_fee_charge_tab(i),
11327: l_title_date_tab(i), l_date_residual_last_revi_tab(i), l_date_last_reamortisatio_tab(i),
11328: l_termination_purchase_am_tab(i), l_date_last_cleanup_tab(i), l_remarketed_amount_tab(i),
11329: l_date_remarketed_tab(i), l_remarket_margin_tab(i), l_repurchased_amount_tab(i),
11330: l_date_repurchased_tab(i), l_gain_loss_tab(i), l_floor_amount_tab(i),
11331: l_previous_contract_tab(i), l_tracked_residual_tab(i), l_date_title_received_tab(i),

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

11327: l_title_date_tab(i), l_date_residual_last_revi_tab(i), l_date_last_reamortisatio_tab(i),
11328: l_termination_purchase_am_tab(i), l_date_last_cleanup_tab(i), l_remarketed_amount_tab(i),
11329: l_date_remarketed_tab(i), l_remarket_margin_tab(i), l_repurchased_amount_tab(i),
11330: l_date_repurchased_tab(i), l_gain_loss_tab(i), l_floor_amount_tab(i),
11331: l_previous_contract_tab(i), l_tracked_residual_tab(i), l_date_title_received_tab(i),
11332: l_estimated_oec_tab(i), l_residual_percentage_tab(i), l_capital_reduction_tab(i),
11333: l_vendor_advance_paid_tab(i), l_tradein_amount_tab(i), l_delivered_date_tab(i),
11334: l_year_of_manufacture_tab(i), l_initial_direct_cost_tab(i), l_occupancy_tab(i),
11335: l_date_last_inspection_tab(i), l_date_next_inspection_du_tab(i), l_weighted_average_life_tab(i),

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

11328: l_termination_purchase_am_tab(i), l_date_last_cleanup_tab(i), l_remarketed_amount_tab(i),
11329: l_date_remarketed_tab(i), l_remarket_margin_tab(i), l_repurchased_amount_tab(i),
11330: l_date_repurchased_tab(i), l_gain_loss_tab(i), l_floor_amount_tab(i),
11331: l_previous_contract_tab(i), l_tracked_residual_tab(i), l_date_title_received_tab(i),
11332: l_estimated_oec_tab(i), l_residual_percentage_tab(i), l_capital_reduction_tab(i),
11333: l_vendor_advance_paid_tab(i), l_tradein_amount_tab(i), l_delivered_date_tab(i),
11334: l_year_of_manufacture_tab(i), l_initial_direct_cost_tab(i), l_occupancy_tab(i),
11335: l_date_last_inspection_tab(i), l_date_next_inspection_du_tab(i), l_weighted_average_life_tab(i),
11336: l_bond_equivalent_yield_tab(i), l_refinance_amount_tab(i), l_year_built_tab(i),

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

11335: l_date_last_inspection_tab(i), l_date_next_inspection_du_tab(i), l_weighted_average_life_tab(i),
11336: l_bond_equivalent_yield_tab(i), l_refinance_amount_tab(i), l_year_built_tab(i),
11337: l_coverage_ratio_tab(i), l_gross_square_footage_tab(i), l_net_rentable_tab(i),
11338: l_date_letter_acceptance_tab(i), l_date_commitment_expirat_tab(i), l_date_appraisal_tab(i),
11339: l_appraisal_value_tab(i), l_residual_value_tab(i), l_percent_tab(i),
11340: l_coverage_tab(i), l_lrv_amount_tab(i), l_amount_tab(i),
11341: l_lrs_percent_tab(i), l_evergreen_percent_tab(i), l_percent_stake_tab(i),
11342: l_amount_stake_tab(i), l_date_sold_tab(i), l_sty_id_for_tab(i),
11343: l_attribute_category_tab(i), l_attribute1_tab(i), l_attribute2_tab(i),

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

11350: l_nty_code_tab(i), l_fcg_code_tab(i), l_prc_code_tab(i),
11351: l_re_lease_yn_tab(i), l_prescribed_asset_yn_tab(i), l_credit_tenant_yn_tab(i),
11352: l_secured_deal_yn_tab(i), l_clg_id_tab(i), l_date_funding_tab(i),
11353: l_date_funding_required_tab(i), l_date_accepted_tab(i), l_date_delivery_expected_tab(i),
11354: l_oec_tab(i), l_capital_amount_tab(i), l_residual_grnty_amount_tab(i),
11355: l_residual_code_tab(i), l_rvi_premium_tab(i), l_credit_nature_tab(i),
11356: l_capitalized_interest_tab(i), l_capital_reduction_perce_tab(i), l_date_pay_investor_start_tab(i),
11357: l_pay_investor_frequency_tab(i), l_pay_investor_event_tab(i), l_pay_investor_remit_days_tab(i),
11358: l_fee_type_tab(i), l_subsidy_id_tab(i), l_subsidy_override_amount_tab(i),

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

11351: l_re_lease_yn_tab(i), l_prescribed_asset_yn_tab(i), l_credit_tenant_yn_tab(i),
11352: l_secured_deal_yn_tab(i), l_clg_id_tab(i), l_date_funding_tab(i),
11353: l_date_funding_required_tab(i), l_date_accepted_tab(i), l_date_delivery_expected_tab(i),
11354: l_oec_tab(i), l_capital_amount_tab(i), l_residual_grnty_amount_tab(i),
11355: l_residual_code_tab(i), l_rvi_premium_tab(i), l_credit_nature_tab(i),
11356: l_capitalized_interest_tab(i), l_capital_reduction_perce_tab(i), l_date_pay_investor_start_tab(i),
11357: l_pay_investor_frequency_tab(i), l_pay_investor_event_tab(i), l_pay_investor_remit_days_tab(i),
11358: l_fee_type_tab(i), l_subsidy_id_tab(i), l_subsidy_override_amount_tab(i),
11359: l_pre_tax_yield_tab(i), l_after_tax_yield_tab(i), l_implicit_interest_rate_tab(i),

Line 11398: 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));

11394: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_object_version_number_tab('||i||')=' || l_object_version_number_tab(i));
11395: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_lao_amount_tab('||i||')=' || l_lao_amount_tab(i));
11396: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_fee_charge_tab('||i||')=' || l_fee_charge_tab(i));
11397: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_title_date_tab('||i||')=' || l_title_date_tab(i));
11398: 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));
11399: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_last_reamortisatio_tab('||i||')=' || l_date_last_reamortisatio_tab(i));
11400: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_termination_purchase_am_tab('||i||')=' || l_termination_purchase_am_tab(i));
11401: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_last_cleanup_tab('||i||')=' || l_date_last_cleanup_tab(i));
11402: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_remarketed_amount_tab('||i||')=' || l_remarketed_amount_tab(i));

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

11406: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_repurchased_tab('||i||')=' || l_date_repurchased_tab(i));
11407: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_gain_loss_tab('||i||')=' || l_gain_loss_tab(i));
11408: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_floor_amount_tab('||i||')=' || l_floor_amount_tab(i));
11409: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_previous_contract_tab('||i||')=' || l_previous_contract_tab(i));
11410: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tracked_residual_tab('||i||')=' || l_tracked_residual_tab(i));
11411: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_title_received_tab('||i||')=' || l_date_title_received_tab(i));
11412: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_estimated_oec_tab('||i||')=' || l_estimated_oec_tab(i));
11413: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_residual_percentage_tab('||i||')=' || l_residual_percentage_tab(i));
11414: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_capital_reduction_tab('||i||')=' || l_capital_reduction_tab(i));

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

11409: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_previous_contract_tab('||i||')=' || l_previous_contract_tab(i));
11410: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tracked_residual_tab('||i||')=' || l_tracked_residual_tab(i));
11411: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_title_received_tab('||i||')=' || l_date_title_received_tab(i));
11412: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_estimated_oec_tab('||i||')=' || l_estimated_oec_tab(i));
11413: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_residual_percentage_tab('||i||')=' || l_residual_percentage_tab(i));
11414: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_capital_reduction_tab('||i||')=' || l_capital_reduction_tab(i));
11415: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_vendor_advance_paid_tab('||i||')=' || l_vendor_advance_paid_tab(i));
11416: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tradein_amount_tab('||i||')=' || l_tradein_amount_tab(i));
11417: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_delivered_date_tab('||i||')=' || l_delivered_date_tab(i));

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

11430: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_letter_acceptance_tab('||i||')=' || l_date_letter_acceptance_tab(i));
11431: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_commitment_expirat_tab('||i||')=' || l_date_commitment_expirat_tab(i));
11432: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_appraisal_tab('||i||')=' || l_date_appraisal_tab(i));
11433: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_appraisal_value_tab('||i||')=' || l_appraisal_value_tab(i));
11434: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_residual_value_tab('||i||')=' || l_residual_value_tab(i));
11435: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_percent_tab('||i||')=' || l_percent_tab(i));
11436: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_coverage_tab('||i||')=' || l_coverage_tab(i));
11437: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_lrv_amount_tab('||i||')=' || l_lrv_amount_tab(i));
11438: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_amount_tab('||i||')=' || l_amount_tab(i));

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

11479: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_accepted_tab('||i||')=' || l_date_accepted_tab(i));
11480: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_delivery_expected_tab('||i||')=' || l_date_delivery_expected_tab(i));
11481: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_oec_tab('||i||')=' || l_oec_tab(i));
11482: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_capital_amount_tab('||i||')=' || l_capital_amount_tab(i));
11483: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_residual_grnty_amount_tab('||i||')=' || l_residual_grnty_amount_tab(i));
11484: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_residual_code_tab('||i||')=' || l_residual_code_tab(i));
11485: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rvi_premium_tab('||i||')=' || l_rvi_premium_tab(i));
11486: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_credit_nature_tab('||i||')=' || l_credit_nature_tab(i));
11487: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_capitalized_interest_tab('||i||')=' || l_capitalized_interest_tab(i));

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

11480: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_date_delivery_expected_tab('||i||')=' || l_date_delivery_expected_tab(i));
11481: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_oec_tab('||i||')=' || l_oec_tab(i));
11482: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_capital_amount_tab('||i||')=' || l_capital_amount_tab(i));
11483: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_residual_grnty_amount_tab('||i||')=' || l_residual_grnty_amount_tab(i));
11484: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_residual_code_tab('||i||')=' || l_residual_code_tab(i));
11485: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rvi_premium_tab('||i||')=' || l_rvi_premium_tab(i));
11486: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_credit_nature_tab('||i||')=' || l_credit_nature_tab(i));
11487: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_capitalized_interest_tab('||i||')=' || l_capitalized_interest_tab(i));
11488: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_capital_reduction_perce_tab('||i||')=' || l_capital_reduction_perce_tab(i));

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

16622: a.attribute12, a.attribute13, a.attribute14,
16623: a.attribute15, a.created_by, a.creation_date,
16624: a.last_updated_by, a.last_update_date, a.last_update_login,
16625: a.depreciate_yn, a.hold_period_days, a.old_salvage_value,
16626: a.new_residual_value, a.old_residual_value, a.units_retired,
16627: a.cost_retired, a.sale_proceeds, a.removal_cost,
16628: a.dnz_asset_id, a.date_due, a.rep_asset_id,
16629: a.lke_asset_id, a.match_amount, a.split_into_singles_flag,
16630: a.split_into_units, a.currency_code, a.currency_conversion_type,

Line 16702: l_tbnew_residual_value_tab2 l_tbnew_residual_value_type;

16698: l_tblast_update_login_tab2 l_tblast_update_login_type;
16699: l_tbdepreciate_yn_tab2 l_tbdepreciate_yn_type;
16700: l_tbhold_period_days_tab2 l_tbhold_period_days_type;
16701: l_tbold_salvage_value_tab2 l_tbold_salvage_value_type;
16702: l_tbnew_residual_value_tab2 l_tbnew_residual_value_type;
16703: l_tbold_residual_value_tab2 l_tbold_residual_value_type;
16704: l_tbunits_retired_tab2 l_tbunits_retired_type;
16705: l_tbcost_retired_tab2 l_tbcost_retired_type;
16706: l_tbsale_proceeds_tab2 l_tbsale_proceeds_type;

Line 16703: l_tbold_residual_value_tab2 l_tbold_residual_value_type;

16699: l_tbdepreciate_yn_tab2 l_tbdepreciate_yn_type;
16700: l_tbhold_period_days_tab2 l_tbhold_period_days_type;
16701: l_tbold_salvage_value_tab2 l_tbold_salvage_value_type;
16702: l_tbnew_residual_value_tab2 l_tbnew_residual_value_type;
16703: l_tbold_residual_value_tab2 l_tbold_residual_value_type;
16704: l_tbunits_retired_tab2 l_tbunits_retired_type;
16705: l_tbcost_retired_tab2 l_tbcost_retired_type;
16706: l_tbsale_proceeds_tab2 l_tbsale_proceeds_type;
16707: l_tbremoval_cost_tab2 l_tbremoval_cost_type;

Line 16752: l_tbnew_residual_value_tab2, l_tbold_residual_value_tab2, l_tbunits_retired_tab2,

16748: l_tbattribute12_tab2, l_tbattribute13_tab2, l_tbattribute14_tab2,
16749: l_tbattribute15_tab2, l_tbcreated_by_tab2, l_tbcreation_date_tab2,
16750: l_tblast_updated_by_tab2, l_tblast_update_date_tab2, l_tblast_update_login_tab2,
16751: l_tbdepreciate_yn_tab2, l_tbhold_period_days_tab2, l_tbold_salvage_value_tab2,
16752: l_tbnew_residual_value_tab2, l_tbold_residual_value_tab2, l_tbunits_retired_tab2,
16753: l_tbcost_retired_tab2, l_tbsale_proceeds_tab2, l_tbremoval_cost_tab2,
16754: l_tbdnz_asset_id_tab2, l_tbdate_due_tab2, l_tbrep_asset_id_tab2,
16755: l_tblke_asset_id_tab2, l_tbmatch_amount_tab2, l_tbsplit_into_singles_fl_tab2,
16756: l_tbsplit_into_units_tab2, l_tbcurrency_code_tab2, l_tbcurrency_convers_type_tab2,

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

16861: l_tblast_update_login_tab(l_txl_assets_b_counter) := l_tblast_update_login_tab2(i);
16862: l_tbdepreciate_yn_tab(l_txl_assets_b_counter) := l_tbdepreciate_yn_tab2(i);
16863: l_tbhold_period_days_tab(l_txl_assets_b_counter) := l_tbhold_period_days_tab2(i);
16864: l_tbold_salvage_value_tab(l_txl_assets_b_counter) := l_tbold_salvage_value_tab2(i);
16865: l_tbnew_residual_value_tab(l_txl_assets_b_counter) := l_tbnew_residual_value_tab2(i);
16866: l_tbold_residual_value_tab(l_txl_assets_b_counter) := l_tbold_residual_value_tab2(i);
16867: l_tbunits_retired_tab(l_txl_assets_b_counter) := l_tbunits_retired_tab2(i);
16868: l_tbcost_retired_tab(l_txl_assets_b_counter) := l_tbcost_retired_tab2(i);
16869: l_tbsale_proceeds_tab(l_txl_assets_b_counter) := l_tbsale_proceeds_tab2(i);

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

16862: l_tbdepreciate_yn_tab(l_txl_assets_b_counter) := l_tbdepreciate_yn_tab2(i);
16863: l_tbhold_period_days_tab(l_txl_assets_b_counter) := l_tbhold_period_days_tab2(i);
16864: l_tbold_salvage_value_tab(l_txl_assets_b_counter) := l_tbold_salvage_value_tab2(i);
16865: l_tbnew_residual_value_tab(l_txl_assets_b_counter) := l_tbnew_residual_value_tab2(i);
16866: l_tbold_residual_value_tab(l_txl_assets_b_counter) := l_tbold_residual_value_tab2(i);
16867: l_tbunits_retired_tab(l_txl_assets_b_counter) := l_tbunits_retired_tab2(i);
16868: l_tbcost_retired_tab(l_txl_assets_b_counter) := l_tbcost_retired_tab2(i);
16869: l_tbsale_proceeds_tab(l_txl_assets_b_counter) := l_tbsale_proceeds_tab2(i);
16870: l_tbremoval_cost_tab(l_txl_assets_b_counter) := l_tbremoval_cost_tab2(i);

Line 16922: new_residual_value, old_residual_value, units_retired,

16918: attribute12, attribute13, attribute14,
16919: attribute15, created_by, creation_date,
16920: last_updated_by, last_update_date, last_update_login,
16921: depreciate_yn, hold_period_days, old_salvage_value,
16922: new_residual_value, old_residual_value, units_retired,
16923: cost_retired, sale_proceeds, removal_cost,
16924: dnz_asset_id, date_due, rep_asset_id,
16925: lke_asset_id, match_amount, split_into_singles_flag,
16926: split_into_units, currency_code, currency_conversion_type,

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

16945: l_tbattribute12_tab(i), l_tbattribute13_tab(i), l_tbattribute14_tab(i),
16946: l_tbattribute15_tab(i), l_created_by, SYSDATE,
16947: l_last_updated_by, SYSDATE, l_last_update_login,
16948: l_tbdepreciate_yn_tab(i), l_tbhold_period_days_tab(i), l_tbold_salvage_value_tab(i),
16949: l_tbnew_residual_value_tab(i), l_tbold_residual_value_tab(i), l_tbunits_retired_tab(i),
16950: l_tbcost_retired_tab(i), l_tbsale_proceeds_tab(i), l_tbremoval_cost_tab(i),
16951: l_tbdnz_asset_id_tab(i), l_tbdate_due_tab(i), l_tbrep_asset_id_tab(i),
16952: l_tblke_asset_id_tab(i), l_tbmatch_amount_tab(i), l_tbsplit_into_singles_fl_tab(i),
16953: l_tbsplit_into_units_tab(i), l_tbcurrency_code_tab(i), l_tbcurrency_convers_type_tab(i),

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

17043: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbattribute15_tab('||i||')=' || l_tbattribute15_tab(i));
17044: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbdepreciate_yn_tab('||i||')=' || l_tbdepreciate_yn_tab(i));
17045: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbhold_period_days_tab('||i||')=' || l_tbhold_period_days_tab(i));
17046: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbold_salvage_value_tab('||i||')=' || l_tbold_salvage_value_tab(i));
17047: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbnew_residual_value_tab('||i||')=' || l_tbnew_residual_value_tab(i));
17048: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbold_residual_value_tab('||i||')=' || l_tbold_residual_value_tab(i));
17049: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbunits_retired_tab('||i||')=' || l_tbunits_retired_tab(i));
17050: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbcost_retired_tab('||i||')=' || l_tbcost_retired_tab(i));
17051: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbsale_proceeds_tab('||i||')=' || l_tbsale_proceeds_tab(i));

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

17044: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbdepreciate_yn_tab('||i||')=' || l_tbdepreciate_yn_tab(i));
17045: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbhold_period_days_tab('||i||')=' || l_tbhold_period_days_tab(i));
17046: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbold_salvage_value_tab('||i||')=' || l_tbold_salvage_value_tab(i));
17047: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbnew_residual_value_tab('||i||')=' || l_tbnew_residual_value_tab(i));
17048: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbold_residual_value_tab('||i||')=' || l_tbold_residual_value_tab(i));
17049: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbunits_retired_tab('||i||')=' || l_tbunits_retired_tab(i));
17050: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbcost_retired_tab('||i||')=' || l_tbcost_retired_tab(i));
17051: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbsale_proceeds_tab('||i||')=' || l_tbsale_proceeds_tab(i));
17052: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tbremoval_cost_tab('||i||')=' || l_tbremoval_cost_tab(i));

Line 17527: FROM dual;

17523: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
17524: -- cursor to get sequence number for asset number
17525: CURSOR c_instance_no_ib IS
17526: SELECT TO_CHAR(OKL_IBN_SEQ.NEXTVAL)
17527: FROM dual;
17528: BEGIN
17529: OPEN c_instance_no_ib;
17530: FETCH c_instance_no_ib INTO x_instance_number_ib;
17531: IF (c_instance_no_ib%NOTFOUND) THEN

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

20668: l_sts_code_orig := c1rec.sts_code;
20669:
20670: l_curr_pos := 'okl_copy_lease_contract:4';
20671: -- kmotepal populating contract id from sys guid instead of using OKC sequence which fixes the bug 4436545 (Reverted back for OKL.H)
20672: SELECT okc_k_headers_b_s.NEXTVAL INTO l_copied_id FROM dual;
20673: --l_copied_id := okc_p_util.raw_to_number(sys_guid());
20674:
20675: l_contract_currency := c1rec.currency_code;
20676: l_contract_start_date := c1rec.start_date;