APPS.FTE_ACS_CACHE_PKG SQL Statements

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

Line: 461

PROCEDURE delete_rule_caches( x_return_status OUT NOCOPY VARCHAR2)
IS

   l_debug_on          CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

Line: 465

   l_module_name       CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'delete_rule_caches';

Line: 475

   g_groups_cache.DELETE;

Line: 476

   g_weight_cache.DELETE;

Line: 477

   g_volume_cache.DELETE;

Line: 478

   g_transit_cache.DELETE;

Line: 479

   g_from_postal_cache.DELETE;

Line: 480

   g_to_postal_cache.DELETE;

Line: 481

   g_fob_cache.DELETE;

Line: 484

        WSH_DEBUG_SV.logmsg(l_module_name,'CACHES DELETED');

Line: 491

      WSH_UTIL_CORE.default_handler('FTE_ACS_CACHE_PKG.DELETE_RULE_CACHES');

Line: 499

END delete_rule_caches;

Line: 534

       delete_rule_caches(x_return_status => x_return_status);

Line: 753

SELECT attribute_name,attribute_uom_code
FROM   fte_sel_group_attributes
WHERE  group_id = p_group_id;

Line: 1151

SELECT  rule_id,
        attribute_name,
        attribute_value_From,
        attribute_value_to,
        attribute_value_from_number,
        attribute_value_to_number,
	range_overlap_flag
FROM    fte_sel_rule_restrictions
WHERE   group_id = p_group_id
ORDER BY rule_id;

Line: 1226

	  DELETE_RULE_CACHES(x_return_status => x_return_status);

Line: 1258

		-- Delete Rule Tab and query again.
		--
		rule_tab.DELETE;

Line: 2595

	sql_string := 'SELECT rule_id FROM '
              || ' (SELECT rule_id'
		      || ' FROM FTE_SEL_RULE_RESTRICTIONS '
		      || ' WHERE attribute_name=''TRANSIT_TIME'' '--AND ROWNUM=1'
		      || ' AND rule_id IN ('
		      || l_rule_str
		      || ')'
		      || ' ORDER BY attribute_value_to_number)'
              || ' WHERE ROWNUM=1';

Line: 2669

	SELECT name
	FROM   FTE_SEL_GROUPS
	WHERE  group_id = p_group_id;

Line: 3250

				-- In all the selected rules, find the rule that has minimum maximum transit time
				-- (If only 1 rule then do nothing)
				--

				IF l_debug_on THEN
		 		   wsh_debug_sv.logmsg(l_module_name,'Searching min high transit time ');

Line: 4010

select fsras.result_id
from   fte_sel_result_assignments fsras
where  fsras.rule_id = p_rule_id;

Line: 4018

select fsra.attribute_code,
       fsra.attribute_value
from   fte_sel_result_attributes fsra
where  fsra.result_id = p_result_id;

Line: 4071

			l_attr_tab.DELETE;