DBA Data[Home] [Help]

APPS.PA_CREATE_RESOURCE dependencies on FND_GLOBAL

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

3696: WHERE business_group_id = -3113;
3697:
3698: BEGIN
3699:
3700: X_user_id := NVL( fnd_global.user_id, 1 );
3701: X_login_id := NVL( fnd_global.login_id, 0 );
3702:
3703: V_old_stack := X_err_stack;
3704: X_err_code := 0;

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

3697:
3698: BEGIN
3699:
3700: X_user_id := NVL( fnd_global.user_id, 1 );
3701: X_login_id := NVL( fnd_global.login_id, 0 );
3702:
3703: V_old_stack := X_err_stack;
3704: X_err_code := 0;
3705: X_err_stack :=

Line 4334: FND_GLOBAL.USER_ID,

4330: --3591751
4331: a.wp_eligible_flag,
4332: --Bug 3637045
4333: a.unit_of_measure,
4334: FND_GLOBAL.USER_ID,
4335: SYSDATE,
4336: SYSDATE,
4337: FND_GLOBAL.USER_ID,
4338: FND_GLOBAL.LOGIN_ID,

Line 4337: FND_GLOBAL.USER_ID,

4333: a.unit_of_measure,
4334: FND_GLOBAL.USER_ID,
4335: SYSDATE,
4336: SYSDATE,
4337: FND_GLOBAL.USER_ID,
4338: FND_GLOBAL.LOGIN_ID,
4339: expenditure_type_2 --Added for Bug13654538
4340: FROM pa_resource_list_members a
4341: WHERE a.resource_list_id = p_resource_list_id

Line 4338: FND_GLOBAL.LOGIN_ID,

4334: FND_GLOBAL.USER_ID,
4335: SYSDATE,
4336: SYSDATE,
4337: FND_GLOBAL.USER_ID,
4338: FND_GLOBAL.LOGIN_ID,
4339: expenditure_type_2 --Added for Bug13654538
4340: FROM pa_resource_list_members a
4341: WHERE a.resource_list_id = p_resource_list_id
4342: AND a.object_id = p_resource_list_id

Line 4624: fnd_global.login_id,

4620: description,
4621: language,
4622: source_lang
4623: ) SELECT
4624: fnd_global.login_id,
4625: sysdate,
4626: fnd_global.user_id,
4627: sysdate,
4628: fnd_global.user_id,

Line 4626: fnd_global.user_id,

4622: source_lang
4623: ) SELECT
4624: fnd_global.login_id,
4625: sysdate,
4626: fnd_global.user_id,
4627: sysdate,
4628: fnd_global.user_id,
4629: x_resource_list_id,
4630: p_name,

Line 4628: fnd_global.user_id,

4624: fnd_global.login_id,
4625: sysdate,
4626: fnd_global.user_id,
4627: sysdate,
4628: fnd_global.user_id,
4629: x_resource_list_id,
4630: p_name,
4631: NVL(p_description,p_name),
4632: L.LANGUAGE_CODE,

Line 4651: fnd_global.user_id,

4647: X_Resource_List_Id,
4648: res_format_id,
4649: 1,
4650: sysdate,
4651: fnd_global.user_id,
4652: sysdate,
4653: fnd_global.user_id,
4654: fnd_global.login_id
4655: FROM

Line 4653: fnd_global.user_id,

4649: 1,
4650: sysdate,
4651: fnd_global.user_id,
4652: sysdate,
4653: fnd_global.user_id,
4654: fnd_global.login_id
4655: FROM
4656: pa_plan_rl_formats
4657: WHERE

Line 4654: fnd_global.login_id

4650: sysdate,
4651: fnd_global.user_id,
4652: sysdate,
4653: fnd_global.user_id,
4654: fnd_global.login_id
4655: FROM
4656: pa_plan_rl_formats
4657: WHERE
4658: resource_list_id=p_parent_resource_list_id

Line 4814: FND_GLOBAL.USER_ID,

4810: a.MEMBER_LEVEL,
4811: a.DISPLAY_FLAG ,
4812: a.ENABLED_FLAG ,
4813: a.TRACK_AS_LABOR_FLAG,
4814: FND_GLOBAL.USER_ID,
4815: SYSDATE,
4816: SYSDATE,
4817: FND_GLOBAL.USER_ID,
4818: FND_GLOBAL.LOGIN_ID,

Line 4817: FND_GLOBAL.USER_ID,

4813: a.TRACK_AS_LABOR_FLAG,
4814: FND_GLOBAL.USER_ID,
4815: SYSDATE,
4816: SYSDATE,
4817: FND_GLOBAL.USER_ID,
4818: FND_GLOBAL.LOGIN_ID,
4819: a.ADW_NOTIFY_FLAG,
4820: a.FUNDS_CONTROL_LEVEL_CODE,
4821: a.PERSON_ID,

Line 4818: FND_GLOBAL.LOGIN_ID,

4814: FND_GLOBAL.USER_ID,
4815: SYSDATE,
4816: SYSDATE,
4817: FND_GLOBAL.USER_ID,
4818: FND_GLOBAL.LOGIN_ID,
4819: a.ADW_NOTIFY_FLAG,
4820: a.FUNDS_CONTROL_LEVEL_CODE,
4821: a.PERSON_ID,
4822: a.JOB_ID,

Line 5185: FND_GLOBAL.USER_ID,

5181: --3591751
5182: a.wp_eligible_flag,
5183: --Bug 3636926
5184: a.unit_of_measure,
5185: FND_GLOBAL.USER_ID,
5186: SYSDATE,
5187: SYSDATE,
5188: FND_GLOBAL.USER_ID,
5189: FND_GLOBAL.LOGIN_ID

Line 5188: FND_GLOBAL.USER_ID,

5184: a.unit_of_measure,
5185: FND_GLOBAL.USER_ID,
5186: SYSDATE,
5187: SYSDATE,
5188: FND_GLOBAL.USER_ID,
5189: FND_GLOBAL.LOGIN_ID
5190: FROM pa_resource_list_members a
5191: WHERE a.resource_list_id = l_resource_list_id
5192: AND a.object_id = p_source_project_id

Line 5189: FND_GLOBAL.LOGIN_ID

5185: FND_GLOBAL.USER_ID,
5186: SYSDATE,
5187: SYSDATE,
5188: FND_GLOBAL.USER_ID,
5189: FND_GLOBAL.LOGIN_ID
5190: FROM pa_resource_list_members a
5191: WHERE a.resource_list_id = l_resource_list_id
5192: AND a.object_id = p_source_project_id
5193: AND a.object_type = 'PROJECT'

Line 5389: LAST_UPDATED_BY = fnd_global.user_id,

5385: set
5386: NAME = P_NAME,
5387: DESCRIPTION = P_DESCRIPTION,
5388: LAST_UPDATE_DATE = sysdate,
5389: LAST_UPDATED_BY = fnd_global.user_id,
5390: LAST_UPDATE_LOGIN = fnd_global.login_id,
5391: SOURCE_LANG = userenv('LANG')
5392: where resource_list_id = P_RESOURCE_LIST_ID
5393: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 5390: LAST_UPDATE_LOGIN = fnd_global.login_id,

5386: NAME = P_NAME,
5387: DESCRIPTION = P_DESCRIPTION,
5388: LAST_UPDATE_DATE = sysdate,
5389: LAST_UPDATED_BY = fnd_global.user_id,
5390: LAST_UPDATE_LOGIN = fnd_global.login_id,
5391: SOURCE_LANG = userenv('LANG')
5392: where resource_list_id = P_RESOURCE_LIST_ID
5393: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
5394:

Line 5408: FND_GLOBAL.LOGIN_ID,

5404: DESCRIPTION,
5405: LANGUAGE,
5406: SOURCE_LANG)
5407: select
5408: FND_GLOBAL.LOGIN_ID,
5409: sysdate,
5410: FND_GLOBAL.USER_ID,
5411: sysdate,
5412: FND_GLOBAL.USER_ID,

Line 5410: FND_GLOBAL.USER_ID,

5406: SOURCE_LANG)
5407: select
5408: FND_GLOBAL.LOGIN_ID,
5409: sysdate,
5410: FND_GLOBAL.USER_ID,
5411: sysdate,
5412: FND_GLOBAL.USER_ID,
5413: P_RESOURCE_LIST_ID,
5414: P_NAME,

Line 5412: FND_GLOBAL.USER_ID,

5408: FND_GLOBAL.LOGIN_ID,
5409: sysdate,
5410: FND_GLOBAL.USER_ID,
5411: sysdate,
5412: FND_GLOBAL.USER_ID,
5413: P_RESOURCE_LIST_ID,
5414: P_NAME,
5415: NVL(P_DESCRIPTION,P_NAME),
5416: L.LANGUAGE_CODE,