[Home] [Help]
PACKAGE: APPS.OKC_SAV_PVT
Source
1 Package OKC_SAV_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCSSAVS.pls 120.0 2005/05/25 22:53:45 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE sav_rec_type IS RECORD (
7 sav_release OKC_STD_ART_VERSIONS_B.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
8 sae_id NUMBER := OKC_API.G_MISS_NUM,
9 date_active OKC_STD_ART_VERSIONS_B.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
10 object_version_number NUMBER := OKC_API.G_MISS_NUM,
11 created_by NUMBER := OKC_API.G_MISS_NUM,
12 creation_date OKC_STD_ART_VERSIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14 last_update_date OKC_STD_ART_VERSIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15 last_update_login NUMBER := OKC_API.G_MISS_NUM,
16 attribute_category OKC_STD_ART_VERSIONS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17 attribute1 OKC_STD_ART_VERSIONS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18 attribute2 OKC_STD_ART_VERSIONS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19 attribute3 OKC_STD_ART_VERSIONS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20 attribute4 OKC_STD_ART_VERSIONS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21 attribute5 OKC_STD_ART_VERSIONS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22 attribute6 OKC_STD_ART_VERSIONS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23 attribute7 OKC_STD_ART_VERSIONS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24 attribute8 OKC_STD_ART_VERSIONS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25 attribute9 OKC_STD_ART_VERSIONS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26 attribute10 OKC_STD_ART_VERSIONS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27 attribute11 OKC_STD_ART_VERSIONS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28 attribute12 OKC_STD_ART_VERSIONS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29 attribute13 OKC_STD_ART_VERSIONS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30 attribute14 OKC_STD_ART_VERSIONS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31 attribute15 OKC_STD_ART_VERSIONS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
32 g_miss_sav_rec sav_rec_type;
33 TYPE sav_tbl_type IS TABLE OF sav_rec_type
34 INDEX BY BINARY_INTEGER;
35 TYPE OkcStdArtVersionsTlRecType IS RECORD (
36 sae_id NUMBER := OKC_API.G_MISS_NUM,
37 sav_release OKC_STD_ART_VERSIONS_TL.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
38 language OKC_STD_ART_VERSIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
39 source_lang OKC_STD_ART_VERSIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
40 sfwt_flag OKC_STD_ART_VERSIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
41 object_version_number NUMBER := OKC_API.G_MISS_NUM,
42 created_by NUMBER := OKC_API.G_MISS_NUM,
43 creation_date OKC_STD_ART_VERSIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45 last_update_date OKC_STD_ART_VERSIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46 text OKC_STD_ART_VERSIONS_TL.TEXT%TYPE ,
47 short_description OKC_STD_ART_VERSIONS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
48 last_update_login NUMBER := OKC_API.G_MISS_NUM);
49 GMissOkcStdArtVersionsTlRec OkcStdArtVersionsTlRecType;
50 TYPE OkcStdArtVersionsTlTblType IS TABLE OF OkcStdArtVersionsTlRecType
51 INDEX BY BINARY_INTEGER;
52 TYPE savv_rec_type IS RECORD (
53 sae_id NUMBER := OKC_API.G_MISS_NUM,
54 sav_release OKC_STD_ART_VERSIONS_V.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
55 object_version_number NUMBER := OKC_API.G_MISS_NUM,
56 sfwt_flag OKC_STD_ART_VERSIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57 date_active OKC_STD_ART_VERSIONS_V.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
58 text OKC_STD_ART_VERSIONS_V.TEXT%TYPE ,
59 short_description OKC_STD_ART_VERSIONS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
60 attribute_category OKC_STD_ART_VERSIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
61 attribute1 OKC_STD_ART_VERSIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
62 attribute2 OKC_STD_ART_VERSIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
63 attribute3 OKC_STD_ART_VERSIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
64 attribute4 OKC_STD_ART_VERSIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
65 attribute5 OKC_STD_ART_VERSIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
66 attribute6 OKC_STD_ART_VERSIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
67 attribute7 OKC_STD_ART_VERSIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
68 attribute8 OKC_STD_ART_VERSIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
69 attribute9 OKC_STD_ART_VERSIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
70 attribute10 OKC_STD_ART_VERSIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71 attribute11 OKC_STD_ART_VERSIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72 attribute12 OKC_STD_ART_VERSIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73 attribute13 OKC_STD_ART_VERSIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74 attribute14 OKC_STD_ART_VERSIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75 attribute15 OKC_STD_ART_VERSIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76 created_by NUMBER := OKC_API.G_MISS_NUM,
77 creation_date OKC_STD_ART_VERSIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79 last_update_date OKC_STD_ART_VERSIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80 last_update_login NUMBER := OKC_API.G_MISS_NUM);
81 g_miss_savv_rec savv_rec_type;
82 TYPE savv_tbl_type IS TABLE OF savv_rec_type
83 INDEX BY BINARY_INTEGER;
84 ---------------------------------------------------------------------------
85 -- GLOBAL MESSAGE CONSTANTS
86 ---------------------------------------------------------------------------
87 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
88 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
89 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
90 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
91 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
92 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
93 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
94 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
95 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
96 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
97 ---------------------------------------------------------------------------
98 -- GLOBAL VARIABLES
99 ---------------------------------------------------------------------------
100 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_SAV_PVT';
101 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
102
103 /******************ADDED AFTER TAPI****************/
104 --GLOBAL MESSAGES
105
106 G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
107 G_NO_PARENT_RECORD CONSTANT varchar2(200) := 'OKC_NO_PARENT_RECORD';
108 G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
109 G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
110 G_NOT_UPPER CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
111 -- G_LESS_THAN_SYSDATE CONSTANT VARCHAR2(200) := 'OKC_LESS_THAN_SYSDATE';
112 G_LESS_THAN_RELEASE_DATE CONSTANT VARCHAR2(200) := 'OKC_LESS_THAN_RELEASE_DATE';
113 G_ATE_REFERENCES CONSTANT VARCHAR2(200) := 'OKC_ATE_REFERENCES';
114 G_ATE_CANNOT_DELETE CONSTANT VARCHAR2(200) := 'OKC_ATE_CANNOT_DELETE';
115 G_NOT_LATEST CONSTANT VARCHAR2(200) := 'OKC_NOT_LATEST_RELEASE';
116
117 --GLOBAL VARIABLES
118 G_VIEW CONSTANT varchar2(30) := 'OKC_STD_ART_VERSIONS_V';
119 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
120
121 -------------------------------------------------------------------
122 -- Individual Field Validation Procedures
123 -------------------------------------------------------------------
124 PROCEDURE validate_sav_release(p_savv_rec IN savv_rec_type,
125 x_return_status OUT NOCOPY VARCHAR2);
126
127 PROCEDURE validate_date_active(p_savv_rec IN savv_rec_type,
128 x_return_status OUT NOCOPY VARCHAR2);
129
130 PROCEDURE validate_no_k_attached(p_savv_rec IN savv_rec_type,
131 x_return_status OUT NOCOPY VARCHAR2);
132
133 PROCEDURE validate_latest(p_savv_rec IN savv_rec_type,
134 x_return_status OUT NOCOPY VARCHAR2);
135
136 PROCEDURE validate_updatable(p_savv_rec IN savv_rec_type,
137 x_return_status OUT NOCOPY VARCHAR2);
138
139 /****************END ADDED AFTER TAPI**************/
140
141 ---------------------------------------------------------------------------
142 -- Procedures and Functions
143 ---------------------------------------------------------------------------
144
145 PROCEDURE qc;
146 PROCEDURE change_version;
147 PROCEDURE api_copy;
148 PROCEDURE add_language;
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_savv_rec IN savv_rec_type,
156 x_savv_rec OUT NOCOPY savv_rec_type);
157
158 PROCEDURE insert_row(
159 p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 p_savv_tbl IN savv_tbl_type,
165 x_savv_tbl OUT NOCOPY savv_tbl_type);
166
167 PROCEDURE lock_row(
168 p_api_version IN NUMBER,
169 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2,
173 p_savv_rec IN savv_rec_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_savv_tbl IN savv_tbl_type);
182
183 PROCEDURE update_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_savv_rec IN savv_rec_type,
190 x_savv_rec OUT NOCOPY savv_rec_type);
191
192 PROCEDURE update_row(
193 p_api_version IN NUMBER,
194 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2,
198 p_savv_tbl IN savv_tbl_type,
199 x_savv_tbl OUT NOCOPY savv_tbl_type);
200
201 PROCEDURE delete_row(
202 p_api_version IN NUMBER,
203 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2,
207 p_savv_rec IN savv_rec_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_savv_tbl IN savv_tbl_type);
216
217 PROCEDURE validate_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_savv_rec IN savv_rec_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_savv_tbl IN savv_tbl_type);
232
233 END OKC_SAV_PVT;