[Home] [Help]
PACKAGE: APPS.JTF_QUALIFIER_PVT
Source
1 Package JTF_QUALIFIER_PVT AS
2 /* $Header: jtfvtrqs.pls 120.0 2005/06/02 18:22:57 appldev ship $ */
3 -- ---------------------------------------------------
4 -- Start of Comments
5 -- ---------------------------------------------------
6 -- PACKAGE NAME: JTF_QUALIFIER_PVT
7 -- ---------------------------------------------------
8 -- PURPOSE
9 -- Joint task force core territory manager private api's.
10 -- This package is a private API for inserting, updating and deleting
11 -- qualifier related information into JTF tables.
12 -- It contains specification for pl/sql records and tables
13 -- and the Private territory related API's.
14 --
15 -- Procedures:
16 --
17 --
18 -- NOTES
19 -- This package is available for private use only.
20 --
21 -- HISTORY
22 -- 07/15/99 JDOCHERT Created
23 --
24 -- End of Comments
25
26
27 /* Insert seeded qualifier record into database */
28 PROCEDURE Create_Seed_Qual_Record
29 ( p_seed_qual_rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type,
30 x_seed_qual_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type );
31
32 /* Update seeded qualifier record in database */
33 PROCEDURE Update_Seed_Qual_Record
34 ( p_seed_qual_rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type,
35 x_seed_qual_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type );
36
37 /* Delete seeded qualifier record from database */
38 PROCEDURE Delete_Seed_Qual_Record
39 ( p_seeded_qual_id IN NUMBER,
40 x_return_status OUT NOCOPY VARCHAR2 );
41
42
43 /* Insert qualifier usage record into database */
44 PROCEDURE Create_Qual_Usgs_Record
45 ( p_seed_qual_id IN NUMBER,
46 p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type,
47 x_qual_usgs_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type);
48
49 /* Update qualifier usage record in database */
50 PROCEDURE Update_Qual_Usgs_Record
51 ( p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type,
52 x_qual_usgs_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type);
53
54 /* Delete qualifier usage record from database */
55 PROCEDURE Delete_Qual_Usgs_Record
56 ( p_qual_usg_id IN NUMBER,
57 x_return_status OUT NOCOPY VARCHAR2 );
58
59 /* Check if qualifier is used by any territories for qualifier disabling purposes */
60 PROCEDURE Check_Qualifier_Usage
61 ( l_qual_usg_id IN NUMBER,
62 l_qualifier_used OUT NOCOPY VARCHAR2 );
63
64
65 -- ***************************************************
66 -- start of comments
67 -- ***************************************************
68 --
69 -- API name : Create_Qualifier
70 -- Type : PRIVATE
71 -- Function : To create qualifiers
72 --
73 -- Pre-reqs :
74 -- Parameters:
75 -- IN :
76 -- Required
77 -- Parameter Name Data Type Default
78 -- p_api_version NUMBER
79 -- p_Seed_Qual_Rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC
80 -- p_Qual_Usgs_Rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC
81 --
82 -- Optional
83 -- Parameter Name Data Type Default
84 -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
85 -- P_Commit VARCHAR2 FND_API.G_FALSE
86 -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL
87 --
88 -- OUT :
89 -- Parameter Name Data Type Default
90 -- x_Return_Status VARCHAR2(1)
91 -- x_Msg_Count NUMBER
92 -- x_Msg_Data VARCHAR2(2000)
93 -- x_Seeded_Qual_Id NUMBER
94 -- x_Qual_Usgs_Id NUMBER
95 --
96 --
97 -- Notes:
98 --
99 --
100 -- End of Comments
101 --
102 PROCEDURE Create_Qualifier
103 (p_api_version IN NUMBER,
104 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
105 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
106 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107 x_Return_Status OUT NOCOPY VARCHAR2,
108 x_Msg_Count OUT NOCOPY NUMBER,
109 x_Msg_Data OUT NOCOPY VARCHAR2,
110 -- commented eihsu 11/4
111 p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type ,--:= JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,
112 p_Qual_Usgs_Rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type ,--:= JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC,
113 x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,
114 x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type);
115
116
117 -- ***************************************************
118 -- start of comments
119 -- ***************************************************
120 --
121 -- API name : Update_Qualifier
122 -- Type : PRIVATE
123 -- Function : To update existing qualifiers
124 --
125 -- Pre-reqs :
126 -- Parameters:
127 -- IN :
128 -- Required
129 -- Parameter Name Data Type Default
130 -- p_api_version NUMBER
131 -- p_Seed_Qual_Rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC
132 -- p_Qual_Usgs_Rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC
133 --
134 -- Optional
135 -- Parameter Name Data Type Default
136 -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
137 -- P_Commit VARCHAR2 FND_API.G_FALSE
138 -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL
139 --
140 -- OUT :
141 -- Parameter Name Data Type Default
142 -- x_Return_Status VARCHAR2(1)
143 -- x_Msg_Count NUMBER
144 -- x_Msg_Data VARCHAR2(2000)
145 -- x_Seed_Qual_Rec Seed_Qual_Out_Rec_Type,
146 -- x_Qual_Usgs_Rec Qual_Usgs_All_Out_Rec_Type);
147 --
148 --
149 -- Notes:
150 --
151 --
152 -- End of Comments
153 --
154 PROCEDURE Update_Qualifier
155 (p_api_version IN NUMBER,
156 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
157 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
158 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159 x_Return_Status OUT NOCOPY VARCHAR2,
160 x_Msg_Count OUT NOCOPY NUMBER,
161 x_Msg_Data OUT NOCOPY VARCHAR2,
162 p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,
163 p_Qual_Usgs_Rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC,
164 x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,
165 x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type);
166
167
168
169
170 -- ***************************************************
171 -- start of comments
172 -- ***************************************************
173 --
174 -- API name : Delete_Qualifier
175 -- Type : PRIVATE
176 -- Function : To delete an existing qualifiers
177 --
178 -- Pre-reqs :
179 -- Parameters:
180 -- IN :
181 -- Required
182 -- Parameter Name Data Type Default
183 -- p_api_version NUMBER
184 -- p_Seeded_Qual_Id NUMBER FND_API.G_MISS_NUM
185 -- p_Qual_Usgs_Id NUMBER FND_API.G_MISS_NUM
186 --
187 -- Optional
188 -- Parameter Name Data Type Default
189 -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
190 -- P_Commit VARCHAR2 FND_API.G_FALSE
191 -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL
192 --
193 -- OUT :
194 -- Parameter Name Data Type Default
195 -- x_Return_Status VARCHAR2(1)
196 -- x_Msg_Count NUMBER
197 -- x_Msg_Data VARCHAR2(2000)
198 --
199 --
200 -- Notes:
201 --
202 --
203 -- End of Comments
204 --
205 PROCEDURE Delete_Qualifier
206 (p_api_version IN NUMBER,
207 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
208 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
209 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
210 x_Return_Status OUT NOCOPY VARCHAR2,
211 x_Msg_Count OUT NOCOPY NUMBER,
212 x_Msg_Data OUT NOCOPY VARCHAR2,
213 p_Seeded_Qual_Id IN NUMBER := FND_API.G_MISS_NUM,
214 p_Qual_Usg_Id IN NUMBER := FND_API.G_MISS_NUM);
215
216
217 END JTF_QUALIFIER_PVT; -- Package Specification JTF_QUALIFIER_PVT