APPS.FA_DELETION_PUB dependencies on FA_CACHE_PKG

Line 62: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;

58: l_orig_currency_context varchar2(64);
59:
60: -- used for tax book loop
61: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
62: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;
63: l_tax_index NUMBER; -- index for tax loop
64:
65: l_calling_fn VARCHAR2(35) := 'fa_deletion_pub.do_delete';
66: del_err EXCEPTION;

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

120: end if;
121:
122:
123: -- call the cache for the primary transaction book
124: if NOT fa_cache_pkg.fazcbc(X_book => px_asset_hdr_rec.book_type_code,
125: p_log_level_rec => g_log_level_rec) then
126: raise del_err;
127: end if;
128:

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

125: p_log_level_rec => g_log_level_rec) then
126: raise del_err;
127: end if;
128:
129: px_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
130:
131: -- verify the asset exist in the book already
132: if not FA_ASSET_VAL_PVT.validate_asset_book
133: (p_transaction_type_code => 'ADJUSTMENT',

Line 154: if not fa_cache_pkg.fazcsob

150: -- that is not tied to a SOB_ID by getting the value from
151: -- the book struct
152:
153: -- Get the book type code P,R or N
154: if not fa_cache_pkg.fazcsob
155: (X_set_of_books_id => px_asset_hdr_rec.set_of_books_id,
156: X_mrc_sob_type_code => l_reporting_flag,
157: p_log_level_rec => g_log_level_rec) then
158: raise del_err;

Line 200: if not fa_cache_pkg.fazcat(X_cat_id => l_asset_cat_rec.category_id

196: end if;
197:
198:
199: -- cache the category info
200: if not fa_cache_pkg.fazcat(X_cat_id => l_asset_cat_rec.category_id
201: ,p_log_level_rec => g_log_level_rec) then
202: raise del_err;
203: end if;
204:

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

213: p_log_level_rec => g_log_level_rec)then
214: raise del_err;
215: end if;
216:
217: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
218:
219: -- note: don't want to use fazctbk cache here
220: -- because the asset may exist in ineffective books
221:

Line 228: if (NOT fa_cache_pkg.fazcbc(X_book => l_tax_rec.book_type_code

224: l_asset_hdr_rec := px_asset_hdr_rec;
225: l_asset_hdr_rec.book_type_code := l_tax_rec.book_type_code;
226:
227: -- cache the book information for the tax book
228: if (NOT fa_cache_pkg.fazcbc(X_book => l_tax_rec.book_type_code
229: ,p_log_level_rec => g_log_level_rec)) then
230: raise del_err;
231: end if;
232:

Line 321: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;

317: -- used for calling private api for reporting books
318: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
319:
320: l_period_rec FA_API_TYPES.period_rec_type;
321: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
322:
323: -- used for local runs
324: l_responsibility_id number;
325: l_application_id number;

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

435: fa_cua_wb_ext_pkg.facuas1(px_asset_hdr_rec.Asset_Id);
436: end if;
437:
438:
439: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
440:
441: -- Added transfer_header_id in the where clause
442: -- as a result of High Cost SQL drill bugfix 3116047 msiddiqu
443:

Line 483: if ( (fa_cache_pkg.fazcat_record.category_type = 'LEASEHOLD IMPROVEMENT')

479:
480: DELETE FROM fa_add_warranties
481: WHERE asset_id= px_asset_hdr_rec.asset_id;
482:
483: if ( (fa_cache_pkg.fazcat_record.category_type = 'LEASEHOLD IMPROVEMENT')
484: and (p_asset_desc_rec.lease_id is not null)) then
485: FA_LEASES_PKG.Delete_Row
486: (X_Lease_Id => p_asset_desc_rec.lease_id,
487: X_Calling_Fn => l_calling_fn

Line 491: elsif (fa_cache_pkg.fazcbc_record.book_class = 'BUDGET') then

487: X_Calling_Fn => l_calling_fn
488: ,p_log_level_rec => p_log_level_rec);
489: end if;
490:
491: elsif (fa_cache_pkg.fazcbc_record.book_class = 'BUDGET') then
492:
493: DELETE FROM FA_CAPITAL_BUDGET WHERE ASSET_ID = px_asset_hdr_rec.asset_id ;
494:
495: End if;