[Home] [Help]
PACKAGE: APPS.OKC_TGD_PVT
Source
1 Package OKC_TGD_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCSTGDS.pls 120.0 2005/05/25 22:58:04 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
7 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
8 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
9 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
10 G_RETURN_STATUS VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
11 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
12 TYPE tve_rec_type IS RECORD (
13 id NUMBER := OKC_API.G_MISS_NUM,
14 spn_id NUMBER := OKC_API.G_MISS_NUM,
15 tve_id_offset NUMBER := OKC_API.G_MISS_NUM,
16 uom_code OKC_TIMEVALUES.uom_code%TYPE := OKC_API.G_MISS_CHAR,
17 cnh_id NUMBER := OKC_API.G_MISS_NUM,
18 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
19 tze_id NUMBER := OKC_API.G_MISS_NUM,
20 tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
21 tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
22 tve_id_started NUMBER := OKC_API.G_MISS_NUM,
23 tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
24 tve_type OKC_TIMEVALUES.TVE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25 object_version_number NUMBER := OKC_API.G_MISS_NUM,
26 created_by NUMBER := OKC_API.G_MISS_NUM,
27 creation_date OKC_TIMEVALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29 last_update_date OKC_TIMEVALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30 duration NUMBER := OKC_API.G_MISS_NUM,
31 operator OKC_TIMEVALUES.OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
32 before_after OKC_TIMEVALUES.BEFORE_AFTER%TYPE := OKC_API.G_MISS_CHAR,
33 datetime OKC_TIMEVALUES.DATETIME%TYPE := OKC_API.G_MISS_DATE,
34 month NUMBER := OKC_API.G_MISS_NUM,
35 day NUMBER := OKC_API.G_MISS_NUM,
36 hour NUMBER := OKC_API.G_MISS_NUM,
37 minute NUMBER := OKC_API.G_MISS_NUM,
38 second NUMBER := OKC_API.G_MISS_NUM,
39 nth NUMBER := OKC_API.G_MISS_NUM,
40 day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
41 interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
42 last_update_login NUMBER := OKC_API.G_MISS_NUM,
43 --Bug 3122962
44 name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
45 description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,
46 short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,
47 comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR,
48
49 attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
50 attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
51 attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
52 attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
53 attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
54 attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
55 attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
56 attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
57 attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
58 attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
59 attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
60 attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
61 attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
62 attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
63 attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
64 attribute15 OKC_TIMEVALUES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
65 g_miss_tve_rec tve_rec_type;
66 TYPE tve_tbl_type IS TABLE OF tve_rec_type
67 INDEX BY BINARY_INTEGER;
68 /*
69 TYPE okc_timevalues_tl_rec_type IS RECORD (
70 id NUMBER := OKC_API.G_MISS_NUM,
71 language OKC_TIMEVALUES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
72 source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
73 sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74 description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
75 short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76 comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
77 name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
78 created_by NUMBER := OKC_API.G_MISS_NUM,
82 last_update_login NUMBER := OKC_API.G_MISS_NUM);
79 creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
80 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
81 last_update_date OKC_TIMEVALUES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
83 g_miss_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
84 TYPE okc_timevalues_tl_tbl_type IS TABLE OF okc_timevalues_tl_rec_type
85 INDEX BY BINARY_INTEGER;
86 */
87 TYPE tgdv_rec_type IS RECORD (
88 id NUMBER := OKC_API.G_MISS_NUM,
89 object_version_number NUMBER := OKC_API.G_MISS_NUM,
90 --Bug 3122962
91 sfwt_flag OKC_TIME_TPG_DELIMITED_V.SFWT_FLAG%TYPE := 'N',
92 npt_id NUMBER := OKC_API.G_MISS_NUM,
93 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
94 tze_id NUMBER := OKC_API.G_MISS_NUM,
95 tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
96 description OKC_TIME_TPG_DELIMITED_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
97 short_description OKC_TIME_TPG_DELIMITED_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98 comments OKC_TIME_TPG_DELIMITED_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
99 month NUMBER := OKC_API.G_MISS_NUM,
100 day NUMBER := OKC_API.G_MISS_NUM,
101 day_of_week OKC_TIME_TPG_DELIMITED_V.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
102 hour NUMBER := OKC_API.G_MISS_NUM,
103 minute NUMBER := OKC_API.G_MISS_NUM,
104 second NUMBER := OKC_API.G_MISS_NUM,
105 nth NUMBER := OKC_API.G_MISS_NUM,
106 attribute_category OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
107 attribute1 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
108 attribute2 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
109 attribute3 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
110 attribute4 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
111 attribute5 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
112 attribute6 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
113 attribute7 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
114 attribute8 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
115 attribute9 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
116 attribute10 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
117 attribute11 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
118 attribute12 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
119 attribute13 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
120 attribute14 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
121 attribute15 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
122 created_by NUMBER := OKC_API.G_MISS_NUM,
123 creation_date OKC_TIME_TPG_DELIMITED_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
124 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
125 last_update_date OKC_TIME_TPG_DELIMITED_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
126 last_update_login NUMBER := OKC_API.G_MISS_NUM);
127 g_miss_tgdv_rec tgdv_rec_type;
128 TYPE tgdv_tbl_type IS TABLE OF tgdv_rec_type
129 INDEX BY BINARY_INTEGER;
130 ---------------------------------------------------------------------------
131 -- GLOBAL MESSAGE CONSTANTS
132 ---------------------------------------------------------------------------
133 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
134 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
135 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
136 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
137 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
138 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
139 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
140 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
141 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
142 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
143 ---------------------------------------------------------------------------
144 -- GLOBAL VARIABLES
145 ---------------------------------------------------------------------------
146 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TGD_PVT';
147 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
148 ---------------------------------------------------------------------------
149 -- Procedures and Functions
150 ---------------------------------------------------------------------------
151
152 PROCEDURE qc;
153 PROCEDURE change_version;
154 PROCEDURE api_copy;
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_tgdv_rec IN tgdv_rec_type,
162 x_tgdv_rec OUT NOCOPY tgdv_rec_type);
163
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_tgdv_tbl IN tgdv_tbl_type,
171 x_tgdv_tbl OUT NOCOPY tgdv_tbl_type);
172
173 PROCEDURE lock_row(
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_tgdv_rec IN tgdv_rec_type);
180
181 PROCEDURE lock_row(
182 p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_tgdv_tbl IN tgdv_tbl_type);
188
189 PROCEDURE update_row(
190 p_api_version IN NUMBER,
191 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195 p_tgdv_rec IN tgdv_rec_type,
196 x_tgdv_rec OUT NOCOPY tgdv_rec_type);
197
198 PROCEDURE update_row(
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_tgdv_tbl IN tgdv_tbl_type,
205 x_tgdv_tbl OUT NOCOPY tgdv_tbl_type);
206
207 PROCEDURE delete_row(
208 p_api_version IN NUMBER,
209 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
210 x_return_status OUT NOCOPY VARCHAR2,
211 x_msg_count OUT NOCOPY NUMBER,
212 x_msg_data OUT NOCOPY VARCHAR2,
213 p_tgdv_rec IN tgdv_rec_type);
214
215 PROCEDURE delete_row(
216 p_api_version IN NUMBER,
217 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
218 x_return_status OUT NOCOPY VARCHAR2,
219 x_msg_count OUT NOCOPY NUMBER,
220 x_msg_data OUT NOCOPY VARCHAR2,
221 p_tgdv_tbl IN tgdv_tbl_type);
222
223 PROCEDURE validate_row(
224 p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
226 x_return_status OUT NOCOPY VARCHAR2,
227 x_msg_count OUT NOCOPY NUMBER,
228 x_msg_data OUT NOCOPY VARCHAR2,
229 p_tgdv_rec IN tgdv_rec_type);
230
231 PROCEDURE validate_row(
232 p_api_version IN NUMBER,
233 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
234 x_return_status OUT NOCOPY VARCHAR2,
235 x_msg_count OUT NOCOPY NUMBER,
236 x_msg_data OUT NOCOPY VARCHAR2,
237 p_tgdv_tbl IN tgdv_tbl_type);
238
239 END OKC_TGD_PVT;