eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_ENTY_ATTR_VALUE_PVT SQL Statements

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

Line: 51


      SELECT PV_ENTY_ATTR_VALUES_s.NEXTVAL
      FROM dual;

Line: 55


      SELECT 1
      FROM PV_ENTY_ATTR_VALUES
      WHERE ENTY_ATTR_VAL_ID = l_id;

Line: 60


		SELECT *
		FROM  PV_ENTY_ATTR_VALUES
		WHERE attribute_id = cv_attribute_id and
		      entity_id    = cv_entity_id and
		      entity       = cv_entity and
		      latest_flag  = 'Y';

Line: 68


		SELECT attribute_type,display_style,DECIMAL_POINTS,name
		FROM  PV_ATTRIBUTES_VL
		WHERE attribute_id = cv_attribute_id
		      ;

Line: 145


           l_enty_attr_val_rec.last_update_date      := SYSDATE;

Line: 146


           l_enty_attr_val_rec.last_updated_by       := G_USER_ID;

Line: 149


           l_enty_attr_val_rec.last_update_login     := G_LOGIN_ID;

Line: 214


		  FOR x IN (select meaning from pv_lookups
			    where lookup_type = 'PV_ATTRIBUTE_TYPE'
			    and lookup_code = l_attribute_type
			   ) LOOP
			l_meaning := x.meaning;

Line: 222


		  FOR x IN (select meaning from pv_lookups
			    where lookup_type = 'PV_ATTR_DISPLAY_STYLE'
			    and lookup_code = l_display_style
			   ) LOOP
			l_meaning := x.meaning;

Line: 243


      PV_ENTY_ATTR_VALUES_PKG.Insert_Row(
           px_enty_attr_val_id       => l_enty_attr_val_rec.enty_attr_val_id
          ,p_last_update_date        => l_enty_attr_val_rec.last_update_date
          ,p_last_updated_by         => l_enty_attr_val_rec.last_updated_by
          ,p_creation_date           => l_enty_attr_val_rec.creation_date
          ,p_created_by              => l_enty_attr_val_rec.created_by
          ,p_last_update_login       => l_enty_attr_val_rec.last_update_login
          ,px_object_version_number  => l_object_version_number
          ,p_entity                  => l_enty_attr_val_rec.entity
          ,p_attribute_id            => l_enty_attr_val_rec.attribute_id
          ,p_party_id                => l_enty_attr_val_rec.party_id
          ,p_attr_value              => l_enty_attr_val_rec.attr_value
          ,p_score                   => l_enty_attr_val_rec.score
          ,p_enabled_flag            => l_enty_attr_val_rec.enabled_flag
          ,p_entity_id               => l_enty_attr_val_rec.entity_id
          -- p_security_group_id     => p_enty_attr_val_rec.security_group_id
	  ,p_version		     => l_enty_attr_val_rec.version
	  ,p_latest_flag		     => l_enty_attr_val_rec.latest_flag
	  ,p_attr_value_extn	     => l_enty_attr_val_rec.attr_value_extn
	  ,p_validation_id	     => l_enty_attr_val_rec.validation_id
          );

Line: 337


PROCEDURE Update_Attr_Value(
     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_val_rec          IN   enty_attr_val_rec_type
    ,x_object_version_number      OUT NOCOPY  NUMBER
    )
 IS

CURSOR c_get_enty_attr_value(cv_enty_attr_val_id NUMBER) IS
    SELECT *
    FROM  PV_ENTY_ATTR_VALUES
    WHERE enty_attr_val_id = cv_enty_attr_val_id;

Line: 357


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

Line: 369


      SAVEPOINT Update_Attr_Value_PVT;

Line: 398


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

Line: 408


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

Line: 427


			   FND_MESSAGE.set_token('COLUMN','Last_Update_Date');

Line: 458


		    ,p_validation_mode      => JTF_PLSQL_API.g_update
		    ,p_enty_attr_val_rec    => p_enty_attr_val_rec
		    ,x_return_status        => x_return_status
		    ,x_msg_count            => x_msg_count
		    ,x_msg_data             => x_msg_data
		    );

Line: 475


       PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');

Line: 479


      PV_ENTY_ATTR_VALUES_PKG.Update_Row(
           p_enty_attr_val_id       => p_enty_attr_val_rec.enty_attr_val_id
          ,p_last_update_date       => SYSDATE
          ,p_last_updated_by        => G_USER_ID
          -- p_creation_date          => SYSDATE
          -- p_created_by             => G_USER_ID
          ,p_last_update_login      => G_LOGIN_ID
          ,p_object_version_number  => p_enty_attr_val_rec.object_version_number
          ,p_entity                 => p_enty_attr_val_rec.entity
          ,p_attribute_id           => p_enty_attr_val_rec.attribute_id
          ,p_party_id               => p_enty_attr_val_rec.party_id
          ,p_attr_value             => p_enty_attr_val_rec.attr_value
          ,p_score                  => p_enty_attr_val_rec.score
          ,p_enabled_flag           => p_enty_attr_val_rec.enabled_flag
          ,p_entity_id              => p_enty_attr_val_rec.entity_id
          -- p_security_group_id    => p_enty_attr_val_rec.security_group_id
		  ,p_version		        => p_enty_attr_val_rec.version
		  ,p_latest_flag		    => p_enty_attr_val_rec.latest_flag
		  ,p_attr_value_extn	    => p_enty_attr_val_rec.attr_value_extn
		  ,p_validation_id	        => p_enty_attr_val_rec.validation_id
          );

Line: 528


     ROLLBACK TO Update_Attr_Value_PVT;

Line: 538


     ROLLBACK TO Update_Attr_Value_PVT;

Line: 548


     ROLLBACK TO Update_Attr_Value_PVT;

Line: 560


End Update_Attr_Value;

Line: 563


PROCEDURE Delete_Attr_Value(
     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_val_id           IN  NUMBER
    ,p_object_version_number      IN   NUMBER
    )

 IS
l_api_name                  CONSTANT VARCHAR2(30) := 'Delete_Attr_Value';

Line: 585


      SAVEPOINT Delete_Attr_Value_PVT;

Line: 616


       PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling delete table handler');

Line: 619


      PV_ENTY_ATTR_VALUES_PKG.Delete_Row(
          p_ENTY_ATTR_VAL_ID  => p_ENTY_ATTR_VAL_ID);

Line: 647


     ROLLBACK TO Delete_Attr_Value_PVT;

Line: 657


     ROLLBACK TO Delete_Attr_Value_PVT;

Line: 667


     ROLLBACK TO Delete_Attr_Value_PVT;

Line: 679


End Delete_Attr_Value;

Line: 703


   SELECT ENTY_ATTR_VAL_ID
   FROM PV_ENTY_ATTR_VALUES
   WHERE ENTY_ATTR_VAL_ID = p_ENTY_ATTR_VAL_ID
   AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 876


      IF p_enty_attr_val_rec.last_update_date = FND_API.g_miss_date
         OR p_enty_attr_val_rec.last_update_date IS NULL THEN

--DBMS_OUTPUT.PUT_LINE('p_enty_attr_val_rec.LAST_UPDATE_DATE = '||
--                    TO_CHAR(p_enty_attr_val_rec.last_update_date));

Line: 883


			  FND_MESSAGE.set_token('COLUMN','last_update_date');

Line: 893


      IF p_enty_attr_val_rec.last_updated_by = FND_API.g_miss_num
         OR p_enty_attr_val_rec.last_updated_by IS NULL THEN
          IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
			  FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

Line: 897


			  FND_MESSAGE.set_token('COLUMN','last_updated_by');

Line: 929


      IF p_enty_attr_val_rec.last_update_login = FND_API.g_miss_num
         OR p_enty_attr_val_rec.last_update_login IS NULL THEN
          IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
			  FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

Line: 933


			  FND_MESSAGE.set_token('COLUMN','last_update_login');

Line: 1013


      IF p_enty_attr_val_rec.last_update_date IS NULL THEN
          IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
			  FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

Line: 1016


			  FND_MESSAGE.set_token('COLUMN','last_update_date');

Line: 1024


      IF p_enty_attr_val_rec.last_updated_by IS NULL THEN
          IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
			  FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

Line: 1027


			  FND_MESSAGE.set_token('COLUMN','last_updated_by');

Line: 1058


      IF p_enty_attr_val_rec.last_update_login IS NULL THEN
          IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
			  FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

Line: 1061


			  FND_MESSAGE.set_token('COLUMN','last_update_login');

Line: 1133


		SELECT 1
		FROM  PV_ATTRIBUTES_b
		WHERE attribute_id = cv_attribute_id
		      ;

Line: 1138


		SELECT 1
		FROM  PV_ENTITY_ATTRS
		WHERE attribute_id = cv_attribute_id and entity = cv_entity
		      ;

Line: 1279


      SELECT *
      FROM pv_enty_attr_values
      WHERE enty_attr_val_id = p_enty_attr_val_rec.enty_attr_val_id;

Line: 1297


   IF p_enty_attr_val_rec.last_update_date = FND_API.g_miss_date THEN
      x_complete_rec.last_update_date := l_pv_enty_attr_val_rec.last_update_date;

Line: 1302


   IF p_enty_attr_val_rec.last_updated_by = FND_API.g_miss_num THEN
      x_complete_rec.last_updated_by := l_pv_enty_attr_val_rec.last_updated_by;

Line: 1317


   IF p_enty_attr_val_rec.last_update_login = FND_API.g_miss_num THEN
      x_complete_rec.last_update_login := l_pv_enty_attr_val_rec.last_update_login;

Line: 1395


    ,p_validation_mode      IN   VARCHAR2 := JTF_PLSQL_API.G_UPDATE
    ,p_enty_attr_val_rec    IN   enty_attr_val_rec_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) := 'Validate_attr_value';

Line: 1539


    ,p_validation_mode            IN   VARCHAR2     := JTF_PLSQL_API.G_UPDATE
    )
IS
BEGIN
      -- Initialize message list if p_init_msg_list is set to TRUE.
      IF FND_API.to_Boolean( p_init_msg_list )
      THEN
         FND_MSG_PUB.initialize;