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_SC_DETAILS_REQUIRED_PKG dependencies on DBMS_SQL

Line 103: X_Cursor := dbms_sql.open_cursor;

99: SQL_Stmt := SQL_Stmt||' AND mtlsub.quantity_tracked = 1 ';
100: SQL_Stmt := SQL_Stmt||' AND sysdate <= nvl(mtlsub.disable_date,sysdate))';
101:
102: X_Stmt_Num := 40;
103: X_Cursor := dbms_sql.open_cursor;
104:
105: X_Stmt_Num := 50;
106: dbms_sql.parse(X_Cursor,SQL_Stmt,dbms_sql.v7);
107:

Line 106: dbms_sql.parse(X_Cursor,SQL_Stmt,dbms_sql.v7);

102: X_Stmt_Num := 40;
103: X_Cursor := dbms_sql.open_cursor;
104:
105: X_Stmt_Num := 50;
106: dbms_sql.parse(X_Cursor,SQL_Stmt,dbms_sql.v7);
107:
108: X_Stmt_Num := 60;
109: dbms_sql.bind_variable(X_Cursor,'X_Entity_Id',X_Entity_Id);
110: dbms_sql.bind_variable(X_Cursor,'X_Warehouse_id',X_Warehouse_id);

Line 109: dbms_sql.bind_variable(X_Cursor,'X_Entity_Id',X_Entity_Id);

105: X_Stmt_Num := 50;
106: dbms_sql.parse(X_Cursor,SQL_Stmt,dbms_sql.v7);
107:
108: X_Stmt_Num := 60;
109: dbms_sql.bind_variable(X_Cursor,'X_Entity_Id',X_Entity_Id);
110: dbms_sql.bind_variable(X_Cursor,'X_Warehouse_id',X_Warehouse_id);
111: dbms_sql.bind_variable(X_Cursor,'X_Reservations',X_Reservations);
112: dbms_sql.bind_variable(X_Cursor,'X_Action',X_Action);
113:

Line 110: dbms_sql.bind_variable(X_Cursor,'X_Warehouse_id',X_Warehouse_id);

106: dbms_sql.parse(X_Cursor,SQL_Stmt,dbms_sql.v7);
107:
108: X_Stmt_Num := 60;
109: dbms_sql.bind_variable(X_Cursor,'X_Entity_Id',X_Entity_Id);
110: dbms_sql.bind_variable(X_Cursor,'X_Warehouse_id',X_Warehouse_id);
111: dbms_sql.bind_variable(X_Cursor,'X_Reservations',X_Reservations);
112: dbms_sql.bind_variable(X_Cursor,'X_Action',X_Action);
113:
114: X_Stmt_Num := 80;

Line 111: dbms_sql.bind_variable(X_Cursor,'X_Reservations',X_Reservations);

107:
108: X_Stmt_Num := 60;
109: dbms_sql.bind_variable(X_Cursor,'X_Entity_Id',X_Entity_Id);
110: dbms_sql.bind_variable(X_Cursor,'X_Warehouse_id',X_Warehouse_id);
111: dbms_sql.bind_variable(X_Cursor,'X_Reservations',X_Reservations);
112: dbms_sql.bind_variable(X_Cursor,'X_Action',X_Action);
113:
114: X_Stmt_Num := 80;
115: X_Rows := dbms_sql.execute(X_Cursor);

Line 112: dbms_sql.bind_variable(X_Cursor,'X_Action',X_Action);

108: X_Stmt_Num := 60;
109: dbms_sql.bind_variable(X_Cursor,'X_Entity_Id',X_Entity_Id);
110: dbms_sql.bind_variable(X_Cursor,'X_Warehouse_id',X_Warehouse_id);
111: dbms_sql.bind_variable(X_Cursor,'X_Reservations',X_Reservations);
112: dbms_sql.bind_variable(X_Cursor,'X_Action',X_Action);
113:
114: X_Stmt_Num := 80;
115: X_Rows := dbms_sql.execute(X_Cursor);
116:

Line 115: X_Rows := dbms_sql.execute(X_Cursor);

111: dbms_sql.bind_variable(X_Cursor,'X_Reservations',X_Reservations);
112: dbms_sql.bind_variable(X_Cursor,'X_Action',X_Action);
113:
114: X_Stmt_Num := 80;
115: X_Rows := dbms_sql.execute(X_Cursor);
116:
117: X_Stmt_Num := 90;
118: X_Rows := dbms_sql.fetch_rows(X_Cursor);
119:

Line 118: X_Rows := dbms_sql.fetch_rows(X_Cursor);

114: X_Stmt_Num := 80;
115: X_Rows := dbms_sql.execute(X_Cursor);
116:
117: X_Stmt_Num := 90;
118: X_Rows := dbms_sql.fetch_rows(X_Cursor);
119:
120: X_Stmt_Num := 110;
121: IF X_Rows <> 0 THEN
122: X_Details_Req := 'Y';

Line 124: IF dbms_sql.is_open(X_Cursor) THEN

120: X_Stmt_Num := 110;
121: IF X_Rows <> 0 THEN
122: X_Details_Req := 'Y';
123: X_Stmt_Num := 100;
124: IF dbms_sql.is_open(X_Cursor) THEN
125: dbms_sql.close_cursor(X_Cursor);
126: END IF;
127: ELSE
128: X_Stmt_Num := 100;

Line 125: dbms_sql.close_cursor(X_Cursor);

121: IF X_Rows <> 0 THEN
122: X_Details_Req := 'Y';
123: X_Stmt_Num := 100;
124: IF dbms_sql.is_open(X_Cursor) THEN
125: dbms_sql.close_cursor(X_Cursor);
126: END IF;
127: ELSE
128: X_Stmt_Num := 100;
129: IF dbms_sql.is_open(X_Cursor) THEN

Line 129: IF dbms_sql.is_open(X_Cursor) THEN

125: dbms_sql.close_cursor(X_Cursor);
126: END IF;
127: ELSE
128: X_Stmt_Num := 100;
129: IF dbms_sql.is_open(X_Cursor) THEN
130: dbms_sql.close_cursor(X_Cursor);
131: END IF;
132:
133: /*

Line 130: dbms_sql.close_cursor(X_Cursor);

126: END IF;
127: ELSE
128: X_Stmt_Num := 100;
129: IF dbms_sql.is_open(X_Cursor) THEN
130: dbms_sql.close_cursor(X_Cursor);
131: END IF;
132:
133: /*
134: Location is required or missing for one detail that is

Line 203: X_Cursor := dbms_sql.open_cursor;

199: SQL_Stmt := SQL_Stmt||' AND trunc(sysdate) <= nvl( mtlsub.disable_date, trunc(sysdate)))';
200:
201:
202: X_Stmt_Num := 120;
203: X_Cursor := dbms_sql.open_cursor;
204:
205: X_Stmt_Num := 130;
206: dbms_sql.parse(X_Cursor,SQL_Stmt,dbms_sql.v7);
207:

Line 206: dbms_sql.parse(X_Cursor,SQL_Stmt,dbms_sql.v7);

202: X_Stmt_Num := 120;
203: X_Cursor := dbms_sql.open_cursor;
204:
205: X_Stmt_Num := 130;
206: dbms_sql.parse(X_Cursor,SQL_Stmt,dbms_sql.v7);
207:
208: X_Stmt_Num := 140;
209: dbms_sql.bind_variable(X_Cursor,'X_Entity_Id',X_Entity_Id);
210: dbms_sql.bind_variable(X_Cursor,'X_Reservations',X_Reservations);

Line 209: dbms_sql.bind_variable(X_Cursor,'X_Entity_Id',X_Entity_Id);

205: X_Stmt_Num := 130;
206: dbms_sql.parse(X_Cursor,SQL_Stmt,dbms_sql.v7);
207:
208: X_Stmt_Num := 140;
209: dbms_sql.bind_variable(X_Cursor,'X_Entity_Id',X_Entity_Id);
210: dbms_sql.bind_variable(X_Cursor,'X_Reservations',X_Reservations);
211: dbms_sql.bind_variable(X_Cursor,'X_Warehouse_id',X_Warehouse_id);
212: dbms_sql.bind_variable(X_Cursor,'X_Action',X_Action);
213:

Line 210: dbms_sql.bind_variable(X_Cursor,'X_Reservations',X_Reservations);

206: dbms_sql.parse(X_Cursor,SQL_Stmt,dbms_sql.v7);
207:
208: X_Stmt_Num := 140;
209: dbms_sql.bind_variable(X_Cursor,'X_Entity_Id',X_Entity_Id);
210: dbms_sql.bind_variable(X_Cursor,'X_Reservations',X_Reservations);
211: dbms_sql.bind_variable(X_Cursor,'X_Warehouse_id',X_Warehouse_id);
212: dbms_sql.bind_variable(X_Cursor,'X_Action',X_Action);
213:
214: X_Stmt_Num := 160;

Line 211: dbms_sql.bind_variable(X_Cursor,'X_Warehouse_id',X_Warehouse_id);

207:
208: X_Stmt_Num := 140;
209: dbms_sql.bind_variable(X_Cursor,'X_Entity_Id',X_Entity_Id);
210: dbms_sql.bind_variable(X_Cursor,'X_Reservations',X_Reservations);
211: dbms_sql.bind_variable(X_Cursor,'X_Warehouse_id',X_Warehouse_id);
212: dbms_sql.bind_variable(X_Cursor,'X_Action',X_Action);
213:
214: X_Stmt_Num := 160;
215: X_Rows := dbms_sql.execute(X_Cursor);

Line 212: dbms_sql.bind_variable(X_Cursor,'X_Action',X_Action);

208: X_Stmt_Num := 140;
209: dbms_sql.bind_variable(X_Cursor,'X_Entity_Id',X_Entity_Id);
210: dbms_sql.bind_variable(X_Cursor,'X_Reservations',X_Reservations);
211: dbms_sql.bind_variable(X_Cursor,'X_Warehouse_id',X_Warehouse_id);
212: dbms_sql.bind_variable(X_Cursor,'X_Action',X_Action);
213:
214: X_Stmt_Num := 160;
215: X_Rows := dbms_sql.execute(X_Cursor);
216:

Line 215: X_Rows := dbms_sql.execute(X_Cursor);

211: dbms_sql.bind_variable(X_Cursor,'X_Warehouse_id',X_Warehouse_id);
212: dbms_sql.bind_variable(X_Cursor,'X_Action',X_Action);
213:
214: X_Stmt_Num := 160;
215: X_Rows := dbms_sql.execute(X_Cursor);
216:
217: X_Stmt_Num := 170;
218: X_Rows := dbms_sql.fetch_rows(X_Cursor);
219:

Line 218: X_Rows := dbms_sql.fetch_rows(X_Cursor);

214: X_Stmt_Num := 160;
215: X_Rows := dbms_sql.execute(X_Cursor);
216:
217: X_Stmt_Num := 170;
218: X_Rows := dbms_sql.fetch_rows(X_Cursor);
219:
220: X_Stmt_Num := 180;
221: IF X_Rows <> 0 THEN
222: X_Details_Req := 'Y';

Line 224: IF dbms_sql.is_open(X_Cursor) THEN

220: X_Stmt_Num := 180;
221: IF X_Rows <> 0 THEN
222: X_Details_Req := 'Y';
223: X_Stmt_Num := 190;
224: IF dbms_sql.is_open(X_Cursor) THEN
225: dbms_sql.close_cursor(X_Cursor);
226: END IF;
227: ELSE
228: X_Stmt_Num := 200;

Line 225: dbms_sql.close_cursor(X_Cursor);

221: IF X_Rows <> 0 THEN
222: X_Details_Req := 'Y';
223: X_Stmt_Num := 190;
224: IF dbms_sql.is_open(X_Cursor) THEN
225: dbms_sql.close_cursor(X_Cursor);
226: END IF;
227: ELSE
228: X_Stmt_Num := 200;
229: IF dbms_sql.is_open(X_Cursor) THEN

Line 229: IF dbms_sql.is_open(X_Cursor) THEN

225: dbms_sql.close_cursor(X_Cursor);
226: END IF;
227: ELSE
228: X_Stmt_Num := 200;
229: IF dbms_sql.is_open(X_Cursor) THEN
230: dbms_sql.close_cursor(X_Cursor);
231: END IF;
232:
233:

Line 230: dbms_sql.close_cursor(X_Cursor);

226: END IF;
227: ELSE
228: X_Stmt_Num := 200;
229: IF dbms_sql.is_open(X_Cursor) THEN
230: dbms_sql.close_cursor(X_Cursor);
231: END IF;
232:
233:
234: /*

Line 317: X_Cursor := dbms_sql.open_cursor;

313:
314:
315:
316: X_Stmt_Num := 210;
317: X_Cursor := dbms_sql.open_cursor;
318:
319: X_Stmt_Num := 220;
320: dbms_sql.parse(X_Cursor,SQL_Stmt,dbms_sql.v7);
321:

Line 320: dbms_sql.parse(X_Cursor,SQL_Stmt,dbms_sql.v7);

316: X_Stmt_Num := 210;
317: X_Cursor := dbms_sql.open_cursor;
318:
319: X_Stmt_Num := 220;
320: dbms_sql.parse(X_Cursor,SQL_Stmt,dbms_sql.v7);
321:
322: X_Stmt_Num := 230;
323: dbms_sql.bind_variable(X_Cursor,'X_Entity_Id',X_Entity_Id);
324: dbms_sql.bind_variable(X_Cursor,'X_Reservations',X_Reservations);

Line 323: dbms_sql.bind_variable(X_Cursor,'X_Entity_Id',X_Entity_Id);

319: X_Stmt_Num := 220;
320: dbms_sql.parse(X_Cursor,SQL_Stmt,dbms_sql.v7);
321:
322: X_Stmt_Num := 230;
323: dbms_sql.bind_variable(X_Cursor,'X_Entity_Id',X_Entity_Id);
324: dbms_sql.bind_variable(X_Cursor,'X_Reservations',X_Reservations);
325: dbms_sql.bind_variable(X_Cursor,'X_Warehouse_id',X_Warehouse_id);
326: dbms_sql.bind_variable(X_Cursor,'X_Action',X_Action);
327: if X_MODE not in ('DEPARTURE','DELIVERY') then

Line 324: dbms_sql.bind_variable(X_Cursor,'X_Reservations',X_Reservations);

320: dbms_sql.parse(X_Cursor,SQL_Stmt,dbms_sql.v7);
321:
322: X_Stmt_Num := 230;
323: dbms_sql.bind_variable(X_Cursor,'X_Entity_Id',X_Entity_Id);
324: dbms_sql.bind_variable(X_Cursor,'X_Reservations',X_Reservations);
325: dbms_sql.bind_variable(X_Cursor,'X_Warehouse_id',X_Warehouse_id);
326: dbms_sql.bind_variable(X_Cursor,'X_Action',X_Action);
327: if X_MODE not in ('DEPARTURE','DELIVERY') then
328: dbms_sql.bind_variable(X_Cursor,'X_Order_Category',X_Order_Category);

Line 325: dbms_sql.bind_variable(X_Cursor,'X_Warehouse_id',X_Warehouse_id);

321:
322: X_Stmt_Num := 230;
323: dbms_sql.bind_variable(X_Cursor,'X_Entity_Id',X_Entity_Id);
324: dbms_sql.bind_variable(X_Cursor,'X_Reservations',X_Reservations);
325: dbms_sql.bind_variable(X_Cursor,'X_Warehouse_id',X_Warehouse_id);
326: dbms_sql.bind_variable(X_Cursor,'X_Action',X_Action);
327: if X_MODE not in ('DEPARTURE','DELIVERY') then
328: dbms_sql.bind_variable(X_Cursor,'X_Order_Category',X_Order_Category);
329: end if;

Line 326: dbms_sql.bind_variable(X_Cursor,'X_Action',X_Action);

322: X_Stmt_Num := 230;
323: dbms_sql.bind_variable(X_Cursor,'X_Entity_Id',X_Entity_Id);
324: dbms_sql.bind_variable(X_Cursor,'X_Reservations',X_Reservations);
325: dbms_sql.bind_variable(X_Cursor,'X_Warehouse_id',X_Warehouse_id);
326: dbms_sql.bind_variable(X_Cursor,'X_Action',X_Action);
327: if X_MODE not in ('DEPARTURE','DELIVERY') then
328: dbms_sql.bind_variable(X_Cursor,'X_Order_Category',X_Order_Category);
329: end if;
330:

Line 328: dbms_sql.bind_variable(X_Cursor,'X_Order_Category',X_Order_Category);

324: dbms_sql.bind_variable(X_Cursor,'X_Reservations',X_Reservations);
325: dbms_sql.bind_variable(X_Cursor,'X_Warehouse_id',X_Warehouse_id);
326: dbms_sql.bind_variable(X_Cursor,'X_Action',X_Action);
327: if X_MODE not in ('DEPARTURE','DELIVERY') then
328: dbms_sql.bind_variable(X_Cursor,'X_Order_Category',X_Order_Category);
329: end if;
330:
331: X_Stmt_Num := 250;
332: X_Rows := dbms_sql.execute(X_Cursor);

Line 332: X_Rows := dbms_sql.execute(X_Cursor);

328: dbms_sql.bind_variable(X_Cursor,'X_Order_Category',X_Order_Category);
329: end if;
330:
331: X_Stmt_Num := 250;
332: X_Rows := dbms_sql.execute(X_Cursor);
333:
334: X_Stmt_Num := 260;
335: X_Rows := dbms_sql.fetch_rows(X_Cursor);
336:

Line 335: X_Rows := dbms_sql.fetch_rows(X_Cursor);

331: X_Stmt_Num := 250;
332: X_Rows := dbms_sql.execute(X_Cursor);
333:
334: X_Stmt_Num := 260;
335: X_Rows := dbms_sql.fetch_rows(X_Cursor);
336:
337: X_Stmt_Num := 270;
338: IF X_Rows <> 0 THEN
339: X_Details_Req := 'Y';

Line 341: IF dbms_sql.is_open(X_Cursor) THEN

337: X_Stmt_Num := 270;
338: IF X_Rows <> 0 THEN
339: X_Details_Req := 'Y';
340: X_Stmt_Num := 280;
341: IF dbms_sql.is_open(X_Cursor) THEN
342: dbms_sql.close_cursor(X_Cursor);
343: END IF;
344: ELSE
345: X_Details_Req := 'N';

Line 342: dbms_sql.close_cursor(X_Cursor);

338: IF X_Rows <> 0 THEN
339: X_Details_Req := 'Y';
340: X_Stmt_Num := 280;
341: IF dbms_sql.is_open(X_Cursor) THEN
342: dbms_sql.close_cursor(X_Cursor);
343: END IF;
344: ELSE
345: X_Details_Req := 'N';
346: END IF;

Line 350: IF dbms_sql.is_open(X_Cursor) THEN

346: END IF;
347: END IF;
348: END IF;
349:
350: IF dbms_sql.is_open(X_Cursor) THEN
351: dbms_sql.close_cursor(X_Cursor);
352: END IF;
353:
354: EXCEPTION

Line 351: dbms_sql.close_cursor(X_Cursor);

347: END IF;
348: END IF;
349:
350: IF dbms_sql.is_open(X_Cursor) THEN
351: dbms_sql.close_cursor(X_Cursor);
352: END IF;
353:
354: EXCEPTION
355: WHEN OTHERS THEN