APPS.IEC_P_VDU_PORT_PARAMS_PKG dependencies on IEC_P_VDU_PORT_PARAMS_TL

Line 55: insert into IEC_P_VDU_PORT_PARAMS_TL (

51: X_LAST_UPDATED_BY,
52: X_LAST_UPDATE_LOGIN
53: );
54:
55: insert into IEC_P_VDU_PORT_PARAMS_TL (
56: VDU_PORT_PARAM_ID,
57: CREATED_BY,
58: CREATION_DATE,
59: LAST_UPDATED_BY,

Line 81: from IEC_P_VDU_PORT_PARAMS_TL T

77: from FND_LANGUAGES L
78: where L.INSTALLED_FLAG in ('I', 'B')
79: and not exists
80: (select NULL
81: from IEC_P_VDU_PORT_PARAMS_TL T
82: where T.VDU_PORT_PARAM_ID = X_VDU_PORT_PARAM_ID
83: and T.LANGUAGE = L.LANGUAGE_CODE);
84:
85: open c;

Line 124: from IEC_P_VDU_PORT_PARAMS_TL

120: cursor c1 is select
121: PARAM_NAME,
122: PARAM_DESCRIPTION,
123: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
124: from IEC_P_VDU_PORT_PARAMS_TL
125: where VDU_PORT_PARAM_ID = X_VDU_PORT_PARAM_ID
126: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
127: for update of VDU_PORT_PARAM_ID nowait;
128: begin

Line 204: update IEC_P_VDU_PORT_PARAMS_TL set

200: if (sql%notfound) then
201: raise no_data_found;
202: end if;
203:
204: update IEC_P_VDU_PORT_PARAMS_TL set
205: PARAM_NAME = X_PARAM_NAME,
206: PARAM_DESCRIPTION = X_PARAM_DESCRIPTION,
207: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
208: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 223: delete from IEC_P_VDU_PORT_PARAMS_TL

219: procedure DELETE_ROW (
220: X_VDU_PORT_PARAM_ID in NUMBER
221: ) is
222: begin
223: delete from IEC_P_VDU_PORT_PARAMS_TL
224: where VDU_PORT_PARAM_ID = X_VDU_PORT_PARAM_ID;
225:
226: if (sql%notfound) then
227: raise no_data_found;

Line 241: delete from IEC_P_VDU_PORT_PARAMS_TL T

237:
238: procedure ADD_LANGUAGE
239: is
240: begin
241: delete from IEC_P_VDU_PORT_PARAMS_TL T
242: where not exists
243: (select NULL
244: from IEC_P_VDU_PORT_PARAMS_B B
245: where B.VDU_PORT_PARAM_ID = T.VDU_PORT_PARAM_ID

Line 248: update IEC_P_VDU_PORT_PARAMS_TL T set (

244: from IEC_P_VDU_PORT_PARAMS_B B
245: where B.VDU_PORT_PARAM_ID = T.VDU_PORT_PARAM_ID
246: );
247:
248: update IEC_P_VDU_PORT_PARAMS_TL T set (
249: PARAM_NAME,
250: PARAM_DESCRIPTION
251: ) = (select
252: B.PARAM_NAME,

Line 254: from IEC_P_VDU_PORT_PARAMS_TL B

250: PARAM_DESCRIPTION
251: ) = (select
252: B.PARAM_NAME,
253: B.PARAM_DESCRIPTION
254: from IEC_P_VDU_PORT_PARAMS_TL B
255: where B.VDU_PORT_PARAM_ID = T.VDU_PORT_PARAM_ID
256: and B.LANGUAGE = T.SOURCE_LANG)
257: where (
258: T.VDU_PORT_PARAM_ID,

Line 263: from IEC_P_VDU_PORT_PARAMS_TL SUBB, IEC_P_VDU_PORT_PARAMS_TL SUBT

259: T.LANGUAGE
260: ) in (select
261: SUBT.VDU_PORT_PARAM_ID,
262: SUBT.LANGUAGE
263: from IEC_P_VDU_PORT_PARAMS_TL SUBB, IEC_P_VDU_PORT_PARAMS_TL SUBT
264: where SUBB.VDU_PORT_PARAM_ID = SUBT.VDU_PORT_PARAM_ID
265: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
266: and (SUBB.PARAM_NAME <> SUBT.PARAM_NAME
267: or SUBB.PARAM_DESCRIPTION <> SUBT.PARAM_DESCRIPTION

Line 272: insert into IEC_P_VDU_PORT_PARAMS_TL (

268: or (SUBB.PARAM_DESCRIPTION is null and SUBT.PARAM_DESCRIPTION is not null)
269: or (SUBB.PARAM_DESCRIPTION is not null and SUBT.PARAM_DESCRIPTION is null)
270: ));
271:
272: insert into IEC_P_VDU_PORT_PARAMS_TL (
273: VDU_PORT_PARAM_ID,
274: CREATED_BY,
275: CREATION_DATE,
276: LAST_UPDATED_BY,

Line 294: from IEC_P_VDU_PORT_PARAMS_TL B, FND_LANGUAGES L

290: B.PARAM_NAME,
291: B.PARAM_DESCRIPTION,
292: L.LANGUAGE_CODE,
293: B.SOURCE_LANG
294: from IEC_P_VDU_PORT_PARAMS_TL B, FND_LANGUAGES L
295: where L.INSTALLED_FLAG in ('I', 'B')
296: and B.LANGUAGE = userenv('LANG')
297: and not exists
298: (select NULL

Line 299: from IEC_P_VDU_PORT_PARAMS_TL T

295: where L.INSTALLED_FLAG in ('I', 'B')
296: and B.LANGUAGE = userenv('LANG')
297: and not exists
298: (select NULL
299: from IEC_P_VDU_PORT_PARAMS_TL T
300: where T.VDU_PORT_PARAM_ID = B.VDU_PORT_PARAM_ID
301: and T.LANGUAGE = L.LANGUAGE_CODE);
302: end ADD_LANGUAGE;
303:

Line 370: update IEC_P_VDU_PORT_PARAMS_TL set

366: begin
367:
368: -- only UPDATE rows that have not been altered by user
369:
370: update IEC_P_VDU_PORT_PARAMS_TL set
371: PARAM_NAME = X_PARAM_NAME,
372: PARAM_DESCRIPTION = X_PARAM_DESCRIPTION,
373: SOURCE_LANG = userenv('LANG'),
374: LAST_UPDATE_DATE = SYSDATE,