APPS.GME_INSERT_STEP_PVT dependencies on GME_BATCH_STEPS

Line 8: ,p_gme_batch_step IN gme_batch_steps%ROWTYPE

4: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_API_INSERT_STEP';
5:
6: PROCEDURE insert_batch_step (
7: p_gme_batch_header IN gme_batch_header%ROWTYPE
8: ,p_gme_batch_step IN gme_batch_steps%ROWTYPE
9: ,x_gme_batch_step OUT NOCOPY gme_batch_steps%ROWTYPE
10: ,x_return_status OUT NOCOPY VARCHAR2)
11: IS
12: CURSOR get_steps_count (v_batchstep_no NUMBER, v_batch_id NUMBER)

Line 9: ,x_gme_batch_step OUT NOCOPY gme_batch_steps%ROWTYPE

5:
6: PROCEDURE insert_batch_step (
7: p_gme_batch_header IN gme_batch_header%ROWTYPE
8: ,p_gme_batch_step IN gme_batch_steps%ROWTYPE
9: ,x_gme_batch_step OUT NOCOPY gme_batch_steps%ROWTYPE
10: ,x_return_status OUT NOCOPY VARCHAR2)
11: IS
12: CURSOR get_steps_count (v_batchstep_no NUMBER, v_batch_id NUMBER)
13: IS

Line 15: FROM gme_batch_steps

11: IS
12: CURSOR get_steps_count (v_batchstep_no NUMBER, v_batch_id NUMBER)
13: IS
14: SELECT COUNT (*)
15: FROM gme_batch_steps
16: WHERE batch_id = v_batch_id
17: AND batchstep_no = v_batchstep_no
18: AND delete_mark = 0;
19:

Line 46: -- gme_batch_steps

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;
50: -- gme_batch_step_resources

Line 64: l_batch_step_row gme_batch_steps%ROWTYPE;

60: l_return_code NUMBER;
61: l_return_status VARCHAR2 (1);
62: l_count NUMBER;
63: l_batch_id NUMBER;
64: l_batch_step_row gme_batch_steps%ROWTYPE;
65: l_exists NUMBER; --nsinghi bug#5202811
66: --Bug#5231180
67: l_um_type mtl_units_of_measure.uom_class%TYPE;
68: l_std_factor NUMBER;

Line 289: IF NOT (gme_batch_steps_dbl.fetch_row (x_gme_batch_step

285:
286: x_gme_batch_step.batchstep_no := p_gme_batch_step.batchstep_no;
287: x_gme_batch_step.batch_id := l_batch_id;
288:
289: IF NOT (gme_batch_steps_dbl.fetch_row (x_gme_batch_step
290: ,x_gme_batch_step) ) THEN
291: RAISE batch_step_fetch_error;
292: END IF;
293:

Line 365: IF NOT (gme_batch_steps_dbl.update_row (p_batch_step => x_gme_batch_step) ) THEN

361: CLOSE cur_text_code;
362: END IF;
363: x_gme_batch_step.text_code := p_gme_batch_step.text_code;
364:
365: IF NOT (gme_batch_steps_dbl.update_row (p_batch_step => x_gme_batch_step) ) THEN
366: RAISE batch_step_update_error;
367: END IF;
368:
369: /* Bug 2397077 Added message to indicate success of program. */

Line 443: ,p_max_capacity OUT NOCOPY gme_batch_steps.max_step_capacity%TYPE

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
446: ,x_return_status OUT NOCOPY VARCHAR2
447: ,p_step_qty_uom IN VARCHAR2 DEFAULT NULL) --Bug#5231180

Line 444: ,p_capacity_uom OUT NOCOPY gme_batch_steps.max_step_capacity_um%TYPE

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
446: ,x_return_status OUT NOCOPY VARCHAR2
447: ,p_step_qty_uom IN VARCHAR2 DEFAULT NULL) --Bug#5231180
448: IS