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