APPS.ENG_CHANGE_TEMPLATES_PKG dependencies on ENG_CHANGE_TEMPLATES_TL

Line 44: insert into ENG_CHANGE_TEMPLATES_TL (

40: X_LAST_UPDATED_BY,
41: X_LAST_UPDATE_LOGIN
42: );
43:
44: insert into ENG_CHANGE_TEMPLATES_TL (
45: CHANGE_TEMPLATE_ID,
46: TEMPLATE_NAME,
47: DESCRIPTION,
48: CREATION_DATE,

Line 70: from ENG_CHANGE_TEMPLATES_TL T

66: from FND_LANGUAGES L
67: where L.INSTALLED_FLAG in ('I', 'B')
68: and not exists
69: (select NULL
70: from ENG_CHANGE_TEMPLATES_TL T
71: where T.CHANGE_TEMPLATE_ID = X_CHANGE_TEMPLATE_ID
72: and T.LANGUAGE = L.LANGUAGE_CODE);
73:
74: open c;

Line 105: from ENG_CHANGE_TEMPLATES_TL

101: cursor c1 is select
102: TEMPLATE_NAME,
103: DESCRIPTION,
104: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
105: from ENG_CHANGE_TEMPLATES_TL
106: where CHANGE_TEMPLATE_ID = X_CHANGE_TEMPLATE_ID
107: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
108: for update of CHANGE_TEMPLATE_ID nowait;
109: begin

Line 171: update ENG_CHANGE_TEMPLATES_TL set

167: if (sql%notfound) then
168: raise no_data_found;
169: end if;
170:
171: update ENG_CHANGE_TEMPLATES_TL set
172: TEMPLATE_NAME = X_TEMPLATE_NAME,
173: DESCRIPTION = X_DESCRIPTION,
174: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
175: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 190: delete from ENG_CHANGE_TEMPLATES_TL

186: procedure DELETE_ROW (
187: X_CHANGE_TEMPLATE_ID in NUMBER
188: ) is
189: begin
190: delete from ENG_CHANGE_TEMPLATES_TL
191: where CHANGE_TEMPLATE_ID = X_CHANGE_TEMPLATE_ID;
192:
193: if (sql%notfound) then
194: raise no_data_found;

Line 208: delete from ENG_CHANGE_TEMPLATES_TL T

204:
205: procedure ADD_LANGUAGE
206: is
207: begin
208: delete from ENG_CHANGE_TEMPLATES_TL T
209: where not exists
210: (select NULL
211: from ENG_CHANGE_TEMPLATES_B B
212: where B.CHANGE_TEMPLATE_ID = T.CHANGE_TEMPLATE_ID

Line 215: update ENG_CHANGE_TEMPLATES_TL T set (

211: from ENG_CHANGE_TEMPLATES_B B
212: where B.CHANGE_TEMPLATE_ID = T.CHANGE_TEMPLATE_ID
213: );
214:
215: update ENG_CHANGE_TEMPLATES_TL T set (
216: TEMPLATE_NAME,
217: DESCRIPTION
218: ) = (select
219: B.TEMPLATE_NAME,

Line 221: from ENG_CHANGE_TEMPLATES_TL B

217: DESCRIPTION
218: ) = (select
219: B.TEMPLATE_NAME,
220: B.DESCRIPTION
221: from ENG_CHANGE_TEMPLATES_TL B
222: where B.CHANGE_TEMPLATE_ID = T.CHANGE_TEMPLATE_ID
223: and B.LANGUAGE = T.SOURCE_LANG)
224: where (
225: T.CHANGE_TEMPLATE_ID,

Line 230: from ENG_CHANGE_TEMPLATES_TL SUBB, ENG_CHANGE_TEMPLATES_TL SUBT

226: T.LANGUAGE
227: ) in (select
228: SUBT.CHANGE_TEMPLATE_ID,
229: SUBT.LANGUAGE
230: from ENG_CHANGE_TEMPLATES_TL SUBB, ENG_CHANGE_TEMPLATES_TL SUBT
231: where SUBB.CHANGE_TEMPLATE_ID = SUBT.CHANGE_TEMPLATE_ID
232: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
233: and (SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
234: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 239: insert into ENG_CHANGE_TEMPLATES_TL (

235: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
236: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
237: ));
238:
239: insert into ENG_CHANGE_TEMPLATES_TL (
240: CHANGE_TEMPLATE_ID,
241: TEMPLATE_NAME,
242: DESCRIPTION,
243: CREATION_DATE,

Line 261: from ENG_CHANGE_TEMPLATES_TL B, FND_LANGUAGES L

257: B.LAST_UPDATED_BY,
258: B.LAST_UPDATE_LOGIN,
259: L.LANGUAGE_CODE,
260: B.SOURCE_LANG
261: from ENG_CHANGE_TEMPLATES_TL B, FND_LANGUAGES L
262: where L.INSTALLED_FLAG in ('I', 'B')
263: and B.LANGUAGE = userenv('LANG')
264: and not exists
265: (select NULL

Line 266: from ENG_CHANGE_TEMPLATES_TL T

262: where L.INSTALLED_FLAG in ('I', 'B')
263: and B.LANGUAGE = userenv('LANG')
264: and not exists
265: (select NULL
266: from ENG_CHANGE_TEMPLATES_TL T
267: where T.CHANGE_TEMPLATE_ID = B.CHANGE_TEMPLATE_ID
268: and T.LANGUAGE = L.LANGUAGE_CODE);
269: end ADD_LANGUAGE;
270: