119: -- Parameters
120: --
121: -- IN
122: -- p_api_version_number IN NUMBER Required
123: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
124: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
125: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
126: -- p_ozf_offr_qual_rec_type_rec IN ozf_offr_qual_rec_type Required
127: --
120: --
121: -- IN
122: -- p_api_version_number IN NUMBER Required
123: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
124: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
125: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
126: -- p_ozf_offr_qual_rec_type_rec IN ozf_offr_qual_rec_type Required
127: --
128: -- OUT
121: -- IN
122: -- p_api_version_number IN NUMBER Required
123: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
124: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
125: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
126: -- p_ozf_offr_qual_rec_type_rec IN ozf_offr_qual_rec_type Required
127: --
128: -- OUT
129: -- x_return_status OUT VARCHAR2
141: -- ==============================================================================
142:
143: PROCEDURE Create_Offr_Qual(
144: p_api_version_number IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148:
149: x_return_status OUT NOCOPY VARCHAR2,
142:
143: PROCEDURE Create_Offr_Qual(
144: p_api_version_number IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148:
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
143: PROCEDURE Create_Offr_Qual(
144: p_api_version_number IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148:
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
166: -- Parameters
167: --
168: -- IN
169: -- p_api_version_number IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
171: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
172: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
173: -- p_ozf_offr_qual_rec_type_rec IN ozf_offr_qual_rec_type Required
174: --
167: --
168: -- IN
169: -- p_api_version_number IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
171: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
172: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
173: -- p_ozf_offr_qual_rec_type_rec IN ozf_offr_qual_rec_type Required
174: --
175: -- OUT
168: -- IN
169: -- p_api_version_number IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
171: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
172: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
173: -- p_ozf_offr_qual_rec_type_rec IN ozf_offr_qual_rec_type Required
174: --
175: -- OUT
176: -- x_return_status OUT VARCHAR2
188: -- ==============================================================================
189:
190: PROCEDURE Update_Offr_Qual(
191: p_api_version_number IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195:
196: x_return_status OUT NOCOPY VARCHAR2,
189:
190: PROCEDURE Update_Offr_Qual(
191: p_api_version_number IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195:
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
190: PROCEDURE Update_Offr_Qual(
191: p_api_version_number IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195:
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,
212: -- Parameters
213: --
214: -- IN
215: -- p_api_version_number IN NUMBER Required
216: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
217: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
218: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
219: -- p_qualifier_id IN NUMBER
220: -- p_object_version_number IN NUMBER Optional Default = NULL
213: --
214: -- IN
215: -- p_api_version_number IN NUMBER Required
216: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
217: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
218: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
219: -- p_qualifier_id IN NUMBER
220: -- p_object_version_number IN NUMBER Optional Default = NULL
221: --
214: -- IN
215: -- p_api_version_number IN NUMBER Required
216: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
217: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
218: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
219: -- p_qualifier_id IN NUMBER
220: -- p_object_version_number IN NUMBER Optional Default = NULL
221: --
222: -- OUT
235: -- ==============================================================================
236:
237: PROCEDURE Delete_Offr_Qual(
238: p_api_version_number IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240: p_commit IN VARCHAR2 := FND_API.G_FALSE,
241: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
242: x_return_status OUT NOCOPY VARCHAR2,
243: x_msg_count OUT NOCOPY NUMBER,
236:
237: PROCEDURE Delete_Offr_Qual(
238: p_api_version_number IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240: p_commit IN VARCHAR2 := FND_API.G_FALSE,
241: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
242: x_return_status OUT NOCOPY VARCHAR2,
243: x_msg_count OUT NOCOPY NUMBER,
244: x_msg_data OUT NOCOPY VARCHAR2,
237: PROCEDURE Delete_Offr_Qual(
238: p_api_version_number IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240: p_commit IN VARCHAR2 := FND_API.G_FALSE,
241: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
242: x_return_status OUT NOCOPY VARCHAR2,
243: x_msg_count OUT NOCOPY NUMBER,
244: x_msg_data OUT NOCOPY VARCHAR2,
245: p_qualifier_id IN NUMBER,
258: -- Parameters
259: --
260: -- IN
261: -- p_api_version_number IN NUMBER Required
262: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
263: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
264: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
265: -- p_ozf_offr_qual_rec_type_rec IN ozf_offr_qual_rec_type Required
266: --
259: --
260: -- IN
261: -- p_api_version_number IN NUMBER Required
262: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
263: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
264: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
265: -- p_ozf_offr_qual_rec_type_rec IN ozf_offr_qual_rec_type Required
266: --
267: -- OUT
260: -- IN
261: -- p_api_version_number IN NUMBER Required
262: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
263: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
264: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
265: -- p_ozf_offr_qual_rec_type_rec IN ozf_offr_qual_rec_type Required
266: --
267: -- OUT
268: -- x_return_status OUT VARCHAR2
280: -- ==============================================================================
281:
282: PROCEDURE Lock_Offr_Qual(
283: p_api_version_number IN NUMBER,
284: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
285:
286: x_return_status OUT NOCOPY VARCHAR2,
287: x_msg_count OUT NOCOPY NUMBER,
288: x_msg_data OUT NOCOPY VARCHAR2,
314:
315:
316: PROCEDURE Validate_Offr_Qual(
317: p_api_version_number IN NUMBER,
318: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
319: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
320: p_ozf_offr_qual_rec IN ozf_offr_qual_rec_type,
321: p_validation_mode IN VARCHAR2,
322: x_return_status OUT NOCOPY VARCHAR2,
315:
316: PROCEDURE Validate_Offr_Qual(
317: p_api_version_number IN NUMBER,
318: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
319: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
320: p_ozf_offr_qual_rec IN ozf_offr_qual_rec_type,
321: p_validation_mode IN VARCHAR2,
322: x_return_status OUT NOCOPY VARCHAR2,
323: x_msg_count OUT NOCOPY NUMBER,
373:
374:
375: PROCEDURE Validate_Ozf_Offr_Qual_Rec (
376: p_api_version_number IN NUMBER,
377: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
378: x_return_status OUT NOCOPY VARCHAR2,
379: x_msg_count OUT NOCOPY NUMBER,
380: x_msg_data OUT NOCOPY VARCHAR2,
381: p_ozf_offr_qual_rec IN ozf_offr_qual_rec_type