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_FP_ELEMENTS_PUB dependencies on PA_FP_ELEMENTS

Line 1: package PA_FP_ELEMENTS_PUB as

1: package PA_FP_ELEMENTS_PUB as
2: /* $Header: PAFPELPS.pls 120.1 2005/08/19 16:26:29 mwasowic noship $ */
3:
4: Invalid_Arg_Exc EXCEPTION;
5:

Line 29: pa_fp_elements.TASK_ID%TYPE INDEX BY BINARY_INTEGER;

25: TYPE l_wbs_refresh_tasks_tbl_typ is TABLE OF
26: l_wbs_refresh_tasks_rec_typ INDEX BY BINARY_INTEGER;--For Bug 2976168.
27:
28: TYPE l_task_id_tbl_typ IS TABLE OF
29: pa_fp_elements.TASK_ID%TYPE INDEX BY BINARY_INTEGER;
30: TYPE l_top_task_id_tbl_typ IS TABLE OF
31: pa_fp_elements.TOP_TASK_ID%TYPE INDEX BY BINARY_INTEGER;
32: TYPE l_res_list_mem_id_tbl_typ IS TABLE OF
33: pa_fp_elements.RESOURCE_LIST_MEMBER_ID%TYPE INDEX BY BINARY_INTEGER;

Line 31: pa_fp_elements.TOP_TASK_ID%TYPE INDEX BY BINARY_INTEGER;

27:
28: TYPE l_task_id_tbl_typ IS TABLE OF
29: pa_fp_elements.TASK_ID%TYPE INDEX BY BINARY_INTEGER;
30: TYPE l_top_task_id_tbl_typ IS TABLE OF
31: pa_fp_elements.TOP_TASK_ID%TYPE INDEX BY BINARY_INTEGER;
32: TYPE l_res_list_mem_id_tbl_typ IS TABLE OF
33: pa_fp_elements.RESOURCE_LIST_MEMBER_ID%TYPE INDEX BY BINARY_INTEGER;
34: TYPE l_task_planning_level_tbl_typ IS TABLE OF
35: pa_fp_elements.TOP_TASK_PLANNING_LEVEL%TYPE INDEX BY BINARY_INTEGER;

Line 33: pa_fp_elements.RESOURCE_LIST_MEMBER_ID%TYPE INDEX BY BINARY_INTEGER;

29: pa_fp_elements.TASK_ID%TYPE INDEX BY BINARY_INTEGER;
30: TYPE l_top_task_id_tbl_typ IS TABLE OF
31: pa_fp_elements.TOP_TASK_ID%TYPE INDEX BY BINARY_INTEGER;
32: TYPE l_res_list_mem_id_tbl_typ IS TABLE OF
33: pa_fp_elements.RESOURCE_LIST_MEMBER_ID%TYPE INDEX BY BINARY_INTEGER;
34: TYPE l_task_planning_level_tbl_typ IS TABLE OF
35: pa_fp_elements.TOP_TASK_PLANNING_LEVEL%TYPE INDEX BY BINARY_INTEGER;
36: TYPE l_track_as_labor_flag_tbl_typ IS TABLE OF
37: pa_resource_assignments.TRACK_AS_LABOR_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 35: pa_fp_elements.TOP_TASK_PLANNING_LEVEL%TYPE INDEX BY BINARY_INTEGER;

31: pa_fp_elements.TOP_TASK_ID%TYPE INDEX BY BINARY_INTEGER;
32: TYPE l_res_list_mem_id_tbl_typ IS TABLE OF
33: pa_fp_elements.RESOURCE_LIST_MEMBER_ID%TYPE INDEX BY BINARY_INTEGER;
34: TYPE l_task_planning_level_tbl_typ IS TABLE OF
35: pa_fp_elements.TOP_TASK_PLANNING_LEVEL%TYPE INDEX BY BINARY_INTEGER;
36: TYPE l_track_as_labor_flag_tbl_typ IS TABLE OF
37: pa_resource_assignments.TRACK_AS_LABOR_FLAG%TYPE INDEX BY BINARY_INTEGER;
38: TYPE l_unit_of_measure_tbl_typ IS TABLE OF
39: pa_resource_assignments.UNIT_OF_MEASURE%TYPE INDEX BY BINARY_INTEGER;

Line 41: pa_fp_elements.RESOURCE_PLANNING_LEVEL%TYPE INDEX BY BINARY_INTEGER;

37: pa_resource_assignments.TRACK_AS_LABOR_FLAG%TYPE INDEX BY BINARY_INTEGER;
38: TYPE l_unit_of_measure_tbl_typ IS TABLE OF
39: pa_resource_assignments.UNIT_OF_MEASURE%TYPE INDEX BY BINARY_INTEGER;
40: TYPE l_res_planning_level_tbl_typ IS TABLE OF
41: pa_fp_elements.RESOURCE_PLANNING_LEVEL%TYPE INDEX BY BINARY_INTEGER;
42: TYPE l_plannable_flag_tbl_typ IS TABLE OF
43: pa_fp_elements.PLANNABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
44: TYPE l_res_planned_for_task_tbl_typ IS TABLE OF
45: pa_fp_elements.RESOURCES_PLANNED_FOR_TASK%TYPE INDEX BY BINARY_INTEGER;

Line 43: pa_fp_elements.PLANNABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;

39: pa_resource_assignments.UNIT_OF_MEASURE%TYPE INDEX BY BINARY_INTEGER;
40: TYPE l_res_planning_level_tbl_typ IS TABLE OF
41: pa_fp_elements.RESOURCE_PLANNING_LEVEL%TYPE INDEX BY BINARY_INTEGER;
42: TYPE l_plannable_flag_tbl_typ IS TABLE OF
43: pa_fp_elements.PLANNABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
44: TYPE l_res_planned_for_task_tbl_typ IS TABLE OF
45: pa_fp_elements.RESOURCES_PLANNED_FOR_TASK%TYPE INDEX BY BINARY_INTEGER;
46: TYPE l_planamount_exists_tbl_typ IS TABLE OF
47: pa_fp_elements.PLAN_AMOUNT_EXISTS_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 45: pa_fp_elements.RESOURCES_PLANNED_FOR_TASK%TYPE INDEX BY BINARY_INTEGER;

41: pa_fp_elements.RESOURCE_PLANNING_LEVEL%TYPE INDEX BY BINARY_INTEGER;
42: TYPE l_plannable_flag_tbl_typ IS TABLE OF
43: pa_fp_elements.PLANNABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
44: TYPE l_res_planned_for_task_tbl_typ IS TABLE OF
45: pa_fp_elements.RESOURCES_PLANNED_FOR_TASK%TYPE INDEX BY BINARY_INTEGER;
46: TYPE l_planamount_exists_tbl_typ IS TABLE OF
47: pa_fp_elements.PLAN_AMOUNT_EXISTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
48: TYPE l_impacted_task_in_tbl_typ IS TABLE OF
49: l_impacted_task_in_rec_typ INDEX BY BINARY_INTEGER;

Line 47: pa_fp_elements.PLAN_AMOUNT_EXISTS_FLAG%TYPE INDEX BY BINARY_INTEGER;

43: pa_fp_elements.PLANNABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
44: TYPE l_res_planned_for_task_tbl_typ IS TABLE OF
45: pa_fp_elements.RESOURCES_PLANNED_FOR_TASK%TYPE INDEX BY BINARY_INTEGER;
46: TYPE l_planamount_exists_tbl_typ IS TABLE OF
47: pa_fp_elements.PLAN_AMOUNT_EXISTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
48: TYPE l_impacted_task_in_tbl_typ IS TABLE OF
49: l_impacted_task_in_rec_typ INDEX BY BINARY_INTEGER;
50:
51: /* PLSQL table types */

Line 156: ,p_element_type IN pa_fp_elements.element_type%TYPE

152: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
153:
154: FUNCTION get_element_id (
155: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
156: ,p_element_type IN pa_fp_elements.element_type%TYPE
157: ,p_task_id IN pa_tasks.task_id%TYPE
158: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE)
159: RETURN pa_fp_elements.proj_fp_elements_id%TYPE;
160:

Line 159: RETURN pa_fp_elements.proj_fp_elements_id%TYPE;

155: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
156: ,p_element_type IN pa_fp_elements.element_type%TYPE
157: ,p_task_id IN pa_tasks.task_id%TYPE
158: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE)
159: RETURN pa_fp_elements.proj_fp_elements_id%TYPE;
160:
161: FUNCTION get_element_plannable_flag (
162: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
163: ,p_element_type IN pa_fp_elements.element_type%TYPE

Line 163: ,p_element_type IN pa_fp_elements.element_type%TYPE

159: RETURN pa_fp_elements.proj_fp_elements_id%TYPE;
160:
161: FUNCTION get_element_plannable_flag (
162: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
163: ,p_element_type IN pa_fp_elements.element_type%TYPE
164: ,p_task_id IN pa_tasks.task_id%TYPE
165: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE)
166: RETURN pa_fp_elements.plannable_flag%TYPE;
167:

Line 166: RETURN pa_fp_elements.plannable_flag%TYPE;

162: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
163: ,p_element_type IN pa_fp_elements.element_type%TYPE
164: ,p_task_id IN pa_tasks.task_id%TYPE
165: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE)
166: RETURN pa_fp_elements.plannable_flag%TYPE;
167:
168: FUNCTION get_plan_amount_exists_flag (
169: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
170: ,p_element_type IN pa_fp_elements.element_type%TYPE

Line 170: ,p_element_type IN pa_fp_elements.element_type%TYPE

166: RETURN pa_fp_elements.plannable_flag%TYPE;
167:
168: FUNCTION get_plan_amount_exists_flag (
169: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
170: ,p_element_type IN pa_fp_elements.element_type%TYPE
171: ,p_task_id IN pa_tasks.task_id%TYPE
172: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE)
173: RETURN pa_fp_elements.plan_amount_exists_flag%TYPE;
174:

Line 173: RETURN pa_fp_elements.plan_amount_exists_flag%TYPE;

169: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
170: ,p_element_type IN pa_fp_elements.element_type%TYPE
171: ,p_task_id IN pa_tasks.task_id%TYPE
172: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE)
173: RETURN pa_fp_elements.plan_amount_exists_flag%TYPE;
174:
175: /*=================================================================================
176: The follwing function has been created to get resource_planning_level value in
177: Create_elements_from_version api.

Line 183: RETURN pa_fp_elements.resource_planning_level%TYPE;

179: FUNCTION get_resource_planning_level(
180: p_parent_member_id IN pa_resource_list_members.parent_member_id%TYPE
181: ,p_uncategorized_flag IN pa_resource_lists.uncategorized_flag%TYPE
182: ,p_grouped_flag IN VARCHAR2)
183: RETURN pa_fp_elements.resource_planning_level%TYPE;
184:
185: PROCEDURE Create_elements_from_version(
186: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
187: ,p_element_type IN pa_fp_elements.element_type%TYPE

Line 187: ,p_element_type IN pa_fp_elements.element_type%TYPE

183: RETURN pa_fp_elements.resource_planning_level%TYPE;
184:
185: PROCEDURE Create_elements_from_version(
186: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
187: ,p_element_type IN pa_fp_elements.element_type%TYPE
188: ,p_from_version_id IN pa_budget_versions.budget_version_id%TYPE
189: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
190: ,x_mixed_resource_planned_flag OUT NOCOPY VARCHAR2 -- new parameter for Bug :- 2625872 --File.Sql.39 bug 4440895
191: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 198: ,p_element_type IN PA_FP_ELEMENTS.ELEMENT_TYPE%TYPE /* COST,REVENUE,ALL,BOTH */

194:
195:
196: PROCEDURE refresh_res_list_changes (
197: p_proj_fp_options_id IN PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE
198: ,p_element_type IN PA_FP_ELEMENTS.ELEMENT_TYPE%TYPE /* COST,REVENUE,ALL,BOTH */
199: ,p_cost_resource_list_id IN PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE
200: ,p_rev_resource_list_id IN PA_PROJ_FP_OPTIONS.REVENUE_RESOURCE_LIST_ID%TYPE
201: ,p_all_resource_list_id IN PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE
202: /* Bug :- 2920954 start of new parameters added for post fp-K one off patch */

Line 231: ,p_element_type IN pa_fp_elements.element_type%TYPE

227: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
228:
229: PROCEDURE Add_resources_automatically
230: ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
231: ,p_element_type IN pa_fp_elements.element_type%TYPE
232: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
233: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE
234: ,p_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
235: ,p_entire_option IN VARCHAR2

Line 236: ,p_element_task_id_tbl IN pa_fp_elements_pub.l_task_id_tbl_typ

232: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
233: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE
234: ,p_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
235: ,p_entire_option IN VARCHAR2
236: ,p_element_task_id_tbl IN pa_fp_elements_pub.l_task_id_tbl_typ
237: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
238: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
239: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
240:

Line 256: ,p_tasks_tbl IN pa_fp_elements_pub.l_wbs_refresh_tasks_tbl_typ

252: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
253:
254: PROCEDURE make_new_tasks_plannable
255: ( p_project_id IN pa_projects_all.project_id%TYPE
256: ,p_tasks_tbl IN pa_fp_elements_pub.l_wbs_refresh_tasks_tbl_typ
257: ,p_refresh_fp_options_tbl IN PA_PLSQL_DATATYPES.IdTabTyp
258: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
259: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
260: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 264: end PA_FP_ELEMENTS_PUB;

260: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
261:
262:
263:
264: end PA_FP_ELEMENTS_PUB;
265: