APPS.HXC_LAYOUT_UTILS_PKG SQL Statements

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

Line: 16

SELECT  SUBSTRB(q.qualifier_attribute26,1,30) attribute_category,
        UPPER(SUBSTRB(q.qualifier_attribute27,1,30)) attribute
FROM
	hxc_layout_components c,
	hxc_layout_comp_qualifiers q
WHERE
	c.layout_id = p_layout_id
AND
	q.layout_component_id   = c.layout_component_id AND
	q.qualifier_attribute25 = 'FLEX' AND
	q.qualifier_attribute_category in ('LOV','CHOICE_LIST','PACKAGE_CHOICE_LIST','TEXT_FIELD','DESCRIPTIVE_FLEX');

Line: 29

SELECT	SUBSTRB(bbit.bld_blk_info_type,1,40) attribute_category,
	UPPER(SUBSTRB(mc.segment,1,30)) attribute
FROM
	hxc_alias_definitions ad,
        hxc_alias_types hat,
        hxc_alias_type_components atc,
        hxc_mapping_components mc,
        hxc_bld_blk_info_types bbit
WHERE
	ad.alias_definition_id = p_alias_definition_id
   and ad.alias_type_id = hat.alias_type_id
   and hat.alias_type = 'OTL_ALT_DDF'
   and atc.alias_type_id = hat.alias_type_id
   and atc.mapping_component_id = mc.mapping_component_id
   and bbit.bld_blk_info_type_id = mc.bld_blk_info_type_id;

Line: 144

FUNCTION update_ok ( p_att_rec   IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes
                   , p_comps_tab IN            components_tab ) RETURN BOOLEAN IS

BEGIN



IF g_debug THEN
	hr_utility.trace('In update ok');

Line: 167

			hr_utility.trace('Cannot update !!!!');

Line: 180

	   	hr_utility.trace('Can not update attribute category!');

Line: 188

	hr_utility.trace('Can update !!!!');

Line: 193

END update_ok;

Line: 211

	IF ( update_ok ( p_attributes(l_att_ind)
                       , l_comps_tab ) )
	THEN

		p_attributes(l_att_ind).attribute_value := NULL;