[Home] [Help]
PACKAGE: APPS.OKL_XCR_PVT
Source
1 PACKAGE OKL_XCR_PVT AS
2 /* $Header: OKLSXCRS.pls 120.2 2005/10/30 04:46:07 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE xcr_rec_type IS RECORD (
7 id NUMBER := Okl_Api.G_MISS_NUM,
8 xcb_id NUMBER := Okl_Api.G_MISS_NUM,
9 rct_id NUMBER := Okl_Api.G_MISS_NUM,
10 icr_id NUMBER := Okl_Api.G_MISS_NUM,
11 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
12 gl_date DATE := Okl_Api.G_MISS_DATE,
13 item_number NUMBER := Okl_Api.G_MISS_NUM,
14 remittance_amount NUMBER := Okl_Api.G_MISS_NUM,
15 currency_code OKL_EXT_CSH_RCPTS_B.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
16 receipt_date OKL_EXT_CSH_RCPTS_B.RECEIPT_DATE%TYPE := Okl_Api.G_MISS_DATE,
17 receipt_method OKL_EXT_CSH_RCPTS_B.RECEIPT_METHOD%TYPE := Okl_Api.G_MISS_CHAR,
18 check_number OKL_EXT_CSH_RCPTS_B.CHECK_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
19 comments OKL_EXT_CSH_RCPTS_TL.COMMENTS%TYPE := Okl_Api.G_MISS_CHAR,
20 customer_number OKL_EXT_CSH_RCPTS_B.CUSTOMER_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
21 bill_to_location OKL_EXT_CSH_RCPTS_B.BILL_TO_LOCATION%TYPE := Okl_Api.G_MISS_CHAR,
22 exchange_rate_type OKL_EXT_CSH_RCPTS_B.EXCHANGE_RATE_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
23 exchange_rate_date OKL_EXT_CSH_RCPTS_B.EXCHANGE_RATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
24 exchange_rate NUMBER := Okl_Api.G_MISS_NUM,
25 transit_routing_number OKL_EXT_CSH_RCPTS_B.TRANSIT_ROUTING_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
26 account OKL_EXT_CSH_RCPTS_B.ACCOUNT%TYPE := Okl_Api.G_MISS_CHAR,
27 customer_bank_name OKL_EXT_CSH_RCPTS_B.CUSTOMER_BANK_NAME%TYPE := Okl_Api.G_MISS_CHAR,
28 customer_bank_branch_name OKL_EXT_CSH_RCPTS_B.CUSTOMER_BANK_BRANCH_NAME%TYPE := Okl_Api.G_MISS_CHAR,
29 remittance_bank_name OKL_EXT_CSH_RCPTS_B.REMITTANCE_BANK_NAME%TYPE := Okl_Api.G_MISS_CHAR,
30 remittance_bank_branch_name OKL_EXT_CSH_RCPTS_B.REMITTANCE_BANK_BRANCH_NAME%TYPE := Okl_Api.G_MISS_CHAR,
31 request_id NUMBER := Okl_Api.G_MISS_NUM,
32 program_application_id NUMBER := Okl_Api.G_MISS_NUM,
33 program_id NUMBER := Okl_Api.G_MISS_NUM,
34 program_update_date OKL_EXT_CSH_RCPTS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
35 org_id NUMBER := Okl_Api.G_MISS_NUM,
36 attribute_category OKL_EXT_CSH_RCPTS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
37 attribute1 OKL_EXT_CSH_RCPTS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
38 attribute2 OKL_EXT_CSH_RCPTS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
39 attribute3 OKL_EXT_CSH_RCPTS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
40 attribute4 OKL_EXT_CSH_RCPTS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
41 attribute5 OKL_EXT_CSH_RCPTS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
42 attribute6 OKL_EXT_CSH_RCPTS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
43 attribute7 OKL_EXT_CSH_RCPTS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
44 attribute8 OKL_EXT_CSH_RCPTS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
45 attribute9 OKL_EXT_CSH_RCPTS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
46 attribute10 OKL_EXT_CSH_RCPTS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
47 attribute11 OKL_EXT_CSH_RCPTS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
48 attribute12 OKL_EXT_CSH_RCPTS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
49 attribute13 OKL_EXT_CSH_RCPTS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
50 attribute14 OKL_EXT_CSH_RCPTS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
51 attribute15 OKL_EXT_CSH_RCPTS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
52 created_by NUMBER := Okl_Api.G_MISS_NUM,
53 creation_date OKL_EXT_CSH_RCPTS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
54 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
55 last_update_date OKL_EXT_CSH_RCPTS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
56 last_update_login NUMBER := Okl_Api.G_MISS_NUM,
57 -- receipt type and fully applied are the two new columns added.
58 receipt_type OKL_EXT_CSH_RCPTS_B.RECEIPT_TYPE%TYPE := 'REG',
59 fully_applied_flag OKL_EXT_CSH_RCPTS_B.FULLY_APPLIED_FLAG%TYPE := 'REG',
60 expired_flag OKL_EXT_CSH_RCPTS_B.FULLY_APPLIED_FLAG%TYPE := Okl_Api.G_MISS_CHAR );
61 g_miss_xcr_rec xcr_rec_type;
62 TYPE xcr_tbl_type IS TABLE OF xcr_rec_type
63 INDEX BY BINARY_INTEGER;
64 TYPE okl_ext_csh_rcpts_tl_rec_type IS RECORD (
65 id NUMBER := Okl_Api.G_MISS_NUM,
66 LANGUAGE OKL_EXT_CSH_RCPTS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
67 source_lang OKL_EXT_CSH_RCPTS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
68 sfwt_flag OKL_EXT_CSH_RCPTS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
69 comments OKL_EXT_CSH_RCPTS_TL.COMMENTS%TYPE := Okl_Api.G_MISS_CHAR,
70 created_by NUMBER := Okl_Api.G_MISS_NUM,
71 creation_date OKL_EXT_CSH_RCPTS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
72 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
73 last_update_date OKL_EXT_CSH_RCPTS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
74 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
75 GMissOklExtCshRcptsTlRec okl_ext_csh_rcpts_tl_rec_type;
76 TYPE okl_ext_csh_rcpts_tl_tbl_type IS TABLE OF okl_ext_csh_rcpts_tl_rec_type
77 INDEX BY BINARY_INTEGER;
78 TYPE xcrv_rec_type IS RECORD (
79 id NUMBER := Okl_Api.G_MISS_NUM,
80 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
81 sfwt_flag OKL_EXT_CSH_RCPTS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
82 xcb_id NUMBER := Okl_Api.G_MISS_NUM,
83 rct_id NUMBER := Okl_Api.G_MISS_NUM,
84 icr_id NUMBER := Okl_Api.G_MISS_NUM,
85 gl_date DATE := Okl_Api.G_MISS_DATE,
86 item_number NUMBER := Okl_Api.G_MISS_NUM,
87 remittance_amount NUMBER := Okl_Api.G_MISS_NUM,
88 currency_code OKL_EXT_CSH_RCPTS_V.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
89 receipt_date OKL_EXT_CSH_RCPTS_V.RECEIPT_DATE%TYPE := Okl_Api.G_MISS_DATE,
90 receipt_method OKL_EXT_CSH_RCPTS_V.RECEIPT_METHOD%TYPE := Okl_Api.G_MISS_CHAR,
91 check_number OKL_EXT_CSH_RCPTS_V.CHECK_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
92 comments OKL_EXT_CSH_RCPTS_V.COMMENTS%TYPE := Okl_Api.G_MISS_CHAR,
93 customer_number OKL_EXT_CSH_RCPTS_V.CUSTOMER_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
94 bill_to_location OKL_EXT_CSH_RCPTS_V.BILL_TO_LOCATION%TYPE := Okl_Api.G_MISS_CHAR,
95 exchange_rate_type OKL_EXT_CSH_RCPTS_V.EXCHANGE_RATE_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
96 exchange_rate_date OKL_EXT_CSH_RCPTS_V.EXCHANGE_RATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
97 exchange_rate NUMBER := Okl_Api.G_MISS_NUM,
98 transit_routing_number OKL_EXT_CSH_RCPTS_V.TRANSIT_ROUTING_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
99 account OKL_EXT_CSH_RCPTS_V.ACCOUNT%TYPE := Okl_Api.G_MISS_CHAR,
100 customer_bank_name OKL_EXT_CSH_RCPTS_V.CUSTOMER_BANK_NAME%TYPE := Okl_Api.G_MISS_CHAR,
101 customer_bank_branch_name OKL_EXT_CSH_RCPTS_V.CUSTOMER_BANK_BRANCH_NAME%TYPE := Okl_Api.G_MISS_CHAR,
102 remittance_bank_name OKL_EXT_CSH_RCPTS_V.REMITTANCE_BANK_NAME%TYPE := Okl_Api.G_MISS_CHAR,
103 remittance_bank_branch_name OKL_EXT_CSH_RCPTS_V.REMITTANCE_BANK_BRANCH_NAME%TYPE := Okl_Api.G_MISS_CHAR,
104 attribute_category OKL_EXT_CSH_RCPTS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
105 attribute1 OKL_EXT_CSH_RCPTS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
106 attribute2 OKL_EXT_CSH_RCPTS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
107 attribute3 OKL_EXT_CSH_RCPTS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
108 attribute4 OKL_EXT_CSH_RCPTS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
109 attribute5 OKL_EXT_CSH_RCPTS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
110 attribute6 OKL_EXT_CSH_RCPTS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
111 attribute7 OKL_EXT_CSH_RCPTS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
112 attribute8 OKL_EXT_CSH_RCPTS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
113 attribute9 OKL_EXT_CSH_RCPTS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
114 attribute10 OKL_EXT_CSH_RCPTS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
115 attribute11 OKL_EXT_CSH_RCPTS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
116 attribute12 OKL_EXT_CSH_RCPTS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
117 attribute13 OKL_EXT_CSH_RCPTS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
118 attribute14 OKL_EXT_CSH_RCPTS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
119 attribute15 OKL_EXT_CSH_RCPTS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
120 request_id NUMBER := Okl_Api.G_MISS_NUM,
121 program_application_id NUMBER := Okl_Api.G_MISS_NUM,
122 program_id NUMBER := Okl_Api.G_MISS_NUM,
123 program_update_date OKL_EXT_CSH_RCPTS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
124 org_id NUMBER := Okl_Api.G_MISS_NUM,
125 created_by NUMBER := Okl_Api.G_MISS_NUM,
126 creation_date OKL_EXT_CSH_RCPTS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
127 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
128 last_update_date OKL_EXT_CSH_RCPTS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
129 last_update_login NUMBER := Okl_Api.G_MISS_NUM,
130 -- receipt type and fully applied are the two new columns added.
131 receipt_type OKL_EXT_CSH_RCPTS_B.RECEIPT_TYPE%TYPE := 'REG',
132 fully_applied_flag OKL_EXT_CSH_RCPTS_B.FULLY_APPLIED_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
133 expired_flag OKL_EXT_CSH_RCPTS_B.FULLY_APPLIED_FLAG%TYPE := Okl_Api.G_MISS_CHAR );
134 g_miss_xcrv_rec xcrv_rec_type;
135 TYPE xcrv_tbl_type IS TABLE OF xcrv_rec_type
136 INDEX BY BINARY_INTEGER;
137 ---------------------------------------------------------------------------
138 -- GLOBAL MESSAGE CONSTANTS
139 ---------------------------------------------------------------------------
140 G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
141 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
142 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
143 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
144 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
145 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
146 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
147 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
148 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
149 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
150 ---------------------------------------------------------------------------
151 -- GLOBAL VARIABLES
152 ---------------------------------------------------------------------------
153 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_XCR_PVT';
154 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
155
156 ---------------------------------------------------------------------------
157 -- ADDED AFTER TAPI 04/17/2001
158 ---------------------------------------------------------------------------
159 ---------------------------------------------------------------------------
160 -- GLOBAL MESSAGES
161 ---------------------------------------------------------------------------
162 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
163 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
164 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
165 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
166 G_USER_MESSAGE CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_INVALID_VALUE';
167 ---------------------------------------------------------------------------
168 -- GLOBAL VARIABLES
169 ---------------------------------------------------------------------------
170 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_TRX_AR_INVOICES_V';
171 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
172
173 ---------------------------------------------------------------------------
174 -- POST GEN TAPI CODE ENDS HERE 04/17/2001
175 ---------------------------------------------------------------------------
176
177 ---------------------------------------------------------------------------
178 -- Procedures and Functions
179 ---------------------------------------------------------------------------
180
181 PROCEDURE qc;
182 PROCEDURE change_version;
183 PROCEDURE api_copy;
184 PROCEDURE add_language;
185 PROCEDURE insert_row(
186 p_api_version IN NUMBER,
187 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_xcrv_rec IN xcrv_rec_type,
192 x_xcrv_rec OUT NOCOPY xcrv_rec_type);
193
194 PROCEDURE insert_row(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_xcrv_tbl IN xcrv_tbl_type,
201 x_xcrv_tbl OUT NOCOPY xcrv_tbl_type);
202
203 PROCEDURE lock_row(
204 p_api_version IN NUMBER,
205 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 p_xcrv_rec IN xcrv_rec_type);
210
211 PROCEDURE lock_row(
212 p_api_version IN NUMBER,
213 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
214 x_return_status OUT NOCOPY VARCHAR2,
215 x_msg_count OUT NOCOPY NUMBER,
216 x_msg_data OUT NOCOPY VARCHAR2,
217 p_xcrv_tbl IN xcrv_tbl_type);
218
219 PROCEDURE update_row(
220 p_api_version IN NUMBER,
221 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_msg_count OUT NOCOPY NUMBER,
224 x_msg_data OUT NOCOPY VARCHAR2,
225 p_xcrv_rec IN xcrv_rec_type,
226 x_xcrv_rec OUT NOCOPY xcrv_rec_type);
227
228 PROCEDURE update_row(
229 p_api_version IN NUMBER,
230 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
231 x_return_status OUT NOCOPY VARCHAR2,
232 x_msg_count OUT NOCOPY NUMBER,
233 x_msg_data OUT NOCOPY VARCHAR2,
234 p_xcrv_tbl IN xcrv_tbl_type,
235 x_xcrv_tbl OUT NOCOPY xcrv_tbl_type);
236
237 PROCEDURE delete_row(
238 p_api_version IN NUMBER,
239 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
240 x_return_status OUT NOCOPY VARCHAR2,
241 x_msg_count OUT NOCOPY NUMBER,
242 x_msg_data OUT NOCOPY VARCHAR2,
243 p_xcrv_rec IN xcrv_rec_type);
244
245 PROCEDURE delete_row(
246 p_api_version IN NUMBER,
247 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
248 x_return_status OUT NOCOPY VARCHAR2,
249 x_msg_count OUT NOCOPY NUMBER,
250 x_msg_data OUT NOCOPY VARCHAR2,
251 p_xcrv_tbl IN xcrv_tbl_type);
252
253 PROCEDURE validate_row(
254 p_api_version IN NUMBER,
255 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
256 x_return_status OUT NOCOPY VARCHAR2,
257 x_msg_count OUT NOCOPY NUMBER,
258 x_msg_data OUT NOCOPY VARCHAR2,
259 p_xcrv_rec IN xcrv_rec_type);
260
261 PROCEDURE validate_row(
262 p_api_version IN NUMBER,
263 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
264 x_return_status OUT NOCOPY VARCHAR2,
265 x_msg_count OUT NOCOPY NUMBER,
266 x_msg_data OUT NOCOPY VARCHAR2,
267 p_xcrv_tbl IN xcrv_tbl_type);
268
269 END Okl_Xcr_Pvt;