APPS.GMD_PARAMETERS_DTL_PKG SQL Statements

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

Line: 15

PROCEDURE INSERT_ROW (
  X_ROWID               OUT NOCOPY VARCHAR2,
  X_PARAMETER_LINE_ID   IN NUMBER,
  X_PARAMETER_ID        IN NUMBER,
  X_PARM_TYPE           IN NUMBER,
  X_PARAMETER_NAME      IN VARCHAR2,
  X_PARAMETER_VALUE     IN VARCHAR2,
  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_DTL
WHERE PARAMETER_LINE_ID = X_PARAMETER_LINE_ID;

Line: 35

  INSERT INTO GMD_PARAMETERS_DTL (
    PARAMETER_ID,
    PARAMETER_LINE_ID,
    PARAMETER_TYPE,
    PARAMETER_NAME,
    PARAMETER_VALUE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) VALUES (
    X_PARAMETER_ID,
    X_PARAMETER_LINE_ID,
    X_PARM_TYPE,
    X_PARAMETER_NAME,
    X_PARAMETER_VALUE,
    SYSDATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 70

END INSERT_ROW;

Line: 93

    SELECT
      PARAMETER_ID,
      PARAMETER_TYPE,
      PARAMETER_NAME,
      PARAMETER_VALUE
    FROM GMD_PARAMETERS_DTL
    WHERE PARAMETER_LINE_ID = X_PARAMETER_LINE_ID
    FOR UPDATE OF PARAMETER_LINE_ID NOWAIT;

Line: 103

    SELECT 1
    from GEM_LOOKUPS
    where lookup_code =X_PARAMETER_NAME
    and   lookup_type =X_LOOKUP_TYPE;

Line: 123

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

Line: 184

PROCEDURE UPDATE_ROW (
  X_PARAMETER_LINE_ID   IN NUMBER,
  X_PARAMETER_ID        IN NUMBER,
  X_PARM_TYPE           IN NUMBER,
  X_PARAMETER_NAME      IN VARCHAR2,
  X_PARAMETER_VALUE     IN VARCHAR2,
  X_LAST_UPDATE_DATE    IN DATE,
  X_LAST_UPDATED_BY     IN NUMBER,
  X_LAST_UPDATE_LOGIN   IN NUMBER
) IS
BEGIN

  UPDATE GMD_PARAMETERS_DTL
  SET
    PARAMETER_ID        = X_PARAMETER_ID,
    PARAMETER_TYPE      = X_PARM_TYPE,
    PARAMETER_NAME      = X_PARAMETER_NAME,
    PARAMETER_VALUE     = X_PARAMETER_VALUE,
    LAST_UPDATE_DATE    = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY     = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN   = X_LAST_UPDATE_LOGIN
  WHERE PARAMETER_LINE_ID = X_PARAMETER_LINE_ID;

Line: 213

END UPDATE_ROW;

Line: 226

PROCEDURE DELETE_ROW (
  X_PARAMETER_LINE_ID IN NUMBER
) IS
BEGIN

  DELETE FROM GMD_PARAMETERS_DTL
  WHERE PARAMETER_LINE_ID = X_PARAMETER_LINE_ID;

Line: 237

END DELETE_ROW;

Line: 257

select  d.parameter_id parameter_id,d.parameter_line_id parameter_line_id
       ,d.parameter_type parameter_type, d.parameter_name parameter_name
       ,d.PARAMETER_VALUE PARAMETER_VALUE,d.creation_date creation_date
       ,d.last_updated_by last_updated_by,d.last_update_date last_update_date
       ,d.last_update_login last_update_login
       ,d.created_by created_by
from gmd_parameters_dtl d, gmd_parameters_hdr h
where d.parameter_id = h.parameter_id
and d.parameter_type = l_type
and ((h.organization_id = l_org_id) or ((l_org_id is NULL) and (h.organization_id IS NULL)))
UNION
select  NULL parameter_id,NULL parameter_line_id,NULL parameter_type,lookup_code parameter_name, NULL PARAMETER_VALUE
       ,NULL creation_date ,NULL last_updated_by,NULL last_updated_date,NULL last_updated_login,NULL created_by
FROM gem_lookups l
WHERE lookup_type = l_gem_type
and ENABLED_FLAG = 'Y'
AND not exists (select 1
               from gmd_parameters_dtl d, gmd_parameters_hdr h
               where d.parameter_id = h.parameter_id
               and d.parameter_type = l_type
               and ((h.organization_id = l_org_id) or ((l_org_id is NULL) and (h.organization_id IS NULL)))
               and d.parameter_name = l.lookup_code)
ORDER BY PARAMETER_NAME;

Line: 319

       Xparm_table(X_prcs_cnt).last_updated_by:=l_get_prcs.last_updated_by;