[Home] [Help]
PACKAGE: APPS.OKC_PAT_PVT
Source
1 Package OKC_PAT_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCSPATS.pls 120.0 2005/05/25 18:04:36 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE pat_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 pat_id NUMBER := OKC_API.G_MISS_NUM,
9 chr_id NUMBER := OKC_API.G_MISS_NUM,
10 cle_id NUMBER := OKC_API.G_MISS_NUM,
11 bsl_id NUMBER := OKC_API.G_MISS_NUM,
12 bcl_id NUMBER := OKC_API.G_MISS_NUM,
13 created_by NUMBER := OKC_API.G_MISS_NUM,
14 creation_date OKC_PRICE_ADJUSTMENTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16 last_update_date OKC_PRICE_ADJUSTMENTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17 modified_from NUMBER := OKC_API.G_MISS_NUM,
18 modified_to NUMBER := OKC_API.G_MISS_NUM,
19 modifier_mechanism_type_code OKC_PRICE_ADJUSTMENTS.MODIFIER_MECHANISM_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
20 operand NUMBER := OKC_API.G_MISS_NUM,
21 arithmetic_operator OKC_PRICE_ADJUSTMENTS.ARITHMETIC_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
22 automatic_flag OKC_PRICE_ADJUSTMENTS.AUTOMATIC_FLAG%TYPE := OKC_API.G_MISS_CHAR,
23 update_allowed OKC_PRICE_ADJUSTMENTS.UPDATE_ALLOWED%TYPE := OKC_API.G_MISS_CHAR,
24 updated_flag OKC_PRICE_ADJUSTMENTS.UPDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25 applied_flag OKC_PRICE_ADJUSTMENTS.APPLIED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26 on_invoice_flag OKC_PRICE_ADJUSTMENTS.ON_INVOICE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
27 pricing_phase_id NUMBER := OKC_API.G_MISS_NUM,
28 context OKC_PRICE_ADJUSTMENTS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
29 program_application_id NUMBER := OKC_API.G_MISS_NUM,
30 program_id NUMBER := OKC_API.G_MISS_NUM,
31 program_update_date OKC_PRICE_ADJUSTMENTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32 request_id NUMBER := OKC_API.G_MISS_NUM,
33 list_header_id NUMBER := OKC_API.G_MISS_NUM,
34 list_line_id NUMBER := OKC_API.G_MISS_NUM,
35 list_line_type_code OKC_PRICE_ADJUSTMENTS.LIST_LINE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
36 change_reason_code OKC_PRICE_ADJUSTMENTS.CHANGE_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
37 change_reason_text OKC_PRICE_ADJUSTMENTS.CHANGE_REASON_TEXT%TYPE := OKC_API.G_MISS_CHAR,
38 estimated_flag OKC_PRICE_ADJUSTMENTS.ESTIMATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39 adjusted_amount NUMBER := OKC_API.G_MISS_NUM,
40 charge_type_code OKC_PRICE_ADJUSTMENTS.CHARGE_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
41 charge_subtype_code OKC_PRICE_ADJUSTMENTS.CHARGE_SUBTYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
42 range_break_quantity NUMBER := OKC_API.G_MISS_NUM,
43 accrual_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
44 pricing_group_sequence NUMBER := OKC_API.G_MISS_NUM,
45 accrual_flag OKC_PRICE_ADJUSTMENTS.ACCRUAL_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
46 list_line_no OKC_PRICE_ADJUSTMENTS.LIST_LINE_NO%TYPE := OKC_API.G_MISS_CHAR,
47 source_system_code OKC_PRICE_ADJUSTMENTS.SOURCE_SYSTEM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
48 benefit_qty NUMBER := OKC_API.G_MISS_NUM,
49 benefit_uom_code OKC_PRICE_ADJUSTMENTS.BENEFIT_UOM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
50 expiration_date OKC_PRICE_ADJUSTMENTS.EXPIRATION_DATE%TYPE := OKC_API.G_MISS_DATE,
51 modifier_level_code OKC_PRICE_ADJUSTMENTS.MODIFIER_LEVEL_CODE%TYPE :=OKC_API.G_MISS_CHAR,
52 price_break_type_code OKC_PRICE_ADJUSTMENTS.PRICE_BREAK_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
53 substitution_attribute OKC_PRICE_ADJUSTMENTS.SUBSTITUTION_ATTRIBUTE%TYPE :=OKC_API.G_MISS_CHAR,
54 proration_type_code OKC_PRICE_ADJUSTMENTS.PRORATION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
55 include_on_returns_flag OKC_PRICE_ADJUSTMENTS.INCLUDE_ON_RETURNS_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
56 object_version_number NUMBER := OKC_API.G_MISS_NUM,
57 attribute1 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
58 attribute2 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
59 attribute3 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
60 attribute4 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
61 attribute5 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
62 attribute6 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
63 attribute7 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
64 attribute8 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
65 attribute9 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
66 attribute10 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67 attribute11 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68 attribute12 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69 attribute13 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70 attribute14 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
71 attribute15 OKC_PRICE_ADJUSTMENTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
72 last_update_login NUMBER := OKC_API.G_MISS_NUM,
73 rebate_transaction_type_code OKC_PRICE_ADJUSTMENTS.REBATE_TRANSACTION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR);
74 g_miss_pat_rec pat_rec_type;
75 TYPE pat_tbl_type IS TABLE OF pat_rec_type
76 INDEX BY BINARY_INTEGER;
77 TYPE patv_rec_type IS RECORD (
78 id NUMBER := OKC_API.G_MISS_NUM,
79 pat_id NUMBER := OKC_API.G_MISS_NUM,
80 chr_id NUMBER := OKC_API.G_MISS_NUM,
81 cle_id NUMBER := OKC_API.G_MISS_NUM,
82 bsl_id NUMBER := OKC_API.G_MISS_NUM,
83 bcl_id NUMBER := OKC_API.G_MISS_NUM,
84 modified_from NUMBER := OKC_API.G_MISS_NUM,
85 modified_to NUMBER := OKC_API.G_MISS_NUM,
86 modifier_mechanism_type_code OKC_PRICE_ADJUSTMENTS_V.MODIFIER_MECHANISM_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
87 operand NUMBER := OKC_API.G_MISS_NUM,
88 arithmetic_operator OKC_PRICE_ADJUSTMENTS_V.ARITHMETIC_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
89 automatic_flag OKC_PRICE_ADJUSTMENTS_V.AUTOMATIC_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90 update_allowed OKC_PRICE_ADJUSTMENTS_V.UPDATE_ALLOWED%TYPE := OKC_API.G_MISS_CHAR,
91 updated_flag OKC_PRICE_ADJUSTMENTS_V.UPDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
92 applied_flag OKC_PRICE_ADJUSTMENTS_V.APPLIED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
93 on_invoice_flag OKC_PRICE_ADJUSTMENTS_V.ON_INVOICE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
94 pricing_phase_id NUMBER := OKC_API.G_MISS_NUM,
95 context OKC_PRICE_ADJUSTMENTS_V.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
96 program_application_id NUMBER := OKC_API.G_MISS_NUM,
97 program_id NUMBER := OKC_API.G_MISS_NUM,
98 program_update_date OKC_PRICE_ADJUSTMENTS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
99 request_id NUMBER := OKC_API.G_MISS_NUM,
100 list_header_id NUMBER := OKC_API.G_MISS_NUM,
101 list_line_id NUMBER := OKC_API.G_MISS_NUM,
102 list_line_type_code OKC_PRICE_ADJUSTMENTS_V.LIST_LINE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
103 change_reason_code OKC_PRICE_ADJUSTMENTS_V.CHANGE_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
104 change_reason_text OKC_PRICE_ADJUSTMENTS_V.CHANGE_REASON_TEXT%TYPE := OKC_API.G_MISS_CHAR,
105 estimated_flag OKC_PRICE_ADJUSTMENTS_V.ESTIMATED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
106 adjusted_amount NUMBER := OKC_API.G_MISS_NUM,
107 charge_type_code OKC_PRICE_ADJUSTMENTS_V.CHARGE_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
108 charge_subtype_code OKC_PRICE_ADJUSTMENTS_V.CHARGE_SUBTYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
109 range_break_quantity NUMBER := OKC_API.G_MISS_NUM,
110 accrual_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
111 pricing_group_sequence NUMBER := OKC_API.G_MISS_NUM,
112 accrual_flag OKC_PRICE_ADJUSTMENTS_V.ACCRUAL_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
113 list_line_no OKC_PRICE_ADJUSTMENTS_V.LIST_LINE_NO%TYPE := OKC_API.G_MISS_CHAR,
114 source_system_code OKC_PRICE_ADJUSTMENTS_V.SOURCE_SYSTEM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
115 benefit_qty NUMBER := OKC_API.G_MISS_NUM,
116 benefit_uom_code OKC_PRICE_ADJUSTMENTS_V.BENEFIT_UOM_CODE%TYPE :=OKC_API.G_MISS_CHAR,
117 expiration_date OKC_PRICE_ADJUSTMENTS_V.EXPIRATION_DATE%TYPE := OKC_API.G_MISS_DATE,
118 modifier_level_code OKC_PRICE_ADJUSTMENTS_V.MODIFIER_LEVEL_CODE%TYPE :=OKC_API.G_MISS_CHAR,
119 price_break_type_code OKC_PRICE_ADJUSTMENTS_V.PRICE_BREAK_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
120 substitution_attribute OKC_PRICE_ADJUSTMENTS_V.SUBSTITUTION_ATTRIBUTE%TYPE :=OKC_API.G_MISS_CHAR,
121 proration_type_code OKC_PRICE_ADJUSTMENTS_V.PRORATION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
122 include_on_returns_flag OKC_PRICE_ADJUSTMENTS_V.INCLUDE_ON_RETURNS_FLAG%TYPE :=OKC_API.G_MISS_CHAR,
123 object_version_number NUMBER := OKC_API.G_MISS_NUM,
124 attribute1 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
125 attribute2 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
126 attribute3 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
127 attribute4 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
128 attribute5 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
129 attribute6 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
130 attribute7 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
131 attribute8 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
132 attribute9 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
133 attribute10 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
134 attribute11 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
135 attribute12 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
136 attribute13 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
137 attribute14 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
138 attribute15 OKC_PRICE_ADJUSTMENTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
139 created_by NUMBER := OKC_API.G_MISS_NUM,
140 creation_date OKC_PRICE_ADJUSTMENTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
141 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
142 last_update_date OKC_PRICE_ADJUSTMENTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
143 last_update_login NUMBER := OKC_API.G_MISS_NUM,
144 rebate_transaction_type_code OKC_PRICE_ADJUSTMENTS.REBATE_TRANSACTION_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR);
145 g_miss_patv_rec patv_rec_type;
146 TYPE patv_tbl_type IS TABLE OF patv_rec_type
147 INDEX BY BINARY_INTEGER;
148 ---------------------------------------------------------------------------
149 -- GLOBAL MESSAGE CONSTANTS
150 ---------------------------------------------------------------------------
151 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
152 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
153 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
154 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
155 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
156 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
157 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
158 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
159 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
160 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
161 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
162 G_FOREIGN_KEY_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_FK_ERROR';
163 G_UNIQUE_KEY_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNIQUE_KEY_ERROR';
164 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
165 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
166 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQD';
167
168 ---------------------------------------------------------------------------
169 -- GLOBAL EXCEPTION
170 ---------------------------------------------------------------------------
171 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
172
173 ---------------------------------------------------------------------------
174 -- GLOBAL VARIABLES
175 ---------------------------------------------------------------------------
176 G_PKG_NAME CONSTANT VARCHAR2(200) := 'PAT_PVT';
177 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
178 ---------------------------------------------------------------------------
179 -- Procedures and Functions
180 ---------------------------------------------------------------------------
181
182 PROCEDURE qc;
183 PROCEDURE change_version;
184 PROCEDURE api_copy;
185 PROCEDURE insert_row(
186 p_api_version IN NUMBER,
187 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188 x_return_status OUT NOCOPY VARCHAR2,
189 x_msg_count OUT NOCOPY NUMBER,
190 x_msg_data OUT NOCOPY VARCHAR2,
191 p_patv_rec IN patv_rec_type,
192 x_patv_rec OUT NOCOPY patv_rec_type);
193
194 PROCEDURE insert_row(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 p_patv_tbl IN patv_tbl_type,
201 x_patv_tbl OUT NOCOPY patv_tbl_type);
202
203 PROCEDURE lock_row(
204 p_api_version IN NUMBER,
205 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 p_patv_rec IN patv_rec_type);
210
211 PROCEDURE lock_row(
212 p_api_version IN NUMBER,
213 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
214 x_return_status OUT NOCOPY VARCHAR2,
215 x_msg_count OUT NOCOPY NUMBER,
216 x_msg_data OUT NOCOPY VARCHAR2,
217 p_patv_tbl IN patv_tbl_type);
218
219 PROCEDURE update_row(
220 p_api_version IN NUMBER,
221 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_msg_count OUT NOCOPY NUMBER,
224 x_msg_data OUT NOCOPY VARCHAR2,
225 p_patv_rec IN patv_rec_type,
226 x_patv_rec OUT NOCOPY patv_rec_type);
227
228 PROCEDURE update_row(
229 p_api_version IN NUMBER,
230 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
231 x_return_status OUT NOCOPY VARCHAR2,
232 x_msg_count OUT NOCOPY NUMBER,
233 x_msg_data OUT NOCOPY VARCHAR2,
234 p_patv_tbl IN patv_tbl_type,
235 x_patv_tbl OUT NOCOPY patv_tbl_type);
236
237 PROCEDURE delete_row(
238 p_api_version IN NUMBER,
239 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
240 x_return_status OUT NOCOPY VARCHAR2,
241 x_msg_count OUT NOCOPY NUMBER,
242 x_msg_data OUT NOCOPY VARCHAR2,
243 p_patv_rec IN patv_rec_type);
244
245 PROCEDURE delete_row(
246 p_api_version IN NUMBER,
247 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
248 x_return_status OUT NOCOPY VARCHAR2,
249 x_msg_count OUT NOCOPY NUMBER,
250 x_msg_data OUT NOCOPY VARCHAR2,
251 p_patv_tbl IN patv_tbl_type);
252
253 PROCEDURE validate_row(
254 p_api_version IN NUMBER,
255 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
256 x_return_status OUT NOCOPY VARCHAR2,
257 x_msg_count OUT NOCOPY NUMBER,
258 x_msg_data OUT NOCOPY VARCHAR2,
259 p_patv_rec IN patv_rec_type);
260
261 PROCEDURE validate_row(
262 p_api_version IN NUMBER,
263 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
264 x_return_status OUT NOCOPY VARCHAR2,
265 x_msg_count OUT NOCOPY NUMBER,
266 x_msg_data OUT NOCOPY VARCHAR2,
267 p_patv_tbl IN patv_tbl_type);
268
269 PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_patv_tbl patv_tbl_type);
270
271 FUNCTION create_version(
272 p_chr_id IN NUMBER,
273 p_major_version IN NUMBER) RETURN VARCHAR2;
274
275 FUNCTION restore_version(
276 p_chr_id IN NUMBER,
277 p_major_version IN NUMBER) RETURN VARCHAR2;
278
279 END OKC_PAT_PVT;