[Home] [Help]
2632: /* in the following decode, if p_task_id is null, check if any other override for same award, project exists.
2633: if p_task id is not null, check if p_task_id = top_task_id for the enc. */
2634: /* calling new function item_task_validate */
2635: /* AND 1 = decode(p_task_id, NULL ,decode (1, (select 1
2636: from GMS_OVERRIDE_SCHEDULES GOS,
2637: pa_tasks TASK
2638: where GOS.award_id = p_award_id
2639: and GOS.project_id = p_project_id
2640: and nvl(ITEM.task_id,-99) = TASK.task_id
2692: AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d')
2693: AND ITEM.ind_compiled_set_id is not null
2694: AND NOT EXISTS
2695: ( select 1
2696: from GMS_OVERRIDE_SCHEDULES GOS,
2697: pa_tasks TASK
2698: where GOS.award_id = p_award_id
2699: and GOS.project_id = ITEM.project_id
2700: and ITEM.task_id = TASK.task_id
2728: /* in the following decode, if p_task_id is null, check if any other override for same award, project exists.
2729: if p_task id is not null, check if p_task_id = top_task_id for the enc. */
2730: /* calling new function item_task_validate */
2731: /* AND 1 = decode(p_task_id, NULL ,decode (1, (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 = p_project_id
2736: and nvl(ITEM.task_id,-99) = TASK.task_id
2783: and adl.award_id = p_award_id )
2784: AND ITEM.ind_compiled_set_id is not null
2785: AND NOT EXISTS
2786: ( select 1
2787: from GMS_OVERRIDE_SCHEDULES GOS,
2788: pa_tasks TASK
2789: where GOS.award_id = p_award_id
2790: and GOS.project_id = ITEM.project_id
2791: and ITEM.task_id = TASK.task_id
2853: begin
2854: l_test := 0;
2855: select 1
2856: into l_test
2857: from GMS_OVERRIDE_SCHEDULES GOS,
2858: pa_tasks TASK
2859: where GOS.award_id = p_award_id
2860: and GOS.project_id = p_project_id
2861: and p_item_task_id = TASK.task_id