82: -- Parameters
83: --
84: -- IN
85: -- p_api_version_number IN NUMBER Required
86: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
87: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
88: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
89: -- p_prgm_benefits_rec IN prgm_benefits_rec_type Required
90: --
83: --
84: -- IN
85: -- p_api_version_number IN NUMBER Required
86: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
87: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
88: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
89: -- p_prgm_benefits_rec IN prgm_benefits_rec_type Required
90: --
91: -- OUT
84: -- IN
85: -- p_api_version_number IN NUMBER Required
86: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
87: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
88: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
89: -- p_prgm_benefits_rec IN prgm_benefits_rec_type Required
90: --
91: -- OUT
92: -- x_return_status OUT VARCHAR2
99: -- End of Comments
100: -- ==============================================================================
101: PROCEDURE Create_Prgm_Benefits(
102: p_api_version_number IN NUMBER
103: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
104: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
105: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
106:
107: ,x_return_status OUT NOCOPY VARCHAR2
100: -- ==============================================================================
101: PROCEDURE Create_Prgm_Benefits(
102: p_api_version_number IN NUMBER
103: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
104: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
105: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
106:
107: ,x_return_status OUT NOCOPY VARCHAR2
108: ,x_msg_count OUT NOCOPY NUMBER
101: PROCEDURE Create_Prgm_Benefits(
102: p_api_version_number IN NUMBER
103: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
104: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
105: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
106:
107: ,x_return_status OUT NOCOPY VARCHAR2
108: ,x_msg_count OUT NOCOPY NUMBER
109: ,x_msg_data OUT NOCOPY VARCHAR2
127: -- Parameters
128: --
129: -- IN
130: -- p_api_version_number IN NUMBER Required
131: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
132: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
134: -- p_prgm_benefits_rec IN prgm_benefits_rec_type Required
135: --
128: --
129: -- IN
130: -- p_api_version_number IN NUMBER Required
131: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
132: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
134: -- p_prgm_benefits_rec IN prgm_benefits_rec_type Required
135: --
136: -- OUT
129: -- IN
130: -- p_api_version_number IN NUMBER Required
131: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
132: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
134: -- p_prgm_benefits_rec IN prgm_benefits_rec_type Required
135: --
136: -- OUT
137: -- x_return_status OUT VARCHAR2
144: -- End of Comments
145: -- ==============================================================================
146: PROCEDURE Update_Prgm_Benefits(
147: p_api_version_number IN NUMBER
148: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
149: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
150: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
151:
152: ,x_return_status OUT NOCOPY VARCHAR2
145: -- ==============================================================================
146: PROCEDURE Update_Prgm_Benefits(
147: p_api_version_number IN NUMBER
148: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
149: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
150: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
151:
152: ,x_return_status OUT NOCOPY VARCHAR2
153: ,x_msg_count OUT NOCOPY NUMBER
146: PROCEDURE Update_Prgm_Benefits(
147: p_api_version_number IN NUMBER
148: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
149: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
150: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
151:
152: ,x_return_status OUT NOCOPY VARCHAR2
153: ,x_msg_count OUT NOCOPY NUMBER
154: ,x_msg_data OUT NOCOPY VARCHAR2
171: -- Parameters
172: --
173: -- IN
174: -- p_api_version_number IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
176: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
177: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
178: -- p_program_benefits_id IN NUMBER
179: -- p_object_version_number IN NUMBER Optional Default = NULL
172: --
173: -- IN
174: -- p_api_version_number IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
176: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
177: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
178: -- p_program_benefits_id IN NUMBER
179: -- p_object_version_number IN NUMBER Optional Default = NULL
180: --
173: -- IN
174: -- p_api_version_number IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
176: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
177: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
178: -- p_program_benefits_id IN NUMBER
179: -- p_object_version_number IN NUMBER Optional Default = NULL
180: --
181: -- OUT
189: -- End of Comments
190: -- =============================================================================
191: PROCEDURE Delete_Prgm_Benefits(
192: p_api_version_number IN NUMBER
193: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
194: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
195: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
196:
197: ,x_return_status OUT NOCOPY VARCHAR2
190: -- =============================================================================
191: PROCEDURE Delete_Prgm_Benefits(
192: p_api_version_number IN NUMBER
193: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
194: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
195: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
196:
197: ,x_return_status OUT NOCOPY VARCHAR2
198: ,x_msg_count OUT NOCOPY NUMBER
191: PROCEDURE Delete_Prgm_Benefits(
192: p_api_version_number IN NUMBER
193: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
194: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
195: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
196:
197: ,x_return_status OUT NOCOPY VARCHAR2
198: ,x_msg_count OUT NOCOPY NUMBER
199: ,x_msg_data OUT NOCOPY VARCHAR2
216: -- Parameters
217: --
218: -- IN
219: -- p_api_version_number IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
222: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
223: -- p_prgm_benefits_rec IN prgm_benefits_rec_type Required
224: --
217: --
218: -- IN
219: -- p_api_version_number IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
222: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
223: -- p_prgm_benefits_rec IN prgm_benefits_rec_type Required
224: --
225: -- OUT
218: -- IN
219: -- p_api_version_number IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
222: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
223: -- p_prgm_benefits_rec IN prgm_benefits_rec_type Required
224: --
225: -- OUT
226: -- x_return_status OUT VARCHAR2
233: -- End of Comments
234: -- ==============================================================================
235: PROCEDURE Lock_Prgm_Benefits(
236: p_api_version_number IN NUMBER
237: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
238:
239: ,x_return_status OUT NOCOPY VARCHAR2
240: ,x_msg_count OUT NOCOPY NUMBER
241: ,x_msg_data OUT NOCOPY VARCHAR2
261: -- End of Comments
262: -- =======================================
263: PROCEDURE Validate_Prgm_Benefits(
264: p_api_version_number IN NUMBER
265: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
266: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
267: ,p_prgm_benefits_rec IN prgm_benefits_rec_type
268: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
269:
262: -- =======================================
263: PROCEDURE Validate_Prgm_Benefits(
264: p_api_version_number IN NUMBER
265: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
266: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
267: ,p_prgm_benefits_rec IN prgm_benefits_rec_type
268: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
269:
270: ,x_return_status OUT NOCOPY VARCHAR2
315: -- End of Comments
316: -- ==============================================================================
317: PROCEDURE Validate_Rec(
318: p_api_version_number IN NUMBER
319: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
320:
321: ,x_return_status OUT NOCOPY VARCHAR2
322: ,x_msg_count OUT NOCOPY NUMBER
323: ,x_msg_data OUT NOCOPY VARCHAR2