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