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 318: select task_id from pa_tasks

314: , x_task_number IN varchar2
315: , x_rowid IN varchar2 ) return number
316: is
317: cursor c1 is
318: select task_id from pa_tasks
319: where project_id = x_project_id
320: and task_number = substrb(x_task_number,1,25) -- bug 5733285 added substrb
321: and (x_ROWID IS NULL OR x_rowid <> PA_TASKS.ROWID);
322:

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

317: cursor c1 is
318: select task_id from pa_tasks
319: where project_id = x_project_id
320: and task_number = substrb(x_task_number,1,25) -- bug 5733285 added substrb
321: and (x_ROWID IS NULL OR x_rowid <> PA_TASKS.ROWID);
322:
323: c1_rec c1%rowtype;
324:
325: begin

Line 366: FROM PA_TASKS

362: cursor c1 is
363: select 1
364: from sys.dual
365: where exists (SELECT null
366: FROM PA_TASKS
367: WHERE PROJECT_ID = x_project_id
368: and task_id <> x_task_id
369: and task_id = top_task_id);
370:

Line 418: FROM PA_TASKS

414: cursor c1 is
415: select 1
416: from sys.dual
417: where exists (SELECT null
418: FROM PA_TASKS
419: WHERE TASK_ID <> x_TASK_ID
420: AND PARENT_TASK_ID = x_PARENT_TASK_ID);
421:
422: c1_rec c1%rowtype;

Line 469: FROM PA_TASKS

465: where exists (SELECT null
466: FROM pa_percent_completes
467: where TASK_ID IN
468: (SELECT TASK_ID
469: FROM PA_TASKS
470: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
471: START WITH TASK_ID = x_TASK_ID));
472:
473: c1_rec c1%rowtype;

Line 512: from pa_tasks

508: (x_task_id IN number ) return number
509: is
510: cursor c1 is
511: select LABOR_COST_MULTIPLIER_NAME
512: from pa_tasks
513: where task_id = x_task_id
514: and LABOR_COST_MULTIPLIER_NAME is not null;
515:
516: c1_rec c1%rowtype;

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

579: cursor p1 is select 1 from pa_project_types_all
580: where burden_sum_dest_task_id = x_task_id
581: and org_id = (SELECT org_id --MOAC Changes: Bug 4363092: removed nvl usage with org_id
582: FROM pa_projects_all
583: where project_id = (select project_id from pa_tasks where task_id=x_task_id));
584:
585: temp number;
586: l_return_val varchar2(1);
587:

Line 1583: from pa_tasks

1579:
1580: cursor c4
1581: is
1582: select last_update_date,last_updated_by,last_update_login,carrying_out_organization_id
1583: from pa_tasks
1584: where task_id = p_task_id
1585: and project_id = p_project_id;
1586:
1587: BEGIN

Line 1924: FROM PA_TASKS

1920: where exists (SELECT NULL
1921: FROM pa_fp_elements r
1922: where r.TASK_ID IN
1923: (SELECT TASK_ID
1924: FROM PA_TASKS
1925: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1926: START WITH TASK_ID = x_task_id));
1927:
1928: c1_rec c1%rowtype;

Line 1957: FROM PA_TASKS

1953: where exists (SELECT NULL
1954: FROM pa_resource_assignments r
1955: where r.TASK_ID IN
1956: (SELECT TASK_ID
1957: FROM PA_TASKS
1958: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1959: START WITH TASK_ID = x_task_id));
1960:
1961: c1_rec c1%rowtype;

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

2281: x_err_stage := 'PA_PROJ_STRUC_MAPPING_UTILS.Check_Task_Has_Mapping'||x_task_id;
2282:
2283: -- Get project id
2284: x_err_stage := 'get project id of '|| x_task_id;
2285: --Bug 3617393 : Retrieve project id from pa_proj_elements rather than pa_tasks since
2286: --the data has already been deleted from pa_tasks in delete_project flow
2287: /*x_project_id :=
2288: pa_proj_tsk_utils.get_task_project_id(x_task_id);*/
2289: OPEN get_task_project_id(x_task_id);

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

2282:
2283: -- Get project id
2284: x_err_stage := 'get project id of '|| x_task_id;
2285: --Bug 3617393 : Retrieve project id from pa_proj_elements rather than pa_tasks since
2286: --the data has already been deleted from pa_tasks in delete_project flow
2287: /*x_project_id :=
2288: pa_proj_tsk_utils.get_task_project_id(x_task_id);*/
2289: OPEN get_task_project_id(x_task_id);
2290: FETCH get_task_project_id INTO x_project_id;

Line 2387: from pa_tasks

2383: is
2384:
2385: cursor c1 (inid number) is
2386: select task_number parent_task_number
2387: from pa_tasks
2388: connect by prior parent_task_id = task_id
2389: start with task_id = c1.inid;
2390:
2391: rv varchar2(2000) := x_sort_order_col;

Line 2430: FROM pa_tasks

2426: cursor c1 is
2427: select 1
2428: from sys.dual
2429: where exists (SELECT null
2430: FROM pa_tasks
2431: where parent_task_id = x_task_id);
2432:
2433: c1_rec c1%rowtype;
2434: