[Home] [Help]
PACKAGE: APPS.OKC_OCE_PVT
Source
1 Package OKC_OCE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCSOCES.pls 120.0 2005/05/25 18:27:46 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE oce_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 pdf_id NUMBER := OKC_API.G_MISS_NUM,
9 cnh_id NUMBER := OKC_API.G_MISS_NUM,
10 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
11 success_resource_id NUMBER := OKC_API.G_MISS_NUM,
12 failure_resource_id NUMBER := OKC_API.G_MISS_NUM,
13 enabled_yn OKC_OUTCOMES_B.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
14 object_version_number NUMBER := OKC_API.G_MISS_NUM,
15 created_by NUMBER := OKC_API.G_MISS_NUM,
16 creation_date OKC_OUTCOMES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18 last_update_date OKC_OUTCOMES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19 last_update_login NUMBER := OKC_API.G_MISS_NUM,
20 attribute_category OKC_OUTCOMES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
21 attribute1 OKC_OUTCOMES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
22 attribute2 OKC_OUTCOMES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
23 attribute3 OKC_OUTCOMES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
24 attribute4 OKC_OUTCOMES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
25 attribute5 OKC_OUTCOMES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
26 attribute6 OKC_OUTCOMES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
27 attribute7 OKC_OUTCOMES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
28 attribute8 OKC_OUTCOMES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
29 attribute9 OKC_OUTCOMES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
30 attribute10 OKC_OUTCOMES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
31 attribute11 OKC_OUTCOMES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
32 attribute12 OKC_OUTCOMES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
33 attribute13 OKC_OUTCOMES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
34 attribute14 OKC_OUTCOMES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
35 attribute15 OKC_OUTCOMES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
36 application_id NUMBER := OKC_API.G_MISS_NUM,
37 seeded_flag OKC_OUTCOMES_B.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR);
38 g_miss_oce_rec oce_rec_type;
39 TYPE oce_tbl_type IS TABLE OF oce_rec_type
40 INDEX BY BINARY_INTEGER;
41 TYPE okc_outcomes_tl_rec_type IS RECORD (
42 id NUMBER := OKC_API.G_MISS_NUM,
43 language OKC_OUTCOMES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
44 source_lang OKC_OUTCOMES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
45 sfwt_flag OKC_OUTCOMES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
46 comments OKC_OUTCOMES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
47 created_by NUMBER := OKC_API.G_MISS_NUM,
48 creation_date OKC_OUTCOMES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
49 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
50 last_update_date OKC_OUTCOMES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
51 last_update_login NUMBER := OKC_API.G_MISS_NUM);
52 g_miss_okc_outcomes_tl_rec okc_outcomes_tl_rec_type;
53 TYPE okc_outcomes_tl_tbl_type IS TABLE OF okc_outcomes_tl_rec_type
54 INDEX BY BINARY_INTEGER;
55 TYPE ocev_rec_type IS RECORD (
56 id NUMBER := OKC_API.G_MISS_NUM,
57 object_version_number NUMBER := OKC_API.G_MISS_NUM,
58 sfwt_flag OKC_OUTCOMES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
59 pdf_id NUMBER := OKC_API.G_MISS_NUM,
60 cnh_id NUMBER := OKC_API.G_MISS_NUM,
61 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
62 success_resource_id NUMBER := OKC_API.G_MISS_NUM,
63 failure_resource_id NUMBER := OKC_API.G_MISS_NUM,
64 enabled_yn OKC_OUTCOMES_V.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
65 comments OKC_OUTCOMES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
66 application_id NUMBER := OKC_API.G_MISS_NUM,
67 seeded_flag OKC_OUTCOMES_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
68 attribute_category OKC_OUTCOMES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
69 attribute1 OKC_OUTCOMES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
70 attribute2 OKC_OUTCOMES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
71 attribute3 OKC_OUTCOMES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
72 attribute4 OKC_OUTCOMES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
73 attribute5 OKC_OUTCOMES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
74 attribute6 OKC_OUTCOMES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
75 attribute7 OKC_OUTCOMES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
76 attribute8 OKC_OUTCOMES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
77 attribute9 OKC_OUTCOMES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
78 attribute10 OKC_OUTCOMES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
79 attribute11 OKC_OUTCOMES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
80 attribute12 OKC_OUTCOMES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
81 attribute13 OKC_OUTCOMES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
82 attribute14 OKC_OUTCOMES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
83 attribute15 OKC_OUTCOMES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
84 created_by NUMBER := OKC_API.G_MISS_NUM,
85 creation_date OKC_OUTCOMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
86 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
87 last_update_date OKC_OUTCOMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
88 last_update_login NUMBER := OKC_API.G_MISS_NUM);
89 g_miss_ocev_rec ocev_rec_type;
90 TYPE ocev_tbl_type IS TABLE OF ocev_rec_type
91 INDEX BY BINARY_INTEGER;
92 ---------------------------------------------------------------------------
93 -- GLOBAL MESSAGE CONSTANTS
94 ---------------------------------------------------------------------------
95 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
96 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
97 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
98 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
99 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
100 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
101 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
102 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
103 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
104 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
105 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
106 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
107 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
108 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPERCASE_REQUIRED';
109 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
110 ---------------------------------------------------------------------------
111 -- GLOBAL VARIABLES
112 ---------------------------------------------------------------------------
113 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_OCE_PVT';
114 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
115 G_VIEW CONSTANT VARCHAR2(200) := 'OKC_OUTCOMES_V';
116 ---------------------------------------------------------------------------
117 -- GLOBAL EXCEPTION
118 ---------------------------------------------------------------------------
119 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
120 ---------------------------------------------------------------------------
121 -- Procedures and Functions
122 ---------------------------------------------------------------------------
123
124 PROCEDURE qc;
125 PROCEDURE change_version;
126 PROCEDURE api_copy;
127 PROCEDURE add_language;
128 PROCEDURE insert_row(
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_ocev_rec IN ocev_rec_type,
135 x_ocev_rec OUT NOCOPY ocev_rec_type);
136
137 PROCEDURE insert_row(
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_ocev_tbl IN ocev_tbl_type,
144 x_ocev_tbl OUT NOCOPY ocev_tbl_type);
145
146 PROCEDURE lock_row(
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 p_ocev_rec IN ocev_rec_type);
153
154 PROCEDURE lock_row(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_ocev_tbl IN ocev_tbl_type);
161
162 PROCEDURE update_row(
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168 p_ocev_rec IN ocev_rec_type,
169 x_ocev_rec OUT NOCOPY ocev_rec_type);
170
171 PROCEDURE update_row(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_ocev_tbl IN ocev_tbl_type,
178 x_ocev_tbl OUT NOCOPY ocev_tbl_type);
179
180 PROCEDURE delete_row(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ocev_rec IN ocev_rec_type);
187
188 PROCEDURE delete_row(
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 x_msg_data OUT NOCOPY VARCHAR2,
194 p_ocev_tbl IN ocev_tbl_type);
195
196 PROCEDURE validate_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_ocev_rec IN ocev_rec_type);
203
204 PROCEDURE validate_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_ocev_tbl IN ocev_tbl_type);
211
212 PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_ocev_tbl ocev_tbl_type);
213
214 FUNCTION create_version(
215 p_chr_id IN NUMBER,
216 p_major_version IN NUMBER) RETURN VARCHAR2;
217
218 FUNCTION restore_version(
219 p_chr_id IN NUMBER,
220 p_major_version IN NUMBER) RETURN VARCHAR2;
221
222 END OKC_OCE_PVT;