APPS.AMS_PROD_TEMPLATE_PKG dependencies on AMS_PROD_TEMPLATES_TL

Line 7: delete from AMS_PROD_TEMPLATES_TL T

3:
4: procedure ADD_LANGUAGE
5: is
6: begin
7: delete from AMS_PROD_TEMPLATES_TL T
8: where not exists
9: (select NULL
10: from AMS_PROD_TEMPLATES_B B
11: where B.TEMPLATE_ID = T.TEMPLATE_ID

Line 14: update AMS_PROD_TEMPLATES_TL T set (

10: from AMS_PROD_TEMPLATES_B B
11: where B.TEMPLATE_ID = T.TEMPLATE_ID
12: );
13:
14: update AMS_PROD_TEMPLATES_TL T set (
15: TEMPLATE_NAME,
16: DESCRIPTION
17: ) = (select
18: B.TEMPLATE_NAME,

Line 20: from AMS_PROD_TEMPLATES_TL B

16: DESCRIPTION
17: ) = (select
18: B.TEMPLATE_NAME,
19: B.DESCRIPTION
20: from AMS_PROD_TEMPLATES_TL B
21: where B.TEMPLATE_ID = T.TEMPLATE_ID
22: and B.LANGUAGE = T.SOURCE_LANG)
23: where (
24: T.TEMPLATE_ID,

Line 29: from AMS_PROD_TEMPLATES_TL SUBB, AMS_PROD_TEMPLATES_TL SUBT

25: T.LANGUAGE
26: ) in (select
27: SUBT.TEMPLATE_ID,
28: SUBT.LANGUAGE
29: from AMS_PROD_TEMPLATES_TL SUBB, AMS_PROD_TEMPLATES_TL SUBT
30: where SUBB.template_ID = SUBT.template_ID
31: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
32: and (SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
33: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 38: insert into AMS_PROD_TEMPLATES_TL (

34: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
35: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
36: ));
37:
38: insert into AMS_PROD_TEMPLATES_TL (
39: template_ID,
40: LAST_UPDATE_DATE,
41: LAST_UPDATED_BY,
42: CREATION_DATE,

Line 60: from AMS_PROD_TEMPLATES_TL B, FND_LANGUAGES L

56: B.template_NAME,
57: B.DESCRIPTION,
58: L.LANGUAGE_CODE,
59: B.SOURCE_LANG
60: from AMS_PROD_TEMPLATES_TL B, FND_LANGUAGES L
61: where L.INSTALLED_FLAG in ('I', 'B')
62: and B.LANGUAGE = userenv('LANG')
63: and not exists
64: (select NULL

Line 65: from AMS_PROD_TEMPLATES_TL T

61: where L.INSTALLED_FLAG in ('I', 'B')
62: and B.LANGUAGE = userenv('LANG')
63: and not exists
64: (select NULL
65: from AMS_PROD_TEMPLATES_TL T
66: where T.template_ID = B.template_ID
67: and T.LANGUAGE = L.LANGUAGE_CODE);
68:
69: end ADD_LANGUAGE;

Line 79: update AMS_PROD_TEMPLATES_TL set

75: , x_description in VARCHAR2
76: , x_owner in VARCHAR2
77: ) is
78: begin
79: update AMS_PROD_TEMPLATES_TL set
80: template_name = nvl(x_template_name, template_name),
81: description = nvl(x_description, description),
82: source_lang = userenv('LANG'),
83: last_update_date = sysdate,

Line 174: INSERT INTO AMS_PROD_TEMPLATES_TL(

170: ,1
171: ,0
172: ,X_PRODUCT_SERVICE_FLAG);
173:
174: INSERT INTO AMS_PROD_TEMPLATES_TL(
175: template_id
176: ,language
177: ,source_lang
178: ,last_update_date

Line 200: FROM AMS_PROD_TEMPLATES_TL t

196: FROM fnd_languages l
197: WHERE l.installed_flag IN ('I','B')
198: AND NOT EXISTS(
199: SELECT NULL
200: FROM AMS_PROD_TEMPLATES_TL t
201: WHERE t.template_id = DECODE( l_template_id, FND_API.g_miss_num, NULL, l_template_id)
202: AND t.language = l.language_code ) ;
203:
204: else

Line 221: UPDATE AMS_PROD_TEMPLATES_TL

217: product_service_flag = X_PRODUCT_SERVICE_FLAG
218: WHERE TEMPLATE_ID = X_TEMPLATE_ID
219: AND object_version_number = l_obj_verno;
220:
221: UPDATE AMS_PROD_TEMPLATES_TL
222: SET template_name = X_TEMPLATE_NAME
223: ,description = X_DESCRIPTION
224: ,last_update_date = sysdate
225: ,last_updated_by = l_user_id