APPS.CS_TP_TEMPLATES_PKG dependencies on CS_TP_TEMPLATES_TL

Line 123: insert into CS_TP_TEMPLATES_TL (

119: X_LAST_UPDATED_BY,
120: X_LAST_UPDATE_LOGIN
121: );
122:
123: insert into CS_TP_TEMPLATES_TL (
124: TEMPLATE_ID,
125: NAME,
126: DESCRIPTION,
127: CREATION_DATE,

Line 149: from CS_TP_TEMPLATES_TL T

145: from FND_LANGUAGES L
146: where L.INSTALLED_FLAG in ('I', 'B')
147: and not exists
148: (select NULL
149: from CS_TP_TEMPLATES_TL T
150: where T.TEMPLATE_ID = X_TEMPLATE_ID
151: and T.LANGUAGE = L.LANGUAGE_CODE);
152:
153: open c;

Line 224: from CS_TP_TEMPLATES_TL

220: cursor c1 is select
221: NAME,
222: DESCRIPTION,
223: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
224: from CS_TP_TEMPLATES_TL
225: where TEMPLATE_ID = X_TEMPLATE_ID
226: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
227: for update of TEMPLATE_ID nowait;
228: begin

Line 421: update CS_TP_TEMPLATES_TL set

417: if (sql%notfound) then
418: raise no_data_found;
419: end if;
420:
421: update CS_TP_TEMPLATES_TL set
422: NAME = decode(nvl(X_NAME, fnd_api.g_miss_char),
423: fnd_api.g_miss_char, name, x_name),
424: DESCRIPTION = decode(nvl(X_DESCRIPTION, fnd_api.g_miss_char),
425: fnd_api.g_miss_char, description, x_description),

Line 445: delete from CS_TP_TEMPLATES_TL

441: procedure DELETE_ROW (
442: X_TEMPLATE_ID in NUMBER
443: ) is
444: begin
445: delete from CS_TP_TEMPLATES_TL
446: where TEMPLATE_ID = X_TEMPLATE_ID;
447:
448: if (sql%notfound) then
449: raise no_data_found;

Line 463: delete from CS_TP_TEMPLATES_TL T

459:
460: procedure ADD_LANGUAGE
461: is
462: begin
463: delete from CS_TP_TEMPLATES_TL T
464: where not exists
465: (select NULL
466: from CS_TP_TEMPLATES_B B
467: where B.TEMPLATE_ID = T.TEMPLATE_ID

Line 470: update CS_TP_TEMPLATES_TL T set (

466: from CS_TP_TEMPLATES_B B
467: where B.TEMPLATE_ID = T.TEMPLATE_ID
468: );
469:
470: update CS_TP_TEMPLATES_TL T set (
471: NAME,
472: DESCRIPTION
473: ) = (select
474: B.NAME,

Line 476: from CS_TP_TEMPLATES_TL B

472: DESCRIPTION
473: ) = (select
474: B.NAME,
475: B.DESCRIPTION
476: from CS_TP_TEMPLATES_TL B
477: where B.TEMPLATE_ID = T.TEMPLATE_ID
478: and B.LANGUAGE = T.SOURCE_LANG)
479: where (
480: T.TEMPLATE_ID,

Line 485: from CS_TP_TEMPLATES_TL SUBB, CS_TP_TEMPLATES_TL SUBT

481: T.LANGUAGE
482: ) in (select
483: SUBT.TEMPLATE_ID,
484: SUBT.LANGUAGE
485: from CS_TP_TEMPLATES_TL SUBB, CS_TP_TEMPLATES_TL SUBT
486: where SUBB.TEMPLATE_ID = SUBT.TEMPLATE_ID
487: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
488: and (SUBB.NAME <> SUBT.NAME
489: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 494: insert into CS_TP_TEMPLATES_TL (

490: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
491: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
492: ));
493:
494: insert into CS_TP_TEMPLATES_TL (
495: TEMPLATE_ID,
496: NAME,
497: DESCRIPTION,
498: CREATION_DATE,

Line 516: from CS_TP_TEMPLATES_TL B, FND_LANGUAGES L

512: B.LAST_UPDATED_BY,
513: B.LAST_UPDATE_LOGIN,
514: L.LANGUAGE_CODE,
515: B.SOURCE_LANG
516: from CS_TP_TEMPLATES_TL B, FND_LANGUAGES L
517: where L.INSTALLED_FLAG in ('I', 'B')
518: and B.LANGUAGE = userenv('LANG')
519: and not exists
520: (select NULL

Line 521: from CS_TP_TEMPLATES_TL T

517: where L.INSTALLED_FLAG in ('I', 'B')
518: and B.LANGUAGE = userenv('LANG')
519: and not exists
520: (select NULL
521: from CS_TP_TEMPLATES_TL T
522: where T.TEMPLATE_ID = B.TEMPLATE_ID
523: and T.LANGUAGE = L.LANGUAGE_CODE);
524: end ADD_LANGUAGE;
525:

Line 604: update CS_TP_TEMPLATES_TL set

600: l_name := x_name;
601: l_description := x_description;
602:
603: -- Update translated portions for specified language
604: update CS_TP_TEMPLATES_TL set
605: name = l_name,
606: description = l_description,
607: last_update_date = sysdate,
608: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),