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 110: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;

106:
107: l_deprn_exp NUMBER;
108: l_bonus_deprn_exp NUMBER;
109:
110: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
111:
112: l_member_exists VARCHAR2(1) := 'N';
113: l_deprn_reserve NUMBER;
114: l_temp_num NUMBER;

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

336: l_adj.period_counter_created := p_period_rec.period_counter;
337: l_adj.period_counter_adjusted := p_period_rec.period_counter;
338: l_adj.current_units := l_asset_desc_rec.current_units;
339: l_adj.selection_retid := 0;
340: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
341: l_adj.leveling_flag := TRUE;
342: l_adj.flush_adj_flag := FALSE;
343: l_adj.last_update_date := p_trans_rec.who_info.last_update_date;
344: l_adj.gen_ccid_flag := TRUE;

Line 806: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;

802:
803: l_distribution_id NUMBER(15);
804: l_units_assigned NUMBER;
805:
806: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
807:
808: l_deprn_exp NUMBER;
809: l_bonus_deprn_exp NUMBER;
810:

Line 1491: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;

1487: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1488: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1489: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1490:
1491: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
1492:
1493: l_deprn_exp NUMBER;
1494: l_bonus_deprn_exp NUMBER;
1495:

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

1581: (NVL(p_asset_retire_rec.units_retired, 0) = g_current_units)) THEN
1582: --end 3440308
1583: l_adj.adjustment_amount := p_asset_retire_rec.cost_retired;
1584: l_adj.selection_thid := 0;
1585: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
1586:
1587: if not FA_INS_ADJUST_PKG.faxinaj
1588: (l_adj,
1589: p_trans_rec.who_info.last_update_date,

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

1619: l_adj.account := fa_cache_pkg.fazccb_record.asset_cost_acct;
1620: end if;
1621:
1622: l_adj.selection_thid := 0;
1623: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
1624: l_adj.current_units := p_asset_desc_rec.current_units;
1625:
1626: l_adj.debit_credit_flag := 'DR';
1627: l_adj.leveling_flag := FALSE;

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

1654: --
1655: if (p_asset_fin_rec.tracking_method = 'ALLOCATE') or
1656: (p_asset_fin_rec.tracking_method = 'CALCULATE') and
1657: (nvl(p_asset_fin_rec.member_rollup_flag, 'N') = 'N') then
1658: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
1659: l_adj.distribution_id := 0;
1660:
1661: l_adj.adjustment_type := 'RESERVE';
1662: l_adj.debit_credit_flag := 'DR';

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

1845: end if;
1846:
1847: l_adj.asset_id := p_asset_fin_rec.group_asset_id;
1848: l_adj.transaction_header_id := p_group_thid;
1849: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
1850: l_adj.distribution_id := 0;
1851:
1852: l_adj.adjustment_type := 'RESERVE';
1853: l_adj.debit_credit_flag := 'DR';

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

2067: l_adj.account := fa_cache_pkg.fazccb_record.deprn_expense_acct;
2068: l_adj.account_type := 'DEPRN_EXPENSE_ACCT';
2069: l_adj.asset_id := p_asset_hdr_rec.asset_id;
2070: l_adj.adjustment_amount := abs(l_deprn_exp);
2071: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2072: l_adj.mrc_sob_type_code := p_mrc_sob_type_code;
2073:
2074: if (nvl(p_asset_fin_rec.member_rollup_flag, 'N') = 'N') then
2075: l_adj.track_member_flag := 'Y';

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

2116: l_adj.account := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;
2117: l_adj.account_type := 'BONUS_DEPRN_EXPENSE_ACCT';
2118: l_adj.asset_id := p_asset_hdr_rec.asset_id;
2119: l_adj.adjustment_amount := abs(l_deprn_exp);
2120: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2121: l_adj.mrc_sob_type_code := p_mrc_sob_type_code;
2122:
2123: if (nvl(p_asset_fin_rec.member_rollup_flag, 'N') = 'N') then
2124: l_adj.track_member_flag := 'Y';

Line 2278: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;

2274: --kawa
2275: -- CURSOR c_get_ret_reserve
2276:
2277: l_ret_period_counter NUMBER := to_number(null);
2278: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
2279:
2280: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2281: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
2282:

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

2307: raise calc_err;
2308: end if;
2309:
2310: --
2311: -- populate FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT(l_adj)to
2312: -- call FA_INS_ADJUST_PKG.faxinaj
2313: --
2314: l_adj.transaction_header_id := p_trans_rec.transaction_header_id;
2315: l_adj.source_type_code := 'RETIREMENT';

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

2359: l_adj.debit_credit_flag := 'CR';
2360: else
2361: l_adj.debit_credit_flag := 'DR';
2362: l_adj.selection_thid := 0;
2363: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2364: end if;
2365:
2366: --tk_util.DumpAdjRec(l_adj, l_adj.debit_credit_flag||':'||to_char(nvl(p_asset_retire_rec.units_retired, 0)));
2367: if not FA_INS_ADJUST_PKG.faxinaj

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

2387: l_adj.account := fa_cache_pkg.fazccb_record.asset_cost_acct;
2388: end if;
2389:
2390: l_adj.selection_thid := 0;
2391: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2392: l_adj.current_units := p_asset_desc_rec.current_units;
2393: l_adj.debit_credit_flag := 'DR';
2394: l_adj.leveling_flag := FALSE;
2395: l_adj.adjustment_amount := l_adj.amount_inserted +

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

2433: fa_debug_pkg.add(l_calling_fn, 'reserve retired',
2434: p_asset_retire_rec.reserve_retired,p_log_level_rec);
2435: end if;
2436:
2437: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2438: l_adj.distribution_id := 0;
2439:
2440: l_adj.adjustment_type := 'RESERVE';
2441: l_adj.debit_credit_flag := 'CR';

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

2487: end if;
2488:
2489: l_adj.asset_id := p_asset_fin_rec.group_asset_id;
2490: l_adj.transaction_header_id := p_group_thid;
2491: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2492: l_adj.distribution_id := 0;
2493:
2494: l_adj.adjustment_type := 'RESERVE';
2495: l_adj.debit_credit_flag := 'CR';

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

2561: end if;
2562: end if;
2563:
2564: l_adj.asset_id := p_asset_fin_rec.group_asset_id;
2565: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2566: l_adj.distribution_id := 0;
2567: l_adj.adjustment_type := 'RESERVE';
2568:
2569: if (l_adj.debit_credit_flag = 'CR') then

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

2622: end if;
2623: end if;
2624:
2625: l_adj.asset_id := p_asset_fin_rec.group_asset_id;
2626: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2627: l_adj.distribution_id := 0;
2628: l_adj.adjustment_type := 'RESERVE';
2629:
2630: if (l_adj.debit_credit_flag = 'CR') then

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

2745: l_adj.account := fa_cache_pkg.fazccb_record.deprn_expense_acct;
2746: l_adj.account_type := 'DEPRN_EXPENSE_ACCT';
2747: l_adj.asset_id := p_asset_hdr_rec.asset_id;
2748: l_adj.adjustment_amount := abs(l_deprn_exp);
2749: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2750: l_adj.mrc_sob_type_code := p_mrc_sob_type_code;
2751:
2752: if (nvl(p_asset_fin_rec.member_rollup_flag, 'N') = 'N') then
2753: l_adj.track_member_flag := 'Y';

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

2793: l_adj.account := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;
2794: l_adj.account_type := 'BONUS_DEPRN_EXPENSE_ACCT';
2795: l_adj.asset_id := p_asset_hdr_rec.asset_id;
2796: l_adj.adjustment_amount := abs(l_deprn_exp);
2797: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2798: l_adj.mrc_sob_type_code := p_mrc_sob_type_code;
2799:
2800: if (nvl(p_asset_fin_rec.member_rollup_flag, 'N') = 'N') then
2801: l_adj.track_member_flag := 'Y';

Line 2930: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;

2926: l_new_reserve NUMBER;
2927: l_new_rec_cost NUMBER;
2928: l_recapture_amount NUMBER;
2929:
2930: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
2931:
2932: l_rowid ROWID; -- temp variable
2933:
2934: calc_err EXCEPTION;

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

3103: l_adj.period_counter_created := l_period_rec.period_counter;
3104: l_adj.period_counter_adjusted := l_period_rec.period_counter;
3105: l_adj.current_units := l_asset_desc_rec.current_units;
3106: l_adj.selection_retid := 0;
3107: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
3108: l_adj.leveling_flag := TRUE;
3109: l_adj.flush_adj_flag := FALSE;
3110: l_adj.last_update_date := l_trans_rec.who_info.last_update_date;
3111: l_adj.gen_ccid_flag := TRUE;

Line 3740: l_adj fa_adjust_type_pkg.fa_adj_row_struct;

3736: from fa_asset_history
3737: where asset_id = p_asset_id
3738: and transaction_header_id_out is null;
3739:
3740: l_adj fa_adjust_type_pkg.fa_adj_row_struct;
3741: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
3742:
3743: l_member_exists VARCHAR2(1) := 'N';
3744: l_deprn_reserve NUMBER;

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

3829: FETCH c_get_unit INTO l_adj.current_units , l_asset_cat_rec.category_id;
3830: CLOSE c_get_unit;
3831:
3832: l_adj.selection_retid := 0;
3833: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
3834: l_adj.leveling_flag := TRUE;
3835: l_adj.flush_adj_flag := FALSE;
3836: l_adj.last_update_date := sysdate;
3837: l_adj.gen_ccid_flag := TRUE;

Line 4509: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;

4505: TYPE tab_num15_type IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
4506: TYPE tab_num_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
4507: TYPE tab_char3_type IS TABLE OF VARCHAR2(3) INDEX BY BINARY_INTEGER;
4508:
4509: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
4510: t_asset_id tab_num15_type;
4511: t_transaction_header_id_in tab_num15_type;
4512: t_rate_adjustment_factor tab_num_type;
4513: t_recoverable_cost tab_num_type;

Line 4555: -- Prepare common FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT parameters

4551: fa_debug_pkg.add(l_calling_fn, 'Begin', p_asset_hdr_rec.asset_id,p_log_level_rec);
4552: fa_debug_pkg.add(l_calling_fn, 'Transaction_key', p_trans_rec.transaction_key,p_log_level_rec);
4553: end if;
4554:
4555: -- Prepare common FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT parameters
4556: l_adj.book_type_code := p_asset_hdr_rec.book_type_code;
4557: l_adj.period_counter_created := p_period_rec.period_counter;
4558: l_adj.period_counter_adjusted := p_period_rec.period_counter;
4559: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

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

4555: -- Prepare common FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT parameters
4556: l_adj.book_type_code := p_asset_hdr_rec.book_type_code;
4557: l_adj.period_counter_created := p_period_rec.period_counter;
4558: l_adj.period_counter_adjusted := p_period_rec.period_counter;
4559: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
4560: l_adj.selection_retid := 0;
4561: l_adj.leveling_flag := TRUE;
4562: l_adj.flush_adj_flag := TRUE; -- FALSE;
4563: l_adj.last_update_date := p_trans_rec.who_info.last_update_date;

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

4752: ) RETURNING transaction_header_id BULK COLLECT INTO t_thid;
4753:
4754:
4755: l_loc := 'Before ADJ LOOP';
4756: -- Prepare non-common FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT parameters and
4757: -- call faxinaj to create records in FA_ADJUSTMENTS table
4758: if (p_log_level_rec.statement_level) then
4759: fa_debug_pkg.add(l_calling_fn, 'Before ADJ LOOP', t_asset_id(1),p_log_level_rec);
4760: fa_debug_pkg.add(l_calling_fn, 't_asset_id.last', t_asset_id.last,p_log_level_rec);