APPS.IEU_UWQ_LOGIN_RULES_PKG dependencies on IEU_UWQ_LOGIN_RULES_TL

Line 44: insert into IEU_UWQ_LOGIN_RULES_TL (

40: X_LAST_UPDATED_BY,
41: X_LAST_UPDATE_LOGIN
42: );
43:
44: insert into IEU_UWQ_LOGIN_RULES_TL (
45: SVR_LOGIN_RULE_ID,
46: LOGIN_RULE_NAME,
47: LOGIN_RULE_DESC,
48: OBJECT_VERSION_NUMBER,

Line 72: from IEU_UWQ_LOGIN_RULES_TL T

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

Line 107: from IEU_UWQ_LOGIN_RULES_TL

103: cursor c1 is select
104: LOGIN_RULE_NAME,
105: LOGIN_RULE_DESC,
106: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
107: from IEU_UWQ_LOGIN_RULES_TL
108: where SVR_LOGIN_RULE_ID = X_SVR_LOGIN_RULE_ID
109: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
110: for update of SVR_LOGIN_RULE_ID nowait;
111:

Line 170: update IEU_UWQ_LOGIN_RULES_TL set

166: if (sql%notfound) then
167: raise no_data_found;
168: end if;
169:
170: update IEU_UWQ_LOGIN_RULES_TL set
171: LOGIN_RULE_NAME = X_LOGIN_RULE_NAME,
172: LOGIN_RULE_DESC = X_LOGIN_RULE_DESC,
173: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
174: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 190: delete from IEU_UWQ_LOGIN_RULES_TL

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

Line 208: delete from IEU_UWQ_LOGIN_RULES_TL T

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

Line 215: update IEU_UWQ_LOGIN_RULES_TL T set (

211: from IEU_UWQ_LOGIN_RULES_B B
212: where B.SVR_LOGIN_RULE_ID = T.SVR_LOGIN_RULE_ID
213: );
214:
215: update IEU_UWQ_LOGIN_RULES_TL T set (
216: LOGIN_RULE_NAME,
217: LOGIN_RULE_DESC
218: ) = (select
219: B.LOGIN_RULE_NAME,

Line 221: from IEU_UWQ_LOGIN_RULES_TL B

217: LOGIN_RULE_DESC
218: ) = (select
219: B.LOGIN_RULE_NAME,
220: B.LOGIN_RULE_DESC
221: from IEU_UWQ_LOGIN_RULES_TL B
222: where B.SVR_LOGIN_RULE_ID = T.SVR_LOGIN_RULE_ID
223: and B.LANGUAGE = T.SOURCE_LANG)
224: where (
225: T.SVR_LOGIN_RULE_ID,

Line 230: from IEU_UWQ_LOGIN_RULES_TL SUBB, IEU_UWQ_LOGIN_RULES_TL SUBT

226: T.LANGUAGE
227: ) in (select
228: SUBT.SVR_LOGIN_RULE_ID,
229: SUBT.LANGUAGE
230: from IEU_UWQ_LOGIN_RULES_TL SUBB, IEU_UWQ_LOGIN_RULES_TL SUBT
231: where SUBB.SVR_LOGIN_RULE_ID = SUBT.SVR_LOGIN_RULE_ID
232: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
233: and (SUBB.LOGIN_RULE_NAME <> SUBT.LOGIN_RULE_NAME
234: or SUBB.LOGIN_RULE_DESC <> SUBT.LOGIN_RULE_DESC

Line 237: insert into IEU_UWQ_LOGIN_RULES_TL (

233: and (SUBB.LOGIN_RULE_NAME <> SUBT.LOGIN_RULE_NAME
234: or SUBB.LOGIN_RULE_DESC <> SUBT.LOGIN_RULE_DESC
235: ));
236:
237: insert into IEU_UWQ_LOGIN_RULES_TL (
238: SVR_LOGIN_RULE_ID,
239: LOGIN_RULE_NAME,
240: LOGIN_RULE_DESC,
241: OBJECT_VERSION_NUMBER,

Line 261: from IEU_UWQ_LOGIN_RULES_TL B, FND_LANGUAGES L

257: B.LAST_UPDATE_DATE,
258: B.LAST_UPDATE_LOGIN,
259: L.LANGUAGE_CODE,
260: B.SOURCE_LANG
261: from IEU_UWQ_LOGIN_RULES_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_LOGIN_RULES_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_LOGIN_RULES_TL T
267: where T.SVR_LOGIN_RULE_ID = B.SVR_LOGIN_RULE_ID
268: and T.LANGUAGE = L.LANGUAGE_CODE);
269: end ADD_LANGUAGE;
270:

Line 340: IEU_UWQ_LOGIN_RULES_TL

336:
337: -- only UPDATE rows that have not been altered by user
338:
339: UPDATE
340: IEU_UWQ_LOGIN_RULES_TL
341: SET
342: source_lang = userenv('LANG'),
343: login_rule_name = x_login_rule_name,
344: login_rule_desc = x_login_rule_desc,