APPS.GMD_FORMULATION_SPECS_PKG dependencies on GMD_FORMULATION_SPECS

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 37: FROM GMD_FORMULATION_SPECS

33: ) IS
34:
35: CURSOR C IS
36: SELECT ROWID
37: FROM GMD_FORMULATION_SPECS
38: WHERE FORMULATION_SPEC_ID = X_FORMULATION_SPEC_ID;
39:
40: BEGIN
41: INSERT INTO GMD_FORMULATION_SPECS (

Line 41: INSERT INTO GMD_FORMULATION_SPECS (

37: FROM GMD_FORMULATION_SPECS
38: WHERE FORMULATION_SPEC_ID = X_FORMULATION_SPEC_ID;
39:
40: BEGIN
41: INSERT INTO GMD_FORMULATION_SPECS (
42: FORMULATION_SPEC_ID,
43: SPEC_VERS,
44: SPEC_NAME,
45: PRODUCT_ID,

Line 146: FROM GMD_FORMULATION_SPECS

142: TECH_PARM_ID,
143: OBJECTIVE_IND,
144: TEXT_CODE,
145: DELETE_MARK
146: FROM GMD_FORMULATION_SPECS
147: WHERE FORMULATION_SPEC_ID = X_FORMULATION_SPEC_ID
148: FOR UPDATE OF FORMULATION_SPEC_ID NOWAIT;
149: RECINFO C%ROWTYPE;
150:

Line 219: UPDATE GMD_FORMULATION_SPECS

215: ) IS
216:
217: BEGIN
218:
219: UPDATE GMD_FORMULATION_SPECS
220: SET
221: PRODUCT_ID = X_PRODUCT_ID,
222: OWNER_ORGANIZATION_ID = X_OWNER_ORGANIZATION_ID,
223: SPEC_STATUS = X_SPEC_STATUS,

Line 253: DELETE FROM GMD_FORMULATION_SPECS

249: X_FORMULATION_SPEC_ID IN NUMBER
250: ) IS
251: BEGIN
252:
253: DELETE FROM GMD_FORMULATION_SPECS
254: WHERE FORMULATION_SPEC_ID = X_FORMULATION_SPEC_ID;
255:
256: IF (SQL%NOTFOUND) THEN
257: RAISE NO_DATA_FOUND;

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 1021: FROM gmd_formulation_specs fs

1017:
1018: /* Fetch the specifications */
1019: OPEN Cur_get_spec FOR
1020: 'SELECT *
1021: FROM gmd_formulation_specs fs
1022: WHERE ' || NVL (l_where, '1 = 1');
1023:
1024: i := 1;
1025: LOOP

Line 1035: x_search_clause := 'SELECT * FROM gmd_formulation_specs fs WHERE ' || NVL (l_where, '1 = 1') || ' ORDER BY spec_name, spec_vers';

1031: CLOSE Cur_get_spec;
1032:
1033: /* Return the WHERE clause so that it can be used to create shortcuts on the WB if
1034: the user wants to save the search condition */
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;

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: