APPS.HXT_AEI SQL Statements

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

Line: 4

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;

Line: 65

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 */
);

Line: 173

end insert_HXT_ADD_ELEM_INFO;

Line: 176

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;

Line: 283

end update_HXT_ADD_ELEM_INFO;

Line: 286

procedure delete_HXT_ADD_ELEM_INFO(p_rowid VARCHAR2) is
begin
   delete from HXT_ADD_ELEM_INFO_F
   where rowid = chartorowid(p_rowid);

Line: 290

end delete_HXT_ADD_ELEM_INFO;

Line: 296

   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;