[Home] [Help]
2659: /* in the following decode, if p_task_id is null, check if any other override for same award, project exists.
2660: if p_task id is not null, check if p_task_id = top_task_id for the enc. */
2661: /* calling new function item_task_validate */
2662: /* AND 1 = decode(p_task_id, NULL ,decode (1, (select 1
2663: from GMS_OVERRIDE_SCHEDULES GOS,
2664: pa_tasks TASK
2665: where GOS.award_id = p_award_id
2666: and GOS.project_id = p_project_id
2667: and nvl(ITEM.task_id,-99) = TASK.task_id
2728: -- bug 6967150 AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d')
2729: AND ITEM.ind_compiled_set_id > 0 -- bug 7225876
2730: AND NOT EXISTS
2731: ( select 1
2732: from GMS_OVERRIDE_SCHEDULES GOS,
2733: pa_tasks TASK
2734: where GOS.award_id = p_award_id
2735: and GOS.project_id = ITEM.project_id
2736: and ITEM.task_id = TASK.task_id
2768: /* in the following decode, if p_task_id is null, check if any other override for same award, project exists.
2769: if p_task id is not null, check if p_task_id = top_task_id for the enc. */
2770: /* calling new function item_task_validate */
2771: /* AND 1 = decode(p_task_id, NULL ,decode (1, (select 1
2772: from GMS_OVERRIDE_SCHEDULES GOS,
2773: pa_tasks TASK
2774: where GOS.award_id = p_award_id
2775: and GOS.project_id = p_project_id
2776: and nvl(ITEM.task_id,-99) = TASK.task_id
2832: and adl.award_id = p_award_id )
2833: AND ITEM.ind_compiled_set_id >0 -- bug 7225876
2834: AND NOT EXISTS
2835: ( select 1
2836: from GMS_OVERRIDE_SCHEDULES GOS,
2837: pa_tasks TASK
2838: where GOS.award_id = p_award_id
2839: and GOS.project_id = ITEM.project_id
2840: and TASK.task_id = item.task_id
2903: begin
2904: l_test := 0;
2905: select 1
2906: into l_test
2907: from GMS_OVERRIDE_SCHEDULES GOS,
2908: pa_tasks TASK
2909: where GOS.award_id = p_award_id
2910: and GOS.project_id = p_project_id
2911: and p_item_task_id = TASK.task_id