[Home] [Help]
PACKAGE: APPS.OKC_CLE_PVT
Source
4 -- GLOBAL DATASTRUCTURES
1 PACKAGE OKC_CLE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCSCLES.pls 120.8 2005/08/22 00:39:14 maanand noship $ */
3 ---------------------------------------------------------------------------
5 ---------------------------------------------------------------------------
6 TYPE cle_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 line_number OKC_K_LINES_B.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
9 chr_id NUMBER := OKC_API.G_MISS_NUM,
10 cle_id NUMBER := OKC_API.G_MISS_NUM,
11 cle_id_renewed NUMBER := OKC_API.G_MISS_NUM,
12 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
13 display_sequence NUMBER := OKC_API.G_MISS_NUM,
14 sts_code OKC_K_LINES_B.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
15 trn_code OKC_K_LINES_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
16 lse_id NUMBER := OKC_API.G_MISS_NUM,
17 exception_yn OKC_K_LINES_B.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
18 object_version_number NUMBER := OKC_API.G_MISS_NUM,
22 last_update_date OKC_K_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19 created_by NUMBER := OKC_API.G_MISS_NUM,
20 creation_date OKC_K_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
21 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
23 hidden_ind OKC_K_LINES_B.HIDDEN_IND%TYPE := OKC_API.G_MISS_CHAR,
24 price_unit NUMBER := OKC_API.G_MISS_NUM,
25 price_unit_percent NUMBER := OKC_API.G_MISS_NUM,
26 price_negotiated NUMBER := OKC_API.G_MISS_NUM,
27 price_level_ind OKC_K_LINES_B.PRICE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
28 invoice_line_level_ind OKC_K_LINES_B.INVOICE_LINE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
29 dpas_rating OKC_K_LINES_B.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
30 template_used OKC_K_LINES_B.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
31 price_type OKC_K_LINES_B.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
32 currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
33 last_update_login NUMBER := OKC_API.G_MISS_NUM,
34 date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
35 start_date OKC_K_LINES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
36 end_date OKC_K_LINES_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
37 date_renewed OKC_K_LINES_B.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
38 upg_orig_system_ref OKC_K_LINES_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
39 upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
40 orig_system_source_code OKC_K_LINES_B.ORIG_SYSTEM_SOURCE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
41 orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
42 orig_system_reference1 OKC_K_LINES_B.ORIG_SYSTEM_REFERENCE1%TYPE :=OKC_API.G_MISS_CHAR,
43 attribute_category OKC_K_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44 attribute1 OKC_K_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
45 attribute2 OKC_K_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
46 attribute3 OKC_K_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
47 attribute4 OKC_K_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
48 attribute5 OKC_K_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
49 attribute6 OKC_K_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
50 attribute7 OKC_K_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
51 attribute8 OKC_K_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
52 attribute9 OKC_K_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
53 attribute10 OKC_K_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
54 attribute11 OKC_K_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
55 attribute12 OKC_K_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
56 attribute13 OKC_K_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
57 attribute14 OKC_K_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
58 attribute15 OKC_K_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
59 cle_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
60 currency_code_renewed OKC_K_LINES_B.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
61 price_negotiated_renewed NUMBER := OKC_API.G_MISS_NUM,
62 request_id NUMBER := OKC_API.G_MISS_NUM,
63 program_application_id NUMBER := OKC_API.G_MISS_NUM,
64 program_id NUMBER := OKC_API.G_MISS_NUM,
65 program_update_date OKC_K_LINES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66 price_list_id NUMBER := OKC_API.G_MISS_NUM,
67 pricing_date OKC_K_LINES_B.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
68 price_list_line_id NUMBER := OKC_API.G_MISS_NUM,
69 line_list_price NUMBER := OKC_API.G_MISS_NUM,
70 item_to_price_yn OKC_K_LINES_B.ITEM_TO_PRICE_YN%TYPE := OKC_API.G_MISS_CHAR,
71 price_basis_yn OKC_K_LINES_B.PRICE_BASIS_YN%TYPE := OKC_API.G_MISS_CHAR,
72 config_header_id NUMBER := OKC_API.G_MISS_NUM,
73 config_revision_number NUMBER := OKC_API.G_MISS_NUM,
74 config_complete_yn OKC_K_LINES_B.CONFIG_COMPLETE_YN%TYPE := OKC_API.G_MISS_CHAR,
75 config_valid_yn OKC_K_LINES_B.CONFIG_VALID_YN%TYPE := OKC_API.G_MISS_CHAR,
76 config_top_model_line_id NUMBER := OKC_API.G_MISS_NUM,
77 config_item_type OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR,
78 CONFIG_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
79 service_item_yn OKC_K_LINES_B.SERVICE_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
80 --new columns for price hold
81 ph_pricing_type OKC_K_LINES_B.PH_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
82 ph_price_break_basis OKC_K_LINES_B.PH_PRICE_BREAK_BASIS%TYPE := OKC_API.G_MISS_CHAR,
83 ph_min_qty OKC_K_LINES_B.PH_MIN_QTY%TYPE := OKC_API.G_MISS_NUM,
84 ph_min_amt OKC_K_LINES_B.PH_MIN_AMT%TYPE := OKC_API.G_MISS_NUM,
85 ph_qp_reference_id OKC_K_LINES_B.PH_QP_REFERENCE_ID%TYPE := OKC_API.G_MISS_NUM,
86 ph_value OKC_K_LINES_B.PH_VALUE%TYPE := OKC_API.G_MISS_NUM,
87 ph_enforce_price_list_yn OKC_K_LINES_B.PH_ENFORCE_PRICE_LIST_YN%TYPE := OKC_API.G_MISS_CHAR,
88 ph_adjustment OKC_K_LINES_B.PH_ADJUSTMENT%TYPE := OKC_API.G_MISS_NUM,
89 ph_integrated_with_qp OKC_K_LINES_B.PH_INTEGRATED_WITH_QP%TYPE := OKC_API.G_MISS_CHAR,
90 --new columns to replace rules
91 cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
92 bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
93 inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
97 --NPALEPU on 03-JUN-2005 Added new column for Annualized amounts Project.
94 line_renewal_type_code OKC_K_LINES_B.LINE_RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
95 ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
96 payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
98 annualized_factor OKC_K_LINES_B.ANNUALIZED_FACTOR%TYPE := OKC_API.G_MISS_NUM,
99 -- Line level Cancellation --
100 date_cancelled OKC_K_LINES_B.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
101 --canc_reason_code OKC_K_LINES_B.CANC_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
102 term_cancel_source OKC_K_LINES_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
103 cancelled_amount OKC_K_LINES_B.CANCELLED_AMOUNT%TYPE := OKC_API.G_MISS_NUM,
104 payment_instruction_type OKC_K_LINES_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
105
106 );
107
108 g_miss_cle_rec cle_rec_type;
109 TYPE cle_tbl_type IS TABLE OF cle_rec_type
110 INDEX BY BINARY_INTEGER;
111
112 TYPE okc_k_lines_tl_rec_type IS RECORD (
113 id NUMBER := OKC_API.G_MISS_NUM,
114 language OKC_K_LINES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
115 source_lang OKC_K_LINES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
116 sfwt_flag OKC_K_LINES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
117 name OKC_K_LINES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
118 comments OKC_K_LINES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
119 item_description OKC_K_LINES_TL.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
120 oke_boe_description OKC_K_LINES_TL.OKE_BOE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
121 cognomen OKC_K_LINES_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
122 block23text OKC_K_LINES_TL.BLOCK23TEXT%TYPE := OKC_API.G_MISS_CHAR,
123 created_by NUMBER := OKC_API.G_MISS_NUM,
124 creation_date OKC_K_LINES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
125 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
126 last_update_date OKC_K_LINES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
127 last_update_login NUMBER := OKC_API.G_MISS_NUM);
128
129 g_miss_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
130 TYPE okc_k_lines_tl_tbl_type IS TABLE OF okc_k_lines_tl_rec_type
131 INDEX BY BINARY_INTEGER;
132
133 TYPE clev_rec_type IS RECORD (
134 id NUMBER := OKC_API.G_MISS_NUM,
135 object_version_number NUMBER := OKC_API.G_MISS_NUM,
136 sfwt_flag OKC_K_LINES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
137 chr_id NUMBER := OKC_API.G_MISS_NUM,
138 cle_id NUMBER := OKC_API.G_MISS_NUM,
139 cle_id_renewed NUMBER := OKC_API.G_MISS_NUM,
140 cle_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
141 lse_id NUMBER := OKC_API.G_MISS_NUM,
142 line_number OKC_K_LINES_V.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
143 sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
144 display_sequence NUMBER := OKC_API.G_MISS_NUM,
145 trn_code OKC_K_LINES_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
146 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
147 comments OKC_K_LINES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
148 item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
149 oke_boe_description OKC_K_LINES_V.OKE_BOE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
150 cognomen OKC_K_LINES_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
151 hidden_ind OKC_K_LINES_V.HIDDEN_IND%TYPE := OKC_API.G_MISS_CHAR,
152 price_unit NUMBER := OKC_API.G_MISS_NUM,
153 price_unit_percent NUMBER := OKC_API.G_MISS_NUM,
154 price_negotiated NUMBER := OKC_API.G_MISS_NUM,
155 price_negotiated_renewed NUMBER := OKC_API.G_MISS_NUM,
156 price_level_ind OKC_K_LINES_V.PRICE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
157 invoice_line_level_ind OKC_K_LINES_V.INVOICE_LINE_LEVEL_IND%TYPE := OKC_API.G_MISS_CHAR,
158 dpas_rating OKC_K_LINES_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
159 block23text OKC_K_LINES_V.BLOCK23TEXT%TYPE := OKC_API.G_MISS_CHAR,
160 exception_yn OKC_K_LINES_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
161 template_used OKC_K_LINES_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
162 date_terminated OKC_K_LINES_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
163 name OKC_K_LINES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
164 start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
165 end_date OKC_K_LINES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
166 date_renewed OKC_K_LINES_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
167 upg_orig_system_ref OKC_K_LINES_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
168 upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
169 orig_system_source_code OKC_K_LINES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
170 orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
171 orig_system_reference1 OKC_K_LINES_V.ORIG_SYSTEM_REFERENCE1%TYPE :=OKC_API.G_MISS_CHAR,
172 attribute_category OKC_K_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
173 attribute1 OKC_K_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
174 attribute2 OKC_K_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
175 attribute3 OKC_K_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
176 attribute4 OKC_K_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
180 attribute8 OKC_K_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
177 attribute5 OKC_K_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
178 attribute6 OKC_K_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
179 attribute7 OKC_K_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
181 attribute9 OKC_K_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
182 attribute10 OKC_K_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
183 attribute11 OKC_K_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
184 attribute12 OKC_K_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
185 attribute13 OKC_K_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
186 attribute14 OKC_K_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
187 attribute15 OKC_K_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
188 created_by NUMBER := OKC_API.G_MISS_NUM,
189 creation_date OKC_K_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
190 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
191 last_update_date OKC_K_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
192 price_type OKC_K_LINES_V.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
193 currency_code OKC_K_LINES_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
194 currency_code_renewed OKC_K_LINES_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
195 last_update_login NUMBER := OKC_API.G_MISS_NUM,
196 old_sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
197 new_sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
198 old_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
199 new_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
200 Call_Action_Asmblr VARCHAR2(1) := 'Y',
201 request_id NUMBER := OKC_API.G_MISS_NUM,
202 program_application_id NUMBER := OKC_API.G_MISS_NUM,
203 program_id NUMBER := OKC_API.G_MISS_NUM,
204 program_update_date OKC_K_LINES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
205 price_list_id NUMBER := OKC_API.G_MISS_NUM,
206 pricing_date OKC_K_LINES_V.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
207 price_list_line_id NUMBER := OKC_API.G_MISS_NUM,
208 line_list_price NUMBER := OKC_API.G_MISS_NUM,
209 item_to_price_yn OKC_K_LINES_V.ITEM_TO_PRICE_YN%TYPE := OKC_API.G_MISS_CHAR,
210 price_basis_yn OKC_K_LINES_V.PRICE_BASIS_YN%TYPE := OKC_API.G_MISS_CHAR,
211 config_header_id NUMBER := OKC_API.G_MISS_NUM,
212 config_revision_number NUMBER := OKC_API.G_MISS_NUM,
213 config_complete_yn OKC_K_LINES_V.CONFIG_COMPLETE_YN%TYPE := OKC_API.G_MISS_CHAR,
214 config_valid_yn OKC_K_LINES_V.CONFIG_VALID_YN%TYPE := OKC_API.G_MISS_CHAR,
215 config_top_model_line_id NUMBER := OKC_API.G_MISS_NUM,
216 config_item_type OKC_K_LINES_V.CONFIG_ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR,
217 CONFIG_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
218 service_item_yn OKC_K_LINES_V.SERVICE_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
219 --new columns for price hold
220 ph_pricing_type OKC_K_LINES_V.PH_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
221 ph_price_break_basis OKC_K_LINES_V.PH_PRICE_BREAK_BASIS%TYPE := OKC_API.G_MISS_CHAR,
222 ph_min_qty OKC_K_LINES_V.PH_MIN_QTY%TYPE := OKC_API.G_MISS_NUM,
223 ph_min_amt OKC_K_LINES_V.PH_MIN_AMT%TYPE := OKC_API.G_MISS_NUM,
224 ph_qp_reference_id OKC_K_LINES_V.PH_QP_REFERENCE_ID%TYPE := OKC_API.G_MISS_NUM,
225 ph_value OKC_K_LINES_V.PH_VALUE%TYPE := OKC_API.G_MISS_NUM,
226 ph_enforce_price_list_yn OKC_K_LINES_V.PH_ENFORCE_PRICE_LIST_YN%TYPE := OKC_API.G_MISS_CHAR,
227 ph_adjustment OKC_K_LINES_V.PH_ADJUSTMENT%TYPE := OKC_API.G_MISS_NUM,
228 ph_integrated_with_qp OKC_K_LINES_V.PH_INTEGRATED_WITH_QP%TYPE := OKC_API.G_MISS_CHAR,
229
230 --new columns to replace rules
231 cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
232 bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
233 inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
234 line_renewal_type_code OKC_K_LINES_V.LINE_RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
235 ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
236 payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
237 VALIDATE_YN VARCHAR2(1) DEFAULT 'Y', --Bug#3150149.
238 --- Line level Cancellation ---
239 date_cancelled OKC_K_LINES_V.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
240 --canc_reason_code OKC_K_LINES_V.CANC_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
241 term_cancel_source OKC_K_LINES_V.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
242 cancelled_amount OKC_K_LINES_V.CANCELLED_AMOUNT%TYPE := OKC_API.G_MISS_NUM,
243 --R12 changes added by mchoudha--
244 annualized_factor OKC_K_LINES_B.ANNUALIZED_FACTOR%TYPE := OKC_API.G_MISS_NUM,
245 payment_instruction_type OKC_K_LINES_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
246 );
247 g_miss_clev_rec clev_rec_type;
248 TYPE clev_tbl_type IS TABLE OF clev_rec_type
249 INDEX BY BINARY_INTEGER;
250 ---------------------------------------------------------------------------
251 -- GLOBAL MESSAGE CONSTANTS
252 ---------------------------------------------------------------------------
253 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
254 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
255 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
259 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
256 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
257 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
258 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
260 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
261 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
262 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
263 ---------------------------------------------------------------------------
264 -- GLOBAL VARIABLES
265 ---------------------------------------------------------------------------
266 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CLE_PVT';
267 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
268 ---------------------------------------------------------------------------
269 -- Procedures and Functions
270 ---------------------------------------------------------------------------
271
272 PROCEDURE qc;
273 PROCEDURE change_version;
274 PROCEDURE api_copy;
275 PROCEDURE add_language;
276 PROCEDURE insert_row(
277 p_api_version IN NUMBER,
278 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
279 x_return_status OUT NOCOPY VARCHAR2,
280 x_msg_count OUT NOCOPY NUMBER,
281 x_msg_data OUT NOCOPY VARCHAR2,
282 p_clev_rec IN clev_rec_type,
283 x_clev_rec OUT NOCOPY clev_rec_type);
284
285 PROCEDURE insert_row(
286 p_api_version IN NUMBER,
287 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
288 x_return_status OUT NOCOPY VARCHAR2,
289 x_msg_count OUT NOCOPY NUMBER,
290 x_msg_data OUT NOCOPY VARCHAR2,
291 p_clev_tbl IN clev_tbl_type,
292 x_clev_tbl OUT NOCOPY clev_tbl_type);
293
294 PROCEDURE lock_row(
295 p_api_version IN NUMBER,
296 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
297 x_return_status OUT NOCOPY VARCHAR2,
298 x_msg_count OUT NOCOPY NUMBER,
299 x_msg_data OUT NOCOPY VARCHAR2,
300 p_clev_rec IN clev_rec_type);
301
302 PROCEDURE lock_row(
303 p_api_version IN NUMBER,
304 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
305 x_return_status OUT NOCOPY VARCHAR2,
306 x_msg_count OUT NOCOPY NUMBER,
307 x_msg_data OUT NOCOPY VARCHAR2,
308 p_clev_tbl IN clev_tbl_type);
309
310 PROCEDURE update_row(
311 p_api_version IN NUMBER,
312 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
313 x_return_status OUT NOCOPY VARCHAR2,
314 x_msg_count OUT NOCOPY NUMBER,
315 x_msg_data OUT NOCOPY VARCHAR2,
316 p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
317 p_clev_rec IN clev_rec_type,
318 x_clev_rec OUT NOCOPY clev_rec_type);
319
320 PROCEDURE update_row(
321 p_api_version IN NUMBER,
322 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
323 x_return_status OUT NOCOPY VARCHAR2,
324 x_msg_count OUT NOCOPY NUMBER,
325 x_msg_data OUT NOCOPY VARCHAR2,
326 p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
327 p_clev_tbl IN clev_tbl_type,
328 x_clev_tbl OUT NOCOPY clev_tbl_type);
329
330 PROCEDURE delete_row(
331 p_api_version IN NUMBER,
332 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
333 x_return_status OUT NOCOPY VARCHAR2,
334 x_msg_count OUT NOCOPY NUMBER,
335 x_msg_data OUT NOCOPY VARCHAR2,
336 p_clev_rec IN clev_rec_type);
337
338 PROCEDURE delete_row(
339 p_api_version IN NUMBER,
340 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
341 x_return_status OUT NOCOPY VARCHAR2,
342 x_msg_count OUT NOCOPY NUMBER,
343 x_msg_data OUT NOCOPY VARCHAR2,
344 p_clev_tbl IN clev_tbl_type);
345
346 PROCEDURE force_delete_row(
347 p_api_version IN NUMBER,
348 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
349 x_return_status OUT NOCOPY VARCHAR2,
350 x_msg_count OUT NOCOPY NUMBER,
351 x_msg_data OUT NOCOPY VARCHAR2,
352 p_clev_tbl IN clev_tbl_type);
353
354 PROCEDURE validate_row(
355 p_api_version IN NUMBER,
356 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
357 x_return_status OUT NOCOPY VARCHAR2,
358 x_msg_count OUT NOCOPY NUMBER,
359 x_msg_data OUT NOCOPY VARCHAR2,
360 p_clev_rec IN clev_rec_type);
361
362 PROCEDURE validate_row(
363 p_api_version IN NUMBER,
364 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
365 x_return_status OUT NOCOPY VARCHAR2,
366 x_msg_count OUT NOCOPY NUMBER,
367 x_msg_data OUT NOCOPY VARCHAR2,
368 p_clev_tbl IN clev_tbl_type);
369
370 PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2, p_clev_tbl clev_tbl_type);
371
372 FUNCTION create_version(
373 p_chr_id IN NUMBER,
374 p_major_version IN NUMBER) RETURN VARCHAR2;
375
376 FUNCTION restore_version(
377 p_chr_id IN NUMBER,
378 p_major_version IN NUMBER) RETURN VARCHAR2;
379
380 END OKC_CLE_PVT;