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,
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:
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
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,
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,
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,
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);
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: