APPS.HXC_TEMPLATE_SUMMARY_API SQL Statements

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

Line: 12

select resource_id
  into l_resource_id
  from hxc_template_summary
 where template_id = p_template_id;

Line: 24

PROCEDURE DELETE_TEMPLATE
            (
		p_template_id in number
            ) is

l_index number;

Line: 44

	hxc_template_summary_pkg.delete_summary_row
	  (p_template_id => p_template_id);

Line: 48

END DELETE_TEMPLATE;

Line: 59

	is SELECT
            a.attribute_category
            ,a.attribute1
            ,a.attribute2
            ,a.attribute3
            ,a.attribute4
            ,a.attribute5
            ,a.attribute6
            ,a.attribute7
            ,a.attribute8
            ,a.attribute9
            ,a.attribute10
            ,a.attribute11
            ,a.attribute12
            ,a.attribute13
            ,a.attribute14
       FROM hxc_time_attributes a,
            hxc_time_attribute_usages au,
            hxc_bld_blk_info_types bbit
      WHERE au.time_building_block_id = p_template_id
        AND au.time_building_block_ovn = p_template_ovn
        AND au.time_attribute_id = a.time_attribute_id
        AND ( (a.attribute_category = 'TEMPLATES')
        OR (a.attribute_category = 'SECURITY')
        OR (a.attribute_category = 'LAYOUT'))
	AND a.bld_blk_info_type_id = bbit.bld_blk_info_type_id;

Line: 102

	hxc_template_summary_pkg.delete_summary_row
		(p_template_id => p_template_id);

Line: 127

hxc_template_summary_pkg.insert_summary_row
	  (p_template_id => p_template_id,
  	   p_template_ovn => p_template_ovn,
	   p_template_name =>l_template_name,
	   p_description =>l_description,
	   p_template_type =>l_template_type,
	   p_layout_id => l_layout_id,
	   p_recurring_period_id =>l_recurring_period,
	   p_business_group_id =>l_business_group_id,
	   p_resource_id => NULL
	  );

Line: 173

	hxc_template_summary_pkg.delete_summary_row
		(p_template_id => p_template_id);

Line: 206

hxc_template_summary_pkg.insert_summary_row
	  (p_template_id => p_blocks(l_timecard_index).time_building_block_id,
  	   p_template_ovn => p_blocks(l_timecard_index).OBJECT_VERSION_NUMBER,
	   p_template_name =>l_template_name,
	   p_description =>l_description,
	   p_template_type =>l_template_type,
	   p_layout_id => l_layout_id,
	   p_recurring_period_id =>l_recurring_period,
	   p_business_group_id =>l_business_group_id,
	   p_resource_id => fnd_global.employee_id
	  );