[Home] [Help]
PACKAGE: APPS.IEX_IOH_PVT
Source
1 PACKAGE IEX_IOH_PVT AUTHID CURRENT_USER AS
2 /* $Header: IEXSIOHS.pls 120.2 2005/12/21 15:45:46 jypark ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- IEX_OPEN_INT_HST_V Record Spec
7 TYPE iohv_rec_type IS RECORD (
8 id NUMBER := 9.99E125
9 ,object1_id1 IEX_OPEN_INT_HST_V.OBJECT1_ID1%TYPE := chr(0)
10 ,object1_id2 IEX_OPEN_INT_HST_V.OBJECT1_ID2%TYPE := chr(0)
11 ,jtot_object1_code IEX_OPEN_INT_HST_V.JTOT_OBJECT1_CODE%TYPE := chr(0)
12 ,action IEX_OPEN_INT_HST_V.ACTION%TYPE := chr(0)
13 ,status IEX_OPEN_INT_HST_V.STATUS%TYPE := chr(0)
14 ,comments IEX_OPEN_INT_HST_V.COMMENTS%TYPE := chr(0)
15 ,request_date IEX_OPEN_INT_HST_V.REQUEST_DATE%TYPE := TO_DATE('1','j')
16 ,process_date IEX_OPEN_INT_HST_V.PROCESS_DATE%TYPE := TO_DATE('1','j')
17 ,ext_agncy_id NUMBER := 9.99E125
18 ,review_date IEX_OPEN_INT_HST_V.REVIEW_DATE%TYPE := TO_DATE('1','j')
19 ,recall_date IEX_OPEN_INT_HST_V.RECALL_DATE%TYPE := TO_DATE('1','j')
20 ,automatic_recall_flag IEX_OPEN_INT_HST_V.AUTOMATIC_RECALL_FLAG%TYPE := chr(0)
21 ,review_before_recall_flag IEX_OPEN_INT_HST_V.REVIEW_BEFORE_RECALL_FLAG%TYPE := chr(0)
22 ,object_version_number NUMBER := 9.99E125
23 ,org_id NUMBER := 9.99E125
24 ,request_id NUMBER := 9.99E125
25 ,program_application_id NUMBER := 9.99E125
26 ,program_id NUMBER := 9.99E125
27 ,program_update_date IEX_OPEN_INT_HST_V.PROGRAM_UPDATE_DATE%TYPE := TO_DATE('1','j')
28 ,attribute_category IEX_OPEN_INT_HST_V.ATTRIBUTE_CATEGORY%TYPE := chr(0)
29 ,attribute1 IEX_OPEN_INT_HST_V.ATTRIBUTE1%TYPE := chr(0)
30 ,attribute2 IEX_OPEN_INT_HST_V.ATTRIBUTE2%TYPE := chr(0)
31 ,attribute3 IEX_OPEN_INT_HST_V.ATTRIBUTE3%TYPE := chr(0)
32 ,attribute4 IEX_OPEN_INT_HST_V.ATTRIBUTE4%TYPE := chr(0)
33 ,attribute5 IEX_OPEN_INT_HST_V.ATTRIBUTE5%TYPE := chr(0)
34 ,attribute6 IEX_OPEN_INT_HST_V.ATTRIBUTE6%TYPE := chr(0)
35 ,attribute7 IEX_OPEN_INT_HST_V.ATTRIBUTE7%TYPE := chr(0)
36 ,attribute8 IEX_OPEN_INT_HST_V.ATTRIBUTE8%TYPE := chr(0)
37 ,attribute9 IEX_OPEN_INT_HST_V.ATTRIBUTE9%TYPE := chr(0)
38 ,attribute10 IEX_OPEN_INT_HST_V.ATTRIBUTE10%TYPE := chr(0)
39 ,attribute11 IEX_OPEN_INT_HST_V.ATTRIBUTE11%TYPE := chr(0)
40 ,attribute12 IEX_OPEN_INT_HST_V.ATTRIBUTE12%TYPE := chr(0)
41 ,attribute13 IEX_OPEN_INT_HST_V.ATTRIBUTE13%TYPE := chr(0)
42 ,attribute14 IEX_OPEN_INT_HST_V.ATTRIBUTE14%TYPE := chr(0)
43 ,attribute15 IEX_OPEN_INT_HST_V.ATTRIBUTE15%TYPE := chr(0)
44 ,created_by NUMBER := 9.99E125
45 ,creation_date IEX_OPEN_INT_HST_V.CREATION_DATE%TYPE := TO_DATE('1','j')
46 ,last_updated_by NUMBER := 9.99E125
47 ,last_update_date IEX_OPEN_INT_HST_V.LAST_UPDATE_DATE%TYPE := TO_DATE('1','j')
48 ,last_update_login NUMBER := 9.99E125);
49 G_MISS_iohv_rec iohv_rec_type;
50 TYPE iohv_tbl_type IS TABLE OF iohv_rec_type
51 INDEX BY BINARY_INTEGER;
52 -- IEX_OPEN_INT_HST Record Spec
53 TYPE ioh_rec_type IS RECORD (
54 id NUMBER := 9.99E125
55 ,object1_id1 IEX_OPEN_INT_HST.OBJECT1_ID1%TYPE := chr(0)
56 ,object1_id2 IEX_OPEN_INT_HST.OBJECT1_ID2%TYPE := chr(0)
57 ,jtot_object1_code IEX_OPEN_INT_HST.JTOT_OBJECT1_CODE%TYPE := chr(0)
58 ,action IEX_OPEN_INT_HST.ACTION%TYPE := chr(0)
59 ,status IEX_OPEN_INT_HST.STATUS%TYPE := chr(0)
60 ,comments IEX_OPEN_INT_HST.COMMENTS%TYPE := chr(0)
61 ,request_date IEX_OPEN_INT_HST.REQUEST_DATE%TYPE := TO_DATE('1','j')
62 ,process_date IEX_OPEN_INT_HST.PROCESS_DATE%TYPE := TO_DATE('1','j')
63 ,ext_agncy_id NUMBER := 9.99E125
64 ,review_date IEX_OPEN_INT_HST.REVIEW_DATE%TYPE := TO_DATE('1','j')
65 ,recall_date IEX_OPEN_INT_HST.RECALL_DATE%TYPE := TO_DATE('1','j')
66 ,automatic_recall_flag IEX_OPEN_INT_HST.AUTOMATIC_RECALL_FLAG%TYPE := chr(0)
67 ,review_before_recall_flag IEX_OPEN_INT_HST.REVIEW_BEFORE_RECALL_FLAG%TYPE := chr(0)
68 ,object_version_number NUMBER := 9.99E125
69 ,org_id NUMBER := 9.99E125
70 ,request_id NUMBER := 9.99E125
71 ,program_application_id NUMBER := 9.99E125
72 ,program_id NUMBER := 9.99E125
73 ,program_update_date IEX_OPEN_INT_HST.PROGRAM_UPDATE_DATE%TYPE := TO_DATE('1','j')
74 ,attribute_category IEX_OPEN_INT_HST.ATTRIBUTE_CATEGORY%TYPE := chr(0)
75 ,attribute1 IEX_OPEN_INT_HST.ATTRIBUTE1%TYPE := chr(0)
76 ,attribute2 IEX_OPEN_INT_HST.ATTRIBUTE2%TYPE := chr(0)
77 ,attribute3 IEX_OPEN_INT_HST.ATTRIBUTE3%TYPE := chr(0)
78 ,attribute4 IEX_OPEN_INT_HST.ATTRIBUTE4%TYPE := chr(0)
79 ,attribute5 IEX_OPEN_INT_HST.ATTRIBUTE5%TYPE := chr(0)
80 ,attribute6 IEX_OPEN_INT_HST.ATTRIBUTE6%TYPE := chr(0)
81 ,attribute7 IEX_OPEN_INT_HST.ATTRIBUTE7%TYPE := chr(0)
82 ,attribute8 IEX_OPEN_INT_HST.ATTRIBUTE8%TYPE := chr(0)
83 ,attribute9 IEX_OPEN_INT_HST.ATTRIBUTE9%TYPE := chr(0)
84 ,attribute10 IEX_OPEN_INT_HST.ATTRIBUTE10%TYPE := chr(0)
85 ,attribute11 IEX_OPEN_INT_HST.ATTRIBUTE11%TYPE := chr(0)
86 ,attribute12 IEX_OPEN_INT_HST.ATTRIBUTE12%TYPE := chr(0)
87 ,attribute13 IEX_OPEN_INT_HST.ATTRIBUTE13%TYPE := chr(0)
88 ,attribute14 IEX_OPEN_INT_HST.ATTRIBUTE14%TYPE := chr(0)
89 ,attribute15 IEX_OPEN_INT_HST.ATTRIBUTE15%TYPE := chr(0)
90 ,created_by NUMBER := 9.99E125
91 ,creation_date IEX_OPEN_INT_HST.CREATION_DATE%TYPE := TO_DATE('1','j')
92 ,last_updated_by NUMBER := 9.99E125
93 ,last_update_date IEX_OPEN_INT_HST.LAST_UPDATE_DATE%TYPE := TO_DATE('1','j')
94 ,last_update_login NUMBER := 9.99E125);
95 G_MISS_ioh_rec ioh_rec_type;
96 TYPE ioh_tbl_type IS TABLE OF ioh_rec_type
97 INDEX BY BINARY_INTEGER;
98 ---------------------------------------------------------------------------
99 -- GLOBAL MESSAGE CONSTANTS
100 ---------------------------------------------------------------------------
101 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
102 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
103 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
104 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
105 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
106 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
107 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
108 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
109 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
110 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
111 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
112 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
113 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
114
115 ---------------------------------------------------------------------------
116 -- GLOBAL EXCEPTIONS
117 ---------------------------------------------------------------------------
118 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
119
120 ---------------------------------------------------------------------------
121 -- GLOBAL VARIABLES
122 ---------------------------------------------------------------------------
123 G_PKG_NAME CONSTANT VARCHAR2(200) := 'IEX_IOH_PVT';
124 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
125 ---------------------------------------------------------------------------
126 -- Procedures and Functions
127 ---------------------------------------------------------------------------
128
129 PROCEDURE qc;
130 PROCEDURE change_version;
131 PROCEDURE api_copy;
132 PROCEDURE insert_row(
133 p_api_version IN NUMBER,
134 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2,
138 p_iohv_rec IN iohv_rec_type,
139 x_iohv_rec OUT NOCOPY iohv_rec_type);
140 PROCEDURE insert_row(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_iohv_tbl IN iohv_tbl_type,
147 x_iohv_tbl OUT NOCOPY iohv_tbl_type,
148 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
149 PROCEDURE insert_row(
150 p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155 p_iohv_tbl IN iohv_tbl_type,
156 x_iohv_tbl OUT NOCOPY iohv_tbl_type);
157 PROCEDURE lock_row(
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_iohv_rec IN iohv_rec_type);
164 PROCEDURE lock_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_iohv_tbl IN iohv_tbl_type,
171 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_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_iohv_tbl IN iohv_tbl_type);
179 PROCEDURE update_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_iohv_rec IN iohv_rec_type,
186 x_iohv_rec OUT NOCOPY iohv_rec_type);
187 PROCEDURE update_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_iohv_tbl IN iohv_tbl_type,
194 x_iohv_tbl OUT NOCOPY iohv_tbl_type,
195 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
196 PROCEDURE update_row(
197 p_api_version IN NUMBER,
198 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_iohv_tbl IN iohv_tbl_type,
203 x_iohv_tbl OUT NOCOPY iohv_tbl_type);
204 PROCEDURE delete_row(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_iohv_rec IN iohv_rec_type);
211 PROCEDURE delete_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_iohv_tbl IN iohv_tbl_type,
218 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_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_iohv_tbl IN iohv_tbl_type);
226 PROCEDURE validate_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_iohv_rec IN iohv_rec_type);
233 PROCEDURE validate_row(
234 p_api_version IN NUMBER,
235 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
236 x_return_status OUT NOCOPY VARCHAR2,
237 x_msg_count OUT NOCOPY NUMBER,
238 x_msg_data OUT NOCOPY VARCHAR2,
239 p_iohv_tbl IN iohv_tbl_type,
240 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_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_iohv_tbl IN iohv_tbl_type);
248 END IEX_IOH_PVT;