[Home] [Help]
PACKAGE: APPS.OKS_CONTRACT_LINE_PUB
Source
1 PACKAGE oks_contract_line_pub AUTHID CURRENT_USER AS
2 /* $Header: OKSPKLNS.pls 120.1.12020000.4 2013/04/05 07:44:56 vgujarat ship $ */
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 --skuchima VRM ER
99 ,revenue_Impact_Date OKS_K_LINES_V.revenue_impact_date%TYPE := OKC_API.G_MISS_DATE
100 ,counter_value_id NUMBER := OKC_API.G_MISS_NUM
101 );
102 G_MISS_klnhv_rec klnhv_rec_type;
103 TYPE klnhv_tbl_type IS TABLE OF klnhv_rec_type
104 INDEX BY BINARY_INTEGER;
105
106 subtype klnv_rec_type is oks_kln_pvt.klnv_rec_type;
107 subtype klnv_tbl_type is oks_kln_pvt.klnv_tbl_type;
108 subtype klt_tbl_type is OKS_KLN_PVT.klt_tbl_type;
109 ---------------------------------------------------------------------------
110 -- GLOBAL VARIABLES
111 ---------------------------------------------------------------------------
112 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_LINE_PUB';
113 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
114 G_RET_STS_SUCCESS CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_SUCCESS;
115 G_RET_STS_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_ERROR;
116 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_UNEXP_ERROR;
117 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
118 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
119 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
120 G_FALSE CONSTANT VARCHAR2(10) := OKC_API.G_FALSE;
121 G_TRUE CONSTANT VARCHAR2(10) := OKC_API.G_TRUE;
122 ---------------------------------------------------------------------------
123
124 PROCEDURE add_language;
125 PROCEDURE create_line(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2,
131 p_klnv_rec IN klnv_rec_type,
132 x_klnv_rec OUT NOCOPY klnv_rec_type,
133 p_validate_yn IN VARCHAR2);
134 PROCEDURE create_line(
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_klnv_tbl IN klnv_tbl_type,
141 x_klnv_tbl OUT NOCOPY klnv_tbl_type,
142 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
143 p_validate_yn IN VARCHAR2);
144 PROCEDURE create_line(
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 p_klnv_tbl IN klnv_tbl_type,
151 x_klnv_tbl OUT NOCOPY klnv_tbl_type,
152 p_validate_yn IN VARCHAR2);
153 PROCEDURE lock_line(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 p_klnv_rec IN klnv_rec_type);
160 PROCEDURE lock_line(
161 p_api_version IN NUMBER,
162 p_init_msg_list IN VARCHAR2,
163 x_return_status OUT NOCOPY VARCHAR2,
164 x_msg_count OUT NOCOPY NUMBER,
165 x_msg_data OUT NOCOPY VARCHAR2,
166 p_klnv_tbl IN klnv_tbl_type,
167 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
168 PROCEDURE lock_line(
169 p_api_version IN NUMBER,
170 p_init_msg_list IN VARCHAR2,
171 x_return_status OUT NOCOPY VARCHAR2,
172 x_msg_count OUT NOCOPY NUMBER,
173 x_msg_data OUT NOCOPY VARCHAR2,
174 p_klnv_tbl IN klnv_tbl_type);
175 PROCEDURE update_line(
176 p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2,
178 x_return_status OUT NOCOPY VARCHAR2,
179 x_msg_count OUT NOCOPY NUMBER,
180 x_msg_data OUT NOCOPY VARCHAR2,
181 p_klnv_rec IN klnv_rec_type,
182 x_klnv_rec OUT NOCOPY klnv_rec_type,
183 p_validate_yn IN VARCHAR2);
184 PROCEDURE update_line(
185 p_api_version IN NUMBER,
186 p_init_msg_list IN VARCHAR2,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2,
190 p_klnv_tbl IN klnv_tbl_type,
191 x_klnv_tbl OUT NOCOPY klnv_tbl_type,
192 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
193 p_validate_yn IN VARCHAR2);
194 PROCEDURE update_line(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 p_klnv_tbl IN klnv_tbl_type,
201 x_klnv_tbl OUT NOCOPY klnv_tbl_type,
202 p_validate_yn IN VARCHAR2);
203 PROCEDURE delete_line(
204 p_api_version IN NUMBER,
205 p_init_msg_list IN VARCHAR2,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 p_klnv_rec IN klnv_rec_type);
210 PROCEDURE delete_line(
211 p_api_version IN NUMBER,
212 p_init_msg_list IN VARCHAR2,
213 x_return_status OUT NOCOPY VARCHAR2,
214 x_msg_count OUT NOCOPY NUMBER,
215 x_msg_data OUT NOCOPY VARCHAR2,
216 p_klnv_tbl IN klnv_tbl_type,
217 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
218 PROCEDURE delete_line(
219 p_api_version IN NUMBER,
220 p_init_msg_list IN VARCHAR2,
221 x_return_status OUT NOCOPY VARCHAR2,
222 x_msg_count OUT NOCOPY NUMBER,
223 x_msg_data OUT NOCOPY VARCHAR2,
224 p_klnv_tbl IN klnv_tbl_type);
225 PROCEDURE validate_line(
226 p_api_version IN NUMBER,
227 p_init_msg_list IN VARCHAR2,
228 x_return_status OUT NOCOPY VARCHAR2,
229 x_msg_count OUT NOCOPY NUMBER,
230 x_msg_data OUT NOCOPY VARCHAR2,
231 p_klnv_rec IN klnv_rec_type);
232 PROCEDURE validate_line(
233 p_api_version IN NUMBER,
234 p_init_msg_list IN VARCHAR2,
235 x_return_status OUT NOCOPY VARCHAR2,
236 x_msg_count OUT NOCOPY NUMBER,
237 x_msg_data OUT NOCOPY VARCHAR2,
238 p_klnv_tbl IN klnv_tbl_type,
239 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
240 PROCEDURE validate_line(
241 p_api_version IN NUMBER,
242 p_init_msg_list IN VARCHAR2,
243 x_return_status OUT NOCOPY VARCHAR2,
244 x_msg_count OUT NOCOPY NUMBER,
245 x_msg_data OUT NOCOPY VARCHAR2,
246 p_klnv_tbl IN klnv_tbl_type);
247
248
249 PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,
250 p_klnv_tbl IN klnv_tbl_type);
251
252 PROCEDURE CREATE_LINE_VERSION_UPG(x_return_status OUT NOCOPY VARCHAR2,
253 p_klnhv_tbl IN klnhv_tbl_type);
254
255 END oks_contract_line_pub;
256