The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row
(p_commit IN VARCHAR2,
p_called_by_form IN VARCHAR2,
p_item_group_code IN VARCHAR2,
p_primary_cas_number IN VARCHAR2,
p_ingredient_flag IN VARCHAR2,
p_explode_ingredient_flag IN VARCHAR2,
p_formula_source_indicator IN VARCHAR2,
p_user_id IN NUMBER,
p_internal_reference_number IN VARCHAR2,
p_label_code IN VARCHAR2,
p_version_code IN VARCHAR2,
p_last_version_code IN VARCHAR2,
p_product_class IN VARCHAR2,
p_item_code IN VARCHAR2,
p_actual_hazard IN NUMBER,
p_print_ing_phrases_flag IN VARCHAR2,
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_attribute21 IN VARCHAR2,
p_attribute22 IN VARCHAR2,
p_attribute23 IN VARCHAR2,
p_attribute24 IN VARCHAR2,
p_attribute25 IN VARCHAR2,
p_attribute26 IN VARCHAR2,
p_attribute27 IN VARCHAR2,
p_attribute28 IN VARCHAR2,
p_attribute29 IN VARCHAR2,
p_attribute30 IN VARCHAR2,
p_created_by IN NUMBER,
p_creation_date IN DATE,
p_last_updated_by IN NUMBER,
p_last_update_date IN DATE,
p_last_update_login IN NUMBER,
x_rowid OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_oracle_error OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
/* Alpha Variables */
L_RETURN_STATUS VARCHAR2(1) := 'S';
SAVEPOINT Insert_Row;
INSERT INTO gr_item_general
(item_code,
item_group_code,
primary_cas_number,
ingredient_flag,
explode_ingredient_flag,
formula_source_indicator,
user_id,
internal_reference_number,
product_label_code,
version_code,
last_version_code,
product_class,
actual_hazard,
print_ingredient_phrases_flag,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
attribute21,
attribute22,
attribute23,
attribute24,
attribute25,
attribute26,
attribute27,
attribute28,
attribute29,
attribute30,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login)
VALUES
(p_item_code,
p_item_group_code,
p_primary_cas_number,
p_ingredient_flag,
p_explode_ingredient_flag,
p_formula_source_indicator,
p_user_id,
p_internal_reference_number,
p_label_code,
p_version_code,
p_last_version_code,
p_product_class,
p_actual_hazard,
p_print_ing_phrases_flag,
p_attribute_category,
p_attribute1,
p_attribute2,
p_attribute3,
p_attribute4,
p_attribute5,
p_attribute6,
p_attribute7,
p_attribute8,
p_attribute9,
p_attribute10,
p_attribute11,
p_attribute12,
p_attribute13,
p_attribute14,
p_attribute15,
p_attribute16,
p_attribute17,
p_attribute18,
p_attribute19,
p_attribute20,
p_attribute21,
p_attribute22,
p_attribute23,
p_attribute24,
p_attribute25,
p_attribute26,
p_attribute27,
p_attribute28,
p_attribute29,
p_attribute30,
p_created_by,
p_creation_date,
p_last_updated_by,
p_last_update_date,
p_last_update_login);
/* Now get the row id of the inserted record */
Check_Primary_Key
(p_item_code,
'F',
l_rowid,
l_key_exists);
ROLLBACK TO SAVEPOINT Insert_Row;
ROLLBACK TO SAVEPOINT Insert_Row;
ROLLBACK TO SAVEPOINT Insert_Row;
'GR_NO_RECORD_INSERTED');
ROLLBACK TO SAVEPOINT Insert_Row;
END Insert_Row;
PROCEDURE Update_Row
(p_commit IN VARCHAR2,
p_called_by_form IN VARCHAR2,
p_rowid IN VARCHAR2,
p_item_group_code IN VARCHAR2,
p_primary_cas_number IN VARCHAR2,
p_ingredient_flag IN VARCHAR2,
p_explode_ingredient_flag IN VARCHAR2,
p_formula_source_indicator IN VARCHAR2,
p_user_id IN NUMBER,
p_internal_reference_number IN VARCHAR2,
p_label_code IN VARCHAR2,
p_version_code IN VARCHAR2,
p_last_version_code IN VARCHAR2,
p_product_class IN VARCHAR2,
p_item_code IN VARCHAR2,
p_actual_hazard IN NUMBER,
p_print_ing_phrases_flag IN VARCHAR2,
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_attribute21 IN VARCHAR2,
p_attribute22 IN VARCHAR2,
p_attribute23 IN VARCHAR2,
p_attribute24 IN VARCHAR2,
p_attribute25 IN VARCHAR2,
p_attribute26 IN VARCHAR2,
p_attribute27 IN VARCHAR2,
p_attribute28 IN VARCHAR2,
p_attribute29 IN VARCHAR2,
p_attribute30 IN VARCHAR2,
p_created_by IN NUMBER,
p_creation_date IN DATE,
p_last_updated_by IN NUMBER,
p_last_update_date IN DATE,
p_last_update_login IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_oracle_error OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
/* Alpha Variables */
L_RETURN_STATUS VARCHAR2(1) := 'S';
SAVEPOINT Update_Row;
UPDATE gr_item_general
SET item_code = p_item_code,
item_group_code = p_item_group_code,
primary_cas_number = p_primary_cas_number,
ingredient_flag = p_ingredient_flag,
explode_ingredient_flag = p_explode_ingredient_flag,
formula_source_indicator = p_formula_source_indicator,
user_id = p_user_id,
internal_reference_number = p_internal_reference_number,
product_label_code = p_label_code,
version_code = p_version_code,
last_version_code = p_last_version_code,
product_class = p_product_class,
actual_hazard = p_actual_hazard,
print_ingredient_phrases_flag = p_print_ing_phrases_flag,
attribute_category = p_attribute_category,
attribute1 = p_attribute1,
attribute2 = p_attribute2,
attribute3 = p_attribute3,
attribute4 = p_attribute4,
attribute5 = p_attribute5,
attribute6 = p_attribute6,
attribute7 = p_attribute7,
attribute8 = p_attribute8,
attribute9 = p_attribute9,
attribute10 = p_attribute10,
attribute11 = p_attribute11,
attribute12 = p_attribute12,
attribute13 = p_attribute13,
attribute14 = p_attribute14,
attribute15 = p_attribute15,
attribute16 = p_attribute16,
attribute17 = p_attribute17,
attribute18 = p_attribute18,
attribute19 = p_attribute19,
attribute20 = p_attribute20,
attribute21 = p_attribute11,
attribute22 = p_attribute22,
attribute23 = p_attribute23,
attribute24 = p_attribute24,
attribute25 = p_attribute25,
attribute26 = p_attribute26,
attribute27 = p_attribute27,
attribute28 = p_attribute28,
attribute29 = p_attribute29,
attribute30 = p_attribute30,
created_by = p_created_by,
creation_date = p_creation_date,
last_updated_by = p_last_updated_by,
last_update_date = p_last_update_date,
last_update_login = p_last_update_login
WHERE rowid = p_rowid;
ROLLBACK TO SAVEPOINT Update_Row;
ROLLBACK TO SAVEPOINT Update_Row;
'GR_NO_RECORD_INSERTED');
ROLLBACK TO SAVEPOINT Update_Row;
END Update_Row;
p_last_updated_by IN NUMBER,
p_last_update_date IN DATE,
p_last_update_login IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_oracle_error OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
/* Alpha Variables */
L_RETURN_STATUS VARCHAR2(1) := 'S';
SELECT *
FROM gr_item_general
WHERE rowid = p_rowid
FOR UPDATE NOWAIT;
PROCEDURE Delete_Row
(p_commit IN VARCHAR2,
p_called_by_form IN VARCHAR2,
p_rowid IN VARCHAR2,
p_item_group_code IN VARCHAR2,
p_primary_cas_number IN VARCHAR2,
p_ingredient_flag IN VARCHAR2,
p_explode_ingredient_flag IN VARCHAR2,
p_formula_source_indicator IN VARCHAR2,
p_user_id IN NUMBER,
p_internal_reference_number IN VARCHAR2,
p_label_code IN VARCHAR2,
p_version_code IN VARCHAR2,
p_last_version_code IN VARCHAR2,
p_product_class IN VARCHAR2,
p_item_code IN VARCHAR2,
p_actual_hazard IN NUMBER,
p_print_ing_phrases_flag IN VARCHAR2,
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_attribute21 IN VARCHAR2,
p_attribute22 IN VARCHAR2,
p_attribute23 IN VARCHAR2,
p_attribute24 IN VARCHAR2,
p_attribute25 IN VARCHAR2,
p_attribute26 IN VARCHAR2,
p_attribute27 IN VARCHAR2,
p_attribute28 IN VARCHAR2,
p_attribute29 IN VARCHAR2,
p_attribute30 IN VARCHAR2,
p_created_by IN NUMBER,
p_creation_date IN DATE,
p_last_updated_by IN NUMBER,
p_last_update_date IN DATE,
p_last_update_login IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_oracle_error OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
/* Alpha Variables */
L_RETURN_STATUS VARCHAR2(1) := 'S';
SAVEPOINT Delete_Row;
DELETE FROM gr_item_general
WHERE rowid = p_rowid;
ROLLBACK TO SAVEPOINT Delete_Row;
ROLLBACK TO SAVEPOINT Delete_Row;
ROLLBACK TO SAVEPOINT Delete_Row;
END Delete_Row;
SELECT ig.item_group_code
FROM gr_item_groups_b ig
WHERE ig.item_group_code = p_item_group_code;
SELECT pc.product_class
FROM gr_product_classes pc
WHERE pc.product_class = p_product_class;
SELECT fnu.user_id
FROM fnd_user fnu
WHERE fnu.user_id = p_user_id;
SELECT COUNT(*)
FROM gr_calculated ca
WHERE ca.item_code = p_item_code;
SELECT COUNT(*)
FROM gr_dispatch_histories dh
WHERE dh.item_code = p_item_code;
SELECT COUNT(*)
FROM gr_document_print dp
WHERE dp.item_code = p_item_code;
SELECT COUNT(*)
FROM gr_emea em
WHERE em.item_code = p_item_code;
SELECT COUNT(*)
FROM gr_generic_items_b gen
WHERE gen.item_code = p_item_code;
SELECT COUNT(*)
FROM gr_generic_ml_name_tl gmn
WHERE gmn.item_code = p_item_code;
SELECT COUNT(*)
FROM gr_item_classns ic
WHERE ic.item_code = p_item_code;
SELECT COUNT(*)
FROM gr_item_disclosures id
WHERE id.item_code = p_item_code;
SELECT COUNT(*)
FROM gr_item_document_dtls idd
WHERE idd.item_code = p_item_code;
SELECT COUNT(*)
FROM gr_item_doc_statuses ids
WHERE ids.item_code = p_item_code;
SELECT COUNT(*)
FROM gr_item_exposure ie
WHERE ie.item_code = p_item_code;
SELECT COUNT(*)
FROM gr_item_properties ip
WHERE ip.item_code = p_item_code;
SELECT COUNT(*)
FROM gr_item_right_to_know irtk
WHERE irtk.item_code = p_item_code;
SELECT COUNT(*)
FROM gr_item_risk_phrases irp
WHERE irp.item_code = p_item_code;
SELECT COUNT(*)
FROM gr_item_safety_phrases isp
WHERE isp.item_code = p_item_code;
SELECT COUNT(*)
FROM gr_item_toxic it
WHERE it.item_code = p_item_code;
SELECT COUNT(*)
FROM gr_multilingual_name_tl mln
WHERE mln.item_code = p_item_code;
SELECT COUNT(*)
FROM gr_other_names_tl onm
WHERE onm.item_code = p_item_code;
SELECT ig.rowid
FROM gr_item_general ig
WHERE ig.item_code = p_item_code;