APPS.FA_ADJUSTMENTS_T_PKG dependencies on FA_ADJUSTMENTS_T

Line 1: PACKAGE BODY FA_ADJUSTMENTS_T_PKG AS

1: PACKAGE BODY FA_ADJUSTMENTS_T_PKG AS
2: /* $Header: fapadjtb.pls 120.1.12010000.8 2010/04/29 12:21:22 deemitta ship $ */
3:
4: procedure prepare(w_clause in varchar2, p_batch_id in number, action_flag in varchar2) is
5:

Line 54: l_calling_fn varchar2(50) := 'FA_ADJUSTMENTS_T_PKG.submit';

50: l_date_placed_in_service datetbltyp;
51: l_original_deprn_start_date datetbltyp;
52: rc_extended_deprn refcrs;
53: l_query varchar2(5000);
54: l_calling_fn varchar2(50) := 'FA_ADJUSTMENTS_T_PKG.submit';
55: v_err_code number;
56: v_err_msg varchar2(255);
57:
58: l_batch_size number;

Line 68: from fa_adjustments_t

64: cursor c_books is
65: select asset_number anum
66: , book_type_code book
67: , allowed_deprn_limit_amount limit_amt
68: from fa_adjustments_t
69: where extended_deprn_flag = 'Y'
70: and batch_id = p_batch_id
71: order by asset_number;
72:

Line 77: from fa_adjustments_t fat

73: cursor all_books is
74: select asset_id aid
75: , fat.asset_number anum
76: , book_type_code book
77: from fa_adjustments_t fat
78: , fa_additions_b fab
79: where batch_id = p_batch_id
80: and fat.asset_number = fab.asset_number
81: order by book_type_code;

Line 89: , fa_adjustments_t fat

85: select fadp.period_name name
86: , fat.asset_number num
87: , fat.book_type_code book
88: from fa_deprn_periods fadp
89: , fa_adjustments_t fat
90: where fadp.period_counter = fat.period_counter_fully_reserved
91: and fadp.book_type_code = fat.book_type_code
92: and fat.batch_id = p_batch_id;
93:

Line 200: insert into fa_adjustments_t

196: /* Added for 7632858 */
197: if l_asset_number.count > 0 then
198:
199: forall j in l_asset_number.first..l_asset_number.last
200: insert into fa_adjustments_t
201: (
202: asset_number,
203: asset_type,
204: attribute_category_code,

Line 320: , fa_adjustments_t fat

316: from fa_book_controls bc
317: , fa_fiscal_year fy
318: , fa_calendar_types ct
319: , fa_calendar_periods cp
320: , fa_adjustments_t fat
321: where bc.book_type_code = i.book
322: and fat.batch_id = p_batch_id
323: and fat.asset_number = i.anum
324: and bc.deprn_calendar = ct.calendar_type

Line 333: update fa_adjustments_t

329: and cp.start_date >= to_date('01/04/2007', 'DD/MM/RRRR')
330: and fy.fiscal_year = (fat.extended_depreciation_period-1)/ct.number_per_fiscal_year
331: and cp.start_date = fy.start_date;
332:
333: update fa_adjustments_t
334: set extended_deprn_period_name = l_name
335: , extended_deprn_limit = i.limit_amt
336: where book_type_code = i.book
337: and asset_number = i.anum

Line 353: update fa_adjustments_t

349:
350: for i in set_period_name loop
351: l_count := l_count + 1;
352:
353: update fa_adjustments_t
354: set period_name = i.name
355: where book_type_code = i.book
356: and asset_number = i.num
357: and batch_id = p_batch_id;

Line 408: update fa_adjustments_t

404: and bks.period_counter_fully_reserved is not null
405: and bks.transaction_header_id_out is null;
406:
407:
408: update fa_adjustments_t
409: set extended_deprn_period_name = l_name
410: , extended_depreciation_period = l_pctr
411: , posting_status = 'POST'
412: , extended_deprn_flag = 'Y'

Line 427: update fa_adjustments_t

423:
424: end loop;
425:
426: elsif (action_flag <> 'U') then -- flag U indicates no action to be taken, as Avail Extended Deprn was Undecided for Bulk operation
427: update fa_adjustments_t
428: set posting_status = 'POST'
429: , extended_deprn_flag = action_flag
430: where batch_id = p_batch_id;
431:

Line 442: END FA_ADJUSTMENTS_T_PKG;

438: v_err_msg := sqlerrm(sqlcode);
439:
440: end;
441:
442: END FA_ADJUSTMENTS_T_PKG;