[Home] [Help]
732: ----------------------------------------------------------------------------
733: if ((TASK_FIRST) OR (l_project_number <> TrxRec.project_number) OR (l_task_number <> TrxRec.task_number)) then
734: select task_id
735: into l_task_id
736: from pa_tasks
737: where task_number = TrxRec.task_number
738: and project_id = l_project_id;
739:
740: TASK_FIRST := FALSE;
1525: /* Bug# 4138033 */
1526: PROCEDURE Validate_Dates_YN
1527: ( l_award_id1 IN gms_awards_all.award_id%TYPE, -- Original Encumbrance Award Id
1528: l_project_id1 IN pa_projects_all.project_id%TYPE, -- Original Encumbrance Project Id
1529: l_task_id1 IN pa_tasks.task_id%TYPE, -- Original Encumbrance Task Id
1530: l_orig_enc_item_id1 IN gms_encumbrance_items_all.encumbrance_item_id%TYPE -- Original Encumbrance Item Id
1531: ) IS
1532:
1533: -- The following cursor is to get the maximum start date and minimum completion date
1534: -- out of award, project and task's start and end dates.
1535: CURSOR Cur_MaxMin_StartEnd_Dates IS
1536: SELECT max(start_date), min(completion_date)
1537: FROM ( select start_date, completion_date
1538: from pa_tasks tsk1
1539: where task_id = l_task_id1
1540: union all
1541: select start_date, completion_date
1542: from pa_projects_all