DBA Data[Home] [Help]

APPS.PA_CREATE_RESOURCE dependencies on FND_GLOBAL

Line 3351: X_user_id := NVL( fnd_global.user_id, 1 );

3347: WHERE business_group_id = -3113;
3348:
3349: BEGIN
3350:
3351: X_user_id := NVL( fnd_global.user_id, 1 );
3352: X_login_id := NVL( fnd_global.login_id, 0 );
3353:
3354: V_old_stack := X_err_stack;
3355: X_err_code := 0;

Line 3352: X_login_id := NVL( fnd_global.login_id, 0 );

3348:
3349: BEGIN
3350:
3351: X_user_id := NVL( fnd_global.user_id, 1 );
3352: X_login_id := NVL( fnd_global.login_id, 0 );
3353:
3354: V_old_stack := X_err_stack;
3355: X_err_code := 0;
3356: X_err_stack :=

Line 3984: FND_GLOBAL.USER_ID,

3980: --3591751
3981: a.wp_eligible_flag,
3982: --Bug 3637045
3983: a.unit_of_measure,
3984: FND_GLOBAL.USER_ID,
3985: SYSDATE,
3986: SYSDATE,
3987: FND_GLOBAL.USER_ID,
3988: FND_GLOBAL.LOGIN_ID

Line 3987: FND_GLOBAL.USER_ID,

3983: a.unit_of_measure,
3984: FND_GLOBAL.USER_ID,
3985: SYSDATE,
3986: SYSDATE,
3987: FND_GLOBAL.USER_ID,
3988: FND_GLOBAL.LOGIN_ID
3989: FROM pa_resource_list_members a
3990: WHERE a.resource_list_id = p_resource_list_id
3991: AND a.object_id = p_resource_list_id

Line 3988: FND_GLOBAL.LOGIN_ID

3984: FND_GLOBAL.USER_ID,
3985: SYSDATE,
3986: SYSDATE,
3987: FND_GLOBAL.USER_ID,
3988: FND_GLOBAL.LOGIN_ID
3989: FROM pa_resource_list_members a
3990: WHERE a.resource_list_id = p_resource_list_id
3991: AND a.object_id = p_resource_list_id
3992: AND a.object_type = 'RESOURCE_LIST'

Line 4271: fnd_global.login_id,

4267: description,
4268: language,
4269: source_lang
4270: ) SELECT
4271: fnd_global.login_id,
4272: sysdate,
4273: fnd_global.user_id,
4274: sysdate,
4275: fnd_global.user_id,

Line 4273: fnd_global.user_id,

4269: source_lang
4270: ) SELECT
4271: fnd_global.login_id,
4272: sysdate,
4273: fnd_global.user_id,
4274: sysdate,
4275: fnd_global.user_id,
4276: x_resource_list_id,
4277: p_name,

Line 4275: fnd_global.user_id,

4271: fnd_global.login_id,
4272: sysdate,
4273: fnd_global.user_id,
4274: sysdate,
4275: fnd_global.user_id,
4276: x_resource_list_id,
4277: p_name,
4278: NVL(p_description,p_name),
4279: L.LANGUAGE_CODE,

Line 4298: fnd_global.user_id,

4294: X_Resource_List_Id,
4295: res_format_id,
4296: 1,
4297: sysdate,
4298: fnd_global.user_id,
4299: sysdate,
4300: fnd_global.user_id,
4301: fnd_global.login_id
4302: FROM

Line 4300: fnd_global.user_id,

4296: 1,
4297: sysdate,
4298: fnd_global.user_id,
4299: sysdate,
4300: fnd_global.user_id,
4301: fnd_global.login_id
4302: FROM
4303: pa_plan_rl_formats
4304: WHERE

Line 4301: fnd_global.login_id

4297: sysdate,
4298: fnd_global.user_id,
4299: sysdate,
4300: fnd_global.user_id,
4301: fnd_global.login_id
4302: FROM
4303: pa_plan_rl_formats
4304: WHERE
4305: resource_list_id=p_parent_resource_list_id

Line 4460: FND_GLOBAL.USER_ID,

4456: a.MEMBER_LEVEL,
4457: a.DISPLAY_FLAG ,
4458: a.ENABLED_FLAG ,
4459: a.TRACK_AS_LABOR_FLAG,
4460: FND_GLOBAL.USER_ID,
4461: SYSDATE,
4462: SYSDATE,
4463: FND_GLOBAL.USER_ID,
4464: FND_GLOBAL.LOGIN_ID,

Line 4463: FND_GLOBAL.USER_ID,

4459: a.TRACK_AS_LABOR_FLAG,
4460: FND_GLOBAL.USER_ID,
4461: SYSDATE,
4462: SYSDATE,
4463: FND_GLOBAL.USER_ID,
4464: FND_GLOBAL.LOGIN_ID,
4465: a.ADW_NOTIFY_FLAG,
4466: a.FUNDS_CONTROL_LEVEL_CODE,
4467: a.PERSON_ID,

Line 4464: FND_GLOBAL.LOGIN_ID,

4460: FND_GLOBAL.USER_ID,
4461: SYSDATE,
4462: SYSDATE,
4463: FND_GLOBAL.USER_ID,
4464: FND_GLOBAL.LOGIN_ID,
4465: a.ADW_NOTIFY_FLAG,
4466: a.FUNDS_CONTROL_LEVEL_CODE,
4467: a.PERSON_ID,
4468: a.JOB_ID,

Line 4830: FND_GLOBAL.USER_ID,

4826: --3591751
4827: a.wp_eligible_flag,
4828: --Bug 3636926
4829: a.unit_of_measure,
4830: FND_GLOBAL.USER_ID,
4831: SYSDATE,
4832: SYSDATE,
4833: FND_GLOBAL.USER_ID,
4834: FND_GLOBAL.LOGIN_ID

Line 4833: FND_GLOBAL.USER_ID,

4829: a.unit_of_measure,
4830: FND_GLOBAL.USER_ID,
4831: SYSDATE,
4832: SYSDATE,
4833: FND_GLOBAL.USER_ID,
4834: FND_GLOBAL.LOGIN_ID
4835: FROM pa_resource_list_members a
4836: WHERE a.resource_list_id = l_resource_list_id
4837: AND a.object_id = p_source_project_id

Line 4834: FND_GLOBAL.LOGIN_ID

4830: FND_GLOBAL.USER_ID,
4831: SYSDATE,
4832: SYSDATE,
4833: FND_GLOBAL.USER_ID,
4834: FND_GLOBAL.LOGIN_ID
4835: FROM pa_resource_list_members a
4836: WHERE a.resource_list_id = l_resource_list_id
4837: AND a.object_id = p_source_project_id
4838: AND a.object_type = 'PROJECT'

Line 5034: LAST_UPDATED_BY = fnd_global.user_id,

5030: set
5031: NAME = P_NAME,
5032: DESCRIPTION = P_DESCRIPTION,
5033: LAST_UPDATE_DATE = sysdate,
5034: LAST_UPDATED_BY = fnd_global.user_id,
5035: LAST_UPDATE_LOGIN = fnd_global.login_id,
5036: SOURCE_LANG = userenv('LANG')
5037: where resource_list_id = P_RESOURCE_LIST_ID
5038: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 5035: LAST_UPDATE_LOGIN = fnd_global.login_id,

5031: NAME = P_NAME,
5032: DESCRIPTION = P_DESCRIPTION,
5033: LAST_UPDATE_DATE = sysdate,
5034: LAST_UPDATED_BY = fnd_global.user_id,
5035: LAST_UPDATE_LOGIN = fnd_global.login_id,
5036: SOURCE_LANG = userenv('LANG')
5037: where resource_list_id = P_RESOURCE_LIST_ID
5038: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
5039:

Line 5053: FND_GLOBAL.LOGIN_ID,

5049: DESCRIPTION,
5050: LANGUAGE,
5051: SOURCE_LANG)
5052: select
5053: FND_GLOBAL.LOGIN_ID,
5054: sysdate,
5055: FND_GLOBAL.USER_ID,
5056: sysdate,
5057: FND_GLOBAL.USER_ID,

Line 5055: FND_GLOBAL.USER_ID,

5051: SOURCE_LANG)
5052: select
5053: FND_GLOBAL.LOGIN_ID,
5054: sysdate,
5055: FND_GLOBAL.USER_ID,
5056: sysdate,
5057: FND_GLOBAL.USER_ID,
5058: P_RESOURCE_LIST_ID,
5059: P_NAME,

Line 5057: FND_GLOBAL.USER_ID,

5053: FND_GLOBAL.LOGIN_ID,
5054: sysdate,
5055: FND_GLOBAL.USER_ID,
5056: sysdate,
5057: FND_GLOBAL.USER_ID,
5058: P_RESOURCE_LIST_ID,
5059: P_NAME,
5060: NVL(P_DESCRIPTION,P_NAME),
5061: L.LANGUAGE_CODE,