1 package JTF_DPF_LOGICAL_PAGES_PKG as
2 /* $Header: jtfdpfls.pls 120.2 2005/10/25 05:17:31 psanyal ship $ */
3 procedure INSERT_ROW (
4 X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5 X_LOGICAL_PAGE_ID in NUMBER,
6 X_LOGICAL_PAGE_NAME in VARCHAR2,
7 X_LOGICAL_PAGE_TYPE in VARCHAR2,
8 X_APPLICATION_ID in NUMBER,
9 X_ENABLED_FLAG in VARCHAR2,
10 X_PAGE_CONTROLLER_CLASS in VARCHAR2,
11 X_PAGE_PERMISSION_NAME in VARCHAR2,
12 X_OBJECT_VERSION_NUMBER in NUMBER,
13 X_LOGICAL_PAGE_DESCRIPTION in VARCHAR2,
14 X_CREATION_DATE in DATE,
15 X_CREATED_BY in NUMBER,
16 X_LAST_UPDATE_DATE in DATE,
17 X_LAST_UPDATED_BY in NUMBER,
18 X_LAST_UPDATE_LOGIN in NUMBER);
19 procedure LOCK_ROW (
20 X_LOGICAL_PAGE_ID in NUMBER,
21 X_LOGICAL_PAGE_NAME in VARCHAR2,
22 X_LOGICAL_PAGE_TYPE in VARCHAR2,
23 X_APPLICATION_ID in NUMBER,
24 X_ENABLED_FLAG in VARCHAR2,
25 X_PAGE_CONTROLLER_CLASS in VARCHAR2,
26 X_PAGE_PERMISSION_NAME in VARCHAR2,
27 X_OBJECT_VERSION_NUMBER in NUMBER,
28 X_LOGICAL_PAGE_DESCRIPTION in VARCHAR2
29 );
30 procedure UPDATE_ROW (
31 X_LOGICAL_PAGE_ID in NUMBER,
32 X_LOGICAL_PAGE_NAME in VARCHAR2,
33 X_LOGICAL_PAGE_TYPE in VARCHAR2,
34 X_APPLICATION_ID in NUMBER,
35 X_ENABLED_FLAG in VARCHAR2,
36 X_PAGE_CONTROLLER_CLASS in VARCHAR2,
37 X_PAGE_PERMISSION_NAME in VARCHAR2,
38 X_OBJECT_VERSION_NUMBER in NUMBER,
39 X_LOGICAL_PAGE_DESCRIPTION in VARCHAR2,
40 X_LAST_UPDATE_DATE in DATE,
41 X_LAST_UPDATED_BY in NUMBER,
42 X_LAST_UPDATE_LOGIN in NUMBER
43 );
44 procedure DELETE_ROW (
45 X_LOGICAL_PAGE_ID in NUMBER
46 );
47 procedure ADD_LANGUAGE;
48
49 procedure TRANSLATE_ROW (
50 X_LOGICAL_PAGE_NAME IN VARCHAR2,
51 X_APPLICATION_ID IN VARCHAR2,
52 X_LOGICAL_PAGE_DESCRIPTION IN VARCHAR2,
53 X_OWNER IN VARCHAR2
54 );
55
56 procedure LOAD_ROW (
57 X_LOGICAL_PAGE_NAME in VARCHAR2,
58 X_APPLICATION_ID in VARCHAR2,
59 X_LOGICAL_PAGE_DESCRIPTION in VARCHAR2,
60 -- X_NUM_NON_DEF_RULES IN VARCHAR2,
61 X_LOGICAL_PAGE_TYPE IN VARCHAR2,
62 X_ENABLED_FLAG IN VARCHAR2,
63 X_PAGE_CONTROLLER_CLASS IN VARCHAR2,
64 X_PAGE_PERMISSION_NAME IN VARCHAR2,
65 X_OWNER in VARCHAR2
66 );
67
68 -- this procedures truncates the list of l2p rules if needed.
69 -- We do this if the number of non-default rules is greater
70 -- than x_num_non_def_rules, and either we own the rows that make
71 -- up the rules, or force_update_flag = 'T'.
72
73 procedure ceiling_lgcl_phy(
74 X_LOGICAL_PAGE_NAME VARCHAR2,
75 X_APPLICATION_ID VARCHAR2,
76 X_NUM_NON_DEF_RULES VARCHAR2,
77 X_OWNER VARCHAR2,
78 X_FORCE_UPDATE_FLAG VARCHAR2);
79
80 -- this function's job is to find a logical which has
81 -- the given logical_page_name and appid. Returns the logical_page_id
82 -- from table jtf_dpf_logical_pagse_b. if no logical matches,
83 -- returns null.
84 function find(
85 x_logical_page_name varchar2,
86 x_application_id in varchar2
87 ) return number;
88
89 -- an entry into table jtf_dpf_lgcl_phy_rules. We should
90 -- decide whether this is an insert, update, or ingore, based on
91 -- the rules:
92 -- (1) if this set of l2p rules is not owned by us, then we should
93 -- leave it alone (unless x_force_update_flag='TRUE')
94 -- (2) a LOGICAL IS UNIQUELY identified logical_page_application_id +
95 -- logical_page_name
96 -- (3) for any logical, there can only be one rule for which
97 -- DEFAULT_PAGE_FLAG='T'
98 -- (4) for any logical, there can only be one rule which has
99 -- DEFAULT_PAGE_FLAG='F' and the given RULE_EVAL_SEQUENCE
100 procedure ins_upd_or_ign_lgcl_phy_rules(
101 x_rule_eval_sequence varchar2,
102 x_default_page_flag varchar2,
103 x_logical_page_application_id varchar2,
104 x_logical_page_name varchar2,
105 x_physical_page_application_id varchar2,
106 x_physical_page_name varchar2,
107 x_rule_application_id varchar2,
108 x_rule_name varchar2,
109 x_owner varchar2,
110 x_force_update_flag varchar2);
111
112 end JTF_DPF_LOGICAL_PAGES_PKG;