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.6 2006/08/09 05:39:28 kmotupal noship $ */
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 1839: P_parm_value => gmd_auto_step_calc.G_PROFILE_MASS_UM_TYPE ,

1835: END IF;
1836:
1837: GMD_API_GRP.FETCH_PARM_VALUES (P_orgn_id => p_organization_id ,
1838: P_parm_name => 'GMD_MASS_UM_TYPE' ,
1839: P_parm_value => gmd_auto_step_calc.G_PROFILE_MASS_UM_TYPE ,
1840: X_return_status => l_return_status );
1841:
1842: GMD_API_GRP.FETCH_PARM_VALUES (P_orgn_id => p_organization_id ,
1843: P_parm_name => 'GMD_VOLUME_UM_TYPE' ,

Line 1844: P_parm_value => gmd_auto_step_calc.G_PROFILE_VOLUME_UM_TYPE ,

1840: X_return_status => l_return_status );
1841:
1842: GMD_API_GRP.FETCH_PARM_VALUES (P_orgn_id => p_organization_id ,
1843: P_parm_name => 'GMD_VOLUME_UM_TYPE' ,
1844: P_parm_value => gmd_auto_step_calc.G_PROFILE_VOLUME_UM_TYPE ,
1845: X_return_status => l_return_status );
1846:
1847: OPEN Cur_get_recipe_details;
1848: FETCH Cur_get_recipe_details INTO X_recipe_details_rec;

Line 2144: -- Procedures used: gmd_auto_step_calc.check_step_qty_calculatable

2140: --
2141: -- SYNOPSIS:
2142: -- cascade_del_to_step_mat (p_check, X_return_status);
2143: --
2144: -- Procedures used: gmd_auto_step_calc.check_step_qty_calculatable
2145: -- gmd_auto_step_calc.calc_step_qty
2146: -- gmd_recipe_detail.recipe_routing_steps
2147: --
2148: -- HISTORY

Line 2145: -- gmd_auto_step_calc.calc_step_qty

2141: -- SYNOPSIS:
2142: -- cascade_del_to_step_mat (p_check, X_return_status);
2143: --
2144: -- Procedures used: gmd_auto_step_calc.check_step_qty_calculatable
2145: -- gmd_auto_step_calc.calc_step_qty
2146: -- gmd_recipe_detail.recipe_routing_steps
2147: --
2148: -- HISTORY
2149: -- 25Jul2001 L.R.Jackson Bug 1856832. Created

Line 2164: X_step_tbl gmd_auto_step_calc.step_rec_tbl;

2160: P_organization_id IN NUMBER) IS
2161:
2162: x_recipe_cntr NUMBER := 0;
2163: x_step_cntr NUMBER := 0;
2164: X_step_tbl gmd_auto_step_calc.step_rec_tbl;
2165: X_all_steps_tbl gmd_recipe_detail.recipe_detail_tbl;
2166: x_flex gmd_recipe_detail.recipe_flex;
2167: x_update_flex gmd_recipe_detail.recipe_update_flex;
2168: x_check_out gmd_auto_step_calc.calculatable_rec_type;

Line 2168: x_check_out gmd_auto_step_calc.calculatable_rec_type;

2164: X_step_tbl gmd_auto_step_calc.step_rec_tbl;
2165: X_all_steps_tbl gmd_recipe_detail.recipe_detail_tbl;
2166: x_flex gmd_recipe_detail.recipe_flex;
2167: x_update_flex gmd_recipe_detail.recipe_update_flex;
2168: x_check_out gmd_auto_step_calc.calculatable_rec_type;
2169: debug_msg EXCEPTION; -- used in debugging
2170: x_ignore_mass_conv BOOLEAN;
2171: x_ignore_vol_conv BOOLEAN;
2172: ALL_MTL_LINES_NOT_ASSOC EXCEPTION;

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

2174: BEGIN
2175: P_return_status := FND_API.G_RET_STS_SUCCESS;
2176: -- Calling program should delete from fm_matl_dtl.
2177: -- DELETE FROM fm_matl_dtl WHERE formulaline_id = P_formulaline_id;
2178: -- 1. Use gmd_auto_step_calc.check_del_from_step_mat to get a list of recipes where
2179: -- this formulaline exists in step/mat association,
2180: -- and where calculate_step_qty flag IS set (ASQC=Yes)
2181: -- and where delete_mark is NOT set
2182: -- and the recipe is NOT marked obsolete.

Line 2228: gmd_auto_step_calc.check_step_qty_calculatable

2224: FOR x_recipe_cntr in 1..P_recipe_tbl.COUNT LOOP
2225: -- debug dbms_output.put_line('call asqc to recalculate here. Give user a message. recipe_id '|| x_recipe_tbl(x_recipe_cntr) );
2226: x_check_out := p_check;
2227: x_check_out.parent_id := P_recipe_tbl(x_recipe_cntr);
2228: gmd_auto_step_calc.check_step_qty_calculatable
2229: (p_check => x_check_out,
2230: p_msg_count => P_msg_count,
2231: p_msg_stack => P_msg_stack,
2232: p_return_status => P_return_status,

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

2235: P_organization_id => P_organization_id);
2236:
2237: -- debug dbms_output.put_line('status from calculatable is ' || p_return_status);
2238: IF p_return_status = 'S' THEN
2239: gmd_auto_step_calc.calc_step_qty(p_parent_id => P_recipe_tbl(x_recipe_cntr),
2240: p_step_tbl => X_step_tbl,
2241: p_msg_count => P_msg_count,
2242: p_msg_stack => P_msg_stack,
2243: p_return_status => p_return_status,

Line 2473: END GMD_AUTO_STEP_CALC;

2469: p_ignore_vol_conv := FALSE;
2470: END check_Bch_stp_qty_calculatable;
2471:
2472:
2473: END GMD_AUTO_STEP_CALC;