[Home] [Help]
PACKAGE: APPS.IEX_IEH_PVT
Source
1 PACKAGE IEX_IEH_PVT AUTHID CURRENT_USER AS
2 /* $Header: IEXSIEHS.pls 120.0 2004/01/24 03:16:16 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
8 exclusion_history_id NUMBER := OKC_API.G_MISS_NUM
5 ---------------------------------------------------------------------------
6 -- IEX_EXCLUSION_HIST_V Record Spec
7 TYPE iehv_rec_type IS RECORD (
9 ,object1_id1 IEX_EXCLUSION_HIST_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
10 ,object1_id2 IEX_EXCLUSION_HIST_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
11 ,jtot_object1_code IEX_EXCLUSION_HIST_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
12 ,exclusion_reason IEX_EXCLUSION_HIST_V.EXCLUSION_REASON%TYPE := OKC_API.G_MISS_CHAR
13 ,effective_start_date IEX_EXCLUSION_HIST_V.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
14 ,effective_end_date IEX_EXCLUSION_HIST_V.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
15 ,cancel_reason IEX_EXCLUSION_HIST_V.CANCEL_REASON%TYPE := OKC_API.G_MISS_CHAR
16 ,cancelled_date IEX_EXCLUSION_HIST_V.CANCELLED_DATE%TYPE := OKC_API.G_MISS_DATE
17 ,exclusion_comment IEX_EXCLUSION_HIST_V.EXCLUSION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
18 ,cancellation_comment IEX_EXCLUSION_HIST_V.CANCELLATION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
19 ,language IEX_EXCLUSION_HIST_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
20 ,source_lang IEX_EXCLUSION_HIST_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
21 ,sfwt_flag IEX_EXCLUSION_HIST_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
22 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
23 ,org_id NUMBER := OKC_API.G_MISS_NUM
24 ,attribute_category IEX_EXCLUSION_HIST_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
25 ,attribute1 IEX_EXCLUSION_HIST_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
26 ,attribute2 IEX_EXCLUSION_HIST_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
27 ,attribute3 IEX_EXCLUSION_HIST_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
28 ,attribute4 IEX_EXCLUSION_HIST_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
29 ,attribute5 IEX_EXCLUSION_HIST_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
30 ,attribute6 IEX_EXCLUSION_HIST_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
31 ,attribute7 IEX_EXCLUSION_HIST_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
32 ,attribute8 IEX_EXCLUSION_HIST_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
33 ,attribute9 IEX_EXCLUSION_HIST_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
34 ,attribute10 IEX_EXCLUSION_HIST_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
35 ,attribute11 IEX_EXCLUSION_HIST_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
36 ,attribute12 IEX_EXCLUSION_HIST_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
37 ,attribute13 IEX_EXCLUSION_HIST_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
38 ,attribute14 IEX_EXCLUSION_HIST_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
39 ,attribute15 IEX_EXCLUSION_HIST_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
40 ,created_by NUMBER := OKC_API.G_MISS_NUM
41 ,creation_date IEX_EXCLUSION_HIST_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
42 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
43 ,last_update_date IEX_EXCLUSION_HIST_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
44 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
45 G_MISS_iehv_rec iehv_rec_type;
46 TYPE iehv_tbl_type IS TABLE OF iehv_rec_type
47 INDEX BY BINARY_INTEGER;
48 -- IEX_EXCLUSION_HIST_TL Record Spec
49 TYPE ieht_rec_type IS RECORD (
50 exclusion_history_id NUMBER := OKC_API.G_MISS_NUM
51 ,exclusion_comment IEX_EXCLUSION_HIST_TL.EXCLUSION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
52 ,cancellation_comment IEX_EXCLUSION_HIST_TL.CANCELLATION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
53 ,language IEX_EXCLUSION_HIST_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
54 ,source_lang IEX_EXCLUSION_HIST_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
55 ,sfwt_flag IEX_EXCLUSION_HIST_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
56 ,created_by NUMBER := OKC_API.G_MISS_NUM
57 ,creation_date IEX_EXCLUSION_HIST_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
58 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
59 ,last_update_date IEX_EXCLUSION_HIST_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
60 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
61 G_MISS_ieht_rec ieht_rec_type;
62 TYPE ieht_tbl_type IS TABLE OF ieht_rec_type
63 INDEX BY BINARY_INTEGER;
64 -- IEX_EXCLUSION_HIST_B Record Spec
65 TYPE ieh_rec_type IS RECORD (
66 exclusion_history_id NUMBER := OKC_API.G_MISS_NUM
67 ,object1_id1 IEX_EXCLUSION_HIST_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
68 ,object1_id2 IEX_EXCLUSION_HIST_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
69 ,jtot_object1_code IEX_EXCLUSION_HIST_B.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
70 ,exclusion_reason IEX_EXCLUSION_HIST_B.EXCLUSION_REASON%TYPE := OKC_API.G_MISS_CHAR
71 ,effective_start_date IEX_EXCLUSION_HIST_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
72 ,effective_end_date IEX_EXCLUSION_HIST_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
73 ,cancel_reason IEX_EXCLUSION_HIST_B.CANCEL_REASON%TYPE := OKC_API.G_MISS_CHAR
74 ,cancelled_date IEX_EXCLUSION_HIST_B.CANCELLED_DATE%TYPE := OKC_API.G_MISS_DATE
75 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
76 ,org_id NUMBER := OKC_API.G_MISS_NUM
77 ,attribute_category IEX_EXCLUSION_HIST_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
78 ,attribute1 IEX_EXCLUSION_HIST_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
79 ,attribute2 IEX_EXCLUSION_HIST_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
80 ,attribute3 IEX_EXCLUSION_HIST_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
81 ,attribute4 IEX_EXCLUSION_HIST_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
82 ,attribute5 IEX_EXCLUSION_HIST_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
83 ,attribute6 IEX_EXCLUSION_HIST_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
84 ,attribute7 IEX_EXCLUSION_HIST_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
85 ,attribute8 IEX_EXCLUSION_HIST_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
86 ,attribute9 IEX_EXCLUSION_HIST_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
87 ,attribute10 IEX_EXCLUSION_HIST_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
88 ,attribute11 IEX_EXCLUSION_HIST_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
89 ,attribute12 IEX_EXCLUSION_HIST_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
90 ,attribute13 IEX_EXCLUSION_HIST_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
91 ,attribute14 IEX_EXCLUSION_HIST_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
92 ,attribute15 IEX_EXCLUSION_HIST_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
93 ,created_by NUMBER := OKC_API.G_MISS_NUM
94 ,creation_date IEX_EXCLUSION_HIST_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
95 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
96 ,last_update_date IEX_EXCLUSION_HIST_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
97 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
98 G_MISS_ieh_rec ieh_rec_type;
99 TYPE ieh_tbl_type IS TABLE OF ieh_rec_type
100 INDEX BY BINARY_INTEGER;
101 ---------------------------------------------------------------------------
102 -- GLOBAL MESSAGE CONSTANTS
103 ---------------------------------------------------------------------------
104 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
105 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
106 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
107 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
108 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
109 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
110 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
111 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
112 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
113 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
114 --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
115 --G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
116 --G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
117
118 ---------------------------------------------------------------------------
119 -- GLOBAL EXCEPTIONS
120 ---------------------------------------------------------------------------
121 --G_EXCEPTION_HALT_VALIDATION EXCEPTION;
122
123 ---------------------------------------------------------------------------
124 -- GLOBAL VARIABLES
125 ---------------------------------------------------------------------------
126 G_PKG_NAME CONSTANT VARCHAR2(200) := 'IEX_IEH_PVT';
127 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
128
129 -------------------------------------------------------------------------------
130 --Post change to TAPI code
131 -------------------------------------------------------------------------------
132 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
133 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
134 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
135 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
136 g_no_parent_record CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
137 ---------------------------------------------------------------------------
138
139 ---------------------------------------------------------------------------
140 -- Procedures and Functions
141 ---------------------------------------------------------------------------
145 PROCEDURE api_copy;
142
143 PROCEDURE qc;
144 PROCEDURE change_version;
146 PROCEDURE add_language;
147 PROCEDURE insert_row(
148 p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153 p_iehv_rec IN iehv_rec_type,
154 x_iehv_rec OUT NOCOPY iehv_rec_type);
155 PROCEDURE insert_row(
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_iehv_tbl IN iehv_tbl_type,
162 x_iehv_tbl OUT NOCOPY iehv_tbl_type,
163 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
164 PROCEDURE insert_row(
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 p_iehv_tbl IN iehv_tbl_type,
171 x_iehv_tbl OUT NOCOPY iehv_tbl_type);
172 PROCEDURE lock_row(
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_iehv_rec IN iehv_rec_type);
179 PROCEDURE lock_row(
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 p_iehv_tbl IN iehv_tbl_type,
186 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
187 PROCEDURE lock_row(
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_iehv_tbl IN iehv_tbl_type);
194 PROCEDURE update_row(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 p_iehv_rec IN iehv_rec_type,
201 x_iehv_rec OUT NOCOPY iehv_rec_type);
202 PROCEDURE update_row(
203 p_api_version IN NUMBER,
204 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
205 x_return_status OUT NOCOPY VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2,
208 p_iehv_tbl IN iehv_tbl_type,
209 x_iehv_tbl OUT NOCOPY iehv_tbl_type,
210 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
211 PROCEDURE update_row(
212 p_api_version IN NUMBER,
213 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
214 x_return_status OUT NOCOPY VARCHAR2,
215 x_msg_count OUT NOCOPY NUMBER,
216 x_msg_data OUT NOCOPY VARCHAR2,
217 p_iehv_tbl IN iehv_tbl_type,
218 x_iehv_tbl OUT NOCOPY iehv_tbl_type);
219 PROCEDURE delete_row(
220 p_api_version IN NUMBER,
221 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_iehv_rec IN iehv_rec_type);
226 PROCEDURE delete_row(
227 p_api_version IN NUMBER,
228 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_iehv_tbl IN iehv_tbl_type,
233 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
234 PROCEDURE delete_row(
235 p_api_version IN NUMBER,
236 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_iehv_tbl IN iehv_tbl_type);
241 PROCEDURE validate_row(
242 p_api_version IN NUMBER,
243 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_iehv_rec IN iehv_rec_type);
248 PROCEDURE validate_row(
249 p_api_version IN NUMBER,
250 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
251 x_return_status OUT NOCOPY VARCHAR2,
252 x_msg_count OUT NOCOPY NUMBER,
253 x_msg_data OUT NOCOPY VARCHAR2,
254 p_iehv_tbl IN iehv_tbl_type,
255 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
256 PROCEDURE validate_row(
257 p_api_version IN NUMBER,
258 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
259 x_return_status OUT NOCOPY VARCHAR2,
260 x_msg_count OUT NOCOPY NUMBER,
261 x_msg_data OUT NOCOPY VARCHAR2,
262 p_iehv_tbl IN iehv_tbl_type);
263 END IEX_IEH_PVT;