[Home] [Help]
PACKAGE: APPS.OKC_CHR_PVT
Source
1 Package OKC_CHR_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCSCHRS.pls 120.5 2007/09/07 10:08:06 vmutyala ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE chr_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
9 authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
10 -- org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
11 contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
12 chr_id_response NUMBER := OKC_API.G_MISS_NUM,
13 chr_id_award NUMBER := OKC_API.G_MISS_NUM,
14 chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
15 INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
16 sts_code OKC_K_HEADERS_B.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
17 qcl_id NUMBER := OKC_API.G_MISS_NUM,
18 scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
19 trn_code OKC_K_HEADERS_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
20 currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
21 archived_yn OKC_K_HEADERS_B.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
22 deleted_yn OKC_K_HEADERS_B.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
23 template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
24 chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25 object_version_number NUMBER := OKC_API.G_MISS_NUM,
26 created_by NUMBER := OKC_API.G_MISS_NUM,
27 creation_date OKC_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29 last_update_date OKC_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30 cust_po_number_req_yn OKC_K_HEADERS_B.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
31 pre_pay_req_yn OKC_K_HEADERS_B.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
32 cust_po_number OKC_K_HEADERS_B.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
33 dpas_rating OKC_K_HEADERS_B.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
34 template_used OKC_K_HEADERS_B.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
35 date_approved OKC_K_HEADERS_B.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
36 datetime_cancelled OKC_K_HEADERS_B.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
37 auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
38 date_issued OKC_K_HEADERS_B.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
39 datetime_responded OKC_K_HEADERS_B.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
40 rfp_type OKC_K_HEADERS_B.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
41 keep_on_mail_list OKC_K_HEADERS_B.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
42 set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
43 response_copies_req NUMBER := OKC_API.G_MISS_NUM,
44 date_close_projected OKC_K_HEADERS_B.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
45 datetime_proposed OKC_K_HEADERS_B.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
46 date_signed OKC_K_HEADERS_B.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
47 date_terminated OKC_K_HEADERS_B.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
48 date_renewed OKC_K_HEADERS_B.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
49 start_date OKC_K_HEADERS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
50 end_date OKC_K_HEADERS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
51 buy_or_sell OKC_K_HEADERS_B.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
52 issue_or_receive OKC_K_HEADERS_B.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
53 estimated_amount NUMBER := OKC_API.G_MISS_NUM,
54 chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
55 estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
56 currency_code_renewed OKC_K_HEADERS_B.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
57 last_update_login NUMBER := OKC_API.G_MISS_NUM,
58 upg_orig_system_ref OKC_K_HEADERS_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
59 upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
60 application_id NUMBER := OKC_API.G_MISS_NUM,
61 orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
62 orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
63 orig_system_reference1 OKC_K_HEADERS_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
64 program_id NUMBER := OKC_API.G_MISS_NUM,
65 request_id NUMBER := OKC_API.G_MISS_NUM,
66 price_list_id NUMBER := OKC_API.G_MISS_NUM,
67 pricing_date OKC_K_HEADERS_B.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
68 sign_by_date OKC_K_HEADERS_B.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
69 program_update_date OKC_K_HEADERS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
70 total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
71 program_application_id NUMBER := OKC_API.G_MISS_NUM,
72 USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
73 GOVERNING_CONTRACT_YN OKC_K_HEADERS_B.GOVERNING_CONTRACT_YN%TYPE := OKC_API.G_MISS_CHAR,
74 attribute_category OKC_K_HEADERS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
75 attribute1 OKC_K_HEADERS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
76 attribute2 OKC_K_HEADERS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
77 attribute3 OKC_K_HEADERS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
78 attribute4 OKC_K_HEADERS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
79 attribute5 OKC_K_HEADERS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
80 attribute6 OKC_K_HEADERS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
81 attribute7 OKC_K_HEADERS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
82 attribute8 OKC_K_HEADERS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
83 attribute9 OKC_K_HEADERS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
84 attribute10 OKC_K_HEADERS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
85 attribute11 OKC_K_HEADERS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
86 attribute12 OKC_K_HEADERS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
87 attribute13 OKC_K_HEADERS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
88 attribute14 OKC_K_HEADERS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
89 attribute15 OKC_K_HEADERS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
90 --new columns to replace rules
91 conversion_type OKC_K_HEADERS_B.CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
92 conversion_rate NUMBER := OKC_API.G_MISS_NUM,
93 conversion_rate_date OKC_K_HEADERS_B.CONVERSION_RATE_DATE%TYPE := OKC_API.G_MISS_DATE,
94 conversion_euro_rate NUMBER := OKC_API.G_MISS_NUM,
95 cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
96 bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
97 inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
98 renewal_type_code OKC_K_HEADERS_B.RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
99 renewal_notify_to NUMBER :=OKC_API.G_MISS_NUM,
100 renewal_end_date OKC_K_HEADERS_B.RENEWAL_END_DATE%TYPE :=OKC_API.G_MISS_DATE,
101 ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
102 payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
103 document_id NUMBER :=OKC_API.G_MISS_NUM,
104 -- R12 Data Model Changes 4485150 start
105 approval_type OKC_K_HEADERS_B.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
106 term_cancel_source OKC_K_HEADERS_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
107 payment_instruction_type OKC_K_HEADERS_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
108 org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
109 -- R12 Data Model Changes 4485150 End
110 cancelled_amount NUMBER := OKC_API.G_MISS_NUM, -- LLC
111 billed_at_source OKC_K_HEADERS_ALL_B.BILLED_AT_SOURCE%TYPE
112 );
113 g_miss_chr_rec chr_rec_type;
114 TYPE chr_tbl_type IS TABLE OF chr_rec_type
115 INDEX BY BINARY_INTEGER;
116
117 TYPE okc_k_headers_tl_rec_type IS RECORD (
118 id NUMBER := OKC_API.G_MISS_NUM,
119 language OKC_K_HEADERS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
120 source_lang OKC_K_HEADERS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
121 sfwt_flag OKC_K_HEADERS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
122 short_description OKC_K_HEADERS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
123 comments OKC_K_HEADERS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
124 description OKC_K_HEADERS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
125 cognomen OKC_K_HEADERS_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
126 non_response_reason OKC_K_HEADERS_TL.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
127 non_response_explain OKC_K_HEADERS_TL.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
128 set_aside_reason OKC_K_HEADERS_TL.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
129 created_by NUMBER := OKC_API.G_MISS_NUM,
130 creation_date OKC_K_HEADERS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
131 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
132 last_update_date OKC_K_HEADERS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
133 last_update_login NUMBER := OKC_API.G_MISS_NUM);
134 g_miss_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
135 TYPE okc_k_headers_tl_tbl_type IS TABLE OF okc_k_headers_tl_rec_type
136 INDEX BY BINARY_INTEGER;
137
138 TYPE chrv_rec_type IS RECORD (
139 id NUMBER := OKC_API.G_MISS_NUM,
140 object_version_number NUMBER := OKC_API.G_MISS_NUM,
141 sfwt_flag OKC_K_HEADERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
142 chr_id_response NUMBER := OKC_API.G_MISS_NUM,
143 chr_id_award NUMBER := OKC_API.G_MISS_NUM,
144 chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
145 INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
146 sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
147 qcl_id NUMBER := OKC_API.G_MISS_NUM,
148 scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
149 contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
150 currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
151 contract_number_modifier OKC_K_HEADERS_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
152 archived_yn OKC_K_HEADERS_V.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
153 deleted_yn OKC_K_HEADERS_V.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
154 cust_po_number_req_yn OKC_K_HEADERS_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
155 pre_pay_req_yn OKC_K_HEADERS_V.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
156 cust_po_number OKC_K_HEADERS_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
157 short_description OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
158 comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
159 description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
160 dpas_rating OKC_K_HEADERS_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
161 cognomen OKC_K_HEADERS_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
162 template_yn OKC_K_HEADERS_V.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
163 template_used OKC_K_HEADERS_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
164 date_approved OKC_K_HEADERS_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
165 datetime_cancelled OKC_K_HEADERS_V.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
166 auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
167 date_issued OKC_K_HEADERS_V.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
168 datetime_responded OKC_K_HEADERS_V.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
169 non_response_reason OKC_K_HEADERS_V.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
170 non_response_explain OKC_K_HEADERS_V.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
171 rfp_type OKC_K_HEADERS_V.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
172 chr_type OKC_K_HEADERS_V.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
173 keep_on_mail_list OKC_K_HEADERS_V.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
174 set_aside_reason OKC_K_HEADERS_V.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
175 set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
176 response_copies_req NUMBER := OKC_API.G_MISS_NUM,
177 date_close_projected OKC_K_HEADERS_V.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
178 datetime_proposed OKC_K_HEADERS_V.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
179 date_signed OKC_K_HEADERS_V.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
180 date_terminated OKC_K_HEADERS_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
181 date_renewed OKC_K_HEADERS_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
182 trn_code OKC_K_HEADERS_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
183 start_date OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
184 end_date OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
185 authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
186 -- org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
187 buy_or_sell OKC_K_HEADERS_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
188 issue_or_receive OKC_K_HEADERS_V.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
189 estimated_amount NUMBER := OKC_API.G_MISS_NUM,
190 chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
191 estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
192 currency_code_renewed OKC_K_HEADERS_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
193 upg_orig_system_ref OKC_K_HEADERS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
194 upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
195 application_id NUMBER := OKC_API.G_MISS_NUM,
196 orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
197 orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
198 orig_system_reference1 OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
199 program_id NUMBER := OKC_API.G_MISS_NUM,
200 request_id NUMBER := OKC_API.G_MISS_NUM,
201 price_list_id NUMBER := OKC_API.G_MISS_NUM,
202 pricing_date OKC_K_HEADERS_V.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
203 sign_by_date OKC_K_HEADERS_V.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
204 program_update_date OKC_K_HEADERS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
205 total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
206 program_application_id NUMBER := OKC_API.G_MISS_NUM,
207 USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
208 GOVERNING_CONTRACT_YN OKC_K_HEADERS_V.GOVERNING_CONTRACT_YN%TYPE := OKC_API.G_MISS_CHAR,
209 attribute_category OKC_K_HEADERS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
210 attribute1 OKC_K_HEADERS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
211 attribute2 OKC_K_HEADERS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
212 attribute3 OKC_K_HEADERS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
213 attribute4 OKC_K_HEADERS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
214 attribute5 OKC_K_HEADERS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
215 attribute6 OKC_K_HEADERS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
216 attribute7 OKC_K_HEADERS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
217 attribute8 OKC_K_HEADERS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
218 attribute9 OKC_K_HEADERS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
219 attribute10 OKC_K_HEADERS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
220 attribute11 OKC_K_HEADERS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
221 attribute12 OKC_K_HEADERS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
222 attribute13 OKC_K_HEADERS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
223 attribute14 OKC_K_HEADERS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
224 attribute15 OKC_K_HEADERS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
225 created_by NUMBER := OKC_API.G_MISS_NUM,
226 creation_date OKC_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
227 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
228 last_update_date OKC_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
229 last_update_login NUMBER := OKC_API.G_MISS_NUM,
230 old_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
231 new_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
232 old_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
233 new_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR ,
234 --new columns to replace rules
235 conversion_type OKC_K_HEADERS_V.CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
236 conversion_rate NUMBER := OKC_API.G_MISS_NUM,
237 conversion_rate_date OKC_K_HEADERS_V.CONVERSION_RATE_DATE%TYPE := OKC_API.G_MISS_DATE,
238 conversion_euro_rate NUMBER := OKC_API.G_MISS_NUM,
239 cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
240 bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
241 inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
242 renewal_type_code OKC_K_HEADERS_V.RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
243 renewal_notify_to NUMBER :=OKC_API.G_MISS_NUM,
244 renewal_end_date OKC_K_HEADERS_V.RENEWAL_END_DATE%TYPE :=OKC_API.G_MISS_DATE,
245 ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
246 payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
247 VALIDATE_YN VARCHAR2(1) DEFAULT 'Y', --Bug#3150149.
248 document_id NUMBER :=OKC_API.G_MISS_NUM,
249 -- R12 Data Model Changes 4485150 Start
250 approval_type OKC_K_HEADERS_B.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
251 term_cancel_source OKC_K_HEADERS_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
252 payment_instruction_type OKC_K_HEADERS_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
253 org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
254 -- R12 Data Model Changes 4485150 End
255 cancelled_amount NUMBER := OKC_API.G_MISS_NUM, -- LLC
256 billed_at_source OKC_K_HEADERS_ALL_V.BILLED_AT_SOURCE%TYPE
257 );
258 g_miss_chrv_rec chrv_rec_type;
259 TYPE chrv_tbl_type IS TABLE OF chrv_rec_type
260 INDEX BY BINARY_INTEGER;
261 ---------------------------------------------------------------------------
262 -- GLOBAL MESSAGE CONSTANTS
263 ---------------------------------------------------------------------------
264 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
265 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
266 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
267 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
268 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
269 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
270 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
271 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
272 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
273 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
274 ---------------------------------------------------------------------------
275 -- GLOBAL VARIABLES
276 ---------------------------------------------------------------------------
277 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CHR_PVT';
278 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
279 ---------------------------------------------------------------------------
280 -- Procedures and Functions
281 ---------------------------------------------------------------------------
282
283 PROCEDURE qc;
284 PROCEDURE change_version;
285 PROCEDURE api_copy;
286 PROCEDURE add_language;
287 PROCEDURE insert_row(
288 p_api_version IN NUMBER,
289 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
290 x_return_status OUT NOCOPY VARCHAR2,
291 x_msg_count OUT NOCOPY NUMBER,
292 x_msg_data OUT NOCOPY VARCHAR2,
293 p_chrv_rec IN chrv_rec_type,
294 x_chrv_rec OUT NOCOPY chrv_rec_type);
295
296 PROCEDURE insert_row(
297 p_api_version IN NUMBER,
298 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
299 x_return_status OUT NOCOPY VARCHAR2,
300 x_msg_count OUT NOCOPY NUMBER,
301 x_msg_data OUT NOCOPY VARCHAR2,
302 p_chrv_tbl IN chrv_tbl_type,
303 x_chrv_tbl OUT NOCOPY chrv_tbl_type);
304
305 PROCEDURE lock_row(
306 p_api_version IN NUMBER,
307 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
308 x_return_status OUT NOCOPY VARCHAR2,
309 x_msg_count OUT NOCOPY NUMBER,
310 x_msg_data OUT NOCOPY VARCHAR2,
311 p_chrv_rec IN chrv_rec_type);
312
313 PROCEDURE lock_row(
314 p_api_version IN NUMBER,
315 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
316 x_return_status OUT NOCOPY VARCHAR2,
317 x_msg_count OUT NOCOPY NUMBER,
318 x_msg_data OUT NOCOPY VARCHAR2,
319 p_chrv_tbl IN chrv_tbl_type);
320
321 PROCEDURE update_row(
322 p_api_version IN NUMBER,
323 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
324 x_return_status OUT NOCOPY VARCHAR2,
325 x_msg_count OUT NOCOPY NUMBER,
326 x_msg_data OUT NOCOPY VARCHAR2,
327 p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
328 p_chrv_rec IN chrv_rec_type,
329 x_chrv_rec OUT NOCOPY chrv_rec_type);
330
331 PROCEDURE update_row(
332 p_api_version IN NUMBER,
333 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
334 x_return_status OUT NOCOPY VARCHAR2,
335 x_msg_count OUT NOCOPY NUMBER,
336 x_msg_data OUT NOCOPY VARCHAR2,
337 p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
338 p_chrv_tbl IN chrv_tbl_type,
339 x_chrv_tbl OUT NOCOPY chrv_tbl_type);
340
341 PROCEDURE delete_row(
342 p_api_version IN NUMBER,
343 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
344 x_return_status OUT NOCOPY VARCHAR2,
345 x_msg_count OUT NOCOPY NUMBER,
346 x_msg_data OUT NOCOPY VARCHAR2,
347 p_chrv_rec IN chrv_rec_type);
348
349 PROCEDURE delete_row(
350 p_api_version IN NUMBER,
351 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
352 x_return_status OUT NOCOPY VARCHAR2,
353 x_msg_count OUT NOCOPY NUMBER,
354 x_msg_data OUT NOCOPY VARCHAR2,
355 p_chrv_tbl IN chrv_tbl_type);
356
357 PROCEDURE validate_row(
358 p_api_version IN NUMBER,
359 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
360 x_return_status OUT NOCOPY VARCHAR2,
361 x_msg_count OUT NOCOPY NUMBER,
362 x_msg_data OUT NOCOPY VARCHAR2,
363 p_chrv_rec IN chrv_rec_type);
364
365 PROCEDURE validate_row(
366 p_api_version IN NUMBER,
367 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
368 x_return_status OUT NOCOPY VARCHAR2,
369 x_msg_count OUT NOCOPY NUMBER,
370 x_msg_data OUT NOCOPY VARCHAR2,
371 p_chrv_tbl IN chrv_tbl_type);
372
373 PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2, p_chrv_tbl chrv_tbl_type);
374
375 FUNCTION create_version(
376 p_chr_id IN NUMBER,
377 p_major_version IN NUMBER) RETURN VARCHAR2;
378
379 FUNCTION restore_version(
380 p_chr_id IN NUMBER,
381 p_major_version IN NUMBER) RETURN VARCHAR2;
382
383 -- function to check uninue contract_number + modifier
384 FUNCTION IS_UNIQUE (p_chrv_rec chrv_rec_type) RETURN VARCHAR2;
385
386 END OKC_CHR_PVT;