1 package JTF_DPF_LOGICAL_FLOWS_PKG as
2 /* $Header: jtfdpffs.pls 120.2 2005/10/25 05:16:54 psanyal ship $ */
3 -- this creates a new in jtf_dpf_logical_flows_b and in _tl.
4 -- the ENABLED_CLONE_FLAG has special handling. It's set to 'F',
5 -- except if it would be the only Flow with this appid and flow_name,
6 -- in which case it's set to 'T'
7 procedure INSERT_ROW (
8 X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
9 X_LOGICAL_FLOW_ID in NUMBER,
10 X_LOGICAL_FLOW_HEAD_ID in NUMBER,
11 X_LOGICAL_FLOW_NAME in VARCHAR2,
12 X_SECURE_FLOW_FLAG in VARCHAR2,
13 X_VALIDATE_FLAG in VARCHAR2,
14 X_APPLICATION_ID in NUMBER,
15 X_FLOW_FINALIZER_CLASS in VARCHAR2,
16 X_RETURN_TO_PAGE_ID in NUMBER,
17 X_BASE_FLOW_FLAG in VARCHAR2,
18 -- X_ENABLED_CLONE_FLAG in VARCHAR2,
19 X_OBJECT_VERSION_NUMBER in NUMBER,
20 X_LOGICAL_FLOW_DESCRIPTION in VARCHAR2,
21 X_CREATION_DATE in DATE,
22 X_CREATED_BY in NUMBER,
23 X_LAST_UPDATE_DATE in DATE,
24 X_LAST_UPDATED_BY in NUMBER,
25 X_LAST_UPDATE_LOGIN in NUMBER);
26 procedure LOCK_ROW (
27 X_LOGICAL_FLOW_ID in NUMBER,
28 X_LOGICAL_FLOW_HEAD_ID in NUMBER,
29 X_LOGICAL_FLOW_NAME in VARCHAR2,
30 X_SECURE_FLOW_FLAG in VARCHAR2,
31 X_VALIDATE_FLAG in VARCHAR2,
32 X_APPLICATION_ID in NUMBER,
33 X_FLOW_FINALIZER_CLASS in VARCHAR2,
34 X_RETURN_TO_PAGE_ID in NUMBER,
35 X_BASE_FLOW_FLAG in VARCHAR2,
36 X_ENABLED_CLONE_FLAG in VARCHAR2,
37 X_OBJECT_VERSION_NUMBER in NUMBER,
38 X_LOGICAL_FLOW_DESCRIPTION in VARCHAR2
39 );
40 procedure UPDATE_ROW (
41 X_LOGICAL_FLOW_ID in NUMBER,
42 X_LOGICAL_FLOW_HEAD_ID in NUMBER,
43 X_LOGICAL_FLOW_NAME in VARCHAR2,
44 X_SECURE_FLOW_FLAG in VARCHAR2,
45 X_VALIDATE_FLAG in VARCHAR2,
46 X_APPLICATION_ID in NUMBER,
47 X_FLOW_FINALIZER_CLASS in VARCHAR2,
48 X_RETURN_TO_PAGE_ID in NUMBER,
49 X_BASE_FLOW_FLAG in VARCHAR2,
50 -- X_ENABLED_CLONE_FLAG in VARCHAR2,
51 X_OBJECT_VERSION_NUMBER in NUMBER,
52 X_LOGICAL_FLOW_DESCRIPTION in VARCHAR2,
53 X_LAST_UPDATE_DATE in DATE,
54 X_LAST_UPDATED_BY in NUMBER,
55 X_LAST_UPDATE_LOGIN in NUMBER
56 );
57 procedure DELETE_ROW (
58 X_LOGICAL_FLOW_ID in NUMBER
59 );
60 procedure ADD_LANGUAGE;
61
62 -- find the flow_id for a flow which has the given name and appid.
63 -- if there are more than one flow_id which match, preference is
64 -- given to:
65 -- (1) the oldest which has last_updated_by = x_last_updated_by, if any, else
66 -- (2) the oldest
67 -- where 'oldest' means that it has the earliest last_update_date
68 --
69 -- If no pages have that name and appid, returns null
70
71 function find_oldest_prefer_owned_by(x_logical_flow_name varchar2,
72 x_application_id varchar2, x_last_updated_by number) return number;
73
74 procedure insert_flow_params(
75 x_flow_id number,
76 x_parameter_name varchar2,
77 x_parameter_type varchar2,
78 x_parameter_sequence varchar2,
79 x_owner varchar2);
80
81 procedure update_flow_params(
82 x_flow_id number,
83 x_parameter_name varchar2,
84 x_parameter_type varchar2,
85 x_parameter_sequence varchar2,
86 x_owner varchar2);
87
88 procedure translate_row(
89 x_flow_name varchar2,
90 x_application_id varchar2,
91 x_flow_description varchar2,
92 x_owner varchar2);
93
94 procedure load_row(
95 X_APPLICATION_ID VARCHAR2,
96 X_LOGICAL_FLOW_NAME VARCHAR2,
97 X_HEAD_LOGICAL_PAGE_NAME VARCHAR2,
98 X_HEAD_LOGICAL_PAGE_APP_ID VARCHAR2,
99 X_SECURE_FLOW_FLAG VARCHAR2,
100 X_VALIDATE_FLAG VARCHAR2,
101 X_FLOW_FINALIZER_CLASS VARCHAR2,
102 X_RTN_TO_LOGICAL_PAGE_NAME VARCHAR2,
103 X_RTN_TO_LOGICAL_PAGE_APP_ID VARCHAR2,
104 X_BASE_FLOW_FLAG VARCHAR2,
105 -- X_ENABLED_CLONE_FLAG VARCHAR2,
106 X_LOGICAL_FLOW_DESCRIPTION VARCHAR2,
107 X_OWNER in VARCHAR2);
108
109 -- an entry into table jtf_dpf_lgcl_next_rules. We should
110 -- decide whether this is an update or an insert, based on
111 -- the rules:
112 -- (1) a LOGICAL IS UNIQUELY identified logical_page_application_id +
113 -- logical_page_name
114 -- (2) for any (flow, logical) there can only be one rule for which
115 -- DEFAULT_NEXT_FLAG='T'
116 -- (3) for any (flow, logical) there can only be one rule which has
117 -- DEFAULT_NEXT_FLAG='F' and the given RULE_EVAL_SEQ
118 procedure ins_upd_or_ign_lgcl_next_rules(
119 x_rule_eval_seq varchar2,
120 x_default_next_flag varchar2,
121 x_logical_flow_application_id varchar2,
122 x_logical_flow_name varchar2,
123 x_logical_page_application_id varchar2,
124 x_logical_page_name varchar2,
125 x_logical_next_page_app_id varchar2,
126 x_logical_next_page_name varchar2,
127 x_rule_application_id varchar2,
128 x_rule_name varchar2,
129 x_owner varchar2,
130 x_force_update_flag varchar2);
131
132 end JTF_DPF_LOGICAL_FLOWS_PKG;
[Home] [Help]