[Home] [Help]
PACKAGE: APPS.JTF_TERR_CNR_GROUPS_PVT
Source
1 PACKAGE JTF_TERR_CNR_GROUPS_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfvcngs.pls 120.0 2005/06/02 18:22:08 appldev ship $ */
3
4 -- ---------------------------------------------------
5 -- Start of Comments
6 -- ---------------------------------------------------
7 -- PACKAGE NAME: JTF_TERR_CNR_GROUPS_PVT
8 -- ---------------------------------------------------
9 -- PURPOSE
10 -- Joint task force core territory CNR GROUPS private api's.
11 -- This package is a private API for inserting customer name
12 -- range (CNR) groups into JTF tables. It contains specification
13 -- for pl/sql records.
14 --
15 -- PROCEDURES:
16 --
17 --
18 -- NOTES
19 -- This package is for PRIVATE USE ONLY
20 --
21 -- HISTORY
22 -- 01/29/01 ARPATEL Created
23 -- 05/16/01 ARPATEL Added Record types: Terr_cnr_values_rec_type and Terr_cnr_values_out_rec_type
24 -- Added API's for JTF_TERR_CNR_GROUP_VALUES.
25 -- 04/25/02 ARPATEL Removed security_group_id references.
26 --
27 -- End of Comments
28 --
29
30 TYPE Terr_cnr_group_rec_type IS RECORD
31 (
32 CNR_GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
33 LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
34 LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
35 CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
36 CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
37 LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
38 NAME VARCHAR2(255), -- := FND_API.G_MISS_CHAR,
39 DESCRIPTION VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
40 ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
41 ATTRIBUTE1 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
42 ATTRIBUTE2 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
43 ATTRIBUTE3 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
44 ATTRIBUTE4 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
45 ATTRIBUTE5 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
46 ATTRIBUTE6 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
47 ATTRIBUTE7 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
48 ATTRIBUTE8 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
49 ATTRIBUTE9 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
50 ATTRIBUTE10 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
51 ATTRIBUTE11 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
52 ATTRIBUTE12 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
53 ATTRIBUTE13 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
54 ATTRIBUTE14 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
55 ATTRIBUTE15 VARCHAR2(150) -- := FND_API.G_MISS_CHAR
56 );
57
58 G_MISS_TERR_CNR_GROUP_REC Terr_cnr_group_rec_type;
59
60
61 -- ***********************************************************
62 -- Start of Comments
63 -- -----------------------------------------------------------
64 -- Territory Resource out Record: Terr_cnr_group_out_rec_type
65 -- -----------------------------------------------------------
66 -- Parameters:
67 -- CNR_GROUP_ID Customer name group id
68 -- RETURN_STATUS Status
69 -- Required:
70 -- Defaults:
71 -- Note:
72 --
73 -- End of Comments
74
75
76 TYPE Terr_cnr_group_out_rec_type IS RECORD
77 (
78 CNR_GROUP_ID NUMBER, --:= FND_API.G_MISS_NUM,
79 RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR
80 );
81
82 G_MISS_TERR_CNR_GROUP_OUT_REC Terr_cnr_group_out_rec_type;
83
84
85 -- ***********************************************************
86 -- Start of Comments
87 -- -----------------------------------------------------------
88 -- Territory Resource in Record: Terr_cnr_group_values_rec_type
89 -- -----------------------------------------------------------
90 -- End of Comments
91
92 TYPE Terr_cnr_values_rec_type IS RECORD
93 (
94 CNR_GROUP_VALUE_ID NUMBER , -- := FND_API.G_MISS_NUM,
95 LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
96 LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
97 CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
98 CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
99 LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
100 CNR_GROUP_ID NUMBER , -- := FND_API.G_MISS_NUM,
101 COMPARISON_OPERATOR VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
102 LOW_VALUE_CHAR VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
103 HIGH_VALUE_CHAR VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
104 START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
105 END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
106 ORG_ID NUMBER -- := FND_API.G_MISS_NUM
107 );
108
109 G_MISS_TERR_CNR_VALUES_REC Terr_cnr_values_rec_type;
110
111
112 -- ***********************************************************
113 -- Start of Comments
114 -- -----------------------------------------------------------
115 -- Territory Resource out Record: Terr_cnr_group_values_out_rec_type
116 -- -----------------------------------------------------------
117 -- Parameters:
118 -- CNR_GROUP_ID Customer name range group value id
119 -- RETURN_STATUS Status
120 -- Required:
121 -- Defaults:
122 -- Note:
123 --
124 -- End of Comments
125
126
127 TYPE Terr_cnr_values_out_rec_type IS RECORD
128 (
129 CNR_GROUP_VALUE_ID NUMBER, --:= FND_API.G_MISS_NUM,
130 RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR
131 );
132
133 G_MISS_TERR_CNR_VALUES_OUT_REC Terr_cnr_values_out_rec_type;
134
135
136 -- ***************************************************
137 -- start of comments
138 -- ***************************************************
139 -- API name : Create_Terr_Cnr_Group
140 -- Type : PUBLIC
141 -- Function : To create CNR groupings.
142 --
143 -- Pre-reqs :
144 --
145 -- End of Comments
146 --
147
148 PROCEDURE Create_Terr_Cnr_Group
149 (
150 p_Api_Version_Number IN NUMBER,
151 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
152 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
153 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154 x_Return_Status OUT NOCOPY VARCHAR2,
155 x_Msg_Count OUT NOCOPY NUMBER,
156 x_Msg_Data OUT NOCOPY VARCHAR2,
157 p_Terr_cnr_group_rec IN Terr_cnr_group_rec_type := G_MISS_TERR_CNR_GROUP_REC,
158 x_Terr_cnr_group_out_rec OUT NOCOPY Terr_cnr_group_out_rec_type
159 );
160
161 PROCEDURE Create_Terr_Cnr_Value
162 (
163 p_Api_Version_Number IN NUMBER,
164 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
165 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
166 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167 x_Return_Status OUT NOCOPY VARCHAR2,
168 x_Msg_Count OUT NOCOPY NUMBER,
169 x_Msg_Data OUT NOCOPY VARCHAR2,
170 p_Terr_cnr_values_rec IN Terr_cnr_values_rec_type := G_MISS_TERR_CNR_VALUES_REC,
171 x_Terr_cnr_values_out_rec OUT NOCOPY Terr_cnr_values_out_rec_type
172 );
173
174
175
176
177 -- ***************************************************
178 -- start of comments
179 -- ***************************************************
180 --
181 -- API name : Delete_Terr_Cnr_Group
182 -- Type : PUBLIC
183 -- Function : To delete CNR groups
184 --
185 -- Pre-reqs :
186 -- Notes:
187 -- Rules for deletion have to be very strict
188 --
189 -- End of Comments
190 --
191
192 PROCEDURE Delete_Terr_Cnr_Group
193 (
194 p_Api_Version_Number IN NUMBER,
195 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
196 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
197 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198 X_Return_Status OUT NOCOPY VARCHAR2,
199 X_Msg_Count OUT NOCOPY NUMBER,
200 X_Msg_Data OUT NOCOPY VARCHAR2,
201 p_Terr_cnr_group_rec IN Terr_cnr_group_rec_type := G_MISS_TERR_CNR_GROUP_REC
202 );
203
204 PROCEDURE Delete_Terr_Cnr_Value
205 (
206 p_Api_Version_Number 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_Terr_cnr_values_rec IN Terr_cnr_values_rec_type := G_MISS_TERR_CNR_VALUES_REC
214 );
215
216
217
218
219 -- ***************************************************
220 -- start of comments
221 -- ***************************************************
222 -- API name : Update_Terr_Cnr_Group
223 -- Type : PUBLIC
224 -- Function : To Update customer name range groupings.
225 --
226 -- Pre-reqs :
227 -- End of Comments
228 --
229
230 PROCEDURE Update_Terr_Cnr_Group
231 (
232 p_Api_Version_Number IN NUMBER,
233 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
234 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
235 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
236 x_Return_Status OUT NOCOPY VARCHAR2,
237 x_Msg_Count OUT NOCOPY NUMBER,
238 x_Msg_Data OUT NOCOPY VARCHAR2,
239 p_Terr_cnr_group_rec IN Terr_cnr_group_rec_type := G_MISS_TERR_CNR_GROUP_REC,
240 x_Terr_cnr_group_out_rec OUT NOCOPY Terr_cnr_group_out_rec_type
241 );
242
243 PROCEDURE Update_Terr_Cnr_Value
244 (
245 p_Api_Version_Number IN NUMBER,
246 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
247 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
248 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249 x_Return_Status OUT NOCOPY VARCHAR2,
250 x_Msg_Count OUT NOCOPY NUMBER,
251 x_Msg_Data OUT NOCOPY VARCHAR2,
252 p_Terr_cnr_values_rec IN Terr_cnr_values_rec_type := G_MISS_TERR_CNR_VALUES_REC,
253 x_Terr_cnr_values_out_rec OUT NOCOPY Terr_cnr_values_out_rec_type
254 );
255
256
257
258 -- ***************************************************
259 -- start of comments
260 -- ***************************************************
261 -- API name : Validate_Cnr_Group_Value_Rec
262 -- Type : PUBLIC
263 -- Function : To Validate CNR group values.
264 --
265 -- Pre-reqs :
266 -- End of Comments
267 --
268
269 PROCEDURE Validate_Cnr_Group_Value_Rec
270 (
271 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272 x_Return_Status OUT NOCOPY VARCHAR2,
273 x_msg_count OUT NOCOPY NUMBER,
274 x_msg_data OUT NOCOPY VARCHAR2,
275 p_DML_Operation IN VARCHAR2,
276 p_Terr_cnr_group_rec IN Terr_cnr_group_rec_type := G_MISS_TERR_CNR_GROUP_REC
277 );
278
279 -- Package spec
280 END JTF_TERR_CNR_GROUPS_PVT;