APPS.AHL_WF_MAPPING_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_WF_MAPPING_ID            IN        NUMBER,
  X_OBJECT_VERSION_NUMBER    IN        NUMBER,
  X_LAST_UPDATE_DATE         IN        DATE,
  X_LAST_UPDATED_BY          IN        NUMBER,
  X_CREATION_DATE            IN        DATE,
  X_CREATED_BY 		         IN        NUMBER,
  X_LAST_UPDATE_LOGIN        IN        NUMBER,
  X_ACTIVE_FLAG              IN        VARCHAR2,
  X_WF_PROCESS_NAME          IN        VARCHAR2,
  X_APPROVAL_OBJECT          IN        VARCHAR2,
  X_ITEM_TYPE                IN        VARCHAR2,
  X_APPLICATION_USG_CODE 	IN VARCHAR2
)
is
cursor C is select ROWID from AHL_WF_MAPPING where
            WF_MAPPING_ID = X_WF_MAPPING_ID ;

Line: 23

insert into AHL_WF_MAPPING
(
  WF_MAPPING_ID           ,
  OBJECT_VERSION_NUMBER   ,
  LAST_UPDATE_DATE        ,
  LAST_UPDATED_BY         ,
  CREATION_DATE           ,
  CREATED_BY 		      ,
  LAST_UPDATE_LOGIN       ,
  ACTIVE_FLAG             ,
  WF_PROCESS_NAME         ,
  APPROVAL_OBJECT         ,
  ITEM_TYPE		  ,
  APPLICATION_USG_CODE
)
 values
(
  X_WF_MAPPING_ID            ,
  X_OBJECT_VERSION_NUMBER    ,
  X_LAST_UPDATE_DATE         ,
  X_LAST_UPDATED_BY          ,
  X_CREATION_DATE            ,
  X_CREATED_BY 		         ,
  X_LAST_UPDATE_LOGIN        ,
  X_ACTIVE_FLAG              ,
  X_WF_PROCESS_NAME          ,
  X_APPROVAL_OBJECT          ,
  X_ITEM_TYPE		     ,
  X_APPLICATION_USG_CODE
);

Line: 62

end INSERT_ROW;

Line: 64

procedure UPDATE_ROW
(
  X_WF_MAPPING_ID            IN        NUMBER,
  X_OBJECT_VERSION_NUMBER    IN        NUMBER,
  X_LAST_UPDATE_DATE         IN        DATE,
  X_LAST_UPDATED_BY          IN        NUMBER,
  X_LAST_UPDATE_LOGIN        IN        NUMBER,
  X_ACTIVE_FLAG              IN        VARCHAR2,
  X_WF_PROCESS_NAME          IN        VARCHAR2,
  X_APPROVAL_OBJECT          IN        VARCHAR2,
  X_ITEM_TYPE     IN        VARCHAR2,
X_APPLICATION_USG_CODE 	IN VARCHAR2
) is
begin
  update AHL_WF_MAPPING set
  WF_MAPPING_ID         =  X_WF_MAPPING_ID,
  OBJECT_VERSION_NUMBER =  X_OBJECT_VERSION_NUMBER,
  LAST_UPDATE_DATE 	=  X_LAST_UPDATE_DATE,
  LAST_UPDATED_BY 	=  X_LAST_UPDATED_BY,
  LAST_UPDATE_LOGIN 	=  X_LAST_UPDATE_LOGIN,
  ACTIVE_FLAG           =  X_ACTIVE_FLAG ,
  WF_PROCESS_NAME       =  X_WF_PROCESS_NAME,
  APPROVAL_OBJECT       =  X_APPROVAL_OBJECT,
  ITEM_TYPE             =  X_ITEM_TYPE,
  APPLICATION_USG_CODE  = X_APPLICATION_USG_CODE
  where WF_MAPPING_ID   =  X_WF_MAPPING_ID;

Line: 95

end UPDATE_ROW;

Line: 117

  select  object_version_number
  from    AHL_WF_MAPPING
  where   WF_MAPPING_ID =  X_WF_MAPPING_ID;

Line: 122

  select 'x'
  from   AHL_WF_MAPPING
  where  WF_MAPPING_ID =  X_WF_MAPPING_ID;

Line: 127

   select Ahl_Wf_Mapping_S.NEXTVAL
   from dual;

Line: 150

AHL_WF_MAPPING_PKG.INSERT_ROW
(
  X_ROWID  		     => l_row_id,
  X_WF_MAPPING_ID     => l_wfm_id,
  X_OBJECT_VERSION_NUMBER   => l_obj_verno,
  X_LAST_UPDATE_DATE        => SYSDATE,
  X_LAST_UPDATED_BY          => l_user_id,
  X_CREATION_DATE            => SYSDATE,
  X_CREATED_BY 		        =>l_user_id,
  X_LAST_UPDATE_LOGIN       =>0,
  X_ACTIVE_FLAG              => X_ACTIVE_FLAG,
  X_WF_PROCESS_NAME          => X_WF_PROCESS_NAME,
  X_APPROVAL_OBJECT          =>  X_APPROVAL_OBJECT,
  X_ITEM_TYPE                => X_ITEM_TYPE,
  X_APPLICATION_USG_CODE 	=> X_APPLICATION_USG_CODE
);

Line: 173

  AHL_WF_MAPPING_PKG.UPDATE_ROW
  (
  X_WF_MAPPING_ID            => X_WF_MAPPING_ID,
  X_OBJECT_VERSION_NUMBER    => l_obj_verno + 1,
  X_LAST_UPDATE_DATE         => SYSDATE,
  X_LAST_UPDATED_BY          => l_user_id,
  X_LAST_UPDATE_LOGIN        => 0,
  X_ACTIVE_FLAG              => X_ACTIVE_FLAG,
  X_WF_PROCESS_NAME          => X_WF_PROCESS_NAME,
  X_APPROVAL_OBJECT         =>  X_APPROVAL_OBJECT,
  X_ITEM_TYPE     => X_ITEM_TYPE        ,
  X_APPLICATION_USG_CODE 	=> X_APPLICATION_USG_CODE
  );

Line: 190

procedure DELETE_ROW(
  X_WF_MAPPING_ID in NUMBER
)
is
begin
  delete from AHL_WF_MAPPING
  where WF_MAPPING_ID = X_WF_MAPPING_ID;

Line: 201

end DELETE_ROW;