1 PACKAGE ASO_PRICE_ADJ_RLTSHIP_PVT as
2 /* $Header: asovprls.pls 120.1 2005/06/29 12:43:35 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_PRICE_ADJ_RLTSHIP_PVT
5 -- Purpose :
6 -- History :
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
14
15 -- *******************************************************
16 -- Start of Comments
17 -- *******************************************************
18 -- API Name: Create_price_adj_rltship
19 -- Type : Private
20 -- Pre-Req :
21 -- Parameters:
22 -- IN
23 -- p_api_version_number IN NUMBER Required
24 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
25 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
26 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
27 -- P_PRICE_ADJ_RLTSHIP_Rec IN PRICE_ADJ_RLTSHIP_Rec_Type Required
28 --
29 -- OUT:
30 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
32 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33 -- Version : Current version 2.0
34 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
35 -- and basic operation, developer must manually add parameters and business logic as necessary.
36 --
37 -- End of Comments
38 --
39 PROCEDURE Create_price_adj_rltship(
40 P_Api_Version_Number IN NUMBER,
41 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
42 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
43 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44 P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_RLTSHIP_REC,
45 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
46 X_ADJ_RELATIONSHIP_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
47 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
48 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
49 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
50 );
51
52 -- *******************************************************
53 -- Start of Comments
54 -- *******************************************************
55 -- API Name: Update_price_adj_rltship
56 -- Type : Private
57 -- Pre-Req :
58 -- Parameters:
59 -- IN
60 -- p_api_version_number IN NUMBER Required
61 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
62 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
63 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
64 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
65 -- P_PRICE_ADJ_RLTSHIP_Rec IN PRICE_ADJ_RLTSHIP_Rec_Type Required
66 --
67 -- OUT:
68 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
69 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
70 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
71 -- Version : Current version 2.0
72 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
73 -- and basic operation, developer must manually add parameters and business logic as necessary.
74 --
75 -- End of Comments
76 --
77 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
78 PROCEDURE Update_price_adj_rltship(
79 P_Api_Version_Number IN NUMBER,
80 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
81 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
82 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83 P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type,
84 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
85 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
86 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
87 );
88
89 -- *******************************************************
90 -- Start of Comments
91 -- *******************************************************
92 -- API Name: Delete_price_adj_rltship
93 -- Type : Private
94 -- Pre-Req :
95 -- Parameters:
96 -- IN
97 -- p_api_version_number IN NUMBER Required
98 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
99 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
100 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
101 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
102 -- P_PRICE_ADJ_RLTSHIP_Rec IN PRICE_ADJ_RLTSHIP_Rec_Type Required
103 --
104 -- OUT:
105 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
106 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
107 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108 -- Version : Current version 2.0
109 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
110 -- and basic operation, developer must manually add parameters and business logic as necessary.
111 --
112 -- End of Comments
113 --
114 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
115 -- The Master delete procedure may not be needed depends on different business requirements.
116 PROCEDURE Delete_price_adj_rltship(
117 P_Api_Version_Number IN NUMBER,
118 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
119 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
120 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121 P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type,
122 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
123 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
124 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
125 );
126
127
128 -- Start of Comments
129 --
130 -- Item level validation procedures
131 --
132 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
133 -- For create: G_CREATE, for update: G_UPDATE
134 -- Note: 1. This is automated generated item level validation procedure.
135 -- The actual validation detail is needed to be added.
136 --
137 -- End of Comments
138
139 PROCEDURE Validate_ADJ_RELATIONSHIP_ID (
140 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
141 P_Validation_mode IN VARCHAR2,
142 P_ADJ_RELATIONSHIP_ID IN NUMBER,
143 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
144 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
145 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
146 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
147 );
148
149 -- Start of Comments
150 --
151 -- Item level validation procedures
152 --
153 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
154 -- For create: G_CREATE, for update: G_UPDATE
155 -- Note: 1. This is automated generated item level validation procedure.
156 -- The actual validation detail is needed to be added.
157 --
158 -- End of Comments
159
160 PROCEDURE Validate_PROGRAM_APPL_ID (
161 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
162 P_Validation_mode IN VARCHAR2,
163 P_PROGRAM_APPLICATION_ID IN NUMBER,
164 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
165 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
166 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
167 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
168 );
169
170 -- Start of Comments
171 --
172 -- Item level validation procedures
173 --
174 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
175 -- For create: G_CREATE, for update: G_UPDATE
176 -- Note: 1. This is automated generated item level validation procedure.
177 -- The actual validation detail is needed to be added.
178 --
179 -- End of Comments
180
181 PROCEDURE Validate_PROGRAM_ID (
182 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
183 P_Validation_mode IN VARCHAR2,
184 P_PROGRAM_ID IN NUMBER,
185 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
186 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
187 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
188 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
189 );
190
191 -- Start of Comments
192 --
193 -- Item level validation procedures
194 --
195 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
196 -- For create: G_CREATE, for update: G_UPDATE
197 -- Note: 1. This is automated generated item level validation procedure.
198 -- The actual validation detail is needed to be added.
199 --
200 -- End of Comments
201
202 PROCEDURE Validate_PROGRAM_UPDATE_DATE (
203 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
204 P_Validation_mode IN VARCHAR2,
205 P_PROGRAM_UPDATE_DATE IN DATE,
206 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
207 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
208 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
209 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
210 );
211
212 -- Start of Comments
213 --
214 -- Item level validation procedures
215 --
216 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
217 -- For create: G_CREATE, for update: G_UPDATE
218 -- Note: 1. This is automated generated item level validation procedure.
219 -- The actual validation detail is needed to be added.
220 --
221 -- End of Comments
222
223 PROCEDURE Validate_REQUEST_ID (
224 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
225 P_Validation_mode IN VARCHAR2,
226 P_REQUEST_ID IN NUMBER,
227 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
228 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
229 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
230 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
231 );
232
233 -- Start of Comments
234 --
235 -- Item level validation procedures
236 --
237 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
238 -- For create: G_CREATE, for update: G_UPDATE
239 -- Note: 1. This is automated generated item level validation procedure.
240 -- The actual validation detail is needed to be added.
241 --
242 -- End of Comments
243
244 PROCEDURE Validate_QUOTE_LINE_ID (
245 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
246 P_Validation_mode IN VARCHAR2,
247 P_QUOTE_LINE_ID IN NUMBER,
248 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
249 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
250 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
251 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
252 );
253
254 -- Start of Comments
255 --
256 -- Item level validation procedures
257 --
258 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
259 -- For create: G_CREATE, for update: G_UPDATE
260 -- Note: 1. This is automated generated item level validation procedure.
261 -- The actual validation detail is needed to be added.
262 --
263 -- End of Comments
264
265 PROCEDURE Validate_PRICE_ADJUSTMENT_ID (
266 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
267 P_Validation_mode IN VARCHAR2,
268 P_PRICE_ADJUSTMENT_ID IN NUMBER,
269 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
270 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
271 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
272 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
273 );
274
275 -- Start of Comments
276 --
277 -- Item level validation procedures
278 --
279 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
280 -- For create: G_CREATE, for update: G_UPDATE
281 -- Note: 1. This is automated generated item level validation procedure.
282 -- The actual validation detail is needed to be added.
283 --
284 -- End of Comments
285
286 PROCEDURE Validate_RLTD_PRICE_ADJ_ID (
287 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
288 P_Validation_mode IN VARCHAR2,
289 P_RLTD_PRICE_ADJ_ID IN NUMBER,
290 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
291 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
292 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
293 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
294 );
295
296 -- Start of Comments
297 --
298 -- Record level validation procedures
299 --
300 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
301 -- For create: G_CREATE, for update: G_UPDATE
302 -- Note: 1. This is automated generated item level validation procedure.
303 -- The actual validation detail is needed to be added.
304 -- 2. Developer can manually added inter-field level validation.
305 -- End of Comments
306
307 PROCEDURE Validate_PRICE_ADJ_RLTSHIP_rec(
308 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
309 P_Validation_mode IN VARCHAR2,
310 P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type,
311 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
312 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
313 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
314 );
315
316 -- Start of Comments
317 --
318 -- validation procedures
319 --
320 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
321 -- For create: G_CREATE, for update: G_UPDATE
322 -- Note: 1. This is automated generated item level validation procedure.
323 -- The actual validation detail is needed to be added.
324 -- 2. We can also validate table instead of record. There will be an option for user to choose.
325 -- End of Comments
326
327 PROCEDURE Validate_price_adj_rltship(
328 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
329 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330 P_Validation_mode IN VARCHAR2,
331 P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type,
332 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
333 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
334 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
335 );
336 End ASO_PRICE_ADJ_RLTSHIP_PVT;