[Home] [Help]
PACKAGE: APPS.OKL_DRA_PVT
Source
1 PACKAGE OKL_DRA_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSDRAS.pls 120.2 2007/04/30 22:58:00 cklee noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_DISB_RULES_V Record Spec
7 TYPE drav_rec_type IS RECORD (
8 disb_rule_id NUMBER
9 ,object_version_number NUMBER
10 ,sfwt_flag OKL_DISB_RULES_V.SFWT_FLAG%TYPE
11 ,rule_name OKL_DISB_RULES_V.RULE_NAME%TYPE
12 ,org_id NUMBER
13 ,start_date OKL_DISB_RULES_V.START_DATE%TYPE
14 ,end_date OKL_DISB_RULES_V.END_DATE%TYPE
15 ,fee_option OKL_DISB_RULES_V.FEE_OPTION%TYPE
16 ,fee_basis OKL_DISB_RULES_V.FEE_BASIS%TYPE
17 ,fee_amount NUMBER
18 ,fee_percent NUMBER
19 ,consolidate_by_due_date OKL_DISB_RULES_V.CONSOLIDATE_BY_DUE_DATE%TYPE
20 ,frequency OKL_DISB_RULES_V.FREQUENCY%TYPE
21 ,day_of_month NUMBER
22 ,scheduled_month OKL_DISB_RULES_V.SCHEDULED_MONTH%TYPE
23 ,consolidate_strm_type OKL_DISB_RULES_V.CONSOLIDATE_STRM_TYPE%TYPE
24 ,description OKL_DISB_RULES_V.DESCRIPTION%TYPE
25 ,attribute_category OKL_DISB_RULES_V.ATTRIBUTE_CATEGORY%TYPE
26 ,attribute1 OKL_DISB_RULES_V.ATTRIBUTE1%TYPE
27 ,attribute2 OKL_DISB_RULES_V.ATTRIBUTE2%TYPE
28 ,attribute3 OKL_DISB_RULES_V.ATTRIBUTE3%TYPE
29 ,attribute4 OKL_DISB_RULES_V.ATTRIBUTE4%TYPE
30 ,attribute5 OKL_DISB_RULES_V.ATTRIBUTE5%TYPE
31 ,attribute6 OKL_DISB_RULES_V.ATTRIBUTE6%TYPE
32 ,attribute7 OKL_DISB_RULES_V.ATTRIBUTE7%TYPE
33 ,attribute8 OKL_DISB_RULES_V.ATTRIBUTE8%TYPE
34 ,attribute9 OKL_DISB_RULES_V.ATTRIBUTE9%TYPE
35 ,attribute10 OKL_DISB_RULES_V.ATTRIBUTE10%TYPE
36 ,attribute11 OKL_DISB_RULES_V.ATTRIBUTE11%TYPE
37 ,attribute12 OKL_DISB_RULES_V.ATTRIBUTE12%TYPE
38 ,attribute13 OKL_DISB_RULES_V.ATTRIBUTE13%TYPE
39 ,attribute14 OKL_DISB_RULES_V.ATTRIBUTE14%TYPE
40 ,attribute15 OKL_DISB_RULES_V.ATTRIBUTE15%TYPE
41 ,created_by NUMBER
42 ,creation_date OKL_DISB_RULES_V.CREATION_DATE%TYPE
43 ,last_updated_by NUMBER
44 ,last_update_date OKL_DISB_RULES_V.LAST_UPDATE_DATE%TYPE
45 ,last_update_login NUMBER);
46 G_MISS_drav_rec drav_rec_type;
47 TYPE drav_tbl_type IS TABLE OF drav_rec_type
48 INDEX BY BINARY_INTEGER;
49 -- OKL_DISB_RULES_TL Record Spec
50 TYPE okl_disb_rules_tl_rec_type IS RECORD (
51 disb_rule_id NUMBER
52 ,language OKL_DISB_RULES_TL.LANGUAGE%TYPE
53 ,source_lang OKL_DISB_RULES_TL.SOURCE_LANG%TYPE
54 ,sfwt_flag OKL_DISB_RULES_TL.SFWT_FLAG%TYPE
55 ,description OKL_DISB_RULES_TL.DESCRIPTION%TYPE
56 ,created_by NUMBER
57 ,creation_date OKL_DISB_RULES_TL.CREATION_DATE%TYPE
58 ,last_updated_by NUMBER
59 ,last_update_date OKL_DISB_RULES_TL.LAST_UPDATE_DATE%TYPE
60 ,last_update_login NUMBER);
61 G_MISS_okl_disb_rules_tl_rec okl_disb_rules_tl_rec_type;
62 TYPE okl_disb_rules_tl_tbl_type IS TABLE OF okl_disb_rules_tl_rec_type
63 INDEX BY BINARY_INTEGER;
64 -- OKL_DISB_RULES_ALL_B Record Spec
65 TYPE dra_rec_type IS RECORD (
66 disb_rule_id NUMBER
67 ,object_version_number NUMBER
68 ,rule_name OKL_DISB_RULES_ALL_B.RULE_NAME%TYPE
69 ,org_id NUMBER
70 ,start_date OKL_DISB_RULES_ALL_B.START_DATE%TYPE
71 ,end_date OKL_DISB_RULES_ALL_B.END_DATE%TYPE
72 ,fee_option OKL_DISB_RULES_ALL_B.FEE_OPTION%TYPE
73 ,fee_basis OKL_DISB_RULES_ALL_B.FEE_BASIS%TYPE
74 ,fee_amount NUMBER
75 ,fee_percent NUMBER
76 ,consolidate_by_due_date OKL_DISB_RULES_ALL_B.CONSOLIDATE_BY_DUE_DATE%TYPE
77 ,frequency OKL_DISB_RULES_ALL_B.FREQUENCY%TYPE
78 ,day_of_month NUMBER
79 ,scheduled_month OKL_DISB_RULES_ALL_B.SCHEDULED_MONTH%TYPE
80 ,consolidate_strm_type OKL_DISB_RULES_ALL_B.CONSOLIDATE_STRM_TYPE%TYPE
81 ,attribute_category OKL_DISB_RULES_ALL_B.ATTRIBUTE_CATEGORY%TYPE
82 ,attribute1 OKL_DISB_RULES_ALL_B.ATTRIBUTE1%TYPE
83 ,attribute2 OKL_DISB_RULES_ALL_B.ATTRIBUTE2%TYPE
84 ,attribute3 OKL_DISB_RULES_ALL_B.ATTRIBUTE3%TYPE
85 ,attribute4 OKL_DISB_RULES_ALL_B.ATTRIBUTE4%TYPE
86 ,attribute5 OKL_DISB_RULES_ALL_B.ATTRIBUTE5%TYPE
87 ,attribute6 OKL_DISB_RULES_ALL_B.ATTRIBUTE6%TYPE
88 ,attribute7 OKL_DISB_RULES_ALL_B.ATTRIBUTE7%TYPE
89 ,attribute8 OKL_DISB_RULES_ALL_B.ATTRIBUTE8%TYPE
90 ,attribute9 OKL_DISB_RULES_ALL_B.ATTRIBUTE9%TYPE
91 ,attribute10 OKL_DISB_RULES_ALL_B.ATTRIBUTE10%TYPE
92 ,attribute11 OKL_DISB_RULES_ALL_B.ATTRIBUTE11%TYPE
93 ,attribute12 OKL_DISB_RULES_ALL_B.ATTRIBUTE12%TYPE
94 ,attribute13 OKL_DISB_RULES_ALL_B.ATTRIBUTE13%TYPE
95 ,attribute14 OKL_DISB_RULES_ALL_B.ATTRIBUTE14%TYPE
96 ,attribute15 OKL_DISB_RULES_ALL_B.ATTRIBUTE15%TYPE
97 ,created_by NUMBER
98 ,creation_date OKL_DISB_RULES_ALL_B.CREATION_DATE%TYPE
99 ,last_updated_by NUMBER
100 ,last_update_date OKL_DISB_RULES_ALL_B.LAST_UPDATE_DATE%TYPE
101 ,last_update_login NUMBER);
102 G_MISS_dra_rec dra_rec_type;
103 TYPE dra_tbl_type IS TABLE OF dra_rec_type
104 INDEX BY BINARY_INTEGER;
105 ---------------------------------------------------------------------------
106 -- GLOBAL MESSAGE CONSTANTS
107 ---------------------------------------------------------------------------
108 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
109 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
110 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
111 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
112 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
113 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
114 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
115 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
116 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
117 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
118 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
119 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
120 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
121
122 ---------------------------------------------------------------------------
123 -- GLOBAL EXCEPTIONS
124 ---------------------------------------------------------------------------
125 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
126
127 ---------------------------------------------------------------------------
128 -- GLOBAL VARIABLES
129 ---------------------------------------------------------------------------
130 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_DRA_PVT';
131 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
132 ---------------------------------------------------------------------------
133 -- Procedures and Functions
134 ---------------------------------------------------------------------------
135
136 PROCEDURE qc;
137 PROCEDURE change_version;
138 PROCEDURE api_copy;
139 PROCEDURE add_language;
140 PROCEDURE insert_row(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 p_drav_rec IN drav_rec_type,
147 x_drav_rec OUT NOCOPY drav_rec_type);
148 PROCEDURE insert_row(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154 p_drav_tbl IN drav_tbl_type,
155 x_drav_tbl OUT NOCOPY drav_tbl_type,
156 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
157 PROCEDURE insert_row(
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163 p_drav_tbl IN drav_tbl_type,
164 x_drav_tbl OUT NOCOPY drav_tbl_type);
165 PROCEDURE lock_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_drav_rec IN drav_rec_type);
172 PROCEDURE lock_row(
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 p_drav_tbl IN drav_tbl_type,
179 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
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_drav_tbl IN drav_tbl_type);
187 PROCEDURE update_row(
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_drav_rec IN drav_rec_type,
194 x_drav_rec OUT NOCOPY drav_rec_type);
195 PROCEDURE update_row(
196 p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201 p_drav_tbl IN drav_tbl_type,
202 x_drav_tbl OUT NOCOPY drav_tbl_type,
203 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
204 PROCEDURE update_row(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
207 x_return_status OUT NOCOPY VARCHAR2,
208 x_msg_count OUT NOCOPY NUMBER,
209 x_msg_data OUT NOCOPY VARCHAR2,
210 p_drav_tbl IN drav_tbl_type,
211 x_drav_tbl OUT NOCOPY drav_tbl_type);
212 PROCEDURE delete_row(
213 p_api_version IN NUMBER,
214 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
215 x_return_status OUT NOCOPY VARCHAR2,
216 x_msg_count OUT NOCOPY NUMBER,
217 x_msg_data OUT NOCOPY VARCHAR2,
218 p_drav_rec IN drav_rec_type);
219 PROCEDURE delete_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_drav_tbl IN drav_tbl_type,
226 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
227 PROCEDURE delete_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_drav_tbl IN drav_tbl_type);
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_drav_rec IN drav_rec_type);
241 PROCEDURE validate_row(
242 p_api_version IN NUMBER,
243 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
244 x_return_status OUT NOCOPY VARCHAR2,
245 x_msg_count OUT NOCOPY NUMBER,
246 x_msg_data OUT NOCOPY VARCHAR2,
247 p_drav_tbl IN drav_tbl_type,
248 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
249 PROCEDURE validate_row(
250 p_api_version IN NUMBER,
251 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
252 x_return_status OUT NOCOPY VARCHAR2,
253 x_msg_count OUT NOCOPY NUMBER,
254 x_msg_data OUT NOCOPY VARCHAR2,
255 p_drav_tbl IN drav_tbl_type);
256 END OKL_DRA_PVT;