APPS.IGS_AD_EXTRACURR_ACT_PKG SQL Statements

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

Line: 3

  PROCEDURE insert_row (
    x_rowid                             IN OUT NOCOPY VARCHAR2,
    x_person_interest_id                OUT NOCOPY     NUMBER,
    x_person_id                         IN     NUMBER,
    x_interest_type_code                IN     VARCHAR2,
    x_comments                          IN     VARCHAR2,
    x_start_date                        IN     DATE,
    x_end_date                          IN     DATE,
    x_hours_per_week                    IN     NUMBER,
    x_weeks_per_year                    IN     NUMBER,
    x_level_of_interest                 IN     VARCHAR2,
    x_level_of_participation            IN     VARCHAR2,
    x_sport_indicator                   IN     VARCHAR2,
    x_sub_interest_type_code            IN     VARCHAR2,
    x_interest_name                     IN     VARCHAR2,
    x_team                              IN     VARCHAR2,
    x_wh_update_date                    IN     DATE,
    x_activity_source_cd                IN     VARCHAR2 DEFAULT NULL,
    x_last_update_date                  OUT NOCOPY    DATE,
    x_msg_Data                          OUT NOCOPY    VARCHAR2,
    x_return_Status                     OUT NOCOPY    VARCHAR2,
    x_object_version_number             IN OUT NOCOPY NUMBER,
    x_mode                              IN     VARCHAR2 DEFAULT 'R'
  ) AS
          p_per_interest_rec Hz_Person_Info_V2Pub.person_interest_rec_type;

Line: 37

         CURSOR c_birth_date_val is SELECT date_of_birth FROM HZ_PERSON_PROFILES
         WHERE party_id = x_person_id AND effective_end_Date is null;

Line: 162

          Igs_Ad_Hz_Extracurr_Act_Pkg.Insert_Row(
                        x_rowid  => l_rowId,
                        x_hz_extracurr_act_id => l_hz_extracurr_act_id,
                        x_person_interest_id  => x_person_interest_id,
                        x_end_date => x_End_Date,
                        x_hours_per_week => x_Hours_per_Week,
                        x_weeks_per_year => x_Weeks_Per_Year,
                        x_activity_source_cd => x_activity_source_cd,
                        x_mode => 'R') ;

Line: 174

  END insert_row;

Line: 177

  PROCEDURE update_row (
    x_rowid                             IN     VARCHAR2,
    x_person_interest_id                IN     NUMBER,
    x_person_id                         IN     NUMBER,
    x_interest_type_code                IN     VARCHAR2,
    x_comments                          IN     VARCHAR2,
    x_start_date                        IN     DATE,
    x_end_date                          IN     DATE,
    x_hours_per_week                    IN     NUMBER,
    x_weeks_per_year                    IN     NUMBER,
    x_level_of_interest                 IN     VARCHAR2,
    x_level_of_participation            IN     VARCHAR2,
    x_sport_indicator                   IN     VARCHAR2,
    x_sub_interest_type_code            IN     VARCHAR2,
    x_interest_name                     IN     VARCHAR2,
    x_team                              IN     VARCHAR2,
    x_wh_update_date                    IN     DATE,
    x_activity_source_cd                IN     VARCHAR2 DEFAULT NULL,
    x_last_update_date                  IN OUT NOCOPY DATE,
    x_msg_Data                            OUT NOCOPY    VARCHAR2,
    x_return_Status                        OUT NOCOPY    VARCHAR2,
    x_object_version_number             IN OUT NOCOPY NUMBER,
    x_mode                              IN     VARCHAR2 DEFAULT 'R'
  ) AS
  /*
  ||  Created By : [email protected]
  ||  Created On : 07-SEP-2000
  ||  Purpose : Handles the UPDATE DML logic for the table.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  */
          p_per_interest_rec Hz_Person_Info_V2Pub.person_interest_rec_type;

Line: 217

          lv_Last_Update_Date        DATE;

Line: 219

                SELECT
                        ROWID, HZ_EXTRACURR_ACT_ID
                FROM
                        IGS_AD_HZ_EXTRACURR_ACT
                WHERE
                         PERSON_INTEREST_ID = x_person_interest_id;

Line: 228

	 CURSOR c_birth_date_val is SELECT date_of_birth FROM HZ_PERSON_PROFILES
         WHERE party_id = x_person_id AND effective_end_Date is null;

Line: 312

	Hz_Person_Info_V2Pub.Update_person_interest(
                        p_init_msg_list    => FND_API.G_TRUE,
		        p_person_interest_rec => p_per_interest_rec,
			p_object_version_number  => x_object_version_number,
                        x_return_status    => l_return_status,
                        x_msg_count     => l_msg_count,
                        x_msg_data    => l_msg_data

		);

Line: 342

          Igs_Ad_Hz_Extracurr_Act_Pkg.Update_Row(
                        x_rowid  => l_rowId,
                        x_hz_extracurr_act_id => l_hz_ExtraCurr_Act_Id,
                        x_person_interest_id  => x_person_interest_id,
                        x_end_date => x_End_Date,
                        x_hours_per_week => x_Hours_per_Week,
                        x_weeks_per_year => x_Weeks_Per_Year,
                        x_activity_source_cd => x_activity_source_cd,
                        x_mode => 'R') ;

Line: 352

  END update_row;