DBA Data[Home] [Help]

APPS.PA_DISPLAY_PERIOD_MASKS dependencies on PA_IMPLEMENTATIONS_ALL

Line 40: ,p_pa_period_type IN pa_implementations_all.pa_period_type%TYPE)

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
44:

Line 93: ,p_pa_period_type IN pa_implementations_all.pa_period_type%TYPE

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:
97:

Line 134: ,p_pa_period_type IN pa_implementations_all.pa_period_type%TYPE

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:
138:

Line 266: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;

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;
270: l_count NUMBER := 0 ; --counter variable

Line 282: -- pa_period_type exists in pa_implementations_all

278: -- get_current_period_start_date() must return a start date for get_gl_periods_before_csr
279: -- and get_gl_periods_after_csr to run
280: -- period_set_name and accounted_period_type exist in table gl_set_of_books
281: -- current_planning_period and period_mask_id exist in table pa_budget_versions
282: -- pa_period_type exists in pa_implementations_all
283: -- to find the time phase code decode is used
284: -- IF pbv.version_type = COST the time phase code = ppfo.cost_time_phased_code
285: -- IF pbv.version_type = REVENUE the time phase code = ppfo.revenue_time_phased_code
286: -- ELSE the time phase code = ppfo.all_time_phased_code

Line 303: ,pa_implementations_all pia

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
307: WHERE ppa.project_id = pbv.project_id