1 PACKAGE gmf_routing_step_calc AUTHID CURRENT_USER AS
2 /* $Header: gmfsteps.pls 120.0 2005/05/26 00:51:21 appldev noship $ */
3
4 /**********************************************************************
5 * NAME
6 * CALC_STEP_QTY
7 *
8 * DESCRIPTION
9 * Wrapper for GMD_AUTO_STEP_CALC.calc_step_qty procedure
10 * Calls the gmd procedure and caches the step table output in
11 * a package variable. The next procedure get_step_qty is
12 * used to retrieve the individual rows from the cost_calc_rout
13 * function of cost rollup and in variances calculation of
14 * subledger.
15 * HISTORY
16 * 12-Apr-2002 Rajesh Seshadri Bug 2269125
17 * 18-Jul-2002 Rajesh Seshadri Bug 2468924 - send process loss to
18 * ASQC routine.
19 * 02-Jan-2003 Venkat Chukkapalli Bug#2700453 Added DEFAULT 0 to
20 * process_loss parameters.
21 **********************************************************************/
22 PROCEDURE calc_step_qty(
23 p_recipe_id IN NUMBER,
24 p_fmeff_id IN NUMBER,
25 p_scale_factor IN NUMBER,
26 p_process_loss IN NUMBER DEFAULT 0,
27 x_error_code OUT NOCOPY NUMBER,
28 x_error_msg OUT NOCOPY VARCHAR2);
29
30 /**********************************************************************
31 * NAME
32 * GET_STEP_QTY
33 *
34 * DESCRIPTION
35 * Used to retrieve the individual step's quantity. Called from
36 * cost_calc_rout of cost rollup and compute_variances of
37 * subledger.
38 *
39 * HISTORY
40 * 12-Apr-2002 Rajesh Seshadri Bug 2269125
41 **********************************************************************/
42 PROCEDURE get_step_qty(
43 p_recipe_id IN NUMBER,
44 p_step_id IN NUMBER,
45 p_step_no IN NUMBER,
46 x_step_qty OUT NOCOPY NUMBER,
47 x_error_code OUT NOCOPY NUMBER);
48
49 END gmf_routing_step_calc;