DBA Data[Home] [Help]

APPS.FTE_SERVICES_UI_WRAPPER SQL Statements

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

Line: 59

      l_block_data(1)('ACTION') 		:= 'UPDATE';
Line: 150

	  l_break_block_data.DELETE;
Line: 247

        l_line_block_data.DELETE;
Line: 248

        l_break_block_data.DELETE;
Line: 251

      l_block_data.DELETE;
Line: 384

    l_block_data.DELETE;
Line: 458

	l_action := 'UPDATE';
Line: 459

	l_lane_tbl(i).action := 'UPDATE';
Line: 499

	SELECT postal_code_from, postal_code_to
	  INTO l_postal_code_from, l_postal_code_to
	  FROM wsh_regions_tl
	 WHERE region_id = l_lane_tbl(i).origin_id
           AND language = USERENV('LANG');
Line: 506

          l_lane_tbl.DELETE;
Line: 507

          l_lane_rate_chart_tbl.DELETE;
Line: 508

          l_lane_commodity_tbl.DELETE;
Line: 509

          l_lane_service_tbl.DELETE;
Line: 520

      IF (FTE_REGION_ZONE_LOADER.INSERT_PARTY_REGION(p_region_id        => l_lane_tbl(i).origin_id,
				  		     p_parent_region_id => l_lane_tbl(i).origin_id,
				  		     p_supplier_id      => -1,
				  		     p_validate_flag    => TRUE,
				  		     p_postal_code_from => l_postal_code_from_num,
				  		     p_postal_code_to   => l_postal_code_to_num) = -1) THEN

        l_lane_tbl.DELETE;
Line: 528

        l_lane_rate_chart_tbl.DELETE;
Line: 529

        l_lane_commodity_tbl.DELETE;
Line: 530

        l_lane_service_tbl.DELETE;
Line: 542

	SELECT postal_code_from, postal_code_to
	  INTO l_postal_code_from, l_postal_code_to
	  FROM wsh_regions_tl
	 WHERE region_id = l_lane_tbl(i).destination_id
           AND language = USERENV('LANG');
Line: 549

          l_lane_tbl.DELETE;
Line: 550

          l_lane_rate_chart_tbl.DELETE;
Line: 551

          l_lane_commodity_tbl.DELETE;
Line: 552

          l_lane_service_tbl.DELETE;
Line: 562

      IF (FTE_REGION_ZONE_LOADER.INSERT_PARTY_REGION(p_region_id        => l_lane_tbl(i).destination_id,
				  		     p_parent_region_id => l_lane_tbl(i).destination_id,
				  		     p_supplier_id      => -1,
				  		     p_validate_flag    => TRUE,
				  		     p_postal_code_from => l_postal_code_from_num,
				  		     p_postal_code_to   => l_postal_code_to_num) = -1) THEN

        l_lane_tbl.DELETE;
Line: 570

        l_lane_rate_chart_tbl.DELETE;
Line: 571

        l_lane_commodity_tbl.DELETE;
Line: 572

        l_lane_service_tbl.DELETE;
Line: 583

    FTE_LANE_PKG.insert_lane_tables(p_lane_tbl			=> l_lane_tbl,
				    p_lane_rate_chart_tbl	=> l_lane_rate_chart_tbl,
				    p_lane_commodity_tbl	=> l_lane_commodity_tbl,
				    p_lane_service_tbl		=> l_lane_service_tbl,
				    x_status			=> x_status,
				    x_error_msg			=> x_error_msg);
Line: 592

      l_lane_tbl.DELETE;
Line: 593

      l_lane_rate_chart_tbl.DELETE;
Line: 594

      l_lane_commodity_tbl.DELETE;
Line: 595

      l_lane_service_tbl.DELETE;
Line: 627

    l_lane_tbl.DELETE;
Line: 628

    l_lane_rate_chart_tbl.DELETE;
Line: 629

    l_lane_commodity_tbl.DELETE;
Line: 630

    l_lane_service_tbl.DELETE;
Line: 632

    l_rate_line_data.DELETE;