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.FA_MASSCP_PKG dependencies on FA_CACHE_PKG

Line 11: g_release number := fa_cache_pkg.fazarel_release;

7: G_fatal_error boolean := FALSE;
8: G_request_id number;
9: G_times_called number := 0;
10:
11: g_release number := fa_cache_pkg.fazarel_release;
12:
13: g_log_level_rec fa_api_types.log_level_rec_type;
14:
15: TYPE num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 150: g_release := fa_cache_pkg.fazarel_release;

146: raise masscp_err;
147: end if;
148: end if;
149:
150: g_release := fa_cache_pkg.fazarel_release;
151:
152: -- get book information
153: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code, p_log_level_rec => g_log_level_rec) then
154: raise masscp_err;

Line 153: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code, p_log_level_rec => g_log_level_rec) then

149:
150: g_release := fa_cache_pkg.fazarel_release;
151:
152: -- get book information
153: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code, p_log_level_rec => g_log_level_rec) then
154: raise masscp_err;
155: end if;
156:
157: if (g_times_called = 1) then

Line 159: if (fa_cache_pkg.fazcbc_record.copy_additions_flag <> 'YES') then

155: end if;
156:
157: if (g_times_called = 1) then
158:
159: if (fa_cache_pkg.fazcbc_record.copy_additions_flag <> 'YES') then
160: fnd_message.set_name('OFA', 'FA_MCP_SHARED_NO_COPY');
161: fnd_message.set_token('TYPE','ADDITIONS',FALSE);
162: l_string := fnd_message.get;
163: FND_FILE.put(FND_FILE.output,l_string);

Line 167: if (fa_cache_pkg.fazcbc_record.copy_adjustments_flag <> 'YES') then

163: FND_FILE.put(FND_FILE.output,l_string);
164: FND_FILE.new_line(FND_FILE.output,1);
165: end if;
166:
167: if (fa_cache_pkg.fazcbc_record.copy_adjustments_flag <> 'YES') then
168: fnd_message.set_name('OFA', 'FA_MCP_SHARED_NO_COPY');
169: fnd_message.set_token('TYPE','ADJUSTMENTS',FALSE);
170: l_string := fnd_message.get;
171: FND_FILE.put(FND_FILE.output,l_string);

Line 175: if (fa_cache_pkg.fazcbc_record.copy_retirements_flag <> 'YES') then

171: FND_FILE.put(FND_FILE.output,l_string);
172: FND_FILE.new_line(FND_FILE.output,1);
173: end if;
174:
175: if (fa_cache_pkg.fazcbc_record.copy_retirements_flag <> 'YES') then
176: fnd_message.set_name('OFA', 'FA_MCP_SHARED_NO_COPY');
177: fnd_message.set_token('TYPE','RETIREMENTS',FALSE);
178: l_string := fnd_message.get;
179: FND_FILE.put(FND_FILE.output,l_string);

Line 183: if (nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y' and

179: FND_FILE.put(FND_FILE.output,l_string);
180: FND_FILE.new_line(FND_FILE.output,1);
181: end if;
182:
183: if (nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y' and
184: nvl(fa_cache_pkg.fazcbc_record.copy_group_addition_flag, 'N') <> 'Y') then
185: fnd_message.set_name('OFA', 'FA_MCP_SHARED_NO_COPY');
186: fnd_message.set_token('TYPE','GROUP ADDITIONS',FALSE);
187: l_string := fnd_message.get;

Line 184: nvl(fa_cache_pkg.fazcbc_record.copy_group_addition_flag, 'N') <> 'Y') then

180: FND_FILE.new_line(FND_FILE.output,1);
181: end if;
182:
183: if (nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y' and
184: nvl(fa_cache_pkg.fazcbc_record.copy_group_addition_flag, 'N') <> 'Y') then
185: fnd_message.set_name('OFA', 'FA_MCP_SHARED_NO_COPY');
186: fnd_message.set_token('TYPE','GROUP ADDITIONS',FALSE);
187: l_string := fnd_message.get;
188: FND_FILE.put(FND_FILE.output,l_string);

Line 211: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);

207:
208: end if;
209:
210:
211: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);
212:
213: if(g_log_level_rec.statement_level) then
214: fa_debug_pkg.add(l_calling_fn, 'opening c_trx_parent cursor at', sysdate, p_log_level_rec => g_log_level_rec);
215: end if;

Line 377: fa_cache_pkg.fazcbc_record.distribution_source_book, p_log_level_rec => g_log_level_rec);

373: 'asset id ',
374: l_asset_id(l_loop_count));
375: fa_debug_pkg.add(l_calling_fn,
376: 'corp book',
377: fa_cache_pkg.fazcbc_record.distribution_source_book, p_log_level_rec => g_log_level_rec);
378: fa_debug_pkg.add(l_calling_fn,
379: 'start thid',
380: l_orig_src_trx_header_id, p_log_level_rec => g_log_level_rec);
381: fa_debug_pkg.add(l_calling_fn,

Line 388: p_corp_book => fa_cache_pkg.fazcbc_record.distribution_source_book,

384:
385: end if;
386:
387: open c_prior_adjs (p_asset_id => l_asset_id(l_loop_count),
388: p_corp_book => fa_cache_pkg.fazcbc_record.distribution_source_book,
389: p_start_thid => l_orig_src_trx_header_id,
390: p_end_thid => l_corp_thid(l_loop_count));
391:
392: fetch c_prior_adjs bulk collect

Line 736: if NOT fa_cache_pkg.fazcbc(X_book => p_tax_book, p_log_level_rec => g_log_level_rec) then

732: add_err2 EXCEPTION; -- fatal
733:
734: BEGIN
735:
736: if NOT fa_cache_pkg.fazcbc(X_book => p_tax_book, p_log_level_rec => g_log_level_rec) then
737: raise add_err1;
738: end if;
739:
740: if (p_asset_type = 'GROUP' and

Line 741: nvl(fa_cache_pkg.fazcbc_record.copy_group_addition_flag, 'N') = 'N') then

737: raise add_err1;
738: end if;
739:
740: if (p_asset_type = 'GROUP' and
741: nvl(fa_cache_pkg.fazcbc_record.copy_group_addition_flag, 'N') = 'N') then
742:
743: l_mesg_name := 'FA_MCP_SHARED_NO_COPY';
744: l_token := 'TYPE';
745: l_value := 'GROUP ADDITIONS';

Line 749: fa_cache_pkg.fazcbc_record.copy_additions_flag = 'NO') then

745: l_value := 'GROUP ADDITIONS';
746:
747: raise add_err1;
748: elsif (p_asset_type <> 'GROUP' and
749: fa_cache_pkg.fazcbc_record.copy_additions_flag = 'NO') then
750:
751: l_mesg_name := 'FA_MCP_SHARED_NO_COPY';
752: l_token := 'TYPE';
753: l_value := 'ADDITIONS';

Line 770: if not fa_cache_pkg.fazccb (

766: into l_category_id
767: from fa_additions_b
768: where asset_id = p_asset_id;
769:
770: if not fa_cache_pkg.fazccb (
771: X_Book => p_tax_book,
772: X_Cat_Id => l_category_id
773: , p_log_level_rec => g_log_level_rec) then
774: l_mesg_name := 'FA_MCP_CAT_NOT_IN_TAX';

Line 807: and corp_bk.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book

803: from fa_books corp_bk,
804: fa_deprn_periods dp,
805: fa_transaction_headers corp_th
806: where corp_bk.transaction_header_id_in = corp_th.transaction_header_id
807: and corp_bk.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
808: and corp_bk.asset_id = p_asset_id
809: and corp_bk.book_type_code = dp.book_type_code
810: and corp_bk.period_counter_capitalized = dp.period_counter
811: and corp_th.date_effective between

Line 883: and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book

879: l_asset_fin_rec.percent_salvage_value,
880: l_asset_fin_rec.salvage_value
881: from fa_books
882: where asset_id = p_asset_id
883: and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
884: and transaction_header_id_in = p_corp_thid;
885:
886: -- set the group asset and salvage information according to options
887: -- selected in book controls. last option will force null inside the addition api

Line 889: if (nvl(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag, 'N') = 'N') then

885:
886: -- set the group asset and salvage information according to options
887: -- selected in book controls. last option will force null inside the addition api
888:
889: if (nvl(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag, 'N') = 'N') then
890: l_asset_fin_rec.group_asset_id := null;
891: end if;
892:
893: if (nvl(fa_cache_pkg.fazcbc_record.copy_salvage_value_flag, 'NO') = 'NO') then

Line 893: if (nvl(fa_cache_pkg.fazcbc_record.copy_salvage_value_flag, 'NO') = 'NO') then

889: if (nvl(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag, 'N') = 'N') then
890: l_asset_fin_rec.group_asset_id := null;
891: end if;
892:
893: if (nvl(fa_cache_pkg.fazcbc_record.copy_salvage_value_flag, 'NO') = 'NO') then
894: l_asset_fin_rec.salvage_type := null;
895: l_asset_fin_rec.percent_salvage_value := null;
896: l_asset_fin_rec.salvage_value := null;
897: end if;

Line 905: l_corp_asset_hdr_rec.book_type_code := fa_cache_pkg.fazcbc_record.distribution_source_book;

901: -- change this
902:
903: if (p_asset_type = 'GROUP') then
904: l_corp_asset_hdr_rec.asset_id := p_asset_id;
905: l_corp_asset_hdr_rec.book_type_code := fa_cache_pkg.fazcbc_record.distribution_source_book;
906:
907: if not FA_UTIL_PVT.get_asset_fin_rec
908: (p_asset_hdr_rec => l_corp_asset_hdr_rec,
909: px_asset_fin_rec => l_corp_asset_fin_rec,

Line 931: if not fa_cache_pkg.fazccbd (X_book => p_tax_book,

927: l_asset_fin_rec.cost := 0;
928: --HH add disabled_flag as null
929: l_asset_fin_rec.disabled_flag := NULL;
930:
931: if not fa_cache_pkg.fazccbd (X_book => p_tax_book,
932: X_cat_id => l_category_id,
933: X_jdpis => to_number(to_char(l_asset_fin_rec.date_placed_in_service, 'J')),
934: p_log_level_rec => g_log_level_rec) then
935: raise add_err1;

Line 938: if fa_cache_pkg.fazccbd_record.recognize_gain_loss is not null or

934: p_log_level_rec => g_log_level_rec) then
935: raise add_err1;
936: end if;
937:
938: if fa_cache_pkg.fazccbd_record.recognize_gain_loss is not null or
939: fa_cache_pkg.fazccbd_record.terminal_gain_loss is not null or
940: fa_cache_pkg.fazccbd_record.tracking_method is not null or
941: fa_cache_pkg.fazccbd_record.excess_allocation_option is not null or
942: fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag is not null or

Line 939: fa_cache_pkg.fazccbd_record.terminal_gain_loss is not null or

935: raise add_err1;
936: end if;
937:
938: if fa_cache_pkg.fazccbd_record.recognize_gain_loss is not null or
939: fa_cache_pkg.fazccbd_record.terminal_gain_loss is not null or
940: fa_cache_pkg.fazccbd_record.tracking_method is not null or
941: fa_cache_pkg.fazccbd_record.excess_allocation_option is not null or
942: fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag is not null or
943: fa_cache_pkg.fazccbd_record.Recapture_Reserve_Flag is not null or

Line 940: fa_cache_pkg.fazccbd_record.tracking_method is not null or

936: end if;
937:
938: if fa_cache_pkg.fazccbd_record.recognize_gain_loss is not null or
939: fa_cache_pkg.fazccbd_record.terminal_gain_loss is not null or
940: fa_cache_pkg.fazccbd_record.tracking_method is not null or
941: fa_cache_pkg.fazccbd_record.excess_allocation_option is not null or
942: fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag is not null or
943: fa_cache_pkg.fazccbd_record.Recapture_Reserve_Flag is not null or
944: fa_cache_pkg.fazccbd_record.LIMIT_PROCEEDS_FLAG is not null or

Line 941: fa_cache_pkg.fazccbd_record.excess_allocation_option is not null or

937:
938: if fa_cache_pkg.fazccbd_record.recognize_gain_loss is not null or
939: fa_cache_pkg.fazccbd_record.terminal_gain_loss is not null or
940: fa_cache_pkg.fazccbd_record.tracking_method is not null or
941: fa_cache_pkg.fazccbd_record.excess_allocation_option is not null or
942: fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag is not null or
943: fa_cache_pkg.fazccbd_record.Recapture_Reserve_Flag is not null or
944: fa_cache_pkg.fazccbd_record.LIMIT_PROCEEDS_FLAG is not null or
945: fa_cache_pkg.fazccbd_record.member_rollup_flag is not null or

Line 942: fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag is not null or

938: if fa_cache_pkg.fazccbd_record.recognize_gain_loss is not null or
939: fa_cache_pkg.fazccbd_record.terminal_gain_loss is not null or
940: fa_cache_pkg.fazccbd_record.tracking_method is not null or
941: fa_cache_pkg.fazccbd_record.excess_allocation_option is not null or
942: fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag is not null or
943: fa_cache_pkg.fazccbd_record.Recapture_Reserve_Flag is not null or
944: fa_cache_pkg.fazccbd_record.LIMIT_PROCEEDS_FLAG is not null or
945: fa_cache_pkg.fazccbd_record.member_rollup_flag is not null or
946: fa_cache_pkg.fazccbd_record.depreciation_option is not null then

Line 943: fa_cache_pkg.fazccbd_record.Recapture_Reserve_Flag is not null or

939: fa_cache_pkg.fazccbd_record.terminal_gain_loss is not null or
940: fa_cache_pkg.fazccbd_record.tracking_method is not null or
941: fa_cache_pkg.fazccbd_record.excess_allocation_option is not null or
942: fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag is not null or
943: fa_cache_pkg.fazccbd_record.Recapture_Reserve_Flag is not null or
944: fa_cache_pkg.fazccbd_record.LIMIT_PROCEEDS_FLAG is not null or
945: fa_cache_pkg.fazccbd_record.member_rollup_flag is not null or
946: fa_cache_pkg.fazccbd_record.depreciation_option is not null then
947:

Line 944: fa_cache_pkg.fazccbd_record.LIMIT_PROCEEDS_FLAG is not null or

940: fa_cache_pkg.fazccbd_record.tracking_method is not null or
941: fa_cache_pkg.fazccbd_record.excess_allocation_option is not null or
942: fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag is not null or
943: fa_cache_pkg.fazccbd_record.Recapture_Reserve_Flag is not null or
944: fa_cache_pkg.fazccbd_record.LIMIT_PROCEEDS_FLAG is not null or
945: fa_cache_pkg.fazccbd_record.member_rollup_flag is not null or
946: fa_cache_pkg.fazccbd_record.depreciation_option is not null then
947:
948: l_asset_fin_rec.recognize_gain_loss := fa_cache_pkg.fazccbd_record.recognize_gain_loss;

Line 945: fa_cache_pkg.fazccbd_record.member_rollup_flag is not null or

941: fa_cache_pkg.fazccbd_record.excess_allocation_option is not null or
942: fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag is not null or
943: fa_cache_pkg.fazccbd_record.Recapture_Reserve_Flag is not null or
944: fa_cache_pkg.fazccbd_record.LIMIT_PROCEEDS_FLAG is not null or
945: fa_cache_pkg.fazccbd_record.member_rollup_flag is not null or
946: fa_cache_pkg.fazccbd_record.depreciation_option is not null then
947:
948: l_asset_fin_rec.recognize_gain_loss := fa_cache_pkg.fazccbd_record.recognize_gain_loss;
949: l_asset_fin_rec.recapture_reserve_flag := fa_cache_pkg.fazccbd_record.recapture_reserve_flag;

Line 946: fa_cache_pkg.fazccbd_record.depreciation_option is not null then

942: fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag is not null or
943: fa_cache_pkg.fazccbd_record.Recapture_Reserve_Flag is not null or
944: fa_cache_pkg.fazccbd_record.LIMIT_PROCEEDS_FLAG is not null or
945: fa_cache_pkg.fazccbd_record.member_rollup_flag is not null or
946: fa_cache_pkg.fazccbd_record.depreciation_option is not null then
947:
948: l_asset_fin_rec.recognize_gain_loss := fa_cache_pkg.fazccbd_record.recognize_gain_loss;
949: l_asset_fin_rec.recapture_reserve_flag := fa_cache_pkg.fazccbd_record.recapture_reserve_flag;
950: l_asset_fin_rec.limit_proceeds_flag := fa_cache_pkg.fazccbd_record.limit_proceeds_flag;

Line 948: l_asset_fin_rec.recognize_gain_loss := fa_cache_pkg.fazccbd_record.recognize_gain_loss;

944: fa_cache_pkg.fazccbd_record.LIMIT_PROCEEDS_FLAG is not null or
945: fa_cache_pkg.fazccbd_record.member_rollup_flag is not null or
946: fa_cache_pkg.fazccbd_record.depreciation_option is not null then
947:
948: l_asset_fin_rec.recognize_gain_loss := fa_cache_pkg.fazccbd_record.recognize_gain_loss;
949: l_asset_fin_rec.recapture_reserve_flag := fa_cache_pkg.fazccbd_record.recapture_reserve_flag;
950: l_asset_fin_rec.limit_proceeds_flag := fa_cache_pkg.fazccbd_record.limit_proceeds_flag;
951: l_asset_fin_rec.terminal_gain_loss := fa_cache_pkg.fazccbd_record.terminal_gain_loss;
952: l_asset_fin_rec.tracking_method := fa_cache_pkg.fazccbd_record.tracking_method;

Line 949: l_asset_fin_rec.recapture_reserve_flag := fa_cache_pkg.fazccbd_record.recapture_reserve_flag;

945: fa_cache_pkg.fazccbd_record.member_rollup_flag is not null or
946: fa_cache_pkg.fazccbd_record.depreciation_option is not null then
947:
948: l_asset_fin_rec.recognize_gain_loss := fa_cache_pkg.fazccbd_record.recognize_gain_loss;
949: l_asset_fin_rec.recapture_reserve_flag := fa_cache_pkg.fazccbd_record.recapture_reserve_flag;
950: l_asset_fin_rec.limit_proceeds_flag := fa_cache_pkg.fazccbd_record.limit_proceeds_flag;
951: l_asset_fin_rec.terminal_gain_loss := fa_cache_pkg.fazccbd_record.terminal_gain_loss;
952: l_asset_fin_rec.tracking_method := fa_cache_pkg.fazccbd_record.tracking_method;
953: l_asset_fin_rec.allocate_to_fully_rsv_flag := fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag;

Line 950: l_asset_fin_rec.limit_proceeds_flag := fa_cache_pkg.fazccbd_record.limit_proceeds_flag;

946: fa_cache_pkg.fazccbd_record.depreciation_option is not null then
947:
948: l_asset_fin_rec.recognize_gain_loss := fa_cache_pkg.fazccbd_record.recognize_gain_loss;
949: l_asset_fin_rec.recapture_reserve_flag := fa_cache_pkg.fazccbd_record.recapture_reserve_flag;
950: l_asset_fin_rec.limit_proceeds_flag := fa_cache_pkg.fazccbd_record.limit_proceeds_flag;
951: l_asset_fin_rec.terminal_gain_loss := fa_cache_pkg.fazccbd_record.terminal_gain_loss;
952: l_asset_fin_rec.tracking_method := fa_cache_pkg.fazccbd_record.tracking_method;
953: l_asset_fin_rec.allocate_to_fully_rsv_flag := fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag;
954: l_asset_fin_rec.allocate_to_fully_ret_flag := fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag;

Line 951: l_asset_fin_rec.terminal_gain_loss := fa_cache_pkg.fazccbd_record.terminal_gain_loss;

947:
948: l_asset_fin_rec.recognize_gain_loss := fa_cache_pkg.fazccbd_record.recognize_gain_loss;
949: l_asset_fin_rec.recapture_reserve_flag := fa_cache_pkg.fazccbd_record.recapture_reserve_flag;
950: l_asset_fin_rec.limit_proceeds_flag := fa_cache_pkg.fazccbd_record.limit_proceeds_flag;
951: l_asset_fin_rec.terminal_gain_loss := fa_cache_pkg.fazccbd_record.terminal_gain_loss;
952: l_asset_fin_rec.tracking_method := fa_cache_pkg.fazccbd_record.tracking_method;
953: l_asset_fin_rec.allocate_to_fully_rsv_flag := fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag;
954: l_asset_fin_rec.allocate_to_fully_ret_flag := fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag;
955: l_asset_fin_rec.excess_allocation_option := fa_cache_pkg.fazccbd_record.excess_allocation_option;

Line 952: l_asset_fin_rec.tracking_method := fa_cache_pkg.fazccbd_record.tracking_method;

948: l_asset_fin_rec.recognize_gain_loss := fa_cache_pkg.fazccbd_record.recognize_gain_loss;
949: l_asset_fin_rec.recapture_reserve_flag := fa_cache_pkg.fazccbd_record.recapture_reserve_flag;
950: l_asset_fin_rec.limit_proceeds_flag := fa_cache_pkg.fazccbd_record.limit_proceeds_flag;
951: l_asset_fin_rec.terminal_gain_loss := fa_cache_pkg.fazccbd_record.terminal_gain_loss;
952: l_asset_fin_rec.tracking_method := fa_cache_pkg.fazccbd_record.tracking_method;
953: l_asset_fin_rec.allocate_to_fully_rsv_flag := fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag;
954: l_asset_fin_rec.allocate_to_fully_ret_flag := fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag;
955: l_asset_fin_rec.excess_allocation_option := fa_cache_pkg.fazccbd_record.excess_allocation_option;
956: l_asset_fin_rec.depreciation_option := fa_cache_pkg.fazccbd_record.depreciation_option;

Line 953: l_asset_fin_rec.allocate_to_fully_rsv_flag := fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag;

949: l_asset_fin_rec.recapture_reserve_flag := fa_cache_pkg.fazccbd_record.recapture_reserve_flag;
950: l_asset_fin_rec.limit_proceeds_flag := fa_cache_pkg.fazccbd_record.limit_proceeds_flag;
951: l_asset_fin_rec.terminal_gain_loss := fa_cache_pkg.fazccbd_record.terminal_gain_loss;
952: l_asset_fin_rec.tracking_method := fa_cache_pkg.fazccbd_record.tracking_method;
953: l_asset_fin_rec.allocate_to_fully_rsv_flag := fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag;
954: l_asset_fin_rec.allocate_to_fully_ret_flag := fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag;
955: l_asset_fin_rec.excess_allocation_option := fa_cache_pkg.fazccbd_record.excess_allocation_option;
956: l_asset_fin_rec.depreciation_option := fa_cache_pkg.fazccbd_record.depreciation_option;
957: l_asset_fin_rec.member_rollup_flag := fa_cache_pkg.fazccbd_record.member_rollup_flag;

Line 954: l_asset_fin_rec.allocate_to_fully_ret_flag := fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag;

950: l_asset_fin_rec.limit_proceeds_flag := fa_cache_pkg.fazccbd_record.limit_proceeds_flag;
951: l_asset_fin_rec.terminal_gain_loss := fa_cache_pkg.fazccbd_record.terminal_gain_loss;
952: l_asset_fin_rec.tracking_method := fa_cache_pkg.fazccbd_record.tracking_method;
953: l_asset_fin_rec.allocate_to_fully_rsv_flag := fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag;
954: l_asset_fin_rec.allocate_to_fully_ret_flag := fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag;
955: l_asset_fin_rec.excess_allocation_option := fa_cache_pkg.fazccbd_record.excess_allocation_option;
956: l_asset_fin_rec.depreciation_option := fa_cache_pkg.fazccbd_record.depreciation_option;
957: l_asset_fin_rec.member_rollup_flag := fa_cache_pkg.fazccbd_record.member_rollup_flag;
958: l_asset_fin_rec.exclude_fully_rsv_flag := l_corp_asset_fin_rec.exclude_fully_rsv_flag;

Line 955: l_asset_fin_rec.excess_allocation_option := fa_cache_pkg.fazccbd_record.excess_allocation_option;

951: l_asset_fin_rec.terminal_gain_loss := fa_cache_pkg.fazccbd_record.terminal_gain_loss;
952: l_asset_fin_rec.tracking_method := fa_cache_pkg.fazccbd_record.tracking_method;
953: l_asset_fin_rec.allocate_to_fully_rsv_flag := fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag;
954: l_asset_fin_rec.allocate_to_fully_ret_flag := fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag;
955: l_asset_fin_rec.excess_allocation_option := fa_cache_pkg.fazccbd_record.excess_allocation_option;
956: l_asset_fin_rec.depreciation_option := fa_cache_pkg.fazccbd_record.depreciation_option;
957: l_asset_fin_rec.member_rollup_flag := fa_cache_pkg.fazccbd_record.member_rollup_flag;
958: l_asset_fin_rec.exclude_fully_rsv_flag := l_corp_asset_fin_rec.exclude_fully_rsv_flag;
959: else

Line 956: l_asset_fin_rec.depreciation_option := fa_cache_pkg.fazccbd_record.depreciation_option;

952: l_asset_fin_rec.tracking_method := fa_cache_pkg.fazccbd_record.tracking_method;
953: l_asset_fin_rec.allocate_to_fully_rsv_flag := fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag;
954: l_asset_fin_rec.allocate_to_fully_ret_flag := fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag;
955: l_asset_fin_rec.excess_allocation_option := fa_cache_pkg.fazccbd_record.excess_allocation_option;
956: l_asset_fin_rec.depreciation_option := fa_cache_pkg.fazccbd_record.depreciation_option;
957: l_asset_fin_rec.member_rollup_flag := fa_cache_pkg.fazccbd_record.member_rollup_flag;
958: l_asset_fin_rec.exclude_fully_rsv_flag := l_corp_asset_fin_rec.exclude_fully_rsv_flag;
959: else
960: l_asset_fin_rec.recognize_gain_loss := l_corp_asset_fin_rec.recognize_gain_loss;

Line 957: l_asset_fin_rec.member_rollup_flag := fa_cache_pkg.fazccbd_record.member_rollup_flag;

953: l_asset_fin_rec.allocate_to_fully_rsv_flag := fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag;
954: l_asset_fin_rec.allocate_to_fully_ret_flag := fa_cache_pkg.fazccbd_record.allocate_to_fully_rsv_flag;
955: l_asset_fin_rec.excess_allocation_option := fa_cache_pkg.fazccbd_record.excess_allocation_option;
956: l_asset_fin_rec.depreciation_option := fa_cache_pkg.fazccbd_record.depreciation_option;
957: l_asset_fin_rec.member_rollup_flag := fa_cache_pkg.fazccbd_record.member_rollup_flag;
958: l_asset_fin_rec.exclude_fully_rsv_flag := l_corp_asset_fin_rec.exclude_fully_rsv_flag;
959: else
960: l_asset_fin_rec.recognize_gain_loss := l_corp_asset_fin_rec.recognize_gain_loss;
961: l_asset_fin_rec.recapture_reserve_flag := l_corp_asset_fin_rec.recapture_reserve_flag;

Line 1250: if NOT fa_cache_pkg.fazcbc(X_book => p_tax_book, p_log_level_rec => g_log_level_rec) then

1246: and ref.trx_reference_id = th.trx_reference_id;
1247:
1248: BEGIN
1249:
1250: if NOT fa_cache_pkg.fazcbc(X_book => p_tax_book, p_log_level_rec => g_log_level_rec) then
1251: raise adj_err1;
1252: end if;
1253:
1254: -- get the copy absolute cost profile option

Line 1313: if (l_trx_date_entered > fa_cache_pkg.fazcdp_record.calendar_period_close_date) then

1309: -- current period note that the tax period was the last one
1310: -- loaded into the deprn period cache via the call to
1311: -- get_deprn_period above.
1312:
1313: if (l_trx_date_entered > fa_cache_pkg.fazcdp_record.calendar_period_close_date) then
1314: l_mesg_name := 'FA_MCP_SHARED_FUTURE_COPY';
1315:
1316: raise adj_err1;
1317: end if;

Line 1326: if (fa_cache_pkg.fazcbc_record.copy_adjustments_flag = 'NO' and

1322: l_corp_old_cost;
1323: l_delta_capacity := nvl(l_corp_new_capacity,0) -
1324: nvl(l_corp_old_capacity,0);
1325:
1326: if (fa_cache_pkg.fazcbc_record.copy_adjustments_flag = 'NO' and
1327: l_delta_capacity = 0) then
1328:
1329: l_mesg_name := 'FA_MCP_SHARED_NO_COPY';
1330: l_token := 'TYPE';

Line 1338: fa_cache_pkg.fazcbc_record.amortize_flag = 'NO' and

1334: end if;
1335:
1336:
1337: if(l_trx_subtype = 'AMORTIZED' and
1338: fa_cache_pkg.fazcbc_record.amortize_flag = 'NO' and
1339: l_delta_capacity = 0) then
1340:
1341: l_mesg_name := 'FA_MCP_SHARED_NO_COPY';
1342: l_token := 'TYPE';

Line 1351: -- fa_cache_pkg.fazcbc_record.amortize_flag = 'NO' - should we check for this?

1347:
1348: -- =====================================================================
1349: -- MacDonald's ER
1350: -- we force the sub type to EXPENSED if it is AMORTIZED and the copy flag is set
1351: -- fa_cache_pkg.fazcbc_record.amortize_flag = 'NO' - should we check for this?
1352: --
1353: if(l_trx_subtype = 'AMORTIZED' and
1354: NVL(fa_cache_pkg.fazcbc_record.copy_amort_adaj_exp_flag,'N') = 'Y' AND
1355: fa_cache_pkg.fazcbc_record.copy_adjustments_flag = 'YES' ) then

Line 1354: NVL(fa_cache_pkg.fazcbc_record.copy_amort_adaj_exp_flag,'N') = 'Y' AND

1350: -- we force the sub type to EXPENSED if it is AMORTIZED and the copy flag is set
1351: -- fa_cache_pkg.fazcbc_record.amortize_flag = 'NO' - should we check for this?
1352: --
1353: if(l_trx_subtype = 'AMORTIZED' and
1354: NVL(fa_cache_pkg.fazcbc_record.copy_amort_adaj_exp_flag,'N') = 'Y' AND
1355: fa_cache_pkg.fazcbc_record.copy_adjustments_flag = 'YES' ) then
1356: l_trx_subtype := 'EXPENSED';
1357: end if;
1358: -- =======================================================================

Line 1355: fa_cache_pkg.fazcbc_record.copy_adjustments_flag = 'YES' ) then

1351: -- fa_cache_pkg.fazcbc_record.amortize_flag = 'NO' - should we check for this?
1352: --
1353: if(l_trx_subtype = 'AMORTIZED' and
1354: NVL(fa_cache_pkg.fazcbc_record.copy_amort_adaj_exp_flag,'N') = 'Y' AND
1355: fa_cache_pkg.fazcbc_record.copy_adjustments_flag = 'YES' ) then
1356: l_trx_subtype := 'EXPENSED';
1357: end if;
1358: -- =======================================================================
1359:

Line 1495: if (nvl(fa_cache_pkg.fazcbc_record.copy_salvage_value_flag, 'NO') = 'NO') then

1491: -- Cannot copy SV adjustments where CORP SV before adj <> TAX SV
1492: -- modified for group enhancements to account for changes
1493: -- in type and percentage as well
1494:
1495: if (nvl(fa_cache_pkg.fazcbc_record.copy_salvage_value_flag, 'NO') = 'NO') then
1496:
1497: if ((l_delta_cost = 0) and
1498: (l_delta_capacity = 0) and
1499: (l_salvage_change)) then

Line 1539: if not fa_cache_pkg.fazccmt

1535: -- Cannot copy adjustments where corp method is prod, but tax is not
1536: -- a prod method
1537:
1538: -- Get rsr for old corp deprn_method
1539: if not fa_cache_pkg.fazccmt
1540: (X_method => l_corp_old_deprn_method_code,
1541: X_life => l_corp_old_life
1542: , p_log_level_rec => g_log_level_rec) then
1543: l_mesg_name := 'FA_MCP_FAIL_THID';

Line 1547: l_corp_old_rsr := fa_cache_pkg.fazccmt_record.rate_source_rule;

1543: l_mesg_name := 'FA_MCP_FAIL_THID';
1544: raise val_err1;
1545: end if;
1546:
1547: l_corp_old_rsr := fa_cache_pkg.fazccmt_record.rate_source_rule;
1548:
1549: -- Get rsr for new corp deprn_method
1550: if not fa_cache_pkg.fazccmt
1551: (X_method => l_corp_new_deprn_method_code,

Line 1550: if not fa_cache_pkg.fazccmt

1546:
1547: l_corp_old_rsr := fa_cache_pkg.fazccmt_record.rate_source_rule;
1548:
1549: -- Get rsr for new corp deprn_method
1550: if not fa_cache_pkg.fazccmt
1551: (X_method => l_corp_new_deprn_method_code,
1552: X_life => l_corp_new_life
1553: , p_log_level_rec => g_log_level_rec) then
1554: l_mesg_name := 'FA_MCP_FAIL_THID';

Line 1558: l_corp_new_rsr := fa_cache_pkg.fazccmt_record.rate_source_rule;

1554: l_mesg_name := 'FA_MCP_FAIL_THID';
1555: raise val_err1;
1556: end if;
1557:
1558: l_corp_new_rsr := fa_cache_pkg.fazccmt_record.rate_source_rule;
1559:
1560: -- Get rsr for tax.deprn_method
1561: if not fa_cache_pkg.fazccmt
1562: (X_method => l_tax_deprn_method_code,

Line 1561: if not fa_cache_pkg.fazccmt

1557:
1558: l_corp_new_rsr := fa_cache_pkg.fazccmt_record.rate_source_rule;
1559:
1560: -- Get rsr for tax.deprn_method
1561: if not fa_cache_pkg.fazccmt
1562: (X_method => l_tax_deprn_method_code,
1563: X_life => l_tax_life
1564: , p_log_level_rec => g_log_level_rec) then
1565: l_mesg_name := 'FA_MCP_FAIL_THID';

Line 1569: l_tax_rsr := fa_cache_pkg.fazccmt_record.rate_source_rule;

1565: l_mesg_name := 'FA_MCP_FAIL_THID';
1566: raise val_err1;
1567: end if;
1568:
1569: l_tax_rsr := fa_cache_pkg.fazccmt_record.rate_source_rule;
1570:
1571:
1572: -- Cannot copy adjustments that are not cost adjustments,
1573: -- OR salvage value adjustments

Line 1608: if (fa_cache_pkg.fazcbc_record.amortize_flag = 'NO' and

1604: -- CAPACITY ADJUSTMENT COPY TO CONTINUE IF THEY FAIL
1605: -- (valid = INVALID, capacity_adj_flag = TRUE)
1606:
1607: -- Amortized adjustments are not allowed in TAX book
1608: if (fa_cache_pkg.fazcbc_record.amortize_flag = 'NO' and
1609: l_trx_subtype = 'AMORTIZED') then
1610:
1611: l_mesg_name := 'FA_MCP_NO_AMORT_ADJS';
1612: l_trx_subtype := 'EXPENSED';

Line 1664: if (nvl(fa_cache_pkg.fazcbc_record.copy_group_change_flag, 'N') = 'N' ) then

1660:
1661: end if;
1662:
1663: if (l_group_change) then
1664: if (nvl(fa_cache_pkg.fazcbc_record.copy_group_change_flag, 'N') = 'N' ) then
1665: l_mesg_name := 'FA_MCP_SHARED_NO_COPY';
1666: l_token := 'TYPE';
1667: l_value := 'GROUP CHANGE ADJUSTMENTS';
1668: raise val_err1;

Line 2004: if NOT fa_cache_pkg.fazcbc(X_book => p_tax_book, p_log_level_rec => g_log_level_rec) then

2000: and ad.asset_id = corp_th.asset_id;
2001:
2002: BEGIN
2003:
2004: if NOT fa_cache_pkg.fazcbc(X_book => p_tax_book, p_log_level_rec => g_log_level_rec) then
2005: raise ret_err1;
2006: end if;
2007:
2008: if (fa_cache_pkg.fazcbc_record.copy_retirements_flag = 'NO') then

Line 2008: if (fa_cache_pkg.fazcbc_record.copy_retirements_flag = 'NO') then

2004: if NOT fa_cache_pkg.fazcbc(X_book => p_tax_book, p_log_level_rec => g_log_level_rec) then
2005: raise ret_err1;
2006: end if;
2007:
2008: if (fa_cache_pkg.fazcbc_record.copy_retirements_flag = 'NO') then
2009:
2010: l_mesg_name := 'FA_MCP_SHARED_NO_COPY';
2011: l_token := 'TYPE';
2012: l_value := 'RETIREMENTS';

Line 2032: p_corp_book => fa_cache_pkg.fazcbc_record.distribution_source_book);

2028: -- get basic info including corp ret info and tax cost, etc
2029: open c_retirement(p_asset_id => p_asset_id,
2030: p_corp_thid => p_corp_thid,
2031: p_tax_book => p_tax_book,
2032: p_corp_book => fa_cache_pkg.fazcbc_record.distribution_source_book);
2033:
2034: fetch c_retirement
2035: into l_trx_date_entered,
2036: l_date_effective,

Line 2075: if (l_trx_date_entered > fa_cache_pkg.fazcdp_record.calendar_period_close_date) then

2071: -- current period note that the tax period was the last one
2072: -- loaded into the deprn period cache via the call to
2073: -- get_deprn_period above.
2074:
2075: if (l_trx_date_entered > fa_cache_pkg.fazcdp_record.calendar_period_close_date) then
2076: l_mesg_name := 'FA_MCP_SHARED_FUTURE_COPY';
2077:
2078: raise ret_err1;
2079: end if;

Line 2090: if not fa_cache_pkg.fazccbd (X_book => p_tax_book,

2086:
2087: -- call the category cache
2088: l_jdpis := to_number(to_char(l_tax_dpis, 'J'));
2089:
2090: if not fa_cache_pkg.fazccbd (X_book => p_tax_book,
2091: X_cat_id => l_category_id,
2092: X_jdpis => l_jdpis, p_log_level_rec => g_log_level_rec) then
2093: l_mesg_name := 'FA_MCP_FAIL_THID';
2094: raise ret_err2;

Line 2161: if (l_trx_date_entered <= fa_cache_pkg.fazcdp_record.calendar_period_close_date and

2157: -- where the transaction date was cal_per_close.
2158: -- only do this if date_retired equals falls in
2159: -- the same period as CPD.
2160:
2161: if (l_trx_date_entered <= fa_cache_pkg.fazcdp_record.calendar_period_close_date and
2162: l_trx_date_entered >= fa_cache_pkg.fazcdp_record.calendar_period_open_date) then
2163:
2164: -- BUG# 4212279
2165: -- don't allow a change where prorate date would change

Line 2162: l_trx_date_entered >= fa_cache_pkg.fazcdp_record.calendar_period_open_date) then

2158: -- only do this if date_retired equals falls in
2159: -- the same period as CPD.
2160:
2161: if (l_trx_date_entered <= fa_cache_pkg.fazcdp_record.calendar_period_close_date and
2162: l_trx_date_entered >= fa_cache_pkg.fazcdp_record.calendar_period_open_date) then
2163:
2164: -- BUG# 4212279
2165: -- don't allow a change where prorate date would change
2166: -- as a result

Line 2175: fa_cache_pkg.fazccbd_record.retirement_prorate_convention

2171: fa_conventions conv2,
2172: fa_calendar_periods cal1,
2173: fa_calendar_periods cal2
2174: where conv1.prorate_convention_code =
2175: fa_cache_pkg.fazccbd_record.retirement_prorate_convention
2176: and conv2.prorate_convention_code =
2177: fa_cache_pkg.fazccbd_record.retirement_prorate_convention
2178: and l_trx_date_entered
2179: between conv1.start_date and conv1.end_date

Line 2177: fa_cache_pkg.fazccbd_record.retirement_prorate_convention

2173: fa_calendar_periods cal2
2174: where conv1.prorate_convention_code =
2175: fa_cache_pkg.fazccbd_record.retirement_prorate_convention
2176: and conv2.prorate_convention_code =
2177: fa_cache_pkg.fazccbd_record.retirement_prorate_convention
2178: and l_trx_date_entered
2179: between conv1.start_date and conv1.end_date
2180: and fa_cache_pkg.fazcdp_record.calendar_period_close_date
2181: between conv2.start_date and conv2.end_date

Line 2180: and fa_cache_pkg.fazcdp_record.calendar_period_close_date

2176: and conv2.prorate_convention_code =
2177: fa_cache_pkg.fazccbd_record.retirement_prorate_convention
2178: and l_trx_date_entered
2179: between conv1.start_date and conv1.end_date
2180: and fa_cache_pkg.fazcdp_record.calendar_period_close_date
2181: between conv2.start_date and conv2.end_date
2182: and cal1.calendar_type = fa_cache_pkg.fazcbc_record.prorate_calendar
2183: and cal2.calendar_type = fa_cache_pkg.fazcbc_record.prorate_calendar
2184: and conv1.prorate_date between cal1.start_date and cal1.end_date

Line 2182: and cal1.calendar_type = fa_cache_pkg.fazcbc_record.prorate_calendar

2178: and l_trx_date_entered
2179: between conv1.start_date and conv1.end_date
2180: and fa_cache_pkg.fazcdp_record.calendar_period_close_date
2181: between conv2.start_date and conv2.end_date
2182: and cal1.calendar_type = fa_cache_pkg.fazcbc_record.prorate_calendar
2183: and cal2.calendar_type = fa_cache_pkg.fazcbc_record.prorate_calendar
2184: and conv1.prorate_date between cal1.start_date and cal1.end_date
2185: and conv2.prorate_date between cal2.start_date and cal2.end_date
2186: and cal1.end_date = cal2.end_date;

Line 2183: and cal2.calendar_type = fa_cache_pkg.fazcbc_record.prorate_calendar

2179: between conv1.start_date and conv1.end_date
2180: and fa_cache_pkg.fazcdp_record.calendar_period_close_date
2181: between conv2.start_date and conv2.end_date
2182: and cal1.calendar_type = fa_cache_pkg.fazcbc_record.prorate_calendar
2183: and cal2.calendar_type = fa_cache_pkg.fazcbc_record.prorate_calendar
2184: and conv1.prorate_date between cal1.start_date and cal1.end_date
2185: and conv2.prorate_date between cal2.start_date and cal2.end_date
2186: and cal1.end_date = cal2.end_date;
2187:

Line 2190: fa_cache_pkg.fazcdp_record.calendar_period_close_date;

2186: and cal1.end_date = cal2.end_date;
2187:
2188: if (l_count > 0) then
2189: l_trx_date_entered :=
2190: fa_cache_pkg.fazcdp_record.calendar_period_close_date;
2191: end if;
2192:
2193: -- if date is not redefaulted, API will trap the
2194: -- overlap and return failure

Line 2432: fa_cache_pkg.fazcbc_record.set_of_books_id,

2428: -- Bug 8643319: Passed the sob_id from cache
2429: if not fa_utils_pkg.faxrnd
2430: (l_tax_cost_retired,
2431: p_tax_book,
2432: fa_cache_pkg.fazcbc_record.set_of_books_id,
2433: p_log_level_rec => g_log_level_rec) then
2434: l_mesg_name := 'FA_MCP_FAIL_THID';
2435: raise ret_err2;
2436: end if;

Line 2451: fa_cache_pkg.fazccbd_record.retirement_prorate_convention;

2447:
2448: l_asset_retire_rec.cost_retired := l_tax_cost_retired;
2449: l_asset_retire_rec.status := 'PENDING';
2450: l_asset_retire_rec.retirement_prorate_convention :=
2451: fa_cache_pkg.fazccbd_record.retirement_prorate_convention;
2452: l_asset_retire_rec.retirement_id := NULL;
2453: l_asset_retire_rec.units_retired := NULL;
2454:
2455: -- BUG# 2737472

Line 2457: if (fa_cache_pkg.fazccbd_record.use_stl_retirements_flag = 'YES') then

2453: l_asset_retire_rec.units_retired := NULL;
2454:
2455: -- BUG# 2737472
2456: -- need to set stl_method_code, etc
2457: if (fa_cache_pkg.fazccbd_record.use_stl_retirements_flag = 'YES') then
2458: l_asset_retire_rec.detail_info.stl_method_code := fa_cache_pkg.fazccbd_record.stl_method_code;
2459: l_asset_retire_rec.detail_info.stl_life_in_months := fa_cache_pkg.fazccbd_record.stl_life_in_months;
2460: end if;
2461:

Line 2458: l_asset_retire_rec.detail_info.stl_method_code := fa_cache_pkg.fazccbd_record.stl_method_code;

2454:
2455: -- BUG# 2737472
2456: -- need to set stl_method_code, etc
2457: if (fa_cache_pkg.fazccbd_record.use_stl_retirements_flag = 'YES') then
2458: l_asset_retire_rec.detail_info.stl_method_code := fa_cache_pkg.fazccbd_record.stl_method_code;
2459: l_asset_retire_rec.detail_info.stl_life_in_months := fa_cache_pkg.fazccbd_record.stl_life_in_months;
2460: end if;
2461:
2462: l_asset_retire_rec.cost_of_removal := l_cost_of_removal;

Line 2459: l_asset_retire_rec.detail_info.stl_life_in_months := fa_cache_pkg.fazccbd_record.stl_life_in_months;

2455: -- BUG# 2737472
2456: -- need to set stl_method_code, etc
2457: if (fa_cache_pkg.fazccbd_record.use_stl_retirements_flag = 'YES') then
2458: l_asset_retire_rec.detail_info.stl_method_code := fa_cache_pkg.fazccbd_record.stl_method_code;
2459: l_asset_retire_rec.detail_info.stl_life_in_months := fa_cache_pkg.fazccbd_record.stl_life_in_months;
2460: end if;
2461:
2462: l_asset_retire_rec.cost_of_removal := l_cost_of_removal;
2463: l_asset_retire_rec.proceeds_of_sale := l_proceeds_of_sale;

Line 2779: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code, p_log_level_rec => g_log_level_rec) then

2775:
2776: x_return_status := 0;
2777:
2778: -- get corp book information
2779: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code, p_log_level_rec => g_log_level_rec) then
2780: raise masscp_err;
2781: end if;
2782:
2783: -- get corp period info

Line 2785: (p_book => fa_cache_pkg.fazcbc_record.distribution_source_book,

2781: end if;
2782:
2783: -- get corp period info
2784: if not FA_UTIL_PVT.get_period_rec
2785: (p_book => fa_cache_pkg.fazcbc_record.distribution_source_book,
2786: p_period_counter => p_period_counter,
2787: x_period_rec => l_corp_period_rec
2788: , p_log_level_rec => g_log_level_rec) then
2789: raise masscp_err;

Line 2804: if (fa_cache_pkg.fazcbc_record.copy_additions_flag = 'YES') then

2800: -- determine transactions available for copying
2801:
2802: fa_trx_types_tab := fa_char30_tbl_type();
2803:
2804: if (fa_cache_pkg.fazcbc_record.copy_additions_flag = 'YES') then
2805: fa_trx_types_tab.EXTEND;
2806: fa_trx_types_tab(fa_trx_types_tab.last) := 'ADDITION';
2807: else
2808: fa_srvr_msg.add_message

Line 2815: if (fa_cache_pkg.fazcbc_record.copy_adjustments_flag = 'YES') then

2811: token1 => 'TYPE',
2812: value1 => 'ADDITIONS', p_log_level_rec => g_log_level_rec);
2813: end if;
2814:
2815: if (fa_cache_pkg.fazcbc_record.copy_adjustments_flag = 'YES') then
2816: fa_trx_types_tab.EXTEND;
2817: fa_trx_types_tab(fa_trx_types_tab.last) := 'ADJUSTMENT';
2818: else
2819: fa_srvr_msg.add_message

Line 2826: if (fa_cache_pkg.fazcbc_record.copy_retirements_flag = 'YES') then

2822: token1 => 'TYPE',
2823: value1 => 'ADJUSTMENTS', p_log_level_rec => g_log_level_rec);
2824: end if;
2825:
2826: if (fa_cache_pkg.fazcbc_record.copy_retirements_flag = 'YES') then
2827: fa_trx_types_tab.EXTEND;
2828: fa_trx_types_tab(fa_trx_types_tab.last) := 'FULL RETIREMENT';
2829:
2830: fa_trx_types_tab.EXTEND;

Line 2843: if (nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y') then

2839: token1 => 'TYPE',
2840: value1 => 'RETIREMENTS', p_log_level_rec => g_log_level_rec);
2841: end if;
2842:
2843: if (nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y') then
2844: if (nvl(fa_cache_pkg.fazcbc_record.copy_group_addition_flag, 'N') = 'Y') then
2845: fa_trx_types_tab.EXTEND;
2846: fa_trx_types_tab(fa_trx_types_tab.last) := 'GROUP ADDITION';
2847: else

Line 2844: if (nvl(fa_cache_pkg.fazcbc_record.copy_group_addition_flag, 'N') = 'Y') then

2840: value1 => 'RETIREMENTS', p_log_level_rec => g_log_level_rec);
2841: end if;
2842:
2843: if (nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y') then
2844: if (nvl(fa_cache_pkg.fazcbc_record.copy_group_addition_flag, 'N') = 'Y') then
2845: fa_trx_types_tab.EXTEND;
2846: fa_trx_types_tab(fa_trx_types_tab.last) := 'GROUP ADDITION';
2847: else
2848: fa_srvr_msg.add_message

Line 2865: if (fa_cache_pkg.fazcbc_record.copy_additions_flag <> 'YES') then

2861:
2862: if (p_mode = 1) then
2863:
2864: -- skip if additions are not selected for copying
2865: if (fa_cache_pkg.fazcbc_record.copy_additions_flag <> 'YES') then
2866: x_return_status := 0;
2867: return;
2868: end if;
2869:

Line 2907: decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,

2903: assets.transaction_header_id_in,
2904: NULL tax_transaction_header_id,
2905: 'ADDITION' transaction_type_code,
2906: NULL,
2907: decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,
2908: 'Y', assets.group_asset_id,
2909: cbd.group_asset_id),
2910: decode(asset_type, 'GROUP', 1,
2911: decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,

Line 2911: decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,

2907: decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,
2908: 'Y', assets.group_asset_id,
2909: cbd.group_asset_id),
2910: decode(asset_type, 'GROUP', 1,
2911: decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,
2912: 'Y', decode(assets.group_asset_id,
2913: null, mod(assets.asset_id, p_total_requests) + 1,
2914: 1),
2915: decode(cbd.group_asset_id,

Line 2919: decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,

2915: decode(cbd.group_asset_id,
2916: null, mod(assets.asset_id, p_total_requests) + 1,
2917: 1))),
2918: decode(asset_type, 'GROUP', 1,
2919: decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,
2920: 'Y', decode(assets.group_asset_id,
2921: null, 1,
2922: 2),
2923: decode(cbd.group_asset_id,

Line 2944: and books.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book

2940: fa_deprn_periods dp,
2941: fa_asset_history ah -- bug fix 5900321
2942: where books.date_effective <= nvl(l_corp_period_rec.period_close_date, sysdate)
2943: and nvl(books.date_ineffective, sysdate) > nvl(l_corp_period_rec.period_close_date, sysdate - 1)
2944: and books.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
2945:
2946: -- bug fix 5900321 (Initial Mass Copy copies capitalized assets to wrong fiscal year and period in TAX book)
2947: and ah.asset_id = books.asset_id
2948: and ah.date_effective <= l_date_effective

Line 2953: and dp.book_type_code (+) = fa_cache_pkg.fazcbc_record.distribution_source_book

2949: and nvl(ah.date_ineffective, sysdate+1) > l_date_effective
2950: and ah.asset_type in ('CAPITALIZED', 'GROUP')
2951: -- End bug fix 5900321
2952:
2953: and dp.book_type_code (+) = fa_cache_pkg.fazcbc_record.distribution_source_book
2954: and dp.period_counter (+) = books.period_counter_fully_retired
2955: and nvl(dp.period_counter,
2956: l_corp_period_rec.period_counter + 1) > l_corp_period_rec.period_counter
2957: and ad.asset_type in ('CAPITALIZED', 'GROUP')

Line 3008: null, decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,

3004: tax_bk.transaction_header_id_in,
3005: assets.transaction_type_code,
3006: tax_bk.group_asset_id,
3007: decode(tax_bk.asset_id,
3008: null, decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,
3009: 'Y', nvl(new_group_asset_id, cbd.group_asset_id),
3010: cbd.group_asset_id),
3011: tax_bk.group_asset_id),
3012: decode(asset_type,

Line 3015: null, decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,

3011: tax_bk.group_asset_id),
3012: decode(asset_type,
3013: 'GROUP', 1,
3014: decode(tax_bk.asset_id,
3015: null, decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,
3016: 'Y', decode(nvl(new_group_asset_id, cbd.group_asset_id),
3017: null, mod(assets.asset_id, p_total_requests) + 1,
3018: 1),
3019: decode(cbd.group_asset_id,

Line 3028: null, decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,

3024: 1))),
3025: decode(asset_type,
3026: 'GROUP', 1,
3027: decode(tax_bk.asset_id,
3028: null, decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,
3029: 'Y', decode(nvl(new_group_asset_id, cbd.group_asset_id),
3030: null, 1,
3031: 2),
3032: decode(cbd.group_asset_id,

Line 3054: where corp_th.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book

3050: fa_transaction_headers corp_th,
3051: fa_books corp_bk,
3052: fa_books corp_bk_old,
3053: TABLE(CAST(fa_trx_types_tab AS fa_char30_tbl_type)) trx
3054: where corp_th.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
3055: and corp_th.transaction_type_code = trx.column_value
3056: and corp_th.date_effective <= nvl(l_corp_period_rec.period_close_date, sysdate)
3057: and corp_th.date_effective >= l_corp_period_rec.period_open_date
3058: and corp_th.source_transaction_header_id is null

Line 3119: if nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y' then

3115: fa_debug_pkg.add(l_calling_fn, 'After gather statistics', l_schema, p_log_level_rec => g_log_level_rec);
3116: end if;
3117:
3118: -- increase the process order for group if applicable
3119: if nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y' then
3120: l_group_increment := 1;
3121: end if; -- group
3122:
3123: