APPS.PRP_TEMPLATES_PKG dependencies on PRP_TEMPLATES_TL

Line 94: insert into PRP_TEMPLATES_TL (

90: X_LAST_UPDATED_BY,
91: X_LAST_UPDATE_LOGIN
92: );
93:
94: insert into PRP_TEMPLATES_TL (
95: TEMPLATE_NAME,
96: TEMPLATE_DESC,
97: CREATED_BY,
98: CREATION_DATE,

Line 120: from PRP_TEMPLATES_TL T

116: from FND_LANGUAGES L
117: where L.INSTALLED_FLAG in ('I', 'B')
118: and not exists
119: (select NULL
120: from PRP_TEMPLATES_TL T
121: where T.TEMPLATE_ID = X_TEMPLATE_ID
122: and T.LANGUAGE = L.LANGUAGE_CODE);
123:
124: open c;

Line 189: from PRP_TEMPLATES_TL

185: cursor c1 is select
186: TEMPLATE_NAME,
187: TEMPLATE_DESC,
188: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
189: from PRP_TEMPLATES_TL
190: where TEMPLATE_ID = X_TEMPLATE_ID
191: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
192: for update of TEMPLATE_ID nowait;
193: begin

Line 321: update PRP_TEMPLATES_TL set

317: if (sql%notfound) then
318: raise no_data_found;
319: end if;
320:
321: update PRP_TEMPLATES_TL set
322: TEMPLATE_NAME = X_TEMPLATE_NAME,
323: TEMPLATE_DESC = X_TEMPLATE_DESC,
324: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
325: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 340: delete from PRP_TEMPLATES_TL

336: procedure DELETE_ROW (
337: X_TEMPLATE_ID in NUMBER
338: ) is
339: begin
340: delete from PRP_TEMPLATES_TL
341: where TEMPLATE_ID = X_TEMPLATE_ID;
342:
343: if (sql%notfound) then
344: raise no_data_found;

Line 358: delete from PRP_TEMPLATES_TL T

354:
355: procedure ADD_LANGUAGE
356: is
357: begin
358: delete from PRP_TEMPLATES_TL T
359: where not exists
360: (select NULL
361: from PRP_TEMPLATES_B B
362: where B.TEMPLATE_ID = T.TEMPLATE_ID

Line 365: update PRP_TEMPLATES_TL T set (

361: from PRP_TEMPLATES_B B
362: where B.TEMPLATE_ID = T.TEMPLATE_ID
363: );
364:
365: update PRP_TEMPLATES_TL T set (
366: TEMPLATE_NAME,
367: TEMPLATE_DESC
368: ) = (select
369: B.TEMPLATE_NAME,

Line 371: from PRP_TEMPLATES_TL B

367: TEMPLATE_DESC
368: ) = (select
369: B.TEMPLATE_NAME,
370: B.TEMPLATE_DESC
371: from PRP_TEMPLATES_TL B
372: where B.TEMPLATE_ID = T.TEMPLATE_ID
373: and B.LANGUAGE = T.SOURCE_LANG)
374: where (
375: T.TEMPLATE_ID,

Line 380: from PRP_TEMPLATES_TL SUBB, PRP_TEMPLATES_TL SUBT

376: T.LANGUAGE
377: ) in (select
378: SUBT.TEMPLATE_ID,
379: SUBT.LANGUAGE
380: from PRP_TEMPLATES_TL SUBB, PRP_TEMPLATES_TL SUBT
381: where SUBB.TEMPLATE_ID = SUBT.TEMPLATE_ID
382: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
383: and (SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
384: or SUBB.TEMPLATE_DESC <> SUBT.TEMPLATE_DESC

Line 389: insert into PRP_TEMPLATES_TL (

385: or (SUBB.TEMPLATE_DESC is null and SUBT.TEMPLATE_DESC is not null)
386: or (SUBB.TEMPLATE_DESC is not null and SUBT.TEMPLATE_DESC is null)
387: ));
388:
389: insert into PRP_TEMPLATES_TL (
390: TEMPLATE_NAME,
391: TEMPLATE_DESC,
392: CREATED_BY,
393: CREATION_DATE,

Line 411: from PRP_TEMPLATES_TL B, FND_LANGUAGES L

407: B.LAST_UPDATE_LOGIN,
408: B.TEMPLATE_ID,
409: L.LANGUAGE_CODE,
410: B.SOURCE_LANG
411: from PRP_TEMPLATES_TL B, FND_LANGUAGES L
412: where L.INSTALLED_FLAG in ('I', 'B')
413: and B.LANGUAGE = userenv('LANG')
414: and not exists
415: (select NULL

Line 416: from PRP_TEMPLATES_TL T

412: where L.INSTALLED_FLAG in ('I', 'B')
413: and B.LANGUAGE = userenv('LANG')
414: and not exists
415: (select NULL
416: from PRP_TEMPLATES_TL T
417: where T.TEMPLATE_ID = B.TEMPLATE_ID
418: and T.LANGUAGE = L.LANGUAGE_CODE);
419: end ADD_LANGUAGE;
420: