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.WSH_EXTREPS_MLS_LANG dependencies on DBMS_SQL

Line 176: l_CursorID := DBMS_SQL.OPEN_CURSOR;

172: v_SelectStmt := v_SelectStmt||' AND wdl.delivery_leg_id = :p_delivery_leg_id';
173: END IF;
174:
175: -- Open the cursor for processing
176: l_CursorID := DBMS_SQL.OPEN_CURSOR;
177:
178: -- Parse the query
179: DBMS_SQL.PARSE(l_CursorID, v_SelectStmt, DBMS_SQL.V7);
180:

Line 179: DBMS_SQL.PARSE(l_CursorID, v_SelectStmt, DBMS_SQL.V7);

175: -- Open the cursor for processing
176: l_CursorID := DBMS_SQL.OPEN_CURSOR;
177:
178: -- Parse the query
179: DBMS_SQL.PARSE(l_CursorID, v_SelectStmt, DBMS_SQL.V7);
180:
181: -- Bind input variables
182: IF p_doc_param_info.p_organization_id IS NOT NULL THEN
183: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_organization_id',p_doc_param_info.p_organization_id);

Line 183: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_organization_id',p_doc_param_info.p_organization_id);

179: DBMS_SQL.PARSE(l_CursorID, v_SelectStmt, DBMS_SQL.V7);
180:
181: -- Bind input variables
182: IF p_doc_param_info.p_organization_id IS NOT NULL THEN
183: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_organization_id',p_doc_param_info.p_organization_id);
184: END IF;
185: IF p_doc_param_info.p_trip_id IS NOT NULL THEN
186: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_trip_id',p_doc_param_info.p_trip_id);
187: END IF;

Line 186: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_trip_id',p_doc_param_info.p_trip_id);

182: IF p_doc_param_info.p_organization_id IS NOT NULL THEN
183: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_organization_id',p_doc_param_info.p_organization_id);
184: END IF;
185: IF p_doc_param_info.p_trip_id IS NOT NULL THEN
186: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_trip_id',p_doc_param_info.p_trip_id);
187: END IF;
188: IF p_doc_param_info.p_trip_stop_id IS NOT NULL THEN
189: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_trip_stop_id',p_doc_param_info.p_trip_stop_id);
190: END IF;

Line 189: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_trip_stop_id',p_doc_param_info.p_trip_stop_id);

185: IF p_doc_param_info.p_trip_id IS NOT NULL THEN
186: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_trip_id',p_doc_param_info.p_trip_id);
187: END IF;
188: IF p_doc_param_info.p_trip_stop_id IS NOT NULL THEN
189: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_trip_stop_id',p_doc_param_info.p_trip_stop_id);
190: END IF;
191: IF p_doc_param_info.p_departure_date_low IS NOT NULL THEN
192: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_departure_date_low',p_doc_param_info.p_departure_date_low);
193: END IF;

Line 192: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_departure_date_low',p_doc_param_info.p_departure_date_low);

188: IF p_doc_param_info.p_trip_stop_id IS NOT NULL THEN
189: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_trip_stop_id',p_doc_param_info.p_trip_stop_id);
190: END IF;
191: IF p_doc_param_info.p_departure_date_low IS NOT NULL THEN
192: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_departure_date_low',p_doc_param_info.p_departure_date_low);
193: END IF;
194: IF p_doc_param_info.p_departure_date_high IS NOT NULL THEN
195: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_departure_date_high',p_doc_param_info.p_departure_date_high);
196: END IF;

Line 195: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_departure_date_high',p_doc_param_info.p_departure_date_high);

191: IF p_doc_param_info.p_departure_date_low IS NOT NULL THEN
192: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_departure_date_low',p_doc_param_info.p_departure_date_low);
193: END IF;
194: IF p_doc_param_info.p_departure_date_high IS NOT NULL THEN
195: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_departure_date_high',p_doc_param_info.p_departure_date_high);
196: END IF;
197: IF p_doc_param_info.p_freight_carrier IS NOT NULL AND p_prog_name <> 'WSHRDPAK' THEN
198: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_freight_carrier',p_doc_param_info.p_freight_carrier);
199: END IF;

Line 198: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_freight_carrier',p_doc_param_info.p_freight_carrier);

194: IF p_doc_param_info.p_departure_date_high IS NOT NULL THEN
195: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_departure_date_high',p_doc_param_info.p_departure_date_high);
196: END IF;
197: IF p_doc_param_info.p_freight_carrier IS NOT NULL AND p_prog_name <> 'WSHRDPAK' THEN
198: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_freight_carrier',p_doc_param_info.p_freight_carrier);
199: END IF;
200: IF p_doc_param_info.p_delivery_id IS NOT NULL THEN
201: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_delivery_id',p_doc_param_info.p_delivery_id);
202: END IF;

Line 201: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_delivery_id',p_doc_param_info.p_delivery_id);

197: IF p_doc_param_info.p_freight_carrier IS NOT NULL AND p_prog_name <> 'WSHRDPAK' THEN
198: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_freight_carrier',p_doc_param_info.p_freight_carrier);
199: END IF;
200: IF p_doc_param_info.p_delivery_id IS NOT NULL THEN
201: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_delivery_id',p_doc_param_info.p_delivery_id);
202: END IF;
203: IF p_prog_name = 'WSHRDPAK' THEN
204: IF p_doc_param_info.p_delivery_date_low IS NOT NULL THEN
205: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_delivery_date_low',p_doc_param_info.p_delivery_date_low);

Line 205: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_delivery_date_low',p_doc_param_info.p_delivery_date_low);

201: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_delivery_id',p_doc_param_info.p_delivery_id);
202: END IF;
203: IF p_prog_name = 'WSHRDPAK' THEN
204: IF p_doc_param_info.p_delivery_date_low IS NOT NULL THEN
205: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_delivery_date_low',p_doc_param_info.p_delivery_date_low);
206: END IF;
207: IF p_doc_param_info.p_delivery_date_high IS NOT NULL THEN
208: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_delivery_date_high',p_doc_param_info.p_delivery_date_high);
209: END IF;

Line 208: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_delivery_date_high',p_doc_param_info.p_delivery_date_high);

204: IF p_doc_param_info.p_delivery_date_low IS NOT NULL THEN
205: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_delivery_date_low',p_doc_param_info.p_delivery_date_low);
206: END IF;
207: IF p_doc_param_info.p_delivery_date_high IS NOT NULL THEN
208: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_delivery_date_high',p_doc_param_info.p_delivery_date_high);
209: END IF;
210: END IF;
211: -- Bug: 1520197
212: IF ( p_prog_name = 'WSHRDBOL' AND p_doc_param_info.p_delivery_leg_id IS NOT NULL ) THEN

Line 213: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_delivery_leg_id',p_doc_param_info.p_delivery_leg_id);

209: END IF;
210: END IF;
211: -- Bug: 1520197
212: IF ( p_prog_name = 'WSHRDBOL' AND p_doc_param_info.p_delivery_leg_id IS NOT NULL ) THEN
213: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_delivery_leg_id',p_doc_param_info.p_delivery_leg_id);
214: END IF;
215:
216: -- Define the output variable
217: DBMS_SQL.DEFINE_COLUMN(l_CursorID,1,l_lang,30);

Line 217: DBMS_SQL.DEFINE_COLUMN(l_CursorID,1,l_lang,30);

213: DBMS_SQL.BIND_VARIABLE(l_CursorID,':p_delivery_leg_id',p_doc_param_info.p_delivery_leg_id);
214: END IF;
215:
216: -- Define the output variable
217: DBMS_SQL.DEFINE_COLUMN(l_CursorID,1,l_lang,30);
218: -- Execute the query
219: l_dummy := DBMS_SQL.EXECUTE(l_CursorID);
220:
221: -- Create string of languages to be returned

Line 219: l_dummy := DBMS_SQL.EXECUTE(l_CursorID);

215:
216: -- Define the output variable
217: DBMS_SQL.DEFINE_COLUMN(l_CursorID,1,l_lang,30);
218: -- Execute the query
219: l_dummy := DBMS_SQL.EXECUTE(l_CursorID);
220:
221: -- Create string of languages to be returned
222: LOOP
223: IF DBMS_SQL.FETCH_ROWS(l_CursorID) = 0 THEN

Line 223: IF DBMS_SQL.FETCH_ROWS(l_CursorID) = 0 THEN

219: l_dummy := DBMS_SQL.EXECUTE(l_CursorID);
220:
221: -- Create string of languages to be returned
222: LOOP
223: IF DBMS_SQL.FETCH_ROWS(l_CursorID) = 0 THEN
224: EXIT;
225: END IF;
226:
227: -- Fetch language into variable

Line 228: DBMS_SQL.COLUMN_VALUE(l_CursorID,1,l_lang);

224: EXIT;
225: END IF;
226:
227: -- Fetch language into variable
228: DBMS_SQL.COLUMN_VALUE(l_CursorID,1,l_lang);
229:
230: IF (l_lang IS NOT NULL) THEN
231: IF (l_lang_str IS NULL) THEN
232: l_lang_str := l_lang;

Line 249: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

245: END IF;
246: END IF;
247: END LOOP;
248:
249: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
250:
251: IF (l_lang_str IS NULL) THEN
252: -- Function must not return an empty string
253: l_lang_str := l_base_lang;

Line 268: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

264: RETURN (l_lang_str);
265:
266: EXCEPTION
267: WHEN OTHERS THEN
268: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
269: --
270: -- Debug Statements
271: --
272: IF l_debug_on THEN