DBA Data[Home] [Help]

APPS.GME_INSERT_STEP_PVT dependencies on GMD_RECIPE_FETCH_PUB

Line 45: l_recipe_rout_step gmd_recipe_fetch_pub.recipe_step_tbl;

41: FROM gme_text_header
42: WHERE text_code = v_text_code);
43:
44: /* Bug#4917184 End */
45: l_recipe_rout_step gmd_recipe_fetch_pub.recipe_step_tbl;
46: -- gme_batch_steps
47: l_recipe_rout_act gmd_recipe_fetch_pub.oprn_act_tbl;
48: -- gme_batch_step_activities
49: l_recipe_rout_resc gmd_recipe_fetch_pub.oprn_resc_tbl;

Line 47: l_recipe_rout_act gmd_recipe_fetch_pub.oprn_act_tbl;

43:
44: /* Bug#4917184 End */
45: l_recipe_rout_step gmd_recipe_fetch_pub.recipe_step_tbl;
46: -- gme_batch_steps
47: l_recipe_rout_act gmd_recipe_fetch_pub.oprn_act_tbl;
48: -- gme_batch_step_activities
49: l_recipe_rout_resc gmd_recipe_fetch_pub.oprn_resc_tbl;
50: -- gme_batch_step_resources
51: /* Pawan kumar bug 2509572 added code for process parameters */

Line 49: l_recipe_rout_resc gmd_recipe_fetch_pub.oprn_resc_tbl;

45: l_recipe_rout_step gmd_recipe_fetch_pub.recipe_step_tbl;
46: -- gme_batch_steps
47: l_recipe_rout_act gmd_recipe_fetch_pub.oprn_act_tbl;
48: -- gme_batch_step_activities
49: l_recipe_rout_resc gmd_recipe_fetch_pub.oprn_resc_tbl;
50: -- gme_batch_step_resources
51: /* Pawan kumar bug 2509572 added code for process parameters */
52: l_resc_parameters gmd_recipe_fetch_pub.recp_resc_proc_param_tbl;
53: -- gme_process_parameters

Line 52: l_resc_parameters gmd_recipe_fetch_pub.recp_resc_proc_param_tbl;

48: -- gme_batch_step_activities
49: l_recipe_rout_resc gmd_recipe_fetch_pub.oprn_resc_tbl;
50: -- gme_batch_step_resources
51: /* Pawan kumar bug 2509572 added code for process parameters */
52: l_resc_parameters gmd_recipe_fetch_pub.recp_resc_proc_param_tbl;
53: -- gme_process_parameters
54: l_recipe_rout_matl gmd_recipe_fetch_pub.recipe_rout_matl_tbl;
55: -- gme_batch_step_items
56: l_routing_depd gmd_recipe_fetch_pub.routing_depd_tbl;

Line 54: l_recipe_rout_matl gmd_recipe_fetch_pub.recipe_rout_matl_tbl;

50: -- gme_batch_step_resources
51: /* Pawan kumar bug 2509572 added code for process parameters */
52: l_resc_parameters gmd_recipe_fetch_pub.recp_resc_proc_param_tbl;
53: -- gme_process_parameters
54: l_recipe_rout_matl gmd_recipe_fetch_pub.recipe_rout_matl_tbl;
55: -- gme_batch_step_items
56: l_routing_depd gmd_recipe_fetch_pub.routing_depd_tbl;
57: -- gme_batch_step_dependencies
58: l_message_count NUMBER;

Line 56: l_routing_depd gmd_recipe_fetch_pub.routing_depd_tbl;

52: l_resc_parameters gmd_recipe_fetch_pub.recp_resc_proc_param_tbl;
53: -- gme_process_parameters
54: l_recipe_rout_matl gmd_recipe_fetch_pub.recipe_rout_matl_tbl;
55: -- gme_batch_step_items
56: l_routing_depd gmd_recipe_fetch_pub.routing_depd_tbl;
57: -- gme_batch_step_dependencies
58: l_message_count NUMBER;
59: l_message_data VARCHAR2 (2048);
60: l_return_code NUMBER;

Line 441: p_recipe_rout_resc IN gmd_recipe_fetch_pub.oprn_resc_tbl

437: fnd_msg_pub.add_exc_msg ('GME_API_INSERT_STEP', 'INSERT_BATCH_STEP');
438: END insert_batch_step;
439:
440: PROCEDURE calc_max_capacity (
441: p_recipe_rout_resc IN gmd_recipe_fetch_pub.oprn_resc_tbl
442: -- resources that we want the max_capacity of
443: ,p_max_capacity OUT NOCOPY gme_batch_steps.max_step_capacity%TYPE
444: ,p_capacity_uom OUT NOCOPY gme_batch_steps.max_step_capacity_um%TYPE
445: ,x_resource OUT NOCOPY gme_batch_step_resources.resources%TYPE