[Home] [Help]
PACKAGE: APPS.OKS_CONTRACT_LINE_PUB
Source
1 PACKAGE oks_contract_line_pub AS
2 /* $Header: OKSPKLNS.pls 120.1 2005/07/15 09:22:59 parkumar noship $ */
3 -- OKS_K_LINES_HV Record Spec
4 TYPE klnhv_rec_type IS RECORD (
5 id NUMBER := OKC_API.G_MISS_NUM
6 ,major_version NUMBER := OKC_API.G_MISS_NUM
7 ,cle_id NUMBER := OKC_API.G_MISS_NUM
8 ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
9 ,discount_list NUMBER := OKC_API.G_MISS_NUM
10 ,acct_rule_id NUMBER := OKC_API.G_MISS_NUM
11 ,payment_type OKS_K_LINES_V.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
12 ,cc_no OKS_K_LINES_V.CC_NO%TYPE := OKC_API.G_MISS_CHAR
13 ,cc_expiry_date OKS_K_LINES_V.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
14 ,cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
15 ,cc_auth_code OKS_K_LINES_V.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
16 ,commitment_id NUMBER := OKC_API.G_MISS_NUM
17 ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
18 ,usage_est_yn OKS_K_LINES_V.USAGE_EST_YN%TYPE := OKC_API.G_MISS_CHAR
19 ,usage_est_method OKS_K_LINES_V.USAGE_EST_METHOD%TYPE := OKC_API.G_MISS_CHAR
20 ,usage_est_start_date OKS_K_LINES_V.USAGE_EST_START_DATE%TYPE := OKC_API.G_MISS_DATE
21 ,termn_method OKS_K_LINES_V.TERMN_METHOD%TYPE := OKC_API.G_MISS_CHAR
22 ,ubt_amount NUMBER := OKC_API.G_MISS_NUM
23 ,credit_amount NUMBER := OKC_API.G_MISS_NUM
24 ,suppressed_credit NUMBER := OKC_API.G_MISS_NUM
25 ,override_amount NUMBER := OKC_API.G_MISS_NUM
26 ,cust_po_number_req_yn OKS_K_LINES_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
27 ,cust_po_number OKS_K_LINES_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
28 ,grace_duration NUMBER := OKC_API.G_MISS_NUM
29 ,grace_period OKS_K_LINES_V.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
30 ,inv_print_flag OKS_K_LINES_V.INV_PRINT_FLAG%TYPE := OKC_API.G_MISS_CHAR
31 ,price_uom OKS_K_LINES_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
32 ,tax_amount NUMBER := OKC_API.G_MISS_NUM
33 ,tax_inclusive_yn OKS_K_LINES_V.TAX_INCLUSIVE_YN%TYPE := OKC_API.G_MISS_CHAR
34 ,tax_status OKS_K_LINES_V.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
35 ,tax_code NUMBER := OKC_API.G_MISS_NUM
36 ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
37 ,ib_trans_type OKS_K_LINES_V.IB_TRANS_TYPE%TYPE := OKC_API.G_MISS_CHAR
38 ,ib_trans_date OKS_K_LINES_V.IB_TRANS_DATE%TYPE := OKC_API.G_MISS_DATE
39 ,prod_price NUMBER := OKC_API.G_MISS_NUM
40 ,service_price NUMBER := OKC_API.G_MISS_NUM
41 ,clvl_list_price NUMBER := OKC_API.G_MISS_NUM
42 ,clvl_quantity NUMBER := OKC_API.G_MISS_NUM
43 ,clvl_extended_amt NUMBER := OKC_API.G_MISS_NUM
44 ,clvl_uom_code OKS_K_LINES_V.CLVL_UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
45 ,toplvl_operand_code OKS_K_LINES_V.TOPLVL_OPERAND_CODE%TYPE := OKC_API.G_MISS_CHAR
46 ,toplvl_operand_val NUMBER := OKC_API.G_MISS_NUM
47 ,toplvl_quantity NUMBER := OKC_API.G_MISS_NUM
48 ,toplvl_uom_code OKS_K_LINES_V.TOPLVL_UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
49 ,toplvl_adj_price NUMBER := OKC_API.G_MISS_NUM
50 ,toplvl_price_qty NUMBER := OKC_API.G_MISS_NUM
51 ,averaging_interval NUMBER := OKC_API.G_MISS_NUM
52 ,settlement_interval OKS_K_LINES_V.SETTLEMENT_INTERVAL%TYPE := OKC_API.G_MISS_CHAR
53 ,minimum_quantity NUMBER := OKC_API.G_MISS_NUM
54 ,default_quantity NUMBER := OKC_API.G_MISS_NUM
55 ,amcv_flag OKS_K_LINES_V.AMCV_FLAG%TYPE := OKC_API.G_MISS_CHAR
56 ,fixed_quantity NUMBER := OKC_API.G_MISS_NUM
57 ,usage_duration NUMBER := OKC_API.G_MISS_NUM
58 ,usage_period OKS_K_LINES_V.USAGE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
59 ,level_yn OKS_K_LINES_V.LEVEL_YN%TYPE := OKC_API.G_MISS_CHAR
60 ,usage_type OKS_K_LINES_V.USAGE_TYPE%TYPE := OKC_API.G_MISS_CHAR
61 ,uom_quantified OKS_K_LINES_V.UOM_QUANTIFIED%TYPE := OKC_API.G_MISS_CHAR
62 ,base_reading NUMBER := OKC_API.G_MISS_NUM
63 ,billing_schedule_type OKS_K_LINES_V.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
64 ,full_credit OKS_K_LINES_V.FULL_CREDIT%TYPE := OKC_API.G_MISS_CHAR
65 ,coverage_type OKS_K_LINES_V.COVERAGE_TYPE%TYPE := OKC_API.G_MISS_CHAR
66 ,exception_cov_id NUMBER := OKC_API.G_MISS_NUM
67 ,limit_uom_quantified OKS_K_LINES_V.LIMIT_UOM_QUANTIFIED%TYPE := OKC_API.G_MISS_CHAR
68 ,discount_amount NUMBER := OKC_API.G_MISS_NUM
69 ,discount_percent NUMBER := OKC_API.G_MISS_NUM
70 ,offset_duration NUMBER := OKC_API.G_MISS_NUM
71 ,offset_period OKS_K_LINES_V.OFFSET_PERIOD%TYPE := OKC_API.G_MISS_CHAR
72 ,incident_severity_id NUMBER := OKC_API.G_MISS_NUM
73 ,pdf_id NUMBER := OKC_API.G_MISS_NUM
74 ,work_thru_yn OKS_K_LINES_V.WORK_THRU_YN%TYPE := OKC_API.G_MISS_CHAR
75 ,react_active_yn OKS_K_LINES_V.REACT_ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR
76 ,transfer_option OKS_K_LINES_V.TRANSFER_OPTION%TYPE := OKC_API.G_MISS_CHAR
77 ,prod_upgrade_yn OKS_K_LINES_V.PROD_UPGRADE_YN%TYPE := OKC_API.G_MISS_CHAR
78 ,inheritance_type OKS_K_LINES_V.INHERITANCE_TYPE%TYPE := OKC_API.G_MISS_CHAR
79 ,pm_program_id NUMBER := OKC_API.G_MISS_NUM
80 ,pm_conf_req_yn OKS_K_LINES_V.PM_CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
81 ,pm_sch_exists_yn OKS_K_LINES_V.PM_SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
82 ,allow_bt_discount OKS_K_LINES_V.ALLOW_BT_DISCOUNT%TYPE := OKC_API.G_MISS_CHAR
83 ,apply_default_timezone OKS_K_LINES_V.APPLY_DEFAULT_TIMEZONE%TYPE := OKC_API.G_MISS_CHAR
84 ,sync_date_install OKS_K_LINES_V.SYNC_DATE_INSTALL%TYPE := OKC_API.G_MISS_CHAR
85 ,sfwt_flag OKS_K_LINES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
86 ,invoice_text OKS_K_LINES_V.INVOICE_TEXT%TYPE := OKC_API.G_MISS_CHAR
87 ,ib_trx_details OKS_K_LINES_V.IB_TRX_DETAILS%TYPE := OKC_API.G_MISS_CHAR
88 ,status_text OKS_K_LINES_V.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
89 ,react_time_name OKS_K_LINES_V.REACT_TIME_NAME%TYPE := OKC_API.G_MISS_CHAR
90 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
91 ,security_group_id NUMBER := OKC_API.G_MISS_NUM
92 ,request_id NUMBER := OKC_API.G_MISS_NUM
93 ,created_by NUMBER := OKC_API.G_MISS_NUM
94 ,creation_date OKS_K_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
95 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
96 ,last_update_date OKS_K_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
97 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
98 G_MISS_klnhv_rec klnhv_rec_type;
99 TYPE klnhv_tbl_type IS TABLE OF klnhv_rec_type
100 INDEX BY BINARY_INTEGER;
101
102 subtype klnv_rec_type is oks_kln_pvt.klnv_rec_type;
103 subtype klnv_tbl_type is oks_kln_pvt.klnv_tbl_type;
104 subtype klt_tbl_type is OKS_KLN_PVT.klt_tbl_type;
105 ---------------------------------------------------------------------------
106 -- GLOBAL VARIABLES
107 ---------------------------------------------------------------------------
108 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_LINE_PUB';
109 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
110 G_RET_STS_SUCCESS CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_SUCCESS;
111 G_RET_STS_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_ERROR;
112 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_UNEXP_ERROR;
113 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
114 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
115 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
116 G_FALSE CONSTANT VARCHAR2(10) := OKC_API.G_FALSE;
117 G_TRUE CONSTANT VARCHAR2(10) := OKC_API.G_TRUE;
118 ---------------------------------------------------------------------------
119
120 PROCEDURE add_language;
121 PROCEDURE create_line(
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 p_klnv_rec IN klnv_rec_type,
128 x_klnv_rec OUT NOCOPY klnv_rec_type,
129 p_validate_yn IN VARCHAR2);
130 PROCEDURE create_line(
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136 p_klnv_tbl IN klnv_tbl_type,
137 x_klnv_tbl OUT NOCOPY klnv_tbl_type,
138 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
139 p_validate_yn IN VARCHAR2);
140 PROCEDURE create_line(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 p_klnv_tbl IN klnv_tbl_type,
147 x_klnv_tbl OUT NOCOPY klnv_tbl_type,
148 p_validate_yn IN VARCHAR2);
149 PROCEDURE lock_line(
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_klnv_rec IN klnv_rec_type);
156 PROCEDURE lock_line(
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_klnv_tbl IN klnv_tbl_type,
163 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
164 PROCEDURE lock_line(
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_klnv_tbl IN klnv_tbl_type);
171 PROCEDURE update_line(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_klnv_rec IN klnv_rec_type,
178 x_klnv_rec OUT NOCOPY klnv_rec_type,
179 p_validate_yn IN VARCHAR2);
180 PROCEDURE update_line(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 p_klnv_tbl IN klnv_tbl_type,
187 x_klnv_tbl OUT NOCOPY klnv_tbl_type,
188 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
189 p_validate_yn IN VARCHAR2);
190 PROCEDURE update_line(
191 p_api_version IN NUMBER,
192 p_init_msg_list IN VARCHAR2,
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2,
196 p_klnv_tbl IN klnv_tbl_type,
197 x_klnv_tbl OUT NOCOPY klnv_tbl_type,
198 p_validate_yn IN VARCHAR2);
199 PROCEDURE delete_line(
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_klnv_rec IN klnv_rec_type);
206 PROCEDURE delete_line(
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_klnv_tbl IN klnv_tbl_type,
213 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
214 PROCEDURE delete_line(
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_klnv_tbl IN klnv_tbl_type);
221 PROCEDURE validate_line(
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_klnv_rec IN klnv_rec_type);
228 PROCEDURE validate_line(
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_klnv_tbl IN klnv_tbl_type,
235 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
236 PROCEDURE validate_line(
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_klnv_tbl IN klnv_tbl_type);
243
244
245 PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,
246 p_klnv_tbl IN klnv_tbl_type);
247
248 PROCEDURE CREATE_LINE_VERSION_UPG(x_return_status OUT NOCOPY VARCHAR2,
249 p_klnhv_tbl IN klnhv_tbl_type);
250
251 END oks_contract_line_pub;
252