1 PACKAGE csi_org_unit_vld_pvt AUTHID CURRENT_USER AS
2 /* $Header: csivouvs.pls 120.0.12000000.1 2007/01/16 15:40:21 appldev ship $ */
3
4 /*----------------------------------------------------------*/
5 /* Function Name : Is_Valid_instance_id */
6 /* */
7 /* Description : This function checks if instance */
8 /* ids are valid */
9 /*----------------------------------------------------------*/
10
11 FUNCTION Is_Valid_instance_id
12 (p_instance_id IN NUMBER
13 ,p_event IN VARCHAR2
14 ,p_stack_err_msg IN BOOLEAN DEFAULT TRUE)
15 RETURN BOOLEAN;
16
17
18
19
20
21 /*----------------------------------------------------------*/
22 /* Function Name : Val_inst_id_for_update */
23 /* */
24 /* Description : This function checks if instance */
25 /* ids can be updated */
26 /*----------------------------------------------------------*/
27
28 FUNCTION Val_inst_id_for_update
29 ( p_instance_id_new IN NUMBER
30 ,p_instance_id_old IN NUMBER
31 ,p_stack_err_msg IN BOOLEAN DEFAULT TRUE)
32 RETURN BOOLEAN;
33
34
35
36
37
38 /*----------------------------------------------------------*/
39 /* Function Name : Is_Valid_operating_unit_id */
40 /* */
41 /* Description : This function checks if operating */
42 /* unit ids are valid */
43 /*----------------------------------------------------------*/
44
45 FUNCTION Is_Valid_operating_unit_id
46 (p_operating_unit_id IN NUMBER
47 ,p_stack_err_msg IN BOOLEAN DEFAULT TRUE)
48 RETURN BOOLEAN;
49
50
51
52
53
54 /*----------------------------------------------------------*/
55 /* Function Name : Is_StartDate_Valid */
56 /* */
57 /* Description : This function checks if start date */
58 /* is valid */
59 /*----------------------------------------------------------*/
60
61 FUNCTION Is_StartDate_Valid
62 ( p_start_date IN OUT NOCOPY DATE,
63 p_end_date IN DATE,
64 p_instance_id IN NUMBER,
65 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
66 )
67 RETURN BOOLEAN;
68
69
70
71
72
73 /*----------------------------------------------------------*/
74 /* Function Name : Is_EndDate_Valid */
75 /* */
76 /* Description : This function checks if end date */
77 /* is valid */
78 /*----------------------------------------------------------*/
79 FUNCTION Is_EndDate_Valid
80 ( p_start_date IN DATE,
81 p_end_date IN DATE,
82 p_instance_id IN NUMBER,
83 p_instance_ou_id IN NUMBER,
84 p_txn_id IN NUMBER,
85 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
86 )
87 RETURN BOOLEAN;
88
89
90
91
92
93 /*----------------------------------------------------------*/
94 /* Function Name : Is_Valid_rel_type_code */
95 /* */
96 /* Description : This function checks if */
97 /* relationship_type_code is valid */
98 /*----------------------------------------------------------*/
99
100 FUNCTION Is_Valid_rel_type_code
101 (p_relationship_type_code IN VARCHAR2
102 ,p_stack_err_msg IN BOOLEAN DEFAULT TRUE)
103 RETURN BOOLEAN;
104
105
106
107
108
109 /*----------------------------------------------------------*/
110 /* Function Name : Alternate_PK_exists */
111 /* */
112 /* Description : This function checks if */
113 /* alternate PKs are valid */
114 /*----------------------------------------------------------*/
115
116 FUNCTION Alternate_PK_exists
117 (p_instance_id IN NUMBER
118 ,p_operating_unit_id IN NUMBER
119 ,p_relationship_type_code IN VARCHAR2
120 ,p_instance_ou_id IN NUMBER DEFAULT -9999
121 ,p_stack_err_msg IN BOOLEAN DEFAULT TRUE)
122 RETURN BOOLEAN;
123
124
125
126
127
128 /*----------------------------------------------------------*/
129 /* Function Name : Is_Valid_instance_ou_id */
130 /* */
131 /* Description : This function checks if */
132 /* instance_ou_id is valid */
133 /*----------------------------------------------------------*/
134
135 FUNCTION Is_Valid_instance_ou_id
136 ( p_instance_ou_id IN NUMBER
137 ,p_stack_err_msg IN BOOLEAN DEFAULT TRUE)
138 RETURN BOOLEAN;
139
140
141
142
143 /*----------------------------------------------------------*/
144 /* Function Name : Val_and_get_inst_ou_id */
145 /* */
146 /* Description : This function checks if */
147 /* instance_ou_id is valid */
148 /*----------------------------------------------------------*/
149
150 FUNCTION Val_and_get_inst_ou_id
151 ( p_instance_ou_id IN NUMBER
152 ,p_org_unit_rec OUT NOCOPY csi_datastructures_pub.organization_units_rec
153 ,p_stack_err_msg IN BOOLEAN DEFAULT TRUE)
154 RETURN BOOLEAN;
155
156
157
158
159 /*----------------------------------------------------------*/
160 /* Function Name : Is_Expire_Op */
161 /* */
162 /* Description : This function checks if it is a */
163 /* ids are valid and returns values */
164 /*----------------------------------------------------------*/
165
166 FUNCTION Is_Expire_Op
167 ( p_org_unit_rec IN csi_datastructures_pub.organization_units_rec
168 ,p_stack_err_msg IN BOOLEAN DEFAULT TRUE
169 )
170 RETURN BOOLEAN;
171
172
173
174
175 /*----------------------------------------------------------*/
176 /* Function Name : Is_Updatable */
177 /* */
178 /* Description : This function checks if this is a */
179 /* an updatable record */
180 /*----------------------------------------------------------*/
181
182 FUNCTION Is_Updatable
183 (p_old_date IN DATE
184 ,p_new_date IN DATE
185 ,p_stack_err_msg IN BOOLEAN DEFAULT TRUE
186 )
187 RETURN BOOLEAN;
188
189
190
191
192
193 /*----------------------------------------------------------*/
194 /* Function Name : Get_instance_ou_id */
195 /* */
196 /* Description : This function generates */
197 /* instance_ou_ids using a sequence */
198 /*----------------------------------------------------------*/
199 FUNCTION Get_instance_ou_id
200 ( p_stack_err_msg IN BOOLEAN DEFAULT TRUE)
201 RETURN NUMBER;
202
203
204
205
206 /*----------------------------------------------------------*/
207 /* Function Name : get_cis_i_org_assign_h_id */
208 /* */
209 /* Description : This function generates */
210 /* cis_i_org_assign_h_id using a sequence */
211 /*----------------------------------------------------------*/
212 FUNCTION get_cis_i_org_assign_h_id
213 ( p_stack_err_msg IN BOOLEAN DEFAULT TRUE)
214 RETURN NUMBER;
215
216
217
218
219 /*-------------------------------------------------------------- */
220 /* Function Name : get_object_version_number */
221 /* */
222 /* Description : This function generates object_version_number */
223 /* using previous version_numbers */
224 /*---------------------------------------------------------------*/
225 FUNCTION get_object_version_number
226 ( p_object_version_number IN NUMBER
227 ,p_stack_err_msg IN BOOLEAN DEFAULT TRUE
228 )
229 RETURN NUMBER;
230
231
232
233
234 /*-------------------------------------------------------------- */
235 /* Function Name : Is_valid_obj_ver_num */
236 /* */
237 /* Description : This function validate object_version_number */
238 /* using previous version numbers */
239 /*---------------------------------------------------------------*/
240 FUNCTION Is_valid_obj_ver_num
241 ( p_obj_ver_numb_new IN NUMBER
242 ,p_obj_ver_numb_old IN NUMBER
243 ,p_stack_err_msg IN BOOLEAN DEFAULT TRUE
244 )
245 RETURN BOOLEAN;
246
247
248
249
250 /*-------------------------------------------------------------- */
251 /* Function Name : get_full_dump_frequency */
252 /* */
253 /* Description : This function gets the dump frequency */
254 /* */
255 /*---------------------------------------------------------------*/
256
257 FUNCTION get_full_dump_frequency
258 (p_stack_err_msg IN BOOLEAN DEFAULT TRUE
259 )
260 RETURN NUMBER;
261
262 END csi_org_unit_vld_pvt;