eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_RETIREMENT_PVT dependencies on FA_ADJUST_TYPE_PKG

Line 131: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;

127: l_deprn_exp NUMBER;
128: l_bonus_deprn_exp NUMBER;
129: l_impairment_exp NUMBER;
130:
131: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
132:
133: l_member_exists VARCHAR2(1) := 'N';
134: l_deprn_reserve NUMBER;
135: l_temp_num NUMBER;

Line 398: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

394: l_adj.period_counter_created := p_period_rec.period_counter;
395: l_adj.period_counter_adjusted := p_period_rec.period_counter;
396: l_adj.current_units := l_asset_desc_rec.current_units;
397: l_adj.selection_retid := 0;
398: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
399: l_adj.leveling_flag := TRUE;
400: l_adj.flush_adj_flag := FALSE;
401: l_adj.last_update_date := p_trans_rec.who_info.last_update_date;
402: l_adj.gen_ccid_flag := TRUE;

Line 880: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;

876: l_transaction_type_code varchar2(20); -- Bug#8580378
877: l_partial_retirement_flag BOOLEAN := FALSE;
878: l_tot_units NUMBER := 0;
879:
880: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
881:
882: l_deprn_exp NUMBER;
883: l_bonus_deprn_exp NUMBER;
884: l_impairment_exp NUMBER;

Line 1562: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;

1558: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1559: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1560: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1561:
1562: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
1563:
1564: l_deprn_exp NUMBER;
1565: l_bonus_deprn_exp NUMBER;
1566: l_impairment_exp NUMBER;

Line 1655: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

1651: (NVL(p_asset_retire_rec.units_retired, 0) = g_current_units)) THEN
1652: --end 3440308
1653: l_adj.adjustment_amount := p_asset_retire_rec.cost_retired;
1654: l_adj.selection_thid := 0;
1655: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
1656:
1657: if not FA_INS_ADJUST_PKG.faxinaj
1658: (l_adj,
1659: p_trans_rec.who_info.last_update_date,

Line 1691: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

1687: l_adj.account := fa_cache_pkg.fazccb_record.asset_cost_acct;
1688: end if;
1689:
1690: l_adj.selection_thid := 0;
1691: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
1692: l_adj.current_units := p_asset_desc_rec.current_units;
1693:
1694: l_adj.debit_credit_flag := 'DR';
1695: l_adj.leveling_flag := FALSE;

Line 1726: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

1722: --
1723: if (p_asset_fin_rec.tracking_method = 'ALLOCATE') or
1724: (p_asset_fin_rec.tracking_method = 'CALCULATE') and
1725: (nvl(p_asset_fin_rec.member_rollup_flag, 'N') = 'N') then
1726: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
1727: l_adj.distribution_id := 0;
1728:
1729: l_adj.adjustment_type := 'RESERVE';
1730: l_adj.debit_credit_flag := 'DR';

Line 1929: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

1925: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
1926: raise calc_err;
1927: end if;
1928:
1929: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
1930: l_adj.distribution_id := 0;
1931:
1932: l_adj.adjustment_type := 'RESERVE';
1933: l_adj.debit_credit_flag := 'DR';

Line 2160: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

2156: l_adj.account := fa_cache_pkg.fazccb_record.deprn_expense_acct;
2157: l_adj.account_type := 'DEPRN_EXPENSE_ACCT';
2158: l_adj.asset_id := p_asset_hdr_rec.asset_id;
2159: l_adj.adjustment_amount := abs(l_deprn_exp);
2160: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2161: l_adj.mrc_sob_type_code := p_mrc_sob_type_code;
2162: l_adj.set_of_books_id := p_asset_hdr_rec.set_of_books_id;
2163:
2164: if (nvl(p_asset_fin_rec.member_rollup_flag, 'N') = 'N') then

Line 2212: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

2208: l_adj.account := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;
2209: l_adj.account_type := 'BONUS_DEPRN_EXPENSE_ACCT';
2210: l_adj.asset_id := p_asset_hdr_rec.asset_id;
2211: l_adj.adjustment_amount := abs(l_deprn_exp);
2212: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2213: l_adj.mrc_sob_type_code := p_mrc_sob_type_code;
2214: l_adj.set_of_books_id := p_asset_hdr_rec.set_of_books_id;
2215:
2216: if (nvl(p_asset_fin_rec.member_rollup_flag, 'N') = 'N') then

Line 2257: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

2253: l_adj.account := fa_cache_pkg.fazccb_record.impair_expense_acct;
2254: l_adj.account_type := 'IMPAIR_EXPENSE_ACCT';
2255: l_adj.asset_id := p_asset_hdr_rec.asset_id;
2256: l_adj.adjustment_amount := abs(l_impairment_exp);
2257: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2258: l_adj.mrc_sob_type_code := p_mrc_sob_type_code;
2259: l_adj.set_of_books_id := p_asset_hdr_rec.set_of_books_id;
2260:
2261: if (nvl(p_asset_fin_rec.member_rollup_flag, 'N') = 'N') then

Line 2434: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;

2430: --kawa
2431: -- CURSOR c_get_ret_reserve
2432:
2433: l_ret_period_counter NUMBER := to_number(null);
2434: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
2435:
2436: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2437: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
2438:

Line 2480: -- populate FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT(l_adj)to

2476: End if;
2477: /* bug#15897249 end */
2478:
2479: --
2480: -- populate FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT(l_adj)to
2481: -- call FA_INS_ADJUST_PKG.faxinaj
2482: --
2483: l_adj.transaction_header_id := p_trans_rec.transaction_header_id;
2484: l_adj.source_type_code := 'RETIREMENT';

Line 2533: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

2529: l_adj.debit_credit_flag := 'CR';
2530: else
2531: l_adj.debit_credit_flag := 'DR';
2532: l_adj.selection_thid := 0;
2533: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2534: end if;
2535:
2536: --tk_util.DumpAdjRec(l_adj, l_adj.debit_credit_flag||':'||to_char(nvl(p_asset_retire_rec.units_retired, 0)));
2537: if not FA_INS_ADJUST_PKG.faxinaj

Line 2561: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

2557: l_adj.account := fa_cache_pkg.fazccb_record.asset_cost_acct;
2558: end if;
2559:
2560: l_adj.selection_thid := 0;
2561: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2562: l_adj.current_units := p_asset_desc_rec.current_units;
2563: l_adj.debit_credit_flag := 'DR';
2564: l_adj.leveling_flag := FALSE;
2565: l_adj.adjustment_amount := l_adj.amount_inserted +

Line 2610: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

2606: fa_debug_pkg.add(l_calling_fn, 'reserve retired',
2607: p_asset_retire_rec.reserve_retired, p_log_level_rec => p_log_level_rec);
2608: end if;
2609:
2610: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2611: l_adj.distribution_id := 0;
2612:
2613: l_adj.adjustment_type := 'RESERVE';
2614: l_adj.debit_credit_flag := 'CR';

Line 2672: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

2668: l_adj.asset_id := p_asset_fin_rec.group_asset_id;
2669: l_adj.transaction_header_id := p_group_thid;
2670: End if;
2671: /* bug#15897249 end */
2672: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2673: l_adj.distribution_id := 0;
2674:
2675: l_adj.adjustment_type := 'RESERVE';
2676: l_adj.debit_credit_flag := 'CR';

Line 2764: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

2760:
2761: l_adj.asset_id := p_asset_fin_rec.group_asset_id;
2762: End if;
2763: /* bug#15897249 end */
2764: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2765: l_adj.distribution_id := 0;
2766: l_adj.adjustment_type := 'RESERVE';
2767:
2768: if (l_adj.debit_credit_flag = 'CR') then

Line 2837: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

2833:
2834: l_adj.asset_id := p_asset_fin_rec.group_asset_id;
2835: End if;
2836: /* bug#15897249 end */
2837: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2838: l_adj.distribution_id := 0;
2839: l_adj.adjustment_type := 'RESERVE';
2840:
2841: if (l_adj.debit_credit_flag = 'CR') then

Line 2983: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

2979: l_adj.account := fa_cache_pkg.fazccb_record.deprn_expense_acct;
2980: l_adj.account_type := 'DEPRN_EXPENSE_ACCT';
2981: l_adj.asset_id := p_asset_hdr_rec.asset_id;
2982: l_adj.adjustment_amount := abs(l_deprn_exp);
2983: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2984: l_adj.mrc_sob_type_code := p_mrc_sob_type_code;
2985: l_adj.set_of_books_id := p_asset_hdr_rec.set_of_books_id;
2986:
2987: if (nvl(p_asset_fin_rec.member_rollup_flag, 'N') = 'N') then

Line 3034: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

3030: l_adj.account := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;
3031: l_adj.account_type := 'BONUS_DEPRN_EXPENSE_ACCT';
3032: l_adj.asset_id := p_asset_hdr_rec.asset_id;
3033: l_adj.adjustment_amount := abs(l_deprn_exp);
3034: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
3035: l_adj.mrc_sob_type_code := p_mrc_sob_type_code;
3036: l_adj.set_of_books_id := p_asset_hdr_rec.set_of_books_id;
3037:
3038: if (nvl(p_asset_fin_rec.member_rollup_flag, 'N') = 'N') then

Line 3078: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

3074: l_adj.account := fa_cache_pkg.fazccb_record.impair_expense_acct;
3075: l_adj.account_type := 'IMPAIR_EXPENSE_ACCT';
3076: l_adj.asset_id := p_asset_hdr_rec.asset_id;
3077: l_adj.adjustment_amount := abs(l_impairment_exp);
3078: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
3079: l_adj.mrc_sob_type_code := p_mrc_sob_type_code;
3080: l_adj.set_of_books_id := p_asset_hdr_rec.set_of_books_id;
3081:
3082: if (nvl(p_asset_fin_rec.member_rollup_flag, 'N') = 'N') then

Line 3202: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;

3198: l_new_reserve NUMBER;
3199: l_new_rec_cost NUMBER;
3200: l_recapture_amount NUMBER;
3201:
3202: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
3203:
3204: l_rowid ROWID; -- temp variable
3205:
3206: l_cost_sign NUMBER; --Bug 8535921

Line 3707: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT; --Bug11886090

3703: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
3704: l_period_rec FA_API_TYPES.period_rec_type;
3705: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
3706:
3707: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT; --Bug11886090
3708:
3709: calc_err EXCEPTION;
3710:
3711: BEGIN

Line 3855: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

3851: l_adj.period_counter_created := l_period_rec.period_counter;
3852: l_adj.period_counter_adjusted := l_period_rec.period_counter;
3853: l_adj.current_units := l_asset_desc_rec.current_units;
3854: l_adj.selection_retid := 0;
3855: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
3856: l_adj.leveling_flag := TRUE;
3857: l_adj.flush_adj_flag := TRUE;
3858: l_adj.last_update_date := l_trans_rec.who_info.last_update_date;
3859: l_adj.gen_ccid_flag := TRUE;

Line 4086: l_adj fa_adjust_type_pkg.fa_adj_row_struct;

4082: from fa_asset_history
4083: where asset_id = p_asset_id
4084: and transaction_header_id_out is null;
4085:
4086: l_adj fa_adjust_type_pkg.fa_adj_row_struct;
4087: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
4088:
4089: l_member_exists VARCHAR2(1) := 'N';
4090: l_deprn_reserve NUMBER;

Line 4186: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

4182: FETCH c_get_unit INTO l_adj.current_units , l_asset_cat_rec.category_id;
4183: CLOSE c_get_unit;
4184:
4185: l_adj.selection_retid := 0;
4186: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
4187: l_adj.leveling_flag := TRUE;
4188: l_adj.flush_adj_flag := FALSE;
4189: l_adj.last_update_date := sysdate;
4190: l_adj.gen_ccid_flag := TRUE;

Line 5067: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;

5063: TYPE tab_num15_type IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
5064: TYPE tab_num_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5065: TYPE tab_char3_type IS TABLE OF VARCHAR2(3) INDEX BY BINARY_INTEGER;
5066:
5067: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
5068: t_asset_id FA_NUM15_TBL_TYPE := FA_NUM15_TBL_TYPE(); --Bug 9076882
5069: t_transaction_header_id_in tab_num15_type;
5070: t_rate_adjustment_factor tab_num_type;
5071: t_recoverable_cost tab_num_type;

Line 5127: -- Prepare common FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT parameters

5123: end if;
5124: return TRUE;
5125: end if;
5126:
5127: -- Prepare common FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT parameters
5128: l_adj.book_type_code := p_asset_hdr_rec.book_type_code;
5129: l_adj.period_counter_created := p_period_rec.period_counter;
5130: l_adj.period_counter_adjusted := p_period_rec.period_counter;
5131: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

Line 5131: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

5127: -- Prepare common FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT parameters
5128: l_adj.book_type_code := p_asset_hdr_rec.book_type_code;
5129: l_adj.period_counter_created := p_period_rec.period_counter;
5130: l_adj.period_counter_adjusted := p_period_rec.period_counter;
5131: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
5132: l_adj.selection_retid := 0;
5133: l_adj.leveling_flag := TRUE;
5134: l_adj.flush_adj_flag := TRUE; -- FALSE;
5135: l_adj.last_update_date := p_trans_rec.who_info.last_update_date;

Line 5421: -- Prepare non-common FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT parameters and

5417: END IF;
5418:
5419:
5420: l_loc := 'Before ADJ LOOP';
5421: -- Prepare non-common FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT parameters and
5422: -- call faxinaj to create records in FA_ADJUSTMENTS table
5423: if (p_log_level_rec.statement_level) then
5424: fa_debug_pkg.add(l_calling_fn, 'Before ADJ LOOP', t_asset_id(1));
5425: fa_debug_pkg.add(l_calling_fn, 't_asset_id.last', t_asset_id.last, p_log_level_rec => p_log_level_rec);

Line 6739: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;

6735: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
6736: p_mrc_sob_type_code IN VARCHAR2,
6737: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
6738: RETURN BOOLEAN is
6739: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
6740: calc_err exception;
6741: l_calling_fn VARCHAR2(100) := 'fa_group_retirement_pvt.move_reserve_to_act_dist';
6742: l_loc varchar2(100);
6743: l_deprn_reserve NUMBER;

Line 6767: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_SINGLE;

6763: l_adj.selection_thid := 0;
6764: l_adj.selection_retid := 0;
6765: l_adj.leveling_flag := TRUE;
6766: l_adj.last_update_date := p_trans_rec.who_info.last_update_date;
6767: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_SINGLE;
6768: l_adj.current_units := null;
6769: l_adj.debit_credit_flag := 'DR';
6770:
6771: l_adj.flush_adj_flag := TRUE;

Line 6837: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

6833: l_adj.adjustment_amount := l_tot_deprn_reserve;
6834: l_adj.debit_credit_flag := 'CR';
6835: l_adj.selection_thid := 0;
6836: l_adj.distribution_id := 0;
6837: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
6838: if l_tot_deprn_reserve <> 0 then
6839: if not FA_INS_ADJUST_PKG.faxinaj
6840: (l_adj,
6841: p_trans_rec.who_info.last_update_date,