eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_CREATE_STEP_PVT dependencies on GMD_AUTO_STEP_CALC

Line 50: l_step_tbl gmd_auto_step_calc.step_rec_tbl;

46:
47: i PLS_INTEGER;
48: j PLS_INTEGER;
49: l_batch_id gme_batch_header.batch_id%TYPE;
50: l_step_tbl gmd_auto_step_calc.step_rec_tbl;
51: l_batchstep_id gme_batch_steps.batchstep_id%TYPE;
52: l_last_batchstep_id gme_batch_steps.batchstep_id%TYPE;
53: l_qty gme_batch_steps.plan_step_qty%TYPE;
54: l_mass_qty gme_batch_steps.plan_mass_qty%TYPE;

Line 902: gmd_auto_step_calc.calc_step_qty

898: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
899: gme_debug.put_line ('auto step calc...');
900: END IF;
901:
902: gmd_auto_step_calc.calc_step_qty
903: (p_parent_id => l_batch_id
904: ,p_step_tbl => l_step_tbl
905: ,p_msg_count => l_msg_count
906: ,p_msg_stack => l_msg_stack

Line 961: --IF l_uom_class = NVL(gmd_auto_step_calc.g_profile_mass_um_type,gme_common_pvt.g_mass_um_type) THEN

957: l_mass_qty := NULL;
958: l_volume_qty := NULL;
959:
960: --Bug#5231180 used gme_common_pvt variables rather GMD spec variables
961: --IF l_uom_class = NVL(gmd_auto_step_calc.g_profile_mass_um_type,gme_common_pvt.g_mass_um_type) THEN
962: IF l_uom_class = gme_common_pvt.g_mass_um_type THEN
963: --multiply the step qty with standard factor to get mass qty
964: l_mass_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
965: --ELSIF l_uom_class = NVL(gmd_auto_step_calc.g_profile_volume_um_type,gme_common_pvt.g_volume_um_type) THEN

Line 965: --ELSIF l_uom_class = NVL(gmd_auto_step_calc.g_profile_volume_um_type,gme_common_pvt.g_volume_um_type) THEN

961: --IF l_uom_class = NVL(gmd_auto_step_calc.g_profile_mass_um_type,gme_common_pvt.g_mass_um_type) THEN
962: IF l_uom_class = gme_common_pvt.g_mass_um_type THEN
963: --multiply the step qty with standard factor to get mass qty
964: l_mass_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
965: --ELSIF l_uom_class = NVL(gmd_auto_step_calc.g_profile_volume_um_type,gme_common_pvt.g_volume_um_type) THEN
966: ELSIF l_uom_class = gme_common_pvt.g_volume_um_type THEN
967: --multiply the step qty with standard factor to get vol qty
968: l_volume_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
969: END IF;

Line 1956: x_gmd_step_tbl gmd_auto_step_calc.step_rec_tbl;

1952: x_max_act_date DATE;
1953: x_max_rsrc_date DATE;
1954: l_return_status VARCHAR2 (1);
1955: x_routing_id gme_batch_header.routing_id%TYPE;
1956: x_gmd_step_tbl gmd_auto_step_calc.step_rec_tbl;
1957: l_batch_id gme_batch_header.batch_id%TYPE;
1958: x_batch_duration NUMBER;
1959: x_batch_start_date DATE;
1960: x_step_start_date DATE;

Line 2066: gmd_auto_step_calc.load_steps (l_batch_id

2062:
2063: /* If P_step_id is NULL, this means we want to process all steps in the batch. If */
2064: /* it is not NULL, then we only want to calc the dates for that step, i.e. insert_step... */
2065: IF (p_step_id IS NULL) THEN
2066: gmd_auto_step_calc.load_steps (l_batch_id
2067: ,1
2068: ,NULL
2069: ,x_gmd_step_tbl
2070: ,x_routing_id

Line 2825: -- This procedure is a modification of GMD_AUTO_STEP_CALC.calc_step_qty.

2821: --
2822: -- DESCRIPTION:
2823: -- This PL/SQL procedure is responsible for scaling step
2824: -- quantities.
2825: -- This procedure is a modification of GMD_AUTO_STEP_CALC.calc_step_qty.
2826: -- The GMD_AUTO_STEP_CALC package will be used whereever possible for
2827: -- underlying routines so as not to duplicate code unnecessarily.
2828: -- This procedure will keep as close to the original as possible.
2829: -- This will always be called from a batch, but the parm to specify this

Line 2826: -- The GMD_AUTO_STEP_CALC package will be used whereever possible for

2822: -- DESCRIPTION:
2823: -- This PL/SQL procedure is responsible for scaling step
2824: -- quantities.
2825: -- This procedure is a modification of GMD_AUTO_STEP_CALC.calc_step_qty.
2826: -- The GMD_AUTO_STEP_CALC package will be used whereever possible for
2827: -- underlying routines so as not to duplicate code unnecessarily.
2828: -- This procedure will keep as close to the original as possible.
2829: -- This will always be called from a batch, but the parm to specify this
2830: -- will be kept just in case...

Line 2842: ,p_step_tbl OUT NOCOPY gmd_auto_step_calc.step_rec_tbl

2838: --
2839: --===================================================================== */
2840: PROCEDURE calc_step_qty (
2841: p_parent_id IN NUMBER
2842: ,p_step_tbl OUT NOCOPY gmd_auto_step_calc.step_rec_tbl
2843: ,p_return_status OUT NOCOPY VARCHAR2
2844: ,p_called_from_batch IN NUMBER DEFAULT 1)
2845: IS
2846: x_step_rows NUMBER;

Line 2879: gmd_auto_step_calc.load_steps (p_parent_id

2875: END IF;
2876:
2877: p_return_status := fnd_api.g_ret_sts_success;
2878: /* Load the steps based into the PL/SQL table P_step_tbl based on the dependencies */
2879: gmd_auto_step_calc.load_steps (p_parent_id
2880: ,p_called_from_batch
2881: ,NULL
2882: ,p_step_tbl
2883: ,x_routing_id

Line 2894: INTO gmd_auto_step_calc.g_mass_std_um;

2890: IF (gme_common_pvt.g_mass_um_type IS NOT NULL) THEN
2891: OPEN cur_get_std_um (gme_common_pvt.g_mass_um_type);
2892:
2893: FETCH cur_get_std_um
2894: INTO gmd_auto_step_calc.g_mass_std_um;
2895:
2896: CLOSE cur_get_std_um;
2897: END IF;
2898:

Line 2903: INTO gmd_auto_step_calc.g_vol_std_um;

2899: IF (gme_common_pvt.g_volume_um_type IS NOT NULL) THEN
2900: OPEN cur_get_std_um (gme_common_pvt.g_volume_um_type);
2901:
2902: FETCH cur_get_std_um
2903: INTO gmd_auto_step_calc.g_vol_std_um;
2904:
2905: CLOSE cur_get_std_um;
2906: END IF;
2907:

Line 2932: p_step_tbl (i).step_mass_uom := gmd_auto_step_calc.g_mass_std_um;

2928: CLOSE cur_get_std_factor;
2929:
2930: IF x_uom_class = gme_common_pvt.g_mass_um_type THEN
2931: p_step_tbl (i).step_mass_qty := x_step_qty * x_new_factor;
2932: p_step_tbl (i).step_mass_uom := gmd_auto_step_calc.g_mass_std_um;
2933: ELSIF x_uom_class = gme_common_pvt.g_volume_um_type THEN
2934: p_step_tbl (i).step_vol_qty := x_step_qty * x_new_factor;
2935: p_step_tbl (i).step_vol_uom := gmd_auto_step_calc.g_vol_std_um;
2936: END IF;

Line 2935: p_step_tbl (i).step_vol_uom := gmd_auto_step_calc.g_vol_std_um;

2931: p_step_tbl (i).step_mass_qty := x_step_qty * x_new_factor;
2932: p_step_tbl (i).step_mass_uom := gmd_auto_step_calc.g_mass_std_um;
2933: ELSIF x_uom_class = gme_common_pvt.g_volume_um_type THEN
2934: p_step_tbl (i).step_vol_qty := x_step_qty * x_new_factor;
2935: p_step_tbl (i).step_vol_uom := gmd_auto_step_calc.g_vol_std_um;
2936: END IF;
2937: END LOOP; /*FOR i IN 1..X_step_rows*/
2938:
2939: IF g_debug <= gme_debug.g_log_procedure THEN