DBA Data[Home] [Help]

APPS.PA_FP_ELEMENTS_PUB dependencies on PA_TASKS

Line 9: (impacted_task_id pa_tasks.task_id%TYPE

5:
6: /* PLSQL record types */
7:
8: TYPE l_impacted_task_in_rec_typ IS RECORD
9: (impacted_task_id pa_tasks.task_id%TYPE
10: ,old_parent_task_id pa_tasks.task_id%TYPE
11: ,new_parent_task_id pa_tasks.task_id%TYPE
12: ,top_task_id pa_tasks.task_id%TYPE
13: ,action VARCHAR2(30));

Line 10: ,old_parent_task_id pa_tasks.task_id%TYPE

6: /* PLSQL record types */
7:
8: TYPE l_impacted_task_in_rec_typ IS RECORD
9: (impacted_task_id pa_tasks.task_id%TYPE
10: ,old_parent_task_id pa_tasks.task_id%TYPE
11: ,new_parent_task_id pa_tasks.task_id%TYPE
12: ,top_task_id pa_tasks.task_id%TYPE
13: ,action VARCHAR2(30));
14:

Line 11: ,new_parent_task_id pa_tasks.task_id%TYPE

7:
8: TYPE l_impacted_task_in_rec_typ IS RECORD
9: (impacted_task_id pa_tasks.task_id%TYPE
10: ,old_parent_task_id pa_tasks.task_id%TYPE
11: ,new_parent_task_id pa_tasks.task_id%TYPE
12: ,top_task_id pa_tasks.task_id%TYPE
13: ,action VARCHAR2(30));
14:
15: --For Bug 2976168.

Line 12: ,top_task_id pa_tasks.task_id%TYPE

8: TYPE l_impacted_task_in_rec_typ IS RECORD
9: (impacted_task_id pa_tasks.task_id%TYPE
10: ,old_parent_task_id pa_tasks.task_id%TYPE
11: ,new_parent_task_id pa_tasks.task_id%TYPE
12: ,top_task_id pa_tasks.task_id%TYPE
13: ,action VARCHAR2(30));
14:
15: --For Bug 2976168.
16: TYPE l_wbs_refresh_tasks_rec_typ IS RECORD

Line 17: ( task_id pa_tasks.task_id%TYPE

13: ,action VARCHAR2(30));
14:
15: --For Bug 2976168.
16: TYPE l_wbs_refresh_tasks_rec_typ IS RECORD
17: ( task_id pa_tasks.task_id%TYPE
18: ,parent_task_id pa_tasks.parent_task_id%TYPE
19: ,top_task_id pa_tasks.top_task_id%TYPE
20: ,task_level VARCHAR2(1) -- T - Top Task, M - Middle Task, L - Lowest Task
21: );

Line 18: ,parent_task_id pa_tasks.parent_task_id%TYPE

14:
15: --For Bug 2976168.
16: TYPE l_wbs_refresh_tasks_rec_typ IS RECORD
17: ( task_id pa_tasks.task_id%TYPE
18: ,parent_task_id pa_tasks.parent_task_id%TYPE
19: ,top_task_id pa_tasks.top_task_id%TYPE
20: ,task_level VARCHAR2(1) -- T - Top Task, M - Middle Task, L - Lowest Task
21: );
22:

Line 19: ,top_task_id pa_tasks.top_task_id%TYPE

15: --For Bug 2976168.
16: TYPE l_wbs_refresh_tasks_rec_typ IS RECORD
17: ( task_id pa_tasks.task_id%TYPE
18: ,parent_task_id pa_tasks.parent_task_id%TYPE
19: ,top_task_id pa_tasks.top_task_id%TYPE
20: ,task_level VARCHAR2(1) -- T - Top Task, M - Middle Task, L - Lowest Task
21: );
22:
23: /* PLSQL table types */

Line 148: ,p_task_id IN pa_tasks.task_id%TYPE DEFAULT NULL

144: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
145:
146: PROCEDURE Create_Enterable_Resources (
147: p_plan_version_id IN NUMBER
148: ,p_task_id IN pa_tasks.task_id%TYPE DEFAULT NULL
149: ,p_res_del_req_flag IN VARCHAR2 DEFAULT 'Y'
150: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
151: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
152: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 157: ,p_task_id IN pa_tasks.task_id%TYPE

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:
161: FUNCTION get_element_plannable_flag (

Line 164: ,p_task_id IN pa_tasks.task_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:
168: FUNCTION get_plan_amount_exists_flag (

Line 171: ,p_task_id IN pa_tasks.task_id%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:
175: /*=================================================================================

Line 242: ( p_task_id IN pa_tasks.task_id%TYPE

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:
241: PROCEDURE Delete_task_elements
242: ( p_task_id IN pa_tasks.task_id%TYPE
243: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
244: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
245: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
246: