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.GMD_AUTO_STEP_CALC dependencies on GMD_AUTO_STEP_CALC

Line 1: PACKAGE BODY GMD_AUTO_STEP_CALC AS

1: PACKAGE BODY GMD_AUTO_STEP_CALC AS
2: /* $Header: GMDSTEPB.pls 120.8.12020000.2 2012/08/08 01:15:11 qzeng ship $ */
3:
4: /*======================================================================
5: -- PROCEDURE :

Line 80: x_check gmd_auto_step_calc.calculatable_rec_type;

76:
77: X_work_step_qty_tbl work_step_qty_tbl;
78: l_return_status VARCHAR2(10);
79:
80: x_check gmd_auto_step_calc.calculatable_rec_type;
81: x_ignore_mass_conv BOOLEAN DEFAULT FALSE;
82: x_ignore_vol_conv BOOLEAN DEFAULT FALSE;
83:
84: /* Cursor Definitions.

Line 132: P_parm_value => gmd_auto_step_calc.G_PROFILE_MASS_UM_TYPE ,

128: END IF;
129:
130: GMD_API_GRP.FETCH_PARM_VALUES (P_orgn_id => p_organization_id ,
131: P_parm_name => 'GMD_MASS_UM_TYPE' ,
132: P_parm_value => gmd_auto_step_calc.G_PROFILE_MASS_UM_TYPE ,
133: X_return_status => l_return_status );
134:
135: GMD_API_GRP.FETCH_PARM_VALUES (P_orgn_id => p_organization_id ,
136: P_parm_name => 'GMD_VOLUME_UM_TYPE' ,

Line 137: P_parm_value => gmd_auto_step_calc.G_PROFILE_VOLUME_UM_TYPE ,

133: X_return_status => l_return_status );
134:
135: GMD_API_GRP.FETCH_PARM_VALUES (P_orgn_id => p_organization_id ,
136: P_parm_name => 'GMD_VOLUME_UM_TYPE' ,
137: P_parm_value => gmd_auto_step_calc.G_PROFILE_VOLUME_UM_TYPE ,
138: X_return_status => l_return_status );
139:
140: /* Load all steps into the PL/SQL table P_step_tbl */
141: /* Table is returned with step no filled in; qty and uom fields empty */

Line 1847: P_parm_value => gmd_auto_step_calc.G_PROFILE_MASS_UM_TYPE ,

1843: END IF;
1844:
1845: GMD_API_GRP.FETCH_PARM_VALUES (P_orgn_id => p_organization_id ,
1846: P_parm_name => 'GMD_MASS_UM_TYPE' ,
1847: P_parm_value => gmd_auto_step_calc.G_PROFILE_MASS_UM_TYPE ,
1848: X_return_status => l_return_status );
1849:
1850: GMD_API_GRP.FETCH_PARM_VALUES (P_orgn_id => p_organization_id ,
1851: P_parm_name => 'GMD_VOLUME_UM_TYPE' ,

Line 1852: P_parm_value => gmd_auto_step_calc.G_PROFILE_VOLUME_UM_TYPE ,

1848: X_return_status => l_return_status );
1849:
1850: GMD_API_GRP.FETCH_PARM_VALUES (P_orgn_id => p_organization_id ,
1851: P_parm_name => 'GMD_VOLUME_UM_TYPE' ,
1852: P_parm_value => gmd_auto_step_calc.G_PROFILE_VOLUME_UM_TYPE ,
1853: X_return_status => l_return_status );
1854:
1855: OPEN Cur_get_recipe_details;
1856: FETCH Cur_get_recipe_details INTO X_recipe_details_rec;

Line 2152: -- Procedures used: gmd_auto_step_calc.check_step_qty_calculatable

2148: --
2149: -- SYNOPSIS:
2150: -- cascade_del_to_step_mat (p_check, X_return_status);
2151: --
2152: -- Procedures used: gmd_auto_step_calc.check_step_qty_calculatable
2153: -- gmd_auto_step_calc.calc_step_qty
2154: -- gmd_recipe_detail.recipe_routing_steps
2155: --
2156: -- HISTORY

Line 2153: -- gmd_auto_step_calc.calc_step_qty

2149: -- SYNOPSIS:
2150: -- cascade_del_to_step_mat (p_check, X_return_status);
2151: --
2152: -- Procedures used: gmd_auto_step_calc.check_step_qty_calculatable
2153: -- gmd_auto_step_calc.calc_step_qty
2154: -- gmd_recipe_detail.recipe_routing_steps
2155: --
2156: -- HISTORY
2157: -- 25Jul2001 L.R.Jackson Bug 1856832. Created

Line 2172: X_step_tbl gmd_auto_step_calc.step_rec_tbl;

2168: P_organization_id IN NUMBER) IS
2169:
2170: x_recipe_cntr NUMBER := 0;
2171: x_step_cntr NUMBER := 0;
2172: X_step_tbl gmd_auto_step_calc.step_rec_tbl;
2173: X_all_steps_tbl gmd_recipe_detail.recipe_detail_tbl;
2174: x_flex gmd_recipe_detail.recipe_flex;
2175: x_update_flex gmd_recipe_detail.recipe_update_flex;
2176: x_check_out gmd_auto_step_calc.calculatable_rec_type;

Line 2176: x_check_out gmd_auto_step_calc.calculatable_rec_type;

2172: X_step_tbl gmd_auto_step_calc.step_rec_tbl;
2173: X_all_steps_tbl gmd_recipe_detail.recipe_detail_tbl;
2174: x_flex gmd_recipe_detail.recipe_flex;
2175: x_update_flex gmd_recipe_detail.recipe_update_flex;
2176: x_check_out gmd_auto_step_calc.calculatable_rec_type;
2177: debug_msg EXCEPTION; -- used in debugging
2178: x_ignore_mass_conv BOOLEAN;
2179: x_ignore_vol_conv BOOLEAN;
2180: ALL_MTL_LINES_NOT_ASSOC EXCEPTION;

Line 2186: -- 1. Use gmd_auto_step_calc.check_del_from_step_mat to get a list of recipes where

2182: BEGIN
2183: P_return_status := FND_API.G_RET_STS_SUCCESS;
2184: -- Calling program should delete from fm_matl_dtl.
2185: -- DELETE FROM fm_matl_dtl WHERE formulaline_id = P_formulaline_id;
2186: -- 1. Use gmd_auto_step_calc.check_del_from_step_mat to get a list of recipes where
2187: -- this formulaline exists in step/mat association,
2188: -- and where calculate_step_qty flag IS set (ASQC=Yes)
2189: -- and where delete_mark is NOT set
2190: -- and the recipe is NOT marked obsolete.

Line 2236: gmd_auto_step_calc.check_step_qty_calculatable

2232: FOR x_recipe_cntr in 1..P_recipe_tbl.COUNT LOOP
2233: -- debug dbms_output.put_line('call asqc to recalculate here. Give user a message. recipe_id '|| x_recipe_tbl(x_recipe_cntr) );
2234: x_check_out := p_check;
2235: x_check_out.parent_id := P_recipe_tbl(x_recipe_cntr);
2236: gmd_auto_step_calc.check_step_qty_calculatable
2237: (p_check => x_check_out,
2238: p_msg_count => P_msg_count,
2239: p_msg_stack => P_msg_stack,
2240: p_return_status => P_return_status,

Line 2247: gmd_auto_step_calc.calc_step_qty(p_parent_id => P_recipe_tbl(x_recipe_cntr),

2243: P_organization_id => P_organization_id);
2244:
2245: -- debug dbms_output.put_line('status from calculatable is ' || p_return_status);
2246: IF p_return_status = 'S' THEN
2247: gmd_auto_step_calc.calc_step_qty(p_parent_id => P_recipe_tbl(x_recipe_cntr),
2248: p_step_tbl => X_step_tbl,
2249: p_msg_count => P_msg_count,
2250: p_msg_stack => P_msg_stack,
2251: p_return_status => p_return_status,

Line 2481: END GMD_AUTO_STEP_CALC;

2477: p_ignore_vol_conv := FALSE;
2478: END check_Bch_stp_qty_calculatable;
2479:
2480:
2481: END GMD_AUTO_STEP_CALC;