APPS.ENG_CHANGE_MGMT_TYPES_PKG dependencies on ENG_CHANGE_MGMT_TYPES_TL

Line 50: insert into ENG_CHANGE_MGMT_TYPES_TL (

46: X_LAST_UPDATED_BY,
47: X_LAST_UPDATE_LOGIN
48: );
49:
50: insert into ENG_CHANGE_MGMT_TYPES_TL (
51: TAB_TEXT,
52: NAME,
53: CHANGE_MGMT_TYPE_CODE,
54: CREATED_BY,

Line 78: from ENG_CHANGE_MGMT_TYPES_TL T

74: from FND_LANGUAGES L
75: where L.INSTALLED_FLAG in ('I', 'B')
76: and not exists
77: (select NULL
78: from ENG_CHANGE_MGMT_TYPES_TL T
79: where T.CHANGE_MGMT_TYPE_CODE = X_CHANGE_MGMT_TYPE_CODE
80: and T.LANGUAGE = L.LANGUAGE_CODE);
81:
82: open c;

Line 120: from ENG_CHANGE_MGMT_TYPES_TL

116: NAME,
117: DESCRIPTION,
118: TAB_TEXT,
119: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
120: from ENG_CHANGE_MGMT_TYPES_TL
121: where CHANGE_MGMT_TYPE_CODE = X_CHANGE_MGMT_TYPE_CODE
122: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
123: for update of CHANGE_MGMT_TYPE_CODE nowait;
124: begin

Line 200: update ENG_CHANGE_MGMT_TYPES_TL set

196: if (sql%notfound) then
197: raise no_data_found;
198: end if;
199:
200: update ENG_CHANGE_MGMT_TYPES_TL set
201: NAME = X_NAME,
202: DESCRIPTION = X_DESCRIPTION,
203: TAB_TEXT = X_TAB_TEXT,
204: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 220: delete from ENG_CHANGE_MGMT_TYPES_TL

216: procedure DELETE_ROW (
217: X_CHANGE_MGMT_TYPE_CODE in VARCHAR2
218: ) is
219: begin
220: delete from ENG_CHANGE_MGMT_TYPES_TL
221: where CHANGE_MGMT_TYPE_CODE = X_CHANGE_MGMT_TYPE_CODE;
222:
223: if (sql%notfound) then
224: raise no_data_found;

Line 238: delete from ENG_CHANGE_MGMT_TYPES_TL T

234:
235: procedure ADD_LANGUAGE
236: is
237: begin
238: delete from ENG_CHANGE_MGMT_TYPES_TL T
239: where not exists
240: (select NULL
241: from ENG_CHANGE_MGMT_TYPES B
242: where B.CHANGE_MGMT_TYPE_CODE = T.CHANGE_MGMT_TYPE_CODE

Line 245: update ENG_CHANGE_MGMT_TYPES_TL T set (

241: from ENG_CHANGE_MGMT_TYPES B
242: where B.CHANGE_MGMT_TYPE_CODE = T.CHANGE_MGMT_TYPE_CODE
243: );
244:
245: update ENG_CHANGE_MGMT_TYPES_TL T set (
246: NAME,
247: DESCRIPTION,
248: TAB_TEXT
249: ) = (select

Line 253: from ENG_CHANGE_MGMT_TYPES_TL B

249: ) = (select
250: B.NAME,
251: B.DESCRIPTION,
252: B.TAB_TEXT
253: from ENG_CHANGE_MGMT_TYPES_TL B
254: where B.CHANGE_MGMT_TYPE_CODE = T.CHANGE_MGMT_TYPE_CODE
255: and B.LANGUAGE = T.SOURCE_LANG)
256: where (
257: T.CHANGE_MGMT_TYPE_CODE,

Line 262: from ENG_CHANGE_MGMT_TYPES_TL SUBB, ENG_CHANGE_MGMT_TYPES_TL SUBT

258: T.LANGUAGE
259: ) in (select
260: SUBT.CHANGE_MGMT_TYPE_CODE,
261: SUBT.LANGUAGE
262: from ENG_CHANGE_MGMT_TYPES_TL SUBB, ENG_CHANGE_MGMT_TYPES_TL SUBT
263: where SUBB.CHANGE_MGMT_TYPE_CODE = SUBT.CHANGE_MGMT_TYPE_CODE
264: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
265: and (SUBB.NAME <> SUBT.NAME
266: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 276: insert into ENG_CHANGE_MGMT_TYPES_TL (

272: or (SUBB.TAB_TEXT is null and SUBT.TAB_TEXT is not null)
273: or (SUBB.TAB_TEXT is not null and SUBT.TAB_TEXT is null)
274: ));
275:
276: insert into ENG_CHANGE_MGMT_TYPES_TL (
277: TAB_TEXT,
278: NAME,
279: CHANGE_MGMT_TYPE_CODE,
280: CREATED_BY,

Line 300: from ENG_CHANGE_MGMT_TYPES_TL B, FND_LANGUAGES L

296: B.LAST_UPDATE_LOGIN,
297: B.DESCRIPTION,
298: L.LANGUAGE_CODE,
299: B.SOURCE_LANG
300: from ENG_CHANGE_MGMT_TYPES_TL B, FND_LANGUAGES L
301: where L.INSTALLED_FLAG in ('I', 'B')
302: and B.LANGUAGE = userenv('LANG')
303: and not exists
304: (select NULL

Line 305: from ENG_CHANGE_MGMT_TYPES_TL T

301: where L.INSTALLED_FLAG in ('I', 'B')
302: and B.LANGUAGE = userenv('LANG')
303: and not exists
304: (select NULL
305: from ENG_CHANGE_MGMT_TYPES_TL T
306: where T.CHANGE_MGMT_TYPE_CODE = B.CHANGE_MGMT_TYPE_CODE
307: and T.LANGUAGE = L.LANGUAGE_CODE);
308: end ADD_LANGUAGE;
309: