[Home] [Help]
PACKAGE: APPS.CS_CONTRACTTMPL_PVT
Source
1 Package CS_CONTRACTTMPL_PVT AUTHID CURRENT_USER AS
2 /* $Header: csctctes.pls 115.0 99/07/16 08:51:43 porting ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE ContractTmpl_Rec_Type IS RECORD (
7 contract_template_id NUMBER := NULL,
8 name CS_CONTRACT_TEMPLATES.NAME%TYPE := NULL,
9 contract_type_id NUMBER := NULL,
10 duration NUMBER := NULL,
11 period_code CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := NULL,
12 workflow CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := NULL,
13 price_list_id NUMBER := NULL,
14 currency_code CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := NULL,
15 conversion_type_code CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := NULL,
16 conversion_rate NUMBER := NULL,
17 conversion_date CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := NULL,
18 invoicing_rule_id NUMBER := NULL,
19 accounting_rule_id NUMBER := NULL,
20 billing_frequency_period CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
21 create_sales_order CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := NULL,
22 renewal_rule CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := NULL,
23 termination_rule CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := NULL,
24 terms_id NUMBER := NULL,
25 tax_handling CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := NULL,
26 tax_exempt_num CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := NULL,
27 tax_exempt_reason_code CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := NULL,
28 contract_amount NUMBER := NULL,
29 discount_id NUMBER := NULL,
30 last_update_date CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := NULL,
31 last_updated_by NUMBER := NULL,
32 creation_date CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := NULL,
33 created_by NUMBER := NULL,
34 auto_renewal_flag CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := NULL,
35 last_update_login NUMBER := NULL,
36 start_date_active CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := NULL,
37 end_date_active CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := NULL,
38 attribute1 CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := NULL,
39 attribute2 CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := NULL,
40 attribute3 CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := NULL,
41 attribute4 CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := NULL,
42 attribute5 CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := NULL,
43 attribute6 CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := NULL,
44 attribute7 CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := NULL,
45 attribute8 CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := NULL,
46 attribute9 CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := NULL,
47 attribute10 CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := NULL,
48 attribute11 CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := NULL,
49 attribute12 CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := NULL,
50 attribute13 CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := NULL,
51 attribute14 CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := NULL,
52 attribute15 CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := NULL,
53 context CS_CONTRACT_TEMPLATES.CONTEXT%TYPE := NULL,
54 object_version_number NUMBER := NULL);
55 G_MISS_contracttmpl_rec ContractTmpl_Rec_Type;
56 TYPE ContractTmpl_Val_Rec_Type IS RECORD (
57 contract_template_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
58 name CS_CONTRACT_TEMPLATES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
59 contract_type_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
60 duration NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
61 period_code CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
62 workflow CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
63 price_list_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
64 currency_code CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
65 conversion_type_code CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
66 conversion_rate NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
67 conversion_date CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
68 invoicing_rule_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
69 accounting_rule_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
70 billing_frequency_period CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
71 create_sales_order CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
72 renewal_rule CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
73 termination_rule CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
74 terms_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
75 tax_handling CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
76 tax_exempt_num CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
77 tax_exempt_reason_code CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
78 contract_amount NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
79 discount_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
80 last_update_date CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
81 last_updated_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
82 creation_date CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
83 created_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
84 auto_renewal_flag CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
85 last_update_login NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
86 start_date_active CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
87 end_date_active CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
88 attribute1 CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
89 attribute2 CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
90 attribute3 CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
91 attribute4 CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
92 attribute5 CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
93 attribute6 CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
94 attribute7 CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
95 attribute8 CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
96 attribute9 CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
97 attribute10 CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
98 attribute11 CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
99 attribute12 CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
100 attribute13 CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
101 attribute14 CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
102 attribute15 CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
103 context CS_CONTRACT_TEMPLATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
104 object_version_number NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
105 G_MISS_contracttmpl_val_rec ContractTmpl_Val_Rec_Type;
106 ---------------------------------------------------------------------------
107 -- GLOBAL MESSAGE CONSTANTS
108 ---------------------------------------------------------------------------
109 G_FND_APP CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FND_APP;
110 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_UNABLE_TO_RESERVE_REC;
111 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
112 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
113 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
114 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
115 G_INVALID_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
116 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
117 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_PARENT_TABLE_TOKEN;
118 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_CHILD_TABLE_TOKEN;
119 ---------------------------------------------------------------------------
120 -- GLOBAL VARIABLES
121 ---------------------------------------------------------------------------
122 G_PKG_NAME CONSTANT VARCHAR2(200) := 'CS_CONTRACTTMPL_PVT';
123 G_APP_NAME CONSTANT VARCHAR2(3) := TAPI_DEV_KIT.G_APP_NAME;
124 ---------------------------------------------------------------------------
125 -- Procedures and Functions
126 ---------------------------------------------------------------------------
127
128 PROCEDURE insert_row
129 (
130 p_api_version IN NUMBER,
131 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
132 p_validation_level IN NUMBER,
133 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
134 x_return_status OUT VARCHAR2,
135 x_msg_count OUT NUMBER,
136 x_msg_data OUT VARCHAR2,
137 p_contracttmpl_rec IN ContractTmpl_Rec_Type := G_MISS_CONTRACTTMPL_REC,
138 x_contract_template_id OUT NUMBER,
139 x_object_version_number OUT NUMBER);
140 PROCEDURE insert_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_name IN CS_CONTRACT_TEMPLATES.NAME%TYPE := NULL,
150 p_contract_type_id IN NUMBER := NULL,
151 p_duration IN NUMBER := NULL,
152 p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := NULL,
153 p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := NULL,
154 p_price_list_id IN NUMBER := NULL,
155 p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := NULL,
156 p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := NULL,
157 p_conversion_rate IN NUMBER := NULL,
158 p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := NULL,
159 p_invoicing_rule_id IN NUMBER := NULL,
160 p_accounting_rule_id IN NUMBER := NULL,
161 p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
162 p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := NULL,
163 p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := NULL,
164 p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := NULL,
165 p_terms_id IN NUMBER := NULL,
166 p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := NULL,
167 p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := NULL,
168 p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := NULL,
169 p_contract_amount IN NUMBER := NULL,
170 p_discount_id IN NUMBER := NULL,
171 p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := NULL,
172 p_last_updated_by IN NUMBER := NULL,
173 p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := NULL,
174 p_created_by IN NUMBER := NULL,
175 p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := NULL,
176 p_last_update_login IN NUMBER := NULL,
177 p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := NULL,
178 p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := NULL,
179 p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := NULL,
180 p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := NULL,
181 p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := NULL,
182 p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := NULL,
183 p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := NULL,
184 p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := NULL,
185 p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := NULL,
186 p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := NULL,
187 p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := NULL,
188 p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := NULL,
189 p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := NULL,
190 p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := NULL,
191 p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := NULL,
192 p_attribute14 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := NULL,
193 p_attribute15 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := NULL,
194 p_context IN CS_CONTRACT_TEMPLATES.CONTEXT%TYPE := NULL,
195 p_object_version_number IN NUMBER := NULL,
196 x_contract_template_id OUT NUMBER,
197 x_object_version_number OUT NUMBER);
198 Procedure lock_row
199 (
200 p_api_version IN NUMBER,
204 x_return_status OUT VARCHAR2,
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,
205 x_msg_count OUT NUMBER,
206 x_msg_data OUT VARCHAR2,
207 p_contract_template_id IN NUMBER,
208 p_object_version_number IN NUMBER);
209 Procedure update_row
210 (
211 p_api_version IN NUMBER,
212 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
213 p_validation_level IN NUMBER,
214 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
215 x_return_status OUT VARCHAR2,
216 x_msg_count OUT NUMBER,
217 x_msg_data OUT VARCHAR2,
218 p_contracttmpl_val_rec IN ContractTmpl_Val_Rec_Type := G_MISS_CONTRACTTMPL_VAL_REC,
219 x_object_version_number OUT NUMBER);
220 Procedure update_row
221 (
222 p_api_version IN NUMBER,
223 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
224 p_validation_level IN NUMBER,
225 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
226 x_return_status OUT VARCHAR2,
227 x_msg_count OUT NUMBER,
228 x_msg_data OUT VARCHAR2,
229 p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
230 p_name IN CS_CONTRACT_TEMPLATES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
231 p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
232 p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
233 p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
234 p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
235 p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
236 p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
237 p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
238 p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
239 p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
240 p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
241 p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
242 p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
243 p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
244 p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
245 p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
246 p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
247 p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
248 p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
249 p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
250 p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
251 p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
252 p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
253 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
254 p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
255 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
256 p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
257 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
258 p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
259 p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
260 p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
261 p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
262 p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
263 p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
264 p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
265 p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
266 p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
267 p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
268 p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
269 p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
270 p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
271 p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
272 p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
273 p_attribute14 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
274 p_attribute15 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
275 p_context IN CS_CONTRACT_TEMPLATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
276 p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
277 x_object_version_number OUT NUMBER);
281 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
278 Procedure delete_row
279 (
280 p_api_version IN NUMBER,
282 p_validation_level IN NUMBER,
283 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
284 x_return_status OUT VARCHAR2,
285 x_msg_count OUT NUMBER,
286 x_msg_data OUT VARCHAR2,
287 p_contract_template_id IN NUMBER);
288 PROCEDURE validate_row
289 (
290 p_api_version IN NUMBER,
291 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
292 p_validation_level IN NUMBER,
293 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
294 x_return_status OUT VARCHAR2,
295 x_msg_count OUT NUMBER,
296 x_msg_data OUT VARCHAR2,
297 p_contracttmpl_val_rec IN ContractTmpl_Val_Rec_Type := G_MISS_CONTRACTTMPL_VAL_REC);
298 PROCEDURE validate_row
299 (
300 p_api_version IN NUMBER,
301 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
302 p_validation_level IN NUMBER,
303 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
304 x_return_status OUT VARCHAR2,
305 x_msg_count OUT NUMBER,
306 x_msg_data OUT VARCHAR2,
307 p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
308 p_name IN CS_CONTRACT_TEMPLATES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
309 p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
310 p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
311 p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
312 p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
313 p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
314 p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
315 p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
316 p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
317 p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
318 p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
319 p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
320 p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
321 p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
322 p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
323 p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
324 p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
325 p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
326 p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
327 p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
328 p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
329 p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
330 p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
331 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
332 p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
333 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
334 p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
335 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
336 p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
337 p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
338 p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
339 p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
340 p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
341 p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
342 p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
343 p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
344 p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
345 p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
346 p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
347 p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
348 p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
349 p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
350 p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
351 p_attribute14 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
352 p_attribute15 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
353 p_context IN CS_CONTRACT_TEMPLATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
354 p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
355 END CS_CONTRACTTMPL_PVT;