DBA Data[Home] [Help]

APPS.PA_RESOURCE_UTILS dependencies on FND_GLOBAL

Line 3195: fnd_global.user_id,

3191: -- If p_authority is 'PROJECT', check PA_SUPER_PROJECT_VIEW profile option
3192:
3193: IF p_authority = 'RESOURCE' THEN
3194: is_project_super_user := fnd_profile.value_specific('PA_SUPER_RESOURCE',
3195: fnd_global.user_id,
3196: fnd_global.resp_id,
3197: fnd_global.resp_appl_id) ;
3198: ELSE
3199: is_project_super_user := fnd_profile.value_specific('PA_SUPER_PROJECT_VIEW',

Line 3196: fnd_global.resp_id,

3192:
3193: IF p_authority = 'RESOURCE' THEN
3194: is_project_super_user := fnd_profile.value_specific('PA_SUPER_RESOURCE',
3195: fnd_global.user_id,
3196: fnd_global.resp_id,
3197: fnd_global.resp_appl_id) ;
3198: ELSE
3199: is_project_super_user := fnd_profile.value_specific('PA_SUPER_PROJECT_VIEW',
3200: fnd_global.user_id,

Line 3197: fnd_global.resp_appl_id) ;

3193: IF p_authority = 'RESOURCE' THEN
3194: is_project_super_user := fnd_profile.value_specific('PA_SUPER_RESOURCE',
3195: fnd_global.user_id,
3196: fnd_global.resp_id,
3197: fnd_global.resp_appl_id) ;
3198: ELSE
3199: is_project_super_user := fnd_profile.value_specific('PA_SUPER_PROJECT_VIEW',
3200: fnd_global.user_id,
3201: fnd_global.resp_id,

Line 3200: fnd_global.user_id,

3196: fnd_global.resp_id,
3197: fnd_global.resp_appl_id) ;
3198: ELSE
3199: is_project_super_user := fnd_profile.value_specific('PA_SUPER_PROJECT_VIEW',
3200: fnd_global.user_id,
3201: fnd_global.resp_id,
3202: fnd_global.resp_appl_id) ;
3203: END IF;
3204:

Line 3201: fnd_global.resp_id,

3197: fnd_global.resp_appl_id) ;
3198: ELSE
3199: is_project_super_user := fnd_profile.value_specific('PA_SUPER_PROJECT_VIEW',
3200: fnd_global.user_id,
3201: fnd_global.resp_id,
3202: fnd_global.resp_appl_id) ;
3203: END IF;
3204:
3205: if is_project_super_user = 'Y' then

Line 3202: fnd_global.resp_appl_id) ;

3198: ELSE
3199: is_project_super_user := fnd_profile.value_specific('PA_SUPER_PROJECT_VIEW',
3200: fnd_global.user_id,
3201: fnd_global.resp_id,
3202: fnd_global.resp_appl_id) ;
3203: END IF;
3204:
3205: if is_project_super_user = 'Y' then
3206: return 'SU';

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

3204:
3205: if is_project_super_user = 'Y' then
3206: return 'SU';
3207: end if;
3208: /* resp.application_id = fnd_global.resp_appl_id join is added for Perfomance
3209: Bug 2634995 */
3210: select menu_name
3211: into l_menu_name
3212: from fnd_menus menu,

Line 3214: where resp.responsibility_id = fnd_global.resp_id

3210: select menu_name
3211: into l_menu_name
3212: from fnd_menus menu,
3213: fnd_responsibility resp
3214: where resp.responsibility_id = fnd_global.resp_id
3215: and resp.menu_id = menu.menu_id
3216: and resp.application_id = fnd_global.resp_appl_id ;
3217:
3218:

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

3212: from fnd_menus menu,
3213: fnd_responsibility resp
3214: where resp.responsibility_id = fnd_global.resp_id
3215: and resp.menu_id = menu.menu_id
3216: and resp.application_id = fnd_global.resp_appl_id ;
3217:
3218:
3219: /* changed for bug 2775111: recently the function 'PA_STAFF_HOME_RM'
3220: got moved from menu 'PA_PRM_RES_MGR' to the submenu 'PA_STAFFING_RES_MGR'.

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

4017: l_function_id number;
4018: l_menu_id number;
4019:
4020: BEGIN
4021: /* resp.application_id = fnd_global.resp_appl_id join is added for Perfomance
4022: Bug 2634995 */
4023: select menu_name, resp.menu_id
4024: into l_menu_name, l_menu_id
4025: from fnd_menus menu,

Line 4027: where resp.responsibility_id = fnd_global.resp_id

4023: select menu_name, resp.menu_id
4024: into l_menu_name, l_menu_id
4025: from fnd_menus menu,
4026: fnd_responsibility resp
4027: where resp.responsibility_id = fnd_global.resp_id
4028: and resp.menu_id = menu.menu_id
4029: and resp.application_id = fnd_global.resp_appl_id ;
4030:
4031: select function_id

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

4025: from fnd_menus menu,
4026: fnd_responsibility resp
4027: where resp.responsibility_id = fnd_global.resp_id
4028: and resp.menu_id = menu.menu_id
4029: and resp.application_id = fnd_global.resp_appl_id ;
4030:
4031: select function_id
4032: into l_function_id
4033: from fnd_form_functions

Line 4623: last_updated_by = fnd_global.user_id,

4619:
4620: UPDATE pa_resources_denorm
4621: SET resource_effective_end_date = G_FTE_DATE,
4622: last_update_date = sysdate,
4623: last_updated_by = fnd_global.user_id,
4624: last_update_login = fnd_global.login_id
4625: WHERE person_id = G_TERM_PERSON_ID --l_person_id
4626: AND resource_effective_end_date = l_resource_effective_end_date;
4627:

Line 4624: last_update_login = fnd_global.login_id

4620: UPDATE pa_resources_denorm
4621: SET resource_effective_end_date = G_FTE_DATE,
4622: last_update_date = sysdate,
4623: last_updated_by = fnd_global.user_id,
4624: last_update_login = fnd_global.login_id
4625: WHERE person_id = G_TERM_PERSON_ID --l_person_id
4626: AND resource_effective_end_date = l_resource_effective_end_date;
4627:
4628: pa_resource_utils.get_fte_flag(p_person_id => G_TERM_PERSON_ID,

Line 4743: last_updated_by = fnd_global.user_id,

4739:
4740: UPDATE pa_resources
4741: SET future_term_wf_flag = p_future_term_wf_flag,
4742: last_update_date = sysdate,
4743: last_updated_by = fnd_global.user_id,
4744: last_update_login = fnd_global.login_id
4745: WHERE
4746: resource_id = l_resource_id;
4747:

Line 4744: last_update_login = fnd_global.login_id

4740: UPDATE pa_resources
4741: SET future_term_wf_flag = p_future_term_wf_flag,
4742: last_update_date = sysdate,
4743: last_updated_by = fnd_global.user_id,
4744: last_update_login = fnd_global.login_id
4745: WHERE
4746: resource_id = l_resource_id;
4747:
4748: ELSIF NVL(l_resource_id,-999) = -999 THEN