APPS.IGW_PROP_PERSON_DEGREES_PVT SQL Statements

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

Line: 5

Procedure update_prop_person_degrees (
 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_PERSON_DEGREE_ID       	  IN		NUMBER,
 P_SHOW_FLAG 		     	  IN            VARCHAR2,
 P_DEGREE_SEQUENCE	     	  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_return_status            VARCHAR2(1);

Line: 30

        SAVEPOINT update_prop_person_degrees;

Line: 64

                        igw_prop_person_degrees_tbh.update_row (
                                    	 x_rowid			 =>	x_rowid
              				,P_PROPOSAL_ID       		 =>	P_PROPOSAL_ID
 					,P_PERSON_DEGREE_ID         	 =>	P_PERSON_DEGREE_ID
 					,P_SHOW_FLAG      		 =>	P_SHOW_FLAG
 					,P_DEGREE_SEQUENCE     		 =>	P_DEGREE_SEQUENCE
              				,p_mode 			 =>	'R'
              				,p_record_version_number	 =>	p_record_version_number
              				,x_return_status		 =>	x_return_status);

Line: 92

              ROLLBACK TO update_prop_person_degrees;

Line: 103

              ROLLBACK TO update_prop_person_degrees;

Line: 109

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

Line: 116

END  update_prop_person_degrees;

Line: 126

   select proposal_id
   into l_proposal_id
   from igw_prop_person_degrees
   where rowid = x_rowid
   and record_version_number = p_record_version_number;

Line: 207

    select person_degree_id,
           degree_sequence,
           last_update_date,
           last_updated_by,
           creation_date,
           created_by,
           last_update_login
    from igw_person_degrees
    where (party_id = p_party_id) AND
          (person_degree_id not in
    (select person_degree_id from igw_prop_person_degrees
     where proposal_id = p_proposal_id));

Line: 222

    select person_biosketch_id,
           line_sequence,
           last_update_date,
           last_updated_by,
           creation_date,
           created_by,
           last_update_login
    from igw_person_biosketch
    where (party_id = p_party_id) AND
          (enable_flag = 'Y') AND
          (person_biosketch_id not in
     (select person_biosketch_id from igw_prop_person_biosketch
      where proposal_id =  p_proposal_id));

Line: 254

   delete from igw_prop_person_degrees
   where (proposal_id = p_proposal_id) AND
   person_degree_id not in
        (select person_degree_id from igw_person_degrees);

Line: 262

   delete from igw_prop_person_biosketch
   where (proposal_id = p_proposal_id) AND
   person_biosketch_id not in
        (select person_biosketch_id from igw_person_biosketch where enable_flag = 'Y');

Line: 273

	  	 degrees.last_update_date,
                 degrees.last_updated_by,
                 degrees.creation_date,
                 degrees.created_by,
                 degrees.last_update_login;

Line: 280

          insert into igw_prop_person_degrees (
		 proposal_id,
                 person_degree_id,
                 degree_sequence,
                 show_flag,
                 last_update_date,
                 last_updated_by,
                 creation_date,
                 created_by,
                 last_update_login,
                 record_version_number)

          values (
		 p_proposal_id,
                 degrees.person_degree_id,
                 degrees.degree_sequence,
                 'Y',
	  	 degrees.last_update_date,
                 degrees.last_updated_by,
                 degrees.creation_date,
                 degrees.created_by,
                 degrees.last_update_login,
                 1);

Line: 306

	  	 degrees.last_update_date,
                 degrees.last_updated_by,
                 degrees.creation_date,
                 degrees.created_by,
                 degrees.last_update_login;

Line: 321

	  	 bio.last_update_date,
                 bio.last_updated_by,
                 bio.creation_date,
                 bio.created_by,
                 bio.last_update_login;

Line: 328

          insert into igw_prop_person_biosketch (
		 proposal_id,
                 person_biosketch_id,
                 line_sequence,
                 show_flag,
                 last_update_date,
                 last_updated_by,
                 creation_date,
                 created_by,
                 last_update_login,
                 record_version_number)

          values (
		 p_proposal_id,
                 bio.person_biosketch_id,
                 bio.line_sequence,
                 'Y',
	  	 bio.last_update_date,
                 bio.last_updated_by,
                 bio.creation_date,
                 bio.created_by,
                 bio.last_update_login,
                 1);

Line: 354

	  	 bio.last_update_date,
                 bio.last_updated_by,
                 bio.creation_date,
                 bio.created_by,
                 bio.last_update_login;