114: -- of invalid line member ids if the x_isvalid
115: -- is equal to 'N' i.e validation failed
116: PROCEDURE validate_input_selections(
117: p_api_version 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: x_return_status OUT NOCOPY VARCHAR2 ,
122: x_msg_count OUT NOCOPY NUMBER,
115: -- is equal to 'N' i.e validation failed
116: PROCEDURE validate_input_selections(
117: p_api_version 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: x_return_status OUT NOCOPY VARCHAR2 ,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2,
116: PROCEDURE validate_input_selections(
117: p_api_version 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: x_return_status OUT NOCOPY VARCHAR2 ,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2,
124: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
138: -- of invalid line member ids if the x_isvalid
139: -- is equal to 'N' i.e validation failed
140: PROCEDURE validate_solve_levels(
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145: x_return_status OUT NOCOPY VARCHAR2 ,
146: x_msg_count OUT NOCOPY NUMBER,
139: -- is equal to 'N' i.e validation failed
140: PROCEDURE validate_solve_levels(
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145: x_return_status OUT NOCOPY VARCHAR2 ,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
140: PROCEDURE validate_solve_levels(
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145: x_return_status OUT NOCOPY VARCHAR2 ,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
162: -- of generate tasks which are invalid i.e.
163: -- contain lines that are not in the model
164: PROCEDURE val_template_le_model(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169: x_return_status OUT NOCOPY VARCHAR2 ,
170: x_msg_count OUT NOCOPY NUMBER,
163: -- contain lines that are not in the model
164: PROCEDURE val_template_le_model(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169: x_return_status OUT NOCOPY VARCHAR2 ,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
164: PROCEDURE val_template_le_model(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169: x_return_status OUT NOCOPY VARCHAR2 ,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
179: -- 'N': The union of Line Members of ALL Generate Template Tasks is different from the
180: -- NON_INITIALIZED inputted line members of Solve
181: procedure val_solveinp_eq_gentemp(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
186: x_return_status OUT NOCOPY VARCHAR2 ,
187: x_msg_count OUT NOCOPY NUMBER,
180: -- NON_INITIALIZED inputted line members of Solve
181: procedure val_solveinp_eq_gentemp(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
186: x_return_status OUT NOCOPY VARCHAR2 ,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
181: procedure val_solveinp_eq_gentemp(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
186: x_return_status OUT NOCOPY VARCHAR2 ,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
202: -- of invalid line member ids if the x_isvalid
203: -- is equal to 'N' i.e validation failed
204: PROCEDURE val_solve_input_higher_levels(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
207: p_commit IN VARCHAR2 := FND_API.G_FALSE,
208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209: x_return_status OUT NOCOPY VARCHAR2 ,
210: x_msg_count OUT NOCOPY NUMBER,
203: -- is equal to 'N' i.e validation failed
204: PROCEDURE val_solve_input_higher_levels(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
207: p_commit IN VARCHAR2 := FND_API.G_FALSE,
208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209: x_return_status OUT NOCOPY VARCHAR2 ,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
204: PROCEDURE val_solve_input_higher_levels(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
207: p_commit IN VARCHAR2 := FND_API.G_FALSE,
208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209: x_return_status OUT NOCOPY VARCHAR2 ,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
212: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
226: -- of invalid line member ids if the x_isvalid
227: -- is equal to 'N' i.e validation failed
228: PROCEDURE validate_output_selections(
229: p_api_version IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231: p_commit IN VARCHAR2 := FND_API.G_FALSE,
232: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
233: x_return_status OUT NOCOPY VARCHAR2 ,
234: x_msg_count OUT NOCOPY NUMBER,
227: -- is equal to 'N' i.e validation failed
228: PROCEDURE validate_output_selections(
229: p_api_version IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231: p_commit IN VARCHAR2 := FND_API.G_FALSE,
232: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
233: x_return_status OUT NOCOPY VARCHAR2 ,
234: x_msg_count OUT NOCOPY NUMBER,
235: x_msg_data OUT NOCOPY VARCHAR2,
228: PROCEDURE validate_output_selections(
229: p_api_version IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231: p_commit IN VARCHAR2 := FND_API.G_FALSE,
232: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
233: x_return_status OUT NOCOPY VARCHAR2 ,
234: x_msg_count OUT NOCOPY NUMBER,
235: x_msg_data OUT NOCOPY VARCHAR2,
236: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
245: -- x_isvalid: this variable is a boolean and can contain either
246: -- 'Y' or 'N'
247: PROCEDURE val_solve_hrzselections(
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: x_return_status OUT NOCOPY VARCHAR2 ,
253: x_msg_count OUT NOCOPY NUMBER,
246: -- 'Y' or 'N'
247: PROCEDURE val_solve_hrzselections(
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: x_return_status OUT NOCOPY VARCHAR2 ,
253: x_msg_count OUT NOCOPY NUMBER,
254: x_msg_data OUT NOCOPY VARCHAR2,
247: PROCEDURE val_solve_hrzselections(
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: x_return_status OUT NOCOPY VARCHAR2 ,
253: x_msg_count OUT NOCOPY NUMBER,
254: x_msg_data OUT NOCOPY VARCHAR2,
255: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,