APPS.PRP_TEMPLATE_CATGS_PKG dependencies on PRP_TEMPLATE_CATGS_TL

Line 88: insert into PRP_TEMPLATE_CATGS_TL (

84: X_LAST_UPDATED_BY,
85: X_LAST_UPDATE_LOGIN
86: );
87:
88: insert into PRP_TEMPLATE_CATGS_TL (
89: TEMPLATE_CATG_ID,
90: TEMPLATE_CATG_NAME,
91: TEMPLATE_CATG_DESC,
92: CREATED_BY,

Line 114: from PRP_TEMPLATE_CATGS_TL T

110: from FND_LANGUAGES L
111: where L.INSTALLED_FLAG in ('I', 'B')
112: and not exists
113: (select NULL
114: from PRP_TEMPLATE_CATGS_TL T
115: where T.TEMPLATE_CATG_ID = X_TEMPLATE_CATG_ID
116: and T.LANGUAGE = L.LANGUAGE_CODE);
117:
118: open c;

Line 179: from PRP_TEMPLATE_CATGS_TL

175: cursor c1 is select
176: TEMPLATE_CATG_NAME,
177: TEMPLATE_CATG_DESC,
178: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
179: from PRP_TEMPLATE_CATGS_TL
180: where TEMPLATE_CATG_ID = X_TEMPLATE_CATG_ID
181: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
182: for update of TEMPLATE_CATG_ID nowait;
183: begin

Line 304: update PRP_TEMPLATE_CATGS_TL set

300: if (sql%notfound) then
301: raise no_data_found;
302: end if;
303:
304: update PRP_TEMPLATE_CATGS_TL set
305: TEMPLATE_CATG_NAME = X_TEMPLATE_CATG_NAME,
306: TEMPLATE_CATG_DESC = X_TEMPLATE_CATG_DESC,
307: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
308: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 323: delete from PRP_TEMPLATE_CATGS_TL

319: procedure DELETE_ROW (
320: X_TEMPLATE_CATG_ID in NUMBER
321: ) is
322: begin
323: delete from PRP_TEMPLATE_CATGS_TL
324: where TEMPLATE_CATG_ID = X_TEMPLATE_CATG_ID;
325:
326: if (sql%notfound) then
327: raise no_data_found;

Line 341: delete from PRP_TEMPLATE_CATGS_TL T

337:
338: procedure ADD_LANGUAGE
339: is
340: begin
341: delete from PRP_TEMPLATE_CATGS_TL T
342: where not exists
343: (select NULL
344: from PRP_TEMPLATE_CATGS_B B
345: where B.TEMPLATE_CATG_ID = T.TEMPLATE_CATG_ID

Line 348: update PRP_TEMPLATE_CATGS_TL T set (

344: from PRP_TEMPLATE_CATGS_B B
345: where B.TEMPLATE_CATG_ID = T.TEMPLATE_CATG_ID
346: );
347:
348: update PRP_TEMPLATE_CATGS_TL T set (
349: TEMPLATE_CATG_NAME,
350: TEMPLATE_CATG_DESC
351: ) = (select
352: B.TEMPLATE_CATG_NAME,

Line 354: from PRP_TEMPLATE_CATGS_TL B

350: TEMPLATE_CATG_DESC
351: ) = (select
352: B.TEMPLATE_CATG_NAME,
353: B.TEMPLATE_CATG_DESC
354: from PRP_TEMPLATE_CATGS_TL B
355: where B.TEMPLATE_CATG_ID = T.TEMPLATE_CATG_ID
356: and B.LANGUAGE = T.SOURCE_LANG)
357: where (
358: T.TEMPLATE_CATG_ID,

Line 363: from PRP_TEMPLATE_CATGS_TL SUBB, PRP_TEMPLATE_CATGS_TL SUBT

359: T.LANGUAGE
360: ) in (select
361: SUBT.TEMPLATE_CATG_ID,
362: SUBT.LANGUAGE
363: from PRP_TEMPLATE_CATGS_TL SUBB, PRP_TEMPLATE_CATGS_TL SUBT
364: where SUBB.TEMPLATE_CATG_ID = SUBT.TEMPLATE_CATG_ID
365: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
366: and (SUBB.TEMPLATE_CATG_NAME <> SUBT.TEMPLATE_CATG_NAME
367: or SUBB.TEMPLATE_CATG_DESC <> SUBT.TEMPLATE_CATG_DESC

Line 372: insert into PRP_TEMPLATE_CATGS_TL (

368: or (SUBB.TEMPLATE_CATG_DESC is null and SUBT.TEMPLATE_CATG_DESC is not null)
369: or (SUBB.TEMPLATE_CATG_DESC is not null and SUBT.TEMPLATE_CATG_DESC is null)
370: ));
371:
372: insert into PRP_TEMPLATE_CATGS_TL (
373: TEMPLATE_CATG_ID,
374: TEMPLATE_CATG_NAME,
375: TEMPLATE_CATG_DESC,
376: CREATED_BY,

Line 394: from PRP_TEMPLATE_CATGS_TL B, FND_LANGUAGES L

390: B.LAST_UPDATE_DATE,
391: B.LAST_UPDATE_LOGIN,
392: L.LANGUAGE_CODE,
393: B.SOURCE_LANG
394: from PRP_TEMPLATE_CATGS_TL B, FND_LANGUAGES L
395: where L.INSTALLED_FLAG in ('I', 'B')
396: and B.LANGUAGE = userenv('LANG')
397: and not exists
398: (select NULL

Line 399: from PRP_TEMPLATE_CATGS_TL T

395: where L.INSTALLED_FLAG in ('I', 'B')
396: and B.LANGUAGE = userenv('LANG')
397: and not exists
398: (select NULL
399: from PRP_TEMPLATE_CATGS_TL T
400: where T.TEMPLATE_CATG_ID = B.TEMPLATE_CATG_ID
401: and T.LANGUAGE = L.LANGUAGE_CODE);
402: end ADD_LANGUAGE;
403: