[Home] [Help]
PACKAGE: APPS.OKC_CNH_PVT
Source
4 -- GLOBAL DATASTRUCTURES
1 Package OKC_CNH_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCSCNHS.pls 120.0 2005/05/25 23:05:09 appldev noship $ */
3 ---------------------------------------------------------------------------
5 ---------------------------------------------------------------------------
6 TYPE cnh_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 acn_id NUMBER := OKC_API.G_MISS_NUM,
9 counter_group_id NUMBER := OKC_API.G_MISS_NUM,
10 one_time_yn OKC_CONDITION_HEADERS_B.ONE_TIME_YN%TYPE := OKC_API.G_MISS_CHAR,
11 before_after OKC_CONDITION_HEADERS_B.BEFORE_AFTER%TYPE := OKC_API.G_MISS_CHAR,
12 cnh_variance NUMBER := OKC_API.G_MISS_NUM,
13 condition_valid_yn OKC_CONDITION_HEADERS_B.CONDITION_VALID_YN%TYPE := OKC_API.G_MISS_CHAR,
14 tracked_yn OKC_CONDITION_HEADERS_B.TRACKED_YN%TYPE := OKC_API.G_MISS_CHAR,
15 date_active OKC_CONDITION_HEADERS_B.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
16 date_inactive OKC_CONDITION_HEADERS_B.DATE_INACTIVE%TYPE := OKC_API.G_MISS_DATE,
17 cnh_type OKC_CONDITION_HEADERS_B.CNH_TYPE%TYPE := OKC_API.G_MISS_CHAR,
18 template_yn OKC_CONDITION_HEADERS_B.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
19 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
20 object_id NUMBER := OKC_API.G_MISS_NUM,
21 jtot_object_code OKC_CONDITION_HEADERS_B.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
22 object_version_number NUMBER := OKC_API.G_MISS_NUM,
23 task_owner_id NUMBER := OKC_API.G_MISS_NUM,
24 created_by NUMBER := OKC_API.G_MISS_NUM,
25 creation_date OKC_CONDITION_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
26 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
27 last_update_date OKC_CONDITION_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
28 last_update_login NUMBER := OKC_API.G_MISS_NUM,
29 attribute_category OKC_CONDITION_HEADERS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
30 attribute1 OKC_CONDITION_HEADERS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
31 attribute2 OKC_CONDITION_HEADERS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
32 attribute3 OKC_CONDITION_HEADERS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
33 attribute4 OKC_CONDITION_HEADERS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
34 attribute5 OKC_CONDITION_HEADERS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
35 attribute6 OKC_CONDITION_HEADERS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
36 attribute7 OKC_CONDITION_HEADERS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
37 attribute8 OKC_CONDITION_HEADERS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
38 attribute9 OKC_CONDITION_HEADERS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
39 attribute10 OKC_CONDITION_HEADERS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
40 attribute11 OKC_CONDITION_HEADERS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
41 attribute12 OKC_CONDITION_HEADERS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
42 attribute13 OKC_CONDITION_HEADERS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
43 attribute14 OKC_CONDITION_HEADERS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
44 attribute15 OKC_CONDITION_HEADERS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
45 application_id NUMBER := OKC_API.G_MISS_NUM,
46 seeded_flag OKC_CONDITION_HEADERS_B.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47 last_rundate OKC_CONDITION_HEADERS_B.LAST_RUNDATE%TYPE := OKC_API.G_MISS_DATE);
48 g_miss_cnh_rec cnh_rec_type;
49 TYPE cnh_tbl_type IS TABLE OF cnh_rec_type
50 INDEX BY BINARY_INTEGER;
51 TYPE OkcConditionHeadersTlRecType IS RECORD (
52 id NUMBER := OKC_API.G_MISS_NUM,
53 language OKC_CONDITION_HEADERS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
54 source_lang OKC_CONDITION_HEADERS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
55 sfwt_flag OKC_CONDITION_HEADERS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
56 name OKC_CONDITION_HEADERS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
57 description OKC_CONDITION_HEADERS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
58 short_description OKC_CONDITION_HEADERS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
59 comments OKC_CONDITION_HEADERS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
60 created_by NUMBER := OKC_API.G_MISS_NUM,
61 creation_date OKC_CONDITION_HEADERS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
62 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
63 last_update_date OKC_CONDITION_HEADERS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
64 last_update_login NUMBER := OKC_API.G_MISS_NUM);
65 GMissOkcConditionHeadersTlRec OkcConditionHeadersTlRecType;
66 TYPE OkcConditionHeadersTlTblType IS TABLE OF OkcConditionHeadersTlRecType
67 INDEX BY BINARY_INTEGER;
68 TYPE cnhv_rec_type IS RECORD (
69 id NUMBER := OKC_API.G_MISS_NUM,
70 object_version_number NUMBER := OKC_API.G_MISS_NUM,
71 sfwt_flag OKC_CONDITION_HEADERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
72 acn_id NUMBER := OKC_API.G_MISS_NUM,
73 counter_group_id NUMBER := OKC_API.G_MISS_NUM,
74 description OKC_CONDITION_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
75 short_description OKC_CONDITION_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76 comments OKC_CONDITION_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
77 one_time_yn OKC_CONDITION_HEADERS_V.ONE_TIME_YN%TYPE := OKC_API.G_MISS_CHAR,
78 name OKC_CONDITION_HEADERS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
79 condition_valid_yn OKC_CONDITION_HEADERS_V.CONDITION_VALID_YN%TYPE := OKC_API.G_MISS_CHAR,
80 before_after OKC_CONDITION_HEADERS_V.BEFORE_AFTER%TYPE := OKC_API.G_MISS_CHAR,
81 tracked_yn OKC_CONDITION_HEADERS_V.TRACKED_YN%TYPE := OKC_API.G_MISS_CHAR,
82 cnh_variance NUMBER := OKC_API.G_MISS_NUM,
83 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
84 template_yn OKC_CONDITION_HEADERS_V.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
85 date_active OKC_CONDITION_HEADERS_V.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
86 object_id NUMBER := OKC_API.G_MISS_NUM,
87 date_inactive OKC_CONDITION_HEADERS_V.DATE_INACTIVE%TYPE := OKC_API.G_MISS_DATE,
88 jtot_object_code OKC_CONDITION_HEADERS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
89 task_owner_id NUMBER := OKC_API.G_MISS_NUM,
90 cnh_type OKC_CONDITION_HEADERS_V.CNH_TYPE%TYPE := OKC_API.G_MISS_CHAR,
91 application_id NUMBER := OKC_API.G_MISS_NUM,
92 seeded_flag OKC_CONDITION_HEADERS_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
93 last_rundate OKC_CONDITION_HEADERS_V.LAST_RUNDATE%TYPE := OKC_API.G_MISS_DATE,
94 attribute_category OKC_CONDITION_HEADERS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
95 attribute1 OKC_CONDITION_HEADERS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
96 attribute2 OKC_CONDITION_HEADERS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
97 attribute3 OKC_CONDITION_HEADERS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
98 attribute4 OKC_CONDITION_HEADERS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
99 attribute5 OKC_CONDITION_HEADERS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
100 attribute6 OKC_CONDITION_HEADERS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
101 attribute7 OKC_CONDITION_HEADERS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
102 attribute8 OKC_CONDITION_HEADERS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
103 attribute9 OKC_CONDITION_HEADERS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
104 attribute10 OKC_CONDITION_HEADERS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
105 attribute11 OKC_CONDITION_HEADERS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
106 attribute12 OKC_CONDITION_HEADERS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
107 attribute13 OKC_CONDITION_HEADERS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
108 attribute14 OKC_CONDITION_HEADERS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
109 attribute15 OKC_CONDITION_HEADERS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
110 created_by NUMBER := OKC_API.G_MISS_NUM,
111 creation_date OKC_CONDITION_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
112 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
113 last_update_date OKC_CONDITION_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
114 last_update_login NUMBER := OKC_API.G_MISS_NUM);
115 g_miss_cnhv_rec cnhv_rec_type;
116 TYPE cnhv_tbl_type IS TABLE OF cnhv_rec_type
117 INDEX BY BINARY_INTEGER;
118 ---------------------------------------------------------------------------
119 -- GLOBAL MESSAGE CONSTANTS
120 ---------------------------------------------------------------------------
121 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
122 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
123 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
124 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
125 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
126 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
127 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
128 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
129 G_COL_NAME_TOKEN1 CONSTANT VARCHAR2(30) := 'COL_NAME1';
130 G_COL_NAME_TOKEN2 CONSTANT VARCHAR2(30) := 'COL_NAME2';
131 G_COL_NAME_TOKEN3 CONSTANT VARCHAR2(30) := 'COL_NAME3';
132 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
133 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
134 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
135 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
136 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
137 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPERCASE_REQUIRED';
138 --G_UNQS CONSTANT VARCHAR2(200) := 'OKC_VALUES_NOT_UNIQUE';
139 G_UNQS CONSTANT VARCHAR2(200) := 'OKC_CNH_OBJECT_JTOT_NOT_UNIQUE';
140 ---------------------------------------------------------------------------
141 -- GLOBAL EXCEPTION
142 ---------------------------------------------------------------------------
143 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
144 ---------------------------------------------------------------------------
145 -- GLOBAL VARIABLES
146 ---------------------------------------------------------------------------
147 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CNH_PVT';
148 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
149 ---------------------------------------------------------------------------
150 -- Procedures and Functions
151 ---------------------------------------------------------------------------
152
153 PROCEDURE qc;
154 PROCEDURE change_version;
155 PROCEDURE api_copy;
156 PROCEDURE add_language;
157 PROCEDURE insert_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_cnhv_rec IN cnhv_rec_type,
164 x_cnhv_rec OUT NOCOPY cnhv_rec_type);
165
166 PROCEDURE insert_row(
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_cnhv_tbl IN cnhv_tbl_type,
173 x_cnhv_tbl OUT NOCOPY cnhv_tbl_type);
174
175 PROCEDURE lock_row(
176 p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
178 x_return_status OUT NOCOPY VARCHAR2,
179 x_msg_count OUT NOCOPY NUMBER,
180 x_msg_data OUT NOCOPY VARCHAR2,
181 p_cnhv_rec IN cnhv_rec_type);
182
183 PROCEDURE lock_row(
184 p_api_version IN NUMBER,
185 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189 p_cnhv_tbl IN cnhv_tbl_type);
190
191 PROCEDURE update_row(
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 p_cnhv_rec IN cnhv_rec_type,
198 x_cnhv_rec OUT NOCOPY cnhv_rec_type);
199
200 PROCEDURE update_row(
201 p_api_version IN NUMBER,
202 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
203 x_return_status OUT NOCOPY VARCHAR2,
204 x_msg_count OUT NOCOPY NUMBER,
205 x_msg_data OUT NOCOPY VARCHAR2,
206 p_cnhv_tbl IN cnhv_tbl_type,
207 x_cnhv_tbl OUT NOCOPY cnhv_tbl_type);
208
209 PROCEDURE delete_row(
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215 p_cnhv_rec IN cnhv_rec_type);
216
217 PROCEDURE delete_row(
218 p_api_version IN NUMBER,
219 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
220 x_return_status OUT NOCOPY VARCHAR2,
221 x_msg_count OUT NOCOPY NUMBER,
222 x_msg_data OUT NOCOPY VARCHAR2,
223 p_cnhv_tbl IN cnhv_tbl_type);
224
225 PROCEDURE validate_row(
226 p_api_version IN NUMBER,
227 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
228 x_return_status OUT NOCOPY VARCHAR2,
229 x_msg_count OUT NOCOPY NUMBER,
230 x_msg_data OUT NOCOPY VARCHAR2,
231 p_cnhv_rec IN cnhv_rec_type);
232
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_cnhv_tbl IN cnhv_tbl_type);
240
241 PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2, p_cnhv_tbl cnhv_tbl_type);
242
243 FUNCTION create_version(
244 p_chr_id IN NUMBER,
245 p_major_version IN NUMBER) RETURN VARCHAR2;
246
247 FUNCTION restore_version(
248 p_chr_id IN NUMBER,
249 p_major_version IN NUMBER) RETURN VARCHAR2;
250
251 END OKC_CNH_PVT;