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