33:
34:
35: TYPE recipe_step_out IS RECORD
36:
37: (recipe_id gmd_recipes.recipe_id%type ,
38: rowid varchar2(18) ,
39: routingstep_no fm_rout_dtl.routingstep_no%type ,
40: routingstep_id fm_rout_dtl.routingstep_id%type ,
41: step_qty fm_rout_dtl.step_qty%type ,
156: TYPE routing_step_tbl IS TABLE OF routing_step_out
157: INDEX BY BINARY_INTEGER;
158:
159: TYPE oprn_act_out IS RECORD
160: ( recipe_id gmd_recipes.recipe_id%type ,
161: routingstep_id fm_rout_dtl.routingstep_id%type ,
162: routingstep_no fm_rout_dtl.routingstep_no%type ,
163: oprn_no gmd_operations_vl.oprn_no%type ,
164: oprn_vers gmd_operations_vl.oprn_vers%type ,
225: /* BUG#2621411 RajaSekhar Added capacity_tolerance field */
226:
227: TYPE oprn_resc_rec IS RECORD
228: (
229: recipe_id gmd_recipes.recipe_id%type ,
230: routingstep_id fm_rout_dtl.routingstep_id%type ,
231: routingstep_no fm_rout_dtl.routingstep_no%type ,
232: oprn_id gmd_operations_vl.oprn_id%type ,
233: oprn_no gmd_operations_vl.oprn_no%type ,
303:
304:
305: TYPE recp_resc_proc_param_rec IS RECORD
306: (
307: recipe_id gmd_recipes.recipe_id%type ,
308: routingstep_id fm_rout_dtl.routingstep_id%type ,
309: routingstep_no fm_rout_dtl.routingstep_no%type ,
310: oprn_line_id gmd_operation_resources.oprn_line_id%type ,
311: resources gmd_operation_resources.resources%type ,