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 1352: update pa_tasks

1348:
1349: if (x_parent_task_id is not null) then
1350: x_err_stage := 'update parent task chargeable flag';
1351:
1352: update pa_tasks
1353: set chargeable_flag = 'N'
1354: where task_id = x_parent_task_id;
1355: end if;
1356:

Line 1361: pa_tasks_pkg.insert_row(

1357: -- call table handler to insert task
1358: begin
1359: x_err_stage := 'Insert task for project '|| x_project_id;
1360:
1361: pa_tasks_pkg.insert_row(
1362: x_rowid,
1363: x_task_id,
1364: x_project_id,
1365: x_task_number,

Line 1523: pa_tasks where

1519: l_cc_tax_task_id number; ---- Bug 6629057
1520:
1521: cursor l_project_csr is
1522: select project_id from
1523: pa_tasks where
1524: task_id = x_task_id;
1525:
1526: --Added for bug 3617393
1527: CURSOR get_template_flag(c_project_id IN NUMBER) IS

Line 1610: -- FROM PA_TASKS

1606: -- inside the anonymous block and used bulk approach.
1607: -- In all the below mentioned deletes following select
1608: -- query :
1609: -- SELECT TASK_ID
1610: -- FROM PA_TASKS
1611: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1612: -- START WITH TASK_ID = x_TASK_ID
1613: -- was getting called repeatedly. Instead used the existing
1614: -- cursor task_cur to fetch all the tasks into PLSQL table

Line 1622: -- FROM PA_TASKS

1618: --x_err_stage := 'Delete txn controls for task '|| x_task_id;
1619: --delete from pa_transaction_controls
1620: --where task_id in
1621: --(SELECT TASK_ID
1622: -- FROM PA_TASKS
1623: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1624: -- START WITH TASK_ID = x_TASK_ID)
1625: -- Added to fix Bug # 1190003
1626: --AND project_id = l_project_id;

Line 1635: -- from pa_tasks

1631: -- x_err_stage := 'Delete labor multipliers for task '|| x_task_id;
1632: -- delete from pa_labor_multipliers
1633: -- where task_id in
1634: -- (select task_id
1635: -- from pa_tasks
1636: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1637: -- START WITH TASK_ID = x_TASK_ID);
1638: --
1639: -- -- Delete job bill rate overrides

Line 1644: -- from pa_tasks

1640: -- x_err_stage := 'Delete job bill rate overrides for task '|| x_task_id;
1641: -- delete from pa_job_bill_rate_overrides
1642: -- where task_id in
1643: -- (select task_id
1644: -- from pa_tasks
1645: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1646: -- START WITH TASK_ID = x_TASK_ID);
1647: --
1648: -- -- Delete job bill title overrides

Line 1653: -- from pa_tasks

1649: -- x_err_stage := 'Delete job bill title overrides for task '|| x_task_id;
1650: -- delete from pa_job_bill_rate_overrides
1651: -- where task_id in
1652: -- (select task_id
1653: -- from pa_tasks
1654: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1655: -- START WITH TASK_ID = x_TASK_ID);
1656: --
1657: -- -- Delete job assignment overrides

Line 1662: -- from pa_tasks

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

Line 1671: -- from pa_tasks

1667: -- x_err_stage := 'Delete emp bill rate overrides for task '|| x_task_id;
1668: -- delete from pa_emp_bill_rate_overrides
1669: -- where task_id in
1670: -- (select task_id
1671: -- from pa_tasks
1672: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1673: -- START WITH TASK_ID = x_TASK_ID);
1674: --
1675: -- -- Delete non-labor bill rate overrides

Line 1680: -- from pa_tasks

1676: -- x_err_stage := 'Delete nl bill rate overrides for task '|| x_task_id;
1677: -- delete from pa_nl_bill_rate_overrides
1678: -- where task_id in
1679: -- (select task_id
1680: -- from pa_tasks
1681: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1682: -- START WITH TASK_ID = x_TASK_ID);
1683:
1684: -- anlee

Line 1699: -- from pa_tasks

1695: -- rev.ind_rate_sch_revision_id
1696: -- and rev.ind_rate_sch_id = sch.ind_rate_sch_id
1697: -- and sch.task_id in
1698: -- (select task_id
1699: -- from pa_tasks
1700: -- connect by prior task_id = parent_task_id
1701: -- start with task_id = x_task_id));
1702:
1703: -- anlee

Line 1715: -- from pa_tasks

1711: -- pa_ind_rate_schedules sch
1712: -- where 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 1730: -- from pa_tasks

1726: -- from pa_ind_rate_sch_revisions rev, pa_ind_rate_schedules sch
1727: -- where rev.ind_rate_sch_id = sch.ind_rate_sch_id
1728: -- and sch.task_id in
1729: -- (select task_id
1730: -- from pa_tasks
1731: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1732: -- START WITH TASK_ID = x_TASK_ID));
1733:
1734: -- anlee

Line 1744: -- from pa_tasks

1740: -- (select ind_rate_sch_id
1741: -- from pa_ind_rate_schedules
1742: -- where task_id in
1743: -- (select task_id
1744: -- from pa_tasks
1745: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1746: -- START WITH TASK_ID = x_TASK_ID));
1747:
1748: /*

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

1748: /*
1749: * Anonymous Block to delete burdening setup starts.
1750: */
1751: declare
1752: cursor task_cur ( l_start_task_id pa_tasks.task_id%TYPE )
1753: is
1754: select task_id
1755: from pa_tasks
1756: connect by prior task_id = parent_task_id

Line 1755: from pa_tasks

1751: declare
1752: cursor task_cur ( l_start_task_id pa_tasks.task_id%TYPE )
1753: is
1754: select task_id
1755: from pa_tasks
1756: connect by prior task_id = parent_task_id
1757: start with task_id = l_start_task_id
1758: ;
1759: cursor sch_cur ( l_task_id IN pa_tasks.task_id%TYPE )

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

1755: from pa_tasks
1756: connect by prior task_id = parent_task_id
1757: start with task_id = l_start_task_id
1758: ;
1759: cursor sch_cur ( l_task_id IN pa_tasks.task_id%TYPE )
1760: is
1761: select sch.ind_rate_sch_id
1762: from pa_ind_rate_schedules sch
1763: where sch.task_id = l_task_id

Line 1920: -- from pa_tasks

1916: --x_err_stage := 'Delete proj asset assignmt for task '|| x_task_id;
1917: -- delete from pa_project_asset_assignments
1918: -- where task_id in
1919: -- (select task_id
1920: -- from pa_tasks
1921: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1922: -- START WITH TASK_ID = x_TASK_ID);
1923:
1924: --Retention Changes --Ansari bug 2362168

Line 1957: from pa_tasks

1953: delete from pa_percent_completes
1954: where project_id = l_project_id
1955: and 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: -- hsiu added.

Line 1994: delete from pa_tasks

1990: -- end delete project structure relationship
1991:
1992: -- Delete task
1993: x_err_stage := 'Delete any task in the subtree of task '|| x_task_id;
1994: delete from pa_tasks
1995: where task_id in
1996: (select task_id
1997: from pa_tasks
1998: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID

Line 1997: from pa_tasks

1993: x_err_stage := 'Delete any task in the subtree of task '|| x_task_id;
1994: delete from pa_tasks
1995: where task_id in
1996: (select task_id
1997: from pa_tasks
1998: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1999: START WITH TASK_ID = x_TASK_ID);
2000:
2001: -- get parent task id

Line 2019: update pa_tasks

2015: if ( status_code = 1 ) then
2016: -- set parent task's chargeable_flag to 'Y
2017: x_err_stage := 'update parent task chargeable flag';
2018:
2019: update pa_tasks
2020: set chargeable_flag = 'Y'
2021: where task_id = x_parent_task_id;
2022:
2023: elsif ( status_code < 0 ) then