APPS.GMD_FORMULATION_SPECS_PKG dependencies on GMD_FORMULATION_SPECS_PKG

Line 1: PACKAGE BODY GMD_FORMULATION_SPECS_PKG AS

1: PACKAGE BODY GMD_FORMULATION_SPECS_PKG AS
2: /* $Header: GMDFSTHB.pls 120.3 2006/02/07 02:50:48 srsriran noship $ */
3:
4: /* Formulation Specification - Table Handlers */
5:

Line 880: x_spec_rec OUT NOCOPY GMD_FORMULATION_SPECS_PKG.l_spec_table

876: p_lot_pick_strategy IN VARCHAR2 DEFAULT NULL ,
877: p_std_qty IN NUMBER DEFAULT NULL ,
878: p_std_uom IN VARCHAR2 DEFAULT NULL ,
879: x_search_clause IN OUT NOCOPY VARCHAR2 ,
880: x_spec_rec OUT NOCOPY GMD_FORMULATION_SPECS_PKG.l_spec_table
881: ) IS
882:
883:
884: TYPE dyn_cursor IS REF CURSOR;

Line 1039: END GMD_FORMULATION_SPECS_PKG;

1035: x_search_clause := 'SELECT * FROM gmd_formulation_specs fs WHERE ' || NVL (l_where, '1 = 1') || ' ORDER BY spec_name, spec_vers';
1036:
1037: END Get_specifications;
1038:
1039: END GMD_FORMULATION_SPECS_PKG;
1040: