11: -- this procedure returns 'Y' n the OUT parameter if the changes can
12: -- be applied to the current run of the BP. Otherwise it will return 'N' in the
13: -- OUT parameter
14: PROCEDURE validate_currentrun (
15: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
16: x_changeCurrentRun OUT NOCOPY VARCHAR2) ;
17:
18:
19:
28: -- this procedure initializes the solve objects from the
29: -- shared aw. These objects will be used by the validation routines that
30: -- will be called by FWK subsequent to this call
31: PROCEDURE initialize_solve_object(
32: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type);
33:
34:
35:
36: -- this procedure detaches all attached aw. It is called by fwk code to detach
44: -- it returns 1 output variable
45: -- x_comparision: this variable is a boolean and can contain either
46: -- 'Y' or 'N'
47: PROCEDURE val_solve_eq_model(
48: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
49: x_comparision OUT NOCOPY VARCHAR2);
50:
51:
52:
59: -- x_task_name: this variable will contain a list of all
60: -- line member of source type LOADED which does not
61: -- exist in a LOAD DATA task
62: PROCEDURE val_solve_eq_data_load(
63: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
64: x_isvalid OUT NOCOPY VARCHAR2,
65: x_dim_members OUT NOCOPY VARCHAR2);
66:
67: -- This procedure validates that all the line members in a Load Data
76: -- x_dim_members: list of line members which exist in a LOAD DATA task
77: -- but do not exist in the Solve definition with source
78: -- type LOADED
79: PROCEDURE val_solve_gt_than_load(
80: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
81: x_isvalid OUT NOCOPY VARCHAR2,
82: x_task_name OUT NOCOPY VARCHAR2,
83: x_dim_members OUT NOCOPY VARCHAR2);
84:
94: -- x_invalid_tasks_list: this variable will contain a list of all
95: -- generate template tasks that do not have
96: -- a line member of source type INPUT
97: PROCEDURE validate_generate_worksheet(
98: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
99: x_isvalid OUT NOCOPY VARCHAR2 ,
100: x_invalid_tasks_list OUT NOCOPY VARCHAR2);
101:
102:
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,
125: p_inputDims IN VARCHAR2,
126: x_isvalid OUT NOCOPY VARCHAR2,
127: x_invalid_dim_list OUT NOCOPY VARCHAR2,
128: x_invalid_linemem_list OUT NOCOPY VARCHAR2);
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,
149: p_outputDims IN VARCHAR2,
150: x_isvalid OUT NOCOPY VARCHAR2,
151: x_invalid_linemem_list OUT NOCOPY VARCHAR2);
152:
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,
173: x_isvalid OUT NOCOPY VARCHAR2,
174: x_invalid_tasks_list OUT NOCOPY VARCHAR2);
175:
176: -- this procedure returns two possible output values
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,
190: x_isvalid OUT NOCOPY VARCHAR2,
191: x_dim_members OUT NOCOPY VARCHAR2);
192:
193:
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,
213: x_isvalid OUT NOCOPY VARCHAR2,
214: x_invalid_linemem_list OUT NOCOPY VARCHAR2);
215:
216: -- this procedure validates the solve output levels
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,
237: p_outputDims IN VARCHAR2,
238: x_isvalid OUT NOCOPY VARCHAR2,
239: x_invalid_dim_list OUT NOCOPY VARCHAR2,
240: x_invalid_linemem_list OUT NOCOPY VARCHAR2);
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,
256: p_hrz_level IN VARCHAR2,
257: x_isvalid OUT NOCOPY VARCHAR2);
258:
259: -- To delete view for an active instance
259: -- To delete view for an active instance
260: -- and clean up its worksheets
261:
262: PROCEDURE delete_view(
263: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type);
264:
265: PROCEDURE has_validation_errors(
266: itemtype IN varchar2,
267: itemkey IN varchar2,