3608: X_NEW_PROJECT_SYSTEM_STATUS_CO => l_new_sys_status,
3609: X_OLD_PROJECT_STATUS_CODE => l_old_project_status,
3610: X_OLD_PROJECT_SYSTEM_STATUS_CO => l_old_sys_status,
3611: X_CHANGE_COMMENT => p_comment,
3612: X_LAST_UPDATED_BY => fnd_global.user_id,
3613: X_CREATED_BY => fnd_global.user_id,
3614: X_CREATION_DATE => sysdate,
3615: X_LAST_UPDATE_DATE => sysdate,
3616: X_LAST_UPDATE_LOGIN => fnd_global.user_id );
3609: X_OLD_PROJECT_STATUS_CODE => l_old_project_status,
3610: X_OLD_PROJECT_SYSTEM_STATUS_CO => l_old_sys_status,
3611: X_CHANGE_COMMENT => p_comment,
3612: X_LAST_UPDATED_BY => fnd_global.user_id,
3613: X_CREATED_BY => fnd_global.user_id,
3614: X_CREATION_DATE => sysdate,
3615: X_LAST_UPDATE_DATE => sysdate,
3616: X_LAST_UPDATE_LOGIN => fnd_global.user_id );
3617:
3612: X_LAST_UPDATED_BY => fnd_global.user_id,
3613: X_CREATED_BY => fnd_global.user_id,
3614: X_CREATION_DATE => sysdate,
3615: X_LAST_UPDATE_DATE => sysdate,
3616: X_LAST_UPDATE_LOGIN => fnd_global.user_id );
3617:
3618: IF (l_debug_mode = 'Y') THEN
3619: pa_debug.debug('Updated PA_PROJECTS_ALL for status history');
3620: END IF;
3662: SET wf_status_code = NULL
3663: ,project_status_code = p_new_status_code
3664: ,closed_date = sysdate
3665: ,last_update_date = sysdate
3666: ,last_updated_by = fnd_global.user_id
3667: ,last_update_login = fnd_global.login_id
3668: WHERE project_id = p_project_id;
3669: ELSE
3670:
3663: ,project_status_code = p_new_status_code
3664: ,closed_date = sysdate
3665: ,last_update_date = sysdate
3666: ,last_updated_by = fnd_global.user_id
3667: ,last_update_login = fnd_global.login_id
3668: WHERE project_id = p_project_id;
3669: ELSE
3670:
3671: UPDATE pa_projects_all
3673: ,project_status_code = p_new_status_code --Added for bug 3818322
3674: /*4364878 : Included update of who columns also*/
3675: ,closed_date = to_date(null) --For any status other than Closed,this field should be NULL
3676: ,last_update_date = sysdate
3677: ,last_updated_by = fnd_global.user_id
3678: ,last_update_login = fnd_global.login_id
3679: WHERE project_id = p_project_id;
3680: END IF;
3681:
3674: /*4364878 : Included update of who columns also*/
3675: ,closed_date = to_date(null) --For any status other than Closed,this field should be NULL
3676: ,last_update_date = sysdate
3677: ,last_updated_by = fnd_global.user_id
3678: ,last_update_login = fnd_global.login_id
3679: WHERE project_id = p_project_id;
3680: END IF;
3681:
3682: --Start the workflow for the project
3695: SET wf_status_code = 'IN_ROUTE'
3696: ,project_status_code = p_new_status_code
3697: ,closed_date = sysdate
3698: ,last_update_date = sysdate
3699: ,last_updated_by = fnd_global.user_id
3700: ,last_update_login = fnd_global.login_id
3701: WHERE project_id = p_project_id;
3702: ELSE
3703:
3696: ,project_status_code = p_new_status_code
3697: ,closed_date = sysdate
3698: ,last_update_date = sysdate
3699: ,last_updated_by = fnd_global.user_id
3700: ,last_update_login = fnd_global.login_id
3701: WHERE project_id = p_project_id;
3702: ELSE
3703:
3704: UPDATE pa_projects_all
3706: ,project_status_code = p_new_status_code --Added for bug 3818322
3707: /*4364878 : Included update of who columns also*/
3708: ,closed_date = to_date(null) --For any status other than Closed,this field should be NULL
3709: ,last_update_date = sysdate
3710: ,last_updated_by = fnd_global.user_id
3711: ,last_update_login = fnd_global.login_id
3712: WHERE project_id = p_project_id;
3713: END IF;
3714:
3707: /*4364878 : Included update of who columns also*/
3708: ,closed_date = to_date(null) --For any status other than Closed,this field should be NULL
3709: ,last_update_date = sysdate
3710: ,last_updated_by = fnd_global.user_id
3711: ,last_update_login = fnd_global.login_id
3712: WHERE project_id = p_project_id;
3713: END IF;
3714:
3715: --Start the workflow for the project
3743: UPDATE pa_projects_all
3744: SET project_status_code = p_new_status_code
3745: ,closed_date = sysdate
3746: ,last_update_date = sysdate
3747: ,last_updated_by = fnd_global.user_id
3748: ,last_update_login = fnd_global.login_id
3749: WHERE project_id = p_project_id ;
3750:
3751: Else
3744: SET project_status_code = p_new_status_code
3745: ,closed_date = sysdate
3746: ,last_update_date = sysdate
3747: ,last_updated_by = fnd_global.user_id
3748: ,last_update_login = fnd_global.login_id
3749: WHERE project_id = p_project_id ;
3750:
3751: Else
3752:
3754: SET project_status_code = p_new_status_code
3755: /*4364878 : Included update of who columns also*/
3756: ,closed_date = to_date(null) --For any status other than Closed,this field should be NULL
3757: ,last_update_date = sysdate
3758: ,last_updated_by = fnd_global.user_id
3759: ,last_update_login = fnd_global.login_id
3760: WHERE project_id = p_project_id ;
3761:
3762: End if;
3755: /*4364878 : Included update of who columns also*/
3756: ,closed_date = to_date(null) --For any status other than Closed,this field should be NULL
3757: ,last_update_date = sysdate
3758: ,last_updated_by = fnd_global.user_id
3759: ,last_update_login = fnd_global.login_id
3760: WHERE project_id = p_project_id ;
3761:
3762: End if;
3763: END IF;