[Home] [Help]
PACKAGE: APPS.OKS_CONTRACT_HDR_PUB
Source
1 PACKAGE oks_contract_hdr_pub AS
2 /* $Header: OKSPKHRS.pls 120.3 2005/08/04 16:05:36 anjkumar noship $ */
3 -- OKS_K_HEADERS_HV Record Spec
4 TYPE khrhv_rec_type IS RECORD (
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
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
47 , rev_est_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
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
83 , rmndr_sent_flag OKS_K_HEADERS_V.RMNDR_SENT_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 G_MISS_khrhv_rec khrhv_rec_type;
93 TYPE khrhv_tbl_type IS TABLE OF khrhv_rec_type
94 INDEX BY BINARY_INTEGER;
95
96 SUBTYPE khrv_rec_type IS oks_khr_pvt.khrv_rec_type;
97 SUBTYPE khrv_tbl_type IS oks_khr_pvt.khrv_tbl_type;
98 ---------------------------------------------------------------------------
99 -- GLOBAL VARIABLES
100 ---------------------------------------------------------------------------
101 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_HDR_PUB';
102 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
103 G_RET_STS_SUCCESS CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_SUCCESS;
104 G_RET_STS_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_ERROR;
105 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_UNEXP_ERROR;
106 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
107 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
108 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
109 G_FALSE CONSTANT VARCHAR2(10) := OKC_API.G_FALSE;
110 G_TRUE CONSTANT VARCHAR2(10) := OKC_API.G_TRUE;
111 ---------------------------------------------------------------------------
112
113 PROCEDURE create_header(
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2,
119 p_khrv_rec IN khrv_rec_type,
120 x_khrv_rec OUT NOCOPY khrv_rec_type,
121 p_validate_yn IN VARCHAR2);
122 PROCEDURE create_header(
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2,
128 p_khrv_tbl IN khrv_tbl_type,
129 x_khrv_tbl OUT NOCOPY khrv_tbl_type,
130 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
131 p_validate_yn IN VARCHAR2);
132 PROCEDURE create_header(
133 p_api_version IN NUMBER,
134 p_init_msg_list IN VARCHAR2,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2,
138 p_khrv_tbl IN khrv_tbl_type,
139 x_khrv_tbl OUT NOCOPY khrv_tbl_type,
140 p_validate_yn IN VARCHAR2);
141 PROCEDURE lock_header(
142 p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2,
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_count OUT NOCOPY NUMBER,
146 x_msg_data OUT NOCOPY VARCHAR2,
147 p_khrv_rec IN khrv_rec_type);
148 PROCEDURE lock_header(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154 p_khrv_tbl IN khrv_tbl_type,
155 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
156 PROCEDURE lock_header(
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_khrv_tbl IN khrv_tbl_type);
163 PROCEDURE update_header(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_khrv_rec IN khrv_rec_type,
170 x_khrv_rec OUT NOCOPY khrv_rec_type,
171 p_validate_yn IN VARCHAR2);
172 PROCEDURE update_header(
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 p_khrv_tbl IN khrv_tbl_type,
179 x_khrv_tbl OUT NOCOPY khrv_tbl_type,
180 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
181 p_validate_yn IN VARCHAR2);
182 PROCEDURE update_header(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 p_khrv_tbl IN khrv_tbl_type,
189 x_khrv_tbl OUT NOCOPY khrv_tbl_type,
190 p_validate_yn IN VARCHAR2);
191 PROCEDURE delete_header(
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 p_khrv_rec IN khrv_rec_type);
198 PROCEDURE delete_header(
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 p_khrv_tbl IN khrv_tbl_type,
205 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
206 PROCEDURE delete_header(
207 p_api_version IN NUMBER,
208 p_init_msg_list IN VARCHAR2,
209 x_return_status OUT NOCOPY VARCHAR2,
210 x_msg_count OUT NOCOPY NUMBER,
211 x_msg_data OUT NOCOPY VARCHAR2,
212 p_khrv_tbl IN khrv_tbl_type);
213 PROCEDURE validate_header(
214 p_api_version IN NUMBER,
215 p_init_msg_list IN VARCHAR2,
216 x_return_status OUT NOCOPY VARCHAR2,
217 x_msg_count OUT NOCOPY NUMBER,
218 x_msg_data OUT NOCOPY VARCHAR2,
219 p_khrv_rec IN khrv_rec_type);
220 PROCEDURE validate_header(
221 p_api_version IN NUMBER,
222 p_init_msg_list IN VARCHAR2,
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2,
226 p_khrv_tbl IN khrv_tbl_type,
227 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
228 PROCEDURE validate_header(
229 p_api_version IN NUMBER,
230 p_init_msg_list IN VARCHAR2,
231 x_return_status OUT NOCOPY VARCHAR2,
232 x_msg_count OUT NOCOPY NUMBER,
233 x_msg_data OUT NOCOPY VARCHAR2,
234 p_khrv_tbl IN khrv_tbl_type);
235 PROCEDURE create_version(
236 p_api_version IN NUMBER,
237 p_init_msg_list IN VARCHAR2,
238 x_return_status OUT NOCOPY VARCHAR2,
239 x_msg_count OUT NOCOPY NUMBER,
240 x_msg_data OUT NOCOPY VARCHAR2,
241 p_chr_id IN NUMBER);
242 PROCEDURE create_version(
243 p_chr_id IN NUMBER,
244 x_return_status OUT NOCOPY VARCHAR2);
245 PROCEDURE save_version(
246 p_api_version IN NUMBER,
247 p_init_msg_list IN VARCHAR2,
248 x_return_status OUT NOCOPY VARCHAR2,
249 x_msg_count OUT NOCOPY NUMBER,
250 x_msg_data OUT NOCOPY VARCHAR2,
251 p_chr_id IN NUMBER);
252 PROCEDURE delete_saved_version(
253 p_api_version IN NUMBER,
254 p_init_msg_list IN VARCHAR2,
255 x_return_status OUT NOCOPY VARCHAR2,
256 x_msg_count OUT NOCOPY NUMBER,
257 x_msg_data OUT NOCOPY VARCHAR2,
258 p_chr_id IN NUMBER);
259 PROCEDURE delete_saved_version(
260 p_chr_id IN NUMBER,
261 x_return_status OUT NOCOPY VARCHAR2);
262 PROCEDURE restore_version(
263 p_api_version IN NUMBER,
264 p_init_msg_list IN VARCHAR2,
265 x_return_status OUT NOCOPY VARCHAR2,
266 x_msg_count OUT NOCOPY NUMBER,
267 x_msg_data OUT NOCOPY VARCHAR2,
268 p_chr_id IN NUMBER);
269 PROCEDURE delete_history(
270 p_api_version IN NUMBER,
271 p_init_msg_list IN VARCHAR2,
272 x_return_status OUT NOCOPY VARCHAR2,
273 x_msg_count OUT NOCOPY NUMBER,
274 x_msg_data OUT NOCOPY VARCHAR2,
275 p_chr_id IN NUMBER);
276
277 PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,
278 p_khrv_tbl IN khrv_tbl_type);
279
280 PROCEDURE CREATE_HDR_VERSION_UPG(x_return_status OUT NOCOPY VARCHAR2,
281 p_khrhv_tbl IN khrhv_tbl_type );
282
283 END oks_contract_hdr_pub;
284