APPS.PA_PROJECTS_MAINT_PUB dependencies on FND_GLOBAL

Line 3585: X_LAST_UPDATED_BY => fnd_global.user_id,

3581: X_NEW_PROJECT_SYSTEM_STATUS_CO => l_new_sys_status,
3582: X_OLD_PROJECT_STATUS_CODE => l_old_project_status,
3583: X_OLD_PROJECT_SYSTEM_STATUS_CO => l_old_sys_status,
3584: X_CHANGE_COMMENT => p_comment,
3585: X_LAST_UPDATED_BY => fnd_global.user_id,
3586: X_CREATED_BY => fnd_global.user_id,
3587: X_CREATION_DATE => sysdate,
3588: X_LAST_UPDATE_DATE => sysdate,
3589: X_LAST_UPDATE_LOGIN => fnd_global.user_id );

Line 3586: X_CREATED_BY => fnd_global.user_id,

3582: X_OLD_PROJECT_STATUS_CODE => l_old_project_status,
3583: X_OLD_PROJECT_SYSTEM_STATUS_CO => l_old_sys_status,
3584: X_CHANGE_COMMENT => p_comment,
3585: X_LAST_UPDATED_BY => fnd_global.user_id,
3586: X_CREATED_BY => fnd_global.user_id,
3587: X_CREATION_DATE => sysdate,
3588: X_LAST_UPDATE_DATE => sysdate,
3589: X_LAST_UPDATE_LOGIN => fnd_global.user_id );
3590:

Line 3589: X_LAST_UPDATE_LOGIN => fnd_global.user_id );

3585: X_LAST_UPDATED_BY => fnd_global.user_id,
3586: X_CREATED_BY => fnd_global.user_id,
3587: X_CREATION_DATE => sysdate,
3588: X_LAST_UPDATE_DATE => sysdate,
3589: X_LAST_UPDATE_LOGIN => fnd_global.user_id );
3590:
3591: IF (l_debug_mode = 'Y') THEN
3592: pa_debug.debug('Updated PA_PROJECTS_ALL for status history');
3593: END IF;

Line 3639: ,last_updated_by = fnd_global.user_id

3635: SET wf_status_code = NULL
3636: ,project_status_code = p_new_status_code
3637: ,closed_date = sysdate
3638: ,last_update_date = sysdate
3639: ,last_updated_by = fnd_global.user_id
3640: ,last_update_login = fnd_global.login_id
3641: WHERE project_id = p_project_id;
3642: ELSE
3643:

Line 3640: ,last_update_login = fnd_global.login_id

3636: ,project_status_code = p_new_status_code
3637: ,closed_date = sysdate
3638: ,last_update_date = sysdate
3639: ,last_updated_by = fnd_global.user_id
3640: ,last_update_login = fnd_global.login_id
3641: WHERE project_id = p_project_id;
3642: ELSE
3643:
3644: UPDATE pa_projects_all

Line 3650: ,last_updated_by = fnd_global.user_id

3646: ,project_status_code = p_new_status_code --Added for bug 3818322
3647: /*4364878 : Included update of who columns also*/
3648: ,closed_date = to_date(null) --For any status other than Closed,this field should be NULL
3649: ,last_update_date = sysdate
3650: ,last_updated_by = fnd_global.user_id
3651: ,last_update_login = fnd_global.login_id
3652: WHERE project_id = p_project_id;
3653: END IF;
3654:

Line 3651: ,last_update_login = fnd_global.login_id

3647: /*4364878 : Included update of who columns also*/
3648: ,closed_date = to_date(null) --For any status other than Closed,this field should be NULL
3649: ,last_update_date = sysdate
3650: ,last_updated_by = fnd_global.user_id
3651: ,last_update_login = fnd_global.login_id
3652: WHERE project_id = p_project_id;
3653: END IF;
3654:
3655: --Start the workflow for the project

Line 3672: ,last_updated_by = fnd_global.user_id

3668: SET wf_status_code = 'IN_ROUTE'
3669: ,project_status_code = p_new_status_code
3670: ,closed_date = sysdate
3671: ,last_update_date = sysdate
3672: ,last_updated_by = fnd_global.user_id
3673: ,last_update_login = fnd_global.login_id
3674: WHERE project_id = p_project_id;
3675: ELSE
3676:

Line 3673: ,last_update_login = fnd_global.login_id

3669: ,project_status_code = p_new_status_code
3670: ,closed_date = sysdate
3671: ,last_update_date = sysdate
3672: ,last_updated_by = fnd_global.user_id
3673: ,last_update_login = fnd_global.login_id
3674: WHERE project_id = p_project_id;
3675: ELSE
3676:
3677: UPDATE pa_projects_all

Line 3683: ,last_updated_by = fnd_global.user_id

3679: ,project_status_code = p_new_status_code --Added for bug 3818322
3680: /*4364878 : Included update of who columns also*/
3681: ,closed_date = to_date(null) --For any status other than Closed,this field should be NULL
3682: ,last_update_date = sysdate
3683: ,last_updated_by = fnd_global.user_id
3684: ,last_update_login = fnd_global.login_id
3685: WHERE project_id = p_project_id;
3686: END IF;
3687:

Line 3684: ,last_update_login = fnd_global.login_id

3680: /*4364878 : Included update of who columns also*/
3681: ,closed_date = to_date(null) --For any status other than Closed,this field should be NULL
3682: ,last_update_date = sysdate
3683: ,last_updated_by = fnd_global.user_id
3684: ,last_update_login = fnd_global.login_id
3685: WHERE project_id = p_project_id;
3686: END IF;
3687:
3688: --Start the workflow for the project

Line 3720: ,last_updated_by = fnd_global.user_id

3716: UPDATE pa_projects_all
3717: SET project_status_code = p_new_status_code
3718: ,closed_date = sysdate
3719: ,last_update_date = sysdate
3720: ,last_updated_by = fnd_global.user_id
3721: ,last_update_login = fnd_global.login_id
3722: WHERE project_id = p_project_id ;
3723:
3724: Else

Line 3721: ,last_update_login = fnd_global.login_id

3717: SET project_status_code = p_new_status_code
3718: ,closed_date = sysdate
3719: ,last_update_date = sysdate
3720: ,last_updated_by = fnd_global.user_id
3721: ,last_update_login = fnd_global.login_id
3722: WHERE project_id = p_project_id ;
3723:
3724: Else
3725:

Line 3731: ,last_updated_by = fnd_global.user_id

3727: SET project_status_code = p_new_status_code
3728: /*4364878 : Included update of who columns also*/
3729: ,closed_date = to_date(null) --For any status other than Closed,this field should be NULL
3730: ,last_update_date = sysdate
3731: ,last_updated_by = fnd_global.user_id
3732: ,last_update_login = fnd_global.login_id
3733: WHERE project_id = p_project_id ;
3734:
3735: End if;

Line 3732: ,last_update_login = fnd_global.login_id

3728: /*4364878 : Included update of who columns also*/
3729: ,closed_date = to_date(null) --For any status other than Closed,this field should be NULL
3730: ,last_update_date = sysdate
3731: ,last_updated_by = fnd_global.user_id
3732: ,last_update_login = fnd_global.login_id
3733: WHERE project_id = p_project_id ;
3734:
3735: End if;
3736: END IF;