DBA Data[Home] [Help]

APPS.PA_RESOURCE_LIST_TBL_PKG dependencies on FND_GLOBAL

Line 98: FND_GLOBAL.USER_ID,

94: P_RESOURCE_LIST_TYPE,
95: P_CONTROL_FLAG,
96: P_USE_FOR_WP_FLAG,
97: P_MIGRATION_CODE,
98: FND_GLOBAL.USER_ID,
99: SYSDATE,
100: SYSDATE,
101: FND_GLOBAL.USER_ID,
102: FND_GLOBAL.LOGIN_ID,

Line 101: FND_GLOBAL.USER_ID,

97: P_MIGRATION_CODE,
98: FND_GLOBAL.USER_ID,
99: SYSDATE,
100: SYSDATE,
101: FND_GLOBAL.USER_ID,
102: FND_GLOBAL.LOGIN_ID,
103: 1,
104: p_Enable_Resource_Classes -- Added for CBS Bug13535688
105: );

Line 102: FND_GLOBAL.LOGIN_ID,

98: FND_GLOBAL.USER_ID,
99: SYSDATE,
100: SYSDATE,
101: FND_GLOBAL.USER_ID,
102: FND_GLOBAL.LOGIN_ID,
103: 1,
104: p_Enable_Resource_Classes -- Added for CBS Bug13535688
105: );
106:

Line 208: FND_GLOBAL.LOGIN_ID,

204: DESCRIPTION,
205: LANGUAGE,
206: SOURCE_LANG
207: ) select
208: FND_GLOBAL.LOGIN_ID,
209: sysdate,
210: FND_GLOBAL.USER_ID,
211: sysdate,
212: FND_GLOBAL.USER_ID,

Line 210: FND_GLOBAL.USER_ID,

206: SOURCE_LANG
207: ) select
208: FND_GLOBAL.LOGIN_ID,
209: sysdate,
210: FND_GLOBAL.USER_ID,
211: sysdate,
212: FND_GLOBAL.USER_ID,
213: X_RESOURCE_LIST_ID,
214: X_NAME,

Line 212: FND_GLOBAL.USER_ID,

208: FND_GLOBAL.LOGIN_ID,
209: sysdate,
210: FND_GLOBAL.USER_ID,
211: sysdate,
212: FND_GLOBAL.USER_ID,
213: X_RESOURCE_LIST_ID,
214: X_NAME,
215: NVL(X_DESCRIPTION,X_NAME),
216: L.LANGUAGE_CODE,

Line 292: LAST_UPDATED_BY = fnd_global.user_id,

288: update pa_resource_lists_tl set
289: NAME = X_NAME,
290: DESCRIPTION = X_DESCRIPTION,
291: LAST_UPDATE_DATE = sysdate,
292: LAST_UPDATED_BY = fnd_global.user_id,
293: LAST_UPDATE_LOGIN = fnd_global.login_id,
294: SOURCE_LANG = userenv('LANG')
295: where resource_list_id = X_RESOURCE_LIST_ID
296: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 293: LAST_UPDATE_LOGIN = fnd_global.login_id,

289: NAME = X_NAME,
290: DESCRIPTION = X_DESCRIPTION,
291: LAST_UPDATE_DATE = sysdate,
292: LAST_UPDATED_BY = fnd_global.user_id,
293: LAST_UPDATE_LOGIN = fnd_global.login_id,
294: SOURCE_LANG = userenv('LANG')
295: where resource_list_id = X_RESOURCE_LIST_ID
296: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
297: