[Home] [Help]
PACKAGE: APPS.OZF_PROCESS_SETUP_PVT
Source
1 PACKAGE OZF_PROCESS_SETUP_PVT AUTHID CURRENT_USER as
2 /* $Header: ozfvpses.pls 120.2 2008/07/03 07:08:31 kdass noship $ */
3 -- Start of Comments
4 -- Package name : ozf_process_setup_pvt
5 -- Purpose :
6 -- History : 09-OCT-2003 vansub Created
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:process_setup_rec_type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- PROCESS_SETUP_ID ,
19 -- SUPP_TRADE_PROFILE_ID ,
20 -- OBJECT_VERSION_NUMBER ,
21 -- LAST_UPDATE_DATE ,
22 -- LAST_UPDATED_BY ,
23 -- CREATION_DATE ,
24 -- CREATED_BY ,
25 -- LAST_UPDATE_LOGIN ,
26 -- REQUEST_ID ,
27 -- PROGRAM_APPLICATION_ID ,
28 -- PROGRAM_UPDATE_DATE ,
29 -- PROGRAM_ID ,
30 -- CREATED_FROM ,
31 -- PROCESS_CODE ,
32 -- ENABLED_FLAG ,
33 -- AUTOMATIC_FLAG ,
34 -- ATTRIBUTE_CATEGORY ,
35 -- ATTRIBUTE1 ,
36 -- ATTRIBUTE2 ,
37 -- ATTRIBUTE3 ,
38 -- ATTRIBUTE4 ,
39 -- ATTRIBUTE5 ,
40 -- ATTRIBUTE6 ,
41 -- ATTRIBUTE7 ,
42 -- ATTRIBUTE8 ,
43 -- ATTRIBUTE9 ,
44 -- ATTRIBUTE10 ,
45 -- ATTRIBUTE11 ,
46 -- ATTRIBUTE12 ,
47 -- ATTRIBUTE13 ,
48 -- ATTRIBUTE14 ,
49 -- ATTRIBUTE15 ,
50 -- ORG_ID ,
51 -- SECURITY_GROUP_ID ,
52 -- Required:
53 -- Defaults:
54 --
55 -- End of Comments
56
57 TYPE process_setup_rec_type IS RECORD
58 (
59 PROCESS_SETUP_ID NUMBER,
60 OBJECT_VERSION_NUMBER NUMBER,
61 LAST_UPDATE_DATE DATE,
62 LAST_UPDATED_BY NUMBER,
63 CREATION_DATE DATE,
64 CREATED_BY NUMBER,
65 LAST_UPDATE_LOGIN NUMBER,
66 REQUEST_ID NUMBER,
67 PROGRAM_APPLICATION_ID NUMBER,
68 PROGRAM_UPDATE_DATE DATE ,
69 PROGRAM_ID NUMBER,
70 CREATED_FROM VARCHAR2(30),
71 ORG_ID NUMBER,
72 SUPP_TRADE_PROFILE_ID NUMBER,
73 PROCESS_CODE VARCHAR2(60),
74 ENABLED_FLAG VARCHAR2(30),
75 AUTOMATIC_FLAG VARCHAR2(1),
76 ATTRIBUTE_CATEGORY VARCHAR2(30),
77 ATTRIBUTE1 VARCHAR2(150),
78 ATTRIBUTE2 VARCHAR2(150),
79 ATTRIBUTE3 VARCHAR2(150),
80 ATTRIBUTE4 VARCHAR2(150),
81 ATTRIBUTE5 VARCHAR2(150),
82 ATTRIBUTE6 VARCHAR2(150),
83 ATTRIBUTE7 VARCHAR2(150),
84 ATTRIBUTE8 VARCHAR2(150),
85 ATTRIBUTE9 VARCHAR2(150),
86 ATTRIBUTE10 VARCHAR2(150),
87 ATTRIBUTE11 VARCHAR2(150),
88 ATTRIBUTE12 VARCHAR2(150),
89 ATTRIBUTE13 VARCHAR2(150),
90 ATTRIBUTE14 VARCHAR2(150),
91 ATTRIBUTE15 VARCHAR2(150),
92 SECURITY_GROUP_ID NUMBER
93
94 );
95
96 g_miss_process_setup_rec process_setup_rec_type;
97 TYPE process_setup_tbl_type IS TABLE OF process_setup_rec_type;
98 g_miss_process_setup_tbl process_setup_tbl_type;
99
100 -- *******************************************************
101 -- Start of Comments
102 -- *******************************************************
103 -- API Name: create_process_setup
104 -- Type : Private
105 -- Pre-Req :
106 -- Parameters:
107 -- IN
108 -- p_api_version_number IN NUMBER Required
109 -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
110 -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
111 -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
112 -- P_process_setup_tbl IN process_setup_tbl_type Required
113 --
114 -- OUT:
115 -- x_return_status OUT NOCOPY VARCHAR2
116 -- x_msg_count OUT NOCOPY NUMBER
117 -- x_msg_data OUT NOCOPY VARCHAR2
118 -- Version : Current version 1.0
119 --
120 -- End of Comments
121 --
122 PROCEDURE create_process_setup(
123 p_api_version_number IN NUMBER,
124 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
126 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2,
130 p_process_setup_tbl IN process_setup_tbl_type ,
131 x_process_setup_id_tbl OUT NOCOPY JTF_NUMBER_TABLE);
132
133 -- *******************************************************
134 -- Start of Comments
135 -- *******************************************************
136 -- API Name: Update_process_setup
137 -- Type : Private
138 -- Pre-Req :
139 -- Parameters:
140 -- IN
141 -- p_api_version_number IN NUMBER Required
142 -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
143 -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
144 -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
145 -- p_process_setup_tbl IN process_setup_tbl_type Required
146 --
147 -- OUT:
148 -- x_return_status OUT NOCOPY VARCHAR2
149 -- x_msg_count OUT NOCOPY NUMBER
150 -- x_msg_data OUT NOCOPY VARCHAR2
151 -- x_object_version_number OUT NOCOPY NUMBER
152 -- Version : Current version 1.0
153 --
154 -- End of Comments
155 --
156 PROCEDURE Update_process_setup(
157 P_Api_Version_Number IN NUMBER,
158 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
159 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
160 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161 X_Return_Status OUT NOCOPY VARCHAR2,
162 X_Msg_Count OUT NOCOPY NUMBER,
163 X_Msg_Data OUT NOCOPY VARCHAR2,
164 p_process_setup_tbl IN process_setup_tbl_type ,
165 X_Object_Version_Number OUT NOCOPY JTF_NUMBER_TABLE);
166 -- *******************************************************
167 -- Start of Comments
168 -- *******************************************************
169 -- API Name: update_process_setup_tbl
170 -- Type : Private
171 -- Pre-Req :
172 -- Parameters:
173 -- IN
174 -- p_api_version_number IN NUMBER Required
175 -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
176 -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
177 -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
178 -- p_process_setup_tbl IN process_setup_tbl_type , Required
179 --
180 -- OUT:
181 -- x_return_status OUT NOCOPY VARCHAR2
182 -- x_msg_count OUT NOCOPY NUMBER
183 -- x_msg_data OUT NOCOPY VARCHAR2
184 -- Version : Current version 1.0
185 --
186 -- End of Comments
187 --
188 PROCEDURE update_process_setup_tbl(
189 P_Api_Version_Number IN NUMBER,
190 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
191 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
192 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193 X_Return_Status OUT NOCOPY VARCHAR2,
194 X_Msg_Count OUT NOCOPY NUMBER,
195 X_Msg_Data OUT NOCOPY VARCHAR2,
196 p_process_setup_tbl IN process_setup_tbl_type
197 );
198
199 -- *******************************************************
200 -- Start of Comments
201 -- *******************************************************
202 -- API Name: Check_uniq_process_setup
203 -- Type : Private
204 -- Pre-Req :
205 -- Parameters:
206 -- IN
207 -- p_process_setup_tbl IN process_setup_tbl_type , Required
208 -- p_validation_mode IN VARCHAR2 Optional Default=JTF_PLSQL_API.g_create
209 --
210 -- OUT:
211 -- x_return_status OUT NOCOPY VARCHAR2
212 --
213 -- Version : Current version 1.0
214 -- Description : Checks the uniqueness of the Reason Mapping for a Customer .
215 --
216 -- End of Comments
217 PROCEDURE Check_uniq_process_setup(
218 p_process_setup_rec IN process_setup_rec_type ,
219 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
220 x_return_status OUT NOCOPY VARCHAR2
221 );
222
223 /***
224 -- Start of Comments
225 --
226 -- Record level validation procedures
227 --
228 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
229 -- For create: G_CREATE, for update: G_UPDATE
230 -- End of Comments
231
232 PROCEDURE validate_process_setup_Rec(
233 P_Api_Version_Number IN NUMBER,
234 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
235 X_Return_Status OUT NOCOPY VARCHAR2,
236 X_Msg_Count OUT NOCOPY NUMBER,
237 X_Msg_Data OUT NOCOPY VARCHAR2,
238 p_process_setup_tbl IN PROCESS_SETUP_TBL_TYPE
239 );
240
241 ***/
242 -- Start of Comments
243 --
244 -- validation procedures
245 --
246 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
247 -- For create: G_CREATE, for update: G_UPDATE
248 -- End of Comments
249
250 PROCEDURE Validate_process_setup(
251 P_Api_Version_Number IN NUMBER,
252 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
253 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
254 P_Validation_mode IN VARCHAR2,
255 p_process_setup_tbl IN process_setup_tbl_type,
256 X_Return_Status OUT NOCOPY VARCHAR2,
257 X_Msg_Count OUT NOCOPY NUMBER,
258 X_Msg_Data OUT NOCOPY VARCHAR2
259 );
260
261 End ozf_process_setup_pvt;
262
263