APPS.IGW_PROP_PERSON_SUPPORT_PVT SQL Statements

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

Line: 93

Procedure update_prop_person_support (
 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,
 p_get_data     		  IN            VARCHAR2,
 x_rowid 		          IN 		VARCHAR2,
 P_PROP_PERSON_SUPPORT_ID	  IN            NUMBER,
 P_PROPOSAL_ID                    IN		NUMBER,
 P_PERSON_ID                      IN		NUMBER,
 P_PARTY_ID                       IN		NUMBER,
 P_SUPPORT_TYPE                   IN		VARCHAR2,
 P_PROPOSAL_AWARD_ID              IN		NUMBER,
 P_PROPOSAL_AWARD_NUMBER          IN	 	VARCHAR2,
 P_PROPOSAL_AWARD_TITLE           IN 	 	VARCHAR2,
 P_PI_PERSON_ID                   IN		NUMBER,
 P_PI_PARTY_ID                    IN		NUMBER,
 P_PI_PERSON_NAME		  IN		VARCHAR2,
 P_SPONSOR_ID                     IN		NUMBER,
 P_SPONSOR_NAME		 	  IN		VARCHAR2,
 P_PROJECT_LOCATION               IN		VARCHAR2,
 P_LOCATION_PARTY_ID              IN		NUMBER,
 P_PROJECT_LOCATION_NAME	  IN		VARCHAR2,
 P_START_DATE                     IN		DATE,
 P_END_DATE                       IN		DATE,
 P_PERCENT_EFFORT                 IN		NUMBER,
 P_MAJOR_GOALS                    IN		VARCHAR2,
 P_OVERLAP                        IN		VARCHAR2,
 P_ANNUAL_DIRECT_COST             IN		NUMBER,
 P_TOTAL_COST                     IN		NUMBER,
 P_CALENDAR_START_DATE            IN		DATE,
 P_CALENDAR_END_DATE              IN		DATE,
 P_ACADEMIC_START_DATE            IN		DATE,
 P_ACADEMIC_END_DATE              IN		DATE,
 P_SUMMER_START_DATE              IN		DATE,
 P_SUMMER_END_DATE                IN		DATE,
 P_ATTRIBUTE_CATEGORY             IN		VARCHAR2,
 P_ATTRIBUTE1                     IN		VARCHAR2,
 P_ATTRIBUTE2                     IN		VARCHAR2,
 P_ATTRIBUTE3                     IN		VARCHAR2,
 P_ATTRIBUTE4                     IN		VARCHAR2,
 P_ATTRIBUTE5                     IN		VARCHAR2,
 P_ATTRIBUTE6                     IN		VARCHAR2,
 P_ATTRIBUTE7                     IN		VARCHAR2,
 P_ATTRIBUTE8                     IN		VARCHAR2,
 P_ATTRIBUTE9                     IN		VARCHAR2,
 P_ATTRIBUTE10                    IN		VARCHAR2,
 P_ATTRIBUTE11                    IN		VARCHAR2,
 P_ATTRIBUTE12                    IN		VARCHAR2,
 P_ATTRIBUTE13                    IN		VARCHAR2,
 P_ATTRIBUTE14                    IN		VARCHAR2,
 P_ATTRIBUTE15                    IN		VARCHAR2,
 p_record_version_number          IN 		NUMBER,
 P_SEQUENCE_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: 176

END  update_prop_person_support;

Line: 179

Procedure delete_prop_person_support (
  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_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: 202

END delete_prop_person_support;

Line: 246

           select ipp.person_id,
                  ipp.person_party_id,
                  ipp.percent_effort,
                  ipv.proposal_id,
		  ipv.proposal_number,
                  ipv.proposal_title,
		  ipv.proposal_start_date,
                  ipv.proposal_end_date,
		  ipv.sponsor_id,
		  ipv.pi_id,
                  ipv.major_goals,
                  ipv.total_cost,
		  ipv.annual_direct_cost,
                  ipv.project_location_id
            from  igw_prop_persons    ipp,
		  igw_prop_v   ipv
           where  ipp.person_party_id = p_party_id AND
                  ipv.proposal_id = ipp.proposal_id AND
		  ipv.proposal_id <> p_proposal_id   AND
		  ipv.sponsor_action_code in ('8', '4', '5') AND
                  ipv.proposal_type_code <> 3;

Line: 270

           select gp.person_id,
		  pa.award_id,
		  pa.funding_source_award_number,
                  pa.award_full_name,
                  pa.major_goals,
		  pa.funding_source_id,
		  pa.start_date_active,
                  pa.end_date_active,
                  pa.proposal_id
            from  gms_personnel        gp,
		  igw_awards_v        pa
           where  gp.person_id = p_person_id           AND
                  gp.award_id = pa.award_id            AND
		  pa.status = 'ACTIVE'                 AND
		  ((pa.proposal_id <> p_proposal_id)  OR (pa.proposal_id is NULL));

Line: 288

           select gp.person_id,
		  pa.award_id,
		  pa.funding_source_award_number,
                  pa.award_full_name,
                  pa.major_goals,
		  pa.funding_source_id,
		  pa.start_date_active,
                  pa.end_date_active,
                  pa.proposal_id
            from  gms_personnel        gp,
		  igw_awards_v        pa
           where  gp.person_id = p_person_id           AND
                  gp.award_id = pa.award_id           		  AND
		  pa.close_date > x_date_minus_three_yrs	  AND
                  pa.close_date < x_date			  AND
                  pa.close_date is not null   			  AND
		  pa.status = 'CLOSED'               		  AND
		  ((pa.proposal_id <> p_proposal_id)  OR (pa.proposal_id is NULL));