[Home] [Help]
PACKAGE: APPS.OKS_CONTRACT_HDR_PUB
Source
4 TYPE khrhv_rec_type IS RECORD (
1 PACKAGE oks_contract_hdr_pub AUTHID CURRENT_USER AS
2 /* $Header: OKSPKHRS.pls 120.3.12010000.2 2008/11/07 09:46:04 serukull ship $ */
3 -- OKS_K_HEADERS_HV Record Spec
5 id NUMBER := OKC_API.G_MISS_NUM
6 , major_version NUMBER := OKC_API.G_MISS_NUM
7 , chr_id NUMBER := OKC_API.G_MISS_NUM
8 , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
9 , payment_type OKS_K_HEADERS_V.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
10 , cc_no OKS_K_HEADERS_V.CC_NO%TYPE := OKC_API.G_MISS_CHAR
11 , cc_expiry_date OKS_K_HEADERS_V.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
12 , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
13 , cc_auth_code OKS_K_HEADERS_V.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
14 , commitment_id NUMBER := OKC_API.G_MISS_NUM
15 , grace_duration NUMBER := OKC_API.G_MISS_NUM
16 , grace_period OKS_K_HEADERS_V.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
17 , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
18 , est_rev_date OKS_K_HEADERS_V.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
19 , tax_amount NUMBER := OKC_API.G_MISS_NUM
20 , tax_status OKS_K_HEADERS_V.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
21 , tax_code NUMBER := OKC_API.G_MISS_NUM
22 , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
23 , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
24 , renewal_status OKS_K_HEADERS_V.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
25 , electronic_renewal_flag OKS_K_HEADERS_V.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
26 , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
27 , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
28 , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
29 , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
30 , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
31 , renewal_po_required OKS_K_HEADERS_V.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
32 , renewal_po_number OKS_K_HEADERS_V.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33 , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
34 , renewal_pricing_type OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
35 , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
36 , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
37 , renewal_grace_period OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
38 , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
39 , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
40 , renewal_est_rev_period OKS_K_HEADERS_V.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
41 , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
42 , renewal_type_used OKS_K_HEADERS_V.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
43 , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
47 , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
44 , renewal_po_used OKS_K_HEADERS_V.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
45 , renewal_pricing_type_used OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
46 , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
48 , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
49 , rev_est_period_used OKS_K_HEADERS_V.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
50 , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
51 , ern_flag_used_yn OKS_K_HEADERS_V.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
52 , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
53 , evn_threshold_cur OKS_K_HEADERS_V.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
54 , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
55 , ern_threshold_cur OKS_K_HEADERS_V.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
56 , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
57 , renewal_grace_period_used OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
58 , inv_trx_type OKS_K_HEADERS_V.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
59 , inv_print_profile OKS_K_HEADERS_V.inv_print_profile%TYPE := OKC_API.G_MISS_CHAR
60 , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
61 , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
62 , summary_trx_yn OKS_K_HEADERS_V.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
63 , service_po_number OKS_K_HEADERS_V.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
64 , service_po_required OKS_K_HEADERS_V.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
65 , billing_schedule_type OKS_K_HEADERS_V.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
66 , object_version_number NUMBER := OKC_API.G_MISS_NUM
67 , security_group_id NUMBER := OKC_API.G_MISS_NUM
68 , request_id NUMBER := OKC_API.G_MISS_NUM
69 , created_by NUMBER := OKC_API.G_MISS_NUM
70 , creation_date OKS_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
71 , last_updated_by NUMBER := OKC_API.G_MISS_NUM
72 , last_update_date OKS_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73 , last_update_login NUMBER := OKC_API.G_MISS_NUM
74 , period_type OKS_K_HEADERS_V.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
75 , period_start OKS_K_HEADERS_V.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
76 , price_uom OKS_K_HEADERS_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
77 , follow_up_action OKS_K_HEADERS_V.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
78 , follow_up_date OKS_K_HEADERS_V.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
79 , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
83 , rmndr_sent_flag OKS_K_HEADERS_V.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
80 , date_accepted OKS_K_HEADERS_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
81 , accepted_by NUMBER := OKC_API.G_MISS_NUM
82 , rmndr_suppress_flag OKS_K_HEADERS_V.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
84 , quote_sent_flag OKS_K_HEADERS_V.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
85 , process_request_id NUMBER := OKC_API.G_MISS_NUM
86 , wf_item_key OKS_K_HEADERS_V.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
87 , person_party_id NUMBER := OKC_API.G_MISS_NUM
88 , tax_classification_code OKS_K_HEADERS_V.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
89 , exempt_certificate_number OKS_K_HEADERS_V.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
90 , exempt_reason_code OKS_K_HEADERS_V.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
91 , approval_type_used OKS_K_HEADERS_V.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
92 , renewal_comment OKS_K_HEADERS_V.RENEWAL_COMMENT%TYPE := OKC_API.G_MISS_CHAR );
93 G_MISS_khrhv_rec khrhv_rec_type;
94 TYPE khrhv_tbl_type IS TABLE OF khrhv_rec_type
95 INDEX BY BINARY_INTEGER;
96
97 SUBTYPE khrv_rec_type IS oks_khr_pvt.khrv_rec_type;
98 SUBTYPE khrv_tbl_type IS oks_khr_pvt.khrv_tbl_type;
99 ---------------------------------------------------------------------------
100 -- GLOBAL VARIABLES
101 ---------------------------------------------------------------------------
102 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_HDR_PUB';
103 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
104 G_RET_STS_SUCCESS CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_SUCCESS;
105 G_RET_STS_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_ERROR;
106 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_UNEXP_ERROR;
107 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
108 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
109 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
110 G_FALSE CONSTANT VARCHAR2(10) := OKC_API.G_FALSE;
111 G_TRUE CONSTANT VARCHAR2(10) := OKC_API.G_TRUE;
112 ---------------------------------------------------------------------------
113
114 PROCEDURE create_header(
115 p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 p_khrv_rec IN khrv_rec_type,
121 x_khrv_rec OUT NOCOPY khrv_rec_type,
122 p_validate_yn IN VARCHAR2);
123 PROCEDURE create_header(
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 p_khrv_tbl IN khrv_tbl_type,
130 x_khrv_tbl OUT NOCOPY khrv_tbl_type,
131 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
132 p_validate_yn IN VARCHAR2);
133 PROCEDURE create_header(
134 p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2,
139 p_khrv_tbl IN khrv_tbl_type,
140 x_khrv_tbl OUT NOCOPY khrv_tbl_type,
141 p_validate_yn IN VARCHAR2);
142 PROCEDURE lock_header(
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 p_khrv_rec IN khrv_rec_type);
149 PROCEDURE lock_header(
150 p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155 p_khrv_tbl IN khrv_tbl_type,
156 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
157 PROCEDURE lock_header(
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2,
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163 p_khrv_tbl IN khrv_tbl_type);
164 PROCEDURE update_header(
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 p_khrv_rec IN khrv_rec_type,
171 x_khrv_rec OUT NOCOPY khrv_rec_type,
172 p_validate_yn IN VARCHAR2);
173 PROCEDURE update_header(
177 x_msg_count OUT NOCOPY NUMBER,
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2,
176 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 p_khrv_tbl IN khrv_tbl_type,
180 x_khrv_tbl OUT NOCOPY khrv_tbl_type,
181 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
182 p_validate_yn IN VARCHAR2);
183 PROCEDURE update_header(
184 p_api_version IN NUMBER,
185 p_init_msg_list IN VARCHAR2,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189 p_khrv_tbl IN khrv_tbl_type,
190 x_khrv_tbl OUT NOCOPY khrv_tbl_type,
191 p_validate_yn IN VARCHAR2);
192 PROCEDURE delete_header(
193 p_api_version IN NUMBER,
194 p_init_msg_list IN VARCHAR2,
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2,
198 p_khrv_rec IN khrv_rec_type);
199 PROCEDURE delete_header(
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_khrv_tbl IN khrv_tbl_type,
206 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
207 PROCEDURE delete_header(
208 p_api_version IN NUMBER,
209 p_init_msg_list IN VARCHAR2,
210 x_return_status OUT NOCOPY VARCHAR2,
211 x_msg_count OUT NOCOPY NUMBER,
212 x_msg_data OUT NOCOPY VARCHAR2,
213 p_khrv_tbl IN khrv_tbl_type);
214 PROCEDURE validate_header(
215 p_api_version IN NUMBER,
216 p_init_msg_list IN VARCHAR2,
217 x_return_status OUT NOCOPY VARCHAR2,
218 x_msg_count OUT NOCOPY NUMBER,
219 x_msg_data OUT NOCOPY VARCHAR2,
220 p_khrv_rec IN khrv_rec_type);
221 PROCEDURE validate_header(
222 p_api_version IN NUMBER,
223 p_init_msg_list IN VARCHAR2,
224 x_return_status OUT NOCOPY VARCHAR2,
225 x_msg_count OUT NOCOPY NUMBER,
226 x_msg_data OUT NOCOPY VARCHAR2,
227 p_khrv_tbl IN khrv_tbl_type,
228 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
229 PROCEDURE validate_header(
230 p_api_version IN NUMBER,
231 p_init_msg_list IN VARCHAR2,
232 x_return_status OUT NOCOPY VARCHAR2,
236 PROCEDURE create_version(
233 x_msg_count OUT NOCOPY NUMBER,
234 x_msg_data OUT NOCOPY VARCHAR2,
235 p_khrv_tbl IN khrv_tbl_type);
237 p_api_version IN NUMBER,
238 p_init_msg_list IN VARCHAR2,
239 x_return_status OUT NOCOPY VARCHAR2,
240 x_msg_count OUT NOCOPY NUMBER,
241 x_msg_data OUT NOCOPY VARCHAR2,
242 p_chr_id IN NUMBER);
243 PROCEDURE create_version(
244 p_chr_id IN NUMBER,
245 x_return_status OUT NOCOPY VARCHAR2);
246 PROCEDURE save_version(
247 p_api_version IN NUMBER,
248 p_init_msg_list IN VARCHAR2,
249 x_return_status OUT NOCOPY VARCHAR2,
250 x_msg_count OUT NOCOPY NUMBER,
251 x_msg_data OUT NOCOPY VARCHAR2,
252 p_chr_id IN NUMBER);
253 PROCEDURE delete_saved_version(
254 p_api_version IN NUMBER,
255 p_init_msg_list IN VARCHAR2,
256 x_return_status OUT NOCOPY VARCHAR2,
257 x_msg_count OUT NOCOPY NUMBER,
258 x_msg_data OUT NOCOPY VARCHAR2,
259 p_chr_id IN NUMBER);
260 PROCEDURE delete_saved_version(
261 p_chr_id IN NUMBER,
262 x_return_status OUT NOCOPY VARCHAR2);
263 PROCEDURE restore_version(
264 p_api_version IN NUMBER,
265 p_init_msg_list IN VARCHAR2,
266 x_return_status OUT NOCOPY VARCHAR2,
267 x_msg_count OUT NOCOPY NUMBER,
268 x_msg_data OUT NOCOPY VARCHAR2,
269 p_chr_id IN NUMBER);
270 PROCEDURE delete_history(
271 p_api_version IN NUMBER,
272 p_init_msg_list IN VARCHAR2,
273 x_return_status OUT NOCOPY VARCHAR2,
274 x_msg_count OUT NOCOPY NUMBER,
275 x_msg_data OUT NOCOPY VARCHAR2,
276 p_chr_id IN NUMBER);
277
278 PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,
279 p_khrv_tbl IN khrv_tbl_type);
280
281 PROCEDURE CREATE_HDR_VERSION_UPG(x_return_status OUT NOCOPY VARCHAR2,
282 p_khrhv_tbl IN khrhv_tbl_type );
283
284 END oks_contract_hdr_pub;
285