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_QUERY_GEN dependencies on FTE_LANE_SEARCH_QUERY_GEN

Line 1: PACKAGE BODY FTE_LANE_SEARCH_QUERY_GEN AS

1: PACKAGE BODY FTE_LANE_SEARCH_QUERY_GEN AS
2: /* $Header: FTELNQYB.pls 120.4 2006/01/23 22:44:22 pkaliyam ship $ */
3:
4: -- global variables
5: g_type1 CONSTANT VARCHAR2(1) := '1';

Line 18: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_LANE_SEARCH_QUERY_GEN';

14:
15: g_bind_counter_global NUMBER;
16:
17: --
18: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_LANE_SEARCH_QUERY_GEN';
19: --
20:
21: -- ----------------------------------------------------------------
22: -- Name: Process_Bind_Var

Line 31: PROCEDURE Process_Bind_Var(p_bindvars IN OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,

27: -- appropriate bind variable array, increments
28: -- the corresponding bind variable counter
29: --
30: -- -----------------------------------------------------------------
31: PROCEDURE Process_Bind_Var(p_bindvars IN OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,
32: p_bindvar IN VARCHAR2,
33: p_bindtype IN VARCHAR2,
34: p_bind_counter_type IN VARCHAR2) IS
35:

Line 36: l_bindvar_type FTE_LANE_SEARCH_QUERY_GEN.bindvar_type;

32: p_bindvar IN VARCHAR2,
33: p_bindtype IN VARCHAR2,
34: p_bind_counter_type IN VARCHAR2) IS
35:
36: l_bindvar_type FTE_LANE_SEARCH_QUERY_GEN.bindvar_type;
37:
38: --
39: l_debug_on BOOLEAN;
40: --

Line 96: PROCEDURE Create_Regions_Clause(p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,

92:
93: -- -----------------------------------------------------------
94: -- forward declaration for procedure Create_Regions_Clause
95: -- -----------------------------------------------------------
96: PROCEDURE Create_Regions_Clause(p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
97: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
98: p_origin_zip_request IN VARCHAR2,
99: p_dest_zip_request IN VARCHAR2,
100: x_query OUT NOCOPY VARCHAR2,

Line 97: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,

93: -- -----------------------------------------------------------
94: -- forward declaration for procedure Create_Regions_Clause
95: -- -----------------------------------------------------------
96: PROCEDURE Create_Regions_Clause(p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
97: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
98: p_origin_zip_request IN VARCHAR2,
99: p_dest_zip_request IN VARCHAR2,
100: x_query OUT NOCOPY VARCHAR2,
101: x_bindvars IN OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars);

Line 101: x_bindvars IN OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars);

97: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
98: p_origin_zip_request IN VARCHAR2,
99: p_dest_zip_request IN VARCHAR2,
100: x_query OUT NOCOPY VARCHAR2,
101: x_bindvars IN OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars);
102:
103: -- ----------------------------------------------------------------
104: -- Name: Create_Lane_Query
105: -- Type: Procedure

Line 114: PROCEDURE Create_Lane_Query(p_search_criteria IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_criteria_rec,

110: -- Returns the relax up and relax down queries,
111: -- and also returns the bind variable arrays.
112: --
113: -- -----------------------------------------------------------------
114: PROCEDURE Create_Lane_Query(p_search_criteria IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_criteria_rec,
115: p_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
116: p_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
117: p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab, -- includes origins
118: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab, -- includes dests

Line 115: p_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,

111: -- and also returns the bind variable arrays.
112: --
113: -- -----------------------------------------------------------------
114: PROCEDURE Create_Lane_Query(p_search_criteria IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_criteria_rec,
115: p_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
116: p_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
117: p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab, -- includes origins
118: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab, -- includes dests
119: p_source_type IN VARCHAR2,

Line 116: p_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,

112: --
113: -- -----------------------------------------------------------------
114: PROCEDURE Create_Lane_Query(p_search_criteria IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_criteria_rec,
115: p_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
116: p_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
117: p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab, -- includes origins
118: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab, -- includes dests
119: p_source_type IN VARCHAR2,
120: x_query1 OUT NOCOPY VARCHAR2,

Line 117: p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab, -- includes origins

113: -- -----------------------------------------------------------------
114: PROCEDURE Create_Lane_Query(p_search_criteria IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_criteria_rec,
115: p_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
116: p_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
117: p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab, -- includes origins
118: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab, -- includes dests
119: p_source_type IN VARCHAR2,
120: x_query1 OUT NOCOPY VARCHAR2,
121: x_query2 OUT NOCOPY VARCHAR2,

Line 118: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab, -- includes dests

114: PROCEDURE Create_Lane_Query(p_search_criteria IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_criteria_rec,
115: p_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
116: p_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
117: p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab, -- includes origins
118: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab, -- includes dests
119: p_source_type IN VARCHAR2,
120: x_query1 OUT NOCOPY VARCHAR2,
121: x_query2 OUT NOCOPY VARCHAR2,
122: x_bindvars1 OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,

Line 122: x_bindvars1 OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,

118: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab, -- includes dests
119: p_source_type IN VARCHAR2,
120: x_query1 OUT NOCOPY VARCHAR2,
121: x_query2 OUT NOCOPY VARCHAR2,
122: x_bindvars1 OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,
123: x_bindvars2 OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,
124: x_bindvars_common OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,
125: x_bindvars_orderby OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,
126: x_return_message OUT NOCOPY VARCHAR2,

Line 123: x_bindvars2 OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,

119: p_source_type IN VARCHAR2,
120: x_query1 OUT NOCOPY VARCHAR2,
121: x_query2 OUT NOCOPY VARCHAR2,
122: x_bindvars1 OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,
123: x_bindvars2 OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,
124: x_bindvars_common OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,
125: x_bindvars_orderby OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,
126: x_return_message OUT NOCOPY VARCHAR2,
127: x_return_status OUT NOCOPY VARCHAR2) IS

Line 124: x_bindvars_common OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,

120: x_query1 OUT NOCOPY VARCHAR2,
121: x_query2 OUT NOCOPY VARCHAR2,
122: x_bindvars1 OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,
123: x_bindvars2 OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,
124: x_bindvars_common OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,
125: x_bindvars_orderby OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,
126: x_return_message OUT NOCOPY VARCHAR2,
127: x_return_status OUT NOCOPY VARCHAR2) IS
128:

Line 125: x_bindvars_orderby OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,

121: x_query2 OUT NOCOPY VARCHAR2,
122: x_bindvars1 OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,
123: x_bindvars2 OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,
124: x_bindvars_common OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,
125: x_bindvars_orderby OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,
126: x_return_message OUT NOCOPY VARCHAR2,
127: x_return_status OUT NOCOPY VARCHAR2) IS
128:
129: -- declare local variables

Line 131: l_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;

127: x_return_status OUT NOCOPY VARCHAR2) IS
128:
129: -- declare local variables
130: l_relax_flag VARCHAR2(1);
131: l_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
132: l_destinations FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
133: l_parent_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
134: l_parent_destinations FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
135: l_origin_zip_request VARCHAR2(30);

Line 132: l_destinations FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;

128:
129: -- declare local variables
130: l_relax_flag VARCHAR2(1);
131: l_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
132: l_destinations FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
133: l_parent_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
134: l_parent_destinations FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
135: l_origin_zip_request VARCHAR2(30);
136: l_dest_zip_request VARCHAR2(30);

Line 133: l_parent_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;

129: -- declare local variables
130: l_relax_flag VARCHAR2(1);
131: l_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
132: l_destinations FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
133: l_parent_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
134: l_parent_destinations FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
135: l_origin_zip_request VARCHAR2(30);
136: l_dest_zip_request VARCHAR2(30);
137: l_mode VARCHAR2(30);

Line 134: l_parent_destinations FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;

130: l_relax_flag VARCHAR2(1);
131: l_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
132: l_destinations FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
133: l_parent_origins FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
134: l_parent_destinations FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
135: l_origin_zip_request VARCHAR2(30);
136: l_dest_zip_request VARCHAR2(30);
137: l_mode VARCHAR2(30);
138: l_lane_number VARCHAR2(30);

Line 172: l_bindvars1 FTE_LANE_SEARCH_QUERY_GEN.bindvars;

168: l_query2 VARCHAR2(32000);
169:
170:
171:
172: l_bindvars1 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
173: l_bindvars2 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
174: l_bindvars_common FTE_LANE_SEARCH_QUERY_GEN.bindvars;
175: l_bindvars_orderby FTE_LANE_SEARCH_QUERY_GEN.bindvars;
176: l_bindvars_schedule FTE_LANE_SEARCH_QUERY_GEN.bindvars;

Line 173: l_bindvars2 FTE_LANE_SEARCH_QUERY_GEN.bindvars;

169:
170:
171:
172: l_bindvars1 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
173: l_bindvars2 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
174: l_bindvars_common FTE_LANE_SEARCH_QUERY_GEN.bindvars;
175: l_bindvars_orderby FTE_LANE_SEARCH_QUERY_GEN.bindvars;
176: l_bindvars_schedule FTE_LANE_SEARCH_QUERY_GEN.bindvars;
177: l_bindvar_type FTE_LANE_SEARCH_QUERY_GEN.bindvar_type;

Line 174: l_bindvars_common FTE_LANE_SEARCH_QUERY_GEN.bindvars;

170:
171:
172: l_bindvars1 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
173: l_bindvars2 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
174: l_bindvars_common FTE_LANE_SEARCH_QUERY_GEN.bindvars;
175: l_bindvars_orderby FTE_LANE_SEARCH_QUERY_GEN.bindvars;
176: l_bindvars_schedule FTE_LANE_SEARCH_QUERY_GEN.bindvars;
177: l_bindvar_type FTE_LANE_SEARCH_QUERY_GEN.bindvar_type;
178:

Line 175: l_bindvars_orderby FTE_LANE_SEARCH_QUERY_GEN.bindvars;

171:
172: l_bindvars1 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
173: l_bindvars2 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
174: l_bindvars_common FTE_LANE_SEARCH_QUERY_GEN.bindvars;
175: l_bindvars_orderby FTE_LANE_SEARCH_QUERY_GEN.bindvars;
176: l_bindvars_schedule FTE_LANE_SEARCH_QUERY_GEN.bindvars;
177: l_bindvar_type FTE_LANE_SEARCH_QUERY_GEN.bindvar_type;
178:
179: l_message VARCHAR2(200);

Line 176: l_bindvars_schedule FTE_LANE_SEARCH_QUERY_GEN.bindvars;

172: l_bindvars1 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
173: l_bindvars2 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
174: l_bindvars_common FTE_LANE_SEARCH_QUERY_GEN.bindvars;
175: l_bindvars_orderby FTE_LANE_SEARCH_QUERY_GEN.bindvars;
176: l_bindvars_schedule FTE_LANE_SEARCH_QUERY_GEN.bindvars;
177: l_bindvar_type FTE_LANE_SEARCH_QUERY_GEN.bindvar_type;
178:
179: l_message VARCHAR2(200);
180: l_status VARCHAR2(1);

Line 177: l_bindvar_type FTE_LANE_SEARCH_QUERY_GEN.bindvar_type;

173: l_bindvars2 FTE_LANE_SEARCH_QUERY_GEN.bindvars;
174: l_bindvars_common FTE_LANE_SEARCH_QUERY_GEN.bindvars;
175: l_bindvars_orderby FTE_LANE_SEARCH_QUERY_GEN.bindvars;
176: l_bindvars_schedule FTE_LANE_SEARCH_QUERY_GEN.bindvars;
177: l_bindvar_type FTE_LANE_SEARCH_QUERY_GEN.bindvar_type;
178:
179: l_message VARCHAR2(200);
180: l_status VARCHAR2(1);
181: x_status NUMBER;

Line 734: PROCEDURE Create_Regions_Clause(p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,

730: -- This is also used by Rate Chart Search, which is why it is
731: -- separated out from Create_Lane_Query.
732: --
733: -- -----------------------------------------------------------------
734: PROCEDURE Create_Regions_Clause(p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
735: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
736: p_origin_zip_request IN VARCHAR2,
737: p_dest_zip_request IN VARCHAR2,
738: x_query OUT NOCOPY VARCHAR2,

Line 735: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,

731: -- separated out from Create_Lane_Query.
732: --
733: -- -----------------------------------------------------------------
734: PROCEDURE Create_Regions_Clause(p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
735: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
736: p_origin_zip_request IN VARCHAR2,
737: p_dest_zip_request IN VARCHAR2,
738: x_query OUT NOCOPY VARCHAR2,
739: x_bindvars IN OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars) IS

Line 739: x_bindvars IN OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars) IS

735: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
736: p_origin_zip_request IN VARCHAR2,
737: p_dest_zip_request IN VARCHAR2,
738: x_query OUT NOCOPY VARCHAR2,
739: x_bindvars IN OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars) IS
740:
741: l_query VARCHAR2(4000);
742: l_counter NUMBER;
743:

Line 859: PROCEDURE Create_Schedule_Query(p_search_criteria IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_criteria_rec,

855: -- passed in via p_search_criteria.lane_ids_list.
856: -- Returns bind variable array and query string.
857: --
858: -- -----------------------------------------------------------------
859: PROCEDURE Create_Schedule_Query(p_search_criteria IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_criteria_rec,
860: p_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
861: p_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
862: p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
863: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,

Line 860: p_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,

856: -- Returns bind variable array and query string.
857: --
858: -- -----------------------------------------------------------------
859: PROCEDURE Create_Schedule_Query(p_search_criteria IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_criteria_rec,
860: p_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
861: p_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
862: p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
863: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
864: x_query OUT NOCOPY VARCHAR2,

Line 861: p_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,

857: --
858: -- -----------------------------------------------------------------
859: PROCEDURE Create_Schedule_Query(p_search_criteria IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_criteria_rec,
860: p_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
861: p_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
862: p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
863: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
864: x_query OUT NOCOPY VARCHAR2,
865: x_bindvars OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,

Line 862: p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,

858: -- -----------------------------------------------------------------
859: PROCEDURE Create_Schedule_Query(p_search_criteria IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_criteria_rec,
860: p_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
861: p_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
862: p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
863: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
864: x_query OUT NOCOPY VARCHAR2,
865: x_bindvars OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,
866: x_return_message OUT NOCOPY VARCHAR2,

Line 863: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,

859: PROCEDURE Create_Schedule_Query(p_search_criteria IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_criteria_rec,
860: p_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
861: p_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
862: p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
863: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
864: x_query OUT NOCOPY VARCHAR2,
865: x_bindvars OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,
866: x_return_message OUT NOCOPY VARCHAR2,
867: x_return_status OUT NOCOPY VARCHAR2) IS

Line 865: x_bindvars OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,

861: p_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
862: p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
863: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
864: x_query OUT NOCOPY VARCHAR2,
865: x_bindvars OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,
866: x_return_message OUT NOCOPY VARCHAR2,
867: x_return_status OUT NOCOPY VARCHAR2) IS
868:
869: l_query VARCHAR2(8000);

Line 872: l_bindvars FTE_LANE_SEARCH_QUERY_GEN.bindvars;

868:
869: l_query VARCHAR2(8000);
870: l_query_dates VARCHAR2(8000);
871:
872: l_bindvars FTE_LANE_SEARCH_QUERY_GEN.bindvars;
873: l_message VARCHAR2(200);
874: l_status VARCHAR2(1);
875:
876: --

Line 996: x_bindvars IN OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,

992: p_dep_date_to IN DATE,
993: p_arr_date_from IN DATE,
994: p_arr_date_to IN DATE,
995: x_query OUT NOCOPY VARCHAR2,
996: x_bindvars IN OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars,
997: x_return_message OUT NOCOPY VARCHAR2,
998: x_return_status OUT NOCOPY VARCHAR2) IS
999:
1000: l_query VARCHAR2(8000);

Line 1752: PROCEDURE Create_Rate_Chart_Query(p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,

1748: -- which match the criteria.
1749: -- Returns the bind variable array and query.
1750: --
1751: -- -----------------------------------------------------------------
1752: PROCEDURE Create_Rate_Chart_Query(p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
1753: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
1754: p_origin_zip_request IN VARCHAR2,
1755: p_dest_zip_request IN VARCHAR2,
1756: p_carrier_name IN VARCHAR2,

Line 1753: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,

1749: -- Returns the bind variable array and query.
1750: --
1751: -- -----------------------------------------------------------------
1752: PROCEDURE Create_Rate_Chart_Query(p_parent_origins IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
1753: p_parent_destinations IN FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab,
1754: p_origin_zip_request IN VARCHAR2,
1755: p_dest_zip_request IN VARCHAR2,
1756: p_carrier_name IN VARCHAR2,
1757: p_tariff_name IN VARCHAR2,

Line 1759: x_bindvars OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars) IS

1755: p_dest_zip_request IN VARCHAR2,
1756: p_carrier_name IN VARCHAR2,
1757: p_tariff_name IN VARCHAR2,
1758: x_query OUT NOCOPY VARCHAR2,
1759: x_bindvars OUT NOCOPY FTE_LANE_SEARCH_QUERY_GEN.bindvars) IS
1760:
1761: l_query VARCHAR2(5000);
1762: l_reg_query VARCHAR2(4000);
1763:

Line 1764: l_bindvars FTE_LANE_SEARCH_QUERY_GEN.bindvars;

1760:
1761: l_query VARCHAR2(5000);
1762: l_reg_query VARCHAR2(4000);
1763:
1764: l_bindvars FTE_LANE_SEARCH_QUERY_GEN.bindvars;
1765:
1766: --
1767: l_debug_on BOOLEAN;
1768: --

Line 1867: END FTE_LANE_SEARCH_QUERY_GEN;

1863: --
1864: END Create_Rate_Chart_Query;
1865:
1866:
1867: END FTE_LANE_SEARCH_QUERY_GEN;