eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_FLEX_VALUE_RULES_PKG dependencies on FND_FLEX_VALUE_RULES

Line 1: package body FND_FLEX_VALUE_RULES_PKG as

1: package body FND_FLEX_VALUE_RULES_PKG as
2: /* $Header: AFFFVLRB.pls 120.2.12010000.1 2008/07/25 14:14:52 appldev ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID IN OUT NOCOPY VARCHAR2,

Line 19: cursor C is select ROWID from FND_FLEX_VALUE_RULES

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from FND_FLEX_VALUE_RULES
20: where FLEX_VALUE_RULE_ID = X_FLEX_VALUE_RULE_ID
21: ;
22: begin
23: insert into FND_FLEX_VALUE_RULES (

Line 23: insert into FND_FLEX_VALUE_RULES (

19: cursor C is select ROWID from FND_FLEX_VALUE_RULES
20: where FLEX_VALUE_RULE_ID = X_FLEX_VALUE_RULE_ID
21: ;
22: begin
23: insert into FND_FLEX_VALUE_RULES (
24: FLEX_VALUE_RULE_ID,
25: FLEX_VALUE_RULE_NAME,
26: FLEX_VALUE_SET_ID,
27: PARENT_FLEX_VALUE_LOW,

Line 47: insert into FND_FLEX_VALUE_RULES_TL (

43: X_LAST_UPDATED_BY,
44: X_LAST_UPDATE_LOGIN
45: );
46:
47: insert into FND_FLEX_VALUE_RULES_TL (
48: DESCRIPTION,
49: FLEX_VALUE_RULE_ID,
50: LAST_UPDATE_DATE,
51: LAST_UPDATED_BY,

Line 73: from FND_FLEX_VALUE_RULES_TL T

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

Line 101: from FND_FLEX_VALUE_RULES

97: FLEX_VALUE_RULE_NAME,
98: FLEX_VALUE_SET_ID,
99: PARENT_FLEX_VALUE_LOW,
100: PARENT_FLEX_VALUE_HIGH
101: from FND_FLEX_VALUE_RULES
102: where FLEX_VALUE_RULE_ID = X_FLEX_VALUE_RULE_ID
103: for update of FLEX_VALUE_RULE_ID nowait;
104: recinfo c%rowtype;
105:

Line 110: from FND_FLEX_VALUE_RULES_TL

106: cursor c1 is select
107: ERROR_MESSAGE,
108: DESCRIPTION,
109: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
110: from FND_FLEX_VALUE_RULES_TL
111: where FLEX_VALUE_RULE_ID = X_FLEX_VALUE_RULE_ID
112: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
113: for update of FLEX_VALUE_RULE_ID nowait;
114: begin

Line 166: update FND_FLEX_VALUE_RULES set

162: X_LAST_UPDATED_BY in NUMBER,
163: X_LAST_UPDATE_LOGIN in NUMBER
164: ) is
165: begin
166: update FND_FLEX_VALUE_RULES set
167: FLEX_VALUE_RULE_NAME = X_FLEX_VALUE_RULE_NAME,
168: FLEX_VALUE_SET_ID = X_FLEX_VALUE_SET_ID,
169: PARENT_FLEX_VALUE_LOW = X_PARENT_FLEX_VALUE_LOW,
170: PARENT_FLEX_VALUE_HIGH = X_PARENT_FLEX_VALUE_HIGH,

Line 180: update FND_FLEX_VALUE_RULES_TL set

176: if (sql%notfound) then
177: raise no_data_found;
178: end if;
179:
180: update FND_FLEX_VALUE_RULES_TL set
181: ERROR_MESSAGE = X_ERROR_MESSAGE,
182: DESCRIPTION = X_DESCRIPTION,
183: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
184: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 199: delete from FND_FLEX_VALUE_RULES_TL

195: procedure DELETE_ROW (
196: X_FLEX_VALUE_RULE_ID in NUMBER
197: ) is
198: begin
199: delete from FND_FLEX_VALUE_RULES_TL
200: where FLEX_VALUE_RULE_ID = X_FLEX_VALUE_RULE_ID;
201:
202: if (sql%notfound) then
203: raise no_data_found;

Line 206: delete from FND_FLEX_VALUE_RULES

202: if (sql%notfound) then
203: raise no_data_found;
204: end if;
205:
206: delete from FND_FLEX_VALUE_RULES
207: where FLEX_VALUE_RULE_ID = X_FLEX_VALUE_RULE_ID;
208:
209: if (sql%notfound) then
210: raise no_data_found;

Line 223: delete from FND_FLEX_VALUE_RULES_TL T

219: /* as a quick workaround to fix the time-consuming table handler issue */
220: /* Eventually we'll need to turn them into a separate fix_language procedure */
221: /*
222:
223: delete from FND_FLEX_VALUE_RULES_TL T
224: where not exists
225: (select NULL
226: from FND_FLEX_VALUE_RULES B
227: where B.FLEX_VALUE_RULE_ID = T.FLEX_VALUE_RULE_ID

Line 226: from FND_FLEX_VALUE_RULES B

222:
223: delete from FND_FLEX_VALUE_RULES_TL T
224: where not exists
225: (select NULL
226: from FND_FLEX_VALUE_RULES B
227: where B.FLEX_VALUE_RULE_ID = T.FLEX_VALUE_RULE_ID
228: );
229:
230: update FND_FLEX_VALUE_RULES_TL T set (

Line 230: update FND_FLEX_VALUE_RULES_TL T set (

226: from FND_FLEX_VALUE_RULES B
227: where B.FLEX_VALUE_RULE_ID = T.FLEX_VALUE_RULE_ID
228: );
229:
230: update FND_FLEX_VALUE_RULES_TL T set (
231: ERROR_MESSAGE,
232: DESCRIPTION
233: ) = (select
234: B.ERROR_MESSAGE,

Line 236: from FND_FLEX_VALUE_RULES_TL B

232: DESCRIPTION
233: ) = (select
234: B.ERROR_MESSAGE,
235: B.DESCRIPTION
236: from FND_FLEX_VALUE_RULES_TL B
237: where B.FLEX_VALUE_RULE_ID = T.FLEX_VALUE_RULE_ID
238: and B.LANGUAGE = T.SOURCE_LANG)
239: where (
240: T.FLEX_VALUE_RULE_ID,

Line 245: from FND_FLEX_VALUE_RULES_TL SUBB, FND_FLEX_VALUE_RULES_TL SUBT

241: T.LANGUAGE
242: ) in (select
243: SUBT.FLEX_VALUE_RULE_ID,
244: SUBT.LANGUAGE
245: from FND_FLEX_VALUE_RULES_TL SUBB, FND_FLEX_VALUE_RULES_TL SUBT
246: where SUBB.FLEX_VALUE_RULE_ID = SUBT.FLEX_VALUE_RULE_ID
247: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
248: and (SUBB.ERROR_MESSAGE <> SUBT.ERROR_MESSAGE
249: or (SUBB.ERROR_MESSAGE is null and SUBT.ERROR_MESSAGE is not null)

Line 257: insert into FND_FLEX_VALUE_RULES_TL (

253: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
254: ));
255: */
256:
257: insert into FND_FLEX_VALUE_RULES_TL (
258: DESCRIPTION,
259: FLEX_VALUE_RULE_ID,
260: LAST_UPDATE_DATE,
261: LAST_UPDATED_BY,

Line 279: from FND_FLEX_VALUE_RULES_TL B, FND_LANGUAGES L

275: B.LAST_UPDATE_LOGIN,
276: B.ERROR_MESSAGE,
277: L.LANGUAGE_CODE,
278: B.SOURCE_LANG
279: from FND_FLEX_VALUE_RULES_TL B, FND_LANGUAGES L
280: where L.INSTALLED_FLAG in ('I', 'B')
281: and B.LANGUAGE = userenv('LANG')
282: and not exists
283: (select NULL

Line 284: from FND_FLEX_VALUE_RULES_TL T

280: where L.INSTALLED_FLAG in ('I', 'B')
281: and B.LANGUAGE = userenv('LANG')
282: and not exists
283: (select NULL
284: from FND_FLEX_VALUE_RULES_TL T
285: where T.FLEX_VALUE_RULE_ID = B.FLEX_VALUE_RULE_ID
286: and T.LANGUAGE = L.LANGUAGE_CODE);
287: end ADD_LANGUAGE;
288:

Line 312: FROM fnd_flex_value_rules

308: BEGIN
309: IF (l_validation_type = 'D') THEN
310: SELECT flex_value_rule_id
311: INTO l_flex_value_rule_id
312: FROM fnd_flex_value_rules
313: WHERE flex_value_set_id = l_flex_value_set_id
314: AND flex_value_rule_name = x_flex_value_rule_name
315: AND (parent_flex_value_low = x_parent_flex_value_low OR
316: (parent_flex_value_low IS NULL AND

Line 321: FROM fnd_flex_value_rules

317: x_parent_flex_value_low IS NULL));
318: ELSE
319: SELECT flex_value_rule_id
320: INTO l_flex_value_rule_id
321: FROM fnd_flex_value_rules
322: WHERE flex_value_set_id = l_flex_value_set_id
323: AND flex_value_rule_name = x_flex_value_rule_name;
324: END IF;
325:

Line 326: fnd_flex_value_rules_pkg.update_row

322: WHERE flex_value_set_id = l_flex_value_set_id
323: AND flex_value_rule_name = x_flex_value_rule_name;
324: END IF;
325:
326: fnd_flex_value_rules_pkg.update_row
327: (X_FLEX_VALUE_RULE_ID => l_flex_value_rule_id,
328: X_FLEX_VALUE_RULE_NAME => x_flex_value_rule_name,
329: X_FLEX_VALUE_SET_ID => l_flex_value_set_id,
330: X_DESCRIPTION => x_description,

Line 339: SELECT fnd_flex_value_rules_s.NEXTVAL

335: X_LAST_UPDATED_BY => x_who.last_updated_by,
336: X_LAST_UPDATE_LOGIN => x_who.last_update_login);
337: EXCEPTION
338: WHEN no_data_found THEN
339: SELECT fnd_flex_value_rules_s.NEXTVAL
340: INTO l_flex_value_rule_id
341: FROM dual;
342:
343: fnd_flex_value_rules_pkg.insert_row

Line 343: fnd_flex_value_rules_pkg.insert_row

339: SELECT fnd_flex_value_rules_s.NEXTVAL
340: INTO l_flex_value_rule_id
341: FROM dual;
342:
343: fnd_flex_value_rules_pkg.insert_row
344: (X_ROWID => l_rowid,
345: X_FLEX_VALUE_RULE_ID => l_flex_value_rule_id,
346: X_FLEX_VALUE_RULE_NAME => x_flex_value_rule_name,
347: X_FLEX_VALUE_SET_ID => l_flex_value_set_id,

Line 370: UPDATE fnd_flex_value_rules_tl SET

366: x_error_message IN VARCHAR2,
367: x_description IN VARCHAR2)
368: IS
369: BEGIN
370: UPDATE fnd_flex_value_rules_tl SET
371: error_message = Nvl(x_error_message, error_message),
372: description = Nvl(x_description, description),
373: last_update_date = x_who.last_update_date,
374: last_updated_by = x_who.last_updated_by,

Line 379: FROM fnd_flex_value_rules fvr, fnd_flex_value_sets fvs

375: last_update_login = x_who.last_update_login,
376: source_lang = userenv('LANG')
377: WHERE (flex_value_rule_id =
378: (SELECT flex_value_rule_id
379: FROM fnd_flex_value_rules fvr, fnd_flex_value_sets fvs
380: WHERE fvr.flex_value_set_id = fvs.flex_value_set_id
381: AND fvs.flex_value_set_name = x_flex_value_set_name
382: AND fvr.flex_value_rule_name = x_flex_value_rule_name
383: AND ((fvs.validation_type NOT IN ('D', 'Y')) OR

Line 391: end FND_FLEX_VALUE_RULES_PKG;

387: x_parent_flex_value_low IS NULL))))))
388: AND userenv('LANG') in (language, source_lang);
389: END translate_row;
390:
391: end FND_FLEX_VALUE_RULES_PKG;