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 119: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code,

115: G_failure_count := 0;
116: G_warning_count := 0;
117:
118: -- get book information
119: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code,
120: p_log_level_rec => g_log_level_rec) then
121: raise masscp_err;
122: end if;
123:

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

122: end if;
123:
124: if (g_times_called = 1) then
125:
126: if (fa_cache_pkg.fazcbc_record.copy_additions_flag <> 'YES') then
127: fnd_message.set_name('OFA', 'FA_MCP_SHARED_NO_COPY');
128: fnd_message.set_token('TYPE','ADDITIONS',FALSE);
129: l_string := fnd_message.get;
130: FND_FILE.put(FND_FILE.output,l_string);

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

130: FND_FILE.put(FND_FILE.output,l_string);
131: FND_FILE.new_line(FND_FILE.output,1);
132: end if;
133:
134: if (fa_cache_pkg.fazcbc_record.copy_adjustments_flag <> 'YES') then
135: fnd_message.set_name('OFA', 'FA_MCP_SHARED_NO_COPY');
136: fnd_message.set_token('TYPE','ADJUSTMENTS',FALSE);
137: l_string := fnd_message.get;
138: FND_FILE.put(FND_FILE.output,l_string);

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

138: FND_FILE.put(FND_FILE.output,l_string);
139: FND_FILE.new_line(FND_FILE.output,1);
140: end if;
141:
142: if (fa_cache_pkg.fazcbc_record.copy_retirements_flag <> 'YES') then
143: fnd_message.set_name('OFA', 'FA_MCP_SHARED_NO_COPY');
144: fnd_message.set_token('TYPE','RETIREMENTS',FALSE);
145: l_string := fnd_message.get;
146: FND_FILE.put(FND_FILE.output,l_string);

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

146: FND_FILE.put(FND_FILE.output,l_string);
147: FND_FILE.new_line(FND_FILE.output,1);
148: end if;
149:
150: if (nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y' and
151: nvl(fa_cache_pkg.fazcbc_record.copy_group_addition_flag, 'N') <> 'Y') then
152: fnd_message.set_name('OFA', 'FA_MCP_SHARED_NO_COPY');
153: fnd_message.set_token('TYPE','GROUP ADDITIONS',FALSE);
154: l_string := fnd_message.get;

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

147: FND_FILE.new_line(FND_FILE.output,1);
148: end if;
149:
150: if (nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y' and
151: nvl(fa_cache_pkg.fazcbc_record.copy_group_addition_flag, 'N') <> 'Y') then
152: fnd_message.set_name('OFA', 'FA_MCP_SHARED_NO_COPY');
153: fnd_message.set_token('TYPE','GROUP ADDITIONS',FALSE);
154: l_string := fnd_message.get;
155: FND_FILE.put(FND_FILE.output,l_string);

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

174: FND_FILE.new_line(FND_FILE.output,1);
175:
176: end if;
177:
178: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);
179:
180: if (g_log_level_rec.statement_level) then
181: fa_debug_pkg.add(l_calling_fn, 'opening c_trx_parent cursor at', sysdate,
182: p_log_level_rec => g_log_level_rec);

Line 507: if NOT fa_cache_pkg.fazcbc(X_book => p_tax_book,

503: add_err2 EXCEPTION; -- fatal
504:
505: BEGIN
506:
507: if NOT fa_cache_pkg.fazcbc(X_book => p_tax_book,
508: p_log_level_rec => p_log_level_rec) then
509: raise add_err1;
510: end if;
511:

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

509: raise add_err1;
510: end if;
511:
512: if (p_asset_type = 'GROUP' and
513: nvl(fa_cache_pkg.fazcbc_record.copy_group_addition_flag, 'N') = 'N') then
514:
515: l_mesg_name := 'FA_MCP_SHARED_NO_COPY';
516: l_token := 'TYPE';
517: l_value := 'GROUP ADDITIONS';

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

517: l_value := 'GROUP ADDITIONS';
518:
519: raise add_err1;
520: elsif (p_asset_type <> 'GROUP' and
521: fa_cache_pkg.fazcbc_record.copy_additions_flag = 'NO') then
522:
523: l_mesg_name := 'FA_MCP_SHARED_NO_COPY';
524: l_token := 'TYPE';
525: l_value := 'ADDITIONS';

Line 542: if not fa_cache_pkg.fazccb (

538: into l_category_id
539: from fa_additions_b
540: where asset_id = p_asset_id;
541:
542: if not fa_cache_pkg.fazccb (
543: X_Book => p_tax_book,
544: X_Cat_Id => l_category_id,
545: p_log_level_rec => p_log_level_rec) then
546: l_mesg_name := 'FA_MCP_CAT_NOT_IN_TAX';

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

575: from fa_books corp_bk,
576: fa_deprn_periods dp,
577: fa_transaction_headers corp_th
578: where corp_bk.transaction_header_id_in = corp_th.transaction_header_id
579: and corp_bk.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
580: and corp_bk.asset_id = p_asset_id
581: and corp_bk.book_type_code = dp.book_type_code
582: and corp_bk.period_counter_capitalized = dp.period_counter
583: and corp_th.date_effective between

Line 655: and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book

651: l_asset_fin_rec.percent_salvage_value,
652: l_asset_fin_rec.salvage_value
653: from fa_books
654: where asset_id = p_asset_id
655: and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
656: and transaction_header_id_in = p_corp_thid;
657:
658: -- set the group asset and salvage information according to options
659: -- selected in book controls. last option will force null inside the addition api

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

657:
658: -- set the group asset and salvage information according to options
659: -- selected in book controls. last option will force null inside the addition api
660:
661: if (nvl(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag, 'N') = 'N') then
662: l_asset_fin_rec.group_asset_id := null;
663: end if;
664:
665: if (nvl(fa_cache_pkg.fazcbc_record.copy_salvage_value_flag, 'NO') = 'NO') then

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

661: if (nvl(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag, 'N') = 'N') then
662: l_asset_fin_rec.group_asset_id := null;
663: end if;
664:
665: if (nvl(fa_cache_pkg.fazcbc_record.copy_salvage_value_flag, 'NO') = 'NO') then
666: l_asset_fin_rec.salvage_type := null;
667: l_asset_fin_rec.percent_salvage_value := null;
668: l_asset_fin_rec.salvage_value := null;
669: end if;

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

674:
675: if (p_asset_type = 'GROUP') then
676:
677: l_corp_asset_hdr_rec.asset_id := p_asset_id;
678: l_corp_asset_hdr_rec.book_type_code := fa_cache_pkg.fazcbc_record.distribution_source_book;
679:
680: if not FA_UTIL_PVT.get_asset_fin_rec
681: (p_asset_hdr_rec => l_corp_asset_hdr_rec,
682: px_asset_fin_rec => l_corp_asset_fin_rec,

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

1045: -- current period note that the tax period was the last one
1046: -- loaded into the deprn period cache via the call to
1047: -- get_deprn_period above.
1048:
1049: if (l_trx_date_entered > fa_cache_pkg.fazcdp_record.calendar_period_close_date) then
1050: l_mesg_name := 'FA_MCP_SHARED_FUTURE_COPY';
1051:
1052: raise adj_err1;
1053: end if;

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

1058: l_corp_old_cost;
1059: l_delta_capacity := nvl(l_corp_new_capacity,0) -
1060: nvl(l_corp_old_capacity,0);
1061:
1062: if (fa_cache_pkg.fazcbc_record.copy_adjustments_flag = 'NO' and
1063: l_delta_capacity = 0) then
1064:
1065: l_mesg_name := 'FA_MCP_SHARED_NO_COPY';
1066: l_token := 'TYPE';

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

1070: end if;
1071:
1072:
1073: if(l_trx_subtype = 'AMORTIZED' and
1074: fa_cache_pkg.fazcbc_record.amortize_flag = 'NO' and
1075: l_delta_capacity = 0) then
1076:
1077: l_mesg_name := 'FA_MCP_SHARED_NO_COPY';
1078: l_token := 'TYPE';

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

1210: -- Cannot copy SV adjustments where CORP SV before adj <> TAX SV
1211: -- modified for group enhancements to account for changes
1212: -- in type and percentage as well
1213:
1214: if (nvl(fa_cache_pkg.fazcbc_record.copy_salvage_value_flag, 'NO') = 'NO') then
1215:
1216: if ((l_delta_cost = 0) and
1217: (l_delta_capacity = 0) and
1218: (l_salvage_change)) then

Line 1259: if not fa_cache_pkg.fazccmt

1255: -- Cannot copy adjustments where corp method is prod, but tax is not
1256: -- a prod method
1257:
1258: -- Get rsr for old corp deprn_method
1259: if not fa_cache_pkg.fazccmt
1260: (X_method => l_corp_old_deprn_method_code,
1261: X_life => l_corp_old_life,
1262: p_log_level_rec => p_log_level_rec) then
1263: l_mesg_name := 'FA_MCP_FAIL_THID';

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

1263: l_mesg_name := 'FA_MCP_FAIL_THID';
1264: raise val_err1;
1265: end if;
1266:
1267: l_corp_old_rsr := fa_cache_pkg.fazccmt_record.rate_source_rule;
1268:
1269: -- Get rsr for new corp deprn_method
1270: if not fa_cache_pkg.fazccmt
1271: (X_method => l_corp_new_deprn_method_code,

Line 1270: if not fa_cache_pkg.fazccmt

1266:
1267: l_corp_old_rsr := fa_cache_pkg.fazccmt_record.rate_source_rule;
1268:
1269: -- Get rsr for new corp deprn_method
1270: if not fa_cache_pkg.fazccmt
1271: (X_method => l_corp_new_deprn_method_code,
1272: X_life => l_corp_new_life,
1273: p_log_level_rec => p_log_level_rec) then
1274: l_mesg_name := 'FA_MCP_FAIL_THID';

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

1274: l_mesg_name := 'FA_MCP_FAIL_THID';
1275: raise val_err1;
1276: end if;
1277:
1278: l_corp_new_rsr := fa_cache_pkg.fazccmt_record.rate_source_rule;
1279:
1280: -- Get rsr for tax.deprn_method
1281: if not fa_cache_pkg.fazccmt
1282: (X_method => l_tax_deprn_method_code,

Line 1281: if not fa_cache_pkg.fazccmt

1277:
1278: l_corp_new_rsr := fa_cache_pkg.fazccmt_record.rate_source_rule;
1279:
1280: -- Get rsr for tax.deprn_method
1281: if not fa_cache_pkg.fazccmt
1282: (X_method => l_tax_deprn_method_code,
1283: X_life => l_tax_life,
1284: p_log_level_rec => p_log_level_rec) then
1285: l_mesg_name := 'FA_MCP_FAIL_THID';

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

1285: l_mesg_name := 'FA_MCP_FAIL_THID';
1286: raise val_err1;
1287: end if;
1288:
1289: l_tax_rsr := fa_cache_pkg.fazccmt_record.rate_source_rule;
1290:
1291:
1292: -- Cannot copy adjustments that are not cost adjustments,
1293: -- OR salvage value adjustments

Line 1303: -- (fa_cache_pkg.fazcbc_record.copy_group_change_flag <> 'Y'))) or

1299: if ((l_delta_cost = 0) and
1300: (not l_valid_salvage_change) and
1301: (l_delta_capacity = 0)) or
1302: -- ((nvl(l_corp_old_group_asset_id, -99) = nvl(l_corp_new_group_asset_id, -99)) or
1303: -- (fa_cache_pkg.fazcbc_record.copy_group_change_flag <> 'Y'))) or
1304: ((l_corp_old_rsr <> l_corp_new_rsr) and
1305: (l_delta_capacity <> 0)) then
1306:
1307: l_mesg_name := 'FA_MCP_INVALID_ADJ_COPY';

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

1325: -- CAPACITY ADJUSTMENT COPY TO CONTINUE IF THEY FAIL
1326: -- (valid = INVALID, capacity_adj_flag = TRUE)
1327:
1328: -- Amortized adjustments are not allowed in TAX book
1329: if (fa_cache_pkg.fazcbc_record.amortize_flag = 'NO' and
1330: l_trx_subtype = 'AMORTIZED') then
1331:
1332: l_mesg_name := 'FA_MCP_NO_AMORT_ADJS';
1333: l_trx_subtype := 'EXPENSED';

Line 1453: fa_cache_pkg.fazcbc_record.copy_group_change_flag = 'Y') then

1449: -- the same amortization start date as in the corporate book ??? VERIFY ???
1450:
1451: if ((nvl(l_corp_old_group_asset_id, -99) <> nvl(l_corp_new_group_asset_id, -99)) and
1452: (nvl(l_corp_old_group_asset_id, -99) = nvl(l_tax_group_asset_id, -99)) and
1453: fa_cache_pkg.fazcbc_record.copy_group_change_flag = 'Y') then
1454:
1455: -- get the corporate amortization start date for the
1456: -- corporate change and use it here
1457:

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

1706: and ad.asset_id = corp_th.asset_id;
1707:
1708: BEGIN
1709:
1710: if (fa_cache_pkg.fazcbc_record.copy_retirements_flag = 'NO') then
1711:
1712: l_mesg_name := 'FA_MCP_SHARED_NO_COPY';
1713: l_token := 'TYPE';
1714: l_value := 'RETIREMENTS';

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

1731: -- get basic info including corp ret info and tax cost, etc
1732: open c_retirement(p_asset_id => p_asset_id,
1733: p_corp_thid => p_corp_thid,
1734: p_tax_book => p_tax_book,
1735: p_corp_book => fa_cache_pkg.fazcbc_record.distribution_source_book);
1736:
1737: fetch c_retirement
1738: into l_trx_date_entered,
1739: l_date_effective,

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

1774: -- current period note that the tax period was the last one
1775: -- loaded into the deprn period cache via the call to
1776: -- get_deprn_period above.
1777:
1778: if (l_trx_date_entered > fa_cache_pkg.fazcdp_record.calendar_period_close_date) then
1779: l_mesg_name := 'FA_MCP_SHARED_FUTURE_COPY';
1780:
1781: raise ret_err1;
1782: end if;

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

1790:
1791: -- call the category cache
1792: l_jdpis := to_number(to_char(l_tax_dpis, 'J'));
1793:
1794: if not fa_cache_pkg.fazccbd (X_book => p_tax_book,
1795: X_cat_id => l_category_id,
1796: X_jdpis => l_jdpis,
1797: p_log_level_rec => p_log_level_rec) then
1798: l_mesg_name := 'FA_MCP_FAIL_THID';

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

1861: -- where the transaction date was cal_per_close.
1862: -- only do this if date_retired equals falls in
1863: -- the same period as CPD.
1864:
1865: if (l_trx_date_entered <= fa_cache_pkg.fazcdp_record.calendar_period_close_date and
1866: l_trx_date_entered >= fa_cache_pkg.fazcdp_record.calendar_period_open_date) then
1867:
1868: -- BUG# 4212279
1869: -- don't allow a change where prorate date would change

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

1862: -- only do this if date_retired equals falls in
1863: -- the same period as CPD.
1864:
1865: if (l_trx_date_entered <= fa_cache_pkg.fazcdp_record.calendar_period_close_date and
1866: l_trx_date_entered >= fa_cache_pkg.fazcdp_record.calendar_period_open_date) then
1867:
1868: -- BUG# 4212279
1869: -- don't allow a change where prorate date would change
1870: -- as a result

Line 1879: fa_cache_pkg.fazccbd_record.retirement_prorate_convention

1875: fa_conventions conv2,
1876: fa_calendar_periods cal1,
1877: fa_calendar_periods cal2
1878: where conv1.prorate_convention_code =
1879: fa_cache_pkg.fazccbd_record.retirement_prorate_convention
1880: and conv2.prorate_convention_code =
1881: fa_cache_pkg.fazccbd_record.retirement_prorate_convention
1882: and l_trx_date_entered
1883: between conv1.start_date and conv1.end_date

Line 1881: fa_cache_pkg.fazccbd_record.retirement_prorate_convention

1877: fa_calendar_periods cal2
1878: where conv1.prorate_convention_code =
1879: fa_cache_pkg.fazccbd_record.retirement_prorate_convention
1880: and conv2.prorate_convention_code =
1881: fa_cache_pkg.fazccbd_record.retirement_prorate_convention
1882: and l_trx_date_entered
1883: between conv1.start_date and conv1.end_date
1884: and fa_cache_pkg.fazcdp_record.calendar_period_close_date
1885: between conv2.start_date and conv2.end_date

Line 1884: and fa_cache_pkg.fazcdp_record.calendar_period_close_date

1880: and conv2.prorate_convention_code =
1881: fa_cache_pkg.fazccbd_record.retirement_prorate_convention
1882: and l_trx_date_entered
1883: between conv1.start_date and conv1.end_date
1884: and fa_cache_pkg.fazcdp_record.calendar_period_close_date
1885: between conv2.start_date and conv2.end_date
1886: and cal1.calendar_type = fa_cache_pkg.fazcbc_record.prorate_calendar
1887: and cal2.calendar_type = fa_cache_pkg.fazcbc_record.prorate_calendar
1888: and conv1.prorate_date between cal1.start_date and cal1.end_date

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

1882: and l_trx_date_entered
1883: between conv1.start_date and conv1.end_date
1884: and fa_cache_pkg.fazcdp_record.calendar_period_close_date
1885: between conv2.start_date and conv2.end_date
1886: and cal1.calendar_type = fa_cache_pkg.fazcbc_record.prorate_calendar
1887: and cal2.calendar_type = fa_cache_pkg.fazcbc_record.prorate_calendar
1888: and conv1.prorate_date between cal1.start_date and cal1.end_date
1889: and conv2.prorate_date between cal2.start_date and cal2.end_date
1890: and cal1.end_date = cal2.end_date;

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

1883: between conv1.start_date and conv1.end_date
1884: and fa_cache_pkg.fazcdp_record.calendar_period_close_date
1885: between conv2.start_date and conv2.end_date
1886: and cal1.calendar_type = fa_cache_pkg.fazcbc_record.prorate_calendar
1887: and cal2.calendar_type = fa_cache_pkg.fazcbc_record.prorate_calendar
1888: and conv1.prorate_date between cal1.start_date and cal1.end_date
1889: and conv2.prorate_date between cal2.start_date and cal2.end_date
1890: and cal1.end_date = cal2.end_date;
1891:

Line 1894: fa_cache_pkg.fazcdp_record.calendar_period_close_date;

1890: and cal1.end_date = cal2.end_date;
1891:
1892: if (l_count > 0) then
1893: l_trx_date_entered :=
1894: fa_cache_pkg.fazcdp_record.calendar_period_close_date;
1895: end if;
1896:
1897: -- if date is not redefaulted, API will trap the
1898: -- overlap and return failure

Line 2119: fa_cache_pkg.fazccbd_record.retirement_prorate_convention;

2115:
2116: l_asset_retire_rec.cost_retired := l_tax_cost_retired;
2117: l_asset_retire_rec.status := 'PENDING';
2118: l_asset_retire_rec.retirement_prorate_convention :=
2119: fa_cache_pkg.fazccbd_record.retirement_prorate_convention;
2120: l_asset_retire_rec.retirement_id := NULL;
2121: l_asset_retire_rec.units_retired := NULL;
2122:
2123: -- BUG# 2737472

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

2121: l_asset_retire_rec.units_retired := NULL;
2122:
2123: -- BUG# 2737472
2124: -- need to set stl_method_code, etc
2125: if (fa_cache_pkg.fazccbd_record.use_stl_retirements_flag = 'YES') then
2126: l_asset_retire_rec.detail_info.stl_method_code := fa_cache_pkg.fazccbd_record.stl_method_code;
2127: l_asset_retire_rec.detail_info.stl_life_in_months := fa_cache_pkg.fazccbd_record.stl_life_in_months;
2128: end if;
2129:

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

2122:
2123: -- BUG# 2737472
2124: -- need to set stl_method_code, etc
2125: if (fa_cache_pkg.fazccbd_record.use_stl_retirements_flag = 'YES') then
2126: l_asset_retire_rec.detail_info.stl_method_code := fa_cache_pkg.fazccbd_record.stl_method_code;
2127: l_asset_retire_rec.detail_info.stl_life_in_months := fa_cache_pkg.fazccbd_record.stl_life_in_months;
2128: end if;
2129:
2130: l_asset_retire_rec.cost_of_removal := l_cost_of_removal;

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

2123: -- BUG# 2737472
2124: -- need to set stl_method_code, etc
2125: if (fa_cache_pkg.fazccbd_record.use_stl_retirements_flag = 'YES') then
2126: l_asset_retire_rec.detail_info.stl_method_code := fa_cache_pkg.fazccbd_record.stl_method_code;
2127: l_asset_retire_rec.detail_info.stl_life_in_months := fa_cache_pkg.fazccbd_record.stl_life_in_months;
2128: end if;
2129:
2130: l_asset_retire_rec.cost_of_removal := l_cost_of_removal;
2131: l_asset_retire_rec.proceeds_of_sale := l_proceeds_of_sale;

Line 2451: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code) then

2447:
2448: x_return_status := 0;
2449:
2450: -- get corp book information
2451: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code) then
2452: raise masscp_err;
2453: end if;
2454:
2455: -- get corp period info

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

2453: end if;
2454:
2455: -- get corp period info
2456: if not FA_UTIL_PVT.get_period_rec
2457: (p_book => fa_cache_pkg.fazcbc_record.distribution_source_book,
2458: p_period_counter => p_period_counter,
2459: x_period_rec => l_corp_period_rec
2460: ) then
2461: raise masscp_err;

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

2470: end if;
2471:
2472: fa_trx_types_tab := fa_char30_tbl_type();
2473:
2474: if (fa_cache_pkg.fazcbc_record.copy_additions_flag = 'YES') then
2475: fa_trx_types_tab.EXTEND;
2476: fa_trx_types_tab(fa_trx_types_tab.last) := 'ADDITION';
2477: else
2478: fa_srvr_msg.add_message

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

2482: value1 => 'ADDITIONS',
2483: p_log_level_rec => g_log_level_rec);
2484: end if;
2485:
2486: if (fa_cache_pkg.fazcbc_record.copy_adjustments_flag = 'YES') then
2487: fa_trx_types_tab.EXTEND;
2488: fa_trx_types_tab(fa_trx_types_tab.last) := 'ADJUSTMENT';
2489: else
2490: fa_srvr_msg.add_message

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

2494: value1 => 'ADJUSTMENTS',
2495: p_log_level_rec => g_log_level_rec);
2496: end if;
2497:
2498: if (fa_cache_pkg.fazcbc_record.copy_retirements_flag = 'YES') then
2499: fa_trx_types_tab.EXTEND;
2500: fa_trx_types_tab(fa_trx_types_tab.last) := 'FULL RETIREMENT';
2501:
2502: fa_trx_types_tab.EXTEND;

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

2512: value1 => 'RETIREMENTS',
2513: p_log_level_rec => g_log_level_rec);
2514: end if;
2515:
2516: if (nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y') then
2517: if (nvl(fa_cache_pkg.fazcbc_record.copy_group_addition_flag, 'N') = 'Y') then
2518: fa_trx_types_tab.EXTEND;
2519: fa_trx_types_tab(fa_trx_types_tab.last) := 'GROUP ADDITION';
2520: else

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

2513: p_log_level_rec => g_log_level_rec);
2514: end if;
2515:
2516: if (nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y') then
2517: if (nvl(fa_cache_pkg.fazcbc_record.copy_group_addition_flag, 'N') = 'Y') then
2518: fa_trx_types_tab.EXTEND;
2519: fa_trx_types_tab(fa_trx_types_tab.last) := 'GROUP ADDITION';
2520: else
2521: fa_srvr_msg.add_message

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

2533:
2534: if (p_mode = 1) then
2535:
2536: -- skip if additions are not selected for copying
2537: if (fa_cache_pkg.fazcbc_record.copy_additions_flag <> 'YES') then
2538: x_return_status := 0;
2539: return;
2540: end if;
2541:

Line 2581: decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,

2577: assets.transaction_header_id_in,
2578: NULL tax_transaction_header_id,
2579: 'ADDITION' transaction_type_code,
2580: NULL,
2581: decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,
2582: 'Y', assets.group_asset_id,
2583: cbd.group_asset_id),
2584: decode(asset_type, 'GROUP', 1,
2585: decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,

Line 2585: decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,

2581: decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,
2582: 'Y', assets.group_asset_id,
2583: cbd.group_asset_id),
2584: decode(asset_type, 'GROUP', 1,
2585: decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,
2586: 'Y', decode(assets.group_asset_id,
2587: null, mod(assets.asset_id, p_total_requests) + 1,
2588: 1),
2589: decode(cbd.group_asset_id,

Line 2593: decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,

2589: decode(cbd.group_asset_id,
2590: null, mod(assets.asset_id, p_total_requests) + 1,
2591: 1))),
2592: decode(asset_type, 'GROUP', 1,
2593: decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,
2594: 'Y', decode(assets.group_asset_id,
2595: null, 1,
2596: 2),
2597: decode(cbd.group_asset_id,

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

2614: fa_deprn_periods dp,
2615: fa_asset_history ah -- bug fix 5925965
2616: where books.date_effective <= nvl(l_corp_period_rec.period_close_date, sysdate)
2617: and nvl(books.date_ineffective, sysdate) > nvl(l_corp_period_rec.period_close_date, sysdate - 1)
2618: and books.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
2619:
2620: -- bug fix 5925965 (Initial Mass Copy copies capitalized assets to wrong fiscal year and period in TAX book)
2621: and ah.asset_id = books.asset_id
2622: and ah.date_effective <= l_date_effective

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

2623: and nvl(ah.date_ineffective, sysdate+1) > l_date_effective
2624: and ah.asset_type in ('CAPITALIZED', 'GROUP')
2625: -- End bug fix 5925965
2626:
2627: and dp.book_type_code (+) = fa_cache_pkg.fazcbc_record.distribution_source_book
2628: and dp.period_counter (+) = books.period_counter_fully_retired
2629: and nvl(dp.period_counter,
2630: l_corp_period_rec.period_counter + 1) > l_corp_period_rec.period_counter
2631: and ad.asset_type in ('CAPITALIZED', 'GROUP')

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

2678: tax_bk.transaction_header_id_in,
2679: assets.transaction_type_code,
2680: tax_bk.group_asset_id,
2681: decode(tax_bk.asset_id,
2682: null, decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,
2683: 'Y', nvl(new_group_asset_id, cbd.group_asset_id),
2684: cbd.group_asset_id),
2685: tax_bk.group_asset_id),
2686: decode(asset_type,

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

2685: tax_bk.group_asset_id),
2686: decode(asset_type,
2687: 'GROUP', 1,
2688: decode(tax_bk.asset_id,
2689: null, decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,
2690: 'Y', decode(nvl(new_group_asset_id, cbd.group_asset_id),
2691: null, mod(assets.asset_id, p_total_requests) + 1,
2692: 1),
2693: decode(cbd.group_asset_id,

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

2698: 1))),
2699: decode(asset_type,
2700: 'GROUP', 1,
2701: decode(tax_bk.asset_id,
2702: null, decode(fa_cache_pkg.fazcbc_record.copy_group_assignment_flag,
2703: 'Y', decode(nvl(new_group_asset_id, cbd.group_asset_id),
2704: null, 1,
2705: 2),
2706: decode(cbd.group_asset_id,

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

2724: fa_transaction_headers corp_th,
2725: fa_books corp_bk,
2726: fa_books corp_bk_old,
2727: TABLE(CAST(fa_trx_types_tab AS fa_char30_tbl_type)) trx
2728: where corp_th.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
2729: and corp_th.transaction_type_code = trx.column_value
2730: and corp_th.date_effective <= nvl(l_corp_period_rec.period_close_date, sysdate)
2731: and corp_th.date_effective >= l_corp_period_rec.period_open_date
2732: and corp_th.source_transaction_header_id is null

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

2761:
2762: FND_CONCURRENT.AF_COMMIT;
2763:
2764: -- increase the process order for group if applicable
2765: if nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y' then
2766: l_group_increment := 1;
2767: end if; -- group
2768:
2769: