APPS.IGW_PROP_USERS_PVT SQL Statements

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

Line: 124

  igw_prop_users_tbh.insert_row (
    x_rowid		=>	x_rowid,
    p_proposal_id	=> 	l_proposal_id,
    p_user_id		=>	l_user_id,
    p_start_date_active	=>	p_start_date_active,
    p_end_date_active 	=>	p_end_date_active,
    p_mode 		=>	'R',
    x_return_status	=>	x_return_status);

Line: 179

Procedure update_prop_user (
  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_full_name			 IN	VARCHAR2
 ,p_start_date_active     	 IN	DATE
 ,p_end_date_active       	 IN	DATE
 ,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_msg_data                 VARCHAR2(250);

Line: 216

      SAVEPOINT update_user;

Line: 335

         	igw_prop_users_tbh.update_row (
    			x_rowid				=>	x_rowid,
    			p_proposal_id			=>	l_proposal_id2,
    			p_user_id			=>	l_user_id2,
    			p_start_date_active		=>	p_start_date_active,
    			p_end_date_active 		=>	p_end_date_active,
    			p_record_version_number		=>	p_record_version_number,
    			p_mode 				=>	'R',
    			x_return_status			=>	l_return_status);

Line: 347

                           update igw_prop_user_roles
                           set proposal_id = l_proposal_id2,
                               user_id = l_user_id2
                           where proposal_id = l_proposal_id
                           and user_id = l_user_id;

Line: 373

              ROLLBACK TO update_user;

Line: 383

              ROLLBACK TO update_user;

Line: 389

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

Line: 396

END  update_prop_user;

Line: 399

Procedure delete_prop_user (
  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_msg_data                 VARCHAR2(250);

Line: 425

       SAVEPOINT delete_user;

Line: 468

     igw_prop_users_tbh.delete_row (
    		x_rowid			=>	x_rowid,
    		p_record_version_number	=>	p_record_version_number,
    		x_return_status		=>	l_return_status);

Line: 473

   delete from igw_prop_user_roles
   where proposal_id = l_proposal_id
   and user_id = l_user_id;

Line: 494

              ROLLBACK TO delete_user;

Line: 504

              ROLLBACK TO delete_user;

Line: 510

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

Line: 517

END delete_prop_user;

Line: 530

select count(*) into N
from igw_prop_user_roles
where proposal_id = p_proposal_id
and   user_id     = p_user_id
and   role_id in (select role_id from igw_roles where seeded_flag = 'Y');

Line: 563

   select proposal_id, user_id, start_date_active, end_date_active
   into x_proposal_id, x_user_id, x_start_date_active, x_end_date_active
   from igw_prop_users
   where rowid = x_rowid
   and record_version_number = p_record_version_number;