APPS.HZ_ORIG_SYSTEM_REF_PUB SQL Statements

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

Line: 43

    HZ_ORIG_SYS_ENTITY_MAP_PKG.Select_Row (
      x_orig_system                           => l_orig_system,
      x_owner_table_name                      => l_owner_table_name,
      x_status                                => x_orig_sys_entity_map_rec.status,
      x_multiple_flag                         => x_orig_sys_entity_map_rec.multiple_flag,
--raji
      x_multi_osr_flag                        => x_orig_sys_entity_map_rec.multi_osr_flag,
      x_object_version_number                 => l_object_version_number,
      x_created_by_module                     => x_orig_sys_entity_map_rec.created_by_module,
      x_application_id                        => x_orig_sys_entity_map_rec.application_id,
      x_attribute_category                    => x_orig_sys_entity_map_rec.attribute_category,
      x_attribute1                            => x_orig_sys_entity_map_rec.attribute1,
      x_attribute2                            => x_orig_sys_entity_map_rec.attribute2,
      x_attribute3                            => x_orig_sys_entity_map_rec.attribute3,
      x_attribute4                            => x_orig_sys_entity_map_rec.attribute4,
      x_attribute5                            => x_orig_sys_entity_map_rec.attribute5,
      x_attribute6                            => x_orig_sys_entity_map_rec.attribute6,
      x_attribute7                            => x_orig_sys_entity_map_rec.attribute7,
      x_attribute8                            => x_orig_sys_entity_map_rec.attribute8,
      x_attribute9                            => x_orig_sys_entity_map_rec.attribute9,
      x_attribute10                           => x_orig_sys_entity_map_rec.attribute10,
      x_attribute11                           => x_orig_sys_entity_map_rec.attribute11,
      x_attribute12                           => x_orig_sys_entity_map_rec.attribute12,
      x_attribute13                           => x_orig_sys_entity_map_rec.attribute13,
      x_attribute14                           => x_orig_sys_entity_map_rec.attribute14,
      x_attribute15                           => x_orig_sys_entity_map_rec.attribute15,
      x_attribute16                           => x_orig_sys_entity_map_rec.attribute16,
      x_attribute17                           => x_orig_sys_entity_map_rec.attribute17,
      x_attribute18                           => x_orig_sys_entity_map_rec.attribute18,
      x_attribute19                           => x_orig_sys_entity_map_rec.attribute19,
      x_attribute20                           => x_orig_sys_entity_map_rec.attribute20
    );

Line: 146

    HZ_ORIG_SYSTEM_REF_PKG.Select_Row (
      x_orig_system_ref_id                    => x_orig_sys_reference_rec.orig_system_ref_id,
      x_orig_system                           => x_orig_sys_reference_rec.orig_system,
      x_orig_system_reference                 => x_orig_sys_reference_rec.orig_system_reference,
      x_owner_table_name                      => x_orig_sys_reference_rec.owner_table_name,
      x_owner_table_id                        => x_orig_sys_reference_rec.owner_table_id,
--raji
      x_party_id                              => x_orig_sys_reference_rec.party_id,
      x_status                                => x_orig_sys_reference_rec.status,
      x_reason_code                           => x_orig_sys_reference_rec.reason_code,
      x_old_orig_system_reference              => x_orig_sys_reference_rec.old_orig_system_reference,
      x_start_date_active                     => x_orig_sys_reference_rec.start_date_active,
      x_end_date_active                       => x_orig_sys_reference_rec.end_date_active,
      x_object_version_number                 => l_object_version_number,
      x_created_by_module                     => x_orig_sys_reference_rec.created_by_module,
      x_application_id                        => x_orig_sys_reference_rec.application_id,
      x_attribute_category                    => x_orig_sys_reference_rec.attribute_category,
      x_attribute1                            => x_orig_sys_reference_rec.attribute1,
      x_attribute2                            => x_orig_sys_reference_rec.attribute2,
      x_attribute3                            => x_orig_sys_reference_rec.attribute3,
      x_attribute4                            => x_orig_sys_reference_rec.attribute4,
      x_attribute5                            => x_orig_sys_reference_rec.attribute5,
      x_attribute6                            => x_orig_sys_reference_rec.attribute6,
      x_attribute7                            => x_orig_sys_reference_rec.attribute7,
      x_attribute8                            => x_orig_sys_reference_rec.attribute8,
      x_attribute9                            => x_orig_sys_reference_rec.attribute9,
      x_attribute10                           => x_orig_sys_reference_rec.attribute10,
      x_attribute11                           => x_orig_sys_reference_rec.attribute11,
      x_attribute12                           => x_orig_sys_reference_rec.attribute12,
      x_attribute13                           => x_orig_sys_reference_rec.attribute13,
      x_attribute14                           => x_orig_sys_reference_rec.attribute14,
      x_attribute15                           => x_orig_sys_reference_rec.attribute15,
      x_attribute16                           => x_orig_sys_reference_rec.attribute16,
      x_attribute17                           => x_orig_sys_reference_rec.attribute17,
      x_attribute18                           => x_orig_sys_reference_rec.attribute18,
      x_attribute19                           => x_orig_sys_reference_rec.attribute19,
      x_attribute20                           => x_orig_sys_reference_rec.attribute20
    );

Line: 287

PROCEDURE update_orig_system_reference(
    p_init_msg_list           	IN      	VARCHAR2 := FND_API.G_FALSE,
    p_orig_sys_reference_rec       IN      ORIG_SYS_REFERENCE_REC_TYPE,
    p_object_version_number   	IN OUT   NOCOPY NUMBER,
    x_return_status   	OUT     NOCOPY	VARCHAR2,
    x_msg_count 	OUT     NOCOPY	NUMBER,
    x_msg_data	OUT     NOCOPY 	VARCHAR2
)is
l_object_version_number number:= p_object_version_number;

Line: 300

    SAVEPOINT update_orig_sys_reference;

Line: 310

    HZ_ORIG_SYSTEM_REF_PVT.update_orig_system_reference(
			FND_API.G_FALSE,
			FND_API.G_VALID_LEVEL_FULL,
			p_orig_sys_reference_rec,
			p_object_version_number,
			x_return_status,
		        x_msg_count,
		        x_msg_data);

Line: 327

        ROLLBACK TO update_orig_sys_reference;

Line: 335

        ROLLBACK TO update_orig_sys_reference;

Line: 343

        ROLLBACK TO update_orig_sys_reference;

Line: 353

end update_orig_system_reference;

Line: 425

	SELECT OWNER_TABLE_ID
        FROM   HZ_ORIG_SYS_REFERENCES
        WHERE  ORIG_SYSTEM = p_orig_system
	and ORIG_SYSTEM_REFERENCE = p_orig_system_reference
	and owner_table_name = p_owner_table_name
	and status = 'A';

Line: 440

		FND_MESSAGE.SET_NAME('AR', 'HZ_MOSR_CANNOT_UPDATE');