[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_row( x_rowid IN OUT NOCOPY VARCHAR2,
x_entity_association_id NUMBER,
x_primary_id_number VARCHAR2,
x_associated_entity_id NUMBER,
x_id_type VARCHAR2,
x_id_number VARCHAR2,
x_description VARCHAR2,
x_effective_date DATE,
x_ineffective_date DATE,
x_attribute_category VARCHAR2,
x_attribute1 VARCHAR2,
x_attribute2 VARCHAR2,
x_attribute3 VARCHAR2,
x_attribute4 VARCHAR2,
x_attribute5 VARCHAR2,
x_attribute6 VARCHAR2,
x_attribute7 VARCHAR2,
x_attribute8 VARCHAR2,
x_attribute9 VARCHAR2,
x_attribute10 VARCHAR2,
x_attribute11 VARCHAR2,
x_attribute12 VARCHAR2,
x_attribute13 VARCHAR2,
x_attribute14 VARCHAR2,
x_attribute15 VARCHAR2,
x_attribute16 VARCHAR2,
x_attribute17 VARCHAR2,
x_attribute18 VARCHAR2,
x_attribute19 VARCHAR2,
x_attribute20 VARCHAR2,
x_created_by NUMBER,
x_creation_date DATE,
x_last_updated_by NUMBER,
x_last_update_date DATE,
x_last_update_login NUMBER ) IS
CURSOR C IS SELECT rowid
FROM jg_zz_entity_assoc
WHERE entity_association_id = x_entity_association_id;
INSERT INTO jg_zz_entity_assoc( entity_association_id,
primary_id_number,
associated_entity_id,
id_type,
id_number,
description,
effective_date,
ineffective_date,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login
) VALUES (
x_entity_association_id,
x_primary_id_number,
x_associated_entity_id,
x_id_type,
x_id_number,
x_description,
x_effective_date,
x_ineffective_date,
x_attribute_category,
x_attribute1,
x_attribute2,
x_attribute3,
x_attribute4,
x_attribute5,
x_attribute6,
x_attribute7,
x_attribute8,
x_attribute9,
x_attribute10,
x_attribute11,
x_attribute12,
x_attribute13,
x_attribute14,
x_attribute15,
x_attribute16,
x_attribute17,
x_attribute18,
x_attribute19,
x_attribute20,
x_created_by,
x_creation_date,
x_last_updated_by,
x_last_update_date,
x_last_update_login );
END insert_row;
x_last_updated_by NUMBER,
x_last_update_date DATE,
x_last_update_login NUMBER ) IS
CURSOR C IS SELECT *
FROM jg_zz_entity_assoc
WHERE rowid = x_rowid
FOR UPDATE OF entity_association_id NOWAIT;
fnd_message.set_name( 'FND', 'FORM_RECORD_DELETED' );
AND ( recinfo.last_updated_by = x_last_updated_by )
AND ( recinfo.last_update_date = x_last_update_date )
AND ( (recinfo.last_update_login = x_last_update_login)
OR ( (recinfo.last_update_login IS NULL)
AND (x_last_update_login IS NULL)))
) THEN
return;
PROCEDURE update_row( x_rowid VARCHAR2,
x_entity_association_id NUMBER,
x_primary_id_number VARCHAR2,
x_associated_entity_id NUMBER,
x_id_type VARCHAR2,
x_id_number VARCHAR2,
x_description VARCHAR2,
x_effective_date DATE,
x_ineffective_date DATE,
x_attribute_category VARCHAR2,
x_attribute1 VARCHAR2,
x_attribute2 VARCHAR2,
x_attribute3 VARCHAR2,
x_attribute4 VARCHAR2,
x_attribute5 VARCHAR2,
x_attribute6 VARCHAR2,
x_attribute7 VARCHAR2,
x_attribute8 VARCHAR2,
x_attribute9 VARCHAR2,
x_attribute10 VARCHAR2,
x_attribute11 VARCHAR2,
x_attribute12 VARCHAR2,
x_attribute13 VARCHAR2,
x_attribute14 VARCHAR2,
x_attribute15 VARCHAR2,
x_attribute16 VARCHAR2,
x_attribute17 VARCHAR2,
x_attribute18 VARCHAR2,
x_attribute19 VARCHAR2,
x_attribute20 VARCHAR2,
x_created_by NUMBER,
x_creation_date DATE,
x_last_updated_by NUMBER,
x_last_update_date DATE,
x_last_update_login NUMBER ) IS
BEGIN
UPDATE jg_zz_entity_assoc
SET entity_association_id = x_entity_association_id,
primary_id_number = x_primary_id_number,
associated_entity_id = x_associated_entity_id,
id_type = x_id_type,
id_number = x_id_number,
description = x_description,
effective_date = x_effective_date,
ineffective_date = x_ineffective_date,
attribute_category = x_attribute_category,
attribute1 = x_attribute1,
attribute2 = x_attribute2,
attribute3 = x_attribute3,
attribute4 = x_attribute4,
attribute5 = x_attribute5,
attribute6 = x_attribute6,
attribute7 = x_attribute7,
attribute8 = x_attribute8,
attribute9 = x_attribute9,
attribute10 = x_attribute10,
attribute11 = x_attribute11,
attribute12 = x_attribute12,
attribute13 = x_attribute13,
attribute14 = x_attribute14,
attribute15 = x_attribute15,
attribute16 = x_attribute16,
attribute17 = x_attribute17,
attribute18 = x_attribute18,
attribute19 = x_attribute19,
attribute20 = x_attribute20,
created_by = x_created_by,
creation_date = x_creation_date,
last_updated_by = x_last_updated_by,
last_update_date = x_last_update_date,
last_update_login = x_last_update_login
WHERE rowid = x_rowid;
END update_row;