[Home] [Help]
PACKAGE: APPS.JTF_QUALIFIER_PUB
Source
1 PACKAGE JTF_QUALIFIER_PUB AUTHID CURRENT_USER AS
2 /* $Header: jtfptrqs.pls 120.0 2005/06/02 18:20:53 appldev ship $ */
3
4 -- ---------------------------------------------------
5 -- Start of Comments
6 -- ---------------------------------------------------
7 -- PACKAGE NAME: JTF_QUALIFIER_PUB
8 -- ---------------------------------------------------
9 -- PURPOSE
10 -- Joint task force core territory manager public api's.
11 -- This package is a public API for inserting, updating and deleting
12 -- qualifier related information into JTF tables.
13 -- It contains specification for pl/sql records and tables
14 -- and the Public territory related API's.
15 --
16 -- Procedures:
17 --
18 --
19 -- NOTES
20 -- This package is publicly available for use
21 --
22 -- HISTORY
23 -- 07/15/99 JDOCHERT Created
24 -- 10/05/99 VNEDUNGA Changing the record group
25 -- to accomodate schema changes
26 -- 03/28/00 VNEDUNGA Adding new columns for eliminating
27 -- dependency to AS_INTERESTS in
28 -- JTF_QUAL_USGS table
29 --
30 -- End of Comments
31
32
33 -- ***************************************************
34 -- Start of Comments
35 -- ---------------------------------------------------
36 -- Seeded qualifier record type: Seed_Qual_Rec_Type
37 -- ---------------------------------------------------
38 --
39 -- Notes
40 --
41 --
42 -- End of Comments
43 --
44
45
46 TYPE Seed_Qual_Rec_Type IS RECORD
47 (SEEDED_QUAL_ID NUMBER ,-- := FND_API.G_MISS_NUM,
48 QUAL_TYPE_ID NUMBER ,-- := FND_API.G_MISS_NUM,
49 LAST_UPDATE_DATE DATE ,-- := FND_API.G_MISS_DATE,
50 LAST_UPDATED_BY NUMBER ,-- := FND_API.G_MISS_NUM,
51 CREATION_DATE DATE ,-- := FND_API.G_MISS_DATE,
52 CREATED_BY NUMBER ,-- := FND_API.G_MISS_NUM,
53 LAST_UPDATE_LOGIN NUMBER ,-- := FND_API.G_MISS_NUM,
54 NAME VARCHAR2(60) ,-- := FND_API.G_MISS_CHAR,
55 DESCRIPTION VARCHAR2(240) ,-- := FND_API.G_MISS_CHAR
56 ORG_ID NUMBER
57 );
58
59
60 TYPE Seed_Qual_Tbl_Type IS TABLE OF Seed_Qual_Rec_Type
61 INDEX BY BINARY_INTEGER;
62
63 G_MISS_SEED_QUAL_REC Seed_Qual_Rec_Type;
64
65 G_MISS_SEED_QUAL_TBL Seed_Qual_Tbl_Type;
66
67
68 -- ***************************************************
69 -- Start of Comments
70 -- ---------------------------------------------------
71 -- Qualifier Usages All record type: Qual_Usgs_All_Rec_Type
72 -- ---------------------------------------------------
73 --
74 -- Notes
75 --
76 --
77 -- End of Comments
78 --
79 TYPE Qual_Usgs_All_Rec_Type IS RECORD
80 (
81 QUAL_USG_ID NUMBER ,---:= FND_API.G_MISS_NUM,
82 LAST_UPDATE_DATE DATE ,-- := FND_API.G_MISS_DATE,
83 LAST_UPDATED_BY NUMBER ,-- := FND_API.G_MISS_NUM,
84 CREATION_DATE DATE ,-- := FND_API.G_MISS_DATE,
85 CREATED_BY NUMBER ,-- := FND_API.G_MISS_NUM,
86 LAST_UPDATE_LOGIN NUMBER ,-- := FND_API.G_MISS_NUM,
87 APPLICATION_SHORT_NAME VARCHAR2(50) ,-- := FND_API.G_MISS_CHAR,
88 SEEDED_QUAL_ID NUMBER ,-- := FND_API.G_MISS_NUM,
89 QUAL_TYPE_USG_ID NUMBER ,-- := FND_API.G_MISS_NUM,
90 ENABLED_FLAG VARCHAR2(1) ,-- := FND_API.G_MISS_CHAR,
91 QUAL_COL1 VARCHAR2(30) ,-- := FND_API.G_MISS_CHAR,
92 QUAL_COL1_ALIAS VARCHAR2(60) ,-- := FND_API.G_MISS_CHAR,
93 QUAL_COL1_DATATYPE VARCHAR2(30) ,-- := FND_API.G_MISS_CHAR,
94 QUAL_COL1_TABLE VARCHAR2(30) ,-- := FND_API.G_MISS_CHAR,
95 QUAL_COL1_TABLE_ALIAS VARCHAR2(30) ,-- := FND_API.G_MISS_CHAR,
96 PRIM_INT_CDE_COL VARCHAR2(30) ,-- := FND_API.G_MISS_CHAR,
97 PRIM_INT_CDE_COL_DATATYPE VARCHAR2(30) ,-- := FND_API.G_MISS_CHAR,
98 PRIM_INT_CDE_COL_ALIAS VARCHAR2(60) ,-- := FND_API.G_MISS_CHAR,
99 SEC_INT_CDE_COL VARCHAR2(30) ,-- := FND_API.G_MISS_CHAR,
100 SEC_INT_CDE_COL_ALIAS VARCHAR2(30) ,-- := FND_API.G_MISS_CHAR,
101 sec_int_cde_col_datatype VARCHAR2(30) ,-- := FND_API.G_MISS_CHAR,
102 INT_CDE_COL_TABLE VARCHAR2(30) ,-- := FND_API.G_MISS_CHAR,
103 INT_CDE_COL_TABLE_ALIAS VARCHAR2(30) ,-- := FND_API.G_MISS_CHAR,
104 SEEDED_FLAG VARCHAR2(1) ,-- := FND_API.G_MISS_CHAR,
105 DISPLAY_TYPE VARCHAR2(40) ,-- := FND_API.G_MISS_CHAR,
106 LOV_SQL VARCHAR2(1000) ,-- := FND_API.G_MISS_CHAR,
107 CONVERT_TO_ID_FLAG VARCHAR2(01) ,-- := FND_API.G_MISS_CHAR
108 COLUMN_COUNT NUMBER ,-- := FND_API.G_MISS_NUM
109 FORMATTING_FUNCTION_FLAG VARCHAR2(01) ,-- := FND_API.G_MISS_CHAR
110 FORMATTING_FUNCTION_NAME VARCHAR2(120) ,-- := FND_API.G_MISS_CHAR
111 SPECIAL_FUNCTION_FLAG VARCHAR2(01) ,-- := FND_API.G_MISS_CHAR
112 SPECIAL_FUNCTION_NAME VARCHAR2(120) ,-- := FND_API.G_MISS_CHAR
113 ENABLE_LOV_VALIDATION VARCHAR2(01) ,-- := FND_API.G_MISS_CHAR
114 DISPLAY_SQL1 VARCHAR2(1000) ,-- := FND_API.G_MISS_CHAR
115 LOV_SQL2 VARCHAR2(1000) ,-- := FND_API.G_MISS_CHAR
116 DISPLAY_SQL2 VARCHAR2(1000) ,-- := FND_API.G_MISS_CHAR
117 LOV_SQL3 VARCHAR2(1000) ,-- := FND_API.G_MISS_CHAR
118 DISPLAY_SQL3 VARCHAR2(1000) ,-- := FND_API.G_MISS_CHAR
119 ORG_ID NUMBER,
120 RULE1 varchar2(2000) ,
121 RULE2 varchar2(2000) ,
122 DISPLAY_SEQUENCE number,
123 DISPLAY_LENGTH number,
124 JSP_LOV_SQL varchar2(2000),
125 use_in_lookup_flag VARCHAR2(1)
126 );
127
128 TYPE Qual_Usgs_All_Tbl_Type IS TABLE OF Qual_Usgs_All_Rec_Type
129 INDEX BY BINARY_INTEGER;
130
131 G_MISS_QUAL_USGS_ALL_REC Qual_Usgs_All_Rec_Type;
132
133 G_MISS_QUAL_USGS_ALL_TBL Qual_Usgs_All_Tbl_Type;
134
135
136 -- ***************************************************
137 -- Start of Comments
138 -- ---------------------------------------------------
139 -- Seeded Qualifier Out record type: Seed_Qual_Out_Rec_Type
140 -- ---------------------------------------------------
141 -- Attributes:
142 -- SEEDED_QUAL_ID
143 -- RETURN_STATUS
144 --
145 -- Notes
146 --
147 --
148 -- End of Comments
149 --
150 TYPE Seed_Qual_Out_Rec_Type IS RECORD
151 (SEEDED_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM_NUM,
152 RETURN_STATUS VARCHAR2(1) -- := FND_API.G_MISS_NUM_CHAR
153 );
154
155
156 TYPE Seed_Qual_Out_Tbl_Type IS TABLE OF Seed_Qual_Out_Rec_Type
157 INDEX BY BINARY_INTEGER;
158
159 G_MISS_SEED_QUAL_OUT_REC Seed_Qual_Out_Rec_Type;
160
161 G_MISS_SEED_QUAL_OUT_TBL_TYPE Seed_Qual_Out_Tbl_Type;
162
163
164 -- ***************************************************
165 -- Start of Comments
166 -- ---------------------------------------------------
167 -- Qualifier Usages All Out record type: Qual_Usgs_All_Out_Rec_Type
168 -- ---------------------------------------------------
169 --
170 -- Notes
171 --
172 --
173 -- End of Comments
174 --
175 TYPE Qual_Usgs_All_Out_Rec_Type IS RECORD
176 (QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
177 RETURN_STATUS VARCHAR2(1) -- := FND_API.G_MISS_CHAR
178 );
179
180 TYPE Qual_Usgs_All_Out_Tbl_Type IS TABLE OF Qual_Usgs_All_Out_Rec_Type
181 INDEX BY BINARY_INTEGER;
182
183 G_MISS_QUAL_USGS_ALL_OUT_REC Qual_Usgs_All_Out_Rec_Type;
184
185 G_MISS_QUAL_USGS_ALL_OUT_TBL Qual_Usgs_All_Out_Tbl_Type;
186
187
188
189
190 -- ***************************************************
191 -- start of comments
192 -- ***************************************************
193 --
194 -- API name : Create_Qualifier
195 -- Type : PUBLIC
196 -- Function : To create qualifiers
197 --
198 -- Pre-reqs :
199 -- Parameters:
200 -- IN :
201 -- Required
202 -- Parameter Name Data Type Default
203 -- p_api_version NUMBER
204 -- p_Seed_Qual_Rec Seed_Qual_Rec_Type G_MISS_SEED_QUAL_REC
205 -- p_Qual_Usgs_Rec Qual_Usgs_All_Rec_Type G_MISS_QUAL_USGS_ALL_REC
206 --
207 -- Optional
208 -- Parameter Name Data Type Default
209 -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
210 -- P_Commit VARCHAR2 FND_API.G_FALSE
211 --
212 -- OUT :
213 -- Parameter Name Data Type Default
214 -- x_Return_Status VARCHAR2(1)
215 -- x_Msg_Count NUMBER
216 -- x_Msg_Data VARCHAR2(2000)
217 -- x_Seeded_Qual_Id NUMBER
218 -- x_Qual_Usgs_Id NUMBER
219 --
220 --
221 -- Notes:
222 --
223 --
224 -- End of Comments
225 --
226 PROCEDURE Create_Qualifier
227 (p_api_version IN NUMBER,
228 -- commented out eihsu 11/04
229 p_Init_Msg_List IN VARCHAR2 ,-- := FND_API.G_FALSE,
230 p_Commit IN VARCHAR2 ,-- := FND_API.G_FALSE,
231 x_Return_Status OUT NOCOPY VARCHAR2,
232 x_Msg_Count OUT NOCOPY NUMBER,
233 x_Msg_Data OUT NOCOPY VARCHAR2,
234 -- commented out eihsu 11/04
235 p_Seed_Qual_Rec IN Seed_Qual_Rec_Type ,--:= G_MISS_SEED_QUAL_REC,
236 p_Qual_Usgs_Rec IN Qual_Usgs_All_Rec_Type ,--:= G_MISS_QUAL_USGS_ALL_REC,
237 x_Seed_Qual_Rec OUT NOCOPY Seed_Qual_Out_Rec_Type,
238 x_Qual_Usgs_Rec OUT NOCOPY Qual_Usgs_All_Out_Rec_Type);
239
240
241 -- ***************************************************
242 -- start of comments
243 -- ***************************************************
244 --
245 -- API name : Update_Qualifier
246 -- Type : PUBLIC
247 -- Function : To update existing qualifiers
248 --
249 -- Pre-reqs :
250 -- Parameters:
251 -- IN :
252 -- Required
253 -- Parameter Name Data Type Default
254 -- p_api_version NUMBER
255 -- p_Seed_Qual_Rec Seed_Qual_Rec_Type G_MISS_SEED_QUAL_REC,
256 -- p_Qual_Usgs_Rec Qual_Usgs_All_Rec_Type G_MISS_QUAL_USGS_ALL_REC,
257 --
258 -- Optional
259 -- Parameter Name Data Type Default
260 -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
261 -- P_Commit VARCHAR2 FND_API.G_FALSE
262 --
263 -- OUT :
264 -- Parameter Name Data Type Default
265 -- x_Return_Status VARCHAR2(1)
266 -- x_Msg_Count NUMBER
267 -- x_Msg_Data VARCHAR2(2000)
268 -- x_Seed_Qual_Rec Seed_Qual_Out_Rec_Type,
269 -- x_Qual_Usgs_Rec Qual_Usgs_All_Out_Rec_Type);
270 --
271 --
272 -- Notes:
273 --
274 --
275 -- End of Comments
276 --
277 PROCEDURE Update_Qualifier
278 (p_api_version IN NUMBER, -- commented out eihsu 11/04
279 p_Init_Msg_List IN VARCHAR2 ,-- := FND_API.G_FALSE,
280 p_Commit IN VARCHAR2 ,-- := FND_API.G_FALSE,
281 x_Return_Status OUT NOCOPY VARCHAR2,
282 x_Msg_Count OUT NOCOPY NUMBER,
283 x_Msg_Data OUT NOCOPY VARCHAR2,
284 p_Seed_Qual_Rec IN Seed_Qual_Rec_Type ,-- := G_MISS_SEED_QUAL_REC,
285 p_Qual_Usgs_Rec IN Qual_Usgs_All_Rec_Type ,-- := G_MISS_QUAL_USGS_ALL_REC,
286 x_Seed_Qual_Rec OUT NOCOPY Seed_Qual_Out_Rec_Type,
287 x_Qual_Usgs_Rec OUT NOCOPY Qual_Usgs_All_Out_Rec_Type);
288
289
290
291
292 -- ***************************************************
293 -- start of comments
294 -- ***************************************************
295 --
296 -- API name : Delete_Qualifier
297 -- Type : PUBLIC
298 -- Function : To delete an existing qualifiers
299 --
300 -- Pre-reqs :
301 -- Parameters:
302 -- IN :
303 -- Required
304 -- Parameter Name Data Type Default
305 -- p_api_version NUMBER
306 -- p_Seeded_Qual_Id NUMBER FND_API.G_MISS_NUM,
307 -- p_Qual_Usgs_Id NUMBER FND_API.G_MISS_NUM);
308 --
309 -- Optional
310 -- Parameter Name Data Type Default
311 -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
312 -- P_Commit VARCHAR2 FND_API.G_FALSE
313 --
314 -- OUT :
315 -- Parameter Name Data Type Default
316 -- x_Return_Status VARCHAR2(1)
317 -- x_Msg_Count NUMBER
318 -- x_Msg_Data VARCHAR2(2000)
319 --
320 --
321 -- Notes:
322 --
323 --
324 -- End of Comments
325 --
326 PROCEDURE Delete_Qualifier
327 (p_api_version IN NUMBER,
328 p_Init_Msg_List IN VARCHAR2 ,-- := FND_API.G_FALSE,
329 p_Commit IN VARCHAR2 ,-- := FND_API.G_FALSE,
330 x_Return_Status OUT NOCOPY VARCHAR2,
331 x_Msg_Count OUT NOCOPY NUMBER,
332 x_Msg_Data OUT NOCOPY VARCHAR2,
333 p_Seeded_Qual_Id IN NUMBER ,-- := FND_API.G_MISS_NUM,
334 p_Qual_Usg_Id IN NUMBER -- := FND_API.G_MISS_NUM
335 );
336
337
338
339 END; -- Package Specification JTF_QUALIFIER_PUB