APPS.PA_UTIL_CATEGORIES_PKG dependencies on PA_UTIL_CATEGORIES_TL

Line 91: insert into PA_UTIL_CATEGORIES_TL (

87: X_LAST_UPDATED_BY,
88: X_LAST_UPDATE_LOGIN
89: );
90:
91: insert into PA_UTIL_CATEGORIES_TL (
92: UTIL_CATEGORY_ID,
93: NAME,
94: DESCRIPTION,
95: CREATION_DATE,

Line 117: from PA_UTIL_CATEGORIES_TL T

113: from FND_LANGUAGES L
114: where L.INSTALLED_FLAG in ('I', 'B')
115: and not exists
116: (select NULL
117: from PA_UTIL_CATEGORIES_TL T
118: where T.UTIL_CATEGORY_ID = X_UTIL_CATEGORY_ID
119: and T.LANGUAGE = L.LANGUAGE_CODE);
120:
121: open c;

Line 184: from PA_UTIL_CATEGORIES_TL

180: cursor c1 is select
181: NAME,
182: DESCRIPTION,
183: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
184: from PA_UTIL_CATEGORIES_TL
185: where UTIL_CATEGORY_ID = X_UTIL_CATEGORY_ID
186: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
187: for update of UTIL_CATEGORY_ID nowait;
188: begin

Line 313: update PA_UTIL_CATEGORIES_TL set

309: if (sql%notfound) then
310: raise no_data_found;
311: end if;
312:
313: update PA_UTIL_CATEGORIES_TL set
314: NAME = X_NAME,
315: DESCRIPTION = X_DESCRIPTION,
316: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
317: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 332: delete from PA_UTIL_CATEGORIES_TL

328: procedure DELETE_ROW (
329: X_UTIL_CATEGORY_ID in NUMBER
330: ) is
331: begin
332: delete from PA_UTIL_CATEGORIES_TL
333: where UTIL_CATEGORY_ID = X_UTIL_CATEGORY_ID;
334:
335: if (sql%notfound) then
336: raise no_data_found;

Line 350: delete from PA_UTIL_CATEGORIES_TL T

346:
347: procedure ADD_LANGUAGE
348: is
349: begin
350: delete from PA_UTIL_CATEGORIES_TL T
351: where not exists
352: (select NULL
353: from PA_UTIL_CATEGORIES_B B
354: where B.UTIL_CATEGORY_ID = T.UTIL_CATEGORY_ID

Line 357: update PA_UTIL_CATEGORIES_TL T set (

353: from PA_UTIL_CATEGORIES_B B
354: where B.UTIL_CATEGORY_ID = T.UTIL_CATEGORY_ID
355: );
356:
357: update PA_UTIL_CATEGORIES_TL T set (
358: NAME,
359: DESCRIPTION
360: ) = (select
361: B.NAME,

Line 363: from PA_UTIL_CATEGORIES_TL B

359: DESCRIPTION
360: ) = (select
361: B.NAME,
362: B.DESCRIPTION
363: from PA_UTIL_CATEGORIES_TL B
364: where B.UTIL_CATEGORY_ID = T.UTIL_CATEGORY_ID
365: and B.LANGUAGE = T.SOURCE_LANG)
366: where (
367: T.UTIL_CATEGORY_ID,

Line 372: from PA_UTIL_CATEGORIES_TL SUBB, PA_UTIL_CATEGORIES_TL SUBT

368: T.LANGUAGE
369: ) in (select
370: SUBT.UTIL_CATEGORY_ID,
371: SUBT.LANGUAGE
372: from PA_UTIL_CATEGORIES_TL SUBB, PA_UTIL_CATEGORIES_TL SUBT
373: where SUBB.UTIL_CATEGORY_ID = SUBT.UTIL_CATEGORY_ID
374: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
375: and (SUBB.NAME <> SUBT.NAME
376: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 381: insert into PA_UTIL_CATEGORIES_TL (

377: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
378: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
379: ));
380:
381: insert into PA_UTIL_CATEGORIES_TL (
382: UTIL_CATEGORY_ID,
383: NAME,
384: DESCRIPTION,
385: CREATION_DATE,

Line 403: from PA_UTIL_CATEGORIES_TL B, FND_LANGUAGES L

399: B.LAST_UPDATED_BY,
400: B.LAST_UPDATE_LOGIN,
401: L.LANGUAGE_CODE,
402: B.SOURCE_LANG
403: from PA_UTIL_CATEGORIES_TL B, FND_LANGUAGES L
404: where L.INSTALLED_FLAG in ('I', 'B')
405: and B.LANGUAGE = userenv('LANG')
406: and not exists
407: (select NULL

Line 408: from PA_UTIL_CATEGORIES_TL T

404: where L.INSTALLED_FLAG in ('I', 'B')
405: and B.LANGUAGE = userenv('LANG')
406: and not exists
407: (select NULL
408: from PA_UTIL_CATEGORIES_TL T
409: where T.UTIL_CATEGORY_ID = B.UTIL_CATEGORY_ID
410: and T.LANGUAGE = L.LANGUAGE_CODE);
411: end ADD_LANGUAGE;
412: