DBA Data[Home] [Help]

APPS.FA_ADJUSTMENT_PUB dependencies on FA_CACHE_PKG

Line 84: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;

80:
81: -- used for tax books when doing cip-in-tax or autocopy
82: l_trans_rec FA_API_TYPES.trans_rec_type;
83: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
84: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;
85: l_tax_index NUMBER; -- index for tax loop
86:
87: -- Bug 6665510: FP: Japan Tax Reform Project
88: l_deprn_method_code varchar2(12);

Line 129: if NOT fa_cache_pkg.fazcbc(X_book => px_asset_hdr_rec.book_type_code,

125: raise adj_err;
126: end if;
127:
128: -- call the cache for the primary transaction book
129: if NOT fa_cache_pkg.fazcbc(X_book => px_asset_hdr_rec.book_type_code,
130: p_log_level_rec => g_log_level_rec) then
131: raise adj_err;
132: end if;
133:

Line 134: px_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

130: p_log_level_rec => g_log_level_rec) then
131: raise adj_err;
132: end if;
133:
134: px_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
135:
136: -- verify the asset exist in the book already
137: if not FA_ASSET_VAL_PVT.validate_asset_book
138: (p_transaction_type_code => 'ADJUSTMENT',

Line 159: if not fa_cache_pkg.fazcsob

155: -- that is not tied to a SOB_ID by getting the value from
156: -- the book struct
157:
158: -- Get the book type code P,R or N
159: if not fa_cache_pkg.fazcsob
160: (X_set_of_books_id => px_asset_hdr_rec.set_of_books_id,
161: X_mrc_sob_type_code => l_reporting_flag,
162: p_log_level_rec => g_log_level_rec) then
163: raise adj_err;

Line 236: if not fa_cache_pkg.fazccmt (

232: fa_debug_pkg.add('pub adj api', 'l_deprn_method_code', l_deprn_method_code, p_log_level_rec);
233: fa_debug_pkg.add('pub adj api', 'l_life_in_months', l_life_in_months, p_log_level_rec);
234: end if; */
235:
236: if not fa_cache_pkg.fazccmt (
237: X_method => l_deprn_method_code,
238: X_life => l_life_in_months) then
239: raise adj_err;
240: end if;

Line 243: fa_debug_pkg.add('pub adj api', 'fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag', fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, p_log_level_rec);

239: raise adj_err;
240: end if;
241:
242: /* if (p_log_level_rec.statement_level) then
243: fa_debug_pkg.add('pub adj api', 'fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag', fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, p_log_level_rec);
244: end if; */
245:
246: if (nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES') and
247: nvl(l_asset_fin_rec_adj.group_asset_id,

Line 246: if (nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES') and

242: /* if (p_log_level_rec.statement_level) then
243: fa_debug_pkg.add('pub adj api', 'fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag', fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, p_log_level_rec);
244: end if; */
245:
246: if (nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES') and
247: nvl(l_asset_fin_rec_adj.group_asset_id,
248: FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM then
249: fa_srvr_msg.add_message
250: (calling_fn => l_calling_fn,

Line 259: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE' and

255:
256: -- do not allow manual cost changes on cip assets in corp
257: -- cost adjustments must be doen via invoices
258:
259: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE' and
260: l_asset_type_rec.asset_type = 'CIP' and
261: nvl(p_asset_fin_rec_adj.cost, 0) <> 0) then
262: fa_srvr_msg.add_message
263: (calling_fn => l_calling_fn,

Line 272: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX' and

268:
269: -- do not allow manual cost changes on cip assets in tax
270: -- except when api is called from the cip-in-tax gateway
271:
272: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX' and
273: l_asset_type_rec.asset_type = 'CIP' and
274: p_calling_fn NOT IN ('fa_ciptax_api_pkg.cip_adj','FA_RECLASS_PVT.do_redefault'
275: ))
276: then

Line 370: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then

366: end if;
367:
368: -- If book is a corporate book, process cip assets and autocopy
369:
370: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
371:
372: -- BUG# 2792134
373: -- null out the fin_rec table as well as deprn
374: -- cost and mrc cost will be rederived using corp values

Line 396: if not fa_cache_pkg.fazctbk

392:
393: l_trans_rec := px_trans_rec;
394: l_asset_hdr_rec := px_asset_hdr_rec;
395:
396: if not fa_cache_pkg.fazctbk
397: (x_corp_book => px_asset_hdr_rec.book_type_code,
398: x_asset_type => l_asset_type_rec.asset_type,
399: x_tax_book_tbl => l_tax_book_tbl,
400: p_log_level_rec => g_log_level_rec) then

Line 419: if (NOT fa_cache_pkg.fazcbc(X_book => l_tax_book_tbl(l_tax_index),

415: null;
416: else
417:
418: -- cache the book information for the tax book
419: if (NOT fa_cache_pkg.fazcbc(X_book => l_tax_book_tbl(l_tax_index),
420: p_log_level_rec => g_log_level_rec)) then
421: raise adj_err;
422: end if;
423:

Line 429: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

425: -- May need to set the transaction date, trx_type, subtype here as well
426: -- based on the open period and settings for each tax book in the loop
427:
428: l_asset_hdr_rec.book_type_code := l_tax_book_tbl(l_tax_index);
429: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
430: l_trans_rec.source_transaction_header_id := px_trans_rec.transaction_header_id;
431: l_trans_rec.transaction_header_id := null;
432:
433: -- set the gl sob info for the primary tax book

Line 568: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;

564:
565: l_reporting_flag varchar2(1);
566:
567: l_period_rec FA_API_TYPES.period_rec_type;
568: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
569:
570: -- used for local runs
571: l_responsibility_id number;
572: l_application_id number;

Line 769: if not FA_CACHE_PKG.fazcrsob

765: end if;
766:
767:
768: -- call the sob cache to get the table of sob_ids
769: if not FA_CACHE_PKG.fazcrsob
770: (x_book_type_code => px_asset_hdr_rec.book_type_code,
771: x_sob_tbl => l_sob_tbl,
772: p_log_level_rec => p_log_level_rec) then
773: raise adj_err;

Line 797: if NOT fa_cache_pkg.fazcbcs(X_book => px_asset_hdr_rec.book_type_code,

793: end if;
794:
795: -- call the cache to set the sob_id used for rounding and other lower
796: -- level code for each book.
797: if NOT fa_cache_pkg.fazcbcs(X_book => px_asset_hdr_rec.book_type_code,
798: p_log_level_rec => p_log_level_rec) then
799: raise adj_err;
800: end if;
801:

Line 1017: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then

1013: -- for the delta cost, etc. invoice engine will alter the gl sob
1014: -- and currency context from the above setting as it processes primary
1015: -- and reporting, but will reset them at temrination back to primary.
1016:
1017: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
1018:
1019: if (px_inv_trans_rec.transaction_type is not null) then
1020:
1021: if not FA_INVOICE_PVT.invoice_engine

Line 1067: elsif (nvl(fa_cache_pkg.fazcbc_record.allow_cip_dep_group_flag, 'N') = 'Y') then

1063: end if; -- corp
1064:
1065: if (p_asset_type_rec.asset_type <> 'CIP') then
1066: l_asset_fin_rec_adj.cip_cost := 0;
1067: elsif (nvl(fa_cache_pkg.fazcbc_record.allow_cip_dep_group_flag, 'N') = 'Y') then
1068: l_asset_fin_rec_adj.cip_cost := g_cip_cost;
1069: else
1070: l_asset_fin_rec_adj.cip_cost := l_asset_fin_rec_adj.cost;
1071: end if;

Line 1156: fa_cache_pkg.fazccb_record.DEPRN_EXPENSE_ACCT;

1152: when reserve is manually adjusted in period of addition
1153: bug 4439919 */
1154:
1155: adj_row.account :=
1156: fa_cache_pkg.fazccb_record.DEPRN_EXPENSE_ACCT;
1157: adj_row.account_type := 'DEPRN_EXPENSE_ACCT';
1158: adj_row.gen_ccid_flag := TRUE;
1159: adj_row.debit_credit_flag := 'CR';
1160: adj_row.selection_mode := fa_std_types.FA_AJ_ACTIVE;

Line 1317: fa_cache_pkg.fazcbc_record.book_class = 'TAX') then

1313: -- was involved, the amounts were already calculated and populated in the mrc
1314: -- pl/sql tables and we just need to copy them into the local variables.
1315:
1316: if (px_inv_trans_rec.transaction_type is null or
1317: fa_cache_pkg.fazcbc_record.book_class = 'TAX') then
1318:
1319: -- Get the associated rate for the adjustment when the invoice table is
1320: -- not populated. If this is a transaction being copied form corp to tax
1321: -- (masscp, cip-in-tax, autocopy), then we will always get the rate for

Line 1325: (fa_cache_pkg.fazcbc_record.book_class = 'TAX')) then

1321: -- (masscp, cip-in-tax, autocopy), then we will always get the rate for
1322: -- the corp trx and use that - unless the corp is not mrc enabled
1323:
1324: if ((px_trans_rec.source_transaction_header_id is not null) and
1325: (fa_cache_pkg.fazcbc_record.book_class = 'TAX')) then
1326: -- get the exchange rate from the corporate transaction
1327: if not FA_MC_UTIL_PVT.get_existing_rate
1328: (p_set_of_books_id => l_sob_tbl(l_sob_index),
1329: p_transaction_header_id => px_trans_rec.source_transaction_header_id,

Line 1339: (p_prim_set_of_books_id => fa_cache_pkg.fazcbc_record.set_of_books_id,

1335: -- get the current average rate for the adjustment
1336: l_exchange_date := px_trans_rec.transaction_date_entered;
1337:
1338: if not FA_MC_UTIL_PVT.get_trx_rate
1339: (p_prim_set_of_books_id => fa_cache_pkg.fazcbc_record.set_of_books_id,
1340: p_reporting_set_of_books_id => l_sob_tbl(l_sob_index),
1341: px_exchange_date => l_exchange_date,
1342: p_book_type_code => px_asset_hdr_rec.book_type_code,
1343: px_rate => l_rate,

Line 1355: (p_prim_set_of_books_id => fa_cache_pkg.fazcbc_record.set_of_books_id,

1351: -- get the current average rate for the addition
1352: l_exchange_date := px_trans_rec.transaction_date_entered;
1353:
1354: if not FA_MC_UTIL_PVT.get_trx_rate
1355: (p_prim_set_of_books_id => fa_cache_pkg.fazcbc_record.set_of_books_id,
1356: p_reporting_set_of_books_id => l_sob_tbl(l_sob_index),
1357: px_exchange_date => l_exchange_date,
1358: p_book_type_code => px_asset_hdr_rec.book_type_code,
1359: px_rate => l_rate,

Line 1661: (fa_cache_pkg.fazccmt (

1657: -- First find out if we have a polish mechanism here
1658: if (p_asset_type_rec.asset_type <> 'GROUP') and
1659: (nvl(l_asset_fin_rec_new.deprn_method_code,
1660: l_asset_fin_rec_adj.deprn_method_code) is not null) and
1661: (fa_cache_pkg.fazccmt (
1662: X_method => nvl(l_asset_fin_rec_new.deprn_method_code,
1663: l_asset_fin_rec_adj.deprn_method_code),
1664: X_life => nvl(l_asset_fin_rec_new.life_in_months,
1665: l_asset_fin_rec_adj.life_in_months),

Line 1668: if (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id is not null) then

1664: X_life => nvl(l_asset_fin_rec_new.life_in_months,
1665: l_asset_fin_rec_adj.life_in_months),
1666: p_log_level_rec => p_log_level_rec
1667: )) then
1668: if (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id is not null) then
1669: if (fa_cache_pkg.fazcdbr_record.polish_rule in (
1670: FA_STD_TYPES.FAD_DBR_POLISH_1,
1671: FA_STD_TYPES.FAD_DBR_POLISH_2,
1672: FA_STD_TYPES.FAD_DBR_POLISH_3,

Line 1669: if (fa_cache_pkg.fazcdbr_record.polish_rule in (

1665: l_asset_fin_rec_adj.life_in_months),
1666: p_log_level_rec => p_log_level_rec
1667: )) then
1668: if (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id is not null) then
1669: if (fa_cache_pkg.fazcdbr_record.polish_rule in (
1670: FA_STD_TYPES.FAD_DBR_POLISH_1,
1671: FA_STD_TYPES.FAD_DBR_POLISH_2,
1672: FA_STD_TYPES.FAD_DBR_POLISH_3,
1673: FA_STD_TYPES.FAD_DBR_POLISH_4,

Line 1975: if (fa_cache_pkg.fazcbc_record.allow_cip_dep_group_flag = 'Y') then

1971:
1972: -- copy the delta cost if any into the group's fin_rec
1973: if (p_asset_type_rec.asset_type = 'CIP') then
1974:
1975: if (fa_cache_pkg.fazcbc_record.allow_cip_dep_group_flag = 'Y') then
1976: l_src_asset_fin_rec_adj.cip_cost := nvl(l_asset_fin_rec_adj.cip_cost, 0);
1977: l_src_asset_fin_rec_adj.cost := nvl(l_asset_fin_rec_adj.cost, 0) - nvl(l_asset_fin_rec_adj.cip_cost, 0);
1978: else
1979: l_src_asset_fin_rec_adj.cip_cost := nvl(l_asset_fin_rec_adj.cost, 0);