43: P_CLASS_NAME,
44: P_IMAGE_FILE_NAME,
45: P_AUDIO_FILE_NAME,
46: SYSDATE,
47: FND_GLOBAL.USER_ID,
48: SYSDATE,
49: FND_GLOBAL.USER_ID,
50: FND_GLOBAL.LOGIN_ID
51: );
45: P_AUDIO_FILE_NAME,
46: SYSDATE,
47: FND_GLOBAL.USER_ID,
48: SYSDATE,
49: FND_GLOBAL.USER_ID,
50: FND_GLOBAL.LOGIN_ID
51: );
52:
53: insert into IEU_CTL_PLUGINS_TL (
46: SYSDATE,
47: FND_GLOBAL.USER_ID,
48: SYSDATE,
49: FND_GLOBAL.USER_ID,
50: FND_GLOBAL.LOGIN_ID
51: );
52:
53: insert into IEU_CTL_PLUGINS_TL (
54: CREATION_DATE,
63: LANGUAGE,
64: SOURCE_LANG
65: ) select
66: SYSDATE,
67: FND_GLOBAL.USER_ID,
68: SYSDATE,
69: FND_GLOBAL.USER_ID,
70: P_PLUGIN_ID,
71: P_OBJECT_VERSION_NUMBER,
65: ) select
66: SYSDATE,
67: FND_GLOBAL.USER_ID,
68: SYSDATE,
69: FND_GLOBAL.USER_ID,
70: P_PLUGIN_ID,
71: P_OBJECT_VERSION_NUMBER,
72: P_DESCRIPTION,
73: FND_GLOBAL.LOGIN_ID,
69: FND_GLOBAL.USER_ID,
70: P_PLUGIN_ID,
71: P_OBJECT_VERSION_NUMBER,
72: P_DESCRIPTION,
73: FND_GLOBAL.LOGIN_ID,
74: P_NAME,
75: L.LANGUAGE_CODE,
76: userenv('LANG')
77: from FND_LANGUAGES L
194: CLASS_NAME = P_CLASS_NAME,
195: IMAGE_FILE_NAME = P_IMAGE_FILE_NAME,
196: AUDIO_FILE_NAME = P_AUDIO_FILE_NAME,
197: LAST_UPDATE_DATE = SYSDATE,
198: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
199: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
200: where PLUGIN_ID = P_PLUGIN_ID;
201:
202: if (sql%notfound) then
195: IMAGE_FILE_NAME = P_IMAGE_FILE_NAME,
196: AUDIO_FILE_NAME = P_AUDIO_FILE_NAME,
197: LAST_UPDATE_DATE = SYSDATE,
198: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
199: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
200: where PLUGIN_ID = P_PLUGIN_ID;
201:
202: if (sql%notfound) then
203: raise no_data_found;
206: update IEU_CTL_PLUGINS_TL set
207: NAME = P_NAME,
208: DESCRIPTION = P_DESCRIPTION,
209: LAST_UPDATE_DATE = SYSDATE,
210: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
211: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
212: SOURCE_LANG = userenv('LANG')
213: where PLUGIN_ID = P_PLUGIN_ID
214: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
207: NAME = P_NAME,
208: DESCRIPTION = P_DESCRIPTION,
209: LAST_UPDATE_DATE = SYSDATE,
210: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
211: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
212: SOURCE_LANG = userenv('LANG')
213: where PLUGIN_ID = P_PLUGIN_ID
214: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
215: