DBA Data[Home] [Help]

APPS.FA_TRACK_MEMBER_PVT dependencies on FA_STD_TYPES

Line 3476: if h_deprn_override_flag <> fa_std_types.FA_NO_OVERRIDE then

3472: fa_debug_pkg.add(l_calling_fn, 'h_deprn_override_flag', h_deprn_override_flag, p_log_level_rec => p_log_level_rec);
3473: end if;
3474:
3475: h_deprn_override := 0;
3476: if h_deprn_override_flag <> fa_std_types.FA_NO_OVERRIDE then
3477: if nvl(P_group_level_override,'N') = 'Y' then
3478: rollback to member_override;
3479: raise allocation_main_override_err;
3480: else

Line 3483: if h_deprn_override_flag = fa_std_types.FA_OVERRIDE_DPR then

3479: raise allocation_main_override_err;
3480: else
3481: x_override_flag := 'Y';
3482: end if;
3483: if h_deprn_override_flag = fa_std_types.FA_OVERRIDE_DPR then
3484: x_allocated_deprn_amount := h_perd_deprn_amount;
3485: h_deprn_override := 1;
3486: elsif h_deprn_override_flag = fa_std_types.FA_OVERRIDE_DPR_BONUS then
3487: x_allocated_deprn_amount := h_perd_deprn_amount;

Line 3486: elsif h_deprn_override_flag = fa_std_types.FA_OVERRIDE_DPR_BONUS then

3482: end if;
3483: if h_deprn_override_flag = fa_std_types.FA_OVERRIDE_DPR then
3484: x_allocated_deprn_amount := h_perd_deprn_amount;
3485: h_deprn_override := 1;
3486: elsif h_deprn_override_flag = fa_std_types.FA_OVERRIDE_DPR_BONUS then
3487: x_allocated_deprn_amount := h_perd_deprn_amount;
3488: x_allocated_bonus_amount := h_perd_bonus_amount;
3489: h_deprn_override := 3;
3490: elsif h_deprn_override_flag = fa_std_types.FA_OVERRIDE_BONUS then

Line 3490: elsif h_deprn_override_flag = fa_std_types.FA_OVERRIDE_BONUS then

3486: elsif h_deprn_override_flag = fa_std_types.FA_OVERRIDE_DPR_BONUS then
3487: x_allocated_deprn_amount := h_perd_deprn_amount;
3488: x_allocated_bonus_amount := h_perd_bonus_amount;
3489: h_deprn_override := 3;
3490: elsif h_deprn_override_flag = fa_std_types.FA_OVERRIDE_BONUS then
3491: x_allocated_bonus_amount := h_perd_bonus_amount;
3492: h_deprn_override := 2;
3493: end if; -- override type check
3494:

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

3815: -- When l_process_deprn_for_member is 'NO', this is not processed.
3816: --
3817: ----------------------------------------------------------------------------
3818:
3819: FUNCTION update_deprn_basis(p_group_rule_in in fa_std_types.fa_deprn_rule_in_struct,
3820: p_apply_reduction_flag in varchar2, -- default NULL,
3821: p_mode in varchar2
3822: ,p_log_level_rec IN fa_api_types.log_level_rec_type) -- default NULL)
3823: return boolean is

Line 3826: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;

3822: ,p_log_level_rec IN fa_api_types.log_level_rec_type) -- default NULL)
3823: return boolean is
3824:
3825: --* Structure to call Deprn Basis Rule
3826: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;
3827: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;
3828:
3829: --* Internal Variables
3830: x_counter number;

Line 3827: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;

3823: return boolean is
3824:
3825: --* Structure to call Deprn Basis Rule
3826: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;
3827: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;
3828:
3829: --* Internal Variables
3830: x_counter number;
3831: x_added_cost number;

Line 5975: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;

5971: p_calling_fn in varchar2 ,p_log_level_rec IN fa_api_types.log_level_rec_type) -- default null
5972: return boolean is
5973:
5974: --* Structure to call Deprn Basis Rule
5975: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;
5976: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;
5977:
5978: --* Host related variables
5979: h_book_type_code varchar2(30);

Line 5976: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;

5972: return boolean is
5973:
5974: --* Structure to call Deprn Basis Rule
5975: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;
5976: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;
5977:
5978: --* Host related variables
5979: h_book_type_code varchar2(30);
5980: h_group_asset_id number;

Line 7072: p_dpr_in in FA_STD_TYPES.dpr_struct,

7068: FUNCTION get_member_at_start(p_period_rec in FA_API_TYPES.period_rec_type,
7069: p_trans_rec in FA_API_TYPES.trans_rec_type,
7070: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
7071: p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type,
7072: p_dpr_in in FA_STD_TYPES.dpr_struct,
7073: p_mrc_sob_type_code in varchar2 default 'N', p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
7074: return boolean is
7075:
7076: --* Host related variables

Line 7150: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;

7146: l_calling_fn varchar2(45) := 'fa_track_member_pvt.get_member_at_start';
7147: get_member_at_start_err exception;
7148:
7149: --* Structure to call Deprn Basis Rule
7150: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;
7151: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;
7152:
7153: --* Get all transaction headers exists until the specified period
7154: cursor ALL_TRANS_IN_PERIOD(p_fiscal_year number, p_period_num number,p_member_asset_id number) is

Line 7151: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;

7147: get_member_at_start_err exception;
7148:
7149: --* Structure to call Deprn Basis Rule
7150: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;
7151: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;
7152:
7153: --* Get all transaction headers exists until the specified period
7154: cursor ALL_TRANS_IN_PERIOD(p_fiscal_year number, p_period_num number,p_member_asset_id number) is
7155: select TH.TRANSACTION_HEADER_ID

Line 7913: p_dpr_in in FA_STD_TYPES.dpr_struct,

7909: --+=====================================================================
7910:
7911: FUNCTION update_member_books(p_trans_rec in FA_API_TYPES.trans_rec_type,
7912: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
7913: p_dpr_in in FA_STD_TYPES.dpr_struct,
7914: p_mrc_sob_type_code in varchar2
7915: ,p_log_level_rec IN fa_api_types.log_level_rec_type) -- default 'N'
7916: return boolean is
7917:

Line 8220: p_dpr_in in FA_STD_TYPES.dpr_struct,

8216: --
8217: --+=====================================================================
8218:
8219: FUNCTION member_eofy_rsv(p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
8220: p_dpr_in in FA_STD_TYPES.dpr_struct,
8221: p_mrc_sob_type_code in varchar2
8222: ,p_log_level_rec IN fa_api_types.log_level_rec_type) -- default 'N'
8223: return boolean is
8224:

Line 9077: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;

9073: and BK_OUT.transaction_header_id_out(+) = BK_IN.transaction_header_id_in
9074: and BK_OUT.set_of_books_id(+) = h_set_of_books_id; --Bug 8941132
9075:
9076: --* Structure to call Deprn Basis Rule
9077: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;
9078: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;
9079:
9080: cursor c_get_member_asset_id is
9081: select mth.asset_id

Line 9078: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;

9074: and BK_OUT.set_of_books_id(+) = h_set_of_books_id; --Bug 8941132
9075:
9076: --* Structure to call Deprn Basis Rule
9077: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;
9078: fa_rule_out fa_std_types.fa_deprn_rule_out_struct;
9079:
9080: cursor c_get_member_asset_id is
9081: select mth.asset_id
9082: from fa_transaction_headers mth

Line 9099: (fa_cache_pkg.fazccmt_record.rate_source_rule = FA_STD_TYPES.FAD_RSR_PROD) then

9095: h_set_of_books_id := p_asset_hdr_rec.set_of_books_id;
9096:
9097: /*Bug13805724 - No need to process all assets ,process one in transaction. */
9098: if (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') and -- ENERGY
9099: (fa_cache_pkg.fazccmt_record.rate_source_rule = FA_STD_TYPES.FAD_RSR_PROD) then
9100: open c_get_member_asset_id;
9101: fetch c_get_member_asset_id into l_member_asset_id;
9102: close c_get_member_asset_id;
9103: if (p_log_level_rec.statement_level) then

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

11090: -- This function will be called to display debug message
11091: --
11092: --+=====================================================================
11093:
11094: FUNCTION display_debug_message(fa_rule_in in fa_std_types.fa_deprn_rule_in_struct,
11095: p_calling_fn in varchar2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
11096:
11097: return boolean is
11098:

Line 11696: x_deprn_override_flag:= fa_std_types.FA_OVERRIDE_DPR;

11692: l_avg_rate:= report_cost / primary_cost;
11693: end if;
11694:
11695: IF x_override_deprn_amount is not null THEN
11696: x_deprn_override_flag:= fa_std_types.FA_OVERRIDE_DPR;
11697: x_deprn_override_flag:= fa_std_types.FA_OVERRIDE_DPR;
11698: if (h_reporting_flag = 'R') then
11699: x_override_deprn_amount := x_override_deprn_amount * l_avg_rate;
11700: end if;

Line 11697: x_deprn_override_flag:= fa_std_types.FA_OVERRIDE_DPR;

11693: end if;
11694:
11695: IF x_override_deprn_amount is not null THEN
11696: x_deprn_override_flag:= fa_std_types.FA_OVERRIDE_DPR;
11697: x_deprn_override_flag:= fa_std_types.FA_OVERRIDE_DPR;
11698: if (h_reporting_flag = 'R') then
11699: x_override_deprn_amount := x_override_deprn_amount * l_avg_rate;
11700: end if;
11701: IF x_override_bonus_amount is not null THEN

Line 11702: x_deprn_override_flag:= fa_std_types.FA_OVERRIDE_DPR_BONUS;

11698: if (h_reporting_flag = 'R') then
11699: x_override_deprn_amount := x_override_deprn_amount * l_avg_rate;
11700: end if;
11701: IF x_override_bonus_amount is not null THEN
11702: x_deprn_override_flag:= fa_std_types.FA_OVERRIDE_DPR_BONUS;
11703: if (h_reporting_flag = 'R') then
11704: x_override_bonus_amount:= x_override_bonus_amount * l_avg_rate;
11705: end if;
11706: END IF;

Line 11708: x_deprn_override_flag:= fa_std_types.FA_OVERRIDE_BONUS;

11704: x_override_bonus_amount:= x_override_bonus_amount * l_avg_rate;
11705: end if;
11706: END IF;
11707: ELSIF x_override_bonus_amount is not null THEN
11708: x_deprn_override_flag:= fa_std_types.FA_OVERRIDE_BONUS;
11709: if (h_reporting_flag = 'R') then
11710: x_override_bonus_amount:= x_override_bonus_amount * l_avg_rate;
11711: end if;
11712: ELSE

Line 11713: x_deprn_override_flag:= fa_std_types.FA_NO_OVERRIDE;

11709: if (h_reporting_flag = 'R') then
11710: x_override_bonus_amount:= x_override_bonus_amount * l_avg_rate;
11711: end if;
11712: ELSE
11713: x_deprn_override_flag:= fa_std_types.FA_NO_OVERRIDE;
11714: END IF;
11715:
11716: -- When user provided YTD amount
11717: IF NVL(h_subtract_ytd_flag,'N') = 'Y' THEN

Line 11733: x_deprn_override_flag:= fa_std_types.FA_NO_OVERRIDE;

11729: return(TRUE);
11730:
11731: exception
11732: when others then
11733: x_deprn_override_flag:= fa_std_types.FA_NO_OVERRIDE;
11734: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
11735: return(TRUE);
11736:
11737: end override_member_amount;