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_TASK_UTILS dependencies on PA_TASKS

Line 19: from pa_tasks

15: function get_wbs_level (x_task_id IN number) return number
16: is
17: cursor c1 is
18: select wbs_level
19: from pa_tasks
20: where task_id = x_task_id;
21:
22: c1_rec c1%rowtype;
23:

Line 56: from pa_tasks

52: function get_top_task_id (x_task_id IN number) return number
53: is
54: cursor c1 is
55: select top_task_id
56: from pa_tasks
57: where task_id = x_task_id;
58:
59: c1_rec c1%rowtype;
60:

Line 94: from pa_tasks

90: function get_parent_task_id (x_task_id IN number) return number
91: is
92: cursor c1 is
93: select parent_task_id
94: from pa_tasks
95: where task_id = x_task_id;
96:
97: c1_rec c1%rowtype;
98:

Line 132: select task_id from pa_tasks

128: , x_task_number IN varchar2
129: , x_rowid IN varchar2 ) return number
130: is
131: cursor c1 is
132: select task_id from pa_tasks
133: where project_id = x_project_id
134: and task_number = substrb(x_task_number,1,25) -- bug 5733285 added substrb
135: and (x_ROWID IS NULL OR x_rowid <> PA_TASKS.ROWID);
136:

Line 135: and (x_ROWID IS NULL OR x_rowid <> PA_TASKS.ROWID);

131: cursor c1 is
132: select task_id from pa_tasks
133: where project_id = x_project_id
134: and task_number = substrb(x_task_number,1,25) -- bug 5733285 added substrb
135: and (x_ROWID IS NULL OR x_rowid <> PA_TASKS.ROWID);
136:
137: c1_rec c1%rowtype;
138:
139: begin

Line 180: FROM PA_TASKS

176: cursor c1 is
177: select 1
178: from sys.dual
179: where exists (SELECT null
180: FROM PA_TASKS
181: WHERE PROJECT_ID = x_project_id
182: and task_id <> x_task_id
183: and task_id = top_task_id);
184:

Line 232: FROM PA_TASKS

228: cursor c1 is
229: select 1
230: from sys.dual
231: where exists (SELECT null
232: FROM PA_TASKS
233: WHERE TASK_ID <> x_TASK_ID
234: AND PARENT_TASK_ID = x_PARENT_TASK_ID);
235:
236: c1_rec c1%rowtype;

Line 283: FROM PA_TASKS

279: where exists (SELECT null
280: FROM pa_percent_completes
281: where TASK_ID IN
282: (SELECT TASK_ID
283: FROM PA_TASKS
284: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
285: START WITH TASK_ID = x_TASK_ID));
286:
287: c1_rec c1%rowtype;

Line 326: from pa_tasks

322: (x_task_id IN number ) return number
323: is
324: cursor c1 is
325: select LABOR_COST_MULTIPLIER_NAME
326: from pa_tasks
327: where task_id = x_task_id
328: and LABOR_COST_MULTIPLIER_NAME is not null;
329:
330: c1_rec c1%rowtype;

Line 397: where project_id = (select project_id from pa_tasks where task_id=x_task_id));

393: cursor p1 is select 1 from pa_project_types_all
394: where burden_sum_dest_task_id = x_task_id
395: and org_id = (SELECT org_id --MOAC Changes: Bug 4363092: removed nvl usage with org_id
396: FROM pa_projects_all
397: where project_id = (select project_id from pa_tasks where task_id=x_task_id));
398:
399: temp number;
400: l_return_val varchar2(1);
401:

Line 1371: from pa_tasks

1367:
1368: cursor c4
1369: is
1370: select last_update_date,last_updated_by,last_update_login,carrying_out_organization_id
1371: from pa_tasks
1372: where task_id = p_task_id
1373: and project_id = p_project_id;
1374:
1375: BEGIN

Line 1712: FROM PA_TASKS

1708: where exists (SELECT NULL
1709: FROM pa_fp_elements r
1710: where r.TASK_ID IN
1711: (SELECT TASK_ID
1712: FROM PA_TASKS
1713: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1714: START WITH TASK_ID = x_task_id));
1715:
1716: c1_rec c1%rowtype;

Line 1745: FROM PA_TASKS

1741: where exists (SELECT NULL
1742: FROM pa_resource_assignments r
1743: where r.TASK_ID IN
1744: (SELECT TASK_ID
1745: FROM PA_TASKS
1746: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1747: START WITH TASK_ID = x_task_id));
1748:
1749: c1_rec c1%rowtype;

Line 2073: --Bug 3617393 : Retrieve project id from pa_proj_elements rather than pa_tasks since

2069: x_err_stage := 'PA_PROJ_STRUC_MAPPING_UTILS.Check_Task_Has_Mapping'||x_task_id;
2070:
2071: -- Get project id
2072: x_err_stage := 'get project id of '|| x_task_id;
2073: --Bug 3617393 : Retrieve project id from pa_proj_elements rather than pa_tasks since
2074: --the data has already been deleted from pa_tasks in delete_project flow
2075: /*x_project_id :=
2076: pa_proj_tsk_utils.get_task_project_id(x_task_id);*/
2077: OPEN get_task_project_id(x_task_id);

Line 2074: --the data has already been deleted from pa_tasks in delete_project flow

2070:
2071: -- Get project id
2072: x_err_stage := 'get project id of '|| x_task_id;
2073: --Bug 3617393 : Retrieve project id from pa_proj_elements rather than pa_tasks since
2074: --the data has already been deleted from pa_tasks in delete_project flow
2075: /*x_project_id :=
2076: pa_proj_tsk_utils.get_task_project_id(x_task_id);*/
2077: OPEN get_task_project_id(x_task_id);
2078: FETCH get_task_project_id INTO x_project_id;

Line 2175: from pa_tasks

2171: is
2172:
2173: cursor c1 (inid number) is
2174: select task_number parent_task_number
2175: from pa_tasks
2176: connect by prior parent_task_id = task_id
2177: start with task_id = c1.inid;
2178:
2179: rv varchar2(2000) := x_sort_order_col;

Line 2218: FROM pa_tasks

2214: cursor c1 is
2215: select 1
2216: from sys.dual
2217: where exists (SELECT null
2218: FROM pa_tasks
2219: where parent_task_id = x_task_id);
2220:
2221: c1_rec c1%rowtype;
2222: