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 108: if FA_CACHE_PKG.fazcbc_record.set_of_books_id is null then

104: 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);
105: end if;
106:
107: -- Check if Cache Package has been called:
108: if FA_CACHE_PKG.fazcbc_record.set_of_books_id is null then
109: if (NOT fa_cache_pkg.fazcbc(X_book => P_book_type_code,
110: p_log_level_rec => p_log_level_rec)) then
111: raise main_err;
112: end if;

Line 109: if (NOT fa_cache_pkg.fazcbc(X_book => P_book_type_code,

105: end if;
106:
107: -- Check if Cache Package has been called:
108: if FA_CACHE_PKG.fazcbc_record.set_of_books_id is null then
109: if (NOT fa_cache_pkg.fazcbc(X_book => P_book_type_code,
110: p_log_level_rec => p_log_level_rec)) then
111: raise main_err;
112: end if;
113: end if;

Line 117: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;

113: end if;
114:
115: -- Get Period Counter
116: if p_mrc_sob_type_code <> 'R' then
117: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;
118:
119: open GET_PERIOD_COUNTER;
120: fetch GET_PERIOD_COUNTER into h_period_counter;
121: if GET_PERIOD_COUNTER%NOTFOUND then

Line 125: if not fa_cache_pkg.fazcct(X_calendar=>h_deprn_calendar,

121: if GET_PERIOD_COUNTER%NOTFOUND then
122: select deprn_calendar into h_deprn_calendar
123: from fa_book_controls
124: where book_type_code=P_Book_Type_code;
125: if not fa_cache_pkg.fazcct(X_calendar=>h_deprn_calendar,
126: p_log_level_rec => p_log_level_rec) then
127: fa_srvr_msg.add_message (calling_fn => l_calling_fn,
128: p_log_level_rec => p_log_level_rec);
129: raise main_err;

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

127: fa_srvr_msg.add_message (calling_fn => l_calling_fn,
128: p_log_level_rec => p_log_level_rec);
129: raise main_err;
130: end if;
131: h_perds_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
132: h_period_counter := P_fiscal_Year * h_perds_per_yr + P_Period_Counter;
133: end if;
134: close GET_PERIOD_COUNTER;
135: else -- For Reporting Book

Line 136: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,

132: h_period_counter := P_fiscal_Year * h_perds_per_yr + P_Period_Counter;
133: end if;
134: close GET_PERIOD_COUNTER;
135: else -- For Reporting Book
136: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
137: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
138:
139: open GET_PERIOD_COUNTER_MRC;
140: fetch GET_PERIOD_COUNTER_MRC into h_period_counter;

Line 137: FA_CACHE_PKG.fazcbc_record.set_of_books_id);

133: end if;
134: close GET_PERIOD_COUNTER;
135: else -- For Reporting Book
136: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
137: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
138:
139: open GET_PERIOD_COUNTER_MRC;
140: fetch GET_PERIOD_COUNTER_MRC into h_period_counter;
141: if GET_PERIOD_COUNTER_MRC%NOTFOUND then

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

141: if GET_PERIOD_COUNTER_MRC%NOTFOUND then
142: select deprn_calendar into h_deprn_calendar
143: from fa_book_controls
144: where book_type_code=P_Book_Type_code;
145: if not fa_cache_pkg.fazcct(X_Calendar=>h_deprn_calendar, p_log_level_rec => p_log_level_rec) then
146: fa_srvr_msg.add_message (calling_fn => l_calling_fn,
147: p_log_level_rec => p_log_level_rec);
148: raise main_err;
149: end if;

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

146: fa_srvr_msg.add_message (calling_fn => l_calling_fn,
147: p_log_level_rec => p_log_level_rec);
148: raise main_err;
149: end if;
150: h_perds_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
151: h_period_counter := P_fiscal_Year * h_perds_per_yr + P_Period_Counter;
152: end if;
153: close GET_PERIOD_COUNTER_MRC;
154: end if;

Line 857: h_set_of_books_id := FA_CACHE_PKG.fazcbc_record.set_of_books_id;

853: h_fiscal_year := P_fiscal_year;
854:
855: -- Apply MRC related feature --
856: if p_mrc_sob_type_code <> 'R' then
857: h_set_of_books_id := FA_CACHE_PKG.fazcbc_record.set_of_books_id;
858:
859: open GET_PERIOD_NUM(h_period_counter);
860: fetch GET_PERIOD_NUM into h_current_period_number;
861:

Line 868: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,

864: end if;
865:
866: close GET_PERIOD_NUM;
867: else
868: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
869: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
870:
871: open GET_PERIOD_NUM_MRC(h_period_counter);
872: fetch GET_PERIOD_NUM_MRC into h_current_period_number;

Line 869: FA_CACHE_PKG.fazcbc_record.set_of_books_id);

865:
866: close GET_PERIOD_NUM;
867: else
868: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
869: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
870:
871: open GET_PERIOD_NUM_MRC(h_period_counter);
872: fetch GET_PERIOD_NUM_MRC into h_current_period_number;
873:

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

877:
878: close GET_PERIOD_NUM_MRC;
879: end if;
880:
881: h_perds_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
882:
883: if (p_log_level_rec.statement_level) then
884: fa_debug_pkg.add(l_calling_fn, 'h_sob_id:book:period_ctr:cur_period_num:perds_per_fy'
885: , h_set_of_books_id||':'||h_book_type_code||':'||

Line 3162: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;

3158:
3159: begin
3160: /* Apply MRC related feature */
3161: if P_mrc_sob_type_code <> 'R' then
3162: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;
3163: else
3164: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
3165: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
3166: end if;

Line 3164: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,

3160: /* Apply MRC related feature */
3161: if P_mrc_sob_type_code <> 'R' then
3162: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;
3163: else
3164: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
3165: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
3166: end if;
3167:
3168: if (p_log_level_rec.statement_level) then

Line 3165: FA_CACHE_PKG.fazcbc_record.set_of_books_id);

3161: if P_mrc_sob_type_code <> 'R' then
3162: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;
3163: else
3164: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
3165: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
3166: end if;
3167:
3168: if (p_log_level_rec.statement_level) then
3169: fa_debug_pkg.add(l_calling_fn, '+++ ALLOCATION_MAIN start +++', '+++', p_log_level_rec);

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

3180: if P_mrc_sob_type_code <> 'R' then
3181: open GET_PERIOD_NUM(P_period_counter);
3182: fetch GET_PERIOD_NUM into h_perd_ctr;
3183: if GET_PERIOD_NUM%NOTFOUND then
3184: h_perds_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
3185: h_perd_ctr := P_period_counter - (P_fiscal_year * h_perds_per_yr);
3186: end if;
3187: close GET_PERIOD_NUM;
3188: else

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

3188: else
3189: open GET_PERIOD_NUM_MRC(P_period_counter);
3190: fetch GET_PERIOD_NUM_MRC into h_perd_ctr;
3191: if GET_PERIOD_NUM_MRC%NOTFOUND then
3192: h_perds_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
3193: h_perd_ctr := P_period_counter - (P_fiscal_year * h_perds_per_yr);
3194: end if;
3195: close GET_PERIOD_NUM_MRC;
3196: end if;

Line 3252: if (fa_cache_pkg.fa_deprn_override_enabled) and

3248: x_calc_done := 'Y';
3249: x_override_flag := 'N';
3250:
3251: -- Manual Override feature call
3252: if (fa_cache_pkg.fa_deprn_override_enabled) and
3253: nvl(P_mode,'DEPRECIATION') in ('DEPRECIATION','ADJUSTMENT') then
3254:
3255: -- Override feature is applicable only when this is processed
3256: -- in Depreciation or Catchup Calculation in Adjustment

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

4210: h_book_type_code := p_group_rule_in.book_type_code;
4211: h_group_asset_id := p_group_rule_in.asset_id;
4212: h_period_counter := p_group_rule_in.period_counter;
4213: h_fiscal_year := p_group_rule_in.fiscal_year;
4214: h_cur_period_counter := FA_CACHE_PKG.fazcbc_record.last_period_counter + 1;
4215:
4216: /* Apply MRC related feature */
4217: if p_group_rule_in.mrc_sob_type_code <> 'R' then
4218: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;

Line 4218: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;

4214: h_cur_period_counter := FA_CACHE_PKG.fazcbc_record.last_period_counter + 1;
4215:
4216: /* Apply MRC related feature */
4217: if p_group_rule_in.mrc_sob_type_code <> 'R' then
4218: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;
4219:
4220: open GET_EXCLUDE_FULLY_RSV_FLAG;
4221: fetch GET_EXCLUDE_FULLY_RSV_FLAG into h_exclude_fully_rsv_flag;
4222: close GET_EXCLUDE_FULLY_RSV_FLAG;

Line 4224: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,

4220: open GET_EXCLUDE_FULLY_RSV_FLAG;
4221: fetch GET_EXCLUDE_FULLY_RSV_FLAG into h_exclude_fully_rsv_flag;
4222: close GET_EXCLUDE_FULLY_RSV_FLAG;
4223: else
4224: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
4225: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
4226:
4227: open GET_EXCLUDE_FULLY_RSV_FLAG_MRC;
4228: fetch GET_EXCLUDE_FULLY_RSV_FLAG_MRC into h_exclude_fully_rsv_flag;

Line 4225: FA_CACHE_PKG.fazcbc_record.set_of_books_id);

4221: fetch GET_EXCLUDE_FULLY_RSV_FLAG into h_exclude_fully_rsv_flag;
4222: close GET_EXCLUDE_FULLY_RSV_FLAG;
4223: else
4224: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
4225: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
4226:
4227: open GET_EXCLUDE_FULLY_RSV_FLAG_MRC;
4228: fetch GET_EXCLUDE_FULLY_RSV_FLAG_MRC into h_exclude_fully_rsv_flag;
4229: close GET_EXCLUDE_FULLY_RSV_FLAG_MRC;

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

4299: into h_asset_id,h_transaction_type_code,h_transaction_key,l_transaction_date_entered
4300: from fa_transaction_headers
4301: where transaction_header_id = h_adj_member_trans_header_id;
4302:
4303: h_period_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
4304:
4305: select fiscal_year_name, deprn_calendar
4306: into h_fiscal_year_name,h_calendar_type
4307: from fa_book_controls

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

4867: -- In this case, adjusted_cost of fully reserved should be removed from adjusted_cost
4868: -- of group asset. so need to maintain the memory table adjusted cost
4869: if nvl(h_exclude_fully_rsv_flag,'N') = 'Y' and
4870: nvl(p_group_rule_in.eofy_flag,'N') = 'Y' and
4871: nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule,'COST') = 'NBV' then
4872:
4873: if (p_log_level_rec.statement_level) then
4874: fa_debug_pkg.add(l_calling_fn, 'Fully Reserve Asset treatment', 'Starts++++', p_log_level_rec);
4875: end if;

Line 5413: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;

5409: begin
5410:
5411: /* Apply MRC related feature */
5412: if p_mrc_sob_type_code <> 'R' then
5413: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;
5414:
5415: else
5416: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
5417: FA_CACHE_PKG.fazcbc_record.set_of_books_id);

Line 5416: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,

5412: if p_mrc_sob_type_code <> 'R' then
5413: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;
5414:
5415: else
5416: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
5417: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
5418: end if;
5419:
5420: if (p_log_level_rec.statement_level) then

Line 5417: FA_CACHE_PKG.fazcbc_record.set_of_books_id);

5413: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;
5414:
5415: else
5416: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
5417: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
5418: end if;
5419:
5420: if (p_log_level_rec.statement_level) then
5421: fa_debug_pkg.add(l_calling_fn, '+++ INS_DD_ADJ start +++', '+++', p_log_level_rec);

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

6282: from FA_TRANSACTION_HEADERS TH,
6283: FA_TRANSACTION_HEADERS TH1,
6284: FA_CALENDAR_PERIODS DP,
6285: FA_FISCAL_YEAR FY
6286: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6287: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
6288: and TH.asset_id = p_member_asset_id
6289: and TH.transaction_type_code not in ('TRANSFER OUT', 'TRANSFER IN', 'TRANSFER', 'TRANSFER IN/VOID',
6290: 'RECLASS', 'UNIT ADJUSTMENT','REINSTATEMENT')

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

6283: FA_TRANSACTION_HEADERS TH1,
6284: FA_CALENDAR_PERIODS DP,
6285: FA_FISCAL_YEAR FY
6286: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6287: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
6288: and TH.asset_id = p_member_asset_id
6289: and TH.transaction_type_code not in ('TRANSFER OUT', 'TRANSFER IN', 'TRANSFER', 'TRANSFER IN/VOID',
6290: 'RECLASS', 'UNIT ADJUSTMENT','REINSTATEMENT')
6291: and nvl(TH.amortization_start_date,TH.transaction_date_entered) between DP.start_date and DP.end_date

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

6304: 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);
6305: end if;
6306:
6307:
6308: if (nvl(fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag, 'N') = 'N') then
6309: open c_get_member_asset_id;
6310: fetch c_get_member_asset_id into l_member_asset_id;
6311: close c_get_member_asset_id;
6312: if (p_log_level_rec.statement_level) then

Line 6327: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;

6323: h_loop_end_period := p_loop_end_period;
6324:
6325: /* Apply MRC related feature */
6326: if p_mrc_sob_type_code <> 'R' then
6327: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;
6328: else
6329: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
6330: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
6331: end if;

Line 6329: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,

6325: /* Apply MRC related feature */
6326: if p_mrc_sob_type_code <> 'R' then
6327: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;
6328: else
6329: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
6330: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
6331: end if;
6332:
6333: -- Query necessary data from table and insert those into FA_TRACKING_TEMP

Line 6330: FA_CACHE_PKG.fazcbc_record.set_of_books_id);

6326: if p_mrc_sob_type_code <> 'R' then
6327: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;
6328: else
6329: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
6330: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
6331: end if;
6332:
6333: -- Query necessary data from table and insert those into FA_TRACKING_TEMP
6334:

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

6376:
6377: if h_transaction_date is null then -- This is a case this process is called to process allocation
6378: -- other than the transaction.need to get period end date for
6379: -- transaction date
6380: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
6381: if h_perd_per_fiscal_year is null then
6382: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then
6383: raise populate_previous_rows_err;
6384: end if;

Line 6382: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then

6378: -- other than the transaction.need to get period end date for
6379: -- transaction date
6380: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
6381: if h_perd_per_fiscal_year is null then
6382: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then
6383: raise populate_previous_rows_err;
6384: end if;
6385: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
6386: end if;

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

6381: if h_perd_per_fiscal_year is null then
6382: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then
6383: raise populate_previous_rows_err;
6384: end if;
6385: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
6386: end if;
6387:
6388: select DP.end_date into h_transaction_date
6389: from FA_FISCAL_YEAR FY,

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

6387:
6388: select DP.end_date into h_transaction_date
6389: from FA_FISCAL_YEAR FY,
6390: FA_CALENDAR_PERIODS DP
6391: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6392: and DP.period_num = p_period_counter - p_fiscal_year*h_perd_per_fiscal_year
6393: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
6394: and FY.fiscal_year = p_fiscal_year
6395: and DP.start_date >= FY.start_date

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

6389: from FA_FISCAL_YEAR FY,
6390: FA_CALENDAR_PERIODS DP
6391: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6392: and DP.period_num = p_period_counter - p_fiscal_year*h_perd_per_fiscal_year
6393: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
6394: and FY.fiscal_year = p_fiscal_year
6395: and DP.start_date >= FY.start_date
6396: and DP.end_date <= FY.end_date;
6397:

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

6645:
6646: if h_transaction_date is null then -- This is a case this process is called to process allocation
6647: -- other than the transaction.need to get period end date for
6648: -- transaction date
6649: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
6650: if h_perd_per_fiscal_year is null then
6651: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then
6652: raise populate_previous_rows_err;
6653: end if;

Line 6651: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then

6647: -- other than the transaction.need to get period end date for
6648: -- transaction date
6649: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
6650: if h_perd_per_fiscal_year is null then
6651: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then
6652: raise populate_previous_rows_err;
6653: end if;
6654: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
6655: end if;

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

6650: if h_perd_per_fiscal_year is null then
6651: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then
6652: raise populate_previous_rows_err;
6653: end if;
6654: h_perd_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
6655: end if;
6656:
6657: select DP.end_date into h_transaction_date
6658: from FA_FISCAL_YEAR FY,

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

6656:
6657: select DP.end_date into h_transaction_date
6658: from FA_FISCAL_YEAR FY,
6659: FA_CALENDAR_PERIODS DP
6660: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6661: and DP.period_num = p_period_counter - p_fiscal_year*h_perd_per_fiscal_year
6662: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
6663: and FY.fiscal_year = p_fiscal_year
6664: and DP.start_date >= FY.start_date

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

6658: from FA_FISCAL_YEAR FY,
6659: FA_CALENDAR_PERIODS DP
6660: where DP.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
6661: and DP.period_num = p_period_counter - p_fiscal_year*h_perd_per_fiscal_year
6662: and FY.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
6663: and FY.fiscal_year = p_fiscal_year
6664: and DP.start_date >= FY.start_date
6665: and DP.end_date <= FY.end_date;
6666:

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

7137: h_life_in_months := p_asset_fin_rec.life_in_months;
7138:
7139: h_mem_trans_thid := nvl(p_trans_rec.member_transaction_header_id,-99);
7140: --* Prepare to call Deprn Basis Rule - 1
7141: h_period_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
7142: h_start_period_counter := h_start_fiscal_year*h_period_per_fiscal_year+h_start_period_num;
7143:
7144: select fiscal_year_name, deprn_calendar
7145: into h_fiscal_year_name,h_calendar_type

Line 7155: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;

7151: end if;
7152:
7153: /* Apply MRC related feature */
7154: if p_mrc_sob_type_code <> 'R' then
7155: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;
7156: else
7157: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
7158: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
7159: end if;

Line 7157: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,

7153: /* Apply MRC related feature */
7154: if p_mrc_sob_type_code <> 'R' then
7155: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;
7156: else
7157: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
7158: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
7159: end if;
7160:
7161: --* Need to call deprn basis rule to get correct adjusted cost at the loop start period.

Line 7158: FA_CACHE_PKG.fazcbc_record.set_of_books_id);

7154: if p_mrc_sob_type_code <> 'R' then
7155: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;
7156: else
7157: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
7158: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
7159: end if;
7160:
7161: --* Need to call deprn basis rule to get correct adjusted cost at the loop start period.
7162: -- Followings are preparation to call faxcdb

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

7166: h_period_counter||':'||h_fiscal_year||':'||h_deprn_method_code||':'||h_life_in_months, p_log_level_rec);
7167: fa_debug_pkg.add(l_calling_fn, 'Method Cache is called.', '***', p_log_level_rec);
7168: end if;
7169:
7170: if not fa_cache_pkg.fazccmt(X_method => h_deprn_method_code,
7171: X_life => h_life_in_months) then
7172: if (p_log_level_rec.statement_level) then
7173: fa_debug_pkg.add(l_calling_fn, '++ fa_cache_pkg.fazccmt is errored out ++', '+++', p_log_level_rec);
7174: end if;

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

7169:
7170: if not fa_cache_pkg.fazccmt(X_method => h_deprn_method_code,
7171: X_life => h_life_in_months) then
7172: if (p_log_level_rec.statement_level) then
7173: fa_debug_pkg.add(l_calling_fn, '++ fa_cache_pkg.fazccmt is errored out ++', '+++', p_log_level_rec);
7174: end if;
7175: raise get_member_at_start_err;
7176: end if;
7177:

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

7175: raise get_member_at_start_err;
7176: end if;
7177:
7178: -- Populate Method related information from cache
7179: h_group_deprn_basis := fa_cache_pkg.fazccmt_record.deprn_basis_rule; -- COST or NBV
7180:
7181: --* If this proceesing period is last period of the fiscal year set h_eofy_flag = 'Y'
7182: --* call depreciable basis rule function to update adjusted cost for the next year
7183: if h_start_period_num = h_period_per_fiscal_year then

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

7192: fa_rule_in.fiscal_year := h_start_fiscal_year;
7193: fa_rule_in.period_num := h_start_period_num;
7194: fa_rule_in.method_code := h_deprn_method_code;
7195: fa_rule_in.life_in_months := h_life_in_months;
7196: fa_rule_in.method_type := fa_cache_pkg.fazccmt_record.rate_source_rule;
7197: fa_rule_in.calc_basis := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
7198: fa_rule_in.mrc_sob_type_code := p_mrc_sob_type_code;
7199: fa_rule_in.group_asset_id := h_group_asset_id;
7200: fa_rule_in.period_counter := h_start_period_counter;

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

7193: fa_rule_in.period_num := h_start_period_num;
7194: fa_rule_in.method_code := h_deprn_method_code;
7195: fa_rule_in.life_in_months := h_life_in_months;
7196: fa_rule_in.method_type := fa_cache_pkg.fazccmt_record.rate_source_rule;
7197: fa_rule_in.calc_basis := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
7198: fa_rule_in.mrc_sob_type_code := p_mrc_sob_type_code;
7199: fa_rule_in.group_asset_id := h_group_asset_id;
7200: fa_rule_in.period_counter := h_start_period_counter;
7201:

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

7199: fa_rule_in.group_asset_id := h_group_asset_id;
7200: fa_rule_in.period_counter := h_start_period_counter;
7201:
7202: --* Group Level information (50% application) if the basis rule assigned to this method enables reduction rate
7203: if fa_cache_pkg.fazcdrd_record.rule_name in ('YEAR END BALANCE WITH POSITIVE REDUCTION',
7204: 'YEAR END BALANCE WITH HALF YEAR RULE') then
7205:
7206: if not check_reduction_application(p_rule_name => fa_cache_pkg.fazcdrd_record.rule_name,
7207: p_group_asset_id => h_group_asset_id,

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

7202: --* Group Level information (50% application) if the basis rule assigned to this method enables reduction rate
7203: if fa_cache_pkg.fazcdrd_record.rule_name in ('YEAR END BALANCE WITH POSITIVE REDUCTION',
7204: 'YEAR END BALANCE WITH HALF YEAR RULE') then
7205:
7206: if not check_reduction_application(p_rule_name => fa_cache_pkg.fazcdrd_record.rule_name,
7207: p_group_asset_id => h_group_asset_id,
7208: p_book_type_code => h_book_type_code,
7209: p_period_counter => h_start_period_counter,
7210: p_group_deprn_basis => h_group_deprn_basis,

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

7809: h_fiscal_year := p_dpr_in.y_end;
7810: h_period_num := p_dpr_in.p_cl_end;
7811:
7812:
7813: if (nvl(fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag, 'N') = 'N') then
7814: open c_get_member_asset_id;
7815: fetch c_get_member_asset_id into l_member_asset_id;
7816: close c_get_member_asset_id;
7817: if (p_log_level_rec.statement_level) then

Line 7829: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;

7825: end if;
7826:
7827: /* Apply MRC related feature */
7828: if p_mrc_sob_type_code <> 'R' then
7829: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;
7830:
7831: open GET_PERIOD_COUNTER;
7832: fetch GET_PERIOD_COUNTER into h_period_counter;
7833: close GET_PERIOD_COUNTER;

Line 7835: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,

7831: open GET_PERIOD_COUNTER;
7832: fetch GET_PERIOD_COUNTER into h_period_counter;
7833: close GET_PERIOD_COUNTER;
7834: else
7835: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
7836: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
7837:
7838: open GET_PERIOD_COUNTER_MRC;
7839: fetch GET_PERIOD_COUNTER_MRC into h_period_counter;

Line 7836: FA_CACHE_PKG.fazcbc_record.set_of_books_id);

7832: fetch GET_PERIOD_COUNTER into h_period_counter;
7833: close GET_PERIOD_COUNTER;
7834: else
7835: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
7836: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
7837:
7838: open GET_PERIOD_COUNTER_MRC;
7839: fetch GET_PERIOD_COUNTER_MRC into h_period_counter;
7840: close GET_PERIOD_COUNTER_MRC;

Line 8052: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;

8048: end if;
8049:
8050: /* Apply MRC related feature */
8051: if p_mrc_sob_type_code <> 'R' then
8052: h_set_of_books_id:= FA_CACHE_PKG.fazcbc_record.set_of_books_id;
8053:
8054: open GET_PERIOD_COUNTER;
8055: fetch GET_PERIOD_COUNTER into h_period_counter;
8056: close GET_PERIOD_COUNTER;

Line 8058: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,

8054: open GET_PERIOD_COUNTER;
8055: fetch GET_PERIOD_COUNTER into h_period_counter;
8056: close GET_PERIOD_COUNTER;
8057: else
8058: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
8059: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
8060:
8061: open GET_PERIOD_COUNTER_MRC;
8062: fetch GET_PERIOD_COUNTER_MRC into h_period_counter;

Line 8059: FA_CACHE_PKG.fazcbc_record.set_of_books_id);

8055: fetch GET_PERIOD_COUNTER into h_period_counter;
8056: close GET_PERIOD_COUNTER;
8057: else
8058: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
8059: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
8060:
8061: open GET_PERIOD_COUNTER_MRC;
8062: fetch GET_PERIOD_COUNTER_MRC into h_period_counter;
8063: close GET_PERIOD_COUNTER_MRC;

Line 8823: if not fa_cache_pkg.fazcct(h_deprn_calendar) then

8819: fa_debug_pkg.add(l_calling_fn, 'h_deprn_calendar:h_fiscal_year_name',
8820: h_deprn_calendar||':'||h_fiscal_year_name, p_log_level_rec);
8821: end if;
8822:
8823: if not fa_cache_pkg.fazcct(h_deprn_calendar) then
8824: if (p_log_level_rec.statement_level) then
8825: fa_debug_pkg.add(l_calling_fn, 'Calendar Cache call is failed', '+++', p_log_level_rec);
8826: end if;
8827: raise pop_mem_table_err;

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

8826: end if;
8827: raise pop_mem_table_err;
8828: end if;
8829:
8830: h_period_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
8831:
8832: open GET_FY_PERDNUM(p_amort_start_date);
8833: fetch GET_FY_PERDNUM into h_temp_fiscal_year,h_temp_period_num;
8834:

Line 8886: h_set_of_books_id := FA_CACHE_PKG.fazcbc_record.set_of_books_id;

8882: h_processing_period_num := h_group_dpis_period_num -1 ;
8883:
8884: -- If this is Reporting Books, get set of books id
8885: if p_mrc_sob_type_code <> 'R' then
8886: h_set_of_books_id := FA_CACHE_PKG.fazcbc_record.set_of_books_id;
8887:
8888: select period_counter
8889: into h_cur_period_Counter
8890: from fa_deprn_periods

Line 8903: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,

8899: and date_ineffective is null;
8900:
8901: else -- Reporting Book
8902:
8903: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
8904: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
8905:
8906: select period_counter
8907: into h_cur_period_Counter

Line 8904: FA_CACHE_PKG.fazcbc_record.set_of_books_id);

8900:
8901: else -- Reporting Book
8902:
8903: h_set_of_books_id:= nvl(FA_CACHE_PKG.fazcbcs_record.set_of_books_id,
8904: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
8905:
8906: select period_counter
8907: into h_cur_period_Counter
8908: from fa_deprn_periods_mrc_v

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

9109: if (p_log_level_rec.statement_level) then
9110: fa_debug_pkg.add(l_calling_fn, 'Method Cache is called.', '***', p_log_level_rec);
9111: end if;
9112:
9113: if not fa_cache_pkg.fazccmt(X_method => h_deprn_method_code,
9114: X_life => h_life_in_months,
9115: p_log_level_rec => p_log_level_rec) then
9116: if (p_log_level_rec.statement_level) then
9117: fa_debug_pkg.add(l_calling_fn, '++ fa_cache_pkg.fazccmt is errored out ++', '+++', p_log_level_rec);

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

9113: if not fa_cache_pkg.fazccmt(X_method => h_deprn_method_code,
9114: X_life => h_life_in_months,
9115: p_log_level_rec => p_log_level_rec) then
9116: if (p_log_level_rec.statement_level) then
9117: fa_debug_pkg.add(l_calling_fn, '++ fa_cache_pkg.fazccmt is errored out ++', '+++', p_log_level_rec);
9118: end if;
9119:
9120: raise pop_mem_table_err;
9121: end if;

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

9124: h_old_life_in_months := h_life_in_months;
9125: end if;
9126:
9127: -- Populate Method related information from cache
9128: h_group_deprn_basis := fa_cache_pkg.fazccmt_record.deprn_basis_rule; -- COST or NBV
9129:
9130: --* Get system deprn amount if subtraction flag is 'Y'
9131: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
9132:

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

9127: -- Populate Method related information from cache
9128: h_group_deprn_basis := fa_cache_pkg.fazccmt_record.deprn_basis_rule; -- COST or NBV
9129:
9130: --* Get system deprn amount if subtraction flag is 'Y'
9131: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
9132:
9133: if (p_log_level_rec.statement_level) then
9134: fa_debug_pkg.add(l_calling_fn, '++ Logic in case the subtraction flag is Y (1)' , '+++', p_log_level_rec);
9135: fa_debug_pkg.add(l_calling_fn, 'h_processing_fiscal_year', h_processing_fiscal_year, p_log_level_rec);

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

9217: fa_rule_in.period_num := h_period_num;
9218: fa_rule_in.period_counter := h_processing_period_counter;
9219: fa_rule_in.method_code := h_deprn_method_code;
9220: fa_rule_in.life_in_months := h_life_in_months;
9221: fa_rule_in.method_type := fa_cache_pkg.fazccmt_record.rate_source_rule;
9222: fa_rule_in.calc_basis := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
9223: fa_rule_in.mrc_sob_type_code := p_mrc_sob_type_code;
9224: fa_rule_in.group_asset_id := h_group_asset_id;
9225: fa_rule_in.recognize_gain_loss := h_group_recognize_gain_loss;

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

9218: fa_rule_in.period_counter := h_processing_period_counter;
9219: fa_rule_in.method_code := h_deprn_method_code;
9220: fa_rule_in.life_in_months := h_life_in_months;
9221: fa_rule_in.method_type := fa_cache_pkg.fazccmt_record.rate_source_rule;
9222: fa_rule_in.calc_basis := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
9223: fa_rule_in.mrc_sob_type_code := p_mrc_sob_type_code;
9224: fa_rule_in.group_asset_id := h_group_asset_id;
9225: fa_rule_in.recognize_gain_loss := h_group_recognize_gain_loss;
9226:

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

9224: fa_rule_in.group_asset_id := h_group_asset_id;
9225: fa_rule_in.recognize_gain_loss := h_group_recognize_gain_loss;
9226:
9227: --* Group Level information (50% application) if the basis rule assigned to this method enables reduction rate
9228: if fa_cache_pkg.fazcdrd_record.rule_name in ('YEAR END BALANCE WITH POSITIVE REDUCTION',
9229: 'YEAR END BALANCE WITH HALF YEAR RULE') then
9230:
9231: if not check_reduction_application(p_rule_name => fa_cache_pkg.fazcdrd_record.rule_name,
9232: p_group_asset_id => h_group_asset_id,

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

9227: --* Group Level information (50% application) if the basis rule assigned to this method enables reduction rate
9228: if fa_cache_pkg.fazcdrd_record.rule_name in ('YEAR END BALANCE WITH POSITIVE REDUCTION',
9229: 'YEAR END BALANCE WITH HALF YEAR RULE') then
9230:
9231: if not check_reduction_application(p_rule_name => fa_cache_pkg.fazcdrd_record.rule_name,
9232: p_group_asset_id => h_group_asset_id,
9233: p_book_type_code => h_book_type_code,
9234: p_period_counter => h_processing_period_counter,
9235: p_group_deprn_basis => h_group_deprn_basis,

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

9349: fa_debug_pkg.add(l_calling_fn, '++++ LOOP FOR GETTING DELTA *** THID', h_transaction_header_id, p_log_level_rec);
9350: 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);
9351: 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);
9352: fa_debug_pkg.add(l_calling_fn, 'h_new_perd_ctr_ret', h_new_perd_ctr_ret, p_log_level_rec);
9353: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcdrd_record.rule_name',
9354: fa_cache_pkg.fazcdrd_record.rule_name, p_log_level_rec);
9355: end if;
9356:
9357: if nvl(h_transaction_type_code,'NULL') in ('PARTIAL RETIREMENT','FULL RETIREMENT') then

Line 9354: fa_cache_pkg.fazcdrd_record.rule_name, p_log_level_rec);

9350: 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);
9351: 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);
9352: fa_debug_pkg.add(l_calling_fn, 'h_new_perd_ctr_ret', h_new_perd_ctr_ret, p_log_level_rec);
9353: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcdrd_record.rule_name',
9354: fa_cache_pkg.fazcdrd_record.rule_name, p_log_level_rec);
9355: end if;
9356:
9357: if nvl(h_transaction_type_code,'NULL') in ('PARTIAL RETIREMENT','FULL RETIREMENT') then
9358: open GET_RETIREMENTS(h_transaction_header_id);

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

9360: close GET_RETIREMENTS;
9361:
9362: -- ENERGY
9363: -- reserve retired will not be equal to cost when recognize_gain_loss = 'NO'
9364: -- ONLY if fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE'
9365: if nvl(h_recognize_gain_loss,'NO') = 'NO' and -- ENERGY
9366: (nvl(fa_cache_pkg.fazcdrd_record.rule_name, 'NONE') <> 'ENERGY PERIOD END BALANCE') then
9367: h_new_eofy_reserve := 0;
9368: else

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

9362: -- ENERGY
9363: -- reserve retired will not be equal to cost when recognize_gain_loss = 'NO'
9364: -- ONLY if fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE'
9365: if nvl(h_recognize_gain_loss,'NO') = 'NO' and -- ENERGY
9366: (nvl(fa_cache_pkg.fazcdrd_record.rule_name, 'NONE') <> 'ENERGY PERIOD END BALANCE') then
9367: h_new_eofy_reserve := 0;
9368: else
9369: h_new_eofy_reserve := nvl(h_new_eofy_reserve,0) + nvl(h_adj_eofy_reserve,0);
9370: h_new_reserve_retired := nvl(h_new_reserve_retired,0) + nvl(h_adj_reserve_retired,0);

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

9375: fa_debug_pkg.add(l_calling_fn, 'h_new_eofy_reserve:h_new_reserve_retired',
9376: h_new_eofy_reserve||':'||h_new_reserve_retired, p_log_level_rec);
9377: end if;
9378: elsif (nvl(h_transaction_type_code,'NULL') = 'REINSTATEMENT') and
9379: (nvl(fa_cache_pkg.fazcdrd_record.rule_name, 'NONE') = 'ENERGY PERIOD END BALANCE') then
9380: --toru
9381: open GET_REINSTATEMENT(h_transaction_header_id);
9382: fetch GET_REINSTATEMENT into h_recognize_gain_loss, h_adj_eofy_reserve, h_adj_reserve_retired;
9383: close GET_REINSTATEMENT;

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

10156: -- Calculate purely periodic expense
10157: h_periodic_expense := h_group_deprn_amount - nvl(h_group_adj_expense,0);
10158: h_periodic_bonus_expense := nvl(h_group_bonus_deprn_amount,0) - nvl(h_group_adj_bonus_expense,0);
10159:
10160: if fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag = 'YES' then
10161: h_group_exclude_salvage := 'Y';
10162: else
10163: h_group_exclude_salvage := 'N';
10164: end if;

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

10170: h_allocate_to_fully_ret_flag := p_asset_fin_rec_new.allocate_to_fully_ret_flag;
10171: h_excess_allocation_option := p_asset_fin_rec_new.excess_allocation_option;
10172: h_depreciation_option := p_asset_fin_rec_new.depreciation_option;
10173: h_member_rollup_flag := p_asset_fin_rec_new.member_rollup_flag;
10174: h_subtraction_flag := fa_cache_pkg.fazcdrd_record.subtract_ytd_flag;
10175:
10176: if h_processing_period_counter <> h_recalc_period_counter or
10177: (h_processing_period_counter = h_recalc_period_counter and
10178: p_no_allocation_for_last = 'N') then

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

10229: --* Following logic is prepared for exclude_salvage_value in FA_BOOKS is set.
10230: -- In this case, adjusted_cost of fully reserved should be removed from adjusted_cost
10231: -- of group asset. so need to maintain the memory table adjusted cost
10232: if nvl(h_exclude_fully_rsv_flag,'N') = 'Y' and
10233: nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule,'COST') = 'NBV' then
10234:
10235: if (p_log_level_rec.statement_level) then
10236: fa_debug_pkg.add(l_calling_fn, 'Fully Reserve Asset treatment', 'Starts++++', p_log_level_rec);
10237: fa_debug_pkg.add(l_calling_fn, 'h_processing_fiscal_year lopped out', h_processing_fiscal_year, p_log_level_rec);

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

10495: h_group_asset_id := p_asset_hdr_rec.asset_id;
10496: h_set_of_books_id := p_asset_hdr_rec.set_of_books_id;
10497:
10498: -- Populate Subtract Ytd Flag
10499: if not fa_cache_pkg.fazccmt(X_method => p_asset_fin_rec_new.deprn_method_code,
10500: X_life => p_asset_fin_rec_new.life_in_months) then
10501: raise pop_mem_amt_err;
10502: end if;
10503:

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

10867: 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);
10868: end if;
10869:
10870: if p_current_fiscal_year is not null and p_current_period_num is not null then
10871: h_number_per_fy := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
10872: h_period_counter := p_current_fiscal_year*h_number_per_fy+p_current_period_num;
10873: else
10874: h_period_counter := NULL;
10875: end if;

Line 11298: h_set_of_books_id := NVL(fa_cache_pkg.fazcbcs_record.set_of_books_id,

11294: if nvl(p_calling_fn,'NULL') = 'POPULATE_MEMBER_ASSETS_TABLE' then
11295: -- This funcation can work only during processing populate_member_assets_table
11296:
11297: IF p_mrc_sob_type_code = 'R' THEN
11298: h_set_of_books_id := NVL(fa_cache_pkg.fazcbcs_record.set_of_books_id,
11299: fa_cache_pkg.fazcbc_record.set_of_books_id);
11300: h_reporting_flag := 'R';
11301: ELSE
11302: h_set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

Line 11299: fa_cache_pkg.fazcbc_record.set_of_books_id);

11295: -- This funcation can work only during processing populate_member_assets_table
11296:
11297: IF p_mrc_sob_type_code = 'R' THEN
11298: h_set_of_books_id := NVL(fa_cache_pkg.fazcbcs_record.set_of_books_id,
11299: fa_cache_pkg.fazcbc_record.set_of_books_id);
11300: h_reporting_flag := 'R';
11301: ELSE
11302: h_set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
11303: h_reporting_flag := 'P';

Line 11302: h_set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

11298: h_set_of_books_id := NVL(fa_cache_pkg.fazcbcs_record.set_of_books_id,
11299: fa_cache_pkg.fazcbc_record.set_of_books_id);
11300: h_reporting_flag := 'R';
11301: ELSE
11302: h_set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
11303: h_reporting_flag := 'P';
11304: END IF;
11305:
11306: if (p_log_level_rec.statement_level) then

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

11306: if (p_log_level_rec.statement_level) then
11307: 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);
11308: end if;
11309: /* select the corresponding period_counter for the current period: fyctr, perd_ctr */
11310: h_calendar_type:= fa_cache_pkg.fazcbc_record.deprn_calendar;
11311: h_fy_name:= fa_cache_pkg.fazcbc_record.fiscal_year_name;
11312: h_num_per_fy:= fa_cache_pkg.fazcct_record.number_per_fiscal_year;
11313:
11314: select cp.period_name

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

11307: 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);
11308: end if;
11309: /* select the corresponding period_counter for the current period: fyctr, perd_ctr */
11310: h_calendar_type:= fa_cache_pkg.fazcbc_record.deprn_calendar;
11311: h_fy_name:= fa_cache_pkg.fazcbc_record.fiscal_year_name;
11312: h_num_per_fy:= fa_cache_pkg.fazcct_record.number_per_fiscal_year;
11313:
11314: select cp.period_name
11315: into h_period_name

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

11308: end if;
11309: /* select the corresponding period_counter for the current period: fyctr, perd_ctr */
11310: h_calendar_type:= fa_cache_pkg.fazcbc_record.deprn_calendar;
11311: h_fy_name:= fa_cache_pkg.fazcbc_record.fiscal_year_name;
11312: h_num_per_fy:= fa_cache_pkg.fazcct_record.number_per_fiscal_year;
11313:
11314: select cp.period_name
11315: into h_period_name
11316: from fa_calendar_periods cp, fa_fiscal_year fy