The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure insert_HXT_ADD_ELEM_INFO(
p_rowid IN OUT NOCOPY VARCHAR2,
p_id NUMBER,
p_effective_start_date DATE,
p_effective_end_date DATE,
p_element_type_id NUMBER,
p_earning_category VARCHAR2,
p_absence_type VARCHAR2,
p_absence_points NUMBER,
p_points_assigned NUMBER,
p_premium_type VARCHAR2,
p_premium_amount NUMBER,
p_processing_order NUMBER,
p_expenditure_type VARCHAR2,
p_created_by NUMBER,
p_creation_date DATE,
p_last_updated_by NUMBER,
p_last_update_date DATE,
p_last_update_login NUMBER,
p_attribute_category VARCHAR2,
p_attribute1 VARCHAR2,
p_attribute2 VARCHAR2,
p_attribute3 VARCHAR2,
p_attribute4 VARCHAR2,
p_attribute5 VARCHAR2,
p_attribute6 VARCHAR2,
p_attribute7 VARCHAR2,
p_attribute8 VARCHAR2,
p_attribute9 VARCHAR2,
p_attribute10 VARCHAR2,
p_attribute11 VARCHAR2,
p_attribute12 VARCHAR2,
p_attribute13 VARCHAR2,
p_attribute14 VARCHAR2,
p_attribute15 VARCHAR2,
p_attribute16 VARCHAR2,
p_attribute17 VARCHAR2,
p_attribute18 VARCHAR2,
p_attribute19 VARCHAR2,
p_attribute20 VARCHAR2,
p_attribute21 VARCHAR2,
p_attribute22 VARCHAR2,
p_attribute23 VARCHAR2,
p_attribute24 VARCHAR2,
p_attribute25 VARCHAR2,
p_attribute26 VARCHAR2,
p_attribute27 VARCHAR2,
p_attribute28 VARCHAR2,
p_attribute29 VARCHAR2,
p_attribute30 VARCHAR2,
p_exclude_from_explosion VARCHAR2 /* Bug: 4489952 */
) is
cursor c2 is select rowid
from hxt_add_elem_info_f
where effective_start_date = p_effective_start_date
and effective_end_date = p_effective_end_date
and id = p_id;
insert into HXT_ADD_ELEM_INFO_F(
id,
effective_start_date,
effective_end_date,
element_type_id,
earning_category,
absence_type,
absence_points,
points_assigned,
premium_type,
premium_amount,
processing_order,
expenditure_type,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
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,
exclude_from_explosion /* Bug: 4489952 */
)
VALUES(
p_id,
p_effective_start_date,
p_effective_end_date,
p_element_type_id,
p_earning_category,
p_absence_type,
p_absence_points,
p_points_assigned,
p_premium_type,
p_premium_amount,
p_processing_order,
p_expenditure_type,
p_created_by,
p_creation_date,
p_last_updated_by,
p_last_update_date,
p_last_update_login,
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_exclude_from_explosion /* Bug: 4489952 */
);
end insert_HXT_ADD_ELEM_INFO;
procedure update_HXT_ADD_ELEM_INFO(
p_rowid IN VARCHAR2,
p_id NUMBER,
p_effective_start_date DATE,
p_effective_end_date DATE,
p_element_type_id NUMBER,
p_earning_category VARCHAR2,
p_absence_type VARCHAR2,
p_absence_points NUMBER,
p_points_assigned NUMBER,
p_premium_type VARCHAR2,
p_premium_amount NUMBER,
p_processing_order NUMBER,
p_expenditure_type VARCHAR2,
p_created_by NUMBER,
p_creation_date DATE,
p_last_updated_by NUMBER,
p_last_update_date DATE,
p_last_update_login NUMBER,
p_attribute_category VARCHAR2,
p_attribute1 VARCHAR2,
p_attribute2 VARCHAR2,
p_attribute3 VARCHAR2,
p_attribute4 VARCHAR2,
p_attribute5 VARCHAR2,
p_attribute6 VARCHAR2,
p_attribute7 VARCHAR2,
p_attribute8 VARCHAR2,
p_attribute9 VARCHAR2,
p_attribute10 VARCHAR2,
p_attribute11 VARCHAR2,
p_attribute12 VARCHAR2,
p_attribute13 VARCHAR2,
p_attribute14 VARCHAR2,
p_attribute15 VARCHAR2,
p_attribute16 VARCHAR2,
p_attribute17 VARCHAR2,
p_attribute18 VARCHAR2,
p_attribute19 VARCHAR2,
p_attribute20 VARCHAR2,
p_attribute21 VARCHAR2,
p_attribute22 VARCHAR2,
p_attribute23 VARCHAR2,
p_attribute24 VARCHAR2,
p_attribute25 VARCHAR2,
p_attribute26 VARCHAR2,
p_attribute27 VARCHAR2,
p_attribute28 VARCHAR2,
p_attribute29 VARCHAR2,
p_attribute30 VARCHAR2,
p_exclude_from_explosion VARCHAR2 /* Bug: 4489952 */
) is
begin
update HXT_ADD_ELEM_INFO_F
set
effective_start_date = p_effective_start_date,
effective_end_date = p_effective_end_date,
element_type_id = p_element_type_id,
earning_category = p_earning_category,
absence_type = p_absence_type,
absence_points = p_absence_points,
points_assigned = p_points_assigned,
premium_type = p_premium_type,
premium_amount = p_premium_amount,
processing_order = p_processing_order,
expenditure_type = p_expenditure_type,
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,
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_attribute21,
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,
exclude_from_explosion = p_exclude_from_explosion /* Bug: 4489952 */
where rowid = p_rowid;
end update_HXT_ADD_ELEM_INFO;
procedure delete_HXT_ADD_ELEM_INFO(p_rowid VARCHAR2) is
begin
delete from HXT_ADD_ELEM_INFO_F
where rowid = chartorowid(p_rowid);
end delete_HXT_ADD_ELEM_INFO;
select ELEMENT_TYPE_ID into vnull
from hxt_add_elem_info_f
where rowid = p_rowid
for update of hxt_add_elem_info_f.ELEMENT_TYPE_ID nowait;