APPS.JTF_DPF dependencies on JTF_DPF_RULES_B

Line 181: q3_c1 jtf_dpf_rules_b.rule_name%type;

177: retval out NOCOPY physical_non_default_tbl) is
178: ddindx binary_integer := 1;
179: q2_c1 jtf_dpf_physical_pages_b.physical_page_name%type;
180: q2_c2 fnd_application.application_short_name%type;
181: q3_c1 jtf_dpf_rules_b.rule_name%type;
182: q3_c2 fnd_application.application_short_name%type;
183: cursor c1(pp_asn varchar2) is
184: select unique
185: lp.logical_page_name,

Line 219: from jtf_dpf_rules_b r

215: r.application_id
216: -- (select application_short_name from fnd_application fa
217: -- where fa.application_id = r.application_id)
218: into q3_c1, q3_c2_temp
219: from jtf_dpf_rules_b r
220: where r.rule_id = c1_rec.rule_id;
221:
222: select application_short_name into q3_c2 from fnd_application
223: where fnd_application.application_id = q3_c2_temp;

Line 247: from jtf_dpf_rules_b r, jtf_dpf_rule_params rp

243: -- r.rule_description,
244: rp.rule_param_name,
245: rp.rule_param_value,
246: rp.rule_param_condition
247: from jtf_dpf_rules_b r, jtf_dpf_rule_params rp
248: where
249: r.rule_id = rp.rule_id and
250: r.application_id =
251: (select application_id from fnd_application fa

Line 357: q3_c2 jtf_dpf_rules_b.rule_name%type;

353: lnr.default_next_flag='F'
354: order by lnr.rule_eval_seq;
355: ddindx binary_integer := 1;
356: q3_c1 fnd_application.application_short_name%type;
357: q3_c2 jtf_dpf_rules_b.rule_name%type;
358: q4_c1 fnd_application.application_short_name%type;
359: q4_c2 jtf_dpf_logical_pages_b.logical_page_name%type;
360: q5_c1 fnd_application.application_short_name%type;
361: q5_c2 jtf_dpf_logical_pages_b.logical_page_name%type;

Line 374: from jtf_dpf_rules_b r

370: -- (select application_short_name from fnd_application fa
371: -- where fa.application_id = r.application_id),
372: r.rule_name
373: into q3_c1_temp, q3_c2
374: from jtf_dpf_rules_b r
375: where r.rule_id = q2_rec.rule_id;
376:
377: select application_short_name
378: into q3_c1

Line 500: delete from jtf_dpf_rules_b where rule_id=p_rule_id;

496: -- no effect if the rule doesn't exist
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:

Line 524: from jtf_dpf_rules_b

520: -- is the proposed new name already taken? count the number
521: -- of rows which already have this name and appid, but which have a
522: -- different logical_flow_id
523: select count(*) into existential
524: from jtf_dpf_rules_b
525: where rule_id <> p_rule_id and
526: rule_name = upd.p_new_name and
527: application_id = t_appid;
528:

Line 531: update jtf_dpf_rules_b

527: application_id = t_appid;
528:
529: if existential > 0 then return 2; end if;
530:
531: update jtf_dpf_rules_b
532: set
533: application_id=t_appid,
534: rule_name = upd.p_new_name,
535: -- rule_description = p_new_descr,

Line 568: select count(*) into existential from jtf_dpf_rules_b

564: select application_id into t_appid
565: from fnd_application
566: where application_short_name = p_asn;
567:
568: select count(*) into existential from jtf_dpf_rules_b
569: where rule_name = p_name and
570: application_id = t_appid;
571:
572: if existential <> 0 then return 2; end if;

Line 591: -- insert into jtf_dpf_rules_b(

587: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
588: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
589:
590:
591: -- insert into jtf_dpf_rules_b(
592: -- rule_id,
593: -- application_id, rule_name, -- rule_description,
594: -- OBJECT_VERSION_NUMBER,
595: -- CREATED_BY,