eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_LANE_SEARCH dependencies on FTE_LANE_SEARCH

Line 1: PACKAGE BODY FTE_LANE_SEARCH AS

1: PACKAGE BODY FTE_LANE_SEARCH AS
2: /* $Header: FTELNSEB.pls 120.2 2006/05/02 00:51:21 jnpinto ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_LANE_SEARCH';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_LANE_SEARCH';

1: PACKAGE BODY FTE_LANE_SEARCH AS
2: /* $Header: FTELNSEB.pls 120.2 2006/05/02 00:51:21 jnpinto ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_LANE_SEARCH';
6: --
7:
8: g_message VARCHAR2(12000);
9:

Line 26: x_regions OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,

22: p_country IN VARCHAR2,
23: p_state IN VARCHAR2,
24: p_city IN VARCHAR2,
25: p_zip IN OUT NOCOPY VARCHAR2,
26: x_regions OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
27: x_parent_regions OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab) IS
28:
29: l_region_and_type FTE_LANE_SEARCH_QUERY_GEN.fte_regions_types;
30: l_country VARCHAR2(60) := null;

Line 27: x_parent_regions OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab) IS

23: p_state IN VARCHAR2,
24: p_city IN VARCHAR2,
25: p_zip IN OUT NOCOPY VARCHAR2,
26: x_regions OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
27: x_parent_regions OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab) IS
28:
29: l_region_and_type FTE_LANE_SEARCH_QUERY_GEN.fte_regions_types;
30: l_country VARCHAR2(60) := null;
31: l_country_code VARCHAR2(10) := null;

Line 29: l_region_and_type FTE_LANE_SEARCH_QUERY_GEN.fte_regions_types;

25: p_zip IN OUT NOCOPY VARCHAR2,
26: x_regions OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
27: x_parent_regions OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab) IS
28:
29: l_region_and_type FTE_LANE_SEARCH_QUERY_GEN.fte_regions_types;
30: l_country VARCHAR2(60) := null;
31: l_country_code VARCHAR2(10) := null;
32: l_state VARCHAR2(60) := null;
33: l_state_code VARCHAR2(10) := null;

Line 41: l_regions FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;

37: l_status NUMBER;
38: l_regions_temp WSH_REGIONS_SEARCH_PKG.region_table;
39: l_region WSH_REGIONS_SEARCH_PKG.region_rec;
40:
41: l_regions FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
42: l_parent_regions FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
43:
44: CURSOR get_postal_code(p_loc_id NUMBER) IS
45: SELECT postal_code FROM wsh_locations

Line 42: l_parent_regions FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;

38: l_regions_temp WSH_REGIONS_SEARCH_PKG.region_table;
39: l_region WSH_REGIONS_SEARCH_PKG.region_rec;
40:
41: l_regions FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
42: l_parent_regions FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
43:
44: CURSOR get_postal_code(p_loc_id NUMBER) IS
45: SELECT postal_code FROM wsh_locations
46: WHERE wsh_location_id = p_loc_id;

Line 337: p_bindvars IN FTE_LANE_SEARCH_QUERY_GEN.bindvars) IS

333: -- using dbms_sql, given a cursor_id.
334: --
335: -- -----------------------------------------------------------------
336: PROCEDURE Bind_Vars(p_cursor_id IN NUMBER,
337: p_bindvars IN FTE_LANE_SEARCH_QUERY_GEN.bindvars) IS
338:
339: --
340: l_debug_on BOOLEAN;
341: --

Line 614: -- Description: This procedure calls FTE_LANE_SEARCH_QUERY_GEN

610: -- ----------------------------------------------------------------
611: -- Name: Search_Lanes
612: -- Type: Procedure
613: --
614: -- Description: This procedure calls FTE_LANE_SEARCH_QUERY_GEN
615: -- procedures to create the dynamic SQL.
616: -- Binds the variables, executes the query, and
617: -- prepares the results in SQL records and SQL
618: -- types for returning to the calling procedure.

Line 642: l_search_criteria FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_criteria_rec;

638: x_schedule_results OUT NOCOPY fte_schedule_tab,
639: x_return_message OUT NOCOPY VARCHAR2,
640: x_return_status OUT NOCOPY VARCHAR2) IS
641:
642: l_search_criteria FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_criteria_rec;
643: l_origin_zip VARCHAR2(30) := null;
644: l_destination_zip VARCHAR2(30) := null;
645:
646: l_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;

Line 646: l_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;

642: l_search_criteria FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_criteria_rec;
643: l_origin_zip VARCHAR2(30) := null;
644: l_destination_zip VARCHAR2(30) := null;
645:
646: l_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
647: l_destinations FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
648: l_parent_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
649: l_parent_dests FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
650:

Line 647: l_destinations FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;

643: l_origin_zip VARCHAR2(30) := null;
644: l_destination_zip VARCHAR2(30) := null;
645:
646: l_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
647: l_destinations FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
648: l_parent_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
649: l_parent_dests FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
650:
651:

Line 648: l_parent_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;

644: l_destination_zip VARCHAR2(30) := null;
645:
646: l_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
647: l_destinations FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
648: l_parent_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
649: l_parent_dests FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
650:
651:
652: l_query1 VARCHAR2(32000);

Line 649: l_parent_dests FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;

645:
646: l_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
647: l_destinations FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
648: l_parent_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
649: l_parent_dests FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
650:
651:
652: l_query1 VARCHAR2(32000);
653: l_query2 VARCHAR2(32000);

Line 655: l_bindvars1 FTE_LANE_SEARCH_QUERY_GEN.bindvars;

651:
652: l_query1 VARCHAR2(32000);
653: l_query2 VARCHAR2(32000);
654:
655: l_bindvars1 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
656: l_bindvars2 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
657: l_bindvars3 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
658: l_bindvars4 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
659:

Line 656: l_bindvars2 FTE_LANE_SEARCH_QUERY_GEN.bindvars;

652: l_query1 VARCHAR2(32000);
653: l_query2 VARCHAR2(32000);
654:
655: l_bindvars1 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
656: l_bindvars2 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
657: l_bindvars3 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
658: l_bindvars4 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
659:
660: l_status VARCHAR2(1);

Line 657: l_bindvars3 FTE_LANE_SEARCH_QUERY_GEN.bindvars;

653: l_query2 VARCHAR2(32000);
654:
655: l_bindvars1 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
656: l_bindvars2 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
657: l_bindvars3 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
658: l_bindvars4 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
659:
660: l_status VARCHAR2(1);
661: l_msg VARCHAR2(2000);

Line 658: l_bindvars4 FTE_LANE_SEARCH_QUERY_GEN.bindvars;

654:
655: l_bindvars1 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
656: l_bindvars2 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
657: l_bindvars3 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
658: l_bindvars4 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
659:
660: l_status VARCHAR2(1);
661: l_msg VARCHAR2(2000);
662:

Line 979: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_LANE_SEARCH_QUERY_GEN.CREATE_LANE_QUERY',WSH_DEBUG_SV.C_PROC_LEVEL);

975: --
976: -- Debug Statements
977: --
978: IF l_debug_on THEN
979: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_LANE_SEARCH_QUERY_GEN.CREATE_LANE_QUERY',WSH_DEBUG_SV.C_PROC_LEVEL);
980: END IF;
981: --
982: FTE_LANE_SEARCH_QUERY_GEN.Create_Lane_Query(p_search_criteria => l_search_criteria,
983: p_origins => l_origins,

Line 982: FTE_LANE_SEARCH_QUERY_GEN.Create_Lane_Query(p_search_criteria => l_search_criteria,

978: IF l_debug_on THEN
979: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_LANE_SEARCH_QUERY_GEN.CREATE_LANE_QUERY',WSH_DEBUG_SV.C_PROC_LEVEL);
980: END IF;
981: --
982: FTE_LANE_SEARCH_QUERY_GEN.Create_Lane_Query(p_search_criteria => l_search_criteria,
983: p_origins => l_origins,
984: p_destinations => l_destinations,
985: p_parent_origins => l_parent_origins,
986: p_parent_destinations => l_parent_dests,

Line 1693: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_LANE_SEARCH_QUERY_GEN.CREATE_SCHEDULE_QUERY',WSH_DEBUG_SV.C_PROC_LEVEL);

1689: --
1690: -- Debug Statements
1691: --
1692: IF l_debug_on THEN
1693: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_LANE_SEARCH_QUERY_GEN.CREATE_SCHEDULE_QUERY',WSH_DEBUG_SV.C_PROC_LEVEL);
1694: END IF;
1695: --
1696: FTE_LANE_SEARCH_QUERY_GEN.Create_Schedule_Query(p_search_criteria => l_search_criteria,
1697: p_origins => l_origins,

Line 1696: FTE_LANE_SEARCH_QUERY_GEN.Create_Schedule_Query(p_search_criteria => l_search_criteria,

1692: IF l_debug_on THEN
1693: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_LANE_SEARCH_QUERY_GEN.CREATE_SCHEDULE_QUERY',WSH_DEBUG_SV.C_PROC_LEVEL);
1694: END IF;
1695: --
1696: FTE_LANE_SEARCH_QUERY_GEN.Create_Schedule_Query(p_search_criteria => l_search_criteria,
1697: p_origins => l_origins,
1698: p_destinations => l_destinations,
1699: p_parent_origins => l_parent_origins,
1700: p_parent_destinations => l_parent_dests,

Line 2032: l_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;

2028: l_origin_zip VARCHAR2(30) := null;
2029: l_destination_zip VARCHAR2(30) := null;
2030: l_carrier_name VARCHAR2(30) := null;
2031: l_tariff_name VARCHAR2(80) := null;
2032: l_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
2033: l_destinations FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
2034: l_parent_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
2035: l_parent_dests FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
2036:

Line 2033: l_destinations FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;

2029: l_destination_zip VARCHAR2(30) := null;
2030: l_carrier_name VARCHAR2(30) := null;
2031: l_tariff_name VARCHAR2(80) := null;
2032: l_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
2033: l_destinations FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
2034: l_parent_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
2035: l_parent_dests FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
2036:
2037: l_query VARCHAR2(5000);

Line 2034: l_parent_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;

2030: l_carrier_name VARCHAR2(30) := null;
2031: l_tariff_name VARCHAR2(80) := null;
2032: l_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
2033: l_destinations FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
2034: l_parent_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
2035: l_parent_dests FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
2036:
2037: l_query VARCHAR2(5000);
2038: l_bindvars FTE_LANE_SEARCH_QUERY_GEN.bindvars;

Line 2035: l_parent_dests FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;

2031: l_tariff_name VARCHAR2(80) := null;
2032: l_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
2033: l_destinations FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
2034: l_parent_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
2035: l_parent_dests FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
2036:
2037: l_query VARCHAR2(5000);
2038: l_bindvars FTE_LANE_SEARCH_QUERY_GEN.bindvars;
2039: l_cursor_id NUMBER;

Line 2038: l_bindvars FTE_LANE_SEARCH_QUERY_GEN.bindvars;

2034: l_parent_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
2035: l_parent_dests FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
2036:
2037: l_query VARCHAR2(5000);
2038: l_bindvars FTE_LANE_SEARCH_QUERY_GEN.bindvars;
2039: l_cursor_id NUMBER;
2040: l_counter NUMBER;
2041: l_rows_affected NUMBER;
2042: l_rows_fetched NUMBER := 0;

Line 2106: FTE_LANE_SEARCH_QUERY_GEN.Create_Rate_Chart_Query(

2102: THEN
2103: x_rate_chart_ids := l_rate_chart_tab;
2104: RETURN;
2105: END IF;
2106: FTE_LANE_SEARCH_QUERY_GEN.Create_Rate_Chart_Query(
2107: p_parent_origins =>l_parent_origins,
2108: p_parent_destinations =>l_parent_dests,
2109: p_origin_zip_request =>l_origin_zip,
2110: p_dest_zip_request =>l_destination_zip,

Line 2164: END FTE_LANE_SEARCH;

2160: END IF;
2161: --
2162: END Get_Rate_Chart_Ids;
2163:
2164: END FTE_LANE_SEARCH;