APPS.FA_XADJ_ITF_PKG dependencies on FA_ADJUSTMENTS_T

Line 87: from fa_adjustments_t fat,

83: , fat.extended_deprn_flag flag
84: , fat.extended_depreciation_period period
85: , fat.posting_status status
86: , fat.extended_deprn_limit -- bug 6658280
87: from fa_adjustments_t fat,
88: fa_additions_b fab
89: where fat.asset_number = fab.asset_number
90: and fat.posting_status = 'POST' /* bug 8597025 */
91: and fat.batch_id = p_batch_id

Line 226: from fa_adjustments_t fat

222:
223: select min(asset_id), max(asset_id)
224: into l_start_range
225: , l_end_range
226: from fa_adjustments_t fat
227: , fa_additions_b fab
228: where batch_id = p_batch_id
229: and fat.asset_number = fab.asset_number;
230:

Line 283: update fa_adjustments_t

279: if (nvl(l_extended_deprn_flag(l_loop_count), 'NULL') <> 'Y' and
280: nvl(p_old_flag, 'NULL') <> 'Y') then
281:
282: if(nvl(l_posting_status(l_loop_count),'NULL') <> 'POST') then
283: update fa_adjustments_t
284: set request_id = l_request_id
285: where rowid = l_itf_rowid(l_loop_count);
286:
287: else

Line 296: update fa_adjustments_t

292: where asset_id = l_asset_id(l_loop_count)
293: and book_type_code = l_book_type_code(l_loop_count)
294: and transaction_header_id_out is null;
295: end if;
296: update fa_adjustments_t
297: set posting_status = 'POSTED'
298: , request_id = l_request_id
299: where rowid = l_itf_rowid(l_loop_count);
300: end if;

Line 314: update fa_adjustments_t

310: else
311: if(nvl(l_posting_status(l_loop_count),'NULL') <> 'POST' or
312: nvl(l_extended_deprn_flag(l_loop_count),'NULL') = 'NULL' or
313: nvl(l_extended_deprn_flag(l_loop_count),'NULL') = nvl(p_old_flag,'NULL')) then
314: update fa_adjustments_t
315: set request_id = l_request_id
316: where rowid = l_itf_rowid(l_loop_count);
317: else
318:

Line 399: update fa_adjustments_t

395: raise data_error;
396: end if;
397:
398: -- flag interface record as posted
399: update fa_adjustments_t
400: set posting_status = 'POSTED',
401: request_id = l_request_id
402: where rowid = l_itf_rowid(l_loop_count);
403:

Line 633: from fa_adjustments_t fat, fa_additions_b fab

629: select min(aid), max(aid), 0,
630: 'UNASSIGNED', p_parent_request_id from ( select /*+ parallel(dh) */
631: fab.asset_id aid, floor(rank()
632: over (order by fab.asset_id)/l_batch_size ) unit_id
633: from fa_adjustments_t fat, fa_additions_b fab
634: where batch_id = p_batch_id
635: and fat.asset_number = fab.asset_number)
636: group by unit_id;
637: