APPS.HR_BUDGET_CALENDAR dependencies on PER_TIME_PERIODS

Line 67: from per_time_periods tpe

63: -- between the start and end of the period.
64: begin
65: select tpe.end_date - tpe.start_date + 1
66: into v_midpoint_offset
67: from per_time_periods tpe
68: where tpe.period_set_name = p_period_set_name
69: and tpe.start_date = p_start_date;
70: exception
71: when no_data_found then

Line 156: insert into per_time_periods

152: begin
153: --
154: -- Creates a single time period for a calendar if the time period to be
155: -- created does not overlap with an existing time period for the calendar.
156: insert into per_time_periods
157: (time_period_id,
158: period_set_name,
159: period_name,
160: period_type,

Line 173: per_time_periods_s.nextval,

169: last_update_login,
170: created_by,
171: creation_date)
172: select
173: per_time_periods_s.nextval,
174: p_period_set_name,
175: to_char(p_prd_num) || ' ' || to_char(p_prd_end_date, 'YYYY') || ' ' ||
176: p_prd_type,
177: p_prd_type,

Line 341: from per_time_periods tpe

337: -- Set the start date of the calendar to be the day after the last time
338: -- period.
339: select max(tpe.end_date) + 1
340: into v_cal_details.start_date
341: from per_time_periods tpe
342: where tpe.period_set_name = v_cal_details.period_set_name;
343: --
344: v_cal_details.start_year_number := v_num_yrs + 1;
345: --

Line 528: from per_time_periods tpe

524: ) is
525: --
526: cursor csr_budget_values is
527: select tpe.time_period_id
528: from per_time_periods tpe
529: where tpe.period_set_name = p_period_set_name
530: and tpe.period_year > p_number_of_years
531: and exists
532: (select null

Line 560: delete from per_time_periods tpe

556: end if;
557: --
558: -- Remove all time periods that exist in years greater than the new
559: -- number of years.
560: delete from per_time_periods tpe
561: where tpe.period_set_name = p_period_set_name
562: and tpe.period_year > p_number_of_years;
563: --
564: -- Remove calendar years.