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_CDE_PKG dependencies on FA_CALENDAR_PERIODS

Line 9: g_pre_period_name fa_calendar_periods.period_name%TYPE;

5: ROUND_ALWAYS constant integer:= 1;
6: g_tested_use_annual_round boolean:= FALSE;
7: g_use_annual_round integer:= ROUND_WITH_RESTRICTIONS;
8: primary_cost NUMBER;
9: g_pre_period_name fa_calendar_periods.period_name%TYPE;
10: g_pre_period_ctr fa_calendar_periods.period_num%TYPE;
11: g_pre_fyctr fa_fiscal_year.fiscal_year%TYPE;
12:
13:

Line 10: g_pre_period_ctr fa_calendar_periods.period_num%TYPE;

6: g_tested_use_annual_round boolean:= FALSE;
7: g_use_annual_round integer:= ROUND_WITH_RESTRICTIONS;
8: primary_cost NUMBER;
9: g_pre_period_name fa_calendar_periods.period_name%TYPE;
10: g_pre_period_ctr fa_calendar_periods.period_num%TYPE;
11: g_pre_fyctr fa_fiscal_year.fiscal_year%TYPE;
12:
13:
14:

Line 1293: from fa_calendar_periods fcp1,

1289: --Added new cursor and variable to check for retirement in period of addition
1290: prd_flag varchar2(1);
1291: cursor c_prd_flag is
1292: select 'Y'
1293: from fa_calendar_periods fcp1,
1294: fa_calendar_periods fcp2,
1295: fa_book_controls fbc
1296: where to_date (dpr_in.prorate_jdate,'J') BETWEEN fcp1.start_date and fcp1.end_date
1297: and fbc.book_type_code = dpr_in.book

Line 1294: fa_calendar_periods fcp2,

1290: prd_flag varchar2(1);
1291: cursor c_prd_flag is
1292: select 'Y'
1293: from fa_calendar_periods fcp1,
1294: fa_calendar_periods fcp2,
1295: fa_book_controls fbc
1296: where to_date (dpr_in.prorate_jdate,'J') BETWEEN fcp1.start_date and fcp1.end_date
1297: and fbc.book_type_code = dpr_in.book
1298: and fcp1.calendar_type = fbc.deprn_calendar

Line 4264: from fa_calendar_periods cp, fa_fiscal_year fy

4260:
4261: /* -- FIGURE OUT THE PERIOD_COUNTER for the current fyctr and perd_ctr
4262: select fy.fiscal_year * h_num_per_fy + cp.period_num
4263: into perd_c
4264: from fa_calendar_periods cp, fa_fiscal_year fy
4265: where cp.period_num = perd_ctr
4266: and fy.fiscal_year = fyctr
4267: and cp.calendar_type = h_calendar_type
4268: and cp.start_date >= fy.start_date

Line 4277: from fa_calendar_periods cp, fa_fiscal_year fy

4273: -- FIGURE OUT THE PERIOD_NAME for the current fyctr and perd_ctr
4274: if perd_ctr <> nvl(g_pre_period_ctr, 0) or fyctr <> nvl(g_pre_fyctr,0) then
4275:
4276: select cp.period_name into perd_name
4277: from fa_calendar_periods cp, fa_fiscal_year fy
4278: where cp.calendar_type = h_calendar_type and
4279: cp.period_num = perd_ctr and
4280: cp.start_date >= fy.start_date and
4281: cp.end_date <= fy.end_date and