APPS.PA_BUDGETARY_CONTROLS_PKG dependencies on PA_TASKS

Line 7: ,x_top_task_id IN PA_TASKS.TASK_ID%type

3: PROCEDURE insert_rows
4: (x_project_id IN PA_PROJECTS_ALL.PROJECT_ID%type
5: ,x_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type
6: ,x_funds_control_level_code IN PA_BUDGETARY_CONTROLS.FUNDS_CONTROL_LEVEL_CODE%type
7: ,x_top_task_id IN PA_TASKS.TASK_ID%type
8: ,x_task_id IN PA_TASKS.TASK_ID%type
9: ,x_parent_member_id IN PA_RESOURCE_LIST_MEMBERS.PARENT_MEMBER_ID%type
10: ,x_resource_list_member_id IN PA_RESOURCE_LIST_MEMBERS.resource_list_member_id%type
11: ,x_return_status OUT NOCOPY VARCHAR2

Line 8: ,x_task_id IN PA_TASKS.TASK_ID%type

4: (x_project_id IN PA_PROJECTS_ALL.PROJECT_ID%type
5: ,x_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type
6: ,x_funds_control_level_code IN PA_BUDGETARY_CONTROLS.FUNDS_CONTROL_LEVEL_CODE%type
7: ,x_top_task_id IN PA_TASKS.TASK_ID%type
8: ,x_task_id IN PA_TASKS.TASK_ID%type
9: ,x_parent_member_id IN PA_RESOURCE_LIST_MEMBERS.PARENT_MEMBER_ID%type
10: ,x_resource_list_member_id IN PA_RESOURCE_LIST_MEMBERS.resource_list_member_id%type
11: ,x_return_status OUT NOCOPY VARCHAR2
12: ,x_msg_count OUT NOCOPY NUMBER

Line 123: FROM pa_tasks pt2

119:
120: DELETE from pa_budgetary_controls bc
121: WHERE EXISTS
122: ( SELECT pt2.task_id
123: FROM pa_tasks pt2
124: WHERE bc.task_id=pt2.parent_task_id
125: AND ((p_entry_level_code = 'L') OR
126: (p_entry_level_code = 'M' AND exists (select 1 from pa_tasks pt1
127: where bc.task_id = pt1.task_id

Line 126: (p_entry_level_code = 'M' AND exists (select 1 from pa_tasks pt1

122: ( SELECT pt2.task_id
123: FROM pa_tasks pt2
124: WHERE bc.task_id=pt2.parent_task_id
125: AND ((p_entry_level_code = 'L') OR
126: (p_entry_level_code = 'M' AND exists (select 1 from pa_tasks pt1
127: where bc.task_id = pt1.task_id
128: and pt1.parent_task_id IS NOT NULL))))
129: AND bc.project_id = p_project_id
130: AND bc.budget_type_code = p_budget_type_code;

Line 175: FROM pa_tasks pt1

171: cursor c_tasks_no_bc is
172: SELECT
173: pt1.task_id,
174: pt1.top_task_id
175: FROM pa_tasks pt1
176: WHERE pt1.project_id = x_project_id
177: AND
178: ( (x_entry_level_code IN ( 'T' ,'M') AND pt1.parent_task_id is null )
179: OR

Line 184: FROM pa_tasks pt2

180: (x_entry_level_code IN ('L','M')
181: AND NOT EXISTS
182: ( SELECT
183: pt2.task_id
184: FROM pa_tasks pt2
185: WHERE pt1.task_id=pt2.parent_task_id)
186: )
187: )
188: AND not exists

Line 238: FROM pa_tasks pt1

234: cursor c_tasks_for_new_resource is
235: SELECT
236: pt1.task_id,
237: pt1.top_task_id
238: FROM pa_tasks pt1
239: WHERE pt1.project_id = x_project_id
240: AND
241: ( (x_entry_level_code IN ( 'T' ,'M') AND pt1.parent_task_id is null )
242: OR

Line 247: FROM pa_tasks pt2

243: (x_entry_level_code IN ('L','M')
244: AND NOT EXISTS
245: ( SELECT
246: pt2.task_id
247: FROM pa_tasks pt2
248: WHERE pt1.task_id=pt2.parent_task_id)
249: )
250: )
251: AND exists