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

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

Line: 50


       SELECT PV_ATTRIBUTE_CODES_S.NEXTVAL
       FROM dual;

Line: 54


       SELECT 1
       FROM PV_ATTRIBUTE_CODES_B
       WHERE ATTR_CODE_ID = l_id;

Line: 129


           l_attribute_code_rec.last_update_date      := SYSDATE;

Line: 130


           l_attribute_code_rec.last_updated_by       := G_USER_ID;

Line: 133


           l_attribute_code_rec.last_update_login     := G_LOGIN_ID;

Line: 162


       PV_ATTRIBUTE_CODE_PKG.Insert_Row(
           px_attr_code_id           => l_attribute_code_rec.attr_code_id,
           p_attr_code               => UPPER(l_attribute_code_rec.attr_code),
           p_last_update_date        => l_attribute_code_rec.last_update_date,
           p_last_updated_by         => l_attribute_code_rec.last_updated_by,
           p_creation_date           => l_attribute_code_rec.creation_date,
           p_created_by              => l_attribute_code_rec.created_by,
           p_last_update_login       => l_attribute_code_rec.last_update_login,
           px_object_version_number  => l_attribute_code_rec.object_version_number,
           p_attribute_id            => l_attribute_code_rec.attribute_id,
           p_enabled_flag            => l_attribute_code_rec.enabled_flag,
           --p_security_group_id  => p_attribute_code_rec.security_group_id
           p_description             => l_attribute_code_rec.description
           );

Line: 247


 PROCEDURE Update_Attribute_Code(
     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_attribute_code_rec         IN   attribute_code_rec_type
    ,x_object_version_number      OUT NOCOPY  NUMBER
    )
  IS

 CURSOR c_get_attribute_code(cv_ATTR_CODE_ID NUMBER) IS
     SELECT *
     FROM  PV_ATTRIBUTE_CODES_B
     WHERE ATTR_CODE_ID = cv_ATTR_CODE_ID;

Line: 267


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

Line: 279


   l_delete_flag	    VARCHAR2(1):='Y';

Line: 282


 select  distinct seleted.attribute_value,rules.process_rule_name
   from pv_enty_select_criteria criteria,pv_selected_attr_values seleted,
        pv_process_rules_vl rules,pv_attribute_codes_vl code
   where code.attr_code_id= pc_attr_code_id and
         criteria.attribute_id= code.attribute_id and
         criteria.selection_criteria_id= seleted.selection_criteria_id and
         criteria.process_rule_id= rules.process_rule_id and
         seleted.attribute_value=code.attr_code;

Line: 292


	select pp.program_id, pp.program_name, ppt.partner_type
	from pv_partner_program_vl pp, pv_partner_program_type_b pt,
	pv_program_partner_types ppt, pv_attribute_codes_vl code
	where
	pp.program_type_id = ppt.program_type_id
	and pp.PROGRAM_STATUS_CODE NOT IN ('CANCEL', 'CLOSED','ARCHIVE')
	and pp.program_type_id = pt.program_type_id
	and pt.enabled_flag = 'Y'
	and ppt.partner_type = code.attr_code
	and code.attr_code_id= pc_attr_code_id
        and code.attribute_id = 3;

Line: 307


   select distinct entity
   from pv_enty_attr_values entyval, pv_attribute_codes_vl code
   where code.attr_code_id= pc_attr_code_id and
         code.attribute_id = entyval.attribute_id and
	 code.attr_code=entyval.attr_value and
	 entyval.latest_flag = 'Y' ;

Line: 318


       SAVEPOINT UPDATE_Attribute_Code_PVT;

Line: 346


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

Line: 357


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

Line: 387


        l_delete_flag := 'N' ;

Line: 392


       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_ATTRCODE_NOTDISABLED_RULE');

Line: 414


		l_delete_flag := 'N' ;

Line: 419


	       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_ATTRCODE_NOTDISABLED_PROGR');

Line: 440


		l_delete_flag := 'N';

Line: 450


	      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_ATTRCODE_NOTDISABLED_ENTITY');

Line: 472


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

Line: 499


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

Line: 515


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

Line: 519


       PV_ATTRIBUTE_CODE_PKG.Update_Row(
           p_attr_code_id           => p_attribute_code_rec.attr_code_id,
           p_attr_code              => p_attribute_code_rec.attr_code,
           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_attribute_code_rec.object_version_number,
           p_attribute_id           => p_attribute_code_rec.attribute_id,
           p_enabled_flag           => p_attribute_code_rec.enabled_flag,
           --p_security_group_id  => p_attribute_code_rec.security_group_id
           p_description            => p_attribute_code_rec.description
           );

Line: 564


      ROLLBACK TO UPDATE_Attribute_Code_PVT;

Line: 574


      ROLLBACK TO UPDATE_Attribute_Code_PVT;

Line: 584


      ROLLBACK TO UPDATE_Attribute_Code_PVT;

Line: 596


 End Update_Attribute_Code;

Line: 599


 PROCEDURE Delete_Attribute_Code(
     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_attr_code_id               IN   NUMBER
    ,p_object_version_number      IN   NUMBER
    )

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

Line: 620


 l_delete_flag	             VARCHAR2(1):='Y';

Line: 625


   select code.attr_code
   from pv_attribute_codes_vl code
   where code.attr_code_id= pc_attr_code_id ;

Line: 630


   select attr.attribute_id,attr.name
   from pv_attributes_vl attr,pv_attribute_codes_vl code
   where code.attr_code_id= pc_attr_code_id and code.attribute_id = attr.attribute_id;

Line: 635


   select distinct entity
   from pv_enty_attr_values entyval, pv_attribute_codes_vl code
   where code.attr_code_id= pc_attr_code_id and
         code.attribute_id = entyval.attribute_id and
	 code.attr_code=entyval.attr_value;

Line: 643


 select  distinct seleted.attribute_value,rules.process_rule_name
   from pv_enty_select_criteria criteria,pv_selected_attr_values seleted,
        pv_process_rules_vl rules,pv_attribute_codes_vl code
   where code.attr_code_id= pc_attr_code_id and
         criteria.attribute_id= code.attribute_id and
         criteria.selection_criteria_id= seleted.selection_criteria_id and
         criteria.process_rule_id= rules.process_rule_id and
         seleted.attribute_value=code.attr_code;

Line: 653


   select  distinct usage.attribute_usage_code
   from pv_attribute_usages usage, pv_attribute_codes_vl code
   where code.attr_code_id=pc_attr_code_id  and
         code.attr_code=usage.attribute_usage_code;

Line: 660


       SAVEPOINT DELETE_Attribute_Code_PVT;

Line: 722


              FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDELETE_SEEDED');

Line: 735


			l_delete_flag := 'N';

Line: 738


		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_ATTRCODE_VADOF_RESELLERS');

Line: 753


			l_delete_flag := 'N';

Line: 758


		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_ATTRCODE_REFERENCED_USAGE');

Line: 777


        l_delete_flag := 'N';

Line: 778


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

Line: 797


      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_ATTRCODE_REFERENCED_ENTITY');

Line: 814


        l_delete_flag := 'N' ;

Line: 819


       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_ATTR_REFERENCED_RULE');

Line: 835


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

Line: 840


       PV_ATTRIBUTE_CODE_PKG.Delete_Row(
           p_ATTR_CODE_ID  => p_ATTR_CODE_ID);

Line: 874


      ROLLBACK TO DELETE_Attribute_Code_PVT;

Line: 884


      ROLLBACK TO DELETE_Attribute_Code_PVT;

Line: 894


      ROLLBACK TO DELETE_Attribute_Code_PVT;

Line: 906


 End Delete_Attribute_Code;

Line: 930


    SELECT ATTR_CODE_ID
    FROM PV_ATTRIBUTE_CODES_B
    WHERE ATTR_CODE_ID = p_ATTR_CODE_ID
    AND object_version_number = p_object_version
    FOR UPDATE NOWAIT;

Line: 1041


   select  attr_code from pv_attribute_codes_b
   where attribute_id = pc_attribute_id;

Line: 1128


            IF p_attribute_code_rec.last_update_date = FND_API.G_MISS_DATE
            OR p_attribute_code_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: 1132


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

Line: 1139


            IF p_attribute_code_rec.last_updated_by = FND_API.G_MISS_NUM
            OR p_attribute_code_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: 1143


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

Line: 1172


            IF p_attribute_code_rec.last_update_login = FND_API.G_MISS_NUM
            OR p_attribute_code_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: 1176


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

Line: 1250


            IF p_attribute_code_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: 1253


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

Line: 1260


            IF p_attribute_code_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: 1263


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

Line: 1290


            IF p_attribute_code_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: 1293


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

Line: 1430


       SELECT *
       FROM pv_attribute_codes_b
       WHERE attr_code_id = p_attribute_code_rec.attr_code_id;

Line: 1453


    IF p_attribute_code_rec.last_update_date = FND_API.g_miss_date THEN
       x_complete_rec.last_update_date := l_attribute_code_rec.last_update_date;

Line: 1458


    IF p_attribute_code_rec.last_updated_by = FND_API.g_miss_num THEN
       x_complete_rec.last_updated_by := l_attribute_code_rec.last_updated_by;

Line: 1473


    IF p_attribute_code_rec.last_update_login = FND_API.g_miss_num THEN
       x_complete_rec.last_update_login := l_attribute_code_rec.last_update_login;

Line: 1510


    ,p_validation_mode            IN   VARCHAR2     := JTF_PLSQL_API.G_UPDATE
    ,p_attribute_code_rec         IN   attribute_code_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_Attribute_Code';

Line: 1648


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