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 GL_SETS_OF_BOOKS

Line 37: ,p_period_set_name IN gl_sets_of_books.period_set_name%TYPE

33: -- it is called by get_periods()
34: */
35:
36: FUNCTION get_current_period_start_date ( p_current_planning_period IN pa_budget_versions.current_planning_period%TYPE
37: ,p_period_set_name IN gl_sets_of_books.period_set_name%TYPE
38: ,p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
39: ,p_accounted_period_type IN gl_sets_of_books.accounted_period_type%TYPE
40: ,p_pa_period_type IN pa_implementations_all.pa_period_type%TYPE)
41: RETURN DATE IS

Line 39: ,p_accounted_period_type IN gl_sets_of_books.accounted_period_type%TYPE

35:
36: FUNCTION get_current_period_start_date ( p_current_planning_period IN pa_budget_versions.current_planning_period%TYPE
37: ,p_period_set_name IN gl_sets_of_books.period_set_name%TYPE
38: ,p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
39: ,p_accounted_period_type IN gl_sets_of_books.accounted_period_type%TYPE
40: ,p_pa_period_type IN pa_implementations_all.pa_period_type%TYPE)
41: RETURN DATE IS
42:
43: l_current_period_start_date DATE; --RETURN value

Line 90: ,p_period_set_name IN gl_sets_of_books.period_set_name%TYPE

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
94: )

Line 92: ,p_accounted_period_type IN gl_sets_of_books.accounted_period_type%TYPE

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
94: )
95: IS
96:

Line 131: ,p_period_set_name IN gl_sets_of_books.period_set_name%TYPE

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
135: )

Line 133: ,p_accounted_period_type IN gl_sets_of_books.accounted_period_type%TYPE

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
135: )
136: IS
137:

Line 264: l_period_set_name gl_sets_of_books.period_set_name%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;
265: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
266: l_pa_period_type pa_implementations_all.pa_period_type%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;

Line 265: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;

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;
265: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
266: l_pa_period_type pa_implementations_all.pa_period_type%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;

Line 302: FROM gl_sets_of_books gsb

298: ,decode(pbv.version_type,
299: 'COST',ppfo.cost_time_phased_code,
300: 'REVENUE',ppfo.revenue_time_phased_code,
301: ppfo.all_time_phased_code) time_phase_code
302: FROM gl_sets_of_books gsb
303: ,pa_implementations_all pia
304: ,pa_projects_all ppa
305: ,pa_budget_versions pbv
306: ,pa_proj_fp_options ppfo