[Home] [Help]
PACKAGE: APPS.CS_SERVICE_PVT
Source
1 Package CS_SERVICE_PVT AUTHID CURRENT_USER AS
2 /* $Header: csctsers.pls 115.1 99/07/16 08:54:25 porting ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE Service_Rec_Type IS RECORD (
7 cp_service_id NUMBER := NULL,
8 customer_product_id NUMBER := NULL,
9 contract_line_status_id NUMBER := NULL,
10 contract_line_template_id NUMBER := NULL,
11 contract_id NUMBER := NULL,
12 service_inventory_item_id NUMBER := NULL,
13 service_manufacturing_org_id NUMBER := NULL,
14 status_code CS_CP_SERVICES.STATUS_CODE%TYPE := NULL,
15 last_cp_service_transaction_id NUMBER := NULL,
16 invoice_flag CS_CP_SERVICES.INVOICE_FLAG%TYPE := NULL,
17 coverage_schedule_id NUMBER := NULL,
18 prorate_flag CS_CP_SERVICES.PRORATE_FLAG%TYPE := NULL,
19 duration_quantity NUMBER := NULL,
20 unit_of_measure_code CS_CP_SERVICES.UNIT_OF_MEASURE_CODE%TYPE := NULL,
21 starting_delay NUMBER := NULL,
22 bill_to_site_use_id NUMBER := NULL,
23 bill_to_contact_id NUMBER := NULL,
24 service_txn_availability_code CS_CP_SERVICES.SERVICE_TXN_AVAILABILITY_CODE%TYPE := NULL,
25 next_pm_visit_date CS_CP_SERVICES.NEXT_PM_VISIT_DATE%TYPE := NULL,
26 pm_visits_completed NUMBER := NULL,
27 last_pm_visit_date CS_CP_SERVICES.LAST_PM_VISIT_DATE%TYPE := NULL,
28 pm_schedule_id NUMBER := NULL,
29 pm_schedule_flag CS_CP_SERVICES.PM_SCHEDULE_FLAG%TYPE := NULL,
30 current_max_schedule_date CS_CP_SERVICES.CURRENT_MAX_SCHEDULE_DATE%TYPE := NULL,
31 price_list_id NUMBER := NULL,
32 service_order_type CS_CP_SERVICES.SERVICE_ORDER_TYPE%TYPE := NULL,
33 invoice_count NUMBER := NULL,
34 currency_code CS_CP_SERVICES.CURRENCY_CODE%TYPE := NULL,
35 conversion_type CS_CP_SERVICES.CONVERSION_TYPE%TYPE := NULL,
36 conversion_rate NUMBER := NULL,
37 conversion_date CS_CP_SERVICES.CONVERSION_DATE%TYPE := NULL,
38 original_service_line_id NUMBER := NULL,
39 warranty_flag CS_CP_SERVICES.WARRANTY_FLAG%TYPE := NULL,
40 original_start_date CS_CP_SERVICES.ORIGINAL_START_DATE%TYPE := NULL,
41 original_end_date CS_CP_SERVICES.ORIGINAL_END_DATE%TYPE := NULL,
42 service_date_change CS_CP_SERVICES.SERVICE_DATE_CHANGE%TYPE := NULL,
43 workflow CS_CP_SERVICES.WORKFLOW%TYPE := NULL,
44 ship_to_site_use_id NUMBER := NULL,
45 original_system_line_reference CS_CP_SERVICES.ORIGINAL_SYSTEM_LINE_REFERENCE%TYPE := NULL,
46 extended_price NUMBER := NULL,
47 discount_id NUMBER := NULL,
48 tax_code CS_CP_SERVICES.TAX_CODE%TYPE := NULL,
49 billing_frequency_period CS_CP_SERVICES.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
50 first_bill_date CS_CP_SERVICES.FIRST_BILL_DATE%TYPE := NULL,
51 next_bill_date CS_CP_SERVICES.NEXT_BILL_DATE%TYPE := NULL,
52 creation_date CS_CP_SERVICES.CREATION_DATE%TYPE := NULL,
53 bill_on NUMBER := NULL,
54 created_by NUMBER := NULL,
55 last_update_date CS_CP_SERVICES.LAST_UPDATE_DATE%TYPE := NULL,
56 last_updated_by NUMBER := NULL,
57 last_update_login NUMBER := NULL,
58 start_date_active CS_CP_SERVICES.START_DATE_ACTIVE%TYPE := NULL,
59 end_date_active CS_CP_SERVICES.END_DATE_ACTIVE%TYPE := NULL,
60 pricing_attribute1 CS_CP_SERVICES.PRICING_ATTRIBUTE1%TYPE := NULL,
61 pricing_attribute2 CS_CP_SERVICES.PRICING_ATTRIBUTE2%TYPE := NULL,
62 pricing_attribute3 CS_CP_SERVICES.PRICING_ATTRIBUTE3%TYPE := NULL,
63 pricing_attribute4 CS_CP_SERVICES.PRICING_ATTRIBUTE4%TYPE := NULL,
64 pricing_attribute5 CS_CP_SERVICES.PRICING_ATTRIBUTE5%TYPE := NULL,
65 pricing_attribute6 CS_CP_SERVICES.PRICING_ATTRIBUTE6%TYPE := NULL,
66 pricing_attribute7 CS_CP_SERVICES.PRICING_ATTRIBUTE7%TYPE := NULL,
67 pricing_attribute8 CS_CP_SERVICES.PRICING_ATTRIBUTE8%TYPE := NULL,
68 pricing_attribute9 CS_CP_SERVICES.PRICING_ATTRIBUTE9%TYPE := NULL,
69 pricing_attribute10 CS_CP_SERVICES.PRICING_ATTRIBUTE10%TYPE := NULL,
70 pricing_attribute11 CS_CP_SERVICES.PRICING_ATTRIBUTE11%TYPE := NULL,
71 pricing_attribute12 CS_CP_SERVICES.PRICING_ATTRIBUTE12%TYPE := NULL,
72 pricing_attribute13 CS_CP_SERVICES.PRICING_ATTRIBUTE13%TYPE := NULL,
73 pricing_attribute14 CS_CP_SERVICES.PRICING_ATTRIBUTE14%TYPE := NULL,
74 pricing_attribute15 CS_CP_SERVICES.PRICING_ATTRIBUTE15%TYPE := NULL,
75 pricing_context CS_CP_SERVICES.PRICING_CONTEXT%TYPE := NULL,
76 attribute1 CS_CP_SERVICES.ATTRIBUTE1%TYPE := NULL,
77 attribute2 CS_CP_SERVICES.ATTRIBUTE2%TYPE := NULL,
78 attribute3 CS_CP_SERVICES.ATTRIBUTE3%TYPE := NULL,
79 attribute4 CS_CP_SERVICES.ATTRIBUTE4%TYPE := NULL,
83 attribute8 CS_CP_SERVICES.ATTRIBUTE8%TYPE := NULL,
80 attribute5 CS_CP_SERVICES.ATTRIBUTE5%TYPE := NULL,
81 attribute6 CS_CP_SERVICES.ATTRIBUTE6%TYPE := NULL,
82 attribute7 CS_CP_SERVICES.ATTRIBUTE7%TYPE := NULL,
84 attribute9 CS_CP_SERVICES.ATTRIBUTE9%TYPE := NULL,
85 attribute10 CS_CP_SERVICES.ATTRIBUTE10%TYPE := NULL,
86 attribute11 CS_CP_SERVICES.ATTRIBUTE11%TYPE := NULL,
87 attribute12 CS_CP_SERVICES.ATTRIBUTE12%TYPE := NULL,
88 attribute13 CS_CP_SERVICES.ATTRIBUTE13%TYPE := NULL,
89 attribute14 CS_CP_SERVICES.ATTRIBUTE14%TYPE := NULL,
90 attribute15 CS_CP_SERVICES.ATTRIBUTE15%TYPE := NULL,
91 context CS_CP_SERVICES.CONTEXT%TYPE := NULL,
92 list_price NUMBER := NULL,
93 org_id NUMBER := NULL,
94 price_percent NUMBER := NULL);
95 G_MISS_service_rec Service_Rec_Type;
96 TYPE Service_Val_Rec_Type IS RECORD (
97 cp_service_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
98 customer_product_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
99 contract_line_status_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
100 contract_line_template_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
101 contract_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
102 service_inventory_item_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
103 service_manufacturing_org_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
104 status_code CS_CP_SERVICES.STATUS_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
105 last_cp_service_transaction_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
106 invoice_flag CS_CP_SERVICES.INVOICE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
107 coverage_schedule_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
108 prorate_flag CS_CP_SERVICES.PRORATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
109 duration_quantity NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
110 unit_of_measure_code CS_CP_SERVICES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
111 starting_delay NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
112 bill_to_site_use_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
113 bill_to_contact_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
114 service_txn_availability_code CS_CP_SERVICES.SERVICE_TXN_AVAILABILITY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
115 next_pm_visit_date CS_CP_SERVICES.NEXT_PM_VISIT_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
116 pm_visits_completed NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
117 last_pm_visit_date CS_CP_SERVICES.LAST_PM_VISIT_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
118 pm_schedule_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
119 pm_schedule_flag CS_CP_SERVICES.PM_SCHEDULE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
120 current_max_schedule_date CS_CP_SERVICES.CURRENT_MAX_SCHEDULE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
121 price_list_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
122 service_order_type CS_CP_SERVICES.SERVICE_ORDER_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
123 invoice_count NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
124 currency_code CS_CP_SERVICES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
125 conversion_type CS_CP_SERVICES.CONVERSION_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
126 conversion_rate NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
127 conversion_date CS_CP_SERVICES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
128 original_service_line_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
129 warranty_flag CS_CP_SERVICES.WARRANTY_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
130 original_start_date CS_CP_SERVICES.ORIGINAL_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
131 original_end_date CS_CP_SERVICES.ORIGINAL_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
132 service_date_change CS_CP_SERVICES.SERVICE_DATE_CHANGE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
133 workflow CS_CP_SERVICES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
134 ship_to_site_use_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
135 original_system_line_reference CS_CP_SERVICES.ORIGINAL_SYSTEM_LINE_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
136 extended_price NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
137 discount_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
138 tax_code CS_CP_SERVICES.TAX_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
139 billing_frequency_period CS_CP_SERVICES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
140 first_bill_date CS_CP_SERVICES.FIRST_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
141 next_bill_date CS_CP_SERVICES.NEXT_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
142 creation_date CS_CP_SERVICES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
143 bill_on NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
144 created_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
145 last_update_date CS_CP_SERVICES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
146 last_updated_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
147 last_update_login NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
148 start_date_active CS_CP_SERVICES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
149 end_date_active CS_CP_SERVICES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
150 pricing_attribute1 CS_CP_SERVICES.PRICING_ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
151 pricing_attribute2 CS_CP_SERVICES.PRICING_ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
152 pricing_attribute3 CS_CP_SERVICES.PRICING_ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
153 pricing_attribute4 CS_CP_SERVICES.PRICING_ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
157 pricing_attribute8 CS_CP_SERVICES.PRICING_ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
154 pricing_attribute5 CS_CP_SERVICES.PRICING_ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
155 pricing_attribute6 CS_CP_SERVICES.PRICING_ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
156 pricing_attribute7 CS_CP_SERVICES.PRICING_ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
158 pricing_attribute9 CS_CP_SERVICES.PRICING_ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
159 pricing_attribute10 CS_CP_SERVICES.PRICING_ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
160 pricing_attribute11 CS_CP_SERVICES.PRICING_ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
161 pricing_attribute12 CS_CP_SERVICES.PRICING_ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
162 pricing_attribute13 CS_CP_SERVICES.PRICING_ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
163 pricing_attribute14 CS_CP_SERVICES.PRICING_ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
164 pricing_attribute15 CS_CP_SERVICES.PRICING_ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
165 pricing_context CS_CP_SERVICES.PRICING_CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
166 attribute1 CS_CP_SERVICES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
167 attribute2 CS_CP_SERVICES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
168 attribute3 CS_CP_SERVICES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
169 attribute4 CS_CP_SERVICES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
170 attribute5 CS_CP_SERVICES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
171 attribute6 CS_CP_SERVICES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
172 attribute7 CS_CP_SERVICES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
173 attribute8 CS_CP_SERVICES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
174 attribute9 CS_CP_SERVICES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
175 attribute10 CS_CP_SERVICES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
176 attribute11 CS_CP_SERVICES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
177 attribute12 CS_CP_SERVICES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
178 attribute13 CS_CP_SERVICES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
179 attribute14 CS_CP_SERVICES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
180 attribute15 CS_CP_SERVICES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
181 context CS_CP_SERVICES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
182 list_price NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
183 org_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
184 price_percent NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
185 G_MISS_service_val_rec Service_Val_Rec_Type;
186 ---------------------------------------------------------------------------
187 -- GLOBAL MESSAGE CONSTANTS
188 ---------------------------------------------------------------------------
189 G_FND_APP CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FND_APP;
190 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_UNABLE_TO_RESERVE_REC;
191 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
192 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
193 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
194 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
195 G_INVALID_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
196 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
197 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_PARENT_TABLE_TOKEN;
198 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_CHILD_TABLE_TOKEN;
199 ---------------------------------------------------------------------------
200 -- GLOBAL VARIABLES
201 ---------------------------------------------------------------------------
202 G_PKG_NAME CONSTANT VARCHAR2(200) := 'CS_SERVICE_PVT';
203 G_APP_NAME CONSTANT VARCHAR2(3) := TAPI_DEV_KIT.G_APP_NAME;
204 ---------------------------------------------------------------------------
205 -- Procedures and Functions
206 ---------------------------------------------------------------------------
207
208 PROCEDURE insert_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_service_rec IN Service_Rec_Type := G_MISS_SERVICE_REC,
218 x_cp_service_id OUT NUMBER);
219 PROCEDURE insert_row
220 (
221 p_api_version IN NUMBER,
222 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
223 p_validation_level IN NUMBER,
224 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
225 x_return_status OUT VARCHAR2,
226 x_msg_count OUT NUMBER,
227 x_msg_data OUT VARCHAR2,
228 p_customer_product_id IN NUMBER := NULL,
229 p_contract_line_status_id IN NUMBER := NULL,
230 p_contract_line_template_id IN NUMBER := NULL,
231 p_contract_id IN NUMBER := NULL,
232 p_service_inventory_item_id IN NUMBER := NULL,
233 p_service_manufacturing_org_id IN NUMBER := NULL,
234 p_status_code IN CS_CP_SERVICES.STATUS_CODE%TYPE := NULL,
235 p_lst_cp_srvic_trnsctin_id IN NUMBER := NULL,
236 p_invoice_flag IN CS_CP_SERVICES.INVOICE_FLAG%TYPE := NULL,
240 p_unit_of_measure_code IN CS_CP_SERVICES.UNIT_OF_MEASURE_CODE%TYPE := NULL,
237 p_coverage_schedule_id IN NUMBER := NULL,
238 p_prorate_flag IN CS_CP_SERVICES.PRORATE_FLAG%TYPE := NULL,
239 p_duration_quantity IN NUMBER := NULL,
241 p_starting_delay IN NUMBER := NULL,
242 p_bill_to_site_use_id IN NUMBER := NULL,
243 p_bill_to_contact_id IN NUMBER := NULL,
244 p_srvic_txn_vilbility_cd IN CS_CP_SERVICES.SERVICE_TXN_AVAILABILITY_CODE%TYPE := NULL,
245 p_next_pm_visit_date IN CS_CP_SERVICES.NEXT_PM_VISIT_DATE%TYPE := NULL,
246 p_pm_visits_completed IN NUMBER := NULL,
247 p_last_pm_visit_date IN CS_CP_SERVICES.LAST_PM_VISIT_DATE%TYPE := NULL,
248 p_pm_schedule_id IN NUMBER := NULL,
249 p_pm_schedule_flag IN CS_CP_SERVICES.PM_SCHEDULE_FLAG%TYPE := NULL,
250 p_current_max_schedule_date IN CS_CP_SERVICES.CURRENT_MAX_SCHEDULE_DATE%TYPE := NULL,
251 p_price_list_id IN NUMBER := NULL,
252 p_service_order_type IN CS_CP_SERVICES.SERVICE_ORDER_TYPE%TYPE := NULL,
253 p_invoice_count IN NUMBER := NULL,
254 p_currency_code IN CS_CP_SERVICES.CURRENCY_CODE%TYPE := NULL,
255 p_conversion_type IN CS_CP_SERVICES.CONVERSION_TYPE%TYPE := NULL,
256 p_conversion_rate IN NUMBER := NULL,
257 p_conversion_date IN CS_CP_SERVICES.CONVERSION_DATE%TYPE := NULL,
258 p_original_service_line_id IN NUMBER := NULL,
259 p_warranty_flag IN CS_CP_SERVICES.WARRANTY_FLAG%TYPE := NULL,
260 p_original_start_date IN CS_CP_SERVICES.ORIGINAL_START_DATE%TYPE := NULL,
261 p_original_end_date IN CS_CP_SERVICES.ORIGINAL_END_DATE%TYPE := NULL,
262 p_service_date_change IN CS_CP_SERVICES.SERVICE_DATE_CHANGE%TYPE := NULL,
263 p_workflow IN CS_CP_SERVICES.WORKFLOW%TYPE := NULL,
264 p_ship_to_site_use_id IN NUMBER := NULL,
265 p_riginl_systm_lin_rfrnc IN CS_CP_SERVICES.ORIGINAL_SYSTEM_LINE_REFERENCE%TYPE := NULL,
266 p_extended_price IN NUMBER := NULL,
267 p_discount_id IN NUMBER := NULL,
268 p_tax_code IN CS_CP_SERVICES.TAX_CODE%TYPE := NULL,
269 p_billing_frequency_period IN CS_CP_SERVICES.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
270 p_first_bill_date IN CS_CP_SERVICES.FIRST_BILL_DATE%TYPE := NULL,
271 p_next_bill_date IN CS_CP_SERVICES.NEXT_BILL_DATE%TYPE := NULL,
272 p_creation_date IN CS_CP_SERVICES.CREATION_DATE%TYPE := NULL,
273 p_bill_on IN NUMBER := NULL,
274 p_created_by IN NUMBER := NULL,
275 p_last_update_date IN CS_CP_SERVICES.LAST_UPDATE_DATE%TYPE := NULL,
276 p_last_updated_by IN NUMBER := NULL,
277 p_last_update_login IN NUMBER := NULL,
278 p_start_date_active IN CS_CP_SERVICES.START_DATE_ACTIVE%TYPE := NULL,
279 p_end_date_active IN CS_CP_SERVICES.END_DATE_ACTIVE%TYPE := NULL,
280 p_pricing_attribute1 IN CS_CP_SERVICES.PRICING_ATTRIBUTE1%TYPE := NULL,
281 p_pricing_attribute2 IN CS_CP_SERVICES.PRICING_ATTRIBUTE2%TYPE := NULL,
282 p_pricing_attribute3 IN CS_CP_SERVICES.PRICING_ATTRIBUTE3%TYPE := NULL,
283 p_pricing_attribute4 IN CS_CP_SERVICES.PRICING_ATTRIBUTE4%TYPE := NULL,
284 p_pricing_attribute5 IN CS_CP_SERVICES.PRICING_ATTRIBUTE5%TYPE := NULL,
285 p_pricing_attribute6 IN CS_CP_SERVICES.PRICING_ATTRIBUTE6%TYPE := NULL,
286 p_pricing_attribute7 IN CS_CP_SERVICES.PRICING_ATTRIBUTE7%TYPE := NULL,
287 p_pricing_attribute8 IN CS_CP_SERVICES.PRICING_ATTRIBUTE8%TYPE := NULL,
288 p_pricing_attribute9 IN CS_CP_SERVICES.PRICING_ATTRIBUTE9%TYPE := NULL,
289 p_pricing_attribute10 IN CS_CP_SERVICES.PRICING_ATTRIBUTE10%TYPE := NULL,
290 p_pricing_attribute11 IN CS_CP_SERVICES.PRICING_ATTRIBUTE11%TYPE := NULL,
291 p_pricing_attribute12 IN CS_CP_SERVICES.PRICING_ATTRIBUTE12%TYPE := NULL,
292 p_pricing_attribute13 IN CS_CP_SERVICES.PRICING_ATTRIBUTE13%TYPE := NULL,
293 p_pricing_attribute14 IN CS_CP_SERVICES.PRICING_ATTRIBUTE14%TYPE := NULL,
294 p_pricing_attribute15 IN CS_CP_SERVICES.PRICING_ATTRIBUTE15%TYPE := NULL,
295 p_pricing_context IN CS_CP_SERVICES.PRICING_CONTEXT%TYPE := NULL,
296 p_attribute1 IN CS_CP_SERVICES.ATTRIBUTE1%TYPE := NULL,
297 p_attribute2 IN CS_CP_SERVICES.ATTRIBUTE2%TYPE := NULL,
298 p_attribute3 IN CS_CP_SERVICES.ATTRIBUTE3%TYPE := NULL,
299 p_attribute4 IN CS_CP_SERVICES.ATTRIBUTE4%TYPE := NULL,
300 p_attribute5 IN CS_CP_SERVICES.ATTRIBUTE5%TYPE := NULL,
301 p_attribute6 IN CS_CP_SERVICES.ATTRIBUTE6%TYPE := NULL,
302 p_attribute7 IN CS_CP_SERVICES.ATTRIBUTE7%TYPE := NULL,
303 p_attribute8 IN CS_CP_SERVICES.ATTRIBUTE8%TYPE := NULL,
304 p_attribute9 IN CS_CP_SERVICES.ATTRIBUTE9%TYPE := NULL,
305 p_attribute10 IN CS_CP_SERVICES.ATTRIBUTE10%TYPE := NULL,
306 p_attribute11 IN CS_CP_SERVICES.ATTRIBUTE11%TYPE := NULL,
307 p_attribute12 IN CS_CP_SERVICES.ATTRIBUTE12%TYPE := NULL,
308 p_attribute13 IN CS_CP_SERVICES.ATTRIBUTE13%TYPE := NULL,
309 p_attribute14 IN CS_CP_SERVICES.ATTRIBUTE14%TYPE := NULL,
310 p_attribute15 IN CS_CP_SERVICES.ATTRIBUTE15%TYPE := NULL,
311 p_context IN CS_CP_SERVICES.CONTEXT%TYPE := NULL,
312 p_list_price IN NUMBER := NULL,
313 p_org_id IN NUMBER := NULL,
314 p_price_percent IN NUMBER := NULL,
315 x_cp_service_id OUT NUMBER);
316 Procedure lock_row
317 (
318 p_api_version IN NUMBER,
322 x_return_status OUT VARCHAR2,
319 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
320 p_validation_level IN NUMBER,
321 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
323 x_msg_count OUT NUMBER,
324 x_msg_data OUT VARCHAR2,
325 p_cp_service_id IN NUMBER,
326 p_customer_product_id IN NUMBER,
327 p_contract_line_status_id IN NUMBER,
328 p_contract_line_template_id IN NUMBER,
329 p_contract_id IN NUMBER,
330 p_service_inventory_item_id IN NUMBER,
331 p_service_manufacturing_org_id IN NUMBER,
332 p_status_code IN VARCHAR2,
333 p_lst_cp_srvic_trnsctin_id IN NUMBER,
334 p_invoice_flag IN VARCHAR2,
335 p_coverage_schedule_id IN NUMBER,
336 p_prorate_flag IN VARCHAR2,
337 p_duration_quantity IN NUMBER,
338 p_unit_of_measure_code IN VARCHAR2,
339 p_starting_delay IN NUMBER,
340 p_bill_to_site_use_id IN NUMBER,
341 p_bill_to_contact_id IN NUMBER,
342 p_srvic_txn_vilbility_cd IN VARCHAR2,
343 p_next_pm_visit_date IN DATE,
344 p_pm_visits_completed IN NUMBER,
345 p_last_pm_visit_date IN DATE,
346 p_pm_schedule_id IN NUMBER,
347 p_pm_schedule_flag IN VARCHAR2,
348 p_current_max_schedule_date IN DATE,
349 p_price_list_id IN NUMBER,
350 p_service_order_type IN VARCHAR2,
351 p_invoice_count IN NUMBER,
352 p_currency_code IN VARCHAR2,
353 p_conversion_type IN VARCHAR2,
354 p_conversion_rate IN NUMBER,
355 p_conversion_date IN DATE,
356 p_original_service_line_id IN NUMBER,
357 p_warranty_flag IN VARCHAR2,
358 p_original_start_date IN DATE,
359 p_original_end_date IN DATE,
360 p_service_date_change IN VARCHAR2,
361 p_workflow IN VARCHAR2,
362 p_ship_to_site_use_id IN NUMBER,
363 p_riginl_systm_lin_rfrnc IN VARCHAR2,
364 p_extended_price IN NUMBER,
365 p_discount_id IN NUMBER,
366 p_tax_code IN VARCHAR2,
367 p_billing_frequency_period IN VARCHAR2,
368 p_first_bill_date IN DATE,
369 p_next_bill_date IN DATE,
370 p_creation_date IN DATE,
371 p_bill_on IN NUMBER,
372 p_created_by IN NUMBER,
373 p_last_update_date IN DATE,
374 p_last_updated_by IN NUMBER,
375 p_last_update_login IN NUMBER,
376 p_start_date_active IN DATE,
377 p_end_date_active IN DATE,
378 p_pricing_attribute1 IN VARCHAR2,
379 p_pricing_attribute2 IN VARCHAR2,
380 p_pricing_attribute3 IN VARCHAR2,
381 p_pricing_attribute4 IN VARCHAR2,
382 p_pricing_attribute5 IN VARCHAR2,
383 p_pricing_attribute6 IN VARCHAR2,
384 p_pricing_attribute7 IN VARCHAR2,
385 p_pricing_attribute8 IN VARCHAR2,
386 p_pricing_attribute9 IN VARCHAR2,
387 p_pricing_attribute10 IN VARCHAR2,
388 p_pricing_attribute11 IN VARCHAR2,
389 p_pricing_attribute12 IN VARCHAR2,
390 p_pricing_attribute13 IN VARCHAR2,
391 p_pricing_attribute14 IN VARCHAR2,
392 p_pricing_attribute15 IN VARCHAR2,
393 p_pricing_context IN VARCHAR2,
394 p_attribute1 IN VARCHAR2,
395 p_attribute2 IN VARCHAR2,
396 p_attribute3 IN VARCHAR2,
397 p_attribute4 IN VARCHAR2,
398 p_attribute5 IN VARCHAR2,
399 p_attribute6 IN VARCHAR2,
400 p_attribute7 IN VARCHAR2,
401 p_attribute8 IN VARCHAR2,
402 p_attribute9 IN VARCHAR2,
403 p_attribute10 IN VARCHAR2,
404 p_attribute11 IN VARCHAR2,
405 p_attribute12 IN VARCHAR2,
406 p_attribute13 IN VARCHAR2,
407 p_attribute14 IN VARCHAR2,
408 p_attribute15 IN VARCHAR2,
409 p_context IN VARCHAR2,
410 p_list_price IN NUMBER,
411 p_org_id IN NUMBER,
412 p_price_percent IN NUMBER);
413 Procedure update_row
414 (
415 p_api_version IN NUMBER,
416 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
417 p_validation_level IN NUMBER,
418 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
419 x_return_status OUT VARCHAR2,
420 x_msg_count OUT NUMBER,
421 x_msg_data OUT VARCHAR2,
422 p_service_val_rec IN Service_Val_Rec_Type := G_MISS_SERVICE_VAL_REC);
423 Procedure update_row
424 (
425 p_api_version IN NUMBER,
426 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
427 p_validation_level IN NUMBER,
428 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
429 x_return_status OUT VARCHAR2,
430 x_msg_count OUT NUMBER,
431 x_msg_data OUT VARCHAR2,
432 p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
433 p_customer_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
437 p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
434 p_contract_line_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
435 p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
436 p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
438 p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
439 p_status_code IN CS_CP_SERVICES.STATUS_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
440 p_lst_cp_srvic_trnsctin_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
441 p_invoice_flag IN CS_CP_SERVICES.INVOICE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
442 p_coverage_schedule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
443 p_prorate_flag IN CS_CP_SERVICES.PRORATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
444 p_duration_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
445 p_unit_of_measure_code IN CS_CP_SERVICES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
446 p_starting_delay IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
447 p_bill_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
448 p_bill_to_contact_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
449 p_srvic_txn_vilbility_cd IN CS_CP_SERVICES.SERVICE_TXN_AVAILABILITY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
450 p_next_pm_visit_date IN CS_CP_SERVICES.NEXT_PM_VISIT_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
451 p_pm_visits_completed IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
452 p_last_pm_visit_date IN CS_CP_SERVICES.LAST_PM_VISIT_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
453 p_pm_schedule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
454 p_pm_schedule_flag IN CS_CP_SERVICES.PM_SCHEDULE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
455 p_current_max_schedule_date IN CS_CP_SERVICES.CURRENT_MAX_SCHEDULE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
456 p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
457 p_service_order_type IN CS_CP_SERVICES.SERVICE_ORDER_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
458 p_invoice_count IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
459 p_currency_code IN CS_CP_SERVICES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
460 p_conversion_type IN CS_CP_SERVICES.CONVERSION_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
461 p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
462 p_conversion_date IN CS_CP_SERVICES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
463 p_original_service_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
464 p_warranty_flag IN CS_CP_SERVICES.WARRANTY_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
465 p_original_start_date IN CS_CP_SERVICES.ORIGINAL_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
466 p_original_end_date IN CS_CP_SERVICES.ORIGINAL_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
467 p_service_date_change IN CS_CP_SERVICES.SERVICE_DATE_CHANGE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
468 p_workflow IN CS_CP_SERVICES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
469 p_ship_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
470 p_riginl_systm_lin_rfrnc IN CS_CP_SERVICES.ORIGINAL_SYSTEM_LINE_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
471 p_extended_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
472 p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
473 p_tax_code IN CS_CP_SERVICES.TAX_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
474 p_billing_frequency_period IN CS_CP_SERVICES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
475 p_first_bill_date IN CS_CP_SERVICES.FIRST_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
476 p_next_bill_date IN CS_CP_SERVICES.NEXT_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
477 p_creation_date IN CS_CP_SERVICES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
478 p_bill_on IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
479 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
480 p_last_update_date IN CS_CP_SERVICES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
481 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
482 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
483 p_start_date_active IN CS_CP_SERVICES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
484 p_end_date_active IN CS_CP_SERVICES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
485 p_pricing_attribute1 IN CS_CP_SERVICES.PRICING_ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
486 p_pricing_attribute2 IN CS_CP_SERVICES.PRICING_ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
487 p_pricing_attribute3 IN CS_CP_SERVICES.PRICING_ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
488 p_pricing_attribute4 IN CS_CP_SERVICES.PRICING_ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
489 p_pricing_attribute5 IN CS_CP_SERVICES.PRICING_ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
490 p_pricing_attribute6 IN CS_CP_SERVICES.PRICING_ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
491 p_pricing_attribute7 IN CS_CP_SERVICES.PRICING_ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
492 p_pricing_attribute8 IN CS_CP_SERVICES.PRICING_ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
493 p_pricing_attribute9 IN CS_CP_SERVICES.PRICING_ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
494 p_pricing_attribute10 IN CS_CP_SERVICES.PRICING_ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
495 p_pricing_attribute11 IN CS_CP_SERVICES.PRICING_ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
496 p_pricing_attribute12 IN CS_CP_SERVICES.PRICING_ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
497 p_pricing_attribute13 IN CS_CP_SERVICES.PRICING_ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
498 p_pricing_attribute14 IN CS_CP_SERVICES.PRICING_ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
499 p_pricing_attribute15 IN CS_CP_SERVICES.PRICING_ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
500 p_pricing_context IN CS_CP_SERVICES.PRICING_CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
504 p_attribute4 IN CS_CP_SERVICES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
501 p_attribute1 IN CS_CP_SERVICES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
502 p_attribute2 IN CS_CP_SERVICES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
503 p_attribute3 IN CS_CP_SERVICES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
505 p_attribute5 IN CS_CP_SERVICES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
506 p_attribute6 IN CS_CP_SERVICES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
507 p_attribute7 IN CS_CP_SERVICES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
508 p_attribute8 IN CS_CP_SERVICES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
509 p_attribute9 IN CS_CP_SERVICES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
510 p_attribute10 IN CS_CP_SERVICES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
511 p_attribute11 IN CS_CP_SERVICES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
512 p_attribute12 IN CS_CP_SERVICES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
513 p_attribute13 IN CS_CP_SERVICES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
514 p_attribute14 IN CS_CP_SERVICES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
515 p_attribute15 IN CS_CP_SERVICES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
516 p_context IN CS_CP_SERVICES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
517 p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
518 p_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
519 p_price_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
520 Procedure delete_row
521 (
522 p_api_version IN NUMBER,
523 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
524 p_validation_level IN NUMBER,
525 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
526 x_return_status OUT VARCHAR2,
527 x_msg_count OUT NUMBER,
528 x_msg_data OUT VARCHAR2,
529 p_cp_service_id IN NUMBER);
530 PROCEDURE validate_row
531 (
532 p_api_version IN NUMBER,
533 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
534 p_validation_level IN NUMBER,
535 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
536 x_return_status OUT VARCHAR2,
537 x_msg_count OUT NUMBER,
538 x_msg_data OUT VARCHAR2,
539 p_service_val_rec IN Service_Val_Rec_Type := G_MISS_SERVICE_VAL_REC);
540 PROCEDURE validate_row
541 (
542 p_api_version IN NUMBER,
543 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
544 p_validation_level IN NUMBER,
545 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
546 x_return_status OUT VARCHAR2,
547 x_msg_count OUT NUMBER,
548 x_msg_data OUT VARCHAR2,
549 p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
550 p_customer_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
551 p_contract_line_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
552 p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
553 p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
554 p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
555 p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
556 p_status_code IN CS_CP_SERVICES.STATUS_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
557 p_lst_cp_srvic_trnsctin_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
558 p_invoice_flag IN CS_CP_SERVICES.INVOICE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
559 p_coverage_schedule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
560 p_prorate_flag IN CS_CP_SERVICES.PRORATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
561 p_duration_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
562 p_unit_of_measure_code IN CS_CP_SERVICES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
563 p_starting_delay IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
564 p_bill_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
565 p_bill_to_contact_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
566 p_srvic_txn_vilbility_cd IN CS_CP_SERVICES.SERVICE_TXN_AVAILABILITY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
567 p_next_pm_visit_date IN CS_CP_SERVICES.NEXT_PM_VISIT_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
568 p_pm_visits_completed IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
569 p_last_pm_visit_date IN CS_CP_SERVICES.LAST_PM_VISIT_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
570 p_pm_schedule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
571 p_pm_schedule_flag IN CS_CP_SERVICES.PM_SCHEDULE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
572 p_current_max_schedule_date IN CS_CP_SERVICES.CURRENT_MAX_SCHEDULE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
573 p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
574 p_service_order_type IN CS_CP_SERVICES.SERVICE_ORDER_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
575 p_invoice_count IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
576 p_currency_code IN CS_CP_SERVICES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
577 p_conversion_type IN CS_CP_SERVICES.CONVERSION_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
578 p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
579 p_conversion_date IN CS_CP_SERVICES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
580 p_original_service_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
581 p_warranty_flag IN CS_CP_SERVICES.WARRANTY_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
582 p_original_start_date IN CS_CP_SERVICES.ORIGINAL_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
583 p_original_end_date IN CS_CP_SERVICES.ORIGINAL_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
584 p_service_date_change IN CS_CP_SERVICES.SERVICE_DATE_CHANGE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
585 p_workflow IN CS_CP_SERVICES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
586 p_ship_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
587 p_riginl_systm_lin_rfrnc IN CS_CP_SERVICES.ORIGINAL_SYSTEM_LINE_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
588 p_extended_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
589 p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
590 p_tax_code IN CS_CP_SERVICES.TAX_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
591 p_billing_frequency_period IN CS_CP_SERVICES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
592 p_first_bill_date IN CS_CP_SERVICES.FIRST_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
593 p_next_bill_date IN CS_CP_SERVICES.NEXT_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
594 p_creation_date IN CS_CP_SERVICES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
595 p_bill_on IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
596 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
597 p_last_update_date IN CS_CP_SERVICES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
598 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
599 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
600 p_start_date_active IN CS_CP_SERVICES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
601 p_end_date_active IN CS_CP_SERVICES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
602 p_pricing_attribute1 IN CS_CP_SERVICES.PRICING_ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
603 p_pricing_attribute2 IN CS_CP_SERVICES.PRICING_ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
604 p_pricing_attribute3 IN CS_CP_SERVICES.PRICING_ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
605 p_pricing_attribute4 IN CS_CP_SERVICES.PRICING_ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
606 p_pricing_attribute5 IN CS_CP_SERVICES.PRICING_ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
607 p_pricing_attribute6 IN CS_CP_SERVICES.PRICING_ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
608 p_pricing_attribute7 IN CS_CP_SERVICES.PRICING_ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
609 p_pricing_attribute8 IN CS_CP_SERVICES.PRICING_ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
610 p_pricing_attribute9 IN CS_CP_SERVICES.PRICING_ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
611 p_pricing_attribute10 IN CS_CP_SERVICES.PRICING_ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
612 p_pricing_attribute11 IN CS_CP_SERVICES.PRICING_ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
613 p_pricing_attribute12 IN CS_CP_SERVICES.PRICING_ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
614 p_pricing_attribute13 IN CS_CP_SERVICES.PRICING_ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
615 p_pricing_attribute14 IN CS_CP_SERVICES.PRICING_ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
616 p_pricing_attribute15 IN CS_CP_SERVICES.PRICING_ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
617 p_pricing_context IN CS_CP_SERVICES.PRICING_CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
618 p_attribute1 IN CS_CP_SERVICES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
619 p_attribute2 IN CS_CP_SERVICES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
620 p_attribute3 IN CS_CP_SERVICES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
621 p_attribute4 IN CS_CP_SERVICES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
622 p_attribute5 IN CS_CP_SERVICES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
623 p_attribute6 IN CS_CP_SERVICES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
624 p_attribute7 IN CS_CP_SERVICES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
625 p_attribute8 IN CS_CP_SERVICES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
626 p_attribute9 IN CS_CP_SERVICES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
627 p_attribute10 IN CS_CP_SERVICES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
628 p_attribute11 IN CS_CP_SERVICES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
629 p_attribute12 IN CS_CP_SERVICES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
630 p_attribute13 IN CS_CP_SERVICES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
631 p_attribute14 IN CS_CP_SERVICES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
632 p_attribute15 IN CS_CP_SERVICES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
633 p_context IN CS_CP_SERVICES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
634 p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
635 p_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
636 p_price_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
637 END CS_SERVICE_PVT;