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

Line 1348: l_cursor := dbms_sql.open_cursor;

1344: --Wms_re_common_pvt.ShowSQL(l_stmt);
1345: inv_sql_binding_pvt.ShowBindVars;
1346:
1347: -- 2nd step: get a cursor and parse the SQL statement
1348: l_cursor := dbms_sql.open_cursor;
1349: dbms_sql.parse( l_cursor, l_stmt, dbms_sql.native );
1350:
1351: -- 3rd step: bind input variables
1352: inv_sql_binding_pvt.BindVars(l_cursor);

Line 1349: dbms_sql.parse( l_cursor, l_stmt, dbms_sql.native );

1345: inv_sql_binding_pvt.ShowBindVars;
1346:
1347: -- 2nd step: get a cursor and parse the SQL statement
1348: l_cursor := dbms_sql.open_cursor;
1349: dbms_sql.parse( l_cursor, l_stmt, dbms_sql.native );
1350:
1351: -- 3rd step: bind input variables
1352: inv_sql_binding_pvt.BindVars(l_cursor);
1353:

Line 1355: dbms_sql.define_column(l_cursor, 1, l_strategy_id);

1351: -- 3rd step: bind input variables
1352: inv_sql_binding_pvt.BindVars(l_cursor);
1353:
1354: -- 4th step: define output column
1355: dbms_sql.define_column(l_cursor, 1, l_strategy_id);
1356: dbms_sql.define_column(l_cursor, 2, l_pk1_value,150);
1357: dbms_sql.define_column(l_cursor, 3, l_pk2_value,150);
1358: dbms_sql.define_column(l_cursor, 4, l_pk3_value,150);
1359: dbms_sql.define_column(l_cursor, 5, l_pk4_value,150);

Line 1356: dbms_sql.define_column(l_cursor, 2, l_pk1_value,150);

1352: inv_sql_binding_pvt.BindVars(l_cursor);
1353:
1354: -- 4th step: define output column
1355: dbms_sql.define_column(l_cursor, 1, l_strategy_id);
1356: dbms_sql.define_column(l_cursor, 2, l_pk1_value,150);
1357: dbms_sql.define_column(l_cursor, 3, l_pk2_value,150);
1358: dbms_sql.define_column(l_cursor, 4, l_pk3_value,150);
1359: dbms_sql.define_column(l_cursor, 5, l_pk4_value,150);
1360: dbms_sql.define_column(l_cursor, 6, l_pk5_value,150);

Line 1357: dbms_sql.define_column(l_cursor, 3, l_pk2_value,150);

1353:
1354: -- 4th step: define output column
1355: dbms_sql.define_column(l_cursor, 1, l_strategy_id);
1356: dbms_sql.define_column(l_cursor, 2, l_pk1_value,150);
1357: dbms_sql.define_column(l_cursor, 3, l_pk2_value,150);
1358: dbms_sql.define_column(l_cursor, 4, l_pk3_value,150);
1359: dbms_sql.define_column(l_cursor, 5, l_pk4_value,150);
1360: dbms_sql.define_column(l_cursor, 6, l_pk5_value,150);
1361:

Line 1358: dbms_sql.define_column(l_cursor, 4, l_pk3_value,150);

1354: -- 4th step: define output column
1355: dbms_sql.define_column(l_cursor, 1, l_strategy_id);
1356: dbms_sql.define_column(l_cursor, 2, l_pk1_value,150);
1357: dbms_sql.define_column(l_cursor, 3, l_pk2_value,150);
1358: dbms_sql.define_column(l_cursor, 4, l_pk3_value,150);
1359: dbms_sql.define_column(l_cursor, 5, l_pk4_value,150);
1360: dbms_sql.define_column(l_cursor, 6, l_pk5_value,150);
1361:
1362: -- 5th step: execute the SQL statement and fetch one record

Line 1359: dbms_sql.define_column(l_cursor, 5, l_pk4_value,150);

1355: dbms_sql.define_column(l_cursor, 1, l_strategy_id);
1356: dbms_sql.define_column(l_cursor, 2, l_pk1_value,150);
1357: dbms_sql.define_column(l_cursor, 3, l_pk2_value,150);
1358: dbms_sql.define_column(l_cursor, 4, l_pk3_value,150);
1359: dbms_sql.define_column(l_cursor, 5, l_pk4_value,150);
1360: dbms_sql.define_column(l_cursor, 6, l_pk5_value,150);
1361:
1362: -- 5th step: execute the SQL statement and fetch one record
1363: l_rows := dbms_sql.execute_and_fetch(l_cursor, false);

Line 1360: dbms_sql.define_column(l_cursor, 6, l_pk5_value,150);

1356: dbms_sql.define_column(l_cursor, 2, l_pk1_value,150);
1357: dbms_sql.define_column(l_cursor, 3, l_pk2_value,150);
1358: dbms_sql.define_column(l_cursor, 4, l_pk3_value,150);
1359: dbms_sql.define_column(l_cursor, 5, l_pk4_value,150);
1360: dbms_sql.define_column(l_cursor, 6, l_pk5_value,150);
1361:
1362: -- 5th step: execute the SQL statement and fetch one record
1363: l_rows := dbms_sql.execute_and_fetch(l_cursor, false);
1364: if l_rows = 0 then

Line 1363: l_rows := dbms_sql.execute_and_fetch(l_cursor, false);

1359: dbms_sql.define_column(l_cursor, 5, l_pk4_value,150);
1360: dbms_sql.define_column(l_cursor, 6, l_pk5_value,150);
1361:
1362: -- 5th step: execute the SQL statement and fetch one record
1363: l_rows := dbms_sql.execute_and_fetch(l_cursor, false);
1364: if l_rows = 0 then
1365: l_strategy_id := null;
1366: else
1367: dbms_sql.column_value(l_cursor, 1, l_strategy_id);

Line 1367: dbms_sql.column_value(l_cursor, 1, l_strategy_id);

1363: l_rows := dbms_sql.execute_and_fetch(l_cursor, false);
1364: if l_rows = 0 then
1365: l_strategy_id := null;
1366: else
1367: dbms_sql.column_value(l_cursor, 1, l_strategy_id);
1368: dbms_sql.column_value(l_cursor, 2, l_pk1_value);
1369: dbms_sql.column_value(l_cursor, 3, l_pk2_value);
1370: dbms_sql.column_value(l_cursor, 4, l_pk3_value);
1371: dbms_sql.column_value(l_cursor, 5, l_pk4_value);

Line 1368: dbms_sql.column_value(l_cursor, 2, l_pk1_value);

1364: if l_rows = 0 then
1365: l_strategy_id := null;
1366: else
1367: dbms_sql.column_value(l_cursor, 1, l_strategy_id);
1368: dbms_sql.column_value(l_cursor, 2, l_pk1_value);
1369: dbms_sql.column_value(l_cursor, 3, l_pk2_value);
1370: dbms_sql.column_value(l_cursor, 4, l_pk3_value);
1371: dbms_sql.column_value(l_cursor, 5, l_pk4_value);
1372: dbms_sql.column_value(l_cursor, 6, l_pk5_value);

Line 1369: dbms_sql.column_value(l_cursor, 3, l_pk2_value);

1365: l_strategy_id := null;
1366: else
1367: dbms_sql.column_value(l_cursor, 1, l_strategy_id);
1368: dbms_sql.column_value(l_cursor, 2, l_pk1_value);
1369: dbms_sql.column_value(l_cursor, 3, l_pk2_value);
1370: dbms_sql.column_value(l_cursor, 4, l_pk3_value);
1371: dbms_sql.column_value(l_cursor, 5, l_pk4_value);
1372: dbms_sql.column_value(l_cursor, 6, l_pk5_value);
1373: end if;

Line 1370: dbms_sql.column_value(l_cursor, 4, l_pk3_value);

1366: else
1367: dbms_sql.column_value(l_cursor, 1, l_strategy_id);
1368: dbms_sql.column_value(l_cursor, 2, l_pk1_value);
1369: dbms_sql.column_value(l_cursor, 3, l_pk2_value);
1370: dbms_sql.column_value(l_cursor, 4, l_pk3_value);
1371: dbms_sql.column_value(l_cursor, 5, l_pk4_value);
1372: dbms_sql.column_value(l_cursor, 6, l_pk5_value);
1373: end if;
1374:

Line 1371: dbms_sql.column_value(l_cursor, 5, l_pk4_value);

1367: dbms_sql.column_value(l_cursor, 1, l_strategy_id);
1368: dbms_sql.column_value(l_cursor, 2, l_pk1_value);
1369: dbms_sql.column_value(l_cursor, 3, l_pk2_value);
1370: dbms_sql.column_value(l_cursor, 4, l_pk3_value);
1371: dbms_sql.column_value(l_cursor, 5, l_pk4_value);
1372: dbms_sql.column_value(l_cursor, 6, l_pk5_value);
1373: end if;
1374:
1375: -- 6th step: finally, close dynamic cursor

Line 1372: dbms_sql.column_value(l_cursor, 6, l_pk5_value);

1368: dbms_sql.column_value(l_cursor, 2, l_pk1_value);
1369: dbms_sql.column_value(l_cursor, 3, l_pk2_value);
1370: dbms_sql.column_value(l_cursor, 4, l_pk3_value);
1371: dbms_sql.column_value(l_cursor, 5, l_pk4_value);
1372: dbms_sql.column_value(l_cursor, 6, l_pk5_value);
1373: end if;
1374:
1375: -- 6th step: finally, close dynamic cursor
1376: dbms_sql.close_cursor(l_cursor);

Line 1376: dbms_sql.close_cursor(l_cursor);

1372: dbms_sql.column_value(l_cursor, 6, l_pk5_value);
1373: end if;
1374:
1375: -- 6th step: finally, close dynamic cursor
1376: dbms_sql.close_cursor(l_cursor);
1377:
1378: -- interrupt the search, if a strategy was found
1379: exit when l_strategy_id is not null;
1380: If (g_debug = 1) then

Line 1485: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);

1481: IF inv_pp_debug.is_debug_mode THEN
1482: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1483: -- the message retrieved here since it is no longer on the stack
1484: inv_pp_debug.set_last_error_message(Sqlerrm);
1485: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1486: --changed by jcearley on 11/22/99 because call was causing error
1487: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1488: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1489: inv_pp_debug.send_last_error_message;

Line 1513: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);

1509: IF inv_pp_debug.is_debug_mode THEN
1510: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1511: -- the message retrieved here since it is no longer on the stack
1512: inv_pp_debug.set_last_error_message(Sqlerrm);
1513: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1514: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1515: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1516: inv_pp_debug.send_last_error_message;
1517: -- inv_pp_debug.send_last_dynamic_sql;

Line 1540: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);

1536: IF inv_pp_debug.is_debug_mode THEN
1537: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1538: -- the message retrieved here since it is no longer on the stack
1539: inv_pp_debug.set_last_error_message(Sqlerrm);
1540: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1541: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1542: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1543: inv_pp_debug.send_last_error_message;
1544: -- inv_pp_debug.send_last_dynamic_sql;