[Home] [Help]
PACKAGE: APPS.CS_CONTRACTLTMPL_PVT
Source
1 Package CS_CONTRACTLTMPL_PVT AUTHID CURRENT_USER AS
2 /* $Header: csctclts.pls 115.0 99/07/16 08:50:10 porting ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE ContractLTmpl_Rec_Type IS RECORD (
7 contract_line_template_id NUMBER := NULL,
8 contract_template_id NUMBER := NULL,
9 coverage_id NUMBER := NULL,
10 service_manufacturing_org_id NUMBER := NULL,
11 service_inventory_item_id NUMBER := NULL,
12 workflow CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := NULL,
13 duration NUMBER := NULL,
14 unit_of_measure_code CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := NULL,
15 original_system_reference CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := NULL,
16 last_update_date CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := NULL,
17 last_updated_by NUMBER := NULL,
18 creation_date CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := NULL,
19 created_by NUMBER := NULL,
20 last_update_login NUMBER := NULL,
21 start_date_active CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := NULL,
22 end_date_active CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := NULL,
23 attribute1 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := NULL,
24 attribute2 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := NULL,
25 attribute3 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := NULL,
26 attribute4 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := NULL,
27 attribute5 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := NULL,
28 attribute6 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := NULL,
29 attribute7 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := NULL,
30 attribute8 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := NULL,
31 attribute9 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := NULL,
32 attribute10 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := NULL,
33 attribute11 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := NULL,
34 attribute12 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := NULL,
35 attribute13 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := NULL,
36 attribute14 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := NULL,
37 attribute15 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := NULL,
38 context CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := NULL,
39 object_version_number NUMBER := NULL);
40 G_MISS_contractltmpl_rec ContractLTmpl_Rec_Type;
41 TYPE ContractLTmpl_Val_Rec_Type IS RECORD (
42 contract_line_template_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
43 contract_template_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
44 coverage_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
45 service_manufacturing_org_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
46 service_inventory_item_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
47 workflow CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
48 duration NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
49 unit_of_measure_code CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
50 original_system_reference CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
51 last_update_date CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
52 last_updated_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
53 creation_date CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
54 created_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
55 last_update_login NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
56 start_date_active CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
57 end_date_active CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
58 attribute1 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
59 attribute2 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
60 attribute3 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
61 attribute4 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
62 attribute5 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
63 attribute6 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
64 attribute7 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
65 attribute8 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
66 attribute9 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
67 attribute10 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
68 attribute11 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
69 attribute12 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
70 attribute13 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
71 attribute14 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
72 attribute15 CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
73 context CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
74 object_version_number NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
75 G_MISS_contractltmpl_val_rec ContractLTmpl_Val_Rec_Type;
76 ---------------------------------------------------------------------------
77 -- GLOBAL MESSAGE CONSTANTS
78 ---------------------------------------------------------------------------
79 G_FND_APP CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FND_APP;
80 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_UNABLE_TO_RESERVE_REC;
81 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
82 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
83 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
84 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
85 G_INVALID_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
86 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
87 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_PARENT_TABLE_TOKEN;
88 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_CHILD_TABLE_TOKEN;
89 ---------------------------------------------------------------------------
90 -- GLOBAL VARIABLES
91 ---------------------------------------------------------------------------
92 G_PKG_NAME CONSTANT VARCHAR2(200) := 'CS_CONTRACTLTMPL_PVT';
93 G_APP_NAME CONSTANT VARCHAR2(3) := TAPI_DEV_KIT.G_APP_NAME;
94 ---------------------------------------------------------------------------
95 -- Procedures and Functions
96 ---------------------------------------------------------------------------
97
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_contractltmpl_rec IN ContractLTmpl_Rec_Type := G_MISS_CONTRACTLTMPL_REC,
108 x_contract_line_template_id OUT NUMBER,
109 x_object_version_number OUT NUMBER);
110 PROCEDURE insert_row
111 (
112 p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
114 p_validation_level IN NUMBER,
115 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
116 x_return_status OUT VARCHAR2,
117 x_msg_count OUT NUMBER,
118 x_msg_data OUT VARCHAR2,
119 p_contract_template_id IN NUMBER := NULL,
120 p_coverage_id IN NUMBER := NULL,
121 p_service_manufacturing_org_id IN NUMBER := NULL,
122 p_service_inventory_item_id IN NUMBER := NULL,
123 p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := NULL,
124 p_duration IN NUMBER := NULL,
125 p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := NULL,
126 p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := NULL,
127 p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := NULL,
128 p_last_updated_by IN NUMBER := NULL,
129 p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := NULL,
130 p_created_by IN NUMBER := NULL,
131 p_last_update_login IN NUMBER := NULL,
132 p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := NULL,
133 p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := NULL,
134 p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := NULL,
135 p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := NULL,
136 p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := NULL,
137 p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := NULL,
138 p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := NULL,
139 p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := NULL,
140 p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := NULL,
141 p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := NULL,
142 p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := NULL,
143 p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := NULL,
144 p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := NULL,
145 p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := NULL,
146 p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := NULL,
147 p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := NULL,
148 p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := NULL,
149 p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := NULL,
150 p_object_version_number IN NUMBER := NULL,
151 x_contract_line_template_id OUT NUMBER,
152 x_object_version_number OUT NUMBER);
153 Procedure lock_row
154 (
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
157 p_validation_level IN NUMBER,
158 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
159 x_return_status OUT VARCHAR2,
160 x_msg_count OUT NUMBER,
161 x_msg_data OUT VARCHAR2,
162 p_contract_line_template_id IN NUMBER,
163 p_object_version_number IN NUMBER);
164 Procedure update_row
165 (
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
168 p_validation_level IN NUMBER,
169 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
170 x_return_status OUT VARCHAR2,
171 x_msg_count OUT NUMBER,
172 x_msg_data OUT VARCHAR2,
173 p_contractltmpl_val_rec IN ContractLTmpl_Val_Rec_Type := G_MISS_CONTRACTLTMPL_VAL_REC,
174 x_object_version_number OUT NUMBER);
175 Procedure update_row
176 (
177 p_api_version IN NUMBER,
178 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
179 p_validation_level IN NUMBER,
180 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
181 x_return_status OUT VARCHAR2,
182 x_msg_count OUT NUMBER,
183 x_msg_data OUT VARCHAR2,
184 p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
185 p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
186 p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
187 p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
188 p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
189 p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
190 p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
191 p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
192 p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
193 p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
194 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
195 p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
196 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
197 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
201 p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
198 p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
199 p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
200 p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
202 p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
203 p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
204 p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
205 p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
206 p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
207 p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
208 p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
209 p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
210 p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
211 p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
212 p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
213 p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
214 p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
215 p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
216 p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
217 x_object_version_number OUT NUMBER);
218 Procedure delete_row
219 (
220 p_api_version IN NUMBER,
221 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
222 p_validation_level IN NUMBER,
223 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
224 x_return_status OUT VARCHAR2,
225 x_msg_count OUT NUMBER,
226 x_msg_data OUT VARCHAR2,
227 p_contract_line_template_id IN NUMBER);
228 PROCEDURE validate_row
229 (
230 p_api_version IN NUMBER,
231 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
232 p_validation_level IN NUMBER,
233 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
234 x_return_status OUT VARCHAR2,
235 x_msg_count OUT NUMBER,
236 x_msg_data OUT VARCHAR2,
237 p_contractltmpl_val_rec IN ContractLTmpl_Val_Rec_Type := G_MISS_CONTRACTLTMPL_VAL_REC);
238 PROCEDURE validate_row
239 (
240 p_api_version IN NUMBER,
241 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
242 p_validation_level IN NUMBER,
243 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
244 x_return_status OUT VARCHAR2,
245 x_msg_count OUT NUMBER,
246 x_msg_data OUT VARCHAR2,
247 p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
248 p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
249 p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
250 p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
251 p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
252 p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
253 p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
254 p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
255 p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
256 p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
257 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
258 p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
259 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
260 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
261 p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
262 p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
263 p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
264 p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
265 p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
266 p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
267 p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
268 p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
269 p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
270 p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
271 p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
272 p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
273 p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
274 p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
278 p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
275 p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
276 p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
277 p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
279 p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
280 END CS_CONTRACTLTMPL_PVT;