[Home] [Help]
PACKAGE: APPS.ASO_HEADER_RLTSHIP_PVT
Source
1 PACKAGE ASO_HEADER_RLTSHIP_PVT as
2 /* $Header: asovheds.pls 120.1 2005/06/29 12:41:45 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_HEADER_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 -- Start of Comments
15 -- *******************************************************
16 -- API Name: Create_header_rltship
17 -- Type : Private
18 -- Pre-Req :
19 -- Parameters:
20 -- IN
21 -- p_api_version_number IN NUMBER Required
22 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
23 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
24 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
25 -- P_HEADER_RLTSHIP_Rec IN HEADER_RLTSHIP_Rec_Type Required
26 --
27 -- OUT:
28 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
29 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
30 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31 -- Version : Current version 2.0
32 -- End of Comments
33 --
34 PROCEDURE Create_header_rltship(
35 P_Api_Version_Number IN NUMBER,
36 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
37 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
38 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
39 P_HEADER_RLTSHIP_Rec IN ASO_QUOTE_PUB.HEADER_RLTSHIP_Rec_Type := ASO_QUOTE_PUB.G_MISS_HEADER_RLTSHIP_REC,
40 X_HEADER_RELATIONSHIP_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
41 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
42 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
43 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
44 );
45
46 -- *******************************************************
47 -- Start of Comments
48 -- *******************************************************
49 -- API Name: Update_header_rltship
50 -- Type : Private
51 -- Pre-Req :
52 -- Parameters:
53 -- IN
54 -- p_api_version_number IN NUMBER Required
55 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
56 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
57 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
58 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
59 -- P_HEADER_RLTSHIP_Rec IN HEADER_RLTSHIP_Rec_Type Required
60 --
61 -- OUT:
62 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
63 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
64 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
65 -- Version : Current version 2.0
66 -- End of Comments
67 --
68 PROCEDURE Update_header_rltship(
69 P_Api_Version_Number IN NUMBER,
70 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
71 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
72 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73 P_HEADER_RLTSHIP_Rec IN ASO_quote_PUB.HEADER_RLTSHIP_Rec_Type,
74 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
75 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
76 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77 );
78
79 -- *******************************************************
80 -- Start of Comments
81 -- *******************************************************
82 -- API Name: Delete_header_rltship
83 -- Type : Private
84 -- Pre-Req :
85 -- Parameters:
86 -- IN
87 -- p_api_version_number IN NUMBER Required
88 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
89 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
90 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
91 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
92 -- P_HEADER_RLTSHIP_Rec IN HEADER_RLTSHIP_Rec_Type Required
93 --
94 -- OUT:
95 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
97 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
98 -- End of Comments
99 --
100 PROCEDURE Delete_header_rltship(
101 P_Api_Version_Number IN NUMBER,
102 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
103 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
104 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105 P_HEADER_RLTSHIP_id IN NUMBER,
106 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
107 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
108 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
109
110 );
111
112
113 PROCEDURE Delete_header_rltship(
114 P_Api_Version_Number IN NUMBER,
115 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
116 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
117 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118 P_HEADER_id IN NUMBER,
119 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
120 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
121 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
122
123 );
124
125 -- Start of Comments
126 --
127 -- Item level validation procedures
128 --
129 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
130 -- For create: G_CREATE, for update: G_UPDATE
131 -- Note: 1. This is automated generated item level validation procedure.
132 -- The actual validation detail is needed to be added.
133 --
134 -- End of Comments
135
136 PROCEDURE Validate_HEADER_RLTSHIP_ID (
137 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
138 P_Validation_mode IN VARCHAR2,
139 P_HEADER_RELATIONSHIP_ID IN NUMBER,
140 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
141 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
142 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
143 );
144
145 -- Start of Comments
146 --
147 -- Item level validation procedures
148 --
149 --
150 -- End of Comments
151
152 PROCEDURE Validate_REQUEST_ID (
153 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
154 P_Validation_mode IN VARCHAR2,
155 P_REQUEST_ID IN NUMBER,
156 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
157 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
158 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
159 );
160
161 -- Start of Comments
162 --
163 -- Item level validation procedures
164 --
165 -- End of Comments
166
167 PROCEDURE Validate_PROGRAM_APPL_ID (
168 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
169 P_Validation_mode IN VARCHAR2,
170 P_PROGRAM_APPLICATION_ID IN NUMBER,
171 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
172 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
173 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
174
175 );
176
177 -- Start of Comments
178 --
179 -- Item level validation procedures
180 --
181 --
182 -- End of Comments
183
184 PROCEDURE Validate_PROGRAM_ID (
185 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
186 P_Validation_mode IN VARCHAR2,
187 P_PROGRAM_ID IN NUMBER,
188 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
189 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
190 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
191 );
192
193 -- Start of Comments
194 --
195 -- Item level validation procedures
196 --
197 --
198 -- End of Comments
199
200 PROCEDURE Validate_PROGRAM_UPDATE_DATE (
201 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
202 P_Validation_mode IN VARCHAR2,
203 P_PROGRAM_UPDATE_DATE IN DATE,
204 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
205 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
206 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
207 );
208
209 -- Start of Comments
210 --
211 -- Item level validation procedures
212 --
213 -- End of Comments
214
215 PROCEDURE Validate_QUOTE_HEADER_ID (
216 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
217 P_Validation_mode IN VARCHAR2,
218 P_QUOTE_HEADER_ID IN NUMBER,
219 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
220 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
221 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
222 );
223
224 -- Start of Comments
225 --
226 -- Item level validation procedures
227 --
228 --
229 -- End of Comments
230
231 PROCEDURE Validate_RELATED_HEADER_ID (
232 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
233 P_Validation_mode IN VARCHAR2,
234 P_RELATED_HEADER_ID IN NUMBER,
235 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
236 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
237 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
238
239 );
240
241 -- Start of Comments
242 --
243 -- Item level validation procedures
244 -- End of Comments
245
246 PROCEDURE Validate_RLTSHIP_TYPE_CODE (
247 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
248 P_Validation_mode IN VARCHAR2,
249 P_RELATIONSHIP_TYPE_CODE IN VARCHAR2,
250 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
251 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
252 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
253 );
254
255 -- Start of Comments
256 --
257 -- Item level validation procedures
258 --
259 -- End of Comments
260
261 PROCEDURE Validate_RECIPROCAL_FLAG (
262 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
263 P_Validation_mode IN VARCHAR2,
264 P_RECIPROCAL_FLAG IN VARCHAR2,
265 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
266 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
267 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
268 );
269
270 -- Start of Comments
271 --
272 -- End of Comments
273
274 PROCEDURE Validate_HEADER_RLTSHIP_rec(
275 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
276 P_Validation_mode IN VARCHAR2,
277 P_HEADER_RLTSHIP_Rec IN ASO_QUOTE_PUB.HEADER_RLTSHIP_Rec_Type,
278 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
279 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
280 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
281
282 );
283
284 -- Start of Comments
285 --
286 -- End of Comments
287
288 PROCEDURE Validate_header_rltship(
289 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
290 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
291 P_Validation_mode IN VARCHAR2,
292 P_HEADER_RLTSHIP_Rec IN ASO_quote_PUB.HEADER_RLTSHIP_Rec_Type,
293 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
294 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
295 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
296
297 );
298 End ASO_HEADER_RLTSHIP_PVT;