APPS.FUN_RULE_CRIT_PARAMS_PKG dependencies on FUN_RULE_CRIT_PARAMS_TL

Line 60: insert into FUN_RULE_CRIT_PARAMS_TL (

56: NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY)
57: )RETURNING ROWID INTO X_ROWID;
58:
59:
60: insert into FUN_RULE_CRIT_PARAMS_TL (
61: CRITERIA_PARAM_ID,
62: USER_PARAM_NAME,
63: DESCRIPTION,
64: TIP_TEXT,

Line 88: from FUN_RULE_CRIT_PARAMS_TL T

84: from FND_LANGUAGES L
85: where L.INSTALLED_FLAG in ('I', 'B')
86: and not exists
87: (select NULL
88: from FUN_RULE_CRIT_PARAMS_TL T
89: where T.CRITERIA_PARAM_ID = NVL(X_CRITERIA_PARAM_ID,l_seq_val)
90: and T.LANGUAGE = L.LANGUAGE_CODE);
91:
92: EXCEPTION

Line 179: update FUN_RULE_CRIT_PARAMS_TL set

175: if (sql%notfound) then
176: raise no_data_found;
177: end if;
178:
179: update FUN_RULE_CRIT_PARAMS_TL set
180: USER_PARAM_NAME = X_USER_PARAM_NAME,
181: DESCRIPTION = X_DESCRIPTION,
182: TIP_TEXT = X_TIP_TEXT,
183: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),

Line 254: DELETE FROM FUN_RULE_CRIT_PARAMS_TL

250: IF ( SQL%NOTFOUND ) THEN
251: RAISE NO_DATA_FOUND;
252: END IF;
253:
254: DELETE FROM FUN_RULE_CRIT_PARAMS_TL
255: WHERE CRITERIA_PARAM_ID = X_CRITERIA_PARAM_ID;
256:
257: if (sql%notfound) then
258: raise no_data_found;

Line 268: delete from FUN_RULE_CRIT_PARAMS_TL T

264:
265: procedure ADD_LANGUAGE
266: IS
267: BEGIN
268: delete from FUN_RULE_CRIT_PARAMS_TL T
269: where not exists
270: (select NULL
271: from FUN_RULE_CRIT_PARAMS_B B
272: where B.CRITERIA_PARAM_ID = T.CRITERIA_PARAM_ID

Line 275: update FUN_RULE_CRIT_PARAMS_TL T set (

271: from FUN_RULE_CRIT_PARAMS_B B
272: where B.CRITERIA_PARAM_ID = T.CRITERIA_PARAM_ID
273: );
274:
275: update FUN_RULE_CRIT_PARAMS_TL T set (
276: USER_PARAM_NAME,
277: DESCRIPTION,
278: TIP_TEXT
279: ) = (select

Line 283: from FUN_RULE_CRIT_PARAMS_TL B

279: ) = (select
280: B.USER_PARAM_NAME,
281: B.DESCRIPTION,
282: B.TIP_TEXT
283: from FUN_RULE_CRIT_PARAMS_TL B
284: where B.CRITERIA_PARAM_ID = T.CRITERIA_PARAM_ID
285: and B.LANGUAGE = T.SOURCE_LANG)
286: where (
287: T.CRITERIA_PARAM_ID,

Line 292: from FUN_RULE_CRIT_PARAMS_TL SUBB, FUN_RULE_CRIT_PARAMS_TL SUBT

288: T.LANGUAGE
289: ) in (select
290: SUBT.CRITERIA_PARAM_ID,
291: SUBT.LANGUAGE
292: from FUN_RULE_CRIT_PARAMS_TL SUBB, FUN_RULE_CRIT_PARAMS_TL SUBT
293: where SUBB.CRITERIA_PARAM_ID = SUBT.CRITERIA_PARAM_ID
294: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
295: and (SUBB.USER_PARAM_NAME <> SUBT.USER_PARAM_NAME
296: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 304: insert into FUN_RULE_CRIT_PARAMS_TL (

300: or (SUBB.TIP_TEXT is null and SUBT.TIP_TEXT is not null)
301: or (SUBB.TIP_TEXT is not null and SUBT.TIP_TEXT is null)
302: ));
303:
304: insert into FUN_RULE_CRIT_PARAMS_TL (
305: CRITERIA_PARAM_ID,
306: USER_PARAM_NAME,
307: DESCRIPTION,
308: TIP_TEXT,

Line 328: from FUN_RULE_CRIT_PARAMS_TL B, FND_LANGUAGES L

324: B.LAST_UPDATED_BY,
325: B.LAST_UPDATE_LOGIN,
326: L.LANGUAGE_CODE,
327: B.SOURCE_LANG
328: from FUN_RULE_CRIT_PARAMS_TL B, FND_LANGUAGES L
329: where L.INSTALLED_FLAG in ('I', 'B')
330: and B.LANGUAGE = userenv('LANG')
331: and not exists
332: (select NULL

Line 333: from FUN_RULE_CRIT_PARAMS_TL T

329: where L.INSTALLED_FLAG in ('I', 'B')
330: and B.LANGUAGE = userenv('LANG')
331: and not exists
332: (select NULL
333: from FUN_RULE_CRIT_PARAMS_TL T
334: where T.CRITERIA_PARAM_ID = B.CRITERIA_PARAM_ID
335: and T.LANGUAGE = L.LANGUAGE_CODE);
336: END ADD_LANGUAGE;
337:

Line 523: from fun_rule_crit_params_tl

519:
520: BEGIN
521: select last_updated_by, last_update_date
522: into db_luby, db_ludate
523: from fun_rule_crit_params_tl
524: where criteria_param_id = cpid
525: and language = userenv('LANG');
526: EXCEPTION
527: WHEN NO_DATA_FOUND THEN

Line 540: update fun_rule_crit_params_tl

536: p_db_id => db_luby,
537: p_db_lud => db_ludate,
538: p_custom_mode => x_custom_mode))
539: then
540: update fun_rule_crit_params_tl
541: set user_param_name = nvl(x_user_param_name, user_param_name),
542: description = nvl(x_description, description),
543: tip_text = nvl(x_tip_text, tip_text),
544: source_lang = userenv('LANG')