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_TRACK_MEMBER_PVT dependencies on FA_CACHE_PKG

Line 135: if FA_CACHE_PKG.fazcbc_record.set_of_books_id is null then

131: fa_debug_pkg.add(l_calling_fn,'P_excess_allocation_option:P_subtraction_flag',P_excess_allocation_option||':'||P_subtraction_flag, p_log_level_rec => p_log_level_rec);
132: end if;
133:
134: -- Check if Cache Package has been called:
135: if FA_CACHE_PKG.fazcbc_record.set_of_books_id is null then
136: if (NOT fa_cache_pkg.fazcbc(X_book => P_book_type_code, p_log_level_rec => p_log_level_rec)) then
137: raise main_err;
138: end if;
139: end if;

Line 136: if (NOT fa_cache_pkg.fazcbc(X_book => P_book_type_code, p_log_level_rec => p_log_level_rec)) then

132: end if;
133:
134: -- Check if Cache Package has been called:
135: if FA_CACHE_PKG.fazcbc_record.set_of_books_id is null then
136: if (NOT fa_cache_pkg.fazcbc(X_book => P_book_type_code, p_log_level_rec => p_log_level_rec)) then
137: raise main_err;
138: end if;
139: end if;
140:

Line 150: if not fa_cache_pkg.fazcct(X_calendar=>h_deprn_calendar, p_log_level_rec => p_log_level_rec) then

146: if GET_PERIOD_COUNTER%NOTFOUND then
147: select deprn_calendar into h_deprn_calendar
148: from fa_book_controls
149: where book_type_code=P_Book_Type_code;
150: if not fa_cache_pkg.fazcct(X_calendar=>h_deprn_calendar, p_log_level_rec => p_log_level_rec) then
151: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
152: raise main_err;
153: end if;
154: h_perds_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;

Line 154: h_perds_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;

150: if not fa_cache_pkg.fazcct(X_calendar=>h_deprn_calendar, p_log_level_rec => p_log_level_rec) then
151: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
152: raise main_err;
153: end if;
154: h_perds_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
155: h_period_counter := P_fiscal_Year * h_perds_per_yr + P_Period_Counter;
156: end if;
157: close GET_PERIOD_COUNTER;
158: else -- For Reporting Book

Line 166: if not fa_cache_pkg.fazcct(X_Calendar=>h_deprn_calendar, p_log_level_rec => p_log_level_rec) then

162: if GET_PERIOD_COUNTER_MRC%NOTFOUND then
163: select deprn_calendar into h_deprn_calendar
164: from fa_book_controls
165: where book_type_code=P_Book_Type_code;
166: if not fa_cache_pkg.fazcct(X_Calendar=>h_deprn_calendar, p_log_level_rec => p_log_level_rec) then
167: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
168: raise main_err;
169: end if;
170: h_perds_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;

Line 170: h_perds_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;

166: if not fa_cache_pkg.fazcct(X_Calendar=>h_deprn_calendar, p_log_level_rec => p_log_level_rec) then
167: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
168: raise main_err;
169: end if;
170: h_perds_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
171: h_period_counter := P_fiscal_Year * h_perds_per_yr + P_Period_Counter;
172: end if;
173: close GET_PERIOD_COUNTER_MRC;
174: end if;

Line 981: h_perds_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;

977:
978: close GET_PERIOD_NUM_MRC;
979: end if;
980:
981: h_perds_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
982:
983: if (p_log_level_rec.statement_level) then
984: fa_debug_pkg.add(l_calling_fn, 'h_sob_id:book:period_ctr:cur_period_num:perds_per_fy'
985: , p_set_of_books_id||':'||h_book_type_code||':'||

Line 2963: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);

2959: end if;
2960: end LOOP; -- All PL/SQL table check
2961: elsif nvl(p_mode,'DEPRECIATION') = 'DEPRECIATION' then
2962: -- Bug # 8394833 Added below code for bluk changes
2963: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);
2964: If p_mrc_sob_type_code <> 'R' then
2965: Open c_mem_unplan_adj;
2966: loop
2967: fetch c_mem_unplan_adj bulk collect

Line 3335: h_perds_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;

3331: if P_mrc_sob_type_code <> 'R' then
3332: open GET_PERIOD_NUM(P_period_counter);
3333: fetch GET_PERIOD_NUM into h_perd_ctr;
3334: if GET_PERIOD_NUM%NOTFOUND then
3335: h_perds_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
3336: h_perd_ctr := P_period_counter - (P_fiscal_year * h_perds_per_yr);
3337: end if;
3338: close GET_PERIOD_NUM;
3339: else

Line 3343: h_perds_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;

3339: else
3340: open GET_PERIOD_NUM_MRC(P_period_counter);
3341: fetch GET_PERIOD_NUM_MRC into h_perd_ctr;
3342: if GET_PERIOD_NUM_MRC%NOTFOUND then
3343: h_perds_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
3344: h_perd_ctr := P_period_counter - (P_fiscal_year * h_perds_per_yr);
3345: end if;
3346: close GET_PERIOD_NUM_MRC;
3347: end if;

Line 3404: if (fa_cache_pkg.fa_deprn_override_enabled) and

3400: x_calc_done := 'Y';
3401: x_override_flag := 'N';
3402:
3403: -- Manual Override feature call
3404: if (fa_cache_pkg.fa_deprn_override_enabled) and
3405: nvl(P_mode,'DEPRECIATION') in ('DEPRECIATION','ADJUSTMENT') then
3406:
3407: -- Override feature is applicable only when this is processed
3408: -- in Depreciation or Catchup Calculation in Adjustment

Line 4370: h_cur_period_counter := FA_CACHE_PKG.fazcbc_record.last_period_counter + 1;

4366: h_book_type_code := p_group_rule_in.book_type_code;
4367: h_group_asset_id := p_group_rule_in.asset_id;
4368: h_period_counter := p_group_rule_in.period_counter;
4369: h_fiscal_year := p_group_rule_in.fiscal_year;
4370: h_cur_period_counter := FA_CACHE_PKG.fazcbc_record.last_period_counter + 1;
4371: h_set_of_books_id := p_group_rule_in.set_of_books_id;
4372:
4373: /* Apply MRC related feature */
4374: if p_group_rule_in.mrc_sob_type_code <> 'R' then

Line 4459: h_period_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;

4455: into h_asset_id,h_transaction_type_code,h_transaction_key,l_transaction_date_entered
4456: from fa_transaction_headers
4457: where transaction_header_id = h_adj_member_trans_header_id;
4458:
4459: h_period_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
4460:
4461: select fiscal_year_name, deprn_calendar
4462: into h_fiscal_year_name,h_calendar_type
4463: from fa_book_controls

Line 5032: nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule,'COST') = 'NBV' then

5028: -- In this case, adjusted_cost of fully reserved should be removed from adjusted_cost
5029: -- of group asset. so need to maintain the memory table adjusted cost
5030: if nvl(h_exclude_fully_rsv_flag,'N') = 'Y' and
5031: nvl(p_group_rule_in.eofy_flag,'N') = 'Y' and
5032: nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule,'COST') = 'NBV' then
5033:
5034: if (p_log_level_rec.statement_level) then
5035: fa_debug_pkg.add(l_calling_fn, 'Fully Reserve Asset treatment', 'Starts++++', p_log_level_rec => p_log_level_rec);
5036: end if;

Line 6448: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar

6444: from FA_TRANSACTION_HEADERS TH,
6445: FA_TRANSACTION_HEADERS TH1,
6446: FA_CALENDAR_PERIODS DP,
6447: FA_FISCAL_YEAR FY
6448: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6449: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
6450: and TH.asset_id = p_member_asset_id
6451: and TH.transaction_type_code not in ('TRANSFER OUT', 'TRANSFER IN', 'TRANSFER', 'TRANSFER IN/VOID',
6452: 'RECLASS', 'UNIT ADJUSTMENT','REINSTATEMENT')

Line 6449: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

6445: FA_TRANSACTION_HEADERS TH1,
6446: FA_CALENDAR_PERIODS DP,
6447: FA_FISCAL_YEAR FY
6448: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6449: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
6450: and TH.asset_id = p_member_asset_id
6451: and TH.transaction_type_code not in ('TRANSFER OUT', 'TRANSFER IN', 'TRANSFER', 'TRANSFER IN/VOID',
6452: 'RECLASS', 'UNIT ADJUSTMENT','REINSTATEMENT')
6453: and nvl(TH.amortization_start_date,TH.transaction_date_entered) between DP.start_date and DP.end_date

Line 6470: if (nvl(fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag, 'N') = 'N') then

6466: p_book_type_code||':'||p_group_asset_id||':'||p_period_counter||':'||p_fiscal_year||':'||p_transaction_header_id||':'||p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec);
6467: end if;
6468:
6469:
6470: if (nvl(fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag, 'N') = 'N') then
6471: open c_get_member_asset_id;
6472: fetch c_get_member_asset_id into l_member_asset_id;
6473: close c_get_member_asset_id;
6474: if (p_log_level_rec.statement_level) then

Line 6536: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;

6532:
6533: if h_transaction_date is null then -- This is a case this process is called to process allocation
6534: -- other than the transaction.need to get period end date for
6535: -- transaction date
6536: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
6537: if h_perd_per_fiscal_year is null then
6538: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar, p_log_level_rec => p_log_level_rec) then
6539: raise populate_previous_rows_err;
6540: end if;

Line 6538: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar, p_log_level_rec => p_log_level_rec) then

6534: -- other than the transaction.need to get period end date for
6535: -- transaction date
6536: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
6537: if h_perd_per_fiscal_year is null then
6538: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar, p_log_level_rec => p_log_level_rec) then
6539: raise populate_previous_rows_err;
6540: end if;
6541: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
6542: end if;

Line 6541: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;

6537: if h_perd_per_fiscal_year is null then
6538: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar, p_log_level_rec => p_log_level_rec) then
6539: raise populate_previous_rows_err;
6540: end if;
6541: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
6542: end if;
6543:
6544: select DP.end_date into h_transaction_date
6545: from FA_FISCAL_YEAR FY,

Line 6547: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar

6543:
6544: select DP.end_date into h_transaction_date
6545: from FA_FISCAL_YEAR FY,
6546: FA_CALENDAR_PERIODS DP
6547: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6548: and DP.period_num = p_period_counter - p_fiscal_year*h_perd_per_fiscal_year
6549: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
6550: and FY.fiscal_year = p_fiscal_year
6551: and DP.start_date >= FY.start_date

Line 6549: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

6545: from FA_FISCAL_YEAR FY,
6546: FA_CALENDAR_PERIODS DP
6547: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6548: and DP.period_num = p_period_counter - p_fiscal_year*h_perd_per_fiscal_year
6549: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
6550: and FY.fiscal_year = p_fiscal_year
6551: and DP.start_date >= FY.start_date
6552: and DP.end_date <= FY.end_date;
6553:

Line 6814: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;

6810:
6811: if h_transaction_date is null then -- This is a case this process is called to process allocation
6812: -- other than the transaction.need to get period end date for
6813: -- transaction date
6814: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
6815: if h_perd_per_fiscal_year is null then
6816: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar, p_log_level_rec => p_log_level_rec) then
6817: raise populate_previous_rows_err;
6818: end if;

Line 6816: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar, p_log_level_rec => p_log_level_rec) then

6812: -- other than the transaction.need to get period end date for
6813: -- transaction date
6814: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
6815: if h_perd_per_fiscal_year is null then
6816: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar, p_log_level_rec => p_log_level_rec) then
6817: raise populate_previous_rows_err;
6818: end if;
6819: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
6820: end if;

Line 6819: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;

6815: if h_perd_per_fiscal_year is null then
6816: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar, p_log_level_rec => p_log_level_rec) then
6817: raise populate_previous_rows_err;
6818: end if;
6819: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
6820: end if;
6821:
6822: select DP.end_date into h_transaction_date
6823: from FA_FISCAL_YEAR FY,

Line 6825: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar

6821:
6822: select DP.end_date into h_transaction_date
6823: from FA_FISCAL_YEAR FY,
6824: FA_CALENDAR_PERIODS DP
6825: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6826: and DP.period_num = p_period_counter - p_fiscal_year*h_perd_per_fiscal_year
6827: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
6828: and FY.fiscal_year = p_fiscal_year
6829: and DP.start_date >= FY.start_date

Line 6827: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

6823: from FA_FISCAL_YEAR FY,
6824: FA_CALENDAR_PERIODS DP
6825: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6826: and DP.period_num = p_period_counter - p_fiscal_year*h_perd_per_fiscal_year
6827: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
6828: and FY.fiscal_year = p_fiscal_year
6829: and DP.start_date >= FY.start_date
6830: and DP.end_date <= FY.end_date;
6831:

Line 7317: h_period_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;

7313: h_life_in_months := p_asset_fin_rec.life_in_months;
7314:
7315: h_mem_trans_thid := nvl(p_trans_rec.member_transaction_header_id,-99);
7316: --* Prepare to call Deprn Basis Rule - 1
7317: h_period_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
7318: h_start_period_counter := h_start_fiscal_year*h_period_per_fiscal_year+h_start_period_num;
7319:
7320: h_set_of_books_id := p_asset_hdr_rec.set_of_books_id;
7321:

Line 7341: if not fa_cache_pkg.fazccmt(X_method => h_deprn_method_code,

7337: h_period_counter||':'||h_fiscal_year||':'||h_deprn_method_code||':'||h_life_in_months, p_log_level_rec => p_log_level_rec);
7338: fa_debug_pkg.add(l_calling_fn, 'Method Cache is called.', '***');
7339: end if;
7340:
7341: if not fa_cache_pkg.fazccmt(X_method => h_deprn_method_code,
7342: X_life => h_life_in_months, p_log_level_rec => p_log_level_rec) then
7343: if (p_log_level_rec.statement_level) then
7344: fa_debug_pkg.add(l_calling_fn, '++ fa_cache_pkg.fazccmt is errored out ++', '+++', p_log_level_rec => p_log_level_rec);
7345: end if;

Line 7344: fa_debug_pkg.add(l_calling_fn, '++ fa_cache_pkg.fazccmt is errored out ++', '+++', p_log_level_rec => p_log_level_rec);

7340:
7341: if not fa_cache_pkg.fazccmt(X_method => h_deprn_method_code,
7342: X_life => h_life_in_months, p_log_level_rec => p_log_level_rec) then
7343: if (p_log_level_rec.statement_level) then
7344: fa_debug_pkg.add(l_calling_fn, '++ fa_cache_pkg.fazccmt is errored out ++', '+++', p_log_level_rec => p_log_level_rec);
7345: end if;
7346: raise get_member_at_start_err;
7347: end if;
7348:

Line 7350: h_group_deprn_basis := fa_cache_pkg.fazccmt_record.deprn_basis_rule; -- COST or NBV

7346: raise get_member_at_start_err;
7347: end if;
7348:
7349: -- Populate Method related information from cache
7350: h_group_deprn_basis := fa_cache_pkg.fazccmt_record.deprn_basis_rule; -- COST or NBV
7351:
7352: --* If this proceesing period is last period of the fiscal year set h_eofy_flag = 'Y'
7353: --* call depreciable basis rule function to update adjusted cost for the next year
7354: if h_start_period_num = h_period_per_fiscal_year then

Line 7367: fa_rule_in.method_type := fa_cache_pkg.fazccmt_record.rate_source_rule;

7363: fa_rule_in.fiscal_year := h_start_fiscal_year;
7364: fa_rule_in.period_num := h_start_period_num;
7365: fa_rule_in.method_code := h_deprn_method_code;
7366: fa_rule_in.life_in_months := h_life_in_months;
7367: fa_rule_in.method_type := fa_cache_pkg.fazccmt_record.rate_source_rule;
7368: fa_rule_in.calc_basis := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
7369: fa_rule_in.mrc_sob_type_code := p_mrc_sob_type_code;
7370: fa_rule_in.set_of_books_id := h_set_of_books_id;
7371: fa_rule_in.group_asset_id := h_group_asset_id;

Line 7368: fa_rule_in.calc_basis := fa_cache_pkg.fazccmt_record.deprn_basis_rule;

7364: fa_rule_in.period_num := h_start_period_num;
7365: fa_rule_in.method_code := h_deprn_method_code;
7366: fa_rule_in.life_in_months := h_life_in_months;
7367: fa_rule_in.method_type := fa_cache_pkg.fazccmt_record.rate_source_rule;
7368: fa_rule_in.calc_basis := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
7369: fa_rule_in.mrc_sob_type_code := p_mrc_sob_type_code;
7370: fa_rule_in.set_of_books_id := h_set_of_books_id;
7371: fa_rule_in.group_asset_id := h_group_asset_id;
7372: fa_rule_in.period_counter := h_start_period_counter;

Line 7375: if fa_cache_pkg.fazcdrd_record.rule_name in ('YEAR END BALANCE WITH POSITIVE REDUCTION',

7371: fa_rule_in.group_asset_id := h_group_asset_id;
7372: fa_rule_in.period_counter := h_start_period_counter;
7373:
7374: --* Group Level information (50% application) if the basis rule assigned to this method enables reduction rate
7375: if fa_cache_pkg.fazcdrd_record.rule_name in ('YEAR END BALANCE WITH POSITIVE REDUCTION',
7376: 'YEAR END BALANCE WITH HALF YEAR RULE') then
7377:
7378: if not check_reduction_application(p_rule_name => fa_cache_pkg.fazcdrd_record.rule_name,
7379: p_group_asset_id => h_group_asset_id,

Line 7378: if not check_reduction_application(p_rule_name => fa_cache_pkg.fazcdrd_record.rule_name,

7374: --* Group Level information (50% application) if the basis rule assigned to this method enables reduction rate
7375: if fa_cache_pkg.fazcdrd_record.rule_name in ('YEAR END BALANCE WITH POSITIVE REDUCTION',
7376: 'YEAR END BALANCE WITH HALF YEAR RULE') then
7377:
7378: if not check_reduction_application(p_rule_name => fa_cache_pkg.fazcdrd_record.rule_name,
7379: p_group_asset_id => h_group_asset_id,
7380: p_book_type_code => h_book_type_code,
7381: p_period_counter => h_start_period_counter,
7382: p_group_deprn_basis => h_group_deprn_basis,

Line 7994: if (nvl(fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag, 'N') = 'N') then

7990: h_fiscal_year := p_dpr_in.y_end;
7991: h_period_num := p_dpr_in.p_cl_end;
7992: h_set_of_books_id := p_asset_hdr_rec.set_of_books_id;
7993:
7994: if (nvl(fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag, 'N') = 'N') then
7995: open c_get_member_asset_id;
7996: fetch c_get_member_asset_id into l_member_asset_id;
7997: close c_get_member_asset_id;
7998: if (p_log_level_rec.statement_level) then

Line 9098: if (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') and -- ENERGY

9094: h_group_dpis := p_asset_fin_rec_new.date_placed_in_service;
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;

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 9119: if not fa_cache_pkg.fazcct(h_deprn_calendar, p_log_level_rec => p_log_level_rec) then

9115: fa_debug_pkg.add(l_calling_fn, 'h_deprn_calendar:h_fiscal_year_name',
9116: h_deprn_calendar||':'||h_fiscal_year_name, p_log_level_rec => p_log_level_rec);
9117: end if;
9118:
9119: if not fa_cache_pkg.fazcct(h_deprn_calendar, p_log_level_rec => p_log_level_rec) then
9120: if (p_log_level_rec.statement_level) then
9121: fa_debug_pkg.add(l_calling_fn, 'Calendar Cache call is failed', '+++', p_log_level_rec => p_log_level_rec);
9122: end if;
9123: raise pop_mem_table_err;

Line 9126: h_period_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;

9122: end if;
9123: raise pop_mem_table_err;
9124: end if;
9125:
9126: h_period_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
9127:
9128: open GET_FY_PERDNUM(p_amort_start_date);
9129: fetch GET_FY_PERDNUM into h_temp_fiscal_year,h_temp_period_num;
9130:

Line 9407: if not fa_cache_pkg.fazccmt(X_method => h_deprn_method_code,

9403: if (p_log_level_rec.statement_level) then
9404: fa_debug_pkg.add(l_calling_fn, 'Method Cache is called.', '***');
9405: end if;
9406:
9407: if not fa_cache_pkg.fazccmt(X_method => h_deprn_method_code,
9408: X_life => h_life_in_months, p_log_level_rec => p_log_level_rec) then
9409: if (p_log_level_rec.statement_level) then
9410: fa_debug_pkg.add(l_calling_fn, '++ fa_cache_pkg.fazccmt is errored out ++', '+++', p_log_level_rec => p_log_level_rec);
9411: end if;

Line 9410: fa_debug_pkg.add(l_calling_fn, '++ fa_cache_pkg.fazccmt is errored out ++', '+++', p_log_level_rec => p_log_level_rec);

9406:
9407: if not fa_cache_pkg.fazccmt(X_method => h_deprn_method_code,
9408: X_life => h_life_in_months, p_log_level_rec => p_log_level_rec) then
9409: if (p_log_level_rec.statement_level) then
9410: fa_debug_pkg.add(l_calling_fn, '++ fa_cache_pkg.fazccmt is errored out ++', '+++', p_log_level_rec => p_log_level_rec);
9411: end if;
9412:
9413: raise pop_mem_table_err;
9414: end if;

Line 9421: h_group_deprn_basis := fa_cache_pkg.fazccmt_record.deprn_basis_rule; -- COST or NBV

9417: h_old_life_in_months := h_life_in_months;
9418: end if;
9419:
9420: -- Populate Method related information from cache
9421: h_group_deprn_basis := fa_cache_pkg.fazccmt_record.deprn_basis_rule; -- COST or NBV
9422:
9423: --* Get system deprn amount if subtraction flag is 'Y'
9424: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
9425:

Line 9424: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then

9420: -- Populate Method related information from cache
9421: h_group_deprn_basis := fa_cache_pkg.fazccmt_record.deprn_basis_rule; -- COST or NBV
9422:
9423: --* Get system deprn amount if subtraction flag is 'Y'
9424: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
9425:
9426: if (p_log_level_rec.statement_level) then
9427: fa_debug_pkg.add(l_calling_fn, '++ Logic in case the subtraction flag is Y (1)' , '+++');
9428: fa_debug_pkg.add(l_calling_fn, 'h_processing_fiscal_year', h_processing_fiscal_year, p_log_level_rec => p_log_level_rec);

Line 9514: fa_rule_in.method_type := fa_cache_pkg.fazccmt_record.rate_source_rule;

9510: fa_rule_in.period_num := h_period_num;
9511: fa_rule_in.period_counter := h_processing_period_counter;
9512: fa_rule_in.method_code := h_deprn_method_code;
9513: fa_rule_in.life_in_months := h_life_in_months;
9514: fa_rule_in.method_type := fa_cache_pkg.fazccmt_record.rate_source_rule;
9515: fa_rule_in.calc_basis := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
9516: fa_rule_in.mrc_sob_type_code := p_mrc_sob_type_code;
9517: fa_rule_in.set_of_books_id := h_set_of_books_id;
9518: fa_rule_in.group_asset_id := h_group_asset_id;

Line 9515: fa_rule_in.calc_basis := fa_cache_pkg.fazccmt_record.deprn_basis_rule;

9511: fa_rule_in.period_counter := h_processing_period_counter;
9512: fa_rule_in.method_code := h_deprn_method_code;
9513: fa_rule_in.life_in_months := h_life_in_months;
9514: fa_rule_in.method_type := fa_cache_pkg.fazccmt_record.rate_source_rule;
9515: fa_rule_in.calc_basis := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
9516: fa_rule_in.mrc_sob_type_code := p_mrc_sob_type_code;
9517: fa_rule_in.set_of_books_id := h_set_of_books_id;
9518: fa_rule_in.group_asset_id := h_group_asset_id;
9519: fa_rule_in.recognize_gain_loss := h_group_recognize_gain_loss;

Line 9522: if fa_cache_pkg.fazcdrd_record.rule_name in ('YEAR END BALANCE WITH POSITIVE REDUCTION',

9518: fa_rule_in.group_asset_id := h_group_asset_id;
9519: fa_rule_in.recognize_gain_loss := h_group_recognize_gain_loss;
9520:
9521: --* Group Level information (50% application) if the basis rule assigned to this method enables reduction rate
9522: if fa_cache_pkg.fazcdrd_record.rule_name in ('YEAR END BALANCE WITH POSITIVE REDUCTION',
9523: 'YEAR END BALANCE WITH HALF YEAR RULE') then
9524:
9525: if not check_reduction_application(p_rule_name => fa_cache_pkg.fazcdrd_record.rule_name,
9526: p_group_asset_id => h_group_asset_id,

Line 9525: if not check_reduction_application(p_rule_name => fa_cache_pkg.fazcdrd_record.rule_name,

9521: --* Group Level information (50% application) if the basis rule assigned to this method enables reduction rate
9522: if fa_cache_pkg.fazcdrd_record.rule_name in ('YEAR END BALANCE WITH POSITIVE REDUCTION',
9523: 'YEAR END BALANCE WITH HALF YEAR RULE') then
9524:
9525: if not check_reduction_application(p_rule_name => fa_cache_pkg.fazcdrd_record.rule_name,
9526: p_group_asset_id => h_group_asset_id,
9527: p_book_type_code => h_book_type_code,
9528: p_period_counter => h_processing_period_counter,
9529: p_group_deprn_basis => h_group_deprn_basis,

Line 9645: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcdrd_record.rule_name',

9641: fa_debug_pkg.add(l_calling_fn, '++++ LOOP FOR GETTING DELTA *** THID', h_transaction_header_id);
9642: fa_debug_pkg.add(l_calling_fn, 'h_delta_cost:h_delta_rec_cost', h_delta_cost||':'||h_delta_recoverable_cost, p_log_level_rec => p_log_level_rec);
9643: fa_debug_pkg.add(l_calling_fn, 'h_adj_cost:h_adj_rec_cost:h_adj_salvage', h_adj_cost||':'||h_adj_rec_cost||':'||h_adj_salvage_value, p_log_level_rec => p_log_level_rec);
9644: fa_debug_pkg.add(l_calling_fn, 'h_new_perd_ctr_ret', h_new_perd_ctr_ret, p_log_level_rec => p_log_level_rec);
9645: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcdrd_record.rule_name',
9646: fa_cache_pkg.fazcdrd_record.rule_name, p_log_level_rec => p_log_level_rec);
9647: end if;
9648:
9649: if nvl(h_transaction_type_code,'NULL') in ('PARTIAL RETIREMENT','FULL RETIREMENT') then

Line 9646: fa_cache_pkg.fazcdrd_record.rule_name, p_log_level_rec => p_log_level_rec);

9642: fa_debug_pkg.add(l_calling_fn, 'h_delta_cost:h_delta_rec_cost', h_delta_cost||':'||h_delta_recoverable_cost, p_log_level_rec => p_log_level_rec);
9643: fa_debug_pkg.add(l_calling_fn, 'h_adj_cost:h_adj_rec_cost:h_adj_salvage', h_adj_cost||':'||h_adj_rec_cost||':'||h_adj_salvage_value, p_log_level_rec => p_log_level_rec);
9644: fa_debug_pkg.add(l_calling_fn, 'h_new_perd_ctr_ret', h_new_perd_ctr_ret, p_log_level_rec => p_log_level_rec);
9645: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcdrd_record.rule_name',
9646: fa_cache_pkg.fazcdrd_record.rule_name, p_log_level_rec => p_log_level_rec);
9647: end if;
9648:
9649: if nvl(h_transaction_type_code,'NULL') in ('PARTIAL RETIREMENT','FULL RETIREMENT') then
9650: open GET_RETIREMENTS(h_transaction_header_id);

Line 9656: -- ONLY if fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE'

9652: close GET_RETIREMENTS;
9653:
9654: -- ENERGY
9655: -- reserve retired will not be equal to cost when recognize_gain_loss = 'NO'
9656: -- ONLY if fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE'
9657: if nvl(h_recognize_gain_loss,'NO') = 'NO' and -- ENERGY
9658: (nvl(fa_cache_pkg.fazcdrd_record.rule_name, 'NONE') <> 'ENERGY PERIOD END BALANCE') then
9659: h_new_eofy_reserve := 0;
9660: else

Line 9658: (nvl(fa_cache_pkg.fazcdrd_record.rule_name, 'NONE') <> 'ENERGY PERIOD END BALANCE') then

9654: -- ENERGY
9655: -- reserve retired will not be equal to cost when recognize_gain_loss = 'NO'
9656: -- ONLY if fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE'
9657: if nvl(h_recognize_gain_loss,'NO') = 'NO' and -- ENERGY
9658: (nvl(fa_cache_pkg.fazcdrd_record.rule_name, 'NONE') <> 'ENERGY PERIOD END BALANCE') then
9659: h_new_eofy_reserve := 0;
9660: else
9661: h_new_eofy_reserve := nvl(h_new_eofy_reserve,0) + nvl(h_adj_eofy_reserve,0);
9662: h_new_reserve_retired := nvl(h_new_reserve_retired,0) + nvl(h_adj_reserve_retired,0);

Line 9671: (nvl(fa_cache_pkg.fazcdrd_record.rule_name, 'NONE') = 'ENERGY PERIOD END BALANCE') then

9667: fa_debug_pkg.add(l_calling_fn, 'h_new_eofy_reserve:h_new_reserve_retired',
9668: h_new_eofy_reserve||':'||h_new_reserve_retired, p_log_level_rec => p_log_level_rec);
9669: end if;
9670: elsif (nvl(h_transaction_type_code,'NULL') = 'REINSTATEMENT') and
9671: (nvl(fa_cache_pkg.fazcdrd_record.rule_name, 'NONE') = 'ENERGY PERIOD END BALANCE') then
9672: --
9673: open GET_REINSTATEMENT(h_transaction_header_id);
9674: fetch GET_REINSTATEMENT into h_recognize_gain_loss, h_adj_eofy_reserve, h_adj_reserve_retired;
9675: close GET_REINSTATEMENT;

Line 10486: if fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag = 'YES' then

10482: -- Calculate purely periodic expense
10483: h_periodic_expense := h_group_deprn_amount - nvl(h_group_adj_expense,0);
10484: h_periodic_bonus_expense := nvl(h_group_bonus_deprn_amount,0) - nvl(h_group_adj_bonus_expense,0);
10485:
10486: if fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag = 'YES' then
10487: h_group_exclude_salvage := 'Y';
10488: else
10489: h_group_exclude_salvage := 'N';
10490: end if;

Line 10500: h_subtraction_flag := fa_cache_pkg.fazcdrd_record.subtract_ytd_flag;

10496: h_allocate_to_fully_ret_flag := p_asset_fin_rec_new.allocate_to_fully_ret_flag;
10497: h_excess_allocation_option := p_asset_fin_rec_new.excess_allocation_option;
10498: h_depreciation_option := p_asset_fin_rec_new.depreciation_option;
10499: h_member_rollup_flag := p_asset_fin_rec_new.member_rollup_flag;
10500: h_subtraction_flag := fa_cache_pkg.fazcdrd_record.subtract_ytd_flag;
10501:
10502: if h_processing_period_counter <> h_recalc_period_counter or
10503: (h_processing_period_counter = h_recalc_period_counter and
10504: p_no_allocation_for_last = 'N') then

Line 10560: nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule,'COST') = 'NBV' then

10556: --* Following logic is prepared for exclude_salvage_value in FA_BOOKS is set.
10557: -- In this case, adjusted_cost of fully reserved should be removed from adjusted_cost
10558: -- of group asset. so need to maintain the memory table adjusted cost
10559: if nvl(h_exclude_fully_rsv_flag,'N') = 'Y' and
10560: nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule,'COST') = 'NBV' then
10561:
10562: if (p_log_level_rec.statement_level) then
10563: fa_debug_pkg.add(l_calling_fn, 'Fully Reserve Asset treatment', 'Starts++++', p_log_level_rec => p_log_level_rec);
10564: fa_debug_pkg.add(l_calling_fn, 'h_processing_fiscal_year lopped out', h_processing_fiscal_year, p_log_level_rec => p_log_level_rec);

Line 10836: if not fa_cache_pkg.fazccmt(X_method => p_asset_fin_rec_new.deprn_method_code,

10832: h_group_asset_id := p_asset_hdr_rec.asset_id;
10833: h_set_of_books_id := p_asset_hdr_rec.set_of_books_id;
10834:
10835: -- Populate Subtract Ytd Flag
10836: if not fa_cache_pkg.fazccmt(X_method => p_asset_fin_rec_new.deprn_method_code,
10837: X_life => p_asset_fin_rec_new.life_in_months, p_log_level_rec => p_log_level_rec) then
10838: raise pop_mem_amt_err;
10839: end if;
10840:

Line 11204: h_number_per_fy := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;

11200: fa_debug_pkg.add(l_calling_fn, 'Last processed fiscal year:period_num', p_current_fiscal_year||':'||p_current_period_num, p_log_level_rec => p_log_level_rec);
11201: end if;
11202:
11203: if p_current_fiscal_year is not null and p_current_period_num is not null then
11204: h_number_per_fy := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
11205: h_period_counter := p_current_fiscal_year*h_number_per_fy+p_current_period_num;
11206: else
11207: h_period_counter := NULL;
11208: end if;

Line 11357: l_primary_sob := fa_cache_pkg.fazcbc_record.set_of_books_id; --Bug 8941132

11353: k number; --Bug 8941132
11354:
11355:
11356: begin
11357: l_primary_sob := fa_cache_pkg.fazcbc_record.set_of_books_id; --Bug 8941132
11358: k:=1; --Bug 8941132
11359:
11360: for i IN 1.. p_track_member_table.COUNT
11361: loop

Line 11646: h_calendar_type:= fa_cache_pkg.fazcbc_record.deprn_calendar;

11642: if (p_log_level_rec.statement_level) then
11643: fa_debug_pkg.add(l_calling_fn, 'h_set_of_books_id:h_reporting_flag', h_set_of_books_id||':'||h_reporting_flag, p_log_level_rec => p_log_level_rec);
11644: end if;
11645: /* select the corresponding period_counter for the current period: fyctr, perd_ctr */
11646: h_calendar_type:= fa_cache_pkg.fazcbc_record.deprn_calendar;
11647: h_fy_name:= fa_cache_pkg.fazcbc_record.fiscal_year_name;
11648: h_num_per_fy:= fa_cache_pkg.fazcct_record.number_per_fiscal_year;
11649:
11650: select cp.period_name

Line 11647: h_fy_name:= fa_cache_pkg.fazcbc_record.fiscal_year_name;

11643: fa_debug_pkg.add(l_calling_fn, 'h_set_of_books_id:h_reporting_flag', h_set_of_books_id||':'||h_reporting_flag, p_log_level_rec => p_log_level_rec);
11644: end if;
11645: /* select the corresponding period_counter for the current period: fyctr, perd_ctr */
11646: h_calendar_type:= fa_cache_pkg.fazcbc_record.deprn_calendar;
11647: h_fy_name:= fa_cache_pkg.fazcbc_record.fiscal_year_name;
11648: h_num_per_fy:= fa_cache_pkg.fazcct_record.number_per_fiscal_year;
11649:
11650: select cp.period_name
11651: into h_period_name

Line 11648: h_num_per_fy:= fa_cache_pkg.fazcct_record.number_per_fiscal_year;

11644: end if;
11645: /* select the corresponding period_counter for the current period: fyctr, perd_ctr */
11646: h_calendar_type:= fa_cache_pkg.fazcbc_record.deprn_calendar;
11647: h_fy_name:= fa_cache_pkg.fazcbc_record.fiscal_year_name;
11648: h_num_per_fy:= fa_cache_pkg.fazcct_record.number_per_fiscal_year;
11649:
11650: select cp.period_name
11651: into h_period_name
11652: from fa_calendar_periods cp, fa_fiscal_year fy