APPS.FTE_ACS_PKG SQL Statements

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

Line: 258

SELECT  delivery_id,
        trip_id,
        rule_id,
        organization_id,
	    initial_pickup_loc_id,
        ultimate_dropoff_loc_id,
        initial_pickup_date,
        ultimate_dropoff_date
FROM    FTE_SEL_SEARCH_ENTITIES_TMP
WHERE   rule_id IS NULL;

Line: 310

					l_fnd_message_name := 'WSH_SELECT_CARRIER_FAIL';

Line: 311

					l_exception_name := 'WSH_SELECT_CARRIER_FAIL';

Line: 393

					FND_MESSAGE.SET_NAME('WSH', 'WSH_SELECT_CARRIER_FAIL');

Line: 394

					l_exception_name := 'WSH_SELECT_CARRIER_FAIL';

Line: 492

SELECT delivery_id,
       trip_id,
       rule_id,
       organization_id,
       initial_pickup_loc_id,
       ultimate_dropoff_loc_id,
       initial_pickup_date,
       ultimate_dropoff_date
FROM   FTE_SEL_SEARCH_ENTITIES_TMP
WHERE  rule_id IS NOT NULL;

Line: 504

SELECT	attribute_value_from_number,
	attribute_value_to_number
FROM	FTE_SEL_RULE_RESTRICTIONS
WHERE   rule_id	= p_rule_id
AND	attribute_name = 'TRANSIT_TIME';

Line: 511

SELECT name
FROM   FTE_SEL_RULES
WHERE  rule_id = p_rule_id;

Line: 925

		FTE_ACS_RULE_UTIL_PKG.INSERT_INTO_GTT( p_input_data	=> p_format_cs_tab,
						       x_return_status  => l_return_status);

Line: 959

	-- Data has been inserted into the GTT or it is there in the record.
	-- For every level - Query the database or use the record.
	--

	--
	-- For a trip sequence followed is-Organization of first stop,Customer Site,Customer,Organization of last stop,Enterprise
	-- For a delivery sequence is - Customer Site, Customer , Organization and Enterprise
	--

	/*l_cnt := 1;

Line: 1016

		l_entity_rule_rec.entity_id_tab.DELETE;

Line: 1017

		l_entity_rule_rec.rule_id_tab.DELETE;

Line: 1020

		-- l_first is index used while doing bulk update
		l_first := l_entity_cnt;

Line: 1070

	    --  Update the GTT with the rule id
	    --
	    IF NOT(l_single_entity) THEN

		IF (p_entity = 'TRIP') THEN
			 FORALL j in l_first .. l_last
				UPDATE FTE_SEL_SEARCH_ENTITIES_TMP
				SET   rule_id  = l_entity_rule_rec.rule_id_tab(j)
				WHERE trip_id  = l_entity_rule_rec.entity_id_tab(j);

Line: 1082

				UPDATE FTE_SEL_SEARCH_ENTITIES_TMP
				SET    rule_id     = l_entity_rule_rec.rule_id_tab(j)
				WHERE  delivery_id = l_entity_rule_rec.entity_id_tab(j);

Line: 1131

	  -- Exceptions are not logged when the action is Select Carrier from Shipping
	  -- Transactions form or Apply Routing Rules from FTE. Only a warning message is shown.
	  --
          IF (p_caller NOT IN('WSH_FSTRX','FTE_MLS_WRAPPER','ORDER_MGMT')) THEN

		LOG_EXCEPTIONS( p_caller     => p_caller,
		 	        p_entity     => p_entity,
 			        p_use_gtt    => l_use_gtt,
 			        p_single_rec => l_entity_rec,
			        x_cs_output_message_tab => x_cs_output_message_tab,
				x_return_status => l_return_status);

Line: 1159

		FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_NO_CARRIER_SELECTED');