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

Line 19: from pa_tasks

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

Line 118: -- 2. Removed join to PA_TASKS in cursor c3

114: -- 09-FEB-99 Ri.Singh Modified.
115: -- 1. Removed comments in cursor c2
116: -- done during bugfix 773604. CONNECT BY
117: -- clause is required for task deletion
118: -- 2. Removed join to PA_TASKS in cursor c3
119: -- as task_id is a not null column in
120: -- pa_expenditures_all
121: -- 3. Added reference to pa_ei_denorm for
122: -- checking if expenditures exist

Line 152: FROM PA_TASKS

148: where exists (SELECT NULL
149: FROM PA_EXPENDITURE_ITEMS_all
150: WHERE TASK_ID IN
151: (SELECT TASK_ID
152: FROM PA_TASKS
153: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
154: START WITH TASK_ID = x_TASK_ID))
155: or exists (SELECT NULL
156: FROM PA_EI_DENORM

Line 159: FROM PA_TASKS

155: or exists (SELECT NULL
156: FROM PA_EI_DENORM
157: WHERE TASK_ID IN
158: (SELECT TASK_ID
159: FROM PA_TASKS
160: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
161: START WITH TASK_ID = x_TASK_ID));
162: cursor c3 is
163: SELECT 1

Line 179: FROM PA_TASKS

175: where exists (SELECT NULL
176: FROM PA_EXPENDITURE_ITEMS_all
177: WHERE TASK_ID IN
178: (SELECT TASK_ID
179: FROM PA_TASKS
180: WHERE TASK_ID = x_TASK_ID));
181:
182: cursor c3 is
183: SELECT 1

Line 189: FROM PA_TASKS

185: where exists (SELECT NULL
186: FROM PA_EXPENDITURE_ITEMS_all
187: WHERE TASK_ID IN
188: (SELECT TASK_ID
189: FROM PA_TASKS
190: WHERE TASK_ID = x_TASK_ID));
191: */
192: c1_rec c1%rowtype;
193: c2_rec c2%rowtype;

Line 283: FROM PA_TASKS

279: where project_id = x_proj_id
280: AND nvl(encumbered_flag,'N') = 'Y' -- Bug 6153950: added encumbered_flag
281: AND 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: /* cursor c2 is

Line 295: FROM PA_TASKS

291: FROM po_distributions_all
292: where project_id = x_proj_id
293: AND TASK_ID IN
294: (SELECT TASK_ID
295: FROM PA_TASKS
296: WHERE TASK_ID = x_TASK_ID));
297: */
298: c1_rec c1%rowtype;
299: c2_rec c2%rowtype;

Line 407: FROM PA_TASKS

403: where project_id = x_proj_id
404: AND nvl(encumbered_flag,'N') = 'Y' -- Bug 6153950: added encumbered_flag
405: AND TASK_ID IN
406: (SELECT TASK_ID
407: FROM PA_TASKS
408: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
409: START WITH TASK_ID = x_TASK_ID));
410:
411: /* cursor c2 is

Line 419: FROM PA_TASKS

415: FROM po_req_distributions_all
416: where project_id = x_proj_id
417: AND TASK_ID IN
418: (SELECT TASK_ID
419: FROM PA_TASKS
420: WHERE TASK_ID = x_TASK_ID));
421: */
422: c1_rec c1%rowtype;
423: c2_rec c2%rowtype;

Line 528: FROM PA_TASKS

524: FROM ap_invoices_all
525: where project_id = x_proj_id
526: AND TASK_ID IN
527: (SELECT TASK_ID
528: FROM PA_TASKS
529: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
530: START WITH TASK_ID = x_TASK_ID));
531:
532: /* cursor c2 is

Line 540: FROM PA_TASKS

536: FROM ap_invoices_all
537: where project_id = x_proj_id
538: AND TASK_ID IN
539: (SELECT TASK_ID
540: FROM PA_TASKS
541: WHERE TASK_ID = x_TASK_ID));
542: */
543: c1_rec c1%rowtype;
544: c2_rec c2%rowtype;

Line 653: FROM PA_TASKS

649: where project_id = x_proj_id
650: AND nvl(encumbered_flag,'N') = 'Y' -- Bug 6153950: added encumbered_flag
651: AND TASK_ID IN
652: (SELECT TASK_ID
653: FROM PA_TASKS
654: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
655: START WITH TASK_ID = x_TASK_ID));
656:
657: /* cursor c2 is

Line 665: FROM PA_TASKS

661: FROM ap_invoice_distributions_all
662: where project_id = x_proj_id
663: AND TASK_ID IN
664: (SELECT TASK_ID
665: FROM PA_TASKS
666: WHERE TASK_ID = x_TASK_ID));
667: */
668: c1_rec c1%rowtype;
669: c2_rec c2%rowtype;

Line 1085: FROM PA_TASKS

1081: FROM pa_draft_invoice_items
1082: where project_id = x_proj_id
1083: AND TASK_ID IN
1084: (SELECT TASK_ID
1085: FROM PA_TASKS
1086: CONNECT BY PRIOR PARENT_TASK_ID = TASK_ID /* Bug 6511941 */
1087: START WITH TASK_ID = x_TASK_ID));
1088:
1089: /* cursor c2 is

Line 1097: FROM PA_TASKS

1093: FROM pa_draft_invoice_items
1094: where project_id = x_proj_id
1095: AND TASK_ID IN
1096: (SELECT TASK_ID
1097: FROM PA_TASKS
1098: WHERE TASK_ID = x_TASK_ID));
1099: */
1100: c1_rec c1%rowtype;
1101: c2_rec c2%rowtype;

Line 1188: FROM PA_TASKS

1184: where exists (SELECT NULL
1185: FROM pa_draft_invoice_details_all
1186: where CC_TAX_TASK_ID IN
1187: (SELECT TASK_ID
1188: FROM PA_TASKS
1189: CONNECT BY PRIOR PARENT_TASK_ID = TASK_ID /* Bug 6511941 */
1190: START WITH TASK_ID = x_TASK_ID));
1191:
1192: c1_rec c1%rowtype;

Line 1259: FROM PA_TASKS

1255: where exists (SELECT NULL
1256: FROM pa_project_customers
1257: where receiver_task_id IN
1258: (SELECT TASK_ID
1259: FROM PA_TASKS
1260: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1261: START WITH TASK_ID = X_TASK_ID));
1262:
1263: c1_rec c1%rowtype;

Line 1330: where project_id = (select project_id from pa_tasks where task_id=X_TASK_ID)

1326: SELECT 1
1327: FROM sys.dual
1328: where exists (SELECT NULL
1329: FROM pa_projects_all -- Modified pa_projects to pa_projects_all for bug#3512486
1330: where project_id = (select project_id from pa_tasks where task_id=X_TASK_ID)
1331: and CC_TAX_TASK_ID IN
1332: (SELECT TASK_ID
1333: FROM PA_TASKS
1334: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID

Line 1333: FROM PA_TASKS

1329: FROM pa_projects_all -- Modified pa_projects to pa_projects_all for bug#3512486
1330: where project_id = (select project_id from pa_tasks where task_id=X_TASK_ID)
1331: and CC_TAX_TASK_ID IN
1332: (SELECT TASK_ID
1333: FROM PA_TASKS
1334: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1335: START WITH TASK_ID = X_TASK_ID));
1336:
1337: c1_rec c1%rowtype;

Line 1425: FROM PA_TASKS

1421: FROM pa_draft_revenue_items
1422: where project_id = x_proj_id
1423: AND TASK_ID IN
1424: (SELECT TASK_ID
1425: FROM PA_TASKS
1426: CONNECT BY PRIOR PARENT_TASK_ID = TASK_ID /* Bug 6511941 */
1427: START WITH TASK_ID = x_TASK_ID));
1428:
1429: /* cursor c2 is

Line 1437: FROM PA_TASKS

1433: FROM pa_draft_revenue_items
1434: where project_id = x_proj_id
1435: AND TASK_ID IN
1436: (SELECT TASK_ID
1437: FROM PA_TASKS
1438: WHERE TASK_ID = x_TASK_ID));
1439: */
1440:
1441: c1_rec c1%rowtype;

Line 1547: FROM PA_TASKS

1543: FROM pa_commitment_txns
1544: where project_id = x_proj_id
1545: AND TASK_ID IN
1546: (SELECT TASK_ID
1547: FROM PA_TASKS
1548: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1549: START WITH TASK_ID = x_TASK_ID));
1550:
1551:

Line 1560: FROM PA_TASKS

1556: FROM pa_commitment_txns
1557: where project_id = x_proj_id
1558: AND TASK_ID IN
1559: (SELECT TASK_ID
1560: FROM PA_TASKS
1561: WHERE TASK_ID = x_TASK_ID));
1562: */
1563: c1_rec c1%rowtype;
1564: c2_rec c2%rowtype;

Line 1675: FROM PA_TASKS

1671: FROM pa_comp_rule_ot_defaults_all -- Bug 4680097: pa_compensation_rule_sets
1672: where project_id = x_proj_id
1673: AND TASK_ID IN
1674: (SELECT TASK_ID
1675: FROM PA_TASKS
1676: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1677: START WITH TASK_ID = x_TASK_ID))
1678: UNION
1679: SELECT 1

Line 1686: FROM PA_TASKS

1682: FROM pa_org_labor_sch_rule
1683: where overtime_project_id = x_proj_id
1684: AND overtime_TASK_ID IN
1685: (SELECT TASK_ID
1686: FROM PA_TASKS
1687: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1688: START WITH TASK_ID = x_TASK_ID));
1689:
1690: /* cursor c2 is

Line 1698: FROM PA_TASKS

1694: FROM pa_compensation_rule_sets
1695: where project_id = x_proj_id
1696: AND TASK_ID IN
1697: (SELECT TASK_ID
1698: FROM PA_TASKS
1699: WHERE TASK_ID = x_TASK_ID));
1700: */
1701: c1_rec c1%rowtype;
1702: c2_rec c2%rowtype;

Line 1811: select 1 from pa_tasks

1807: WHERE project_id = x_project_id);
1808:
1809: /*Added for bug 6063643*/
1810: Cursor c2 is
1811: select 1 from pa_tasks
1812: where task_id = x_task_id
1813: and wbs_level > 1
1814: and exists (select null from pa_project_asset_assignments
1815: where task_id = x_task_id

Line 1828: FROM PA_TASKS

1824: FROM pa_project_asset_assignments
1825: where project_id = x_proj_id
1826: AND TASK_ID IN
1827: (SELECT TASK_ID
1828: FROM PA_TASKS
1829: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1830: START WITH TASK_ID = x_TASK_ID));
1831:
1832: commented for bug6063643*/

Line 1842: FROM PA_TASKS

1838: FROM pa_project_asset_assignments
1839: where project_id = x_proj_id
1840: AND TASK_ID IN
1841: (SELECT TASK_ID
1842: FROM PA_TASKS
1843: WHERE TASK_ID = x_TASK_ID));
1844: */
1845: c1_rec c1%rowtype;
1846: c2_rec c2%rowtype;

Line 2498: from pa_tasks

2494:
2495: /* fetch task creation_date into l_task_cdate */
2496: /* start of bug 4060239 */
2497: select trunc(creation_date) into l_task_cdate
2498: from pa_tasks
2499: where task_id = x_task_id;
2500:
2501: /* Commented and modfied for Bug#5839405
2502: SELECT 1