DBA Data[Home] [Help]

APPS.JTF_DPF dependencies on JTF_DPF_LGCL_PHY_RULES

Line 42: rule_eval_sequence jtf_dpf_lgcl_phy_rules.rule_eval_sequence%type,

38:
39: -- created by sel15.sql
40: type physical_non_default is record(
41: logical_name jtf_dpf_logical_pages_b.logical_page_name%type,
42: rule_eval_sequence jtf_dpf_lgcl_phy_rules.rule_eval_sequence%type,
43: rule_asn fnd_application.application_short_name%type,
44: rule_name jtf_dpf_rules_b.rule_name%type,
45: phys_asn fnd_application.application_short_name%type,
46: phys_id number,

Line 289: -- - jtf_dpf_lgcl_phy_rules

285: -- logical editing procedures:
286: -- removes any instances with logical_page_id from tables:
287: -- - jtf_dpf_logical_pages
288: -- - jtf_dpf_lgcl_next_rules
289: -- - jtf_dpf_lgcl_phy_rules
290: -- removes the logical from JTF_DPF_LOGICAL_PAGES. Also removes
291: -- any jtf_dpf_lgcl_phy_rules with the same logical_page_id
292: procedure logical_delete(p_logical_page_id number);
293:

Line 291: -- any jtf_dpf_lgcl_phy_rules with the same logical_page_id

287: -- - jtf_dpf_logical_pages
288: -- - jtf_dpf_lgcl_next_rules
289: -- - jtf_dpf_lgcl_phy_rules
290: -- removes the logical from JTF_DPF_LOGICAL_PAGES. Also removes
291: -- any jtf_dpf_lgcl_phy_rules with the same logical_page_id
292: procedure logical_delete(p_logical_page_id number);
293:
294: -- update the jtf_dpf_logical_pages table so that the logical identified
295: -- by logical_page_id has the specified ASN, NAME, and DESCR.

Line 296: -- Also updates the JTF_DPF_LGCL_PHY_RULES table,

292: procedure logical_delete(p_logical_page_id number);
293:
294: -- update the jtf_dpf_logical_pages table so that the logical identified
295: -- by logical_page_id has the specified ASN, NAME, and DESCR.
296: -- Also updates the JTF_DPF_LGCL_PHY_RULES table,
297: -- so that the one default_next_flag='T' row it has for this logical_page_id
298: -- indicates the specified default_physical page
299: --
300: -- This does NOT update the defaultPhysical of the Logical if

Line 324: -- 1 row into JTF_DPF_LOGICAL_PAGES and one row into JTF_DPF_LGCL_PHY_RULES

320: function logical_update(p_logical_page_id number,
321: upd logical_update_rec) return number;
322:
323: -- creates a new logical with the designated parameters. Always inserts
324: -- 1 row into JTF_DPF_LOGICAL_PAGES and one row into JTF_DPF_LGCL_PHY_RULES
325: --
326: -- Returns one of the following values:
327: -- 1: new one successfully created
328: -- 2: new one not created: the given "p_new_name" is already taken

Line 341: -- updates table JTF_DPF_LGCL_PHY_RULES, so that the default_next_flag='F'

337: p_new_page_permission_name varchar2,
338: p_default_physical_id JTF_DPF_PHYSICAL_PAGES_B.PHYSICAL_PAGE_ID%type)
339: return number;
340:
341: -- updates table JTF_DPF_LGCL_PHY_RULES, so that the default_next_flag='F'
342: -- rows which it contains for this logical_page_id are the rules and
343: -- results specified by p_new_ones
344: procedure logical_set_non_default_phys(p_logical_page_id number,
345: p_new_ones new_phys_non_def_tbl);