[Home] [Help]
PACKAGE: APPS.FF_FFXWSDFF_PKG
Source
1 package ff_ffxwsdff_pkg AUTHID CURRENT_USER as
2 /* $Header: ffxwsdff.pkh 115.0 99/07/16 02:04:20 porting ship $ */
3
4 --------------------------------------------------------
5 -- I : Row Handlers for FF_FUNCTIONS --
6 --------------------------------------------------------
7
8 procedure insert_function(x_rowid in out varchar2,
9 x_function_id in out number,
10 x_class varchar2,
11 x_name varchar2,
12 x_alias_name varchar2,
13 x_business_group_id number,
14 x_created_by number,
15 x_creation_date date,
16 x_data_type varchar2,
17 x_definition varchar2,
18 x_last_updated_by number,
19 x_last_update_date date,
20 x_last_update_login number,
21 x_legislation_code varchar2,
22 x_description varchar2
23 );
24
25 procedure lock_function(x_rowid varchar2,
26 x_function_id number,
27 x_class varchar2,
28 x_name varchar2,
29 x_alias_name varchar2,
30 x_business_group_id number,
31 x_created_by number,
32 x_creation_date date,
33 x_data_type varchar2,
34 x_definition varchar2,
35 x_last_updated_by number,
36 x_last_update_date date,
37 x_last_update_login number,
38 x_legislation_code varchar2,
39 x_description varchar2
40 );
41
42 procedure update_function(x_rowid varchar2,
43 x_function_id number,
44 x_class varchar2,
45 x_name varchar2,
46 x_alias_name varchar2,
47 x_business_group_id number,
48 x_created_by number,
49 x_creation_date date,
50 x_data_type varchar2,
51 x_definition varchar2,
52 x_last_updated_by number,
53 x_last_update_date date,
54 x_last_update_login number,
55 x_legislation_code varchar2,
56 x_description varchar2
57 );
58
59 procedure delete_function(x_rowid varchar2,
60 x_function_id number);
61
62
63 -------------------------------------------------------------
64 -- II : Row Handlers for FF_FUNCTION_CONTEXT_USAGES --
65 -------------------------------------------------------------
66
67 procedure insert_context_usage(x_rowid in out varchar2,
68 x_function_id number,
69 x_sequence_number number,
70 x_context_id number
71 );
72
73 procedure lock_context_usage(x_rowid varchar2,
74 x_function_id number,
75 x_sequence_number number,
76 x_context_id number
77 );
78
79 procedure update_context_usage(x_rowid varchar2,
80 x_function_id number,
81 x_sequence_number number,
82 x_context_id number
83 );
84
85 procedure delete_context_usage(x_rowid varchar2);
86
87
88 -----------------------------------------------------------
89 -- III : Row Handlers for FF_FUNCTION_PARAMETERS --
90 -----------------------------------------------------------
91
92 procedure insert_parameter(x_rowid in out varchar2,
93 x_function_id number,
94 x_sequence_number number,
95 x_class varchar2,
96 x_continuing_parameter varchar2,
97 x_data_type varchar2,
98 x_name varchar2,
99 x_optional varchar2
100 );
101
102 procedure lock_parameter(x_rowid varchar2,
103 x_function_id number,
104 x_sequence_number number,
105 x_class varchar2,
106 x_continuing_parameter varchar2,
107 x_data_type varchar2,
108 x_name varchar2,
109 x_optional varchar2
110 );
111
112 procedure update_parameter(x_rowid varchar2,
113 x_function_id number,
114 x_sequence_number number,
115 x_class varchar2,
116 x_continuing_parameter varchar2,
117 x_data_type varchar2,
118 x_name varchar2,
119 x_optional varchar2
120 );
121
122 procedure delete_parameter(x_rowid varchar2);
123
124
125 ---------------------------------------------------------------------
126 -- IV : Other functions and procedures needed for FFXWSDFF --
127 ---------------------------------------------------------------------
128
129 ---------------------------------------------------------------------
130 -- next_parameter_sequence
131 --
132 -- Returns the next available parameter sequence number
133 -- to maintain a sequence of parameters within a particular function.
134 ---------------------------------------------------------------------
135
136 function next_parameter_sequence(p_function_id number) return number;
137
138
139 ---------------------------------------------------------------------
140 -- next_context_usage_sequence
141 --
142 -- Returns the next available context usage sequence number
143 -- to maintain a sequence of contexts within a particular function.
144 ---------------------------------------------------------------------
145
146 function next_context_usage_sequence(p_function_id number) return number;
147
148
149 ---------------------------------------------------------------------
150 -- check_alias_name
151 --
152 -- Ensures that the alias name is different to the function name
153 -- within the FUNCTION block.
154 ---------------------------------------------------------------------
155
156 procedure check_alias_name(p_function_name varchar2,
157 p_alias_name varchar2);
158
159
160 ---------------------------------------------------------------------
161 -- set_parameter_properties
162 --
163 -- Sets the correct OPTIONAL and CONTINUING_PARAMETER properties for
164 -- a parameter class of 'out' or 'in out'.
165 ---------------------------------------------------------------------
166
167 procedure set_parameter_properties(p_class varchar2,
168 p_optional in out varchar2,
169 p_continuing_parameter in out varchar2);
170
171 end ff_ffxwsdff_pkg;
172