[Home] [Help]
360: x_project_id number;
361:
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
412: x_parent_task_id number;
413:
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);
460: is
461:
462: cursor c1 is
463: select 1
464: from sys.dual
465: where exists (SELECT null
466: FROM pa_percent_completes
467: where TASK_ID IN
468: (SELECT TASK_ID
1311:
1312: CURSOR Cdl_Cur IS
1313: SELECT NULL
1314: FROM
1315: SYS.DUAL
1316: WHERE EXISTS
1317: (SELECT NULL
1318: FROM
1319: pa_expenditure_items_all paei,
1324:
1325: CURSOR Rdl_Cur IS
1326: SELECT NULL
1327: FROM
1328: SYS.DUAL
1329: WHERE EXISTS
1330: (SELECT NULL
1331: FROM
1332: pa_expenditure_items_all paei,
1337:
1338: CURSOR Draft_Inv_Cur IS
1339: SELECT NULL
1340: FROM
1341: SYS.DUAL
1342: WHERE EXISTS
1343: (SELECT NULL
1344: FROM
1345: pa_draft_invoice_items dii
1915: x_err_stage := 'check pa_fp_elements for task '|| x_task_id;
1916: declare
1917: cursor c1 is
1918: SELECT 1
1919: FROM sys.dual
1920: where exists (SELECT NULL
1921: FROM pa_fp_elements r
1922: where r.TASK_ID IN
1923: (SELECT TASK_ID
1948: x_err_stage := 'check budget for task '|| x_task_id;
1949: declare
1950: cursor c1 is
1951: SELECT 1
1952: FROM sys.dual
1953: where exists (SELECT NULL
1954: FROM pa_resource_assignments r
1955: where r.TASK_ID IN
1956: (SELECT TASK_ID
2424: is
2425:
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:
2647: is
2648: CURSOR c1
2649: IS
2650: SELECT 1
2651: FROM dual
2652: WHERE EXISTS
2653: (SELECT NULL
2654: FROM PA_PROJ_ELEM_VER_SCHEDULE
2655: WHERE PROJECT_ID = p_project_id