APPS.FA_DELETION_PUB dependencies on FA_CACHE_PKG

Line 62: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;

58: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
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 125: if NOT fa_cache_pkg.fazcbc(X_book => px_asset_hdr_rec.book_type_code, p_log_level_rec => g_log_level_rec) then

121: end if;
122:
123:
124: -- call the cache for the primary transaction book
125: if NOT fa_cache_pkg.fazcbc(X_book => px_asset_hdr_rec.book_type_code, 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;

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

125: if NOT fa_cache_pkg.fazcbc(X_book => px_asset_hdr_rec.book_type_code, 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 146: if not fa_cache_pkg.fazcsob

142: -- that is not tied to a SOB_ID by getting the value from
143: -- the book struct
144:
145: -- Get the book type code P,R or N
146: if not fa_cache_pkg.fazcsob
147: (X_set_of_books_id => px_asset_hdr_rec.set_of_books_id,
148: X_mrc_sob_type_code => l_reporting_flag
149: , p_log_level_rec => g_log_level_rec) then
150: raise del_err;

Line 191: if not fa_cache_pkg.fazcat(X_cat_id => l_asset_cat_rec.category_id, p_log_level_rec => g_log_level_rec) then

187: end if;
188:
189:
190: -- cache the category info
191: if not fa_cache_pkg.fazcat(X_cat_id => l_asset_cat_rec.category_id, p_log_level_rec => g_log_level_rec) then
192: raise del_err;
193: end if;
194:
195:

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

204: )then
205: raise del_err;
206: end if;
207:
208: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
209:
210: -- note: don't want to use fazctbk cache here
211: -- because the asset may exist in ineffective books
212:

Line 219: if (NOT fa_cache_pkg.fazcbc(X_book => l_tax_rec.book_type_code, p_log_level_rec => g_log_level_rec)) then

215: l_asset_hdr_rec := px_asset_hdr_rec;
216: l_asset_hdr_rec.book_type_code := l_tax_rec.book_type_code;
217:
218: -- cache the book information for the tax book
219: if (NOT fa_cache_pkg.fazcbc(X_book => l_tax_rec.book_type_code, p_log_level_rec => g_log_level_rec)) then
220: raise del_err;
221: end if;
222: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id; --Bug 10306673
223: if not do_all_books

Line 222: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id; --Bug 10306673

218: -- cache the book information for the tax book
219: if (NOT fa_cache_pkg.fazcbc(X_book => l_tax_rec.book_type_code, p_log_level_rec => g_log_level_rec)) then
220: raise del_err;
221: end if;
222: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id; --Bug 10306673
223: if not do_all_books
224: (px_asset_hdr_rec => l_asset_hdr_rec , -- tax
225: p_asset_type_rec => l_asset_type_rec,
226: p_asset_desc_rec => l_asset_desc_rec,

Line 299: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;

295: -- used for calling private api for reporting books
296: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
297:
298: l_period_rec FA_API_TYPES.period_rec_type;
299: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
300:
301: -- used for local runs
302: l_responsibility_id number;
303: l_application_id number;

Line 309: g_release number := fa_cache_pkg.fazarel_release;

305: l_rowid varchar2(120);
306:
307: l_calling_fn varchar2(30) := 'fa_delete_pub.do_all_books';
308: del_err EXCEPTION;
309: g_release number := fa_cache_pkg.fazarel_release;
310: -- Added as a result of High Cost SQL drill bugfix 3116047 msiddiqu
311: Cursor C1 is
312: SELECT INVOICE_TRANSACTION_ID_IN,
313: INVOICE_TRANSACTION_ID_OUT

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

424: fa_cua_wb_ext_pkg.facuas1(px_asset_hdr_rec.Asset_Id, p_log_level_rec => p_log_level_rec);
425: end if;
426:
427:
428: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
429:
430: -- Added transfer_header_id in the where clause
431: -- as a result of High Cost SQL drill bugfix 3116047 msiddiqu
432:

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

467:
468: DELETE FROM fa_add_warranties
469: WHERE asset_id= px_asset_hdr_rec.asset_id;
470:
471: if ( (fa_cache_pkg.fazcat_record.category_type = 'LEASEHOLD IMPROVEMENT')
472: and (p_asset_desc_rec.lease_id is not null) ) then
473: FA_LEASES_PKG.Delete_Row
474: (X_Lease_Id => p_asset_desc_rec.lease_id,
475: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

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

474: (X_Lease_Id => p_asset_desc_rec.lease_id,
475: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
476: end if;
477:
478: elsif (fa_cache_pkg.fazcbc_record.book_class = 'BUDGET') then
479:
480: DELETE FROM FA_CAPITAL_BUDGET WHERE ASSET_ID = px_asset_hdr_rec.asset_id ;
481:
482: End if;