APPS.ENG_CHANGE_CLASSIFICATIONS_PKG dependencies on ENG_CHANGE_CLASSIFICATIONS_TL

Line 39: insert into ENG_CHANGE_CLASSIFICATIONS_TL (

35: X_LAST_UPDATE_DATE,
36: X_LAST_UPDATED_BY,
37: X_LAST_UPDATE_LOGIN
38: );
39: insert into ENG_CHANGE_CLASSIFICATIONS_TL (
40: DESCRIPTION,
41: LAST_UPDATED_BY,
42: CREATION_DATE,
43: CREATED_BY,

Line 65: from ENG_CHANGE_CLASSIFICATIONS_TL T

61: from FND_LANGUAGES L
62: where L.INSTALLED_FLAG in ('I', 'B')
63: and not exists
64: (select NULL
65: from ENG_CHANGE_CLASSIFICATIONS_TL T
66: where T.CLASSIFICATION_ID = X_CLASSIFICATION_ID
67: and T.LANGUAGE = L.LANGUAGE_CODE);
68: open c;
69: fetch c into X_ROWID;

Line 94: from ENG_CHANGE_CLASSIFICATIONS_TL

90: cursor c1 is select
91: DESCRIPTION,
92: CLASSIFICATION_NAME,
93: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
94: from ENG_CHANGE_CLASSIFICATIONS_TL
95: where CLASSIFICATION_ID = X_CLASSIFICATION_ID
96: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
97: for update of CLASSIFICATION_ID nowait;
98: begin

Line 154: update ENG_CHANGE_CLASSIFICATIONS_TL set

150: where CLASSIFICATION_ID = X_CLASSIFICATION_ID;
151: if (sql%notfound) then
152: raise no_data_found;
153: end if;
154: update ENG_CHANGE_CLASSIFICATIONS_TL set
155: DESCRIPTION = X_DESCRIPTION,
156: CLASSIFICATION_NAME = X_CLASSIFICATION_NAME,
157: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
158: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 171: delete from ENG_CHANGE_CLASSIFICATIONS_TL

167: procedure DELETE_ROW (
168: X_CLASSIFICATION_ID in NUMBER
169: ) is
170: begin
171: delete from ENG_CHANGE_CLASSIFICATIONS_TL
172: where CLASSIFICATION_ID = X_CLASSIFICATION_ID;
173: if (sql%notfound) then
174: raise no_data_found;
175: end if;

Line 185: delete from ENG_CHANGE_CLASSIFICATIONS_TL T

181: end DELETE_ROW;
182: procedure ADD_LANGUAGE
183: is
184: begin
185: delete from ENG_CHANGE_CLASSIFICATIONS_TL T
186: where not exists
187: (select NULL
188: from ENG_CHANGE_CLASSIFICATIONS_B B
189: where B.CLASSIFICATION_ID = T.CLASSIFICATION_ID

Line 191: update ENG_CHANGE_CLASSIFICATIONS_TL T set (

187: (select NULL
188: from ENG_CHANGE_CLASSIFICATIONS_B B
189: where B.CLASSIFICATION_ID = T.CLASSIFICATION_ID
190: );
191: update ENG_CHANGE_CLASSIFICATIONS_TL T set (
192: DESCRIPTION,
193: CLASSIFICATION_NAME
194: ) = (select
195: B.DESCRIPTION,

Line 197: from ENG_CHANGE_CLASSIFICATIONS_TL B

193: CLASSIFICATION_NAME
194: ) = (select
195: B.DESCRIPTION,
196: B.CLASSIFICATION_NAME
197: from ENG_CHANGE_CLASSIFICATIONS_TL B
198: where B.CLASSIFICATION_ID = T.CLASSIFICATION_ID
199: and B.LANGUAGE = T.SOURCE_LANG)
200: where (
201: T.CLASSIFICATION_ID,

Line 206: from ENG_CHANGE_CLASSIFICATIONS_TL SUBB, ENG_CHANGE_CLASSIFICATIONS_TL SUBT

202: T.LANGUAGE
203: ) in (select
204: SUBT.CLASSIFICATION_ID,
205: SUBT.LANGUAGE
206: from ENG_CHANGE_CLASSIFICATIONS_TL SUBB, ENG_CHANGE_CLASSIFICATIONS_TL SUBT
207: where SUBB.CLASSIFICATION_ID = SUBT.CLASSIFICATION_ID
208: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
209: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
210: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 216: insert into ENG_CHANGE_CLASSIFICATIONS_TL (

212: or SUBB.CLASSIFICATION_NAME <> SUBT.CLASSIFICATION_NAME
213: or (SUBB.CLASSIFICATION_NAME is null and SUBT.CLASSIFICATION_NAME is not null)
214: or (SUBB.CLASSIFICATION_NAME is not null and SUBT.CLASSIFICATION_NAME is null)
215: ));
216: insert into ENG_CHANGE_CLASSIFICATIONS_TL (
217: DESCRIPTION,
218: LAST_UPDATED_BY,
219: CREATION_DATE,
220: CREATED_BY,

Line 238: from ENG_CHANGE_CLASSIFICATIONS_TL B, FND_LANGUAGES L

234: B.CLASSIFICATION_ID,
235: B.LAST_UPDATE_DATE,
236: L.LANGUAGE_CODE,
237: B.SOURCE_LANG
238: from ENG_CHANGE_CLASSIFICATIONS_TL B, FND_LANGUAGES L
239: where L.INSTALLED_FLAG in ('I', 'B')
240: and B.LANGUAGE = userenv('LANG')
241: and not exists
242: (select NULL

Line 243: from ENG_CHANGE_CLASSIFICATIONS_TL T

239: where L.INSTALLED_FLAG in ('I', 'B')
240: and B.LANGUAGE = userenv('LANG')
241: and not exists
242: (select NULL
243: from ENG_CHANGE_CLASSIFICATIONS_TL T
244: where T.CLASSIFICATION_ID = B.CLASSIFICATION_ID
245: and T.LANGUAGE = L.LANGUAGE_CODE);
246: end ADD_LANGUAGE;
247: end ENG_CHANGE_CLASSIFICATIONS_PKG;