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

Line 120: FROM PA_TASKS

116:
117: -- added for bug#3693197
118: CURSOR get_all_tasks IS
119: SELECT task_id
120: FROM PA_TASKS
121: WHERE project_id = x_project_id;
122:
123: -- added for bug#3693197
124: l_tasks_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 359: -- or task_id in (select task_id from pa_tasks

355: -- Commented out for performance bug 2800018
356: -- Delete labor multipliers
357: -- delete from pa_labor_multipliers
358: -- where (project_id = x_project_id
359: -- or task_id in (select task_id from pa_tasks
360: -- where project_id = x_project_id));
361:
362: -- added for bug#3693197
363: open get_all_tasks ;

Line 373: -- FROM PA_TASKS

369:
370: -- commented for bug#3693197 and replaced with bulk delete
371: -- DELETE FROM PA_LABOR_MULTIPLIERS
372: -- WHERE ( TASK_ID IN (SELECT TASK_ID
373: -- FROM PA_TASKS
374: -- WHERE PROJECT_ID = x_project_id ));
375:
376: if nvl(l_tasks_tbl.last,0) > 0 then
377: forall i in l_tasks_tbl.first..l_tasks_tbl.last

Line 387: -- or task_id in (select task_id from pa_tasks

383: -- Commented out for performance bug 2800074
384: -- Delete job bill rate overrides
385: -- delete from pa_job_bill_rate_overrides
386: -- where (project_id = x_project_id
387: -- or task_id in (select task_id from pa_tasks
388: -- where project_id = x_project_id));
389:
390: DELETE FROM PA_JOB_BILL_RATE_OVERRIDES
391: WHERE PROJECT_ID = x_project_id ;

Line 396: -- FROM PA_TASKS

392:
393: -- commented for bug#3693197 and replaced with bulk delete
394: -- DELETE FROM PA_JOB_BILL_RATE_OVERRIDES
395: -- WHERE ( TASK_ID IN (SELECT TASK_ID
396: -- FROM PA_TASKS
397: -- WHERE PROJECT_ID = x_project_id ));
398:
399: if nvl(l_tasks_tbl.last,0) > 0 then
400: forall i in l_tasks_tbl.first..l_tasks_tbl.last

Line 410: -- or task_id in (select task_id from pa_tasks

406: -- Commented out for performance
407: -- Delete job bill title overrides
408: -- delete from pa_job_bill_title_overrides
409: -- where (project_id = x_project_id
410: -- or task_id in (select task_id from pa_tasks
411: -- where project_id = x_project_id));
412:
413: DELETE FROM pa_job_bill_title_overrides
414: WHERE PROJECT_ID = x_project_id ;

Line 419: -- FROM PA_TASKS

415:
416: -- commented for bug#3693197 and replaced with bulk delete
417: -- DELETE FROM pa_job_bill_title_overrides
418: -- WHERE ( TASK_ID IN (SELECT TASK_ID
419: -- FROM PA_TASKS
420: -- WHERE PROJECT_ID = x_project_id ));
421:
422: if nvl(l_tasks_tbl.last,0) > 0 then
423: forall i in l_tasks_tbl.first..l_tasks_tbl.last

Line 433: -- or task_id in (select task_id from pa_tasks

429: -- Commented out for performance
430: -- Delete job assignment overrides
431: -- delete from pa_job_assignment_overrides
432: -- where (project_id = x_project_id
433: -- or task_id in (select task_id from pa_tasks
434: -- where project_id = x_project_id));
435:
436: DELETE FROM pa_job_assignment_overrides
437: WHERE PROJECT_ID = x_project_id ;

Line 442: -- FROM PA_TASKS

438:
439: -- commented for bug#3693197 and replaced with bulk delete
440: -- DELETE FROM pa_job_assignment_overrides
441: -- WHERE ( TASK_ID IN (SELECT TASK_ID
442: -- FROM PA_TASKS
443: -- WHERE PROJECT_ID = x_project_id ));
444:
445: if nvl(l_tasks_tbl.last,0) > 0 then
446: forall i in l_tasks_tbl.first..l_tasks_tbl.last

Line 456: -- or task_id in (select task_id from pa_tasks

452: -- Commented out for performance
453: -- Delete emp bill rate overrides
454: -- delete from pa_emp_bill_rate_overrides
455: -- where (project_id = x_project_id
456: -- or task_id in (select task_id from pa_tasks
457: -- where project_id = x_project_id));
458:
459: DELETE FROM pa_emp_bill_rate_overrides
460: WHERE PROJECT_ID = x_project_id ;

Line 465: -- FROM PA_TASKS

461:
462: -- commented for bug#3693197 and replaced with bulk delete
463: -- DELETE FROM pa_emp_bill_rate_overrides
464: -- WHERE ( TASK_ID IN (SELECT TASK_ID
465: -- FROM PA_TASKS
466: -- WHERE PROJECT_ID = x_project_id ));
467:
468: if nvl(l_tasks_tbl.last,0) > 0 then
469: forall i in l_tasks_tbl.first..l_tasks_tbl.last

Line 479: -- or task_id in (select task_id from pa_tasks

475: -- Commented out for performance bug 2800083
476: -- Delete non-labor bill rate overrides
477: -- delete from pa_nl_bill_rate_overrides
478: -- where (project_id = x_project_id
479: -- or task_id in (select task_id from pa_tasks
480: -- where project_id = x_project_id));
481:
482: DELETE FROM PA_NL_BILL_RATE_OVERRIDES
483: WHERE PROJECT_ID = x_project_id ;

Line 488: -- FROM PA_TASKS

484:
485: -- commented for bug#3693197 and replaced with bulk delete
486: -- DELETE FROM PA_NL_BILL_RATE_OVERRIDES
487: -- WHERE ( TASK_ID IN (SELECT TASK_ID
488: -- FROM PA_TASKS
489: -- WHERE PROJECT_ID = x_project_id ));
490:
491: if nvl(l_tasks_tbl.last,0) > 0 then
492: forall i in l_tasks_tbl.first..l_tasks_tbl.last

Line 643: from pa_tasks t

639:
640: temp_stack := x_err_stack;
641:
642: for task_rec in (select t.task_id
643: from pa_tasks t
644: where t.project_id = x_project_id
645: and t.task_id = t.top_task_id) loop
646:
647: x_err_stack := NULL;

Line 1366: update pa_tasks

1362:
1363: if (x_parent_task_id is not null) then
1364: x_err_stage := 'update parent task chargeable flag';
1365:
1366: update pa_tasks
1367: set chargeable_flag = 'N'
1368: where task_id = x_parent_task_id;
1369: end if;
1370:

Line 1375: pa_tasks_pkg.insert_row(

1371: -- call table handler to insert task
1372: begin
1373: x_err_stage := 'Insert task for project '|| x_project_id;
1374:
1375: pa_tasks_pkg.insert_row(
1376: x_rowid,
1377: x_task_id,
1378: x_project_id,
1379: x_task_number,

Line 1539: pa_tasks where

1535: l_cc_tax_task_id number; ---- Bug 6629057
1536:
1537: cursor l_project_csr is
1538: select project_id from
1539: pa_tasks where
1540: task_id = x_task_id;
1541:
1542: --Added for bug 3617393
1543: CURSOR get_template_flag(c_project_id IN NUMBER) IS

Line 1626: -- FROM PA_TASKS

1622: -- inside the anonymous block and used bulk approach.
1623: -- In all the below mentioned deletes following select
1624: -- query :
1625: -- SELECT TASK_ID
1626: -- FROM PA_TASKS
1627: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1628: -- START WITH TASK_ID = x_TASK_ID
1629: -- was getting called repeatedly. Instead used the existing
1630: -- cursor task_cur to fetch all the tasks into PLSQL table

Line 1638: -- FROM PA_TASKS

1634: --x_err_stage := 'Delete txn controls for task '|| x_task_id;
1635: --delete from pa_transaction_controls
1636: --where task_id in
1637: --(SELECT TASK_ID
1638: -- FROM PA_TASKS
1639: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1640: -- START WITH TASK_ID = x_TASK_ID)
1641: -- Added to fix Bug # 1190003
1642: --AND project_id = l_project_id;

Line 1651: -- from pa_tasks

1647: -- x_err_stage := 'Delete labor multipliers for task '|| x_task_id;
1648: -- delete from pa_labor_multipliers
1649: -- where task_id in
1650: -- (select task_id
1651: -- from pa_tasks
1652: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1653: -- START WITH TASK_ID = x_TASK_ID);
1654: --
1655: -- -- Delete job bill rate overrides

Line 1660: -- from pa_tasks

1656: -- x_err_stage := 'Delete job bill rate overrides for task '|| x_task_id;
1657: -- delete from pa_job_bill_rate_overrides
1658: -- where task_id in
1659: -- (select task_id
1660: -- from pa_tasks
1661: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1662: -- START WITH TASK_ID = x_TASK_ID);
1663: --
1664: -- -- Delete job bill title overrides

Line 1669: -- from pa_tasks

1665: -- x_err_stage := 'Delete job bill title overrides for task '|| x_task_id;
1666: -- delete from pa_job_bill_rate_overrides
1667: -- where task_id in
1668: -- (select task_id
1669: -- from pa_tasks
1670: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1671: -- START WITH TASK_ID = x_TASK_ID);
1672: --
1673: -- -- Delete job assignment overrides

Line 1678: -- from pa_tasks

1674: -- x_err_stage := 'Delete job assignmt overrides for task '|| x_task_id;
1675: -- delete from pa_job_assignment_overrides
1676: -- where task_id in
1677: -- (select task_id
1678: -- from pa_tasks
1679: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1680: -- START WITH TASK_ID = x_TASK_ID);
1681: --
1682: -- -- Delete emp bill rate overrides

Line 1687: -- from pa_tasks

1683: -- x_err_stage := 'Delete emp bill rate overrides for task '|| x_task_id;
1684: -- delete from pa_emp_bill_rate_overrides
1685: -- where task_id in
1686: -- (select task_id
1687: -- from pa_tasks
1688: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1689: -- START WITH TASK_ID = x_TASK_ID);
1690: --
1691: -- -- Delete non-labor bill rate overrides

Line 1696: -- from pa_tasks

1692: -- x_err_stage := 'Delete nl bill rate overrides for task '|| x_task_id;
1693: -- delete from pa_nl_bill_rate_overrides
1694: -- where task_id in
1695: -- (select task_id
1696: -- from pa_tasks
1697: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1698: -- START WITH TASK_ID = x_TASK_ID);
1699:
1700: -- anlee

Line 1715: -- from pa_tasks

1711: -- rev.ind_rate_sch_revision_id
1712: -- and rev.ind_rate_sch_id = sch.ind_rate_sch_id
1713: -- and sch.task_id in
1714: -- (select task_id
1715: -- from pa_tasks
1716: -- connect by prior task_id = parent_task_id
1717: -- start with task_id = x_task_id));
1718:
1719: -- anlee

Line 1731: -- from pa_tasks

1727: -- pa_ind_rate_schedules sch
1728: -- where rev.ind_rate_sch_id = sch.ind_rate_sch_id
1729: -- and sch.task_id in
1730: -- (select task_id
1731: -- from pa_tasks
1732: -- connect by prior task_id = parent_task_id
1733: -- start with task_id = x_task_id));
1734:
1735: -- anlee

Line 1746: -- from pa_tasks

1742: -- from pa_ind_rate_sch_revisions rev, pa_ind_rate_schedules sch
1743: -- where rev.ind_rate_sch_id = sch.ind_rate_sch_id
1744: -- and sch.task_id in
1745: -- (select task_id
1746: -- from pa_tasks
1747: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1748: -- START WITH TASK_ID = x_TASK_ID));
1749:
1750: -- anlee

Line 1760: -- from pa_tasks

1756: -- (select ind_rate_sch_id
1757: -- from pa_ind_rate_schedules
1758: -- where task_id in
1759: -- (select task_id
1760: -- from pa_tasks
1761: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1762: -- START WITH TASK_ID = x_TASK_ID));
1763:
1764: /*

Line 1768: cursor task_cur ( l_start_task_id pa_tasks.task_id%TYPE )

1764: /*
1765: * Anonymous Block to delete burdening setup starts.
1766: */
1767: declare
1768: cursor task_cur ( l_start_task_id pa_tasks.task_id%TYPE )
1769: is
1770: select task_id
1771: from pa_tasks
1772: connect by prior task_id = parent_task_id

Line 1771: from pa_tasks

1767: declare
1768: cursor task_cur ( l_start_task_id pa_tasks.task_id%TYPE )
1769: is
1770: select task_id
1771: from pa_tasks
1772: connect by prior task_id = parent_task_id
1773: start with task_id = l_start_task_id
1774: ;
1775: cursor sch_cur ( l_task_id IN pa_tasks.task_id%TYPE )

Line 1775: cursor sch_cur ( l_task_id IN pa_tasks.task_id%TYPE )

1771: from pa_tasks
1772: connect by prior task_id = parent_task_id
1773: start with task_id = l_start_task_id
1774: ;
1775: cursor sch_cur ( l_task_id IN pa_tasks.task_id%TYPE )
1776: is
1777: select sch.ind_rate_sch_id
1778: from pa_ind_rate_schedules sch
1779: where sch.task_id = l_task_id

Line 1936: -- from pa_tasks

1932: --x_err_stage := 'Delete proj asset assignmt for task '|| x_task_id;
1933: -- delete from pa_project_asset_assignments
1934: -- where task_id in
1935: -- (select task_id
1936: -- from pa_tasks
1937: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1938: -- START WITH TASK_ID = x_TASK_ID);
1939:
1940: --Retention Changes --Ansari bug 2362168

Line 1973: from pa_tasks

1969: delete from pa_percent_completes
1970: where project_id = l_project_id
1971: and task_id in
1972: (select task_id
1973: from pa_tasks
1974: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1975: START WITH TASK_ID = x_TASK_ID);
1976:
1977: -- hsiu added.

Line 2011: delete from pa_tasks

2007:
2008: --Commented for the Bug 14213218
2009: /* -- Delete task
2010: x_err_stage := 'Delete any task in the subtree of task '|| x_task_id;
2011: delete from pa_tasks
2012: where task_id in
2013: (select task_id
2014: from pa_tasks
2015: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID

Line 2014: from pa_tasks

2010: x_err_stage := 'Delete any task in the subtree of task '|| x_task_id;
2011: delete from pa_tasks
2012: where task_id in
2013: (select task_id
2014: from pa_tasks
2015: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
2016: START WITH TASK_ID = x_TASK_ID); */
2017: --Bug 14213218 End
2018:

Line 2037: update pa_tasks

2033: if ( status_code = 1 ) then
2034: -- set parent task's chargeable_flag to 'Y
2035: x_err_stage := 'update parent task chargeable flag';
2036:
2037: update pa_tasks
2038: set chargeable_flag = 'Y'
2039: where task_id = x_parent_task_id;
2040:
2041: elsif ( status_code < 0 ) then

Line 2054: cursor alt_task_cur ( l_task_id pa_tasks.task_id%TYPE )

2050: */
2051: /*
2052: Declare
2053: l_alt_task_Ids SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE();
2054: cursor alt_task_cur ( l_task_id pa_tasks.task_id%TYPE )
2055: is
2056: select alt_task_id from pa_alternate_tasks
2057: where proj_element_id in
2058: (select task_id

Line 2059: from pa_tasks

2055: is
2056: select alt_task_id from pa_alternate_tasks
2057: where proj_element_id in
2058: (select task_id
2059: from pa_tasks
2060: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
2061: START WITH TASK_ID = l_task_id)
2062: ;
2063: Begin

Line 2089: delete from pa_tasks

2085:
2086: --Bug 14213218: Deleting the task after updating the parent task chargeable flag to 'Y'
2087: -- Delete task
2088: x_err_stage := 'Delete any task in the subtree of task '|| x_task_id;
2089: delete from pa_tasks
2090: where task_id in
2091: (select task_id
2092: from pa_tasks
2093: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID

Line 2092: from pa_tasks

2088: x_err_stage := 'Delete any task in the subtree of task '|| x_task_id;
2089: delete from pa_tasks
2090: where task_id in
2091: (select task_id
2092: from pa_tasks
2093: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
2094: START WITH TASK_ID = x_TASK_ID);
2095:
2096: --Bug 14213218 End