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 975: gme_debug.put_line ('CALLING gmd_auto_step_calc.calc_step_qty. Org is '||p_gme_batch_header_rec.organization_id);

971: ELSE
972: IF (p_gme_batch_header_rec.automatic_step_calculation = 1) THEN
973: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
974: gme_debug.put_line ('auto step calc for batch id '||l_batch_id);
975: gme_debug.put_line ('CALLING gmd_auto_step_calc.calc_step_qty. Org is '||p_gme_batch_header_rec.organization_id);
976: END IF;
977:
978: gmd_auto_step_calc.calc_step_qty
979: (p_parent_id => l_batch_id

Line 978: gmd_auto_step_calc.calc_step_qty

974: gme_debug.put_line ('auto step calc for batch id '||l_batch_id);
975: gme_debug.put_line ('CALLING gmd_auto_step_calc.calc_step_qty. Org is '||p_gme_batch_header_rec.organization_id);
976: END IF;
977:
978: gmd_auto_step_calc.calc_step_qty
979: (p_parent_id => l_batch_id
980: ,p_step_tbl => l_step_tbl
981: ,p_msg_count => l_msg_count
982: ,p_msg_stack => l_msg_stack

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

1042: l_mass_qty := NULL;
1043: l_volume_qty := NULL;
1044:
1045: --Bug#5231180 used gme_common_pvt variables rather GMD spec variables
1046: --IF l_uom_class = NVL(gmd_auto_step_calc.g_profile_mass_um_type,gme_common_pvt.g_mass_um_type) THEN
1047: IF l_uom_class = gme_common_pvt.g_mass_um_type THEN
1048: --multiply the step qty with standard factor to get mass qty
1049: l_mass_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
1050: --ELSIF l_uom_class = NVL(gmd_auto_step_calc.g_profile_volume_um_type,gme_common_pvt.g_volume_um_type) THEN

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

1046: --IF l_uom_class = NVL(gmd_auto_step_calc.g_profile_mass_um_type,gme_common_pvt.g_mass_um_type) THEN
1047: IF l_uom_class = gme_common_pvt.g_mass_um_type THEN
1048: --multiply the step qty with standard factor to get mass qty
1049: l_mass_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
1050: --ELSIF l_uom_class = NVL(gmd_auto_step_calc.g_profile_volume_um_type,gme_common_pvt.g_volume_um_type) THEN
1051: ELSIF l_uom_class = gme_common_pvt.g_volume_um_type THEN
1052: --multiply the step qty with standard factor to get vol qty
1053: l_volume_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
1054: END IF;

Line 2081: x_gmd_step_tbl gmd_auto_step_calc.step_rec_tbl;

2077: x_max_act_date DATE;
2078: x_max_rsrc_date DATE;
2079: l_return_status VARCHAR2 (1);
2080: x_routing_id gme_batch_header.routing_id%TYPE;
2081: x_gmd_step_tbl gmd_auto_step_calc.step_rec_tbl;
2082: l_batch_id gme_batch_header.batch_id%TYPE;
2083: x_batch_duration NUMBER;
2084: x_batch_start_date DATE;
2085: x_step_start_date DATE;

Line 2198: gmd_auto_step_calc.load_steps (l_batch_id

2194:
2195: /* If P_step_id is NULL, this means we want to process all steps in the batch. If */
2196: /* it is not NULL, then we only want to calc the dates for that step, i.e. insert_step... */
2197: IF (p_step_id IS NULL) THEN
2198: gmd_auto_step_calc.load_steps (l_batch_id
2199: ,1
2200: ,NULL
2201: ,x_gmd_step_tbl
2202: ,x_routing_id

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

3322: --
3323: -- DESCRIPTION:
3324: -- This PL/SQL procedure is responsible for scaling step
3325: -- quantities.
3326: -- This procedure is a modification of GMD_AUTO_STEP_CALC.calc_step_qty.
3327: -- The GMD_AUTO_STEP_CALC package will be used whereever possible for
3328: -- underlying routines so as not to duplicate code unnecessarily.
3329: -- This procedure will keep as close to the original as possible.
3330: -- This will always be called from a batch, but the parm to specify this

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

3323: -- DESCRIPTION:
3324: -- This PL/SQL procedure is responsible for scaling step
3325: -- quantities.
3326: -- This procedure is a modification of GMD_AUTO_STEP_CALC.calc_step_qty.
3327: -- The GMD_AUTO_STEP_CALC package will be used whereever possible for
3328: -- underlying routines so as not to duplicate code unnecessarily.
3329: -- This procedure will keep as close to the original as possible.
3330: -- This will always be called from a batch, but the parm to specify this
3331: -- will be kept just in case...

Line 3343: ,p_step_tbl OUT NOCOPY gmd_auto_step_calc.step_rec_tbl

3339: --
3340: --===================================================================== */
3341: PROCEDURE calc_step_qty (
3342: p_parent_id IN NUMBER
3343: ,p_step_tbl OUT NOCOPY gmd_auto_step_calc.step_rec_tbl
3344: ,p_return_status OUT NOCOPY VARCHAR2
3345: ,p_called_from_batch IN NUMBER DEFAULT 1)
3346: IS
3347: x_step_rows NUMBER;

Line 3380: gmd_auto_step_calc.load_steps (p_parent_id

3376: END IF;
3377:
3378: p_return_status := fnd_api.g_ret_sts_success;
3379: /* Load the steps based into the PL/SQL table P_step_tbl based on the dependencies */
3380: gmd_auto_step_calc.load_steps (p_parent_id
3381: ,p_called_from_batch
3382: ,NULL
3383: ,p_step_tbl
3384: ,x_routing_id

Line 3395: INTO gmd_auto_step_calc.g_mass_std_um;

3391: IF (gme_common_pvt.g_mass_um_type IS NOT NULL) THEN
3392: OPEN cur_get_std_um (gme_common_pvt.g_mass_um_type);
3393:
3394: FETCH cur_get_std_um
3395: INTO gmd_auto_step_calc.g_mass_std_um;
3396:
3397: CLOSE cur_get_std_um;
3398: END IF;
3399:

Line 3404: INTO gmd_auto_step_calc.g_vol_std_um;

3400: IF (gme_common_pvt.g_volume_um_type IS NOT NULL) THEN
3401: OPEN cur_get_std_um (gme_common_pvt.g_volume_um_type);
3402:
3403: FETCH cur_get_std_um
3404: INTO gmd_auto_step_calc.g_vol_std_um;
3405:
3406: CLOSE cur_get_std_um;
3407: END IF;
3408:

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

3429: CLOSE cur_get_std_factor;
3430:
3431: IF x_uom_class = gme_common_pvt.g_mass_um_type THEN
3432: p_step_tbl (i).step_mass_qty := x_step_qty * x_new_factor;
3433: p_step_tbl (i).step_mass_uom := gmd_auto_step_calc.g_mass_std_um;
3434: ELSIF x_uom_class = gme_common_pvt.g_volume_um_type THEN
3435: p_step_tbl (i).step_vol_qty := x_step_qty * x_new_factor;
3436: p_step_tbl (i).step_vol_uom := gmd_auto_step_calc.g_vol_std_um;
3437: END IF;

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

3432: p_step_tbl (i).step_mass_qty := x_step_qty * x_new_factor;
3433: p_step_tbl (i).step_mass_uom := gmd_auto_step_calc.g_mass_std_um;
3434: ELSIF x_uom_class = gme_common_pvt.g_volume_um_type THEN
3435: p_step_tbl (i).step_vol_qty := x_step_qty * x_new_factor;
3436: p_step_tbl (i).step_vol_uom := gmd_auto_step_calc.g_vol_std_um;
3437: END IF;
3438: END LOOP; /*FOR i IN 1..X_step_rows*/
3439:
3440: IF g_debug <= gme_debug.g_log_procedure THEN