APPS.IEC_P_RES_GRP_CAPS_PKG dependencies on IEC_P_RES_GRP_CAPS_TL

Line 46: insert into IEC_P_RES_GRP_CAPS_TL (

42: X_LAST_UPDATED_BY,
43: X_LAST_UPDATE_LOGIN
44: );
45:
46: insert into IEC_P_RES_GRP_CAPS_TL (
47: RES_GROUP_CAP_ID,
48: CREATED_BY,
49: CREATION_DATE,
50: LAST_UPDATED_BY,

Line 72: from IEC_P_RES_GRP_CAPS_TL T

68: from FND_LANGUAGES L
69: where L.INSTALLED_FLAG in ('I', 'B')
70: and not exists
71: (select NULL
72: from IEC_P_RES_GRP_CAPS_TL T
73: where T.RES_GROUP_CAP_ID = X_RES_GROUP_CAP_ID
74: and T.LANGUAGE = L.LANGUAGE_CODE);
75: open c;
76: fetch c into X_ROWID;

Line 110: from IEC_P_RES_GRP_CAPS_TL

106: cursor c1 is select
107: CAP_NAME,
108: CAP_DESCRIPTION,
109: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
110: from IEC_P_RES_GRP_CAPS_TL
111: where RES_GROUP_CAP_ID = X_RES_GROUP_CAP_ID
112: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
113: for update of RES_GROUP_CAP_ID nowait;
114: begin

Line 179: update IEC_P_RES_GRP_CAPS_TL set

175: if (sql%notfound) then
176: raise no_data_found;
177: end if;
178:
179: update IEC_P_RES_GRP_CAPS_TL set
180: CAP_NAME = X_CAP_NAME,
181: CAP_DESCRIPTION = X_CAP_DESCRIPTION,
182: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
183: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 198: delete from IEC_P_RES_GRP_CAPS_TL

194: procedure DELETE_ROW (
195: X_RES_GROUP_CAP_ID in NUMBER
196: ) is
197: begin
198: delete from IEC_P_RES_GRP_CAPS_TL
199: where RES_GROUP_CAP_ID = X_RES_GROUP_CAP_ID;
200:
201: if (sql%notfound) then
202: raise no_data_found;

Line 262: delete from IEC_P_RES_GRP_CAPS_TL T

258:
259: procedure ADD_LANGUAGE
260: is
261: begin
262: delete from IEC_P_RES_GRP_CAPS_TL T
263: where not exists
264: (select NULL
265: from IEC_P_RES_GRP_CAPS_B B
266: where B.RES_GROUP_CAP_ID = T.RES_GROUP_CAP_ID

Line 269: update IEC_P_RES_GRP_CAPS_TL T set (

265: from IEC_P_RES_GRP_CAPS_B B
266: where B.RES_GROUP_CAP_ID = T.RES_GROUP_CAP_ID
267: );
268:
269: update IEC_P_RES_GRP_CAPS_TL T set (
270: CAP_NAME,
271: CAP_DESCRIPTION
272: ) = (select
273: B.CAP_NAME,

Line 275: from IEC_P_RES_GRP_CAPS_TL B

271: CAP_DESCRIPTION
272: ) = (select
273: B.CAP_NAME,
274: B.CAP_DESCRIPTION
275: from IEC_P_RES_GRP_CAPS_TL B
276: where B.RES_GROUP_CAP_ID = T.RES_GROUP_CAP_ID
277: and B.LANGUAGE = T.SOURCE_LANG)
278: where (
279: T.RES_GROUP_CAP_ID,

Line 284: from IEC_P_RES_GRP_CAPS_TL SUBB, IEC_P_RES_GRP_CAPS_TL SUBT

280: T.LANGUAGE
281: ) in (select
282: SUBT.RES_GROUP_CAP_ID,
283: SUBT.LANGUAGE
284: from IEC_P_RES_GRP_CAPS_TL SUBB, IEC_P_RES_GRP_CAPS_TL SUBT
285: where SUBB.RES_GROUP_CAP_ID = SUBT.RES_GROUP_CAP_ID
286: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
287: and (SUBB.CAP_NAME <> SUBT.CAP_NAME
288: or SUBB.CAP_DESCRIPTION <> SUBT.CAP_DESCRIPTION

Line 293: insert into IEC_P_RES_GRP_CAPS_TL (

289: or (SUBB.CAP_DESCRIPTION is null and SUBT.CAP_DESCRIPTION is not null)
290: or (SUBB.CAP_DESCRIPTION is not null and SUBT.CAP_DESCRIPTION is null)
291: ));
292:
293: insert into IEC_P_RES_GRP_CAPS_TL (
294: RES_GROUP_CAP_ID,
295: CREATED_BY,
296: CREATION_DATE,
297: LAST_UPDATED_BY,

Line 315: from IEC_P_RES_GRP_CAPS_TL B, FND_LANGUAGES L

311: B.CAP_NAME,
312: B.CAP_DESCRIPTION,
313: L.LANGUAGE_CODE,
314: B.SOURCE_LANG
315: from IEC_P_RES_GRP_CAPS_TL B, FND_LANGUAGES L
316: where L.INSTALLED_FLAG in ('I', 'B')
317: and B.LANGUAGE = userenv('LANG')
318: and not exists
319: (select NULL

Line 320: from IEC_P_RES_GRP_CAPS_TL T

316: where L.INSTALLED_FLAG in ('I', 'B')
317: and B.LANGUAGE = userenv('LANG')
318: and not exists
319: (select NULL
320: from IEC_P_RES_GRP_CAPS_TL T
321: where T.RES_GROUP_CAP_ID = B.RES_GROUP_CAP_ID
322: and T.LANGUAGE = L.LANGUAGE_CODE);
323: end ADD_LANGUAGE;
324:

Line 335: update IEC_P_RES_GRP_CAPS_TL set

331: begin
332:
333: -- only UPDATE rows that have not been altered by user
334:
335: update IEC_P_RES_GRP_CAPS_TL set
336: CAP_NAME = X_CAP_NAME,
337: SOURCE_LANG = userenv('LANG'),
338: CAP_DESCRIPTION = X_CAP_DESCRIPTION,
339: LAST_UPDATE_DATE = SYSDATE,