APPS.JTF_OBJECT_PARAM_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW  ( X_ROWID  IN OUT NOCOPY   VARCHAR2,
    X_OBJECT_DTLS_ID IN NUMBER,
    X_SOURCE_PARAM IN VARCHAR2,
    X_DEST_PARAM IN VARCHAR2,
    X_CREATION_DATE IN DATE,
    X_CREATED_BY IN NUMBER,
    X_LAST_UPDATED_BY IN NUMBER,
    X_LAST_UPDATE_DATE IN DATE,
    X_LAST_UPDATE_LOGIN IN NUMBER)
   is

   l_PARAMETER_ID jtf_object_pg_params.parameter_id%type;

Line: 16

  select ROWID from jtf_object_pg_params
    where parameter_id=l_PARAMETER_ID;

Line: 22

INSERT INTO  JTF_OBJECT_PG_PARAMS
      (  PARAMETER_ID ,
         OBJECT_DTLS_ID ,
         SOURCE_PARAM ,
         DEST_PARAM ,
         CREATION_DATE,
         CREATED_BY ,
         LAST_UPDATED_BY ,
         LAST_UPDATE_DATE ,
         LAST_UPDATE_LOGIN ,
         OBJECT_VERSION_NUMBER )
         VALUES
         (
         JTF_OBJECT_PG_PARAMS_S.NEXTVAL,
         X_OBJECT_DTLS_ID ,
         X_SOURCE_PARAM ,
         X_DEST_PARAM ,
         X_CREATION_DATE,
         X_CREATED_BY ,
         X_LAST_UPDATED_BY ,
         X_LAST_UPDATE_DATE ,
         X_LAST_UPDATE_LOGIN ,
         1.0 )
         returning PARAMETER_ID into l_PARAMETER_ID;

Line: 56

end INSERT_ROW;

Line: 62

  cursor c is select
        OBJECT_VERSION_NUMBER
    from jtf_object_pg_params
    where parameter_id= X_PARAMETER_ID
    for update of PARAMETER_ID nowait;

Line: 92

procedure UPDATE_ROW  ( X_PARAMETER_ID  IN NUMBER,
        X_SOURCE_PARAM IN VARCHAR2,
        X_DEST_PARAM IN VARCHAR2,
        X_LAST_UPDATED_BY IN NUMBER,
        X_LAST_UPDATE_DATE IN DATE,
        X_LAST_UPDATE_LOGIN IN NUMBER,
        X_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
   ) is

   l_object_version_number jtf_object_pg_params.object_version_number%type;

Line: 106

UPDATE  JTF_OBJECT_PG_PARAMS A
SET
   A.SOURCE_PARAM = X_SOURCE_PARAM
 , A.DEST_PARAM = X_DEST_PARAM
 , A.LAST_UPDATED_BY = X_LAST_UPDATED_BY
 , A.LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
 , A.LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
 , A.OBJECT_VERSION_NUMBER =(X_OBJECT_VERSION_NUMBER + 1.0)

  where  PARAMETER_ID=X_PARAMETER_ID;

Line: 123

end UPDATE_ROW;

Line: 125

procedure DELETE_ROW (
  X_PARAMETER_ID  IN NUMBER,
  X_OBJECT_VERSION_NUMBER IN NUMBER
) is

begin


  delete from JTF_OBJECT_PG_PARAMS
  where PARAMETER_ID = X_PARAMETER_ID
  and   object_version_number=X_OBJECT_VERSION_NUMBER ;

Line: 141

end DELETE_ROW;