92: -- Parameters
93: --
94: -- IN
95: -- p_api_version_number IN NUMBER Required
96: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
97: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
98: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
99: -- p_cal_crt_rec_rec IN cal_crt_rec_rec_type Required
100: --
93: --
94: -- IN
95: -- p_api_version_number IN NUMBER Required
96: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
97: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
98: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
99: -- p_cal_crt_rec_rec IN cal_crt_rec_rec_type Required
100: --
101: -- OUT
94: -- IN
95: -- p_api_version_number IN NUMBER Required
96: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
97: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
98: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
99: -- p_cal_crt_rec_rec IN cal_crt_rec_rec_type Required
100: --
101: -- OUT
102: -- x_return_status OUT VARCHAR2
114: -- ==============================================================================
115:
116: PROCEDURE Create_Cal_Crt(
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:
122: x_return_status OUT NOCOPY VARCHAR2,
115:
116: PROCEDURE Create_Cal_Crt(
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:
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
116: PROCEDURE Create_Cal_Crt(
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:
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
139: -- Parameters
140: --
141: -- IN
142: -- p_api_version_number IN NUMBER Required
143: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
146: -- p_cal_crt_rec_rec IN cal_crt_rec_rec_type Required
147: --
140: --
141: -- IN
142: -- p_api_version_number IN NUMBER Required
143: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
146: -- p_cal_crt_rec_rec IN cal_crt_rec_rec_type Required
147: --
148: -- OUT
141: -- IN
142: -- p_api_version_number IN NUMBER Required
143: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
146: -- p_cal_crt_rec_rec IN cal_crt_rec_rec_type Required
147: --
148: -- OUT
149: -- x_return_status OUT VARCHAR2
161: -- ==============================================================================
162:
163: PROCEDURE Update_Cal_Crt(
164: p_api_version_number IN NUMBER,
165: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
166: p_commit IN VARCHAR2 := FND_API.G_FALSE,
167: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
168:
169: x_return_status OUT NOCOPY VARCHAR2,
162:
163: PROCEDURE Update_Cal_Crt(
164: p_api_version_number IN NUMBER,
165: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
166: p_commit IN VARCHAR2 := FND_API.G_FALSE,
167: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
168:
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
163: PROCEDURE Update_Cal_Crt(
164: p_api_version_number IN NUMBER,
165: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
166: p_commit IN VARCHAR2 := FND_API.G_FALSE,
167: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
168:
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
185: -- Parameters
186: --
187: -- IN
188: -- p_api_version_number IN NUMBER Required
189: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
190: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
191: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
192: -- p_criteria_id IN NUMBER
193: -- p_object_version_number IN NUMBER Optional Default = NULL
186: --
187: -- IN
188: -- p_api_version_number IN NUMBER Required
189: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
190: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
191: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
192: -- p_criteria_id IN NUMBER
193: -- p_object_version_number IN NUMBER Optional Default = NULL
194: --
187: -- IN
188: -- p_api_version_number IN NUMBER Required
189: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
190: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
191: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
192: -- p_criteria_id IN NUMBER
193: -- p_object_version_number IN NUMBER Optional Default = NULL
194: --
195: -- OUT
208: -- ==============================================================================
209:
210: PROCEDURE Delete_Cal_Crt(
211: p_api_version_number IN NUMBER,
212: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213: p_commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
209:
210: PROCEDURE Delete_Cal_Crt(
211: p_api_version_number IN NUMBER,
212: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213: p_commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
210: PROCEDURE Delete_Cal_Crt(
211: p_api_version_number IN NUMBER,
212: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213: p_commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_criteria_id IN NUMBER,
231: -- Parameters
232: --
233: -- IN
234: -- p_api_version_number IN NUMBER Required
235: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
236: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
237: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
238: -- p_cal_crt_rec_rec IN cal_crt_rec_rec_type Required
239: --
232: --
233: -- IN
234: -- p_api_version_number IN NUMBER Required
235: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
236: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
237: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
238: -- p_cal_crt_rec_rec IN cal_crt_rec_rec_type Required
239: --
240: -- OUT
233: -- IN
234: -- p_api_version_number IN NUMBER Required
235: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
236: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
237: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
238: -- p_cal_crt_rec_rec IN cal_crt_rec_rec_type Required
239: --
240: -- OUT
241: -- x_return_status OUT VARCHAR2
253: -- ==============================================================================
254:
255: PROCEDURE Lock_Cal_Crt(
256: p_api_version_number IN NUMBER,
257: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
258:
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_count OUT NOCOPY NUMBER,
261: x_msg_data OUT NOCOPY VARCHAR2,
287:
288:
289: PROCEDURE Validate_Cal_Crt(
290: p_api_version_number IN NUMBER,
291: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
293: p_cal_crt_rec_rec IN cal_crt_rec_rec_type,
294: p_validation_mode IN VARCHAR2,
295: x_return_status OUT NOCOPY VARCHAR2,
288:
289: PROCEDURE Validate_Cal_Crt(
290: p_api_version_number IN NUMBER,
291: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
293: p_cal_crt_rec_rec IN cal_crt_rec_rec_type,
294: p_validation_mode IN VARCHAR2,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
346:
347:
348: PROCEDURE Validate_Cal_Crt_Rec_Rec (
349: p_api_version_number IN NUMBER,
350: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
351: x_return_status OUT NOCOPY VARCHAR2,
352: x_msg_count OUT NOCOPY NUMBER,
353: x_msg_data OUT NOCOPY VARCHAR2,
354: p_cal_crt_rec_rec IN cal_crt_rec_rec_type