The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT entity_group_id FROM hxc_entity_groups
WHERE entity_type = l_p_entity_type and name = l_p_name;
SELECT entity_group_id,
entity_type,
object_version_number,
DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
INTO
l_entity_group_id,
l_entity_type ,
l_ovn,
l_owner
FROM hxc_entity_groups
WHERE name = p_name and entity_type = p_entity_type;
-- only update if the entity type has actually changed
IF ( ( p_entity_type <> l_entity_type ) )
THEN
hxc_heg_upd.upd
(p_entity_group_id => l_entity_group_id
,p_object_version_number => l_ovn
,p_name => p_name
,p_entity_type => p_entity_type
) ;
SELECT
entity_group_comp_id,
OBJECT_VERSION_NUMBER,
DECODE( NVL(last_updated_by,-1),1, 'SEED', 'CUSTOM')
INTO
l_entity_group_comp_id,
l_object_version_number,
l_owner
FROM hxc_entity_group_comps
WHERE entity_group_id = l_entity_group_id
AND attribute_category = P_ATTRIBUTE_CATEGORY;
,p_last_update_date IN VARCHAR2) IS
l_entity_group_id HXC_ENTITY_GROUPS.ENTITY_GROUP_ID%TYPE;
l_last_update_date_db HXC_ENTITY_GROUPS.last_update_date%TYPE;
l_last_updated_by_db HXC_ENTITY_GROUPS.last_updated_by%TYPE;
l_last_updated_by_f HXC_ENTITY_GROUPS.last_updated_by%TYPE;
l_last_update_date_f HXC_ENTITY_GROUPS.last_update_date%TYPE;
l_last_updated_by_f := fnd_load_util.owner_id(p_owner);
l_last_update_date_f := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
SELECT entity_group_id,
entity_type,
object_version_number
,last_update_date
,last_updated_by
INTO
l_entity_group_id,
l_entity_type ,
l_ovn
,l_last_update_date_db
,l_last_updated_by_db
FROM hxc_entity_groups
WHERE name = p_name and entity_type = p_entity_type;
IF (fnd_load_util.upload_test( l_last_updated_by_f,
l_last_update_date_f,
l_last_updated_by_db,
l_last_update_date_db ,
p_custom_mode))
THEN
-- only update if the entity type has actually changed
IF ( ( p_entity_type <> l_entity_type ) )
THEN
hxc_heg_upd.upd
(p_entity_group_id => l_entity_group_id
,p_object_version_number => l_ovn
,p_name => p_name
,p_entity_type => p_entity_type
) ;
,p_last_update_date IN VARCHAR2) IS
l_entity_group_comp_id HXC_ENTITY_GROUP_COMPS.ENTITY_GROUP_comp_ID%TYPE;
l_last_update_date_db HXC_ENTITY_GROUP_COMPS.last_update_date%TYPE;
l_last_updated_by_db HXC_ENTITY_GROUP_COMPS.last_updated_by%TYPE;
l_last_updated_by_f HXC_ENTITY_GROUP_COMPS.last_updated_by%TYPE;
l_last_update_date_f HXC_ENTITY_GROUP_COMPS.last_update_date%TYPE;
l_last_updated_by_f := fnd_load_util.owner_id(p_owner);
l_last_update_date_f := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
SELECT
entity_group_comp_id,
OBJECT_VERSION_NUMBER
,last_update_date
,last_updated_by
INTO
l_entity_group_comp_id,
l_object_version_number
,l_last_update_date_db
,l_last_updated_by_db
FROM hxc_entity_group_comps
WHERE entity_group_id = l_entity_group_id
AND attribute_category = P_ATTRIBUTE_CATEGORY;
IF (fnd_load_util.upload_test( l_last_updated_by_f,
l_last_update_date_f,
l_last_updated_by_db,
l_last_update_date_db ,
p_custom_mode))
THEN
if g_debug then
hr_utility.trace('Starting to upd --');