APPS.PV_ENTY_ATTR_VALIDATIONS_PUB SQL Statements

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

Line: 24

PROCEDURE Update_Attr_Validations(
     p_api_version_number         IN   NUMBER
    ,p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE
    ,p_commit                     IN   VARCHAR2     := FND_API.G_FALSE
    ,p_validation_level           IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL

    ,x_return_status              OUT NOCOPY  VARCHAR2
    ,x_msg_count                  OUT NOCOPY  NUMBER
    ,x_msg_data                   OUT NOCOPY  VARCHAR2

    ,p_enty_attr_validation_rec   IN   PV_ENTY_ATTR_VALIDATIONS_PVT.enty_attr_validation_rec_type  := PV_ENTY_ATTR_VALIDATIONS_PVT.g_miss_enty_attr_vldtn_rec
	,p_attribute_Id				  IN NUMBER
	,p_entity_Id				  IN NUMBER
	,p_entity                     IN VARCHAR2

    )
 IS

CURSOR c_get_enty_attr_value(cv_entity_id NUMBER, cv_attribute_id NUMBER, cv_entity VARCHAR2 ) IS
    SELECT *
    FROM  PV_ENTY_ATTR_VALUES
    WHERE entity_id = cv_entity_id and
	      attribute_id = cv_attribute_id and
		  entity = cv_entity and
		  latest_flag = 'Y'
		  ;

Line: 51

l_api_name                 CONSTANT VARCHAR2(30) := 'Update_Attr_Validations';

Line: 66

      SAVEPOINT Update_Attr_Validations_PUB;

Line: 121

      PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Open Cursor to Select');

Line: 140

			l_tar_enty_attr_val_rec.last_update_date               := SYSDATE;

Line: 141

			l_tar_enty_attr_val_rec.last_updated_by                := G_USER_ID;

Line: 144

			l_tar_enty_attr_val_rec.last_update_login              := l_ref_enty_attr_val_rec.last_update_login;

Line: 158

			PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - calling PV_Enty_Attr_Value_PVT.Update_Attr_Value');

Line: 160

			PV_Enty_Attr_Value_PVT.Update_Attr_Value(
				 p_api_version_number         => p_api_version_number
				,p_init_msg_list              => p_init_msg_list
				,p_commit                     => p_commit
				,p_validation_level           => p_validation_level

				,x_return_status              => x_return_status
				,x_msg_count                  => x_msg_count
				,x_msg_data                   => x_msg_data

				,p_enty_attr_val_rec		  => l_tar_enty_attr_val_rec
				,x_object_version_number	  => l_object_version_number
			);

Line: 190

			   FND_MESSAGE.set_token('MODE','Update');

Line: 227

     ROLLBACK TO Update_Attr_Validations_PUB;

Line: 237

     ROLLBACK TO Update_Attr_Validations_PUB;

Line: 247

     ROLLBACK TO Update_Attr_Validations_PUB;

Line: 259

End Update_Attr_Validations;