APPS.GMD_PARAMETERS_HDR_PKG dependencies on GMD_PARAMETERS_HDR

Line 1: PACKAGE BODY GMD_PARAMETERS_HDR_PKG AS

1: PACKAGE BODY GMD_PARAMETERS_HDR_PKG AS
2: /* $Header: GMDPRHDB.pls 120.1 2006/02/20 04:51:50 kshukla noship $ */
3:
4: /*======================================================================
5: -- PROCEDURE :

Line 29: FROM GMD_PARAMETERS_HDR

25: ) IS
26:
27: CURSOR C IS
28: SELECT ROWID
29: FROM GMD_PARAMETERS_HDR
30: WHERE PARAMETER_ID = X_PARAMETER_ID;
31:
32: BEGIN
33: INSERT INTO GMD_PARAMETERS_HDR (

Line 33: INSERT INTO GMD_PARAMETERS_HDR (

29: FROM GMD_PARAMETERS_HDR
30: WHERE PARAMETER_ID = X_PARAMETER_ID;
31:
32: BEGIN
33: INSERT INTO GMD_PARAMETERS_HDR (
34: ORGANIZATION_ID,
35: LAB_IND,
36: PLANT_IND,
37: PARAMETER_ID,

Line 87: FROM GMD_PARAMETERS_HDR

83: ORGANIZATION_ID,
84: LAB_IND,
85: PLANT_IND,
86: PARAMETER_ID
87: FROM GMD_PARAMETERS_HDR
88: WHERE PARAMETER_ID = X_PARAMETER_ID
89: FOR UPDATE OF PARAMETER_ID NOWAIT;
90:
91: RECINFO C%ROWTYPE;

Line 142: UPDATE GMD_PARAMETERS_HDR SET

138: X_LAST_UPDATE_LOGIN IN NUMBER
139: ) IS
140:
141: BEGIN
142: UPDATE GMD_PARAMETERS_HDR SET
143: ORGANIZATION_ID = X_ORGANIZATION_ID,
144: LAB_IND = X_LAB_IND,
145: PLANT_IND = X_PLANT_IND,
146: PARAMETER_ID = X_PARAMETER_ID,

Line 174: DELETE FROM GMD_PARAMETERS_HDR

170: ) IS
171:
172: BEGIN
173:
174: DELETE FROM GMD_PARAMETERS_HDR
175: WHERE PARAMETER_ID = X_PARAMETER_ID;
176:
177: IF (SQL%NOTFOUND) THEN
178: RAISE NO_DATA_FOUND;

Line 183: END GMD_PARAMETERS_HDR_PKG;

179: END IF;
180:
181: END DELETE_ROW;
182:
183: END GMD_PARAMETERS_HDR_PKG;