[Home] [Help]
PACKAGE: APPS.CS_BILLRATE_PVT
Source
1 Package CS_BILLRATE_PVT AUTHID CURRENT_USER AS
2 /* $Header: csctcbrs.pls 115.0 99/07/16 08:49:28 porting ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE BillRate_Rec_Type IS RECORD (
7 coverage_bill_rate_id NUMBER := NULL,
8 coverage_billing_type_id NUMBER := NULL,
9 rate_type_code CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := NULL,
10 unit_of_measure_code CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := NULL,
11 flat_rate NUMBER := NULL,
12 percent_rate NUMBER := NULL,
13 last_update_date CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := NULL,
14 last_updated_by NUMBER := NULL,
15 creation_date CS_COV_BILL_RATES.CREATION_DATE%TYPE := NULL,
16 created_by NUMBER := NULL,
17 last_update_login NUMBER := NULL,
18 attribute1 CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := NULL,
19 attribute2 CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := NULL,
20 attribute3 CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := NULL,
21 attribute4 CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := NULL,
22 attribute5 CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := NULL,
23 attribute6 CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := NULL,
24 attribute7 CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := NULL,
25 attribute8 CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := NULL,
26 attribute9 CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := NULL,
27 attribute10 CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := NULL,
28 attribute11 CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := NULL,
29 attribute12 CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := NULL,
30 attribute13 CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := NULL,
31 attribute14 CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := NULL,
32 attribute15 CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := NULL,
33 context CS_COV_BILL_RATES.CONTEXT%TYPE := NULL,
34 object_version_number NUMBER := NULL);
35 G_MISS_billrate_rec BillRate_Rec_Type;
36 TYPE BillRate_Val_Rec_Type IS RECORD (
37 coverage_bill_rate_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
38 coverage_billing_type_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
39 rate_type_code CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
40 unit_of_measure_code CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
41 flat_rate NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
42 percent_rate NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
43 last_update_date CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
44 last_updated_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
45 creation_date CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
46 created_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
47 last_update_login NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
48 attribute1 CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
49 attribute2 CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
50 attribute3 CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
51 attribute4 CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
52 attribute5 CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
53 attribute6 CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
54 attribute7 CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
55 attribute8 CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
56 attribute9 CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
57 attribute10 CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
58 attribute11 CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
59 attribute12 CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
60 attribute13 CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
61 attribute14 CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
62 attribute15 CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
63 context CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
64 object_version_number NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
65 G_MISS_billrate_val_rec BillRate_Val_Rec_Type;
66 ---------------------------------------------------------------------------
67 -- GLOBAL MESSAGE CONSTANTS
68 ---------------------------------------------------------------------------
69 G_FND_APP CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FND_APP;
70 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_UNABLE_TO_RESERVE_REC;
71 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
72 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
73 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
74 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
75 G_INVALID_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
76 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
77 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_PARENT_TABLE_TOKEN;
78 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_CHILD_TABLE_TOKEN;
79 ---------------------------------------------------------------------------
80 -- GLOBAL VARIABLES
81 ---------------------------------------------------------------------------
82 G_PKG_NAME CONSTANT VARCHAR2(200) := 'CS_BILLRATE_PVT';
83 G_APP_NAME CONSTANT VARCHAR2(3) := TAPI_DEV_KIT.G_APP_NAME;
84 ---------------------------------------------------------------------------
85 -- Procedures and Functions
86 ---------------------------------------------------------------------------
87
88 PROCEDURE insert_row
89 (
90 p_api_version IN NUMBER,
91 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
92 p_validation_level IN NUMBER,
93 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
94 x_return_status OUT VARCHAR2,
95 x_msg_count OUT NUMBER,
96 x_msg_data OUT VARCHAR2,
97 p_billrate_rec IN BillRate_Rec_Type := G_MISS_BILLRATE_REC,
98 x_coverage_bill_rate_id OUT NUMBER,
99 x_object_version_number OUT NUMBER);
100 PROCEDURE insert_row
101 (
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
104 p_validation_level IN NUMBER,
105 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
106 x_return_status OUT VARCHAR2,
107 x_msg_count OUT NUMBER,
108 x_msg_data OUT VARCHAR2,
109 p_coverage_billing_type_id IN NUMBER := NULL,
110 p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := NULL,
111 p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := NULL,
112 p_flat_rate IN NUMBER := NULL,
113 p_percent_rate IN NUMBER := NULL,
114 p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := NULL,
115 p_last_updated_by IN NUMBER := NULL,
116 p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := NULL,
117 p_created_by IN NUMBER := NULL,
118 p_last_update_login IN NUMBER := NULL,
119 p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := NULL,
120 p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := NULL,
121 p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := NULL,
122 p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := NULL,
123 p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := NULL,
124 p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := NULL,
125 p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := NULL,
126 p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := NULL,
127 p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := NULL,
128 p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := NULL,
129 p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := NULL,
130 p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := NULL,
131 p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := NULL,
132 p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := NULL,
133 p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := NULL,
134 p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := NULL,
135 p_object_version_number IN NUMBER := NULL,
136 x_coverage_bill_rate_id OUT NUMBER,
137 x_object_version_number OUT NUMBER);
138 Procedure lock_row
139 (
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
142 p_validation_level IN NUMBER,
143 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
144 x_return_status OUT VARCHAR2,
145 x_msg_count OUT NUMBER,
146 x_msg_data OUT VARCHAR2,
147 p_coverage_bill_rate_id IN NUMBER,
148 p_object_version_number IN NUMBER);
149 Procedure update_row
150 (
151 p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
153 p_validation_level IN NUMBER,
154 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
155 x_return_status OUT VARCHAR2,
156 x_msg_count OUT NUMBER,
157 x_msg_data OUT VARCHAR2,
158 p_billrate_val_rec IN BillRate_Val_Rec_Type := G_MISS_BILLRATE_VAL_REC,
159 x_object_version_number OUT NUMBER);
160 Procedure update_row
161 (
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
164 p_validation_level IN NUMBER,
165 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
166 x_return_status OUT VARCHAR2,
167 x_msg_count OUT NUMBER,
168 x_msg_data OUT VARCHAR2,
169 p_coverage_bill_rate_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
170 p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
171 p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
172 p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
173 p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
174 p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
175 p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
176 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
177 p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
178 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
179 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
180 p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
181 p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
182 p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
186 p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
183 p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
184 p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
185 p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
187 p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
188 p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
189 p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
190 p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
191 p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
192 p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
193 p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
194 p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
195 p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
196 p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
197 x_object_version_number OUT NUMBER);
198 Procedure delete_row
199 (
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
202 p_validation_level IN NUMBER,
203 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
204 x_return_status OUT VARCHAR2,
205 x_msg_count OUT NUMBER,
206 x_msg_data OUT VARCHAR2,
207 p_coverage_bill_rate_id IN NUMBER);
208 PROCEDURE validate_row
209 (
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
212 p_validation_level IN NUMBER,
213 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
214 x_return_status OUT VARCHAR2,
215 x_msg_count OUT NUMBER,
216 x_msg_data OUT VARCHAR2,
217 p_billrate_val_rec IN BillRate_Val_Rec_Type := G_MISS_BILLRATE_VAL_REC);
218 PROCEDURE validate_row
219 (
220 p_api_version IN NUMBER,
221 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
222 p_validation_level IN NUMBER,
223 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
224 x_return_status OUT VARCHAR2,
225 x_msg_count OUT NUMBER,
226 x_msg_data OUT VARCHAR2,
227 p_coverage_bill_rate_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
228 p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
229 p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
230 p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
231 p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
232 p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
233 p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
234 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
235 p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
236 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
237 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
238 p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
239 p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
240 p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
241 p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
242 p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
243 p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
244 p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
245 p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
246 p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
247 p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
248 p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
249 p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
250 p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
251 p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
252 p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
253 p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
254 p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
255 END CS_BILLRATE_PVT;