APPS.FND_FLEX_VALUE_RULES_PKG dependencies on FND_FLEX_VALUE_RULES_TL

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 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 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 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 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 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,