[Home] [Help]
PACKAGE: APPS.OKL_CPN_PVT
Source
1 PACKAGE OKL_CPN_PVT AS
2 /* $Header: OKLSCPNS.pls 120.2 2006/07/11 10:16:31 dkagrawa noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_CURE_PAYMENT_LINES_V Record Spec
7 TYPE CPNv_rec_type IS RECORD (
8 cure_payment_line_id NUMBER := OKC_API.G_MISS_NUM
9 ,cure_payment_id NUMBER := OKC_API.G_MISS_NUM
10 ,chr_id NUMBER := OKC_API.G_MISS_NUM
11 ,amount NUMBER := OKC_API.G_MISS_NUM
12 ,cured_flag OKL_CURE_PAYMENT_LINES.CURED_FLAG%TYPE := OKC_API.G_MISS_CHAR
13 ,status OKL_CURE_PAYMENT_LINES.STATUS%TYPE := OKC_API.G_MISS_CHAR
14 ,cure_refund_id NUMBER := OKC_API.G_MISS_NUM
15 ,approval_status OKL_CURE_PAYMENT_LINES.APPROVAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
16 ,approval_reason OKL_CURE_PAYMENT_LINES.APPROVAL_REASON%TYPE := OKC_API.G_MISS_CHAR
17 ,transaction_id NUMBER := OKC_API.G_MISS_NUM
18 ,tai_id NUMBER := OKC_API.G_MISS_NUM
19 ,process_status OKL_CURE_PAYMENT_LINES.PROCESS_STATUS%TYPE := OKC_API.G_MISS_CHAR
20 ,rct_id NUMBER := OKC_API.G_MISS_NUM
21 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
22 ,org_id NUMBER := OKC_API.G_MISS_NUM
23 ,request_id NUMBER := OKC_API.G_MISS_NUM
24 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
25 ,program_id NUMBER := OKC_API.G_MISS_NUM
26 ,program_update_date OKL_CURE_PAYMENT_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
27 ,attribute_category OKL_CURE_PAYMENT_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
28 ,attribute1 OKL_CURE_PAYMENT_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
29 ,attribute2 OKL_CURE_PAYMENT_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
30 ,attribute3 OKL_CURE_PAYMENT_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
31 ,attribute4 OKL_CURE_PAYMENT_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
32 ,attribute5 OKL_CURE_PAYMENT_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
33 ,attribute6 OKL_CURE_PAYMENT_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
34 ,attribute7 OKL_CURE_PAYMENT_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
35 ,attribute8 OKL_CURE_PAYMENT_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
36 ,attribute9 OKL_CURE_PAYMENT_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
37 ,attribute10 OKL_CURE_PAYMENT_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
38 ,attribute11 OKL_CURE_PAYMENT_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
39 ,attribute12 OKL_CURE_PAYMENT_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
40 ,attribute13 OKL_CURE_PAYMENT_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
41 ,attribute14 OKL_CURE_PAYMENT_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
42 ,attribute15 OKL_CURE_PAYMENT_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
43 ,created_by NUMBER := OKC_API.G_MISS_NUM
44 ,creation_date OKL_CURE_PAYMENT_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
45 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
46 ,last_update_date OKL_CURE_PAYMENT_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
47 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
48 G_MISS_CPNv_rec CPNv_rec_type;
49 TYPE CPNv_tbl_type IS TABLE OF CPNv_rec_type
50 INDEX BY BINARY_INTEGER;
51 -- OKL_CURE_PAYMENT_LINES Record Spec
52 TYPE OKLCurePaymentLinesRecType IS RECORD (
53 cure_payment_line_id NUMBER := OKC_API.G_MISS_NUM
54 ,cure_payment_id NUMBER := OKC_API.G_MISS_NUM
55 ,chr_id NUMBER := OKC_API.G_MISS_NUM
56 ,amount NUMBER := OKC_API.G_MISS_NUM
57 ,cured_flag OKL_CURE_PAYMENT_LINES.CURED_FLAG%TYPE := OKC_API.G_MISS_CHAR
58 ,status OKL_CURE_PAYMENT_LINES.STATUS%TYPE := OKC_API.G_MISS_CHAR
59 ,cure_refund_id NUMBER := OKC_API.G_MISS_NUM
60 ,approval_status OKL_CURE_PAYMENT_LINES.APPROVAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
61 ,approval_reason OKL_CURE_PAYMENT_LINES.APPROVAL_REASON%TYPE := OKC_API.G_MISS_CHAR
62 ,transaction_id NUMBER := OKC_API.G_MISS_NUM
63 ,tai_id NUMBER := OKC_API.G_MISS_NUM
64 ,process_status OKL_CURE_PAYMENT_LINES.PROCESS_STATUS%TYPE := OKC_API.G_MISS_CHAR
65 ,rct_id NUMBER := OKC_API.G_MISS_NUM
66 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
67 ,org_id NUMBER := OKC_API.G_MISS_NUM
68 ,request_id NUMBER := OKC_API.G_MISS_NUM
69 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
70 ,program_id NUMBER := OKC_API.G_MISS_NUM
71 ,program_update_date OKL_CURE_PAYMENT_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
72 ,attribute_category OKL_CURE_PAYMENT_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
73 ,attribute1 OKL_CURE_PAYMENT_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
74 ,attribute2 OKL_CURE_PAYMENT_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
75 ,attribute3 OKL_CURE_PAYMENT_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
76 ,attribute4 OKL_CURE_PAYMENT_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
77 ,attribute5 OKL_CURE_PAYMENT_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
78 ,attribute6 OKL_CURE_PAYMENT_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
79 ,attribute7 OKL_CURE_PAYMENT_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
80 ,attribute8 OKL_CURE_PAYMENT_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
81 ,attribute9 OKL_CURE_PAYMENT_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
82 ,attribute10 OKL_CURE_PAYMENT_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
83 ,attribute11 OKL_CURE_PAYMENT_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
84 ,attribute12 OKL_CURE_PAYMENT_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
85 ,attribute13 OKL_CURE_PAYMENT_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
86 ,attribute14 OKL_CURE_PAYMENT_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
87 ,attribute15 OKL_CURE_PAYMENT_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
88 ,created_by NUMBER := OKC_API.G_MISS_NUM
89 ,creation_date OKL_CURE_PAYMENT_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
90 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
91 ,last_update_date OKL_CURE_PAYMENT_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
92 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
93 GMissOKLCurePaymentLinesRec OKLCurePaymentLinesRecType;
94 TYPE OKLCurePaymentLinesTblType IS TABLE OF OKLCurePaymentLinesRecType
95 INDEX BY BINARY_INTEGER;
96 ---------------------------------------------------------------------------
97 -- GLOBAL MESSAGE CONSTANTS
98 ---------------------------------------------------------------------------
99 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
100 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
101 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
102 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
103 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
104 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
105 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
106 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
107 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
108 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
109 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
110 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
111 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
112
113 ---------------------------------------------------------------------------
114 -- GLOBAL EXCEPTIONS
115 ---------------------------------------------------------------------------
116 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
117
118 ---------------------------------------------------------------------------
119 -- GLOBAL VARIABLES
120 ---------------------------------------------------------------------------
121 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CPN_PVT';
122 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
123 ---------------------------------------------------------------------------
124 -- Procedures and Functions
125 ---------------------------------------------------------------------------
126
127 PROCEDURE qc;
128 PROCEDURE change_version;
129 PROCEDURE api_copy;
130 PROCEDURE insert_row(
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136 p_CPNv_rec IN CPNv_rec_type,
137 x_CPNv_rec OUT NOCOPY CPNv_rec_type);
138 PROCEDURE insert_row(
139 p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144 p_CPNv_tbl IN CPNv_tbl_type,
145 x_CPNv_tbl OUT NOCOPY CPNv_tbl_type,
146 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
147 PROCEDURE insert_row(
148 p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153 p_CPNv_tbl IN CPNv_tbl_type,
154 x_CPNv_tbl OUT NOCOPY CPNv_tbl_type);
155 PROCEDURE lock_row(
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_CPNv_rec IN CPNv_rec_type);
162 PROCEDURE lock_row(
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168 p_CPNv_tbl IN CPNv_tbl_type,
169 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
170 PROCEDURE lock_row(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 p_CPNv_tbl IN CPNv_tbl_type);
177 PROCEDURE update_row(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_CPNv_rec IN CPNv_rec_type,
184 x_CPNv_rec OUT NOCOPY CPNv_rec_type);
185 PROCEDURE update_row(
186 p_api_version IN NUMBER,
187 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188 x_return_status OUT NOCOPY VARCHAR2,
189 x_msg_count OUT NOCOPY NUMBER,
190 x_msg_data OUT NOCOPY VARCHAR2,
191 p_CPNv_tbl IN CPNv_tbl_type,
192 x_CPNv_tbl OUT NOCOPY CPNv_tbl_type,
193 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
194 PROCEDURE update_row(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 p_CPNv_tbl IN CPNv_tbl_type,
201 x_CPNv_tbl OUT NOCOPY CPNv_tbl_type);
202 PROCEDURE delete_row(
203 p_api_version IN NUMBER,
204 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
205 x_return_status OUT NOCOPY VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2,
208 p_CPNv_rec IN CPNv_rec_type);
209 PROCEDURE delete_row(
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215 p_CPNv_tbl IN CPNv_tbl_type,
216 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
217 PROCEDURE delete_row(
218 p_api_version IN NUMBER,
219 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
220 x_return_status OUT NOCOPY VARCHAR2,
221 x_msg_count OUT NOCOPY NUMBER,
222 x_msg_data OUT NOCOPY VARCHAR2,
223 p_CPNv_tbl IN CPNv_tbl_type);
224 PROCEDURE validate_row(
225 p_api_version IN NUMBER,
226 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2,
230 p_CPNv_rec IN CPNv_rec_type);
231 PROCEDURE validate_row(
232 p_api_version IN NUMBER,
233 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
234 x_return_status OUT NOCOPY VARCHAR2,
235 x_msg_count OUT NOCOPY NUMBER,
236 x_msg_data OUT NOCOPY VARCHAR2,
237 p_CPNv_tbl IN CPNv_tbl_type,
238 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
239 PROCEDURE validate_row(
240 p_api_version IN NUMBER,
241 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2,
245 p_CPNv_tbl IN CPNv_tbl_type);
246 END OKL_CPN_PVT;