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

Line 845: g_build_package_tbl DBMS_SQL.varchar2s;

841: g_stmt_serial_validate LONG;
842: g_stmt_serial_detail LONG;
843: g_stmt_serial_detail_new LONG;
844: g_build_package_row NUMBER;
845: g_build_package_tbl DBMS_SQL.varchar2s;
846: g_default_pick_task_type_id NUMBER;
847: g_default_putaway_task_type_id NUMBER;
848: g_default_cc_task_type_id NUMBER;
849: g_default_repl_task_type_id NUMBER;

Line 15040: l_cursor := DBMS_SQL.open_cursor;

15036: RAISE fnd_api.g_exc_error; -- bug#13565649
15037: end if;
15038:
15039: --open cursor
15040: l_cursor := DBMS_SQL.open_cursor;
15041: --parse cursor
15042: DBMS_SQL.parse(l_cursor, g_build_package_tbl, 1, g_build_package_row, FALSE, DBMS_SQL.native);
15043: --close cursor
15044: DBMS_SQL.close_cursor(l_cursor);

Line 15042: DBMS_SQL.parse(l_cursor, g_build_package_tbl, 1, g_build_package_row, FALSE, DBMS_SQL.native);

15038:
15039: --open cursor
15040: l_cursor := DBMS_SQL.open_cursor;
15041: --parse cursor
15042: DBMS_SQL.parse(l_cursor, g_build_package_tbl, 1, g_build_package_row, FALSE, DBMS_SQL.native);
15043: --close cursor
15044: DBMS_SQL.close_cursor(l_cursor);
15045:
15046: /* We may need to call this API for AOL standards

Line 15044: DBMS_SQL.close_cursor(l_cursor);

15040: l_cursor := DBMS_SQL.open_cursor;
15041: --parse cursor
15042: DBMS_SQL.parse(l_cursor, g_build_package_tbl, 1, g_build_package_row, FALSE, DBMS_SQL.native);
15043: --close cursor
15044: DBMS_SQL.close_cursor(l_cursor);
15045:
15046: /* We may need to call this API for AOL standards
15047: --get schema info
15048: l_return := fnd_installation.get_app_info(

Line 15407: --l_cursor := dbms_sql.open_cursor;

15403: || l_package_name
15404: || ';';
15405: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
15406: --open cursor
15407: --l_cursor := dbms_sql.open_cursor;
15408: --parse cursor
15409: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
15410: --close cursor
15411: --dbms_sql.close_cursor(l_cursor);

Line 15409: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);

15405: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
15406: --open cursor
15407: --l_cursor := dbms_sql.open_cursor;
15408: --parse cursor
15409: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
15410: --close cursor
15411: --dbms_sql.close_cursor(l_cursor);
15412: buildpackage(l_pack_sql);
15413: --create the package spec

Line 15411: --dbms_sql.close_cursor(l_cursor);

15407: --l_cursor := dbms_sql.open_cursor;
15408: --parse cursor
15409: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
15410: --close cursor
15411: --dbms_sql.close_cursor(l_cursor);
15412: buildpackage(l_pack_sql);
15413: --create the package spec
15414: createpackage(x_return_status, l_package_name, FALSE);
15415:

Line 15474: --l_cursor := dbms_sql.open_cursor;

15470: || l_package_name
15471: || ';';
15472: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
15473: --open cursor
15474: --l_cursor := dbms_sql.open_cursor;
15475: --parse cursor
15476: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
15477: --close cursor
15478: --dbms_sql.close_cursor(l_cursor);

Line 15476: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);

15472: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
15473: --open cursor
15474: --l_cursor := dbms_sql.open_cursor;
15475: --parse cursor
15476: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
15477: --close cursor
15478: --dbms_sql.close_cursor(l_cursor);
15479: buildpackage(l_pack_sql);
15480: createpackage(x_return_status, l_package_name, FALSE);

Line 15478: --dbms_sql.close_cursor(l_cursor);

15474: --l_cursor := dbms_sql.open_cursor;
15475: --parse cursor
15476: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
15477: --close cursor
15478: --dbms_sql.close_cursor(l_cursor);
15479: buildpackage(l_pack_sql);
15480: createpackage(x_return_status, l_package_name, FALSE);
15481:
15482: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 15538: --l_cursor := dbms_sql.open_cursor;

15534: || l_package_name
15535: || ';';
15536: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
15537: --open cursor
15538: --l_cursor := dbms_sql.open_cursor;
15539: --parse cursor
15540: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
15541: --close cursor
15542: --dbms_sql.close_cursor(l_cursor);

Line 15540: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);

15536: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
15537: --open cursor
15538: --l_cursor := dbms_sql.open_cursor;
15539: --parse cursor
15540: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
15541: --close cursor
15542: --dbms_sql.close_cursor(l_cursor);
15543: buildpackage(l_pack_sql);
15544: createpackage(x_return_status, l_package_name, FALSE);

Line 15542: --dbms_sql.close_cursor(l_cursor);

15538: --l_cursor := dbms_sql.open_cursor;
15539: --parse cursor
15540: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
15541: --close cursor
15542: --dbms_sql.close_cursor(l_cursor);
15543: buildpackage(l_pack_sql);
15544: createpackage(x_return_status, l_package_name, FALSE);
15545:
15546: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 15605: --l_cursor := dbms_sql.open_cursor;

15601: || l_package_name
15602: || ';';
15603: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
15604: --open cursor
15605: --l_cursor := dbms_sql.open_cursor;
15606: --parse cursor
15607: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
15608: --close cursor
15609: --dbms_sql.close_cursor(l_cursor);

Line 15607: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);

15603: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
15604: --open cursor
15605: --l_cursor := dbms_sql.open_cursor;
15606: --parse cursor
15607: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
15608: --close cursor
15609: --dbms_sql.close_cursor(l_cursor);
15610: buildpackage(l_pack_sql);
15611: createpackage(x_return_status, l_package_name, FALSE);

Line 15609: --dbms_sql.close_cursor(l_cursor);

15605: --l_cursor := dbms_sql.open_cursor;
15606: --parse cursor
15607: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
15608: --close cursor
15609: --dbms_sql.close_cursor(l_cursor);
15610: buildpackage(l_pack_sql);
15611: createpackage(x_return_status, l_package_name, FALSE);
15612:
15613: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 15711: --l_cursor := dbms_sql.open_cursor;

15707: || ';';
15708: log_procedure(l_api_name, '=>', '********************* 198');
15709: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
15710: --open cursor
15711: --l_cursor := dbms_sql.open_cursor;
15712: --parse cursor
15713: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
15714: --close cursor
15715: --dbms_sql.close_cursor(l_cursor);

Line 15713: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);

15709: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
15710: --open cursor
15711: --l_cursor := dbms_sql.open_cursor;
15712: --parse cursor
15713: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
15714: --close cursor
15715: --dbms_sql.close_cursor(l_cursor);
15716: buildpackage(l_pack_sql);
15717: createpackage(x_return_status, l_package_name, FALSE);

Line 15715: --dbms_sql.close_cursor(l_cursor);

15711: --l_cursor := dbms_sql.open_cursor;
15712: --parse cursor
15713: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
15714: --close cursor
15715: --dbms_sql.close_cursor(l_cursor);
15716: buildpackage(l_pack_sql);
15717: createpackage(x_return_status, l_package_name, FALSE);
15718:
15719: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 16066: --l_cursor := dbms_sql.open_cursor;

16062: || l_package_name
16063: || ';';
16064: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
16065: --open cursor
16066: --l_cursor := dbms_sql.open_cursor;
16067: --parse cursor
16068: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
16069: --close cursor
16070: --dbms_sql.close_cursor(l_cursor);

Line 16068: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);

16064: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
16065: --open cursor
16066: --l_cursor := dbms_sql.open_cursor;
16067: --parse cursor
16068: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
16069: --close cursor
16070: --dbms_sql.close_cursor(l_cursor);
16071: buildpackage(l_pack_sql);
16072: createpackage(x_return_status, l_package_name, FALSE);

Line 16070: --dbms_sql.close_cursor(l_cursor);

16066: --l_cursor := dbms_sql.open_cursor;
16067: --parse cursor
16068: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
16069: --close cursor
16070: --dbms_sql.close_cursor(l_cursor);
16071: buildpackage(l_pack_sql);
16072: createpackage(x_return_status, l_package_name, FALSE);
16073:
16074: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 16304: l_cursor := dbms_sql.open_cursor;

16300: -- inv_pp_debug.send_long_to_pipe(l_pack_body_sql);
16301: /*
16302: --open cursor
16303:
16304: l_cursor := dbms_sql.open_cursor;
16305: dbms_out
16306: --parse cursor
16307:
16308: dbms_sql.parse(l_cursor, l_pack_body_sql, dbms_sql.native);

Line 16308: dbms_sql.parse(l_cursor, l_pack_body_sql, dbms_sql.native);

16304: l_cursor := dbms_sql.open_cursor;
16305: dbms_out
16306: --parse cursor
16307:
16308: dbms_sql.parse(l_cursor, l_pack_body_sql, dbms_sql.native);
16309:
16310: --close cursor
16311: dbms_sql.close_cursor(l_cursor);
16312: */

Line 16311: dbms_sql.close_cursor(l_cursor);

16307:
16308: dbms_sql.parse(l_cursor, l_pack_body_sql, dbms_sql.native);
16309:
16310: --close cursor
16311: dbms_sql.close_cursor(l_cursor);
16312: */
16313:
16314:
16315:

Line 16346: IF DBMS_SQL.is_open(l_cursor) THEN

16342: END IF;
16343:
16344: -- end of debugging section
16345: --
16346: IF DBMS_SQL.is_open(l_cursor) THEN
16347: DBMS_SQL.close_cursor(l_cursor);
16348: END IF;
16349:
16350: freeglobals;

Line 16347: DBMS_SQL.close_cursor(l_cursor);

16343:
16344: -- end of debugging section
16345: --
16346: IF DBMS_SQL.is_open(l_cursor) THEN
16347: DBMS_SQL.close_cursor(l_cursor);
16348: END IF;
16349:
16350: freeglobals;
16351: x_return_status := fnd_api.g_ret_sts_error;

Line 16369: IF DBMS_SQL.is_open(l_cursor) THEN

16365: END IF;
16366:
16367: -- end of debugging section
16368: --
16369: IF DBMS_SQL.is_open(l_cursor) THEN
16370: DBMS_SQL.close_cursor(l_cursor);
16371: END IF;
16372:
16373: freeglobals;

Line 16370: DBMS_SQL.close_cursor(l_cursor);

16366:
16367: -- end of debugging section
16368: --
16369: IF DBMS_SQL.is_open(l_cursor) THEN
16370: DBMS_SQL.close_cursor(l_cursor);
16371: END IF;
16372:
16373: freeglobals;
16374: fnd_message.set_name('WMS', 'WMS_PACKAGE_GEN_FAILED');

Line 16398: IF DBMS_SQL.is_open(l_cursor) THEN

16394: IF rule%ISOPEN THEN
16395: CLOSE rule;
16396: END IF;
16397:
16398: IF DBMS_SQL.is_open(l_cursor) THEN
16399: DBMS_SQL.close_cursor(l_cursor);
16400: END IF;
16401:
16402: freeglobals;

Line 16399: DBMS_SQL.close_cursor(l_cursor);

16395: CLOSE rule;
16396: END IF;
16397:
16398: IF DBMS_SQL.is_open(l_cursor) THEN
16399: DBMS_SQL.close_cursor(l_cursor);
16400: END IF;
16401:
16402: freeglobals;
16403: fnd_message.set_name('WMS', 'WMS_PACKAGE_GEN_FAILED');

Line 18997: -- l_cursor := dbms_sql.open_cursor;

18993: -- Bug# 2430429
18994: -- The call to open_curs was not using bind variables.
18995: -- This was causing performance problems
18996:
18997: -- l_cursor := dbms_sql.open_cursor;
18998: --build dynamic PL/SQL for call to stored procedure;
18999: -- open_curs opens the appropriate cursor for the rule;
19000: -- this call has to be dynamic because of the name of the rule package
19001: IF p_type_code = 2 THEN