[Home] [Help]
PACKAGE: APPS.OKL_RCA_PVT
Source
1 PACKAGE Okl_Rca_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSRCAS.pls 120.3 2007/08/24 09:39:19 nikshah ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE rca_rec_type IS RECORD (
7 id NUMBER := Okl_Api.G_MISS_NUM,
8 rct_id_details NUMBER := Okl_Api.G_MISS_NUM,
9 cnr_id NUMBER := Okl_Api.G_MISS_NUM,
10 khr_id NUMBER := Okl_Api.G_MISS_NUM,
11 lln_id NUMBER := Okl_Api.G_MISS_NUM,
12 lsm_id NUMBER := Okl_Api.G_MISS_NUM,
13 ile_id NUMBER := Okl_Api.G_MISS_NUM,
14 line_number NUMBER := Okl_Api.G_MISS_NUM,
15 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
16 amount NUMBER := Okl_Api.G_MISS_NUM,
17 request_id NUMBER := Okl_Api.G_MISS_NUM,
18 program_application_id NUMBER := Okl_Api.G_MISS_NUM,
19 program_id NUMBER := Okl_Api.G_MISS_NUM,
20 program_update_date OKL_TXL_RCPT_APPS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
21 org_id NUMBER := Okl_Api.G_MISS_NUM,
22 attribute_category OKL_TXL_RCPT_APPS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
23 attribute1 OKL_TXL_RCPT_APPS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
24 attribute2 OKL_TXL_RCPT_APPS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
25 attribute3 OKL_TXL_RCPT_APPS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
26 attribute4 OKL_TXL_RCPT_APPS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
27 attribute5 OKL_TXL_RCPT_APPS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
28 attribute6 OKL_TXL_RCPT_APPS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
29 attribute7 OKL_TXL_RCPT_APPS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
30 attribute8 OKL_TXL_RCPT_APPS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
31 attribute9 OKL_TXL_RCPT_APPS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
32 attribute10 OKL_TXL_RCPT_APPS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
33 attribute11 OKL_TXL_RCPT_APPS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
34 attribute12 OKL_TXL_RCPT_APPS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
35 attribute13 OKL_TXL_RCPT_APPS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
36 attribute14 OKL_TXL_RCPT_APPS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
37 attribute15 OKL_TXL_RCPT_APPS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
38 created_by NUMBER := Okl_Api.G_MISS_NUM,
39 creation_date OKL_TXL_RCPT_APPS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
40 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
41 last_update_date OKL_TXL_RCPT_APPS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
42 last_update_login NUMBER := Okl_Api.G_MISS_NUM,
43 -- New column to hold stream type id
44 sty_id NUMBER := Okl_Api.G_MISS_NUM,
45 -- New column to hold ar invoice id
46 ar_invoice_id NUMBER := Okl_Api.G_MISS_NUM );
47 g_miss_rca_rec rca_rec_type;
48 TYPE rca_tbl_type IS TABLE OF rca_rec_type
49 INDEX BY BINARY_INTEGER;
50 TYPE okl_txl_rcpt_apps_tl_rec_type IS RECORD (
51 id NUMBER := Okl_Api.G_MISS_NUM,
52 LANGUAGE OKL_TXL_RCPT_APPS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
53 source_lang OKL_TXL_RCPT_APPS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
54 sfwt_flag OKL_TXL_RCPT_APPS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
55 description OKL_TXL_RCPT_APPS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
56 created_by NUMBER := Okl_Api.G_MISS_NUM,
57 creation_date OKL_TXL_RCPT_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_TXL_RCPT_APPS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
60 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
61 GMissOklTxlRcptAppsTlRec okl_txl_rcpt_apps_tl_rec_type;
62 TYPE okl_txl_rcpt_apps_tl_tbl_type IS TABLE OF okl_txl_rcpt_apps_tl_rec_type
63 INDEX BY BINARY_INTEGER;
64 TYPE rcav_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_TXL_RCPT_APPS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
68 cnr_id NUMBER := Okl_Api.G_MISS_NUM,
69 lln_id NUMBER := Okl_Api.G_MISS_NUM,
70 lsm_id NUMBER := Okl_Api.G_MISS_NUM,
71 khr_id NUMBER := Okl_Api.G_MISS_NUM,
72 ile_id NUMBER := Okl_Api.G_MISS_NUM,
73 rct_id_details NUMBER := Okl_Api.G_MISS_NUM,
74 line_number NUMBER := Okl_Api.G_MISS_NUM,
75 description OKL_TXL_RCPT_APPS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
76 amount NUMBER := Okl_Api.G_MISS_NUM,
77 attribute_category OKL_TXL_RCPT_APPS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
78 attribute1 OKL_TXL_RCPT_APPS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
79 attribute2 OKL_TXL_RCPT_APPS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
80 attribute3 OKL_TXL_RCPT_APPS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
81 attribute4 OKL_TXL_RCPT_APPS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
82 attribute5 OKL_TXL_RCPT_APPS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
83 attribute6 OKL_TXL_RCPT_APPS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
84 attribute7 OKL_TXL_RCPT_APPS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
85 attribute8 OKL_TXL_RCPT_APPS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
86 attribute9 OKL_TXL_RCPT_APPS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
87 attribute10 OKL_TXL_RCPT_APPS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
88 attribute11 OKL_TXL_RCPT_APPS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
89 attribute12 OKL_TXL_RCPT_APPS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
90 attribute13 OKL_TXL_RCPT_APPS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
91 attribute14 OKL_TXL_RCPT_APPS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
92 attribute15 OKL_TXL_RCPT_APPS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
93 request_id NUMBER := Okl_Api.G_MISS_NUM,
94 program_application_id NUMBER := Okl_Api.G_MISS_NUM,
95 program_id NUMBER := Okl_Api.G_MISS_NUM,
96 program_update_date OKL_TXL_RCPT_APPS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
97 org_id NUMBER := Okl_Api.G_MISS_NUM,
98 created_by NUMBER := Okl_Api.G_MISS_NUM,
99 creation_date OKL_TXL_RCPT_APPS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
100 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
101 last_update_date OKL_TXL_RCPT_APPS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
102 last_update_login NUMBER := Okl_Api.G_MISS_NUM,
103 -- New column to hold stream type id
104 sty_id NUMBER := Okl_Api.G_MISS_NUM,
105 -- New column to hold ar invoice id
106 ar_invoice_id NUMBER := Okl_Api.G_MISS_NUM );
107 g_miss_rcav_rec rcav_rec_type;
108 TYPE rcav_tbl_type IS TABLE OF rcav_rec_type
109 INDEX BY BINARY_INTEGER;
110 ---------------------------------------------------------------------------
111 -- GLOBAL MESSAGE CONSTANTS
112 ---------------------------------------------------------------------------
113 G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
114 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
115 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
116 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
117 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
118 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
119 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
120 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
121 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
122 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
123 ---------------------------------------------------------------------------
124 -- GLOBAL VARIABLES
125 ---------------------------------------------------------------------------
126 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RCA_PVT';
127 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
128
129 ---------------------------------------------------------------------------
130 -- ADDED AFTER TAPI 04/17/2001
131 ---------------------------------------------------------------------------
132 ---------------------------------------------------------------------------
133 -- GLOBAL MESSAGES
134 ---------------------------------------------------------------------------
135 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
136 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
137 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
138 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
139
140 ---------------------------------------------------------------------------
141 -- GLOBAL VARIABLES
142 ---------------------------------------------------------------------------
143 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_TRX_AR_INVOICES_V';
144 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
145
146 ---------------------------------------------------------------------------
147 -- POST TAPI GENERATION CODE ENDS HERE.
148 ---------------------------------------------------------------------------
149
150 ---------------------------------------------------------------------------
151 -- Procedures and Functions
152 ---------------------------------------------------------------------------
153
154 PROCEDURE qc;
155 PROCEDURE change_version;
156 PROCEDURE api_copy;
157 PROCEDURE add_language;
158 PROCEDURE insert_row(
159 p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 p_rcav_rec IN rcav_rec_type,
165 x_rcav_rec OUT NOCOPY rcav_rec_type);
166
167 PROCEDURE insert_row(
168 p_api_version IN NUMBER,
169 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2,
173 p_rcav_tbl IN rcav_tbl_type,
174 x_rcav_tbl OUT NOCOPY rcav_tbl_type);
175
176 PROCEDURE lock_row(
177 p_api_version IN NUMBER,
178 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
179 x_return_status OUT NOCOPY VARCHAR2,
180 x_msg_count OUT NOCOPY NUMBER,
181 x_msg_data OUT NOCOPY VARCHAR2,
182 p_rcav_rec IN rcav_rec_type);
183
184 PROCEDURE lock_row(
185 p_api_version IN NUMBER,
186 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2,
190 p_rcav_tbl IN rcav_tbl_type);
191
192 PROCEDURE update_row(
193 p_api_version IN NUMBER,
194 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2,
198 p_rcav_rec IN rcav_rec_type,
199 x_rcav_rec OUT NOCOPY rcav_rec_type);
200
201 PROCEDURE update_row(
202 p_api_version IN NUMBER,
203 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2,
207 p_rcav_tbl IN rcav_tbl_type,
208 x_rcav_tbl OUT NOCOPY rcav_tbl_type);
209
210 PROCEDURE delete_row(
211 p_api_version IN NUMBER,
212 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
213 x_return_status OUT NOCOPY VARCHAR2,
214 x_msg_count OUT NOCOPY NUMBER,
215 x_msg_data OUT NOCOPY VARCHAR2,
216 p_rcav_rec IN rcav_rec_type);
217
218 PROCEDURE delete_row(
219 p_api_version IN NUMBER,
220 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
221 x_return_status OUT NOCOPY VARCHAR2,
222 x_msg_count OUT NOCOPY NUMBER,
223 x_msg_data OUT NOCOPY VARCHAR2,
224 p_rcav_tbl IN rcav_tbl_type);
225
226 PROCEDURE validate_row(
227 p_api_version IN NUMBER,
228 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
229 x_return_status OUT NOCOPY VARCHAR2,
230 x_msg_count OUT NOCOPY NUMBER,
231 x_msg_data OUT NOCOPY VARCHAR2,
232 p_rcav_rec IN rcav_rec_type);
233
234 PROCEDURE validate_row(
235 p_api_version IN NUMBER,
236 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
237 x_return_status OUT NOCOPY VARCHAR2,
238 x_msg_count OUT NOCOPY NUMBER,
239 x_msg_data OUT NOCOPY VARCHAR2,
240 p_rcav_tbl IN rcav_tbl_type);
241
242
243 -- Procedure to merge customer id
244 PROCEDURE OKL_RCA_PARTY_MERGE(
245 p_entity_name IN VARCHAR2,
246 p_from_id IN NUMBER,
247 x_to_id OUT NOCOPY NUMBER,
248 p_from_fk_id IN NUMBER,
249 p_to_fk_id IN NUMBER,
250 p_parent_entity_name IN VARCHAR2,
251 p_batch_id IN NUMBER,
252 p_batch_party_id IN NUMBER,
253 x_return_status OUT NOCOPY VARCHAR2);
254
255 END Okl_Rca_Pvt;