DBA Data[Home] [Help]

APPS.GMS_MULTI_FUNDING dependencies on PA_TASKS

Line 195: UPDATE pa_tasks pt

191: -- Bug 3319191 : UPDATE Indirect schedule on task corresponding to
192: -- Award Project when Indirect schedule is changed
193: -- at award level.
194:
195: UPDATE pa_tasks pt
196: SET cost_ind_rate_sch_id= X_IDC_Schedule_Id,
197: cost_ind_sch_fixed_date=X_IDC_Schedule_Fixed_Date
198: WHERE project_id = X_project_id;
199:

Line 3162: G_Stage := '(320:Select from pa_tasks)';

3158:
3159: X_Awd_Proj_Name := X_Project_Name;
3160: X_Awd_Proj_Number := X_Project_Number;
3161:
3162: G_Stage := '(320:Select from pa_tasks)';
3163:
3164: --Getting the Only Task ID and its Completion Date (also the Project Completion Date)
3165: --of this Award Project to UPDATE Task Information
3166:

Line 3171: FROM pa_tasks

3167: BEGIN
3168:
3169: SELECT task_id, trunc(start_date), trunc(completion_date)
3170: INTO X_Task_ID_To_UPDATE, X_Task_Proj_Start_Date, X_Task_Proj_Compl_Date
3171: FROM pa_tasks
3172: WHERE project_id = X_Award_Project_Id;
3173:
3174: EXCEPTION
3175: WHEN OTHERS THEN