[Home] [Help]
PACKAGE: APPS.OKL_CRT_PVT
Source
1 PACKAGE OKL_CRT_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSCRTS.pls 120.2 2006/07/11 10:18:49 dkagrawa noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_CURE_REPORTS_V Record Spec
7 TYPE crtv_rec_type IS RECORD (
8 cure_report_id NUMBER := OKL_API.G_MISS_NUM
9 ,report_number OKL_CURE_REPORTS.REPORT_NUMBER%TYPE := OKL_API.G_MISS_CHAR
10 ,report_type OKL_CURE_REPORTS.REPORT_TYPE%TYPE := OKL_API.G_MISS_CHAR
11 ,report_date OKL_CURE_REPORTS.REPORT_DATE%TYPE := OKL_API.G_MISS_DATE
12 ,vendor_id NUMBER := OKL_API.G_MISS_NUM
13 ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
14 ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM
15 ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR
16 ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR
17 ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE
18 ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
19 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
20 ,org_id NUMBER := OKL_API.G_MISS_NUM
21 ,request_id NUMBER := OKL_API.G_MISS_NUM
22 ,program_application_id NUMBER := OKL_API.G_MISS_NUM
23 ,program_id NUMBER := OKL_API.G_MISS_NUM
24 ,program_update_date OKL_CURE_REPORTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
25 ,attribute_category OKL_CURE_REPORTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
26 ,attribute1 OKL_CURE_REPORTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
27 ,attribute2 OKL_CURE_REPORTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
28 ,attribute3 OKL_CURE_REPORTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
29 ,attribute4 OKL_CURE_REPORTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
30 ,attribute5 OKL_CURE_REPORTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
31 ,attribute6 OKL_CURE_REPORTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
32 ,attribute7 OKL_CURE_REPORTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
33 ,attribute8 OKL_CURE_REPORTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
34 ,attribute9 OKL_CURE_REPORTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
35 ,attribute10 OKL_CURE_REPORTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
36 ,attribute11 OKL_CURE_REPORTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
37 ,attribute12 OKL_CURE_REPORTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
38 ,attribute13 OKL_CURE_REPORTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
39 ,attribute14 OKL_CURE_REPORTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
40 ,attribute15 OKL_CURE_REPORTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
41 ,created_by NUMBER := OKL_API.G_MISS_NUM
42 ,creation_date OKL_CURE_REPORTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
43 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
44 ,last_update_date OKL_CURE_REPORTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
45 ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
46 G_MISS_crtv_rec crtv_rec_type;
47 TYPE crtv_tbl_type IS TABLE OF crtv_rec_type
48 INDEX BY BINARY_INTEGER;
49 -- OKL_CURE_REPORTS Record Spec
50 TYPE crt_rec_type IS RECORD (
51 cure_report_id NUMBER := OKL_API.G_MISS_NUM
52 ,report_number OKL_CURE_REPORTS.REPORT_NUMBER%TYPE := OKL_API.G_MISS_CHAR
53 ,report_type OKL_CURE_REPORTS.REPORT_TYPE%TYPE := OKL_API.G_MISS_CHAR
54 ,report_date OKL_CURE_REPORTS.REPORT_DATE%TYPE := OKL_API.G_MISS_DATE
55 ,vendor_id NUMBER := OKL_API.G_MISS_NUM
56 ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
57 ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM
58 ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR
59 ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR
60 ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE
61 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
62 ,org_id NUMBER := OKL_API.G_MISS_NUM
63 ,request_id NUMBER := OKL_API.G_MISS_NUM
64 ,program_application_id NUMBER := OKL_API.G_MISS_NUM
65 ,program_id NUMBER := OKL_API.G_MISS_NUM
66 ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
67 ,program_update_date OKL_CURE_REPORTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
68 ,attribute_category OKL_CURE_REPORTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
69 ,attribute1 OKL_CURE_REPORTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
70 ,attribute2 OKL_CURE_REPORTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
71 ,attribute3 OKL_CURE_REPORTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
72 ,attribute4 OKL_CURE_REPORTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
73 ,attribute5 OKL_CURE_REPORTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
74 ,attribute6 OKL_CURE_REPORTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
75 ,attribute7 OKL_CURE_REPORTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
76 ,attribute8 OKL_CURE_REPORTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
77 ,attribute9 OKL_CURE_REPORTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
78 ,attribute10 OKL_CURE_REPORTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
79 ,attribute11 OKL_CURE_REPORTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
80 ,attribute12 OKL_CURE_REPORTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
81 ,attribute13 OKL_CURE_REPORTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
82 ,attribute14 OKL_CURE_REPORTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
83 ,attribute15 OKL_CURE_REPORTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
84 ,created_by NUMBER := OKL_API.G_MISS_NUM
85 ,creation_date OKL_CURE_REPORTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
86 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
87 ,last_update_date OKL_CURE_REPORTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
88 ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
89 G_MISS_crt_rec crt_rec_type;
90 TYPE crt_tbl_type IS TABLE OF crt_rec_type
91 INDEX BY BINARY_INTEGER;
92 ---------------------------------------------------------------------------
93 -- GLOBAL MESSAGE CONSTANTS
94 ---------------------------------------------------------------------------
95 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
96 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
97 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
98 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
99 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
100 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
101 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
102 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
103 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
104 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
105 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
106 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
107 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
108
109 ---------------------------------------------------------------------------
110 -- GLOBAL EXCEPTIONS
111 ---------------------------------------------------------------------------
112 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
113
114 ---------------------------------------------------------------------------
115 -- GLOBAL VARIABLES
116 ---------------------------------------------------------------------------
117 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CRT_PVT';
118 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
119 ---------------------------------------------------------------------------
120 -- Procedures and Functions
121 ---------------------------------------------------------------------------
122
123 PROCEDURE qc;
124 PROCEDURE change_version;
125 PROCEDURE api_copy;
126 PROCEDURE insert_row(
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 p_crtv_rec IN crtv_rec_type,
133 x_crtv_rec OUT NOCOPY crtv_rec_type);
134 PROCEDURE insert_row(
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_crtv_tbl IN crtv_tbl_type,
141 x_crtv_tbl OUT NOCOPY crtv_tbl_type,
142 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
143 PROCEDURE insert_row(
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 p_crtv_tbl IN crtv_tbl_type,
150 x_crtv_tbl OUT NOCOPY crtv_tbl_type);
151 PROCEDURE lock_row(
152 p_api_version IN NUMBER,
153 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
154 x_return_status OUT NOCOPY VARCHAR2,
155 x_msg_count OUT NOCOPY NUMBER,
156 x_msg_data OUT NOCOPY VARCHAR2,
157 p_crtv_rec IN crtv_rec_type);
158 PROCEDURE lock_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_crtv_tbl IN crtv_tbl_type,
165 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
166 PROCEDURE lock_row(
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172 p_crtv_tbl IN crtv_tbl_type);
173 PROCEDURE update_row(
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 p_crtv_rec IN crtv_rec_type,
180 x_crtv_rec OUT NOCOPY crtv_rec_type);
181 PROCEDURE update_row(
182 p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2,
187 p_crtv_tbl IN crtv_tbl_type,
188 x_crtv_tbl OUT NOCOPY crtv_tbl_type,
189 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
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_crtv_tbl IN crtv_tbl_type,
197 x_crtv_tbl OUT NOCOPY crtv_tbl_type);
198 PROCEDURE delete_row(
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 p_crtv_rec IN crtv_rec_type);
205 PROCEDURE delete_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_crtv_tbl IN crtv_tbl_type,
212 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
213 PROCEDURE delete_row(
214 p_api_version IN NUMBER,
215 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
216 x_return_status OUT NOCOPY VARCHAR2,
217 x_msg_count OUT NOCOPY NUMBER,
218 x_msg_data OUT NOCOPY VARCHAR2,
219 p_crtv_tbl IN crtv_tbl_type);
220 PROCEDURE validate_row(
221 p_api_version IN NUMBER,
222 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2,
226 p_crtv_rec IN crtv_rec_type);
227 PROCEDURE validate_row(
228 p_api_version IN NUMBER,
229 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
230 x_return_status OUT NOCOPY VARCHAR2,
231 x_msg_count OUT NOCOPY NUMBER,
232 x_msg_data OUT NOCOPY VARCHAR2,
233 p_crtv_tbl IN crtv_tbl_type,
234 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
235 PROCEDURE validate_row(
236 p_api_version IN NUMBER,
237 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
238 x_return_status OUT NOCOPY VARCHAR2,
239 x_msg_count OUT NOCOPY NUMBER,
240 x_msg_data OUT NOCOPY VARCHAR2,
241 p_crtv_tbl IN crtv_tbl_type);
242 END OKL_CRT_PVT;