APPS.IEC_P_RES_GRP_PARAMS_PKG dependencies on IEC_P_RES_GRP_PARAMS_TL

Line 58: insert into IEC_P_RES_GRP_PARAMS_TL (

54: X_LAST_UPDATED_BY,
55: X_LAST_UPDATE_LOGIN
56: );
57:
58: insert into IEC_P_RES_GRP_PARAMS_TL (
59: RES_GROUP_PARAM_ID,
60: CREATED_BY,
61: CREATION_DATE,
62: LAST_UPDATED_BY,

Line 84: from IEC_P_RES_GRP_PARAMS_TL T

80: from FND_LANGUAGES L
81: where L.INSTALLED_FLAG in ('I', 'B')
82: and not exists
83: (select NULL
84: from IEC_P_RES_GRP_PARAMS_TL T
85: where T.RES_GROUP_PARAM_ID = X_RES_GROUP_PARAM_ID
86: and T.LANGUAGE = L.LANGUAGE_CODE);
87:
88: open c;

Line 129: from IEC_P_RES_GRP_PARAMS_TL

125: cursor c1 is select
126: PARAM_NAME,
127: PARAM_DESCRIPTION,
128: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
129: from IEC_P_RES_GRP_PARAMS_TL
130: where RES_GROUP_PARAM_ID = X_RES_GROUP_PARAM_ID
131: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
132: for update of RES_GROUP_PARAM_ID nowait;
133: begin

Line 214: update IEC_P_RES_GRP_PARAMS_TL set

210: if (sql%notfound) then
211: raise no_data_found;
212: end if;
213:
214: update IEC_P_RES_GRP_PARAMS_TL set
215: PARAM_NAME = X_PARAM_NAME,
216: PARAM_DESCRIPTION = X_PARAM_DESCRIPTION,
217: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
218: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 233: delete from IEC_P_RES_GRP_PARAMS_TL

229: procedure DELETE_ROW (
230: X_RES_GROUP_PARAM_ID in NUMBER
231: ) is
232: begin
233: delete from IEC_P_RES_GRP_PARAMS_TL
234: where RES_GROUP_PARAM_ID = X_RES_GROUP_PARAM_ID;
235:
236: if (sql%notfound) then
237: raise no_data_found;

Line 251: delete from IEC_P_RES_GRP_PARAMS_TL T

247:
248: procedure ADD_LANGUAGE
249: is
250: begin
251: delete from IEC_P_RES_GRP_PARAMS_TL T
252: where not exists
253: (select NULL
254: from IEC_P_RES_GRP_PARAMS_B B
255: where B.RES_GROUP_PARAM_ID = T.RES_GROUP_PARAM_ID

Line 258: update IEC_P_RES_GRP_PARAMS_TL T set (

254: from IEC_P_RES_GRP_PARAMS_B B
255: where B.RES_GROUP_PARAM_ID = T.RES_GROUP_PARAM_ID
256: );
257:
258: update IEC_P_RES_GRP_PARAMS_TL T set (
259: PARAM_NAME,
260: PARAM_DESCRIPTION
261: ) = (select
262: B.PARAM_NAME,

Line 264: from IEC_P_RES_GRP_PARAMS_TL B

260: PARAM_DESCRIPTION
261: ) = (select
262: B.PARAM_NAME,
263: B.PARAM_DESCRIPTION
264: from IEC_P_RES_GRP_PARAMS_TL B
265: where B.RES_GROUP_PARAM_ID = T.RES_GROUP_PARAM_ID
266: and B.LANGUAGE = T.SOURCE_LANG)
267: where (
268: T.RES_GROUP_PARAM_ID,

Line 273: from IEC_P_RES_GRP_PARAMS_TL SUBB, IEC_P_RES_GRP_PARAMS_TL SUBT

269: T.LANGUAGE
270: ) in (select
271: SUBT.RES_GROUP_PARAM_ID,
272: SUBT.LANGUAGE
273: from IEC_P_RES_GRP_PARAMS_TL SUBB, IEC_P_RES_GRP_PARAMS_TL SUBT
274: where SUBB.RES_GROUP_PARAM_ID = SUBT.RES_GROUP_PARAM_ID
275: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
276: and (SUBB.PARAM_NAME <> SUBT.PARAM_NAME
277: or SUBB.PARAM_DESCRIPTION <> SUBT.PARAM_DESCRIPTION

Line 282: insert into IEC_P_RES_GRP_PARAMS_TL (

278: or (SUBB.PARAM_DESCRIPTION is null and SUBT.PARAM_DESCRIPTION is not null)
279: or (SUBB.PARAM_DESCRIPTION is not null and SUBT.PARAM_DESCRIPTION is null)
280: ));
281:
282: insert into IEC_P_RES_GRP_PARAMS_TL (
283: RES_GROUP_PARAM_ID,
284: CREATED_BY,
285: CREATION_DATE,
286: LAST_UPDATED_BY,

Line 304: from IEC_P_RES_GRP_PARAMS_TL B, FND_LANGUAGES L

300: B.PARAM_NAME,
301: B.PARAM_DESCRIPTION,
302: L.LANGUAGE_CODE,
303: B.SOURCE_LANG
304: from IEC_P_RES_GRP_PARAMS_TL B, FND_LANGUAGES L
305: where L.INSTALLED_FLAG in ('I', 'B')
306: and B.LANGUAGE = userenv('LANG')
307: and not exists
308: (select NULL

Line 309: from IEC_P_RES_GRP_PARAMS_TL T

305: where L.INSTALLED_FLAG in ('I', 'B')
306: and B.LANGUAGE = userenv('LANG')
307: and not exists
308: (select NULL
309: from IEC_P_RES_GRP_PARAMS_TL T
310: where T.RES_GROUP_PARAM_ID = B.RES_GROUP_PARAM_ID
311: and T.LANGUAGE = L.LANGUAGE_CODE);
312: end ADD_LANGUAGE;
313:

Line 384: update IEC_P_RES_GRP_PARAMS_TL set

380: begin
381:
382: -- only UPDATE rows that have not been altered by user
383:
384: update IEC_P_RES_GRP_PARAMS_TL set
385: PARAM_NAME = X_PARAM_NAME,
386: SOURCE_LANG = userenv('LANG'),
387: PARAM_DESCRIPTION = X_PARAM_DESCRIPTION,
388: LAST_UPDATE_DATE = SYSDATE,