DBA Data[Home] [Help]

APPS.FARX_RP dependencies on FA_LOAD_TBL_PKG

Line 373: FA_LOAD_TBL_PKG.g_deprn_count := 0;

369: =========================================================================*/
370: IF (mr_rec.redefault_flag = 'YES') THEN
371: -- Depreciation rules will be redefaulted.
372: -- Reset g_deprn_count before loading the cache table.
373: FA_LOAD_TBL_PKG.g_deprn_count := 0;
374: -- Load depreciation rules table for the corporate book and all the
375: -- associated tax books for the new category.
376: -- Simulates caching effect.
377: FA_LOAD_TBL_PKG.Load_Deprn_Rules_Tbl(

Line 377: FA_LOAD_TBL_PKG.Load_Deprn_Rules_Tbl(

373: FA_LOAD_TBL_PKG.g_deprn_count := 0;
374: -- Load depreciation rules table for the corporate book and all the
375: -- associated tax books for the new category.
376: -- Simulates caching effect.
377: FA_LOAD_TBL_PKG.Load_Deprn_Rules_Tbl(
378: p_corp_book => mr_rec.book_type_code,
379: p_category_id => mr_rec.to_category_id,
380: x_return_status => h_status,
381: p_log_level_rec => g_log_level_rec);

Line 547: FA_LOAD_TBL_PKG.g_deprn_count := 0;

543: COMMIT WORK;
544:
545: IF (mr_rec.redefault_flag = 'YES') THEN
546: -- Reset g_deprn_count after completing mass reclass transaction.
547: FA_LOAD_TBL_PKG.g_deprn_count := 0;
548: END IF;
549:
550: /*=========================================================================
551: Fetch the preview records from the interface table and print them on

Line 581: FA_LOAD_TBL_PKG.g_deprn_count := 0;

577: WHEN mrcl_failure THEN
578: retcode := 2; -- Completed with error.
579:
580: -- Reset global variable values.
581: FA_LOAD_TBL_PKG.g_deprn_count := 0;
582: a_tbl.delete;
583: a_index := 0;
584: g_asset_count := 0;
585: --g_total_assets := 0;

Line 616: FA_LOAD_TBL_PKG.g_deprn_count := 0;

612: CALLING_FN => 'FARX_RP.Preview_Reclass');
613: END IF;
614:
615: -- Reset global variable values.
616: FA_LOAD_TBL_PKG.g_deprn_count := 0;
617: a_tbl.delete;
618: a_index := 0;
619: g_asset_count := 0;
620: --g_total_assets := 0;

Line 664: h_dummy_rules1 FA_LOAD_TBL_PKG.asset_deprn_info;

660: h_depreciate_flag VARCHAR2(3);
661: pos NUMBER;
662: h_dummy_bool1 BOOLEAN;
663: h_dummy_bool2 BOOLEAN;
664: h_dummy_rules1 FA_LOAD_TBL_PKG.asset_deprn_info;
665: h_dummy_rules2 FA_LOAD_TBL_PKG.asset_deprn_info;
666: h_dummy_date DATE;
667: h_dummy_char1 VARCHAR2(10);
668: h_dummy_char2 VARCHAR2(4);

Line 665: h_dummy_rules2 FA_LOAD_TBL_PKG.asset_deprn_info;

661: pos NUMBER;
662: h_dummy_bool1 BOOLEAN;
663: h_dummy_bool2 BOOLEAN;
664: h_dummy_rules1 FA_LOAD_TBL_PKG.asset_deprn_info;
665: h_dummy_rules2 FA_LOAD_TBL_PKG.asset_deprn_info;
666: h_dummy_date DATE;
667: h_dummy_char1 VARCHAR2(10);
668: h_dummy_char2 VARCHAR2(4);
669: store_failure EXCEPTION;

Line 795: FA_LOAD_TBL_PKG.Find_Position_Deprn_Rules(

791: -- Get new depreciation rules.
792:
793: -- First, get the index of the new depreciation rules record
794: -- from the depreciation table.
795: FA_LOAD_TBL_PKG.Find_Position_Deprn_Rules(
796: p_book_type_code => h_book_type_code,
797: p_date_placed_in_service => h_dpis,
798: x_pos => pos,
799: p_log_level_rec => g_log_level_rec);

Line 808: := FA_LOAD_TBL_PKG.deprn_table(pos).prorate_conv_code;

804: raise store_failure;
805: END IF;
806:
807: a_tbl(a_index).convention
808: := FA_LOAD_TBL_PKG.deprn_table(pos).prorate_conv_code;
809: a_tbl(a_index).ceiling
810: := FA_LOAD_TBL_PKG.deprn_table(pos).ceiling_name;
811: a_tbl(a_index).method
812: := FA_LOAD_TBL_PKG.deprn_table(pos).deprn_method;

Line 810: := FA_LOAD_TBL_PKG.deprn_table(pos).ceiling_name;

806:
807: a_tbl(a_index).convention
808: := FA_LOAD_TBL_PKG.deprn_table(pos).prorate_conv_code;
809: a_tbl(a_index).ceiling
810: := FA_LOAD_TBL_PKG.deprn_table(pos).ceiling_name;
811: a_tbl(a_index).method
812: := FA_LOAD_TBL_PKG.deprn_table(pos).deprn_method;
813: a_tbl(a_index).life_in_months
814: := FA_LOAD_TBL_PKG.deprn_table(pos).life_in_months;

Line 812: := FA_LOAD_TBL_PKG.deprn_table(pos).deprn_method;

808: := FA_LOAD_TBL_PKG.deprn_table(pos).prorate_conv_code;
809: a_tbl(a_index).ceiling
810: := FA_LOAD_TBL_PKG.deprn_table(pos).ceiling_name;
811: a_tbl(a_index).method
812: := FA_LOAD_TBL_PKG.deprn_table(pos).deprn_method;
813: a_tbl(a_index).life_in_months
814: := FA_LOAD_TBL_PKG.deprn_table(pos).life_in_months;
815: a_tbl(a_index).basic_rate
816: := FA_LOAD_TBL_PKG.deprn_table(pos).basic_rate;

Line 814: := FA_LOAD_TBL_PKG.deprn_table(pos).life_in_months;

810: := FA_LOAD_TBL_PKG.deprn_table(pos).ceiling_name;
811: a_tbl(a_index).method
812: := FA_LOAD_TBL_PKG.deprn_table(pos).deprn_method;
813: a_tbl(a_index).life_in_months
814: := FA_LOAD_TBL_PKG.deprn_table(pos).life_in_months;
815: a_tbl(a_index).basic_rate
816: := FA_LOAD_TBL_PKG.deprn_table(pos).basic_rate;
817: a_tbl(a_index).adjusted_rate
818: := FA_LOAD_TBL_PKG.deprn_table(pos).adjusted_rate;

Line 816: := FA_LOAD_TBL_PKG.deprn_table(pos).basic_rate;

812: := FA_LOAD_TBL_PKG.deprn_table(pos).deprn_method;
813: a_tbl(a_index).life_in_months
814: := FA_LOAD_TBL_PKG.deprn_table(pos).life_in_months;
815: a_tbl(a_index).basic_rate
816: := FA_LOAD_TBL_PKG.deprn_table(pos).basic_rate;
817: a_tbl(a_index).adjusted_rate
818: := FA_LOAD_TBL_PKG.deprn_table(pos).adjusted_rate;
819: a_tbl(a_index).bonus_rule
820: := FA_LOAD_TBL_PKG.deprn_table(pos).bonus_rule;

Line 818: := FA_LOAD_TBL_PKG.deprn_table(pos).adjusted_rate;

814: := FA_LOAD_TBL_PKG.deprn_table(pos).life_in_months;
815: a_tbl(a_index).basic_rate
816: := FA_LOAD_TBL_PKG.deprn_table(pos).basic_rate;
817: a_tbl(a_index).adjusted_rate
818: := FA_LOAD_TBL_PKG.deprn_table(pos).adjusted_rate;
819: a_tbl(a_index).bonus_rule
820: := FA_LOAD_TBL_PKG.deprn_table(pos).bonus_rule;
821: a_tbl(a_index).capacity
822: := FA_LOAD_TBL_PKG.deprn_table(pos).production_capacity;

Line 820: := FA_LOAD_TBL_PKG.deprn_table(pos).bonus_rule;

816: := FA_LOAD_TBL_PKG.deprn_table(pos).basic_rate;
817: a_tbl(a_index).adjusted_rate
818: := FA_LOAD_TBL_PKG.deprn_table(pos).adjusted_rate;
819: a_tbl(a_index).bonus_rule
820: := FA_LOAD_TBL_PKG.deprn_table(pos).bonus_rule;
821: a_tbl(a_index).capacity
822: := FA_LOAD_TBL_PKG.deprn_table(pos).production_capacity;
823: a_tbl(a_index).unit_of_measure
824: := FA_LOAD_TBL_PKG.deprn_table(pos).unit_of_measure;

Line 822: := FA_LOAD_TBL_PKG.deprn_table(pos).production_capacity;

818: := FA_LOAD_TBL_PKG.deprn_table(pos).adjusted_rate;
819: a_tbl(a_index).bonus_rule
820: := FA_LOAD_TBL_PKG.deprn_table(pos).bonus_rule;
821: a_tbl(a_index).capacity
822: := FA_LOAD_TBL_PKG.deprn_table(pos).production_capacity;
823: a_tbl(a_index).unit_of_measure
824: := FA_LOAD_TBL_PKG.deprn_table(pos).unit_of_measure;
825: -- We will not redefault depreciate flag through mass reclass.
826: a_tbl(a_index).depreciate_flag := h_depreciate_flag;

Line 824: := FA_LOAD_TBL_PKG.deprn_table(pos).unit_of_measure;

820: := FA_LOAD_TBL_PKG.deprn_table(pos).bonus_rule;
821: a_tbl(a_index).capacity
822: := FA_LOAD_TBL_PKG.deprn_table(pos).production_capacity;
823: a_tbl(a_index).unit_of_measure
824: := FA_LOAD_TBL_PKG.deprn_table(pos).unit_of_measure;
825: -- We will not redefault depreciate flag through mass reclass.
826: a_tbl(a_index).depreciate_flag := h_depreciate_flag;
827: a_tbl(a_index).allowed_deprn_limit
828: := FA_LOAD_TBL_PKG.deprn_table(pos).allow_deprn_limit;

Line 828: := FA_LOAD_TBL_PKG.deprn_table(pos).allow_deprn_limit;

824: := FA_LOAD_TBL_PKG.deprn_table(pos).unit_of_measure;
825: -- We will not redefault depreciate flag through mass reclass.
826: a_tbl(a_index).depreciate_flag := h_depreciate_flag;
827: a_tbl(a_index).allowed_deprn_limit
828: := FA_LOAD_TBL_PKG.deprn_table(pos).allow_deprn_limit;
829: a_tbl(a_index).deprn_limit_amt
830: := FA_LOAD_TBL_PKG.deprn_table(pos).deprn_limit_amount;
831: a_tbl(a_index).percent_salvage_val
832: := FA_LOAD_TBL_PKG.deprn_table(pos).percent_salvage_value;

Line 830: := FA_LOAD_TBL_PKG.deprn_table(pos).deprn_limit_amount;

826: a_tbl(a_index).depreciate_flag := h_depreciate_flag;
827: a_tbl(a_index).allowed_deprn_limit
828: := FA_LOAD_TBL_PKG.deprn_table(pos).allow_deprn_limit;
829: a_tbl(a_index).deprn_limit_amt
830: := FA_LOAD_TBL_PKG.deprn_table(pos).deprn_limit_amount;
831: a_tbl(a_index).percent_salvage_val
832: := FA_LOAD_TBL_PKG.deprn_table(pos).percent_salvage_value;
833:
834: -- Convert values using conversion_table, which caches

Line 832: := FA_LOAD_TBL_PKG.deprn_table(pos).percent_salvage_value;

828: := FA_LOAD_TBL_PKG.deprn_table(pos).allow_deprn_limit;
829: a_tbl(a_index).deprn_limit_amt
830: := FA_LOAD_TBL_PKG.deprn_table(pos).deprn_limit_amount;
831: a_tbl(a_index).percent_salvage_val
832: := FA_LOAD_TBL_PKG.deprn_table(pos).percent_salvage_value;
833:
834: -- Convert values using conversion_table, which caches
835: -- converted values of certain fields for the new rules.
836: -- (The corresponding converted record is stored in the