1 Package CS_SERVICES_PVT AUTHID CURRENT_USER AS
2 /* $Header: csctpsrs.pls 115.1 99/07/16 08:53:25 porting ship $ */
3 ------------------------------------------------------------------------------
4 -- GLOBAL VARIABLES
5 ------------------------------------------------------------------------------
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'CS_CPSERVICE_PVT';
7 G_APP_NAME CONSTANT VARCHAR2(3) := 'CS';
8
9 Procedure Delete_Service
10 (
11 p_api_version IN NUMBER,
12 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
13 p_validation_level IN NUMBER,
14 p_commit IN VARCHAR2 := FND_API.G_FALSE,
15 x_return_status OUT VARCHAR2,
16 x_msg_count OUT NUMBER,
17 x_msg_data OUT VARCHAR2,
18 p_cp_service_id IN NUMBER
19 );
20
21 Procedure Get_Service_Status
22 (
23 p_api_version IN NUMBER,
24 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
25 p_validation_level IN NUMBER,
26 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
27 x_return_status OUT VARCHAR2,
28 x_msg_count OUT NUMBER,
29 x_msg_data OUT VARCHAR2,
30 p_contract_id IN CS_CONTRACTS.CONTRACT_ID%TYPE,
31 x_service_status OUT VARCHAR2
32 );
33
34 Procedure Insert_Service
35 (
36 p_api_version IN NUMBER,
37 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
38 p_validation_level IN NUMBER,
39 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
40 x_return_status OUT VARCHAR2,
41 x_msg_count OUT NUMBER,
42 x_msg_data OUT VARCHAR2,
43 p_customer_product_id IN NUMBER := NULL,
44 p_contract_line_status_id IN NUMBER := NULL,
45 p_contract_line_template_id IN NUMBER := NULL,
46 p_contract_id IN NUMBER := NULL,
47 p_service_inventory_item_id IN NUMBER := NULL,
48 p_service_manufacturing_org_id IN NUMBER := NULL,
49 p_status_code IN CS_CP_SERVICES.STATUS_CODE%TYPE := NULL,
50 p_lst_cp_srvic_trnsctin_id IN NUMBER := NULL,
51 p_invoice_flag IN CS_CP_SERVICES.INVOICE_FLAG%TYPE := NULL,
52 p_coverage_schedule_id IN NUMBER := NULL,
53 p_prorate_flag IN CS_CP_SERVICES.PRORATE_FLAG%TYPE := NULL,
54 p_duration_quantity IN NUMBER := NULL,
55 p_unit_of_measure_code IN CS_CP_SERVICES.UNIT_OF_MEASURE_CODE%TYPE := NULL,
56 p_starting_delay IN NUMBER := NULL,
57 p_bill_to_site_use_id IN NUMBER := NULL,
58 p_bill_to_contact_id IN NUMBER := NULL,
59 p_srvic_txn_vilbility_cd IN CS_CP_SERVICES.SERVICE_TXN_AVAILABILITY_CODE%TYPE := NULL,
60 p_next_pm_visit_date IN CS_CP_SERVICES.NEXT_PM_VISIT_DATE%TYPE := NULL,
61 p_pm_visits_completed IN NUMBER := NULL,
62 p_last_pm_visit_date IN CS_CP_SERVICES.LAST_PM_VISIT_DATE%TYPE := NULL,
63 p_pm_schedule_id IN NUMBER := NULL,
64 p_pm_schedule_flag IN CS_CP_SERVICES.PM_SCHEDULE_FLAG%TYPE := NULL,
65 p_current_max_schedule_date IN CS_CP_SERVICES.CURRENT_MAX_SCHEDULE_DATE%TYPE := NULL,
66 p_price_list_id IN NUMBER := NULL,
67 p_service_order_type IN CS_CP_SERVICES.SERVICE_ORDER_TYPE%TYPE := NULL,
68 p_invoice_count IN NUMBER := NULL,
69 p_currency_code IN CS_CP_SERVICES.CURRENCY_CODE%TYPE := NULL,
70 p_conversion_type IN CS_CP_SERVICES.CONVERSION_TYPE%TYPE := NULL,
71 p_conversion_rate IN NUMBER := NULL,
72 p_conversion_date IN CS_CP_SERVICES.CONVERSION_DATE%TYPE := NULL,
73 p_original_service_line_id IN NUMBER := NULL,
74 p_warranty_flag IN CS_CP_SERVICES.WARRANTY_FLAG%TYPE := NULL,
75 p_original_start_date IN CS_CP_SERVICES.ORIGINAL_START_DATE%TYPE := NULL,
76 p_original_end_date IN CS_CP_SERVICES.ORIGINAL_END_DATE%TYPE := NULL,
77 p_service_date_change IN CS_CP_SERVICES.SERVICE_DATE_CHANGE%TYPE := NULL,
78 p_workflow IN CS_CP_SERVICES.WORKFLOW%TYPE := NULL,
79 p_ship_to_site_use_id IN NUMBER := NULL,
80 p_riginl_systm_lin_rfrnc IN CS_CP_SERVICES.ORIGINAL_SYSTEM_LINE_REFERENCE%TYPE := NULL,
81 p_extended_price IN NUMBER := NULL,
82 p_discount_id IN NUMBER := NULL,
83 p_tax_code IN CS_CP_SERVICES.TAX_CODE%TYPE := NULL,
84 p_billing_frequency_period IN CS_CP_SERVICES.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
85 p_first_bill_date IN CS_CP_SERVICES.FIRST_BILL_DATE%TYPE := NULL,
86 p_next_bill_date IN CS_CP_SERVICES.NEXT_BILL_DATE%TYPE := NULL,
87 p_creation_date IN CS_CP_SERVICES.CREATION_DATE%TYPE := NULL,
88 p_bill_on IN NUMBER := NULL,
89 p_created_by IN NUMBER := NULL,
90 p_last_update_date IN CS_CP_SERVICES.LAST_UPDATE_DATE%TYPE := NULL,
91 p_last_updated_by IN NUMBER := NULL,
92 p_last_update_login IN NUMBER := NULL,
93 p_start_date_active IN CS_CP_SERVICES.START_DATE_ACTIVE%TYPE := NULL,
94 p_end_date_active IN CS_CP_SERVICES.END_DATE_ACTIVE%TYPE := NULL,
95 p_pricing_attribute1 IN CS_CP_SERVICES.PRICING_ATTRIBUTE1%TYPE := NULL,
96 p_pricing_attribute2 IN CS_CP_SERVICES.PRICING_ATTRIBUTE2%TYPE := NULL,
97 p_pricing_attribute3 IN CS_CP_SERVICES.PRICING_ATTRIBUTE3%TYPE := NULL,
98 p_pricing_attribute4 IN CS_CP_SERVICES.PRICING_ATTRIBUTE4%TYPE := NULL,
99 p_pricing_attribute5 IN CS_CP_SERVICES.PRICING_ATTRIBUTE5%TYPE := NULL,
100 p_pricing_attribute6 IN CS_CP_SERVICES.PRICING_ATTRIBUTE6%TYPE := NULL,
101 p_pricing_attribute7 IN CS_CP_SERVICES.PRICING_ATTRIBUTE7%TYPE := NULL,
102 p_pricing_attribute8 IN CS_CP_SERVICES.PRICING_ATTRIBUTE8%TYPE := NULL,
103 p_pricing_attribute9 IN CS_CP_SERVICES.PRICING_ATTRIBUTE9%TYPE := NULL,
104 p_pricing_attribute10 IN CS_CP_SERVICES.PRICING_ATTRIBUTE10%TYPE := NULL,
105 p_pricing_attribute11 IN CS_CP_SERVICES.PRICING_ATTRIBUTE11%TYPE := NULL,
106 p_pricing_attribute12 IN CS_CP_SERVICES.PRICING_ATTRIBUTE12%TYPE := NULL,
107 p_pricing_attribute13 IN CS_CP_SERVICES.PRICING_ATTRIBUTE13%TYPE := NULL,
108 p_pricing_attribute14 IN CS_CP_SERVICES.PRICING_ATTRIBUTE14%TYPE := NULL,
109 p_pricing_attribute15 IN CS_CP_SERVICES.PRICING_ATTRIBUTE15%TYPE := NULL,
110 p_pricing_context IN CS_CP_SERVICES.PRICING_CONTEXT%TYPE := NULL,
111 p_attribute1 IN CS_CP_SERVICES.ATTRIBUTE1%TYPE := NULL,
112 p_attribute2 IN CS_CP_SERVICES.ATTRIBUTE2%TYPE := NULL,
113 p_attribute3 IN CS_CP_SERVICES.ATTRIBUTE3%TYPE := NULL,
114 p_attribute4 IN CS_CP_SERVICES.ATTRIBUTE4%TYPE := NULL,
115 p_attribute5 IN CS_CP_SERVICES.ATTRIBUTE5%TYPE := NULL,
116 p_attribute6 IN CS_CP_SERVICES.ATTRIBUTE6%TYPE := NULL,
117 p_attribute7 IN CS_CP_SERVICES.ATTRIBUTE7%TYPE := NULL,
118 p_attribute8 IN CS_CP_SERVICES.ATTRIBUTE8%TYPE := NULL,
119 p_attribute9 IN CS_CP_SERVICES.ATTRIBUTE9%TYPE := NULL,
120 p_attribute10 IN CS_CP_SERVICES.ATTRIBUTE10%TYPE := NULL,
121 p_attribute11 IN CS_CP_SERVICES.ATTRIBUTE11%TYPE := NULL,
122 p_attribute12 IN CS_CP_SERVICES.ATTRIBUTE12%TYPE := NULL,
123 p_attribute13 IN CS_CP_SERVICES.ATTRIBUTE13%TYPE := NULL,
124 p_attribute14 IN CS_CP_SERVICES.ATTRIBUTE14%TYPE := NULL,
125 p_attribute15 IN CS_CP_SERVICES.ATTRIBUTE15%TYPE := NULL,
126 p_context IN CS_CP_SERVICES.CONTEXT%TYPE := NULL,
127 p_list_price IN NUMBER := NULL,
128 p_org_id IN NUMBER := NULL,
129 p_price_percent IN NUMBER := NULL,
130 x_cp_service_id OUT CS_CP_SERVICES.CP_SERVICE_ID%TYPE );
131
132
133 Procedure Update_Service
134 (
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
137 p_validation_level IN NUMBER,
138 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
139 x_return_status OUT VARCHAR2,
140 x_msg_count OUT NUMBER,
141 x_msg_data OUT VARCHAR2,
142 p_customer_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
143 p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
144 p_contract_line_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
145 p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
146 p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
147 p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
148 p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
149 p_status_code IN CS_CP_SERVICES.STATUS_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
150 p_lst_cp_srvic_trnsctin_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
151 p_invoice_flag IN CS_CP_SERVICES.INVOICE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
152 p_coverage_schedule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
153 p_prorate_flag IN CS_CP_SERVICES.PRORATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
154 p_duration_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
155 p_unit_of_measure_code IN CS_CP_SERVICES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
156 p_starting_delay IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
157 p_bill_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
158 p_bill_to_contact_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
159 p_srvic_txn_vilbility_cd IN CS_CP_SERVICES.SERVICE_TXN_AVAILABILITY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
160 p_next_pm_visit_date IN CS_CP_SERVICES.NEXT_PM_VISIT_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
161 p_pm_visits_completed IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
162 p_last_pm_visit_date IN CS_CP_SERVICES.LAST_PM_VISIT_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
163 p_pm_schedule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
164 p_pm_schedule_flag IN CS_CP_SERVICES.PM_SCHEDULE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
165 p_current_max_schedule_date IN CS_CP_SERVICES.CURRENT_MAX_SCHEDULE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
166 p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
167 p_service_order_type IN CS_CP_SERVICES.SERVICE_ORDER_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
168 p_invoice_count IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
169 p_currency_code IN CS_CP_SERVICES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
170 p_conversion_type IN CS_CP_SERVICES.CONVERSION_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
171 p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
172 p_conversion_date IN CS_CP_SERVICES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
173 p_original_service_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
174 p_warranty_flag IN CS_CP_SERVICES.WARRANTY_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
175 p_original_start_date IN CS_CP_SERVICES.ORIGINAL_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
176 p_original_end_date IN CS_CP_SERVICES.ORIGINAL_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
177 p_service_date_change IN CS_CP_SERVICES.SERVICE_DATE_CHANGE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
178 p_workflow IN CS_CP_SERVICES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
179 p_ship_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
180 p_riginl_systm_lin_rfrnc IN CS_CP_SERVICES.ORIGINAL_SYSTEM_LINE_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
181 p_extended_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
182 p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
183 p_tax_code IN CS_CP_SERVICES.TAX_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
184 p_billing_frequency_period IN CS_CP_SERVICES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
185 p_first_bill_date IN CS_CP_SERVICES.FIRST_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
186 p_next_bill_date IN CS_CP_SERVICES.NEXT_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
187 p_creation_date IN CS_CP_SERVICES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
188 p_bill_on IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
189 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
190 p_last_update_date IN CS_CP_SERVICES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
191 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
192 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
193 p_start_date_active IN CS_CP_SERVICES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
194 p_end_date_active IN CS_CP_SERVICES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
195 p_pricing_attribute1 IN CS_CP_SERVICES.PRICING_ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
196 p_pricing_attribute2 IN CS_CP_SERVICES.PRICING_ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
197 p_pricing_attribute3 IN CS_CP_SERVICES.PRICING_ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
198 p_pricing_attribute4 IN CS_CP_SERVICES.PRICING_ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
199 p_pricing_attribute5 IN CS_CP_SERVICES.PRICING_ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
200 p_pricing_attribute6 IN CS_CP_SERVICES.PRICING_ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
201 p_pricing_attribute7 IN CS_CP_SERVICES.PRICING_ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
202 p_pricing_attribute8 IN CS_CP_SERVICES.PRICING_ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
203 p_pricing_attribute9 IN CS_CP_SERVICES.PRICING_ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
204 p_pricing_attribute10 IN CS_CP_SERVICES.PRICING_ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
205 p_pricing_attribute11 IN CS_CP_SERVICES.PRICING_ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
206 p_pricing_attribute12 IN CS_CP_SERVICES.PRICING_ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
207 p_pricing_attribute13 IN CS_CP_SERVICES.PRICING_ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
208 p_pricing_attribute14 IN CS_CP_SERVICES.PRICING_ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
209 p_pricing_attribute15 IN CS_CP_SERVICES.PRICING_ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
210 p_pricing_context IN CS_CP_SERVICES.PRICING_CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
211 p_attribute1 IN CS_CP_SERVICES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
212 p_attribute2 IN CS_CP_SERVICES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
213 p_attribute3 IN CS_CP_SERVICES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
214 p_attribute4 IN CS_CP_SERVICES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
215 p_attribute5 IN CS_CP_SERVICES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
216 p_attribute6 IN CS_CP_SERVICES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
217 p_attribute7 IN CS_CP_SERVICES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
218 p_attribute8 IN CS_CP_SERVICES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
219 p_attribute9 IN CS_CP_SERVICES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
220 p_attribute10 IN CS_CP_SERVICES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
221 p_attribute11 IN CS_CP_SERVICES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
222 p_attribute12 IN CS_CP_SERVICES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
223 p_attribute13 IN CS_CP_SERVICES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
224 p_attribute14 IN CS_CP_SERVICES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
225 p_attribute15 IN CS_CP_SERVICES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
226 p_context IN CS_CP_SERVICES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
227 p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
228 p_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
229 p_price_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
230
231 END CS_SERVICES_PVT;