APPS.JTF_DPF dependencies on JTF_DPF_RULES_TL

Line 255: t_rules_descr jtf_dpf_rules_tl.rule_description%type;

251: (select application_id from fnd_application fa
252: where fa.application_short_name = pp_asn)
253: order by rp.rule_param_sequence;
254: ddindx binary_integer := 1;
255: t_rules_descr jtf_dpf_rules_tl.rule_description%type;
256: begin
257: for c1_rec in c1(asn) loop
258: -- create a new record
259: select rule_description into t_rules_descr

Line 260: from jtf_dpf_rules_tl jrtl

256: begin
257: for c1_rec in c1(asn) loop
258: -- create a new record
259: select rule_description into t_rules_descr
260: from jtf_dpf_rules_tl jrtl
261: where jrtl.rule_id = c1_rec.rule_id and
262: jrtl.language = p_lang;
263:
264: retval(ddindx).rule_id := c1_rec.rule_id;

Line 501: delete from jtf_dpf_rules_tl where rule_id=p_rule_id;

497: procedure rule_delete(p_rule_id number) is
498: begin
499: delete from jtf_dpf_rule_params where rule_id = p_rule_id;
500: delete from jtf_dpf_rules_b where rule_id=p_rule_id;
501: delete from jtf_dpf_rules_tl where rule_id=p_rule_id;
502: -- commit;
503: end;
504:
505: -- change the rule specified by rule_id so that it is of the specified

Line 543: update jtf_dpf_rules_tl

539: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
540: where rule_id = p_rule_id;
541:
542: if upd.p_new_descr is null or fnd_api.g_miss_char <> upd.p_new_descr then
543: update jtf_dpf_rules_tl
544: set rule_description = upd.p_new_descr,
545: -- object_version_number = OBJECT_VERSION_NUMBER+1,
546: last_update_date = sysdate,
547: last_updated_by = fnd_global.user_id,

Line 608: -- insert into jtf_dpf_rules_tl(

604: -- SYSDATE,
605: -- FND_GLOBAL.USER_ID,
606: -- FND_GLOBAL.CONC_LOGIN_ID);
607: --
608: -- insert into jtf_dpf_rules_tl(
609: -- RULE_ID,
610: -- LANGUAGE,
611: -- SOURCE_LANG,
612: -- RULE_DESCRIPTION,