APPS.GMS_FP_DISTRIBUTIONS_PKG SQL Statements

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

Line: 4

   PROCEDURE INSERT_ROW ( P_rec GMS_FP_DISTRIBUTIONS%ROWTYPE)
    IS
      X_rec GMS_FP_DISTRIBUTIONS%ROWTYPE;

Line: 14

      insert into GMS_FP_DISTRIBUTIONS(funding_pattern_id
                                        ,distribution_number
                                        ,award_id
                                        ,distribution_value
                                        ,last_update_date
                                        ,last_updated_by
                                        ,creation_date
                                        ,created_by
                                        ,last_update_login
					)
                                 values( X_rec .funding_pattern_id
                                        ,X_rec .distribution_number
                                        ,X_rec .award_id
                                        ,X_rec .distribution_value
                                        ,X_rec .last_update_date
                                        ,X_rec .last_updated_by
                                        ,X_rec .creation_date
                                        ,X_rec .created_by
                                        ,X_rec .last_update_login);

Line: 37

   END INSERT_ROW;

Line: 42

           SELECT funding_pattern_id
                  ,distribution_number
                  ,award_id
                  ,distribution_value
           FROM GMS_FP_DISTRIBUTIONS
           WHERE funding_pattern_id    = P_rec.funding_pattern_id
           AND   distribution_number   = P_rec.distribution_number
           AND   award_id              = P_rec.award_id;

Line: 60

            fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 97

   PROCEDURE UPDATE_ROW ( P_rec GMS_FP_DISTRIBUTIONS%ROWTYPE) IS
        X_rec GMS_FP_DISTRIBUTIONS%ROWTYPE;

Line: 102

           update GMS_FP_DISTRIBUTIONS
       	   set distribution_value    = X_rec.distribution_value
              ,award_id 	         = X_rec.award_id
	       where funding_pattern_id  = X_rec.funding_pattern_id
	       and distribution_number   = X_rec.distribution_number;

Line: 115

  END UPDATE_ROW;

Line: 116

  PROCEDURE DELETE_ROW ( P_rec GMS_FP_DISTRIBUTIONS%ROWTYPE) IS
  X_rec GMS_FP_DISTRIBUTIONS%ROWTYPE;

Line: 120

                    delete gms_fp_distributions
                    where funding_pattern_id    = X_rec.funding_pattern_id
                    and distribution_number   =   X_rec.distribution_number;

Line: 131

    END DELETE_ROW;