APPS.EAM_SAFETY_ASSET_NUMBER_PVT SQL Statements

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

Line: 23

PROCEDURE INSERT_ROW
(
    p_eAM_asset_safety_rec    IN           EAM_SAFETY_ASSET_NUMBER_PUB.eam_asset_safety_info_rec_type
   , x_return_status           OUT NOCOPY  VARCHAR2
)  IS

BEGIN

	x_return_status         := FND_API.G_RET_STS_SUCCESS;

Line: 33

	    INSERT INTO EAM_ASSET_SAFETY_TYPES
	     (
	      INSTANCE_ID,
	      EAM_SAFETY_TYPE,
	      OPERATING_POSITION,
	      OPERATING_TAG,
	      SHUTDOWN_POSITION,
	      SHUTDOWN_TAG,
	      POS_LOCKOUT_DEVICE,
	      LOCKOUT_DEVICE,
	      CREATION_DATE,
	      CREATED_BY,
	      LAST_UPDATED_BY,
	      LAST_UPDATE_LOGIN,
	      LAST_UPDATE_DATE
	     )
	     VALUES
	     (
	      p_eAM_asset_safety_rec.instance_id,
              p_eAM_asset_safety_rec.safety_type,
	      p_eAM_asset_safety_rec.operating_position,
	      p_eAM_asset_safety_rec.operating_tag,
	      p_eAM_asset_safety_rec.shutdown_position,
	      p_eAM_asset_safety_rec.shutdown_tag,
	      p_eAM_asset_safety_rec.pos_lockout_device,
	      p_eAM_asset_safety_rec.lockout_device,
	      SYSDATE,
              FND_GLOBAL.user_id,
	      FND_GLOBAL.user_id,
	      FND_GLOBAL.login_id,
              SYSDATE
              );

Line: 71

  END INSERT_ROW;

Line: 74

 PROCEDURE UPDATE_ROW
  ( p_eAM_asset_safety_rec    IN           EAM_SAFETY_ASSET_NUMBER_PUB.eam_asset_safety_info_rec_type
   ,x_return_status           OUT NOCOPY  VARCHAR2
)   IS

  l_instance_id NUMBER;

Line: 85

	 UPDATE EAM_ASSET_SAFETY_TYPES
	    SET
	      eam_safety_type         = p_eAM_asset_safety_rec.safety_type,
		  operating_position        = p_eAM_asset_safety_rec.operating_position,
		  operating_tag             = p_eAM_asset_safety_rec.operating_tag,
		  shutdown_position         = p_eAM_asset_safety_rec.shutdown_position,
		  shutdown_tag              = p_eAM_asset_safety_rec.shutdown_tag,
		  pos_lockout_device         = p_eAM_asset_safety_rec.pos_lockout_device,
		  lockout_device            = p_eAM_asset_safety_rec.lockout_device,
	      LAST_UPDATED_BY    =  FND_GLOBAL.user_id,
	      LAST_UPDATE_LOGIN  =  FND_GLOBAL.login_id,
	      LAST_UPDATE_DATE   =  SYSDATE
	    WHERE
	      INSTANCE_ID = p_eAM_asset_safety_rec.instance_id;

Line: 110

  END UPDATE_ROW;