APPS.GMD_PARAMETERS_HDR_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14

PROCEDURE INSERT_ROW (
  X_ROWID               IN OUT NOCOPY VARCHAR2,
  X_PARAMETER_ID        IN NUMBER,
  X_ORGANIZATION_ID     IN NUMBER,
  X_LAB_IND             IN NUMBER,
  X_PLANT_IND           IN NUMBER,
  X_CREATION_DATE       IN DATE,
  X_CREATED_BY          IN NUMBER,
  X_LAST_UPDATE_DATE    IN DATE,
  X_LAST_UPDATED_BY     IN NUMBER,
  X_LAST_UPDATE_LOGIN   IN NUMBER
) IS

CURSOR C IS
  SELECT ROWID
  FROM GMD_PARAMETERS_HDR
  WHERE PARAMETER_ID = X_PARAMETER_ID;

Line: 33

  INSERT INTO GMD_PARAMETERS_HDR (
    ORGANIZATION_ID,
    LAB_IND,
    PLANT_IND,
    PARAMETER_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_ORGANIZATION_ID,
    X_LAB_IND,
    X_PLANT_IND,
    X_PARAMETER_ID,
    SYSDATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 63

END INSERT_ROW;

Line: 82

  CURSOR C IS SELECT
      ORGANIZATION_ID,
      LAB_IND,
      PLANT_IND,
      PARAMETER_ID
    FROM GMD_PARAMETERS_HDR
    WHERE PARAMETER_ID = X_PARAMETER_ID
    FOR UPDATE OF PARAMETER_ID NOWAIT;

Line: 98

    FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

Line: 131

PROCEDURE UPDATE_ROW (
  X_PARAMETER_ID        IN NUMBER,
  X_ORGANIZATION_ID     IN NUMBER,
  X_LAB_IND             IN NUMBER,
  X_PLANT_IND           IN NUMBER,
  X_LAST_UPDATE_DATE    IN DATE,
  X_LAST_UPDATED_BY     IN NUMBER,
  X_LAST_UPDATE_LOGIN   IN NUMBER
) IS

BEGIN
  UPDATE GMD_PARAMETERS_HDR SET
    ORGANIZATION_ID = X_ORGANIZATION_ID,
    LAB_IND = X_LAB_IND,
    PLANT_IND = X_PLANT_IND,
    PARAMETER_ID = X_PARAMETER_ID,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  WHERE PARAMETER_ID = X_PARAMETER_ID;

Line: 156

END UPDATE_ROW;

Line: 168

PROCEDURE DELETE_ROW (
  X_PARAMETER_ID IN NUMBER
) IS

BEGIN

  DELETE FROM GMD_PARAMETERS_HDR
  WHERE PARAMETER_ID = X_PARAMETER_ID;

Line: 181

END DELETE_ROW;