APPS.IEU_UWQM_PRIORITIES_PKG dependencies on IEU_UWQM_PRIORITIES_TL

Line 37: insert into IEU_UWQM_PRIORITIES_TL (

33: FND_GLOBAL.USER_ID,
34: FND_GLOBAL.LOGIN_ID
35: );
36:
37: insert into IEU_UWQM_PRIORITIES_TL (
38: LAST_UPDATE_LOGIN,
39: NAME,
40: DESCRIPTION,
41: LAST_UPDATE_DATE,

Line 65: from IEU_UWQM_PRIORITIES_TL T

61: from FND_LANGUAGES L
62: where L.INSTALLED_FLAG in ('I', 'B')
63: and not exists
64: (select NULL
65: from IEU_UWQM_PRIORITIES_TL T
66: where T.PRIORITY_ID = P_PRIORITY_ID
67: and T.LANGUAGE = L.LANGUAGE_CODE);
68:
69: open c;

Line 100: from IEU_UWQM_PRIORITIES_TL

96: cursor c1 is select
97: NAME,
98: DESCRIPTION,
99: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
100: from IEU_UWQM_PRIORITIES_TL
101: where PRIORITY_ID = P_PRIORITY_ID
102: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
103: for update of PRIORITY_ID nowait;
104: begin

Line 159: update IEU_UWQM_PRIORITIES_TL set

155: if (sql%notfound) then
156: raise no_data_found;
157: end if;
158:
159: update IEU_UWQM_PRIORITIES_TL set
160: NAME = P_NAME,
161: DESCRIPTION = P_DESCRIPTION,
162: LAST_UPDATE_DATE = SYSDATE,
163: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 178: delete from IEU_UWQM_PRIORITIES_TL

174: procedure DELETE_ROW (
175: P_PRIORITY_ID in NUMBER
176: ) is
177: begin
178: delete from IEU_UWQM_PRIORITIES_TL
179: where PRIORITY_ID = P_PRIORITY_ID;
180:
181: if (sql%notfound) then
182: raise no_data_found;

Line 196: delete from IEU_UWQM_PRIORITIES_TL T

192:
193: procedure ADD_LANGUAGE
194: is
195: begin
196: delete from IEU_UWQM_PRIORITIES_TL T
197: where not exists
198: (select NULL
199: from IEU_UWQM_PRIORITIES_B B
200: where B.PRIORITY_ID = T.PRIORITY_ID

Line 203: update IEU_UWQM_PRIORITIES_TL T set (

199: from IEU_UWQM_PRIORITIES_B B
200: where B.PRIORITY_ID = T.PRIORITY_ID
201: );
202:
203: update IEU_UWQM_PRIORITIES_TL T set (
204: NAME,
205: DESCRIPTION
206: ) = (select
207: B.NAME,

Line 209: from IEU_UWQM_PRIORITIES_TL B

205: DESCRIPTION
206: ) = (select
207: B.NAME,
208: B.DESCRIPTION
209: from IEU_UWQM_PRIORITIES_TL B
210: where B.PRIORITY_ID = T.PRIORITY_ID
211: and B.LANGUAGE = T.SOURCE_LANG)
212: where (
213: T.PRIORITY_ID,

Line 218: from IEU_UWQM_PRIORITIES_TL SUBB, IEU_UWQM_PRIORITIES_TL SUBT

214: T.LANGUAGE
215: ) in (select
216: SUBT.PRIORITY_ID,
217: SUBT.LANGUAGE
218: from IEU_UWQM_PRIORITIES_TL SUBB, IEU_UWQM_PRIORITIES_TL SUBT
219: where SUBB.PRIORITY_ID = SUBT.PRIORITY_ID
220: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
221: and (SUBB.NAME <> SUBT.NAME
222: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 225: insert into IEU_UWQM_PRIORITIES_TL (

221: and (SUBB.NAME <> SUBT.NAME
222: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
223: ));
224:
225: insert into IEU_UWQM_PRIORITIES_TL (
226: LAST_UPDATE_LOGIN,
227: NAME,
228: DESCRIPTION,
229: LAST_UPDATE_DATE,

Line 249: from IEU_UWQM_PRIORITIES_TL B, FND_LANGUAGES L

245: B.CREATED_BY,
246: B.PRIORITY_ID,
247: L.LANGUAGE_CODE,
248: B.SOURCE_LANG
249: from IEU_UWQM_PRIORITIES_TL B, FND_LANGUAGES L
250: where L.INSTALLED_FLAG in ('I', 'B')
251: and B.LANGUAGE = userenv('LANG')
252: and not exists
253: (select NULL

Line 254: from IEU_UWQM_PRIORITIES_TL T

250: where L.INSTALLED_FLAG in ('I', 'B')
251: and B.LANGUAGE = userenv('LANG')
252: and not exists
253: (select NULL
254: from IEU_UWQM_PRIORITIES_TL T
255: where T.PRIORITY_ID = B.PRIORITY_ID
256: and T.LANGUAGE = L.LANGUAGE_CODE);
257: end ADD_LANGUAGE;
258:

Line 269: UPDATE ieu_uwqm_priorities_tl

265: BEGIN
266:
267: -- only UPDATE rows that have not been altered by user
268:
269: UPDATE ieu_uwqm_priorities_tl
270: SET
271: name = p_name,
272: source_lang = userenv('LANG'),
273: description = p_description,