DBA Data[Home] [Help]

APPS.PA_RESOURCE_LIST_TBL_PKG dependencies on FND_GLOBAL

Line 96: FND_GLOBAL.USER_ID,

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

Line 99: FND_GLOBAL.USER_ID,

95: P_MIGRATION_CODE,
96: FND_GLOBAL.USER_ID,
97: SYSDATE,
98: SYSDATE,
99: FND_GLOBAL.USER_ID,
100: FND_GLOBAL.LOGIN_ID,
101: 1
102: );
103:

Line 100: FND_GLOBAL.LOGIN_ID,

96: FND_GLOBAL.USER_ID,
97: SYSDATE,
98: SYSDATE,
99: FND_GLOBAL.USER_ID,
100: FND_GLOBAL.LOGIN_ID,
101: 1
102: );
103:
104: --Checks for failure of Insert stmt

Line 205: FND_GLOBAL.LOGIN_ID,

201: DESCRIPTION,
202: LANGUAGE,
203: SOURCE_LANG
204: ) select
205: FND_GLOBAL.LOGIN_ID,
206: sysdate,
207: FND_GLOBAL.USER_ID,
208: sysdate,
209: FND_GLOBAL.USER_ID,

Line 207: FND_GLOBAL.USER_ID,

203: SOURCE_LANG
204: ) select
205: FND_GLOBAL.LOGIN_ID,
206: sysdate,
207: FND_GLOBAL.USER_ID,
208: sysdate,
209: FND_GLOBAL.USER_ID,
210: X_RESOURCE_LIST_ID,
211: X_NAME,

Line 209: FND_GLOBAL.USER_ID,

205: FND_GLOBAL.LOGIN_ID,
206: sysdate,
207: FND_GLOBAL.USER_ID,
208: sysdate,
209: FND_GLOBAL.USER_ID,
210: X_RESOURCE_LIST_ID,
211: X_NAME,
212: NVL(X_DESCRIPTION,X_NAME),
213: L.LANGUAGE_CODE,

Line 289: LAST_UPDATED_BY = fnd_global.user_id,

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

Line 290: LAST_UPDATE_LOGIN = fnd_global.login_id,

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