APPS.ENG_CHANGE_MGMT_TYPES_PKG dependencies on ENG_CHANGE_MGMT_TYPES

Line 1: package body ENG_CHANGE_MGMT_TYPES_PKG as

1: package body ENG_CHANGE_MGMT_TYPES_PKG as
2: /* $Header: ENGTYPEB.pls 115.2 2002/12/03 19:43:12 sshrikha noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_CHANGE_MGMT_TYPE_CODE in VARCHAR2,

Line 20: cursor C is select ROWID from ENG_CHANGE_MGMT_TYPES

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from ENG_CHANGE_MGMT_TYPES
21: where CHANGE_MGMT_TYPE_CODE = X_CHANGE_MGMT_TYPE_CODE
22: ;
23: begin
24: insert into ENG_CHANGE_MGMT_TYPES (

Line 24: insert into ENG_CHANGE_MGMT_TYPES (

20: cursor C is select ROWID from ENG_CHANGE_MGMT_TYPES
21: where CHANGE_MGMT_TYPE_CODE = X_CHANGE_MGMT_TYPE_CODE
22: ;
23: begin
24: insert into ENG_CHANGE_MGMT_TYPES (
25: ENABLE_REV_ITEMS_FLAG,
26: ENABLE_TASKS_FLAG,
27: DISABLE_FLAG,
28: CHANGE_MGMT_TYPE_CODE,

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 110: from ENG_CHANGE_MGMT_TYPES

106: ENABLE_TASKS_FLAG,
107: DISABLE_FLAG,
108: SEQUENCE_NUMBER,
109: FORM_FUNCTION_NAME
110: from ENG_CHANGE_MGMT_TYPES
111: where CHANGE_MGMT_TYPE_CODE = X_CHANGE_MGMT_TYPE_CODE
112: for update of CHANGE_MGMT_TYPE_CODE nowait;
113: recinfo c%rowtype;
114:

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 185: update ENG_CHANGE_MGMT_TYPES set

181: X_LAST_UPDATE_LOGIN in NUMBER
182: )
183: is
184: begin
185: update ENG_CHANGE_MGMT_TYPES set
186: ENABLE_REV_ITEMS_FLAG = X_ENABLE_REV_ITEMS_FLAG,
187: ENABLE_TASKS_FLAG = X_ENABLE_TASKS_FLAG,
188: DISABLE_FLAG = X_DISABLE_FLAG,
189: SEQUENCE_NUMBER = X_SEQUENCE_NUMBER,

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 227: delete from ENG_CHANGE_MGMT_TYPES

223: if (sql%notfound) then
224: raise no_data_found;
225: end if;
226:
227: delete from ENG_CHANGE_MGMT_TYPES
228: where CHANGE_MGMT_TYPE_CODE = X_CHANGE_MGMT_TYPE_CODE;
229:
230: if (sql%notfound) then
231: 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 241: from ENG_CHANGE_MGMT_TYPES B

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
243: );
244:
245: update ENG_CHANGE_MGMT_TYPES_TL T set (

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:

Line 310: end ENG_CHANGE_MGMT_TYPES_PKG;

306: where T.CHANGE_MGMT_TYPE_CODE = B.CHANGE_MGMT_TYPE_CODE
307: and T.LANGUAGE = L.LANGUAGE_CODE);
308: end ADD_LANGUAGE;
309:
310: end ENG_CHANGE_MGMT_TYPES_PKG;