APPS.ICX_USER_SEC_ATTR_PVT SQL Statements

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

Line: 23

   p_last_updated_by		IN	NUMBER,
   p_last_update_date		IN	DATE,
   p_last_update_login		IN	NUMBER
)
IS
l_api_name		CONSTANT VARCHAR2(30) := 'Create_User_Sec_Attr';

Line: 66

   select count(*)
     into l_duplicate
     from ak_web_user_sec_attr_values
    where web_user_id       = p_web_user_id
      and attribute_code    = p_attribute_code
      and attribute_application_id = p_attribute_appl_id
      and ((varchar2_value  = p_varchar2_value)
	  or (varchar2_value is null and p_varchar2_value is null))
      and ((date_value      = p_date_value)
	  or (date_value is null and p_date_value is null))
      and ((number_value    = p_number_value)
	  or (number_value is null and p_number_value is null));

Line: 90

      INSERT into AK_WEB_USER_SEC_ATTR_VALUES
      (
	 WEB_USER_ID			,
	 ATTRIBUTE_APPLICATION_ID	,
         ATTRIBUTE_CODE			,
	 VARCHAR2_VALUE			,
	 DATE_VALUE			,
	 NUMBER_VALUE			,
         CREATED_BY			,
         CREATION_DATE			,
         LAST_UPDATED_BY		,
         LAST_UPDATE_DATE		,
         LAST_UPDATE_LOGIN
      )
      values
      (
	 p_web_user_id			,
	 p_attribute_appl_id		,
         p_attribute_code		,
	 p_varchar2_value		,
	 p_date_value			,
	 p_number_value			,
         p_created_by			,
         p_creation_date		,
         p_last_updated_by		,
         p_last_update_date		,
         p_last_update_login
      );

Line: 125

         fnd_message.set_name('FND','SQL-NO INSERT');

Line: 197

PROCEDURE Delete_User_Sec_Attr
(  p_api_version_number		IN	NUMBER,
   p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE,
   p_simulate			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,
   p_return_status		OUT NOCOPY	VARCHAR2,
   p_msg_count			OUT NOCOPY	NUMBER,
   p_msg_data			OUT NOCOPY	VARCHAR2,
--   p_msg_entity			OUT	VARCHAR2,
--   p_msg_entity_index		OUT	NUMBER,
   p_web_user_id                IN      NUMBER,
   p_attribute_code             IN      VARCHAR2,
   p_attribute_appl_id          IN      NUMBER,
   p_varchar2_value             IN      VARCHAR2,
   p_date_value                 IN      DATE,
   p_number_value               IN      NUMBER

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

Line: 224

   SAVEPOINT Delete_User_Sec_Attr_PVT;

Line: 250

   Delete from AK_WEB_USER_SEC_ATTR_VALUES
    where web_user_id 	    = p_web_user_id
      and attribute_code    = p_attribute_code
      and attribute_application_id = p_attribute_appl_id
      and ((varchar2_value  = p_varchar2_value)
	  or (varchar2_value is null and p_varchar2_value is null))
      and ((date_value	    = p_date_value)
	  or (date_value is null and p_date_value is null))
      and ((number_value    = p_number_value)
	  or (number_value is null and p_number_value is null));

Line: 267

      fnd_message.set_name('FND','SQL-NO DELETE');

Line: 292

      Rollback to Delete_User_Sec_Attr_PVT;

Line: 303

      Rollback to Delete_User_Sec_Attr_PVT;

Line: 314

      Rollback to Delete_User_Sec_Attr_PVT;

Line: 333

end Delete_User_Sec_Attr;

Line: 346

   p_last_updated_by            IN      NUMBER,
   p_last_update_date           IN      DATE,
   p_last_update_login          IN      NUMBER,
   p_return_status              OUT NOCOPY     VARCHAR2,
   p_msg_count                  OUT NOCOPY     NUMBER,
   p_msg_data                   OUT NOCOPY     VARCHAR2
) is

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

Line: 372

        select  b.REGION_APPLICATION_ID,b.REGION_CODE,
                a.ATTRIBUTE_APPLICATION_ID,a.ATTRIBUTE_CODE
        from    AK_OBJECT_ATTRIBUTES c,
                AK_REGIONS b,
                AK_RESP_SECURITY_ATTRIBUTES a
        where   a.RESPONSIBILITY_ID = p_responsibility_id
        and     a.RESP_APPLICATION_ID = p_resp_application_id
        and     a.ATTRIBUTE_CODE = b.REGION_CODE
        and     b.DATABASE_OBJECT_NAME = c.DATABASE_OBJECT_NAME
        and     c.ATTRIBUTE_CODE = 'ICX_CUSTOMER_CONTACT_ID';

Line: 384

        select  b.REGION_APPLICATION_ID,b.REGION_CODE,
                a.ATTRIBUTE_APPLICATION_ID,a.ATTRIBUTE_CODE
        from    AK_OBJECT_ATTRIBUTES c,
                AK_REGIONS b,
                AK_RESP_SECURITY_ATTRIBUTES a
        where   a.RESPONSIBILITY_ID = p_responsibility_id
        and     a.RESP_APPLICATION_ID = p_resp_application_id
        and     a.ATTRIBUTE_CODE = b.REGION_CODE
        and     b.DATABASE_OBJECT_NAME = c.DATABASE_OBJECT_NAME
        and     c.ATTRIBUTE_CODE = 'ICX_INTERNAL_CONTACT_ID';

Line: 396

        select  b.REGION_APPLICATION_ID,b.REGION_CODE,
                a.ATTRIBUTE_APPLICATION_ID,a.ATTRIBUTE_CODE
        from    AK_OBJECT_ATTRIBUTES c,
                AK_REGIONS b,
                AK_RESP_SECURITY_ATTRIBUTES a
        where   a.RESPONSIBILITY_ID = p_responsibility_id
        and     a.RESP_APPLICATION_ID = p_resp_application_id
        and     a.ATTRIBUTE_CODE = b.REGION_CODE
        and     b.DATABASE_OBJECT_NAME = c.DATABASE_OBJECT_NAME
        and     c.ATTRIBUTE_CODE = 'ICX_SUPPLIER_CONTACT_ID';

Line: 441

select  CUSTOMER_ID,SUPPLIER_ID,EMPLOYEE_ID
into    l_customer_contact_id,l_vendor_contact_id,l_internal_contact_id
from    FND_USER
where   USER_ID = p_web_user_id;

Line: 459

select    DATA_TYPE
into      l_data_type
from      AK_ATTRIBUTES
where     ATTRIBUTE_CODE = s.ATTRIBUTE_CODE
and       ATTRIBUTE_APPLICATION_ID = s.ATTRIBUTE_APPLICATION_ID;

Line: 497

        p_last_updated_by       => p_last_updated_by,
        p_last_update_date      => p_last_update_date,
        p_last_update_login     => p_last_update_login);

Line: 519

select    DATA_TYPE
into      l_data_type
from      AK_ATTRIBUTES
where     ATTRIBUTE_CODE = s.ATTRIBUTE_CODE
and       ATTRIBUTE_APPLICATION_ID = s.ATTRIBUTE_APPLICATION_ID;

Line: 557

        p_last_updated_by       => p_last_updated_by,
        p_last_update_date      => p_last_update_date,
        p_last_update_login     => p_last_update_login);

Line: 579

select    DATA_TYPE
into      l_data_type
from      AK_ATTRIBUTES
where     ATTRIBUTE_CODE = s.ATTRIBUTE_CODE
and       ATTRIBUTE_APPLICATION_ID = s.ATTRIBUTE_APPLICATION_ID;

Line: 617

        p_last_updated_by       => p_last_updated_by,
        p_last_update_date      => p_last_update_date,
        p_last_update_login     => p_last_update_login);