[Home] [Help]
PACKAGE: APPS.OKL_OKC_MIGRATION_PVT
Source
1 PACKAGE okl_okc_migration_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLROKCS.pls 120.2 2006/11/13 07:34:05 dpsingh noship $ */
3 -- The Enities we are Handling are as listed below
4 --1.OKC_K_VERS_NUMBERS_V -- cvmv
5 --2.OKC_K_HEADERS_V -- chrv
6 --3.OKC_K_LINES_V -- clev
7 --4.OKC_K_ITEMS_V -- cimv
8 --5.OKC_K_PARTY_ROLES_V -- cplv
9 --6.OKC_GOVERNANCES_V -- gvev
10 --7.OKC_RULE_GROUPS_V -- rgpv
11 --8.OKC_RG_PARTY_ROLES_V -- rmpv
12 --9.OKC_CONTACTS_V -- ctcv
13 -- End of Listing
14 -- Badriath Kuchibhotla
15 TYPE cvmv_rec_type IS RECORD (
16 chr_id NUMBER := OKC_API.G_MISS_NUM,
17 object_version_number NUMBER := OKC_API.G_MISS_NUM,
18 major_version NUMBER := OKC_API.G_MISS_NUM,
19 minor_version NUMBER := OKC_API.G_MISS_NUM,
20 created_by NUMBER := OKC_API.G_MISS_NUM,
21 creation_date OKC_K_VERS_NUMBERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
22 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
23 last_update_date OKC_K_VERS_NUMBERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
24 last_update_login NUMBER := OKC_API.G_MISS_NUM);
25
26 TYPE cvmv_tbl_type IS TABLE OF cvmv_rec_type
27 INDEX BY BINARY_INTEGER;
28
29 TYPE chrv_rec_type IS RECORD (
30 id NUMBER := OKC_API.G_MISS_NUM,
31 object_version_number NUMBER := OKC_API.G_MISS_NUM,
32 sfwt_flag OKC_K_HEADERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
33 chr_id_response NUMBER := OKC_API.G_MISS_NUM,
34 chr_id_award NUMBER := OKC_API.G_MISS_NUM,
35 chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
36 INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
37 sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
38 qcl_id NUMBER := OKC_API.G_MISS_NUM,
39 scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
40 contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
41 currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
42 contract_number_modifier OKC_K_HEADERS_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
43 archived_yn OKC_K_HEADERS_V.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
44 deleted_yn OKC_K_HEADERS_V.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
45 cust_po_number_req_yn OKC_K_HEADERS_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
46 pre_pay_req_yn OKC_K_HEADERS_V.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
47 cust_po_number OKC_K_HEADERS_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
48 short_description OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
49 comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
50 description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51 dpas_rating OKC_K_HEADERS_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
52 cognomen OKC_K_HEADERS_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
53 template_yn OKC_K_HEADERS_V.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
54 template_used OKC_K_HEADERS_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
55 date_approved OKC_K_HEADERS_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
56 datetime_cancelled OKC_K_HEADERS_V.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
57 auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
58 date_issued OKC_K_HEADERS_V.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
59 datetime_responded OKC_K_HEADERS_V.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
60 non_response_reason OKC_K_HEADERS_V.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
61 non_response_explain OKC_K_HEADERS_V.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
62 rfp_type OKC_K_HEADERS_V.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63 chr_type OKC_K_HEADERS_V.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
64 keep_on_mail_list OKC_K_HEADERS_V.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
65 set_aside_reason OKC_K_HEADERS_V.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
66 set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
67 response_copies_req NUMBER := OKC_API.G_MISS_NUM,
68 date_close_projected OKC_K_HEADERS_V.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
69 datetime_proposed OKC_K_HEADERS_V.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
70 date_signed OKC_K_HEADERS_V.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
71 date_terminated OKC_K_HEADERS_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
72 date_renewed OKC_K_HEADERS_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
73 trn_code OKC_K_HEADERS_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
74 start_date OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
75 end_date OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
76 authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
77 buy_or_sell OKC_K_HEADERS_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
78 issue_or_receive OKC_K_HEADERS_V.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
79 estimated_amount NUMBER := OKC_API.G_MISS_NUM,
80 chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
81 estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
82 currency_code_renewed OKC_K_HEADERS_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
83 upg_orig_system_ref OKC_K_HEADERS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
84 upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
85 application_id NUMBER := OKC_API.G_MISS_NUM,
86 orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
87 orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
88 orig_system_reference1 OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
89 program_id NUMBER := OKC_API.G_MISS_NUM,
90 request_id NUMBER := OKC_API.G_MISS_NUM,
91 price_list_id NUMBER := OKC_API.G_MISS_NUM,
92 pricing_date OKC_K_HEADERS_V.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
93 sign_by_date OKC_K_HEADERS_V.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
94 program_update_date OKC_K_HEADERS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
95 total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
96 program_application_id NUMBER := OKC_API.G_MISS_NUM,
97 USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
98 attribute_category OKC_K_HEADERS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
99 attribute1 OKC_K_HEADERS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
100 attribute2 OKC_K_HEADERS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
101 attribute3 OKC_K_HEADERS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
102 attribute4 OKC_K_HEADERS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
103 attribute5 OKC_K_HEADERS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
104 attribute6 OKC_K_HEADERS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
105 attribute7 OKC_K_HEADERS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
106 attribute8 OKC_K_HEADERS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
107 attribute9 OKC_K_HEADERS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
108 attribute10 OKC_K_HEADERS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
109 attribute11 OKC_K_HEADERS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
110 attribute12 OKC_K_HEADERS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
111 attribute13 OKC_K_HEADERS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
112 attribute14 OKC_K_HEADERS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
113 attribute15 OKC_K_HEADERS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
114 created_by NUMBER := OKC_API.G_MISS_NUM,
115 creation_date OKC_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
116 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
117 last_update_date OKC_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
118 last_update_login NUMBER := OKC_API.G_MISS_NUM,
119 old_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
120 new_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
121 old_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
122 new_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
123 --new columns to replace rules
124 conversion_type OKC_K_HEADERS_B.CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
125 conversion_rate NUMBER := OKC_API.G_MISS_NUM,
126 conversion_rate_date OKC_K_HEADERS_B.CONVERSION_RATE_DATE%TYPE := OKC_API.G_MISS_DATE,
127 conversion_euro_rate NUMBER := OKC_API.G_MISS_NUM,
128 cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
129 bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
130 inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
131 renewal_type_code OKC_K_HEADERS_B.RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
132 renewal_notify_to NUMBER :=OKC_API.G_MISS_NUM,
133 renewal_end_date OKC_K_HEADERS_B.RENEWAL_END_DATE%TYPE :=OKC_API.G_MISS_DATE,
134 ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
135 payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
136 --Added by dpsingh for LE Uptake
137 legal_entity_id NUMBER :=OKL_API.G_MISS_NUM);
138
139 TYPE chrv_tbl_type IS TABLE OF chrv_rec_type
140 INDEX BY BINARY_INTEGER;
141
142 TYPE clev_rec_type IS RECORD (
143 id NUMBER := OKC_API.G_MISS_NUM,
144 object_version_number NUMBER := OKC_API.G_MISS_NUM,
145 sfwt_flag OKC_K_LINES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
146 chr_id NUMBER := OKC_API.G_MISS_NUM,
147 cle_id NUMBER := OKC_API.G_MISS_NUM,
148 cle_id_renewed NUMBER := OKC_API.G_MISS_NUM,
149 cle_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
150 lse_id NUMBER := OKC_API.G_MISS_NUM,
151 line_number OKC_K_LINES_V.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
152 sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
153 display_sequence NUMBER := OKC_API.G_MISS_NUM,
154 trn_code OKC_K_LINES_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
155 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
156 comments OKC_K_LINES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
157 item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
158 oke_boe_description OKC_K_LINES_V.OKE_BOE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
159 cognomen OKC_K_LINES_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
160 hidden_ind OKC_K_LINES_V.HIDDEN_IND%TYPE := OKC_API.G_MISS_CHAR,
161 price_unit NUMBER := OKC_API.G_MISS_NUM,
162 price_unit_percent NUMBER := OKC_API.G_MISS_NUM,
163 price_negotiated NUMBER := OKC_API.G_MISS_NUM,
164 price_negotiated_renewed NUMBER := OKC_API.G_MISS_NUM,
165 price_level_ind OKC_K_LINES_V.PRICE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
166 invoice_line_level_ind OKC_K_LINES_V.INVOICE_LINE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
167 dpas_rating OKC_K_LINES_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
168 block23text OKC_K_LINES_V.BLOCK23TEXT%TYPE := OKC_API.G_MISS_CHAR,
169 exception_yn OKC_K_LINES_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
170 template_used OKC_K_LINES_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
171 date_terminated OKC_K_LINES_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
172 name OKC_K_LINES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
173 start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
174 end_date OKC_K_LINES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
175 date_renewed OKC_K_LINES_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
176 upg_orig_system_ref OKC_K_LINES_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
177 upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
178 orig_system_source_code OKC_K_LINES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
179 orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
180 orig_system_reference1 OKC_K_LINES_V.ORIG_SYSTEM_REFERENCE1%TYPE :=OKC_API.G_MISS_CHAR,
181 attribute_category OKC_K_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
182 attribute1 OKC_K_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
183 attribute2 OKC_K_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
184 attribute3 OKC_K_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
185 attribute4 OKC_K_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
186 attribute5 OKC_K_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
187 attribute6 OKC_K_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
188 attribute7 OKC_K_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
189 attribute8 OKC_K_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
190 attribute9 OKC_K_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
191 attribute10 OKC_K_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
192 attribute11 OKC_K_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
193 attribute12 OKC_K_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
194 attribute13 OKC_K_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
195 attribute14 OKC_K_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
196 attribute15 OKC_K_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
197 created_by NUMBER := OKC_API.G_MISS_NUM,
198 creation_date OKC_K_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
199 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
200 last_update_date OKC_K_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
201 price_type OKC_K_LINES_V.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
202 currency_code OKC_K_LINES_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
203 currency_code_renewed OKC_K_LINES_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
204 last_update_login NUMBER := OKC_API.G_MISS_NUM,
205 old_sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
206 new_sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
207 old_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
208 new_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
209 Call_Action_Asmblr VARCHAR2(1) := 'Y',
210 request_id NUMBER := OKC_API.G_MISS_NUM,
211 program_application_id NUMBER := OKC_API.G_MISS_NUM,
212 program_id NUMBER := OKC_API.G_MISS_NUM,
213 program_update_date OKC_K_LINES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
214 price_list_id NUMBER := OKC_API.G_MISS_NUM,
215 pricing_date OKC_K_LINES_V.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
216 price_list_line_id NUMBER := OKC_API.G_MISS_NUM,
217 line_list_price NUMBER := OKC_API.G_MISS_NUM,
218 item_to_price_yn OKC_K_LINES_V.ITEM_TO_PRICE_YN%TYPE := OKC_API.G_MISS_CHAR,
219 price_basis_yn OKC_K_LINES_V.PRICE_BASIS_YN%TYPE := OKC_API.G_MISS_CHAR,
220 config_header_id NUMBER := OKC_API.G_MISS_NUM,
221 config_revision_number NUMBER := OKC_API.G_MISS_NUM,
222 config_complete_yn OKC_K_LINES_V.CONFIG_COMPLETE_YN%TYPE := OKC_API.G_MISS_CHAR,
223 config_valid_yn OKC_K_LINES_V.CONFIG_VALID_YN%TYPE := OKC_API.G_MISS_CHAR,
224 config_top_model_line_id NUMBER := OKC_API.G_MISS_NUM,
225 config_item_type OKC_K_LINES_V.CONFIG_ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR,
226 CONFIG_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
227 --new columns to replace rules
228 cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
229 bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
230 inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
231 line_renewal_type_code OKC_K_LINES_B.LINE_RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
232 ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
233 payment_term_id NUMBER :=OKC_API.G_MISS_NUM
234 );
235
236
237 TYPE clev_tbl_type IS TABLE OF clev_rec_type
238 INDEX BY BINARY_INTEGER;
239
240 TYPE cimv_rec_type IS RECORD (
241 id NUMBER := OKC_API.G_MISS_NUM,
242 object_version_number NUMBER := OKC_API.G_MISS_NUM,
243 cle_id NUMBER := OKC_API.G_MISS_NUM,
244 chr_id NUMBER := OKC_API.G_MISS_NUM,
245 cle_id_for NUMBER := OKC_API.G_MISS_NUM,
246 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
247 object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
248 object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
249 jtot_object1_code OKC_K_ITEMS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
250 uom_code OKC_K_ITEMS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR,
251 exception_yn OKC_K_ITEMS_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
252 number_of_items NUMBER := OKC_API.G_MISS_NUM,
253 upg_orig_system_ref OKC_K_ITEMS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
254 upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
255 priced_item_yn OKC_K_ITEMS_V.PRICED_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
256 created_by NUMBER := OKC_API.G_MISS_NUM,
257 creation_date OKC_K_ITEMS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
258 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
259 last_update_date OKC_K_ITEMS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
260 last_update_login NUMBER := OKC_API.G_MISS_NUM);
261
262 TYPE cimv_tbl_type IS TABLE OF cimv_rec_type
263 INDEX BY BINARY_INTEGER;
264
265 TYPE cplv_rec_type IS RECORD (
266 id NUMBER := OKC_API.G_MISS_NUM,
267 object_version_number NUMBER := OKC_API.G_MISS_NUM,
268 sfwt_flag OKC_K_PARTY_ROLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
269 cpl_id NUMBER := OKC_API.G_MISS_NUM,
270 chr_id NUMBER := OKC_API.G_MISS_NUM,
271 cle_id NUMBER := OKC_API.G_MISS_NUM,
272 rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
273 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
274 object1_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
275 object1_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
276 jtot_object1_code OKC_K_PARTY_ROLES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
277 cognomen OKC_K_PARTY_ROLES_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
278 code OKC_K_PARTY_ROLES_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
279 facility OKC_K_PARTY_ROLES_V.FACILITY%TYPE := OKC_API.G_MISS_CHAR,
280 minority_group_lookup_code OKC_K_PARTY_ROLES_V.MINORITY_GROUP_LOOKUP_CODE%TYPE := OKC_API.G_MISS_CHAR,
281 small_business_flag OKC_K_PARTY_ROLES_V.SMALL_BUSINESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
282 women_owned_flag OKC_K_PARTY_ROLES_V.WOMEN_OWNED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
283 alias OKC_K_PARTY_ROLES_V.ALIAS%TYPE := OKC_API.G_MISS_CHAR,
284 attribute_category OKC_K_PARTY_ROLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
285 attribute1 OKC_K_PARTY_ROLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
286 attribute2 OKC_K_PARTY_ROLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
287 attribute3 OKC_K_PARTY_ROLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
288 attribute4 OKC_K_PARTY_ROLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
289 attribute5 OKC_K_PARTY_ROLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
290 attribute6 OKC_K_PARTY_ROLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
291 attribute7 OKC_K_PARTY_ROLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
292 attribute8 OKC_K_PARTY_ROLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
293 attribute9 OKC_K_PARTY_ROLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
294 attribute10 OKC_K_PARTY_ROLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
295 attribute11 OKC_K_PARTY_ROLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
296 attribute12 OKC_K_PARTY_ROLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
297 attribute13 OKC_K_PARTY_ROLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
298 attribute14 OKC_K_PARTY_ROLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
299 attribute15 OKC_K_PARTY_ROLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
300 created_by NUMBER := OKC_API.G_MISS_NUM,
301 creation_date OKC_K_PARTY_ROLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
302 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
303 last_update_date OKC_K_PARTY_ROLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
304 last_update_login NUMBER := OKC_API.G_MISS_NUM,
305 cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
306 bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM);
307
308 TYPE cplv_tbl_type IS TABLE OF cplv_rec_type
309 INDEX BY BINARY_INTEGER;
310 -- Badriath Kuchibhotla
311
312 TYPE gvev_rec_type IS RECORD (
313 id NUMBER := OKC_API.G_MISS_NUM,
314 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
315 isa_agreement_id NUMBER := OKC_API.G_MISS_NUM,
316 object_version_number NUMBER := OKC_API.G_MISS_NUM,
317 chr_id NUMBER := OKC_API.G_MISS_NUM,
318 cle_id NUMBER := OKC_API.G_MISS_NUM,
319 chr_id_referred NUMBER := OKC_API.G_MISS_NUM,
320 cle_id_referred NUMBER := OKC_API.G_MISS_NUM,
321 copied_only_yn OKC_GOVERNANCES_V.COPIED_ONLY_YN%TYPE := OKC_API.G_MISS_CHAR,
322 created_by NUMBER := OKC_API.G_MISS_NUM,
323 creation_date OKC_GOVERNANCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
324 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
325 last_update_date OKC_GOVERNANCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
326 last_update_login NUMBER := OKC_API.G_MISS_NUM);
327
328 TYPE gvev_tbl_type IS TABLE OF gvev_rec_type
329 INDEX BY BINARY_INTEGER;
330
331 TYPE rgpv_rec_type IS RECORD (
332 id NUMBER := OKC_API.G_MISS_NUM,
333 object_version_number NUMBER := OKC_API.G_MISS_NUM,
334 sfwt_flag OKC_RULE_GROUPS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
335 rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
336 sat_code OKC_RULE_GROUPS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
337 rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
338 cle_id NUMBER := OKC_API.G_MISS_NUM,
339 chr_id NUMBER := OKC_API.G_MISS_NUM,
340 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
341 parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
342 comments OKC_RULE_GROUPS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
343 attribute_category OKC_RULE_GROUPS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
344 attribute1 OKC_RULE_GROUPS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
345 attribute2 OKC_RULE_GROUPS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
346 attribute3 OKC_RULE_GROUPS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
347 attribute4 OKC_RULE_GROUPS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
348 attribute5 OKC_RULE_GROUPS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
349 attribute6 OKC_RULE_GROUPS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
350 attribute7 OKC_RULE_GROUPS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
351 attribute8 OKC_RULE_GROUPS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
352 attribute9 OKC_RULE_GROUPS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
353 attribute10 OKC_RULE_GROUPS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
354 attribute11 OKC_RULE_GROUPS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
355 attribute12 OKC_RULE_GROUPS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
356 attribute13 OKC_RULE_GROUPS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
357 attribute14 OKC_RULE_GROUPS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
358 attribute15 OKC_RULE_GROUPS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
359 created_by NUMBER := OKC_API.G_MISS_NUM,
360 creation_date OKC_RULE_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
361 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
362 last_update_date OKC_RULE_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
363 last_update_login NUMBER := OKC_API.G_MISS_NUM);
364
365 TYPE rgpv_tbl_type IS TABLE OF rgpv_rec_type
366 INDEX BY BINARY_INTEGER;
367
368 TYPE rmpv_rec_type IS RECORD (
369 id NUMBER := OKC_API.G_MISS_NUM,
370 rgp_id NUMBER := OKC_API.G_MISS_NUM,
371 rrd_id NUMBER := OKC_API.G_MISS_NUM,
372 cpl_id NUMBER := OKC_API.G_MISS_NUM,
373 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
374 object_version_number NUMBER := OKC_API.G_MISS_NUM,
375 created_by NUMBER := OKC_API.G_MISS_NUM,
376 creation_date OKC_RG_PARTY_ROLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
377 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
378 last_update_date OKC_RG_PARTY_ROLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
379 last_update_login NUMBER := OKC_API.G_MISS_NUM);
380
381 TYPE rmpv_tbl_type IS TABLE OF rmpv_rec_type
382 INDEX BY BINARY_INTEGER;
383
384 TYPE ctcv_rec_type IS RECORD (
385 id NUMBER := OKC_API.G_MISS_NUM,
386 object_version_number NUMBER := OKC_API.G_MISS_NUM,
387 cpl_id NUMBER := OKC_API.G_MISS_NUM,
388 cro_code OKC_CONTACTS_V.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
389 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
390 contact_sequence NUMBER := OKC_API.G_MISS_NUM,
391 object1_id1 OKC_CONTACTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
392 object1_id2 OKC_CONTACTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
393 jtot_object1_code OKC_CONTACTS_V.jtot_object1_code%TYPE:= OKC_API.G_MISS_CHAR,
394 attribute_category OKC_CONTACTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
395 attribute1 OKC_CONTACTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
396 attribute2 OKC_CONTACTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
397 attribute3 OKC_CONTACTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
398 attribute4 OKC_CONTACTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
399 attribute5 OKC_CONTACTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
400 attribute6 OKC_CONTACTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
401 attribute7 OKC_CONTACTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
402 attribute8 OKC_CONTACTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
403 attribute9 OKC_CONTACTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
404 attribute10 OKC_CONTACTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
405 attribute11 OKC_CONTACTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
406 attribute12 OKC_CONTACTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
407 attribute13 OKC_CONTACTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
408 attribute14 OKC_CONTACTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
409 attribute15 OKC_CONTACTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
410 created_by NUMBER := OKC_API.G_MISS_NUM,
411 creation_date OKC_CONTACTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
412 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
413 last_update_date OKC_CONTACTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
414 last_update_login NUMBER := OKC_API.G_MISS_NUM,
415 start_date OKC_CONTACTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
416 end_date OKC_CONTACTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE);
417
418 TYPE ctcv_tbl_type IS TABLE OF ctcv_rec_type
419 INDEX BY BINARY_INTEGER;
420
421 --------------------------------------------------------------------------------
422 G_API_TYPE VARCHAR2(10) := '_PVT';
423
424
425
426 --start ashish
427 PROCEDURE create_contract_header(
428 p_api_version IN NUMBER,
429 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
430 x_return_status OUT NOCOPY VARCHAR2,
431 x_msg_count OUT NOCOPY NUMBER,
432 x_msg_data OUT NOCOPY VARCHAR2,
433 p_chrv_rec IN chrv_rec_type,
434 x_chrv_rec OUT NOCOPY chrv_rec_type);
435
436
437 PROCEDURE update_contract_header(
438 p_api_version IN NUMBER,
439 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
440 x_return_status OUT NOCOPY VARCHAR2,
441 x_msg_count OUT NOCOPY NUMBER,
442 x_msg_data OUT NOCOPY VARCHAR2,
443 p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
444 p_chrv_rec IN chrv_rec_type,
445 x_chrv_rec OUT NOCOPY chrv_rec_type);
446
447
448 PROCEDURE delete_contract_header(
449 p_api_version IN NUMBER,
450 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
451 x_return_status OUT NOCOPY VARCHAR2,
452 x_msg_count OUT NOCOPY NUMBER,
453 x_msg_data OUT NOCOPY VARCHAR2,
454 p_chrv_rec IN chrv_rec_type);
455
456
457 PROCEDURE lock_contract_header(
458 p_api_version IN NUMBER,
459 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
460 x_return_status OUT NOCOPY VARCHAR2,
461 x_msg_count OUT NOCOPY NUMBER,
462 x_msg_data OUT NOCOPY VARCHAR2,
463 p_chrv_rec IN chrv_rec_type);
464
465
466 PROCEDURE validate_contract_header(
467 p_api_version IN NUMBER,
468 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
469 x_return_status OUT NOCOPY VARCHAR2,
470 x_msg_count OUT NOCOPY NUMBER,
471 x_msg_data OUT NOCOPY VARCHAR2,
472 p_chrv_rec IN chrv_rec_type);
473
474
475 PROCEDURE create_contract_line(
476 p_api_version IN NUMBER,
477 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
478 x_return_status OUT NOCOPY VARCHAR2,
479 x_msg_count OUT NOCOPY NUMBER,
480 x_msg_data OUT NOCOPY VARCHAR2,
481 p_restricted_update IN VARCHAR2 DEFAULT 'F',
482 p_clev_rec IN clev_rec_type,
483 x_clev_rec OUT NOCOPY clev_rec_type);
484
485 PROCEDURE create_contract_line(
486 p_api_version IN NUMBER,
487 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
488 x_return_status OUT NOCOPY VARCHAR2,
489 x_msg_count OUT NOCOPY NUMBER,
490 x_msg_data OUT NOCOPY VARCHAR2,
491 p_restricted_update IN VARCHAR2 DEFAULT 'F',
492 p_clev_tbl IN clev_tbl_type,
493 x_clev_tbl OUT NOCOPY clev_tbl_type);
494
495 PROCEDURE update_contract_line(
496 p_api_version IN NUMBER,
497 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
498 x_return_status OUT NOCOPY VARCHAR2,
499 x_msg_count OUT NOCOPY NUMBER,
500 x_msg_data OUT NOCOPY VARCHAR2,
501 p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
502 p_clev_rec IN clev_rec_type,
503 x_clev_rec OUT NOCOPY clev_rec_type);
504
505 PROCEDURE update_contract_line(
506 p_api_version IN NUMBER,
507 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
508 x_return_status OUT NOCOPY VARCHAR2,
509 x_msg_count OUT NOCOPY NUMBER,
510 x_msg_data OUT NOCOPY VARCHAR2,
511 p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
512 p_clev_tbl IN clev_tbl_type,
513 x_clev_tbl OUT NOCOPY clev_tbl_type);
514
515
516 PROCEDURE delete_contract_line(
517 p_api_version IN NUMBER,
518 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
519 x_return_status OUT NOCOPY VARCHAR2,
520 x_msg_count OUT NOCOPY NUMBER,
521 x_msg_data OUT NOCOPY VARCHAR2,
522 p_clev_rec IN clev_rec_type);
523
524 PROCEDURE delete_contract_line(
525 p_api_version IN NUMBER,
526 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
527 x_return_status OUT NOCOPY VARCHAR2,
528 x_msg_count OUT NOCOPY NUMBER,
529 x_msg_data OUT NOCOPY VARCHAR2,
530 p_clev_tbl IN clev_tbl_type);
531
532
533
534 PROCEDURE lock_contract_line(
535 p_api_version IN NUMBER,
536 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
537 x_return_status OUT NOCOPY VARCHAR2,
538 x_msg_count OUT NOCOPY NUMBER,
539 x_msg_data OUT NOCOPY VARCHAR2,
540 p_clev_rec IN clev_rec_type);
541
542
543 PROCEDURE validate_contract_line(
544 p_api_version IN NUMBER,
545 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
546 x_return_status OUT NOCOPY VARCHAR2,
547 x_msg_count OUT NOCOPY NUMBER,
548 x_msg_data OUT NOCOPY VARCHAR2,
549 p_clev_rec IN clev_rec_type);
550
551
552 PROCEDURE create_governance(
553 p_api_version IN NUMBER,
554 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
555 x_return_status OUT NOCOPY VARCHAR2,
556 x_msg_count OUT NOCOPY NUMBER,
557 x_msg_data OUT NOCOPY VARCHAR2,
558 p_gvev_rec IN gvev_rec_type,
559 x_gvev_rec OUT NOCOPY gvev_rec_type);
560
561
562 PROCEDURE update_governance(
563 p_api_version IN NUMBER,
564 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
565 x_return_status OUT NOCOPY VARCHAR2,
566 x_msg_count OUT NOCOPY NUMBER,
567 x_msg_data OUT NOCOPY VARCHAR2,
568 p_gvev_rec IN gvev_rec_type,
569 x_gvev_rec OUT NOCOPY gvev_rec_type);
570
571
572 PROCEDURE delete_governance(
573 p_api_version IN NUMBER,
574 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
575 x_return_status OUT NOCOPY VARCHAR2,
576 x_msg_count OUT NOCOPY NUMBER,
577 x_msg_data OUT NOCOPY VARCHAR2,
578 p_gvev_rec IN gvev_rec_type);
579
580
581 PROCEDURE lock_governance(
582 p_api_version IN NUMBER,
583 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
584 x_return_status OUT NOCOPY VARCHAR2,
585 x_msg_count OUT NOCOPY NUMBER,
586 x_msg_data OUT NOCOPY VARCHAR2,
587 p_gvev_rec IN gvev_rec_type);
588
589
590 PROCEDURE validate_governance(
591 p_api_version IN NUMBER,
592 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
593 x_return_status OUT NOCOPY VARCHAR2,
594 x_msg_count OUT NOCOPY NUMBER,
595 x_msg_data OUT NOCOPY VARCHAR2,
596 p_gvev_rec IN gvev_rec_type);
597
598
599
600 --end ashish
601 --------------------------------------------------------------------------------
602 --start badri
603
604 PROCEDURE version_contract(
605 p_api_version IN NUMBER,
606 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
607 x_return_status OUT NOCOPY VARCHAR2,
608 x_msg_count OUT NOCOPY NUMBER,
609 x_msg_data OUT NOCOPY VARCHAR2,
610 p_cvmv_rec IN cvmv_rec_type,
611 p_commit IN VARCHAR2 DEFAULT OKC_API.G_TRUE,
612 x_cvmv_rec OUT NOCOPY cvmv_rec_type);
613
614 PROCEDURE version_contract(
615 p_api_version IN NUMBER,
616 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
617 x_return_status OUT NOCOPY VARCHAR2,
618 x_msg_count OUT NOCOPY NUMBER,
619 x_msg_data OUT NOCOPY VARCHAR2,
620 p_cvmv_tbl IN cvmv_tbl_type,
621 p_commit IN VARCHAR2 DEFAULT OKC_API.G_TRUE,
622 x_cvmv_tbl OUT NOCOPY cvmv_tbl_type);
623 ---------------------------------------------------------------------------------------
624
625 procedure create_contract_item(p_api_version IN NUMBER,
626 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
627 x_return_status OUT NOCOPY VARCHAR2,
628 x_msg_count OUT NOCOPY NUMBER,
629 x_msg_data OUT NOCOPY VARCHAR2,
630 p_cimv_rec IN cimv_rec_type,
631 x_cimv_rec OUT NOCOPY cimv_rec_type);
632
633
634 procedure create_contract_item(p_api_version IN NUMBER,
635 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
636 x_return_status OUT NOCOPY VARCHAR2,
637 x_msg_count OUT NOCOPY NUMBER,
638 x_msg_data OUT NOCOPY VARCHAR2,
639 p_cimv_tbl IN cimv_tbl_type,
640 x_cimv_tbl OUT NOCOPY cimv_tbl_type);
641
642 PROCEDURE update_contract_item(
643 p_api_version IN NUMBER,
644 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
645 x_return_status OUT NOCOPY VARCHAR2,
646 x_msg_count OUT NOCOPY NUMBER,
647 x_msg_data OUT NOCOPY VARCHAR2,
648 p_cimv_rec IN cimv_rec_type,
649 x_cimv_rec OUT NOCOPY cimv_rec_type);
650
651 procedure update_contract_item(p_api_version IN NUMBER,
652 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
653 x_return_status OUT NOCOPY VARCHAR2,
654 x_msg_count OUT NOCOPY NUMBER,
655 x_msg_data OUT NOCOPY VARCHAR2,
656 p_cimv_tbl IN cimv_tbl_type,
657 x_cimv_tbl OUT NOCOPY cimv_tbl_type);
658
659
660 PROCEDURE delete_contract_item(
661 p_api_version IN NUMBER,
662 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
663 x_return_status OUT NOCOPY VARCHAR2,
664 x_msg_count OUT NOCOPY NUMBER,
665 x_msg_data OUT NOCOPY VARCHAR2,
666 p_cimv_rec IN cimv_rec_type);
667
668 procedure delete_contract_item(p_api_version IN NUMBER,
669 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
670 x_return_status OUT NOCOPY VARCHAR2,
671 x_msg_count OUT NOCOPY NUMBER,
672 x_msg_data OUT NOCOPY VARCHAR2,
673 p_cimv_tbl IN cimv_tbl_type);
674
675 PROCEDURE create_k_party_role(
676 p_api_version IN NUMBER,
677 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
678 x_return_status OUT NOCOPY VARCHAR2,
679 x_msg_count OUT NOCOPY NUMBER,
680 x_msg_data OUT NOCOPY VARCHAR2,
681 p_cplv_rec IN cplv_rec_type,
682 x_cplv_rec OUT NOCOPY cplv_rec_type);
683
684 PROCEDURE create_k_party_role(
685 p_api_version IN NUMBER,
686 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
687 x_return_status OUT NOCOPY VARCHAR2,
688 x_msg_count OUT NOCOPY NUMBER,
689 x_msg_data OUT NOCOPY VARCHAR2,
690 p_cplv_tbl IN cplv_tbl_type,
691 x_cplv_tbl OUT NOCOPY cplv_tbl_type);
692
693 PROCEDURE update_k_party_role(
694 p_api_version IN NUMBER,
695 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
696 x_return_status OUT NOCOPY VARCHAR2,
697 x_msg_count OUT NOCOPY NUMBER,
698 x_msg_data OUT NOCOPY VARCHAR2,
699 p_cplv_rec IN cplv_rec_type,
700 x_cplv_rec OUT NOCOPY cplv_rec_type);
701
702 PROCEDURE update_k_party_role(
703 p_api_version IN NUMBER,
704 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
705 x_return_status OUT NOCOPY VARCHAR2,
706 x_msg_count OUT NOCOPY NUMBER,
707 x_msg_data OUT NOCOPY VARCHAR2,
708 p_cplv_tbl IN cplv_tbl_type,
709 x_cplv_tbl OUT NOCOPY cplv_tbl_type);
710
711 PROCEDURE delete_k_party_role(
712 p_api_version IN NUMBER,
713 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
714 x_return_status OUT NOCOPY VARCHAR2,
715 x_msg_count OUT NOCOPY NUMBER,
716 x_msg_data OUT NOCOPY VARCHAR2,
717 p_cplv_rec IN cplv_rec_type);
718
719 PROCEDURE delete_k_party_role(
720 p_api_version IN NUMBER,
721 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
722 x_return_status OUT NOCOPY VARCHAR2,
723 x_msg_count OUT NOCOPY NUMBER,
724 x_msg_data OUT NOCOPY VARCHAR2,
725 p_cplv_tbl IN cplv_tbl_type);
726
727 PROCEDURE create_contact(
728 p_api_version IN NUMBER,
729 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
730 x_return_status OUT NOCOPY VARCHAR2,
731 x_msg_count OUT NOCOPY NUMBER,
732 x_msg_data OUT NOCOPY VARCHAR2,
733 p_ctcv_rec IN ctcv_rec_type,
734 x_ctcv_rec OUT NOCOPY ctcv_rec_type);
735
736 PROCEDURE create_contact(
737 p_api_version IN NUMBER,
738 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
739 x_return_status OUT NOCOPY VARCHAR2,
740 x_msg_count OUT NOCOPY NUMBER,
741 x_msg_data OUT NOCOPY VARCHAR2,
742 p_ctcv_tbl IN ctcv_tbl_type,
743 x_ctcv_tbl OUT NOCOPY ctcv_tbl_type);
744
745 PROCEDURE update_contact(
746 p_api_version IN NUMBER,
747 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
748 x_return_status OUT NOCOPY VARCHAR2,
749 x_msg_count OUT NOCOPY NUMBER,
750 x_msg_data OUT NOCOPY VARCHAR2,
751 p_ctcv_rec IN ctcv_rec_type,
752 x_ctcv_rec OUT NOCOPY ctcv_rec_type);
753
754 PROCEDURE update_contact(
755 p_api_version IN NUMBER,
756 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
757 x_return_status OUT NOCOPY VARCHAR2,
758 x_msg_count OUT NOCOPY NUMBER,
759 x_msg_data OUT NOCOPY VARCHAR2,
760 p_ctcv_tbl IN ctcv_tbl_type,
761 x_ctcv_tbl OUT NOCOPY ctcv_tbl_type);
762
763 PROCEDURE delete_contact(
764 p_api_version IN NUMBER,
765 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
766 x_return_status OUT NOCOPY VARCHAR2,
767 x_msg_count OUT NOCOPY NUMBER,
768 x_msg_data OUT NOCOPY VARCHAR2,
769 p_ctcv_rec IN ctcv_rec_type);
770
771 PROCEDURE delete_contact(
772 p_api_version IN NUMBER,
773 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
774 x_return_status OUT NOCOPY VARCHAR2,
775 x_msg_count OUT NOCOPY NUMBER,
776 x_msg_data OUT NOCOPY VARCHAR2,
777 p_ctcv_tbl IN ctcv_tbl_type);
778
779 --end badri
780 ------------------------------------------------------------------------------
781 --start cklee
782 PROCEDURE create_rule_group(
783 p_api_version IN NUMBER,
784 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
785 x_return_status OUT NOCOPY VARCHAR2,
786 x_msg_count OUT NOCOPY NUMBER,
787 x_msg_data OUT NOCOPY VARCHAR2,
788 p_rgpv_rec IN rgpv_rec_type,
789 x_rgpv_rec OUT NOCOPY rgpv_rec_type);
790
791 PROCEDURE update_rule_group(
792 p_api_version IN NUMBER,
793 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
794 x_return_status OUT NOCOPY VARCHAR2,
795 x_msg_count OUT NOCOPY NUMBER,
796 x_msg_data OUT NOCOPY VARCHAR2,
797 p_rgpv_rec IN rgpv_rec_type,
798 x_rgpv_rec OUT NOCOPY rgpv_rec_type);
799
800 PROCEDURE delete_rule_group(
801 p_api_version IN NUMBER,
802 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
803 x_return_status OUT NOCOPY VARCHAR2,
804 x_msg_count OUT NOCOPY NUMBER,
805 x_msg_data OUT NOCOPY VARCHAR2,
806 p_rgpv_rec IN rgpv_rec_type);
807
808 PROCEDURE lock_rule_group(
809 p_api_version IN NUMBER,
810 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
811 x_return_status OUT NOCOPY VARCHAR2,
812 x_msg_count OUT NOCOPY NUMBER,
813 x_msg_data OUT NOCOPY VARCHAR2,
814 p_rgpv_rec IN rgpv_rec_type);
815
816 PROCEDURE validate_rule_group(
817 p_api_version IN NUMBER,
818 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
819 x_return_status OUT NOCOPY VARCHAR2,
820 x_msg_count OUT NOCOPY NUMBER,
821 x_msg_data OUT NOCOPY VARCHAR2,
822 p_rgpv_rec IN rgpv_rec_type);
823
824
825 PROCEDURE create_rg_mode_pty_role(
826 p_api_version IN NUMBER,
827 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
828 x_return_status OUT NOCOPY VARCHAR2,
829 x_msg_count OUT NOCOPY NUMBER,
830 x_msg_data OUT NOCOPY VARCHAR2,
831 p_rmpv_rec IN rmpv_rec_type,
832 x_rmpv_rec OUT NOCOPY rmpv_rec_type);
833
834 PROCEDURE update_rg_mode_pty_role(
835 p_api_version IN NUMBER,
836 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
837 x_return_status OUT NOCOPY VARCHAR2,
838 x_msg_count OUT NOCOPY NUMBER,
839 x_msg_data OUT NOCOPY VARCHAR2,
840 p_rmpv_rec IN rmpv_rec_type,
841 x_rmpv_rec OUT NOCOPY rmpv_rec_type);
842
843 PROCEDURE delete_rg_mode_pty_role(
844 p_api_version IN NUMBER,
845 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
846 x_return_status OUT NOCOPY VARCHAR2,
847 x_msg_count OUT NOCOPY NUMBER,
848 x_msg_data OUT NOCOPY VARCHAR2,
849 p_rmpv_rec IN rmpv_rec_type);
850
851 PROCEDURE lock_rg_mode_pty_role(
852 p_api_version IN NUMBER,
853 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
854 x_return_status OUT NOCOPY VARCHAR2,
855 x_msg_count OUT NOCOPY NUMBER,
856 x_msg_data OUT NOCOPY VARCHAR2,
857 p_rmpv_rec IN rmpv_rec_type);
858
859 PROCEDURE validate_rg_mode_pty_role(
860 p_api_version IN NUMBER,
861 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
862 x_return_status OUT NOCOPY VARCHAR2,
863 x_msg_count OUT NOCOPY NUMBER,
864 x_msg_data OUT NOCOPY VARCHAR2,
865 p_rmpv_rec IN rmpv_rec_type);
866
867 --end cklee
868 END OKL_OKC_MIGRATION_PVT;