APPS.EAM_SAFETY_ASSET_NUMBER_PUB SQL Statements

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

Line: 26

/*Procedure to create or update asset/instance safety lookups-positional asset/lockout device*/
PROCEDURE CREATEUPDATE_ASSET_SAFETY_INFO
(
    p_api_version                    IN           NUMBER
   ,p_commit	    	             IN           VARCHAR2 := FND_API.G_FALSE
   ,p_eAM_asset_safety_tbl           IN           EAM_SAFETY_ASSET_NUMBER_PUB.eam_asset_safety_info_tbl_type
   ,x_return_status                  OUT  NOCOPY  VARCHAR2
   ,x_msg_count		                 OUT  NOCOPY  NUMBER
   ,x_msg_data	                     OUT  NOCOPY  VARCHAR2
 ) IS
   l_api_name                      CONSTANT VARCHAR2(30)   := 'CREATEUPDATE_ASSET_SAFETY_INFO';

Line: 45

   l_create_update  VARCHAR2(1);

Line: 54

    SAVEPOINT CREATEUPDATE_ASSET_SAFETY_INFO;

Line: 90

		      ,x_create_update => l_create_update
		      ,x_return_status => l_return_status
	     	  ,x_msg_count     => l_msg_count
          ,x_msg_data      => l_msg_data
	     	);

Line: 114

			IF l_create_update = 'U' THEN

		           EAM_SAFETY_ASSET_NUMBER_PVT.UPDATE_ROW
                    ( p_eAM_asset_safety_rec    => p_eAM_asset_safety_tbl(i)
                     ,x_return_status => l_return_status
                    );

Line: 128

	 /*l_create_update = 'C' indicates that asset number safety lookup values are being entered for the first time for asset/instance */
		  IF l_create_update = 'C' THEN

		          EAM_SAFETY_ASSET_NUMBER_PVT.INSERT_ROW
                    ( p_eAM_asset_safety_rec    => p_eAM_asset_safety_tbl(i)
                    ,x_return_status => l_return_status
                    );

Line: 162

                ROLLBACK TO CREATEUPDATE_ASSET_SAFETY_INFO;

Line: 171

                ROLLBACK TO CREATEUPDATE_ASSET_SAFETY_INFO;

Line: 180

                ROLLBACK TO CREATEUPDATE_ASSET_SAFETY_INFO;

Line: 195

END CREATEUPDATE_ASSET_SAFETY_INFO;