[Home] [Help]
PACKAGE: APPS.OKL_XCA_PVT
Source
4 ---------------------------------------------------------------------------
1 PACKAGE OKL_XCA_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSXCAS.pls 115.12 2002/12/16 20:53:21 bvaghela noship $ */
3
5 -- GLOBAL DATASTRUCTURES
6 ---------------------------------------------------------------------------
7 TYPE xca_rec_type IS RECORD (
8 id NUMBER := Okl_Api.G_MISS_NUM,
9 xcr_id_details NUMBER := Okl_Api.G_MISS_NUM,
10 irp_id NUMBER := Okl_Api.G_MISS_NUM,
11 lsm_id NUMBER := Okl_Api.G_MISS_NUM,
15 invoice_number OKL_XTL_CSH_APPS_B.INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
12 rca_id NUMBER := Okl_Api.G_MISS_NUM,
13 cat_id NUMBER := Okl_Api.G_MISS_NUM,
14 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
16 amount_applied NUMBER := Okl_Api.G_MISS_NUM,
17 invoice_installment NUMBER := Okl_Api.G_MISS_NUM,
18 amount_applied_from NUMBER := Okl_Api.G_MISS_NUM,
19 invoice_currency_code OKL_XTL_CSH_APPS_B.INVOICE_CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
20 trans_to_receipt_rate NUMBER := Okl_Api.G_MISS_NUM,
21 trx_date OKL_XTL_CSH_APPS_B.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
22 request_id NUMBER := Okl_Api.G_MISS_NUM,
23 program_application_id NUMBER := Okl_Api.G_MISS_NUM,
24 program_id NUMBER := Okl_Api.G_MISS_NUM,
25 program_update_date OKL_XTL_CSH_APPS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
26 org_id NUMBER := Okl_Api.G_MISS_NUM,
27 attribute_category OKL_XTL_CSH_APPS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
28 attribute1 OKL_XTL_CSH_APPS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
29 attribute2 OKL_XTL_CSH_APPS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
30 attribute3 OKL_XTL_CSH_APPS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
31 attribute4 OKL_XTL_CSH_APPS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
32 attribute5 OKL_XTL_CSH_APPS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
33 attribute6 OKL_XTL_CSH_APPS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
34 attribute7 OKL_XTL_CSH_APPS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
35 attribute8 OKL_XTL_CSH_APPS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
36 attribute9 OKL_XTL_CSH_APPS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
37 attribute10 OKL_XTL_CSH_APPS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
38 attribute11 OKL_XTL_CSH_APPS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
39 attribute12 OKL_XTL_CSH_APPS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
40 attribute13 OKL_XTL_CSH_APPS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
41 attribute14 OKL_XTL_CSH_APPS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
42 attribute15 OKL_XTL_CSH_APPS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
43 created_by NUMBER := Okl_Api.G_MISS_NUM,
44 creation_date OKL_XTL_CSH_APPS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
45 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
46 last_update_date OKL_XTL_CSH_APPS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
47 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
48 g_miss_xca_rec xca_rec_type;
49 TYPE xca_tbl_type IS TABLE OF xca_rec_type
50 INDEX BY BINARY_INTEGER;
51 TYPE okl_xtl_csh_apps_tl_rec_type IS RECORD (
52 id NUMBER := Okl_Api.G_MISS_NUM,
53 LANGUAGE OKL_XTL_CSH_APPS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
54 source_lang OKL_XTL_CSH_APPS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
55 sfwt_flag OKL_XTL_CSH_APPS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
56 created_by NUMBER := Okl_Api.G_MISS_NUM,
57 creation_date OKL_XTL_CSH_APPS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
58 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
59 last_update_date OKL_XTL_CSH_APPS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
60 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
61 g_miss_okl_xtl_csh_apps_tl_rec okl_xtl_csh_apps_tl_rec_type;
62 TYPE okl_xtl_csh_apps_tl_tbl_type IS TABLE OF okl_xtl_csh_apps_tl_rec_type
63 INDEX BY BINARY_INTEGER;
64 TYPE xcav_rec_type IS RECORD (
65 id NUMBER := Okl_Api.G_MISS_NUM,
66 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
67 sfwt_flag OKL_XTL_CSH_APPS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
68 lsm_id NUMBER := Okl_Api.G_MISS_NUM,
69 rca_id NUMBER := Okl_Api.G_MISS_NUM,
70 cat_id NUMBER := Okl_Api.G_MISS_NUM,
71 irp_id NUMBER := Okl_Api.G_MISS_NUM,
72 xcr_id_details NUMBER := Okl_Api.G_MISS_NUM,
73 invoice_number OKL_XTL_CSH_APPS_V.INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
74 amount_applied NUMBER := Okl_Api.G_MISS_NUM,
75 invoice_installment NUMBER := Okl_Api.G_MISS_NUM,
76 amount_applied_from NUMBER := Okl_Api.G_MISS_NUM,
77 invoice_currency_code OKL_XTL_CSH_APPS_V.INVOICE_CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
78 trans_to_receipt_rate NUMBER := Okl_Api.G_MISS_NUM,
79 trx_date OKL_XTL_CSH_APPS_V.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
80 attribute_category OKL_XTL_CSH_APPS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
81 attribute1 OKL_XTL_CSH_APPS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
82 attribute2 OKL_XTL_CSH_APPS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
83 attribute3 OKL_XTL_CSH_APPS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
84 attribute4 OKL_XTL_CSH_APPS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
85 attribute5 OKL_XTL_CSH_APPS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
86 attribute6 OKL_XTL_CSH_APPS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
87 attribute7 OKL_XTL_CSH_APPS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
91 attribute11 OKL_XTL_CSH_APPS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
88 attribute8 OKL_XTL_CSH_APPS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
89 attribute9 OKL_XTL_CSH_APPS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
90 attribute10 OKL_XTL_CSH_APPS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
92 attribute12 OKL_XTL_CSH_APPS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
93 attribute13 OKL_XTL_CSH_APPS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
94 attribute14 OKL_XTL_CSH_APPS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
95 attribute15 OKL_XTL_CSH_APPS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
96 request_id NUMBER := Okl_Api.G_MISS_NUM,
97 program_application_id NUMBER := Okl_Api.G_MISS_NUM,
98 program_id NUMBER := Okl_Api.G_MISS_NUM,
99 program_update_date OKL_XTL_CSH_APPS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
100 org_id NUMBER := Okl_Api.G_MISS_NUM,
101 created_by NUMBER := Okl_Api.G_MISS_NUM,
102 creation_date OKL_XTL_CSH_APPS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
103 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
104 last_update_date OKL_XTL_CSH_APPS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
105 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
106 g_miss_xcav_rec xcav_rec_type;
107 TYPE xcav_tbl_type IS TABLE OF xcav_rec_type
108 INDEX BY BINARY_INTEGER;
109 ---------------------------------------------------------------------------
110 -- GLOBAL MESSAGE CONSTANTS
111 ---------------------------------------------------------------------------
112 G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
113 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
114 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
115 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
116 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
117 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
118 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
119 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
120 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
121 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
122 ---------------------------------------------------------------------------
123 -- GLOBAL VARIABLES
124 ---------------------------------------------------------------------------
125 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_XCA_PVT';
126 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
127
128 ---------------------------------------------------------------------------
129 -- ADDED AFTER TAPI 04/17/2001
130 ---------------------------------------------------------------------------
131 ---------------------------------------------------------------------------
132 -- GLOBAL MESSAGES
133 ---------------------------------------------------------------------------
134 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
135 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
136 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
137 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
138
139 ---------------------------------------------------------------------------
140 -- GLOBAL VARIABLES
141 ---------------------------------------------------------------------------
142 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_TRX_AR_INVOICES_V';
143 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
144
145 ---------------------------------------------------------------------------
146 -- POST GEN TAPI CODE ENDS HERE 04/17/2001
147 ---------------------------------------------------------------------------
148 ---------------------------------------------------------------------------
149 -- Procedures and Functions
150 ---------------------------------------------------------------------------
151
152 PROCEDURE qc;
153 PROCEDURE change_version;
154 PROCEDURE api_copy;
155 PROCEDURE add_language;
156 PROCEDURE insert_row(
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_xcav_rec IN xcav_rec_type,
163 x_xcav_rec OUT NOCOPY xcav_rec_type);
164
165 PROCEDURE insert_row(
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 p_xcav_tbl IN xcav_tbl_type,
172 x_xcav_tbl OUT NOCOPY xcav_tbl_type);
173
174 PROCEDURE lock_row(
175 p_api_version IN NUMBER,
176 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2,
180 p_xcav_rec IN xcav_rec_type);
181
182 PROCEDURE lock_row(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 p_xcav_tbl IN xcav_tbl_type);
189
190 PROCEDURE update_row(
191 p_api_version IN NUMBER,
192 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2,
196 p_xcav_rec IN xcav_rec_type,
197 x_xcav_rec OUT NOCOPY xcav_rec_type);
198
199 PROCEDURE update_row(
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_xcav_tbl IN xcav_tbl_type,
206 x_xcav_tbl OUT NOCOPY xcav_tbl_type);
207
208 PROCEDURE delete_row(
209 p_api_version IN NUMBER,
210 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
211 x_return_status OUT NOCOPY VARCHAR2,
212 x_msg_count OUT NOCOPY NUMBER,
213 x_msg_data OUT NOCOPY VARCHAR2,
214 p_xcav_rec IN xcav_rec_type);
215
216 PROCEDURE delete_row(
217 p_api_version IN NUMBER,
218 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
219 x_return_status OUT NOCOPY VARCHAR2,
220 x_msg_count OUT NOCOPY NUMBER,
221 x_msg_data OUT NOCOPY VARCHAR2,
222 p_xcav_tbl IN xcav_tbl_type);
223
224 PROCEDURE validate_row(
225 p_api_version IN NUMBER,
226 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_xcav_rec IN xcav_rec_type);
231
232 PROCEDURE validate_row(
233 p_api_version IN NUMBER,
234 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
235 x_return_status OUT NOCOPY VARCHAR2,
236 x_msg_count OUT NOCOPY NUMBER,
237 x_msg_data OUT NOCOPY VARCHAR2,
238 p_xcav_tbl IN xcav_tbl_type);
239
240 END Okl_Xca_Pvt;