[Home] [Help]
PACKAGE: APPS.OKL_XLP_PVT
Source
1 Package OKL_XLP_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSXLPS.pls 115.3 2002/08/16 00:19:08 stmathew noship $ */
3 ---------------------------------------------------------------------------
4 -- PostGen --
5 -- SPEC:
6 -- 0. Global Messages (5) and Variables (2) = Done!
7 -- BODY:
8 -- 1. Check for Not Null Primary Keys
9 -- 2. Check for Not Null Foreign Keys
10 -- 5. Validity of Foreign Keys, where applicable
11 -- 4. Validity of Unique Keys, where applicable
12 -- 3. Validity of Org_id, where applicable
13 -- 6. Added domain validation, where applicable
14 -- 7. Added the Concurrent Manager Columns ( p104 )
15 -- 8. Any lookup code should be validated using the OKL_UTIL package.
16 ---------------------------------------------------------------------------
17 -- GLOBAL DATASTRUCTURES
18 ---------------------------------------------------------------------------
19 TYPE xlp_rec_type IS RECORD (
20 id NUMBER := OKL_API.G_MISS_NUM,
21 xpi_id_details NUMBER := OKL_API.G_MISS_NUM,
22 pid_id NUMBER := OKL_API.G_MISS_NUM,
23 ibi_id NUMBER := OKL_API.G_MISS_NUM,
24 tpl_id NUMBER := OKL_API.G_MISS_NUM,
25 tap_id NUMBER := OKL_API.G_MISS_NUM,
26 object_version_number NUMBER := OKL_API.G_MISS_NUM,
27 invoice_line_id NUMBER := OKL_API.G_MISS_NUM,
28 line_number NUMBER := OKL_API.G_MISS_NUM,
29 line_type OKL_XTL_PAY_INVS_B.LINE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
30 amount NUMBER := OKL_API.G_MISS_NUM,
31 accounting_date OKL_XTL_PAY_INVS_B.ACCOUNTING_DATE%TYPE := OKL_API.G_MISS_DATE,
32 dist_code_combination_id NUMBER := OKL_API.G_MISS_NUM,
33 tax_code OKL_XTL_PAY_INVS_B.TAX_CODE%TYPE := OKL_API.G_MISS_CHAR,
34 request_id NUMBER := OKL_API.G_MISS_NUM,
35 program_application_id NUMBER := OKL_API.G_MISS_NUM,
36 program_id NUMBER := OKL_API.G_MISS_NUM,
37 program_update_date OKL_XTL_PAY_INVS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
38 org_id NUMBER := OKL_API.G_MISS_NUM,
39 attribute_category OKL_XTL_PAY_INVS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
40 attribute1 OKL_XTL_PAY_INVS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
41 attribute2 OKL_XTL_PAY_INVS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
42 attribute3 OKL_XTL_PAY_INVS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
43 attribute4 OKL_XTL_PAY_INVS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
44 attribute5 OKL_XTL_PAY_INVS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
45 attribute6 OKL_XTL_PAY_INVS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
46 attribute7 OKL_XTL_PAY_INVS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
47 attribute8 OKL_XTL_PAY_INVS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
48 attribute9 OKL_XTL_PAY_INVS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
49 attribute10 OKL_XTL_PAY_INVS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
50 attribute11 OKL_XTL_PAY_INVS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
51 attribute12 OKL_XTL_PAY_INVS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
52 attribute13 OKL_XTL_PAY_INVS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
53 attribute14 OKL_XTL_PAY_INVS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
54 attribute15 OKL_XTL_PAY_INVS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
55 created_by NUMBER := OKL_API.G_MISS_NUM,
56 creation_date OKL_XTL_PAY_INVS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
57 last_updated_by NUMBER := OKL_API.G_MISS_NUM,
58 last_update_date OKL_XTL_PAY_INVS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
59 last_update_login NUMBER := OKL_API.G_MISS_NUM);
60 g_miss_xlp_rec xlp_rec_type;
61 TYPE xlp_tbl_type IS TABLE OF xlp_rec_type
62 INDEX BY BINARY_INTEGER;
63 TYPE okl_xtl_pay_invs_tl_rec_type IS RECORD (
64 id NUMBER := OKL_API.G_MISS_NUM,
65 language OKL_XTL_PAY_INVS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR,
66 source_lang OKL_XTL_PAY_INVS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR,
67 sfwt_flag OKL_XTL_PAY_INVS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
68 description OKL_XTL_PAY_INVS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
69 stream_type OKL_XTL_PAY_INVS_TL.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
70 created_by NUMBER := OKL_API.G_MISS_NUM,
71 creation_date OKL_XTL_PAY_INVS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
72 last_updated_by NUMBER := OKL_API.G_MISS_NUM,
73 last_update_date OKL_XTL_PAY_INVS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
74 last_update_login NUMBER := OKL_API.G_MISS_NUM);
75 g_miss_okl_xtl_pay_invs_tl_rec okl_xtl_pay_invs_tl_rec_type;
76 TYPE okl_xtl_pay_invs_tl_tbl_type IS TABLE OF okl_xtl_pay_invs_tl_rec_type
77 INDEX BY BINARY_INTEGER;
78 TYPE xlpv_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_XTL_PAY_INVS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
82 tpl_id NUMBER := OKL_API.G_MISS_NUM,
83 tap_id NUMBER := OKL_API.G_MISS_NUM,
84 pid_id NUMBER := OKL_API.G_MISS_NUM,
85 ibi_id NUMBER := OKL_API.G_MISS_NUM,
86 xpi_id_details NUMBER := OKL_API.G_MISS_NUM,
87 invoice_line_id NUMBER := OKL_API.G_MISS_NUM,
88 line_number NUMBER := OKL_API.G_MISS_NUM,
89 line_type OKL_XTL_PAY_INVS_V.LINE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
90 amount NUMBER := OKL_API.G_MISS_NUM,
91 accounting_date OKL_XTL_PAY_INVS_V.ACCOUNTING_DATE%TYPE := OKL_API.G_MISS_DATE,
92 description OKL_XTL_PAY_INVS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
93 dist_code_combination_id NUMBER := OKL_API.G_MISS_NUM,
94 tax_code OKL_XTL_PAY_INVS_V.TAX_CODE%TYPE := OKL_API.G_MISS_CHAR,
95 stream_type OKL_XTL_PAY_INVS_V.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
96 attribute_category OKL_XTL_PAY_INVS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
97 attribute1 OKL_XTL_PAY_INVS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
98 attribute2 OKL_XTL_PAY_INVS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
99 attribute3 OKL_XTL_PAY_INVS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
100 attribute4 OKL_XTL_PAY_INVS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
101 attribute5 OKL_XTL_PAY_INVS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
102 attribute6 OKL_XTL_PAY_INVS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
103 attribute7 OKL_XTL_PAY_INVS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
104 attribute8 OKL_XTL_PAY_INVS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
105 attribute9 OKL_XTL_PAY_INVS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
106 attribute10 OKL_XTL_PAY_INVS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
107 attribute11 OKL_XTL_PAY_INVS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
111 attribute15 OKL_XTL_PAY_INVS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
108 attribute12 OKL_XTL_PAY_INVS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
109 attribute13 OKL_XTL_PAY_INVS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
110 attribute14 OKL_XTL_PAY_INVS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
112 request_id NUMBER := OKL_API.G_MISS_NUM,
113 program_application_id NUMBER := OKL_API.G_MISS_NUM,
114 program_id NUMBER := OKL_API.G_MISS_NUM,
115 program_update_date OKL_XTL_PAY_INVS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
116 org_id NUMBER := OKL_API.G_MISS_NUM,
117 created_by NUMBER := OKL_API.G_MISS_NUM,
118 creation_date OKL_XTL_PAY_INVS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
119 last_updated_by NUMBER := OKL_API.G_MISS_NUM,
120 last_update_date OKL_XTL_PAY_INVS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
121 last_update_login NUMBER := OKL_API.G_MISS_NUM);
122 g_miss_xlpv_rec xlpv_rec_type;
123 TYPE xlpv_tbl_type IS TABLE OF xlpv_rec_type
124 INDEX BY BINARY_INTEGER;
125 ---------------------------------------------------------------------------
126 -- GLOBAL MESSAGE CONSTANTS
127 ---------------------------------------------------------------------------
128 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
129 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
130 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
131 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
132 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
133 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
134 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
135 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
136 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
137 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
138 -- PostGen-Begin-0
139 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :='OKL_UNEXPECTED_ERROR';
140 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) :='OKL_NO_PARENT_RECORD';
141 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) :='ERROR_MESSAGE';
142 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) :='ERROR_CODE';
143 G_NOT_SAME CONSTANT VARCHAR2(200) :='OKL_CANNOT_BE_SAME';
144 -- PostGen-End-0
145 ---------------------------------------------------------------------------
146 -- GLOBAL VARIABLES
147 ---------------------------------------------------------------------------
148 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_XLP_PVT';
149 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
150 -- Post-Gen Begin-0
151 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_XTL_PAY_INVS_V';
152 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
153 -- Post-Gen End-0
154 ---------------------------------------------------------------------------
155 -- Procedures and Functions
159 PROCEDURE change_version;
156 ---------------------------------------------------------------------------
157
158 PROCEDURE qc;
160 PROCEDURE api_copy;
161 PROCEDURE add_language;
162 PROCEDURE insert_row(
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_xlpv_rec IN xlpv_rec_type,
169 x_xlpv_rec OUT NOCOPY xlpv_rec_type);
170
171 PROCEDURE insert_row(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_xlpv_tbl IN xlpv_tbl_type,
178 x_xlpv_tbl OUT NOCOPY xlpv_tbl_type);
179
180 PROCEDURE lock_row(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 p_xlpv_rec IN xlpv_rec_type);
187
188 PROCEDURE lock_row(
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 x_msg_data OUT NOCOPY VARCHAR2,
194 p_xlpv_tbl IN xlpv_tbl_type);
195
196 PROCEDURE update_row(
197 p_api_version IN NUMBER,
198 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2,
202 p_xlpv_rec IN xlpv_rec_type,
203 x_xlpv_rec OUT NOCOPY xlpv_rec_type);
204
205 PROCEDURE update_row(
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 p_xlpv_tbl IN xlpv_tbl_type,
212 x_xlpv_tbl OUT NOCOPY xlpv_tbl_type);
213
214 PROCEDURE delete_row(
215 p_api_version IN NUMBER,
216 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
217 x_return_status OUT NOCOPY VARCHAR2,
218 x_msg_count OUT NOCOPY NUMBER,
219 x_msg_data OUT NOCOPY VARCHAR2,
220 p_xlpv_rec IN xlpv_rec_type);
221
222 PROCEDURE delete_row(
223 p_api_version IN NUMBER,
224 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
225 x_return_status OUT NOCOPY VARCHAR2,
226 x_msg_count OUT NOCOPY NUMBER,
227 x_msg_data OUT NOCOPY VARCHAR2,
228 p_xlpv_tbl IN xlpv_tbl_type);
229
230 PROCEDURE validate_row(
231 p_api_version IN NUMBER,
232 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
233 x_return_status OUT NOCOPY VARCHAR2,
234 x_msg_count OUT NOCOPY NUMBER,
235 x_msg_data OUT NOCOPY VARCHAR2,
239 p_api_version IN NUMBER,
236 p_xlpv_rec IN xlpv_rec_type);
237
238 PROCEDURE validate_row(
240 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
241 x_return_status OUT NOCOPY VARCHAR2,
242 x_msg_count OUT NOCOPY NUMBER,
243 x_msg_data OUT NOCOPY VARCHAR2,
244 p_xlpv_tbl IN xlpv_tbl_type);
245
246 END OKL_XLP_PVT;