APPS.MTL_ITEM_TEMPLATES_PKG dependencies on MTL_ITEM_TEMPLATES_TL

Line 114: INSERT INTO MTL_ITEM_TEMPLATES_TL (

110: P_Item_Templates_Rec.GLOBAL_ATTRIBUTE20
111: )
112: RETURNING ROWID INTO X_ROWID;
113:
114: INSERT INTO MTL_ITEM_TEMPLATES_TL (
115: TEMPLATE_ID,
116: TEMPLATE_NAME,
117: DESCRIPTION,
118: CREATION_DATE,

Line 138: FROM MTL_ITEM_TEMPLATES_TL T

134: USERENV('LANG')
135: FROM FND_LANGUAGES L
136: WHERE L.INSTALLED_FLAG in ('I', 'B')
137: AND NOT EXISTS (SELECT NULL
138: FROM MTL_ITEM_TEMPLATES_TL T
139: WHERE T.TEMPLATE_ID = P_Item_Templates_Rec.TEMPLATE_ID
140: AND T.LANGUAGE = L.LANGUAGE_CODE);
141: END INSERT_ROW;
142:

Line 173: FROM MTL_ITEM_TEMPLATES_TL

169: SELECT
170: TEMPLATE_NAME,
171: DESCRIPTION,
172: DECODE(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
173: FROM MTL_ITEM_TEMPLATES_TL
174: WHERE TEMPLATE_ID = P_Item_Templates_Rec.TEMPLATE_ID
175: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
176:
177: recinfo c_get_item_templates%rowtype;

Line 316: UPDATE MTL_ITEM_TEMPLATES_TL set

312: IF (SQL%NOTFOUND) THEN
313: RAISE NO_DATA_FOUND;
314: END IF;
315:
316: UPDATE MTL_ITEM_TEMPLATES_TL set
317: TEMPLATE_NAME = P_Item_Templates_Rec.TEMPLATE_NAME,
318: DESCRIPTION = P_Item_Templates_Rec.DESCRIPTION,
319: LAST_UPDATE_DATE = P_Item_Templates_Rec.LAST_UPDATE_DATE,
320: LAST_UPDATED_BY = P_Item_Templates_Rec.LAST_UPDATED_BY,

Line 339: DELETE FROM MTL_ITEM_TEMPLATES_TL

335:
336: PROCEDURE DELETE_ROW (P_Template_Id IN NUMBER) IS
337: BEGIN
338:
339: DELETE FROM MTL_ITEM_TEMPLATES_TL
340: WHERE TEMPLATE_ID = P_Template_Id;
341:
342: IF (SQL%NOTFOUND) THEN
343: RAISE NO_DATA_FOUND;

Line 360: DELETE FROM MTL_ITEM_TEMPLATES_TL T

356: END DELETE_ROW;
357:
358: PROCEDURE ADD_LANGUAGE IS
359: BEGIN
360: DELETE FROM MTL_ITEM_TEMPLATES_TL T
361: WHERE NOT EXISTS(SELECT NULL
362: FROM MTL_ITEM_TEMPLATES_B B
363: WHERE B.TEMPLATE_ID = T.TEMPLATE_ID);
364:

Line 365: UPDATE MTL_ITEM_TEMPLATES_TL T

361: WHERE NOT EXISTS(SELECT NULL
362: FROM MTL_ITEM_TEMPLATES_B B
363: WHERE B.TEMPLATE_ID = T.TEMPLATE_ID);
364:
365: UPDATE MTL_ITEM_TEMPLATES_TL T
366: SET (TEMPLATE_NAME,DESCRIPTION) = (SELECT B.TEMPLATE_NAME,B.DESCRIPTION
367: FROM MTL_ITEM_TEMPLATES_TL B
368: WHERE B.TEMPLATE_ID = T.TEMPLATE_ID
369: AND B.LANGUAGE = T.SOURCE_LANG)

Line 367: FROM MTL_ITEM_TEMPLATES_TL B

363: WHERE B.TEMPLATE_ID = T.TEMPLATE_ID);
364:
365: UPDATE MTL_ITEM_TEMPLATES_TL T
366: SET (TEMPLATE_NAME,DESCRIPTION) = (SELECT B.TEMPLATE_NAME,B.DESCRIPTION
367: FROM MTL_ITEM_TEMPLATES_TL B
368: WHERE B.TEMPLATE_ID = T.TEMPLATE_ID
369: AND B.LANGUAGE = T.SOURCE_LANG)
370: WHERE (T.TEMPLATE_ID,
371: T.LANGUAGE) IN (SELECT SUBT.TEMPLATE_ID,

Line 373: FROM MTL_ITEM_TEMPLATES_TL SUBT,

369: AND B.LANGUAGE = T.SOURCE_LANG)
370: WHERE (T.TEMPLATE_ID,
371: T.LANGUAGE) IN (SELECT SUBT.TEMPLATE_ID,
372: SUBT.LANGUAGE
373: FROM MTL_ITEM_TEMPLATES_TL SUBT,
374: MTL_ITEM_TEMPLATES_TL SUBB
375: WHERE SUBB.TEMPLATE_ID = SUBT.TEMPLATE_ID
376: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
377: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 374: MTL_ITEM_TEMPLATES_TL SUBB

370: WHERE (T.TEMPLATE_ID,
371: T.LANGUAGE) IN (SELECT SUBT.TEMPLATE_ID,
372: SUBT.LANGUAGE
373: FROM MTL_ITEM_TEMPLATES_TL SUBT,
374: MTL_ITEM_TEMPLATES_TL SUBB
375: WHERE SUBB.TEMPLATE_ID = SUBT.TEMPLATE_ID
376: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
377: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
378: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 384: INSERT INTO MTL_ITEM_TEMPLATES_TL (

380: AND (SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
381: or (SUBB.TEMPLATE_NAME is null and SUBT.TEMPLATE_NAME is not null)
382: or (SUBB.TEMPLATE_NAME is not null and SUBT.TEMPLATE_NAME is null)));
383:
384: INSERT INTO MTL_ITEM_TEMPLATES_TL (
385: TEMPLATE_ID,
386: TEMPLATE_NAME,
387: DESCRIPTION,
388: CREATION_DATE,

Line 405: FROM MTL_ITEM_TEMPLATES_TL B,

401: B.LAST_UPDATED_BY,
402: B.LAST_UPDATE_LOGIN,
403: L.LANGUAGE_CODE,
404: B.SOURCE_LANG
405: FROM MTL_ITEM_TEMPLATES_TL B,
406: FND_LANGUAGES L
407: WHERE L.INSTALLED_FLAG IN ('I', 'B')
408: AND B.LANGUAGE = USERENV('LANG')
409: AND NOT EXISTS (SELECT NULL

Line 410: FROM MTL_ITEM_TEMPLATES_TL T

406: FND_LANGUAGES L
407: WHERE L.INSTALLED_FLAG IN ('I', 'B')
408: AND B.LANGUAGE = USERENV('LANG')
409: AND NOT EXISTS (SELECT NULL
410: FROM MTL_ITEM_TEMPLATES_TL T
411: WHERE T.TEMPLATE_ID = B.TEMPLATE_ID
412: AND T.LANGUAGE = L.LANGUAGE_CODE);
413: end ADD_LANGUAGE;
414: