APPS.IGS_OR_GEN_012_PKG SQL Statements

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

Line: 123

  PROCEDURE update_organization (
      p_party_id                          IN  NUMBER,
      p_institution_cd                    IN  VARCHAR2,
      p_name                              IN  VARCHAR2,
      p_status                            IN  VARCHAR2,
      p_last_update                       IN  OUT NOCOPY 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_attribute16                       IN  VARCHAR2,
      p_attribute17                       IN  VARCHAR2,
      p_attribute18                       IN  VARCHAR2,
      p_attribute19                       IN  VARCHAR2,
      p_attribute20                       IN  VARCHAR2,
      p_return_status                     OUT NOCOPY VARCHAR2,
      p_msg_data                          OUT NOCOPY VARCHAR2,
      p_object_version_number             IN OUT NOCOPY NUMBER,
      p_attribute21                       IN  VARCHAR2,
      p_attribute22                       IN  VARCHAR2,
      p_attribute23                       IN  VARCHAR2,
      p_attribute24                       IN  VARCHAR2
  ) AS
  /*
  ||  Created By : [email protected]
  ||  Created On : 28-AUG-2000
  ||  Purpose : To call the API hz_part_pub.update_organization
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  */

    v_msg_count      NUMBER;

Line: 222

    hz_party_v2pub.update_organization (
       p_init_msg_list                 =>  	FND_API.G_TRUE,
       p_organization_rec              =>    v_organization_rec_type,
       p_party_object_version_number   =>    p_object_version_number,
       x_profile_id                    =>    v_profile_id,
       x_return_status                 =>    p_return_status,
       x_msg_count                     =>    v_msg_count,
       x_msg_data                      =>    p_msg_data
    ) ;

Line: 245

  END update_organization;

Line: 259

  ||                                  PKM Bind variable issue (Instead of passing the hard-coded values passed the select clause)
  ||  (reverse chronological order - newest change first)
  */
  CURSOR get_attr_type_cur IS
	  SELECT distinct attr_type
	  FROM   igs_or_func_fltr
	  WHERE  func_code = p_function_name;

Line: 268

     SELECT attr_val
     FROM   igs_or_func_fltr
     WHERE  func_code = p_function_name;

Line: 291

		l_where_clause := get_attr_type_rec.attr_type ||' IN (SELECT attr_val FROM igs_or_func_fltr  WHERE  func_code = '''|| p_function_name ||''')';

Line: 323

	  SELECT distinct attr_type
	  FROM   igs_or_func_fltr
	  WHERE  func_code = p_function_name;

Line: 346

		l_where_clause := get_attr_type_rec.attr_type ||' IN (SELECT attr_val FROM igs_or_func_fltr  WHERE  func_code = :PARAMETER.P_FORM_NAME)';

Line: 377

	  SELECT distinct attr_type
	  FROM   igs_or_func_fltr
	  WHERE  func_code = cp_function_name;

Line: 399

		l_where_clause := get_attr_type_rec.attr_type ||' IN (SELECT attr_val FROM igs_or_func_fltr  WHERE  func_code = :p_function_name )';

Line: 427

	  SELECT distinct attr_type, inst_org_val
	  FROM   igs_or_func_fltr
	  WHERE  func_code = cp_function_name;

Line: 457

		l_where_clause := l_inst_org_prefix||get_attr_type_rec.attr_type ||' IN (SELECT attr_val FROM igs_or_func_fltr  WHERE  func_code = :PARAMETER.P_FORM_NAME)';

Line: 486

	  SELECT distinct attr_type, inst_org_val
	  FROM   igs_or_func_fltr
	  WHERE  func_code = cp_function_name;

Line: 514

		l_where_clause := l_inst_org_prefix||get_attr_type_rec.attr_type ||' IN (SELECT attr_val FROM igs_or_func_fltr  WHERE  func_code = :p_function_name )';