APPS.IEU_UWQ_RES_CATS_PKG dependencies on IEU_UWQ_RES_CATS_TL

Line 45: insert into IEU_UWQ_RES_CATS_TL (

41: X_LAST_UPDATED_BY,
42: X_LAST_UPDATE_LOGIN
43: );
44:
45: insert into IEU_UWQ_RES_CATS_TL (
46: RES_CAT_ID,
47: OBJECT_VERSION_NUMBER,
48: CREATED_BY,
49: CREATION_DATE,

Line 73: from IEU_UWQ_RES_CATS_TL T

69: from FND_LANGUAGES L
70: where L.INSTALLED_FLAG in ('I', 'B')
71: and not exists
72: (select NULL
73: from IEU_UWQ_RES_CATS_TL T
74: where T.RES_CAT_ID = X_RES_CAT_ID
75: and T.LANGUAGE = L.LANGUAGE_CODE);
76:
77: open c;

Line 108: from IEU_UWQ_RES_CATS_TL

104: cursor c1 is select
105: NAME,
106: DESCRIPTION,
107: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
108: from IEU_UWQ_RES_CATS_TL
109: where RES_CAT_ID = X_RES_CAT_ID
110: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
111: for update of RES_CAT_ID nowait;
112: begin

Line 171: update IEU_UWQ_RES_CATS_TL set

167: if (sql%notfound) then
168: raise no_data_found;
169: end if;
170:
171: update IEU_UWQ_RES_CATS_TL set
172: NAME = X_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 IEU_UWQ_RES_CATS_TL

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

Line 208: delete from IEU_UWQ_RES_CATS_TL T

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

Line 215: update IEU_UWQ_RES_CATS_TL T set (

211: from IEU_UWQ_RES_CATS_B B
212: where B.RES_CAT_ID = T.RES_CAT_ID
213: );
214:
215: update IEU_UWQ_RES_CATS_TL T set (
216: NAME,
217: DESCRIPTION
218: ) = (select
219: B.NAME,

Line 221: from IEU_UWQ_RES_CATS_TL B

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

Line 230: from IEU_UWQ_RES_CATS_TL SUBB, IEU_UWQ_RES_CATS_TL SUBT

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

Line 237: insert into IEU_UWQ_RES_CATS_TL (

233: and (SUBB.NAME <> SUBT.NAME
234: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
235: ));
236:
237: insert into IEU_UWQ_RES_CATS_TL (
238: RES_CAT_ID,
239: OBJECT_VERSION_NUMBER,
240: CREATED_BY,
241: CREATION_DATE,

Line 261: from IEU_UWQ_RES_CATS_TL B, FND_LANGUAGES L

257: B.NAME,
258: B.DESCRIPTION,
259: L.LANGUAGE_CODE,
260: B.SOURCE_LANG
261: from IEU_UWQ_RES_CATS_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 IEU_UWQ_RES_CATS_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 IEU_UWQ_RES_CATS_TL T
267: where T.RES_CAT_ID = B.RES_CAT_ID
268: and T.LANGUAGE = L.LANGUAGE_CODE);
269: end ADD_LANGUAGE;
270:

Line 353: IEU_UWQ_RES_CATS_TL

349:
350: -- only UPDATE rows that have not been altered by user
351:
352: UPDATE
353: IEU_UWQ_RES_CATS_TL
354: SET
355: source_lang = userenv('LANG'),
356: name = x_name,
357: description = x_description,