APPS.IGW_PROP_USER_ROLES_PVT SQL Statements

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

Line: 104

         igw_prop_user_roles_tbh.insert_row(
          	x_rowid			=>	x_rowid,
          	p_proposal_id		=>	l_proposal_id,
    		p_user_id		=>	l_user_id,
    		p_role_id		=>	l_role_id,
    		p_mode			=>      'R',
    		x_return_status		=>	x_return_status);

Line: 156

Procedure update_prop_user_role (
  p_init_msg_list                IN 	VARCHAR2   := FND_API.G_FALSE
 ,p_commit                       IN 	VARCHAR2   := FND_API.G_FALSE
 ,p_validate_only                IN 	VARCHAR2   := FND_API.G_FALSE
 ,x_rowid 		         IN 	VARCHAR2
 ,p_proposal_id			 IN 	NUMBER
 ,p_proposal_number		 IN	VARCHAR2
 ,p_user_id               	 IN 	NUMBER
 ,p_user_name			 IN	VARCHAR2
 ,p_role_id               	 IN 	NUMBER
 ,p_role_name 			 IN	VARCHAR2
 ,p_logged_user_id		 IN     NUMBER
 ,p_record_version_number        IN 	NUMBER
 ,x_return_status                OUT NOCOPY 	VARCHAR2
 ,x_msg_count                    OUT NOCOPY 	NUMBER
 ,x_msg_data                     OUT NOCOPY 	VARCHAR2)  is


  l_proposal_id              NUMBER;

Line: 193

        SAVEPOINT update_user_role;

Line: 284

                        igw_prop_user_roles_tbh.update_row (
                                    	x_rowid			=>	x_rowid,
              				p_proposal_id		=>	l_proposal_id2,
              				p_user_id		=>	l_user_id2,
              				p_role_id		=>	l_role_id2,
              				p_mode 			=>	'R',
              				p_record_version_number	=>	p_record_version_number,
              				x_return_status		=>	x_return_status);

Line: 311

              ROLLBACK TO update_user_role;

Line: 322

              ROLLBACK TO update_user_role;

Line: 328

                            p_procedure_name    =>    'UPDATE_USER_ROLE',
                            p_error_text        =>     SUBSTRB(SQLERRM,1,240));

Line: 335

END  update_prop_user_role;

Line: 338

Procedure delete_prop_user_role (
  p_init_msg_list                IN   		VARCHAR2   := FND_API.G_FALSE
 ,p_commit                       IN   		VARCHAR2   := FND_API.G_FALSE
 ,p_validate_only                IN   		VARCHAR2   := FND_API.G_FALSE
 ,x_rowid 			 IN 		VARCHAR2
 ,p_logged_user_id		 IN     	NUMBER
 ,p_record_version_number        IN   		NUMBER
 ,x_return_status                OUT NOCOPY  		VARCHAR2
 ,x_msg_count                    OUT NOCOPY  		NUMBER
 ,x_msg_data                     OUT NOCOPY  		VARCHAR2)  is

  l_proposal_id              NUMBER;

Line: 366

       SAVEPOINT delete_user_role;

Line: 411

     igw_prop_user_roles_tbh.delete_row(
      	     x_rowid			=>	x_rowid,
	     p_record_version_number	=>	p_record_version_number,
             x_return_status		=>	x_return_status);

Line: 434

              ROLLBACK TO delete_user_role;

Line: 445

              ROLLBACK TO delete_user_role;

Line: 451

                            p_procedure_name    =>    'DELETE_USER_ROLE',
                            p_error_text        =>     SUBSTRB(SQLERRM,1,240));

Line: 457

END delete_prop_user_role;

Line: 471

    select x into y
    from igw_prop_user_roles  ppr,
         igw_prop_users  ppu
    where ppr.proposal_id = p_proposal_id  	AND
         ppr.proposal_id = ppu.proposal_id      AND
         ppr.user_id = ppu.user_id   		AND
         ppr.role_id in (0,2,3)		        AND
         ppr.user_id = p_logged_user_id		AND
         sysdate >= ppu.start_date_active  	AND
         sysdate <= nvl(ppu.end_date_active, sysdate);

Line: 510

   select proposal_id, user_id, role_id
   into x_proposal_id, x_user_id, x_role_id
   from igw_prop_user_roles
   where rowid = x_rowid
   and record_version_number = p_record_version_number;

Line: 542

   	SELECT role_id
   	INTO x_role_id
   	FROM igw_roles_tl
   	WHERE upper(role_name) = upper(p_role_name)
   	and   language = userenv('LANG');

Line: 578

select count(*) into N
from igw_roles
where role_id = p_role_id AND
      seeded_flag = 'Y';