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_ENTITY_ATTRIBUTE_PVT SQL Statements

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

Line: 57


      SELECT PV_ENTITY_ATTRS_s.NEXTVAL
      FROM dual;

Line: 61


      SELECT 1
      FROM PV_ENTITY_ATTRS
      WHERE ENTITY_ATTR_ID = l_id;

Line: 66


	SELECT attribute_type, display_style
	from pv_attributes_vl
	where attribute_id=cv_attribute_id
	;

Line: 120


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

Line: 128


			  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: 136


			  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: 221


           l_entity_attr_rec.last_update_date      := SYSDATE;

Line: 222


           l_entity_attr_rec.last_updated_by       := G_USER_ID;

Line: 225


           l_entity_attr_rec.last_update_login     := G_LOGIN_ID;

Line: 278


      Pv_Entity_Attrs_Pkg.Insert_Row(
           px_entity_attr_id         => l_entity_attr_rec.entity_attr_id
          ,px_object_version_number  => l_object_version_number
	  ,p_batch_sql_text          => l_entity_attr_rec.batch_sql_text
	  ,p_refresh_frequency       => l_entity_attr_rec.refresh_frequency
	  ,p_refresh_frequency_uom   => l_entity_attr_rec.refresh_frequency_uom
	  ,p_last_refresh_date       => l_entity_attr_rec.last_refresh_date
	  ,p_display_external_value_flag   => l_entity_attr_rec.display_external_value_flag
          ,p_lov_string              =>  l_lov_string  --replace(l_lov_string,':1','?')
          ,p_enabled_flag            => l_entity_attr_rec.enabled_flag
	  ,p_display_flag            => l_entity_attr_rec.display_flag
          ,p_locator_flag            => l_entity_attr_rec.locator_flag
          ,p_entity_type	     => l_entity_attr_rec.entity_type
          ,p_require_validation_flag => l_entity_attr_rec.require_validation_flag
 	  ,p_external_update_text    => l_entity_attr_rec.external_update_text
          ,p_attribute_id            => l_entity_attr_rec.attribute_id
          ,p_entity                  => l_entity_attr_rec.entity
          ,p_sql_text                => l_entity_attr_rec.sql_text
          ,p_attr_data_type          => l_entity_attr_rec.attr_data_type
          ,p_creation_date           => l_entity_attr_rec.creation_date
          ,p_created_by              => l_entity_attr_rec.created_by
	  ,p_last_updated_by         => l_entity_attr_rec.last_updated_by
          ,p_last_update_date        => l_entity_attr_rec.last_update_date
          ,p_last_update_login       => l_entity_attr_rec.last_update_login);

Line: 368


PROCEDURE Update_Entity_Attr(
     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_entity_attr_rec         IN   entity_attr_rec_type
    ,x_object_version_number      OUT NOCOPY  NUMBER
    )
 IS

CURSOR c_get_entity_attribute(cv_entity_attr_id NUMBER) IS
    SELECT *
    FROM  PV_ENTITY_ATTRS
    WHERE ENTITY_ATTR_ID = cv_entity_attr_id;

Line: 389


	SELECT attribute_type,display_style
	from pv_attributes_vl
	where attribute_id=cv_attribute_id
	;

Line: 395


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

Line: 412


      SAVEPOINT Update_Entity_Attr_PVT;

Line: 437


	  Pvx_Utility_Pvt.debug_message('Private API: - Open Cursor to Select');

Line: 445


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

Line: 522


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

Line: 551


            ,p_validation_mode     => Jtf_Plsql_Api.g_update
            ,p_entity_attr_rec  =>  p_entity_attr_rec
            ,x_return_status       => x_return_status
            ,x_msg_count           => x_msg_count
            ,x_msg_data            => x_msg_data);

Line: 562


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

Line: 569


      Pv_Entity_Attrs_Pkg.Update_Row(
           p_entity_attr_id         => p_entity_attr_rec.entity_attr_id
          ,p_last_update_date       => SYSDATE
          ,p_last_updated_by        => G_USER_ID
          ,p_last_update_login      => G_LOGIN_ID
          ,p_object_version_number  => p_entity_attr_rec.object_version_number
          ,p_attribute_id           => p_entity_attr_rec.attribute_id
          ,p_entity                 => p_entity_attr_rec.entity
	  ,p_entity_type            => p_entity_attr_rec.entity_type
          ,p_sql_text               => p_entity_attr_rec.sql_text
          ,p_attr_data_type         => p_entity_attr_rec.attr_data_type
          ,p_lov_string             => l_lov_string --replace(l_lov_string,':1','?') --replacing :1 with ? as we are storing java bindings
          ,p_enabled_flag           => p_entity_attr_rec.enabled_flag
          ,p_display_flag           => p_entity_attr_rec.display_flag
          ,p_locator_flag           => p_entity_attr_rec.locator_flag
	  ,p_require_validation_flag=> p_entity_attr_rec.require_validation_flag
	  ,p_external_update_text          => p_entity_attr_rec.external_update_text
	  ,p_refresh_frequency          => p_entity_attr_rec.refresh_frequency
	  ,p_refresh_frequency_uom          => p_entity_attr_rec.refresh_frequency_uom
	  ,p_batch_sql_text          => p_entity_attr_rec.batch_sql_text
	  ,p_last_refresh_date          => p_entity_attr_rec.last_refresh_date
	  ,p_display_external_value_flag   => p_entity_attr_rec.display_external_value_flag


          );

Line: 620


     ROLLBACK TO Update_Entity_Attr_PVT;

Line: 629


     ROLLBACK TO Update_Entity_Attr_PVT;

Line: 638


     ROLLBACK TO Update_Entity_Attr_PVT;

Line: 650


END Update_Entity_Attr;

Line: 682


	select meaning from pv_lookups
	where lookup_type = 'PV_ATTRIBUTE_ENTITY_TYPE'
	and lookup_code= cv_lookup_code
	;

Line: 1150


PROCEDURE Delete_Entity_Attr(
     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_entity_attr_id                   IN  NUMBER
    ,p_object_version_number      IN   NUMBER
    )
 IS
l_api_name                  CONSTANT VARCHAR2(30) := 'Delete_Entity_Attr';

Line: 1166


l_delete_flag	            VARCHAR2(1):='Y';

Line: 1173


	select attr.name, enty.entity
	from   pv_attributes_vl attr, pv_entity_attrs enty
	where  enty.entity_attr_id=pc_entity_attr_id and
		   enty.attribute_id=attr.attribute_id
		   ;

Line: 1180


	select	prg.program_name
	from	pv_partner_program_vl prg, pv_ge_qsnr_elements_b qsnr
	where	qsnr.used_by_entity_id = prg.program_id and
			entity_attr_id = pc_entity_attr_id
			;

Line: 1186


   select distinct val.entity
   from pv_enty_attr_values val, pv_entity_attrs enty
   where enty.entity_attr_id =pc_entity_attr_id and
		 enty.attribute_id = val.attribute_id and
		 enty.entity = val.entity
		 ;

Line: 1195


      SAVEPOINT Delete_Entity_Attr_PVT;

Line: 1231


        l_delete_flag := 'N' ;

Line: 1236


      if(l_delete_flag = 'N') then

		IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
	      THEN
              FND_MESSAGE.Set_Name('PV', 'PV_ENTITYATTR_REF_VALUE');

Line: 1255


        l_delete_flag := 'N' ;

Line: 1260


      if(l_delete_flag = 'N') then

		IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
	      THEN
              FND_MESSAGE.Set_Name('PV', 'PV_ENTITYATTR_REF_PROGRAM');

Line: 1280


	  Pvx_Utility_Pvt.debug_message( 'Private API: Calling delete table handler');

Line: 1283


      Pv_Entity_Attrs_Pkg.Delete_Row(
          p_ENTITY_ATTR_ID  => p_ENTITY_ATTR_ID);

Line: 1309


     ROLLBACK TO Delete_Entity_Attr_PVT;

Line: 1318


     ROLLBACK TO Delete_Entity_Attr_PVT;

Line: 1327


     ROLLBACK TO Delete_Entity_Attr_PVT;

Line: 1339


END Delete_Entity_Attr;

Line: 1357


   SELECT ENTITY_ATTR_ID
   FROM PV_ENTITY_ATTRS
   WHERE ENTITY_ATTR_ID = p_ENTITY_ATTR_ID
   AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 1505


      IF p_entity_attr_rec.last_update_date = Fnd_Api.g_miss_date OR p_entity_attr_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: 1508


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

Line: 1514


      IF p_entity_attr_rec.last_updated_by = Fnd_Api.g_miss_num OR p_entity_attr_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: 1517


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

Line: 1541


      IF p_entity_attr_rec.last_update_login = Fnd_Api.g_miss_num OR
         p_entity_attr_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: 1545


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

Line: 1620


      IF p_entity_attr_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: 1623


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

Line: 1629


      IF p_entity_attr_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: 1632


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

Line: 1656


      IF p_entity_attr_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: 1659


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

Line: 1819


      SELECT *
      FROM pv_entity_attrs
      WHERE entity_attr_id = p_entity_attr_rec.entity_attr_id;

Line: 1833


   IF p_entity_attr_rec.last_update_date = Fnd_Api.g_miss_date THEN
      x_complete_rec.last_update_date := l_entity_attr_rec.last_update_date;

Line: 1837


   IF p_entity_attr_rec.last_updated_by = Fnd_Api.g_miss_num THEN
      x_complete_rec.last_updated_by := l_entity_attr_rec.last_updated_by;

Line: 1849


   IF p_entity_attr_rec.last_update_login = Fnd_Api.g_miss_num THEN
      x_complete_rec.last_update_login := l_entity_attr_rec.last_update_login;

Line: 1895


   IF p_entity_attr_rec.selection_type = Fnd_Api.g_miss_char THEN
      x_complete_rec.selection_type := l_entity_attr_rec.selection_type;

Line: 1925


	 -- external_update_text
   IF p_entity_attr_rec.external_update_text = Fnd_Api.g_miss_char THEN
      x_complete_rec.external_update_text := l_entity_attr_rec.external_update_text;

Line: 1965


    ,p_validation_mode            IN   VARCHAR2     := Jtf_Plsql_Api.G_UPDATE
    ,p_entity_attr_rec         IN   entity_attr_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_Entity_Attr';

Line: 2098


    ,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;