APPS.HXT_HEP SQL Statements

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

Line: 4

procedure insert_HXT_EARNING_POLICIES(
p_rowid                      IN OUT NOCOPY VARCHAR2,
p_id                         NUMBER,
p_hcl_id                     NUMBER,
p_fcl_earn_type              VARCHAR2,
p_name                       VARCHAR2,
p_business_group_id          NUMBER,  --HXT11i1
p_effective_start_date       DATE,
p_pip_id                     NUMBER,
p_pep_id                     NUMBER,
p_egt_id                     NUMBER,
p_description                VARCHAR2,
p_effective_end_date         DATE,
p_created_by                 NUMBER,
p_creation_date              DATE,
p_last_updated_by            NUMBER,
p_last_update_date           DATE,
p_last_update_login          NUMBER,
p_organization_id            NUMBER,
p_round_up                   NUMBER,
p_min_tcard_intvl            NUMBER,
p_use_points_assigned        VARCHAR2
) is

cursor c2 is select rowid
            from   HXT_EARNING_POLICIES
            where  effective_start_date = p_effective_start_date
            and    effective_end_date = p_effective_end_date
            and    id = p_id;

Line: 36

insert into HXT_EARNING_POLICIES
(id
,hcl_id
,fcl_earn_type
,name
,business_group_id  --HXT11i1
,effective_start_date
,pip_id
,pep_id
,egt_id
,description
,effective_end_date
,created_by
,creation_date
,last_updated_by
,last_update_date
,last_update_login
,organization_id
,round_up
,min_tcard_intvl
,use_points_assigned
)
VALUES
(p_id
,p_hcl_id
,p_fcl_earn_type
,p_name
,p_business_group_id  --HXT11i1
,p_effective_start_date
,p_pip_id
,p_pep_id
,p_egt_id
,p_description
,p_effective_end_date
,p_created_by
,p_creation_date
,p_last_updated_by
,p_last_update_date
,p_last_update_login
,p_organization_id
,p_round_up
,p_min_tcard_intvl
,p_use_points_assigned
);

Line: 86

end insert_HXT_EARNING_POLICIES;

Line: 89

procedure update_HXT_EARNING_POLICIES
(p_rowid                      IN VARCHAR2
,p_id                         NUMBER
,p_hcl_id                     NUMBER
,p_fcl_earn_type              VARCHAR2
,p_name                       VARCHAR2
,p_business_group_id          NUMBER  --HXT11i1
,p_effective_start_date       DATE
,p_pip_id                     NUMBER
,p_pep_id                     NUMBER
,p_egt_id                     NUMBER
,p_description                VARCHAR2
,p_effective_end_date         DATE
,p_created_by                 NUMBER
,p_creation_date              DATE
,p_last_updated_by            NUMBER
,p_last_update_date           DATE
,p_last_update_login          NUMBER
,p_organization_id            NUMBER
,p_round_up                   NUMBER
,p_min_tcard_intvl            NUMBER
,p_use_points_assigned        VARCHAR2
) is

begin

UPDATE HXT_EARNING_POLICIES
SET
hcl_id               = p_hcl_id,
fcl_earn_type        = p_fcl_earn_type,
name                 = p_name,
business_group_id    = p_business_group_id,  --HXT11i1
effective_start_date = p_effective_start_date,
pip_id               = p_pip_id,
pep_id               = p_pep_id,
egt_id               = p_egt_id,
description          = p_description,
effective_end_date   = p_effective_end_date,
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,
organization_id      = p_organization_id,
round_up             = p_round_up,
min_tcard_intvl      = p_min_tcard_intvl,
use_points_assigned  = p_use_points_assigned
where rowid          = p_rowid;

Line: 138

end update_HXT_EARNING_POLICIES;

Line: 141

procedure delete_HXT_EARNING_POLICIES(p_rowid VARCHAR2) is
begin
   delete from HXT_EARNING_POLICIES
   where rowid = chartorowid(p_rowid);

Line: 145

end delete_HXT_EARNING_POLICIES;

Line: 151

   select ID into vnull
   from HXT_EARNING_POLICIES
   where rowid = p_rowid
   for update of HXT_EARNING_POLICIES.ID nowait;