1 PACKAGE csi_pricing_attrib_vld_pvt AUTHID CURRENT_USER AS
2 /* $Header: csivpavs.pls 120.0.12010000.1 2008/07/25 08:16:23 appldev ship $ */
3
4 G_PKG_NAME VARCHAR2(30) := 'csi_extend_attrib_vld_pvt';
5
6 /*----------------------------------------------------------*/
7 /* Function Name : Is_Valid_instance_id */
8 /* */
9 /* Description : This function checks if instance */
10 /* ids are valid */
11 /*----------------------------------------------------------*/
12
13 FUNCTION Is_Valid_instance_id
14 (p_instance_id IN NUMBER
15 ,p_event IN VARCHAR2
16 ,p_stack_err_msg IN BOOLEAN DEFAULT TRUE)
17 RETURN BOOLEAN;
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 /* Function Name : Is_StartDate_Valid */
38 /* */
39 /* Description : This function checks if start date */
40 /* is valid */
41 /*----------------------------------------------------------*/
42
43 FUNCTION Is_StartDate_Valid
44 (p_start_date IN OUT NOCOPY DATE,
45 p_end_date IN DATE,
46 p_instance_id IN NUMBER,
47 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
48 )
49 RETURN BOOLEAN;
50
51
52
53
54 /*----------------------------------------------------------*/
55 /* Function Name : Is_EndDate_Valid */
56 /* */
57 /* Description : This function checks if end date */
58 /* is valid */
59 /*----------------------------------------------------------*/
60
61 FUNCTION Is_EndDate_Valid
62 ( p_start_date IN DATE,
63 p_end_date IN DATE,
64 p_instance_id IN NUMBER,
65 p_pricing_attr_id IN NUMBER,
66 p_txn_id IN NUMBER,
67 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
68 ) RETURN BOOLEAN;
69
70
71
72
73 /*----------------------------------------------------------*/
74 /* Function Name : Is_Valid_pricing_attrib_id */
75 /* */
76 /* Description : This function checks if pricing_attrib */
77 /* ids are valid */
78 /*----------------------------------------------------------*/
79
80 FUNCTION Is_Valid_pricing_attrib_id
81 (p_pricing_attrib_id IN NUMBER
82 ,p_stack_err_msg IN BOOLEAN DEFAULT TRUE
83 )
84 RETURN BOOLEAN;
85
86
87
88 /*----------------------------------------------------------*/
89 /* Function Name : Val_and_get_pri_att_id */
90 /* */
91 /* Description : This function checks if pricing_attrib */
92 /* ids are valid and returns values */
93 /*----------------------------------------------------------*/
94
95 FUNCTION Val_and_get_pri_att_id
96 ( p_pricing_attrib_id IN NUMBER
97 ,p_pricing_attribs_rec OUT NOCOPY csi_datastructures_pub.pricing_attribs_rec
98 ,p_stack_err_msg IN BOOLEAN DEFAULT TRUE
99 )
100 RETURN BOOLEAN;
101
102
103
104
105 /*----------------------------------------------------------*/
106 /* Function Name : Is_Expire_Op */
107 /* */
108 /* Description : This function checks if it is a */
109 /* ids are valid and returns values */
110 /*----------------------------------------------------------*/
111
112 FUNCTION Is_Expire_Op
113 (p_pricing_attribs_rec IN csi_datastructures_pub.pricing_attribs_rec
114 ,p_stack_err_msg IN BOOLEAN DEFAULT TRUE
115 )
116 RETURN BOOLEAN;
117
118
119
120 /*----------------------------------------------------------*/
121 /* Function Name : Is_Updatable */
122 /* */
123 /* Description : This function checks if this is a */
124 /* an updatable record */
125 /*----------------------------------------------------------*/
126
127 FUNCTION Is_Updatable
128 (p_old_date IN DATE
129 ,p_new_date IN DATE
130 ,p_stack_err_msg IN BOOLEAN DEFAULT TRUE
131 )
132 RETURN BOOLEAN;
133
134
135
136
137
138 /*----------------------------------------------------------*/
139 /* Function Name : get_pricing_attrib_id */
140 /* */
141 /* Description : This function generates */
142 /* pricing_attrib_id using a sequence */
143 /*----------------------------------------------------------*/
144
145 FUNCTION get_pricing_attrib_id
146 ( p_stack_err_msg IN BOOLEAN DEFAULT TRUE
147 )
148 RETURN NUMBER;
149
150
151
152
153 /*----------------------------------------------------------*/
154 /* Function Name : get_pricing_attrib_h_id */
155 /* */
156 /* Description : This function generates */
157 /* pricing_attrib_h_id using a sequence */
158 /*----------------------------------------------------------*/
159
160 FUNCTION get_pricing_attrib_h_id
161 ( p_stack_err_msg IN BOOLEAN DEFAULT TRUE
162 )
163 RETURN NUMBER;
164
165
166
167
168 /*-------------------------------------------------------------- */
169 /* Function Name : get_object_version_number */
170 /* */
171 /* Description : This function generates object_version_number */
172 /* using previous version numbers */
173 /*---------------------------------------------------------------*/
174
175 FUNCTION get_object_version_number
176 (p_object_version_number IN NUMBER
177 ,p_stack_err_msg IN BOOLEAN DEFAULT TRUE
178 )
179 RETURN NUMBER;
180
181
182
183
184 /*-------------------------------------------------------------- */
185 /* Function Name : Is_valid_obj_ver_num */
186 /* */
187 /* Description : This function generates object_version_number */
188 /* using previous version numbers */
189 /*---------------------------------------------------------------*/
190
191 FUNCTION Is_valid_obj_ver_num
192 (p_obj_ver_numb_new IN NUMBER
193 ,p_obj_ver_numb_old IN NUMBER
194 ,p_stack_err_msg IN BOOLEAN DEFAULT TRUE
195 )
196 RETURN BOOLEAN;
197
198
199
200
201 /*-------------------------------------------------------------- */
202 /* Function Name : get_full_dump_frequency */
203 /* */
204 /* Description : This function gets the dump frequency */
205 /*---------------------------------------------------------------*/
206
207 FUNCTION get_full_dump_frequency
208 (p_stack_err_msg IN BOOLEAN DEFAULT TRUE
209 )
210 RETURN NUMBER;
211
212
213 END csi_pricing_attrib_vld_pvt;