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.PA_DISPLAY_PERIOD_MASKS dependencies on PA_RESOURCE_ASSIGNMENTS

Line 89: PROCEDURE get_plan_period_end ( p_planning_end_date IN pa_resource_assignments.planning_end_date%TYPE

85: END get_current_period_start_date;
86:
87:
88:
89: PROCEDURE get_plan_period_end ( p_planning_end_date IN pa_resource_assignments.planning_end_date%TYPE
90: ,p_period_set_name IN gl_sets_of_books.period_set_name%TYPE
91: ,p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
92: ,p_accounted_period_type IN gl_sets_of_books.accounted_period_type%TYPE
93: ,p_pa_period_type IN pa_implementations_all.pa_period_type%TYPE

Line 130: PROCEDURE get_plan_period_start ( p_planning_start_date IN pa_resource_assignments.planning_start_date%TYPE

126: END get_plan_period_end;
127:
128:
129:
130: PROCEDURE get_plan_period_start ( p_planning_start_date IN pa_resource_assignments.planning_start_date%TYPE
131: ,p_period_set_name IN gl_sets_of_books.period_set_name%TYPE
132: ,p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
133: ,p_accounted_period_type IN gl_sets_of_books.accounted_period_type%TYPE
134: ,p_pa_period_type IN pa_implementations_all.pa_period_type%TYPE

Line 260: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE DEFAULT -1) RETURN NUMBER

256: -- these will be used for the proceeding buckets end period and suceeding buckets start period
257: -- get_periods will return 1 if it populates periods_tab pl/sql table successfully
258: */
259: FUNCTION get_periods ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
260: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE DEFAULT -1) RETURN NUMBER
261: IS
262: l_return NUMBER := 0; --RETURN value
263: l_current_planning_period pa_budget_versions.current_planning_period%TYPE;
264: l_period_set_name gl_sets_of_books.period_set_name%TYPE;

Line 271: l_plan_start_date pa_resource_assignments.planning_start_date%TYPE;

267: l_time_phase_code pa_proj_fp_options.cost_time_phased_code%TYPE;
268: l_period_mask_id pa_period_mask_details.period_mask_id%TYPE;
269: l_cpp_start_date DATE;
270: l_count NUMBER := 0 ; --counter variable
271: l_plan_start_date pa_resource_assignments.planning_start_date%TYPE;
272: l_plan_end_date pa_resource_assignments.planning_end_date%TYPE;
273:
274:
275: /*

Line 272: l_plan_end_date pa_resource_assignments.planning_end_date%TYPE;

268: l_period_mask_id pa_period_mask_details.period_mask_id%TYPE;
269: l_cpp_start_date DATE;
270: l_count NUMBER := 0 ; --counter variable
271: l_plan_start_date pa_resource_assignments.planning_start_date%TYPE;
272: l_plan_end_date pa_resource_assignments.planning_end_date%TYPE;
273:
274:
275: /*
276: -- get_name_and_type_csr is used to select the parameters needed for

Line 317: FROM pa_resource_assignments

313:
314: CURSOR get_resource_asg_dates IS
315: SELECT planning_start_date,
316: planning_end_date
317: FROM pa_resource_assignments
318: WHERE resource_assignment_id = p_resource_assignment_id;
319:
320: get_name_and_type_rec get_name_and_type_csr%ROWTYPE;
321: