DBA Data[Home] [Help]

APPS.FA_TRACK_MEMBER_PVT dependencies on FA_STD_TYPES

Line 3322: if h_deprn_override_flag <> fa_std_types.FA_NO_OVERRIDE then

3318: fa_debug_pkg.add(l_calling_fn, 'h_deprn_override_flag', h_deprn_override_flag, p_log_level_rec);
3319: end if;
3320:
3321: h_deprn_override := 0;
3322: if h_deprn_override_flag <> fa_std_types.FA_NO_OVERRIDE then
3323: if nvl(P_group_level_override,'N') = 'Y' then
3324: rollback to member_override;
3325: raise allocation_main_override_err;
3326: else

Line 3329: if h_deprn_override_flag = fa_std_types.FA_OVERRIDE_DPR then

3325: raise allocation_main_override_err;
3326: else
3327: x_override_flag := 'Y';
3328: end if;
3329: if h_deprn_override_flag = fa_std_types.FA_OVERRIDE_DPR then
3330: x_allocated_deprn_amount := h_perd_deprn_amount;
3331: h_deprn_override := 1;
3332: elsif h_deprn_override_flag = fa_std_types.FA_OVERRIDE_DPR_BONUS then
3333: x_allocated_deprn_amount := h_perd_deprn_amount;

Line 3332: elsif h_deprn_override_flag = fa_std_types.FA_OVERRIDE_DPR_BONUS then

3328: end if;
3329: if h_deprn_override_flag = fa_std_types.FA_OVERRIDE_DPR then
3330: x_allocated_deprn_amount := h_perd_deprn_amount;
3331: h_deprn_override := 1;
3332: elsif h_deprn_override_flag = fa_std_types.FA_OVERRIDE_DPR_BONUS then
3333: x_allocated_deprn_amount := h_perd_deprn_amount;
3334: x_allocated_bonus_amount := h_perd_bonus_amount;
3335: h_deprn_override := 3;
3336: elsif h_deprn_override_flag = fa_std_types.FA_OVERRIDE_BONUS then

Line 3336: elsif h_deprn_override_flag = fa_std_types.FA_OVERRIDE_BONUS then

3332: elsif h_deprn_override_flag = fa_std_types.FA_OVERRIDE_DPR_BONUS then
3333: x_allocated_deprn_amount := h_perd_deprn_amount;
3334: x_allocated_bonus_amount := h_perd_bonus_amount;
3335: h_deprn_override := 3;
3336: elsif h_deprn_override_flag = fa_std_types.FA_OVERRIDE_BONUS then
3337: x_allocated_bonus_amount := h_perd_bonus_amount;
3338: h_deprn_override := 2;
3339: end if; -- override type check
3340:

Line 3669: FUNCTION update_deprn_basis(p_group_rule_in in fa_std_types.fa_deprn_rule_in_struct,

3665: -- When l_process_deprn_for_member is 'NO', this is not processed.
3666: --
3667: ----------------------------------------------------------------------------
3668:
3669: FUNCTION update_deprn_basis(p_group_rule_in in fa_std_types.fa_deprn_rule_in_struct,
3670: p_apply_reduction_flag in varchar2, -- default NULL,
3671: p_mode in varchar2,
3672: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) -- default NULL)
3673: return boolean is

Line 3676: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;

3672: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) -- default NULL)
3673: return boolean is
3674:
3675: --* Structure to call Deprn Basis Rule
3676: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;
3677: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;
3678:
3679: --* Internal Variables
3680: x_counter number;

Line 3677: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;

3673: return boolean is
3674:
3675: --* Structure to call Deprn Basis Rule
3676: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;
3677: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;
3678:
3679: --* Internal Variables
3680: x_counter number;
3681: x_added_cost number;

Line 5813: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;

5809: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) -- default null
5810: return boolean is
5811:
5812: --* Structure to call Deprn Basis Rule
5813: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;
5814: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;
5815:
5816: --* Host related variables
5817: h_book_type_code varchar2(15);

Line 5814: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;

5810: return boolean is
5811:
5812: --* Structure to call Deprn Basis Rule
5813: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;
5814: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;
5815:
5816: --* Host related variables
5817: h_book_type_code varchar2(15);
5818: h_group_asset_id number;

Line 6901: p_dpr_in in FA_STD_TYPES.dpr_struct,

6897: FUNCTION get_member_at_start(p_period_rec in FA_API_TYPES.period_rec_type,
6898: p_trans_rec in FA_API_TYPES.trans_rec_type,
6899: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
6900: p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type,
6901: p_dpr_in in FA_STD_TYPES.dpr_struct,
6902: p_mrc_sob_type_code in varchar2 default 'N',
6903: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
6904: return boolean is
6905:

Line 6980: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;

6976: l_calling_fn varchar2(45) := 'fa_track_member_pvt.get_member_at_start';
6977: get_member_at_start_err exception;
6978:
6979: --* Structure to call Deprn Basis Rule
6980: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;
6981: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;
6982:
6983: --* Get all transaction headers exists until the specified period
6984: cursor ALL_TRANS_IN_PERIOD(p_fiscal_year number, p_period_num number,p_member_asset_id number) is

Line 6981: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;

6977: get_member_at_start_err exception;
6978:
6979: --* Structure to call Deprn Basis Rule
6980: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;
6981: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;
6982:
6983: --* Get all transaction headers exists until the specified period
6984: cursor ALL_TRANS_IN_PERIOD(p_fiscal_year number, p_period_num number,p_member_asset_id number) is
6985: select TH.TRANSACTION_HEADER_ID

Line 7734: p_dpr_in in FA_STD_TYPES.dpr_struct,

7730: --+=====================================================================
7731:
7732: FUNCTION update_member_books(p_trans_rec in FA_API_TYPES.trans_rec_type,
7733: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
7734: p_dpr_in in FA_STD_TYPES.dpr_struct,
7735: p_mrc_sob_type_code in varchar2,
7736: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) -- default 'N'
7737: return boolean is
7738:

Line 7994: p_dpr_in in FA_STD_TYPES.dpr_struct,

7990: --
7991: --+=====================================================================
7992:
7993: FUNCTION member_eofy_rsv(p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
7994: p_dpr_in in FA_STD_TYPES.dpr_struct,
7995: p_mrc_sob_type_code in varchar2,
7996: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) -- default 'N'
7997: return boolean is
7998:

Line 8797: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;

8793: and BK_OUT.asset_id(+) = BK_IN.asset_id
8794: and BK_OUT.transaction_header_id_out(+) = BK_IN.transaction_header_id_in;
8795:
8796: --* Structure to call Deprn Basis Rule
8797: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;
8798: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;
8799:
8800:
8801: BEGIN

Line 8798: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;

8794: and BK_OUT.transaction_header_id_out(+) = BK_IN.transaction_header_id_in;
8795:
8796: --* Structure to call Deprn Basis Rule
8797: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;
8798: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;
8799:
8800:
8801: BEGIN
8802: if (p_log_level_rec.statement_level) then

Line 10758: FUNCTION display_debug_message(fa_rule_in in fa_std_types.fa_deprn_rule_in_struct,

10754: -- This function will be called to display debug message
10755: --
10756: --+=====================================================================
10757:
10758: FUNCTION display_debug_message(fa_rule_in in fa_std_types.fa_deprn_rule_in_struct,
10759: p_calling_fn in varchar2,
10760: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
10761:
10762: return boolean is

Line 11360: x_deprn_override_flag:= fa_std_types.FA_OVERRIDE_DPR;

11356: l_avg_rate:= report_cost / primary_cost;
11357: end if;
11358:
11359: IF x_override_deprn_amount is not null THEN
11360: x_deprn_override_flag:= fa_std_types.FA_OVERRIDE_DPR;
11361: x_deprn_override_flag:= fa_std_types.FA_OVERRIDE_DPR;
11362: if (h_reporting_flag = 'R') then
11363: x_override_deprn_amount := x_override_deprn_amount * l_avg_rate;
11364: end if;

Line 11361: x_deprn_override_flag:= fa_std_types.FA_OVERRIDE_DPR;

11357: end if;
11358:
11359: IF x_override_deprn_amount is not null THEN
11360: x_deprn_override_flag:= fa_std_types.FA_OVERRIDE_DPR;
11361: x_deprn_override_flag:= fa_std_types.FA_OVERRIDE_DPR;
11362: if (h_reporting_flag = 'R') then
11363: x_override_deprn_amount := x_override_deprn_amount * l_avg_rate;
11364: end if;
11365: IF x_override_bonus_amount is not null THEN

Line 11366: x_deprn_override_flag:= fa_std_types.FA_OVERRIDE_DPR_BONUS;

11362: if (h_reporting_flag = 'R') then
11363: x_override_deprn_amount := x_override_deprn_amount * l_avg_rate;
11364: end if;
11365: IF x_override_bonus_amount is not null THEN
11366: x_deprn_override_flag:= fa_std_types.FA_OVERRIDE_DPR_BONUS;
11367: if (h_reporting_flag = 'R') then
11368: x_override_bonus_amount:= x_override_bonus_amount * l_avg_rate;
11369: end if;
11370: END IF;

Line 11372: x_deprn_override_flag:= fa_std_types.FA_OVERRIDE_BONUS;

11368: x_override_bonus_amount:= x_override_bonus_amount * l_avg_rate;
11369: end if;
11370: END IF;
11371: ELSIF x_override_bonus_amount is not null THEN
11372: x_deprn_override_flag:= fa_std_types.FA_OVERRIDE_BONUS;
11373: if (h_reporting_flag = 'R') then
11374: x_override_bonus_amount:= x_override_bonus_amount * l_avg_rate;
11375: end if;
11376: ELSE

Line 11377: x_deprn_override_flag:= fa_std_types.FA_NO_OVERRIDE;

11373: if (h_reporting_flag = 'R') then
11374: x_override_bonus_amount:= x_override_bonus_amount * l_avg_rate;
11375: end if;
11376: ELSE
11377: x_deprn_override_flag:= fa_std_types.FA_NO_OVERRIDE;
11378: END IF;
11379:
11380: -- When user provided YTD amount
11381: IF NVL(h_subtract_ytd_flag,'N') = 'Y' THEN

Line 11397: x_deprn_override_flag:= fa_std_types.FA_NO_OVERRIDE;

11393: return(TRUE);
11394:
11395: exception
11396: when others then
11397: x_deprn_override_flag:= fa_std_types.FA_NO_OVERRIDE;
11398: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
11399: p_log_level_rec => p_log_level_rec);
11400: return(TRUE);
11401: