DBA Data[Home] [Help]

APPS.PA_RESOURCE_UTILS dependencies on FND_GLOBAL

Line 3456: fnd_global.user_id,

3452: -- If p_authority is 'PROJECT', check PA_SUPER_PROJECT_VIEW profile option
3453:
3454: IF p_authority = 'RESOURCE' THEN
3455: is_project_super_user := fnd_profile.value_specific('PA_SUPER_RESOURCE',
3456: fnd_global.user_id,
3457: fnd_global.resp_id,
3458: fnd_global.resp_appl_id) ;
3459: ELSE
3460: is_project_super_user := fnd_profile.value_specific('PA_SUPER_PROJECT_VIEW',

Line 3457: fnd_global.resp_id,

3453:
3454: IF p_authority = 'RESOURCE' THEN
3455: is_project_super_user := fnd_profile.value_specific('PA_SUPER_RESOURCE',
3456: fnd_global.user_id,
3457: fnd_global.resp_id,
3458: fnd_global.resp_appl_id) ;
3459: ELSE
3460: is_project_super_user := fnd_profile.value_specific('PA_SUPER_PROJECT_VIEW',
3461: fnd_global.user_id,

Line 3458: fnd_global.resp_appl_id) ;

3454: IF p_authority = 'RESOURCE' THEN
3455: is_project_super_user := fnd_profile.value_specific('PA_SUPER_RESOURCE',
3456: fnd_global.user_id,
3457: fnd_global.resp_id,
3458: fnd_global.resp_appl_id) ;
3459: ELSE
3460: is_project_super_user := fnd_profile.value_specific('PA_SUPER_PROJECT_VIEW',
3461: fnd_global.user_id,
3462: fnd_global.resp_id,

Line 3461: fnd_global.user_id,

3457: fnd_global.resp_id,
3458: fnd_global.resp_appl_id) ;
3459: ELSE
3460: is_project_super_user := fnd_profile.value_specific('PA_SUPER_PROJECT_VIEW',
3461: fnd_global.user_id,
3462: fnd_global.resp_id,
3463: fnd_global.resp_appl_id) ;
3464: END IF;
3465:

Line 3462: fnd_global.resp_id,

3458: fnd_global.resp_appl_id) ;
3459: ELSE
3460: is_project_super_user := fnd_profile.value_specific('PA_SUPER_PROJECT_VIEW',
3461: fnd_global.user_id,
3462: fnd_global.resp_id,
3463: fnd_global.resp_appl_id) ;
3464: END IF;
3465:
3466: if is_project_super_user = 'Y' then

Line 3463: fnd_global.resp_appl_id) ;

3459: ELSE
3460: is_project_super_user := fnd_profile.value_specific('PA_SUPER_PROJECT_VIEW',
3461: fnd_global.user_id,
3462: fnd_global.resp_id,
3463: fnd_global.resp_appl_id) ;
3464: END IF;
3465:
3466: if is_project_super_user = 'Y' then
3467: return 'SU';

Line 3469: /* resp.application_id = fnd_global.resp_appl_id join is added for Perfomance

3465:
3466: if is_project_super_user = 'Y' then
3467: return 'SU';
3468: end if;
3469: /* resp.application_id = fnd_global.resp_appl_id join is added for Perfomance
3470: Bug 2634995 */
3471: select menu_name
3472: into l_menu_name
3473: from fnd_menus menu,

Line 3475: where resp.responsibility_id = fnd_global.resp_id

3471: select menu_name
3472: into l_menu_name
3473: from fnd_menus menu,
3474: fnd_responsibility resp
3475: where resp.responsibility_id = fnd_global.resp_id
3476: and resp.menu_id = menu.menu_id
3477: and resp.application_id = fnd_global.resp_appl_id ;
3478:
3479:

Line 3477: and resp.application_id = fnd_global.resp_appl_id ;

3473: from fnd_menus menu,
3474: fnd_responsibility resp
3475: where resp.responsibility_id = fnd_global.resp_id
3476: and resp.menu_id = menu.menu_id
3477: and resp.application_id = fnd_global.resp_appl_id ;
3478:
3479:
3480: /* changed for bug 2775111: recently the function 'PA_STAFF_HOME_RM'
3481: got moved from menu 'PA_PRM_RES_MGR' to the submenu 'PA_STAFFING_RES_MGR'.

Line 4357: /* resp.application_id = fnd_global.resp_appl_id join is added for Perfomance

4353: l_function_id number;
4354: l_menu_id number;
4355:
4356: BEGIN
4357: /* resp.application_id = fnd_global.resp_appl_id join is added for Perfomance
4358: Bug 2634995 */
4359: select menu_name, resp.menu_id
4360: into l_menu_name, l_menu_id
4361: from fnd_menus menu,

Line 4363: where resp.responsibility_id = fnd_global.resp_id

4359: select menu_name, resp.menu_id
4360: into l_menu_name, l_menu_id
4361: from fnd_menus menu,
4362: fnd_responsibility resp
4363: where resp.responsibility_id = fnd_global.resp_id
4364: and resp.menu_id = menu.menu_id
4365: and resp.application_id = fnd_global.resp_appl_id ;
4366:
4367: select function_id

Line 4365: and resp.application_id = fnd_global.resp_appl_id ;

4361: from fnd_menus menu,
4362: fnd_responsibility resp
4363: where resp.responsibility_id = fnd_global.resp_id
4364: and resp.menu_id = menu.menu_id
4365: and resp.application_id = fnd_global.resp_appl_id ;
4366:
4367: select function_id
4368: into l_function_id
4369: from fnd_form_functions

Line 4979: last_updated_by = fnd_global.user_id,

4975:
4976: UPDATE pa_resources_denorm
4977: SET resource_effective_end_date = G_FTE_DATE,
4978: last_update_date = sysdate,
4979: last_updated_by = fnd_global.user_id,
4980: last_update_login = fnd_global.login_id
4981: WHERE person_id = G_TERM_PERSON_ID --l_person_id
4982: AND resource_effective_end_date = l_resource_effective_end_date;
4983:

Line 4980: last_update_login = fnd_global.login_id

4976: UPDATE pa_resources_denorm
4977: SET resource_effective_end_date = G_FTE_DATE,
4978: last_update_date = sysdate,
4979: last_updated_by = fnd_global.user_id,
4980: last_update_login = fnd_global.login_id
4981: WHERE person_id = G_TERM_PERSON_ID --l_person_id
4982: AND resource_effective_end_date = l_resource_effective_end_date;
4983:
4984: pa_resource_utils.get_fte_flag(p_person_id => G_TERM_PERSON_ID,

Line 5099: last_updated_by = fnd_global.user_id,

5095:
5096: UPDATE pa_resources
5097: SET future_term_wf_flag = p_future_term_wf_flag,
5098: last_update_date = sysdate,
5099: last_updated_by = fnd_global.user_id,
5100: last_update_login = fnd_global.login_id
5101: WHERE
5102: resource_id = l_resource_id;
5103:

Line 5100: last_update_login = fnd_global.login_id

5096: UPDATE pa_resources
5097: SET future_term_wf_flag = p_future_term_wf_flag,
5098: last_update_date = sysdate,
5099: last_updated_by = fnd_global.user_id,
5100: last_update_login = fnd_global.login_id
5101: WHERE
5102: resource_id = l_resource_id;
5103:
5104: ELSIF NVL(l_resource_id,-999) = -999 THEN