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 812: g_build_package_tbl DBMS_SQL.varchar2s;

808: g_stmt_serial_validate LONG;
809: g_stmt_serial_detail LONG;
810: g_stmt_serial_detail_new LONG;
811: g_build_package_row NUMBER;
812: g_build_package_tbl DBMS_SQL.varchar2s;
813: g_default_pick_task_type_id NUMBER;
814: g_default_putaway_task_type_id NUMBER;
815: g_default_cc_task_type_id NUMBER;
816: g_default_repl_task_type_id NUMBER;

Line 12430: l_cursor := DBMS_SQL.open_cursor;

12426:
12427: BEGIN
12428: x_return_status := fnd_api.g_ret_sts_unexp_error;
12429: --open cursor
12430: l_cursor := DBMS_SQL.open_cursor;
12431: --parse cursor
12432: DBMS_SQL.parse(l_cursor, g_build_package_tbl, 1, g_build_package_row, FALSE, DBMS_SQL.native);
12433: --close cursor
12434: DBMS_SQL.close_cursor(l_cursor);

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

12428: x_return_status := fnd_api.g_ret_sts_unexp_error;
12429: --open cursor
12430: l_cursor := DBMS_SQL.open_cursor;
12431: --parse cursor
12432: DBMS_SQL.parse(l_cursor, g_build_package_tbl, 1, g_build_package_row, FALSE, DBMS_SQL.native);
12433: --close cursor
12434: DBMS_SQL.close_cursor(l_cursor);
12435:
12436: /* We may need to call this API for AOL standards

Line 12434: DBMS_SQL.close_cursor(l_cursor);

12430: l_cursor := DBMS_SQL.open_cursor;
12431: --parse cursor
12432: DBMS_SQL.parse(l_cursor, g_build_package_tbl, 1, g_build_package_row, FALSE, DBMS_SQL.native);
12433: --close cursor
12434: DBMS_SQL.close_cursor(l_cursor);
12435:
12436: /* We may need to call this API for AOL standards
12437: --get schema info
12438: l_return := fnd_installation.get_app_info(

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

12760: || l_package_name
12761: || ';';
12762: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
12763: --open cursor
12764: --l_cursor := dbms_sql.open_cursor;
12765: --parse cursor
12766: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
12767: --close cursor
12768: --dbms_sql.close_cursor(l_cursor);

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

12762: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
12763: --open cursor
12764: --l_cursor := dbms_sql.open_cursor;
12765: --parse cursor
12766: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
12767: --close cursor
12768: --dbms_sql.close_cursor(l_cursor);
12769: buildpackage(l_pack_sql);
12770: --create the package spec

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

12764: --l_cursor := dbms_sql.open_cursor;
12765: --parse cursor
12766: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
12767: --close cursor
12768: --dbms_sql.close_cursor(l_cursor);
12769: buildpackage(l_pack_sql);
12770: --create the package spec
12771: createpackage(x_return_status, l_package_name, FALSE);
12772:

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

12827: || l_package_name
12828: || ';';
12829: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
12830: --open cursor
12831: --l_cursor := dbms_sql.open_cursor;
12832: --parse cursor
12833: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
12834: --close cursor
12835: --dbms_sql.close_cursor(l_cursor);

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

12829: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
12830: --open cursor
12831: --l_cursor := dbms_sql.open_cursor;
12832: --parse cursor
12833: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
12834: --close cursor
12835: --dbms_sql.close_cursor(l_cursor);
12836: buildpackage(l_pack_sql);
12837: createpackage(x_return_status, l_package_name, FALSE);

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

12831: --l_cursor := dbms_sql.open_cursor;
12832: --parse cursor
12833: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
12834: --close cursor
12835: --dbms_sql.close_cursor(l_cursor);
12836: buildpackage(l_pack_sql);
12837: createpackage(x_return_status, l_package_name, FALSE);
12838:
12839: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

12891: || l_package_name
12892: || ';';
12893: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
12894: --open cursor
12895: --l_cursor := dbms_sql.open_cursor;
12896: --parse cursor
12897: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
12898: --close cursor
12899: --dbms_sql.close_cursor(l_cursor);

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

12893: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
12894: --open cursor
12895: --l_cursor := dbms_sql.open_cursor;
12896: --parse cursor
12897: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
12898: --close cursor
12899: --dbms_sql.close_cursor(l_cursor);
12900: buildpackage(l_pack_sql);
12901: createpackage(x_return_status, l_package_name, FALSE);

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

12895: --l_cursor := dbms_sql.open_cursor;
12896: --parse cursor
12897: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
12898: --close cursor
12899: --dbms_sql.close_cursor(l_cursor);
12900: buildpackage(l_pack_sql);
12901: createpackage(x_return_status, l_package_name, FALSE);
12902:
12903: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

12958: || l_package_name
12959: || ';';
12960: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
12961: --open cursor
12962: --l_cursor := dbms_sql.open_cursor;
12963: --parse cursor
12964: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
12965: --close cursor
12966: --dbms_sql.close_cursor(l_cursor);

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

12960: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
12961: --open cursor
12962: --l_cursor := dbms_sql.open_cursor;
12963: --parse cursor
12964: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
12965: --close cursor
12966: --dbms_sql.close_cursor(l_cursor);
12967: buildpackage(l_pack_sql);
12968: createpackage(x_return_status, l_package_name, FALSE);

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

12962: --l_cursor := dbms_sql.open_cursor;
12963: --parse cursor
12964: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
12965: --close cursor
12966: --dbms_sql.close_cursor(l_cursor);
12967: buildpackage(l_pack_sql);
12968: createpackage(x_return_status, l_package_name, FALSE);
12969:
12970: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

13064: || ';';
13065: log_procedure(l_api_name, '=>', '********************* 198');
13066: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
13067: --open cursor
13068: --l_cursor := dbms_sql.open_cursor;
13069: --parse cursor
13070: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
13071: --close cursor
13072: --dbms_sql.close_cursor(l_cursor);

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

13066: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
13067: --open cursor
13068: --l_cursor := dbms_sql.open_cursor;
13069: --parse cursor
13070: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
13071: --close cursor
13072: --dbms_sql.close_cursor(l_cursor);
13073: buildpackage(l_pack_sql);
13074: createpackage(x_return_status, l_package_name, FALSE);

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

13068: --l_cursor := dbms_sql.open_cursor;
13069: --parse cursor
13070: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
13071: --close cursor
13072: --dbms_sql.close_cursor(l_cursor);
13073: buildpackage(l_pack_sql);
13074: createpackage(x_return_status, l_package_name, FALSE);
13075:
13076: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

13419: || l_package_name
13420: || ';';
13421: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
13422: --open cursor
13423: --l_cursor := dbms_sql.open_cursor;
13424: --parse cursor
13425: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
13426: --close cursor
13427: --dbms_sql.close_cursor(l_cursor);

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

13421: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
13422: --open cursor
13423: --l_cursor := dbms_sql.open_cursor;
13424: --parse cursor
13425: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
13426: --close cursor
13427: --dbms_sql.close_cursor(l_cursor);
13428: buildpackage(l_pack_sql);
13429: createpackage(x_return_status, l_package_name, FALSE);

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

13423: --l_cursor := dbms_sql.open_cursor;
13424: --parse cursor
13425: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);
13426: --close cursor
13427: --dbms_sql.close_cursor(l_cursor);
13428: buildpackage(l_pack_sql);
13429: createpackage(x_return_status, l_package_name, FALSE);
13430:
13431: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 13640: l_cursor := dbms_sql.open_cursor;

13636: -- inv_pp_debug.send_long_to_pipe(l_pack_body_sql);
13637: /*
13638: --open cursor
13639:
13640: l_cursor := dbms_sql.open_cursor;
13641: dbms_out
13642: --parse cursor
13643:
13644: dbms_sql.parse(l_cursor, l_pack_body_sql, dbms_sql.native);

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

13640: l_cursor := dbms_sql.open_cursor;
13641: dbms_out
13642: --parse cursor
13643:
13644: dbms_sql.parse(l_cursor, l_pack_body_sql, dbms_sql.native);
13645:
13646: --close cursor
13647: dbms_sql.close_cursor(l_cursor);
13648: */

Line 13647: dbms_sql.close_cursor(l_cursor);

13643:
13644: dbms_sql.parse(l_cursor, l_pack_body_sql, dbms_sql.native);
13645:
13646: --close cursor
13647: dbms_sql.close_cursor(l_cursor);
13648: */
13649:
13650:
13651:

Line 13682: IF DBMS_SQL.is_open(l_cursor) THEN

13678: END IF;
13679:
13680: -- end of debugging section
13681: --
13682: IF DBMS_SQL.is_open(l_cursor) THEN
13683: DBMS_SQL.close_cursor(l_cursor);
13684: END IF;
13685:
13686: freeglobals;

Line 13683: DBMS_SQL.close_cursor(l_cursor);

13679:
13680: -- end of debugging section
13681: --
13682: IF DBMS_SQL.is_open(l_cursor) THEN
13683: DBMS_SQL.close_cursor(l_cursor);
13684: END IF;
13685:
13686: freeglobals;
13687: x_return_status := fnd_api.g_ret_sts_error;

Line 13705: IF DBMS_SQL.is_open(l_cursor) THEN

13701: END IF;
13702:
13703: -- end of debugging section
13704: --
13705: IF DBMS_SQL.is_open(l_cursor) THEN
13706: DBMS_SQL.close_cursor(l_cursor);
13707: END IF;
13708:
13709: freeglobals;

Line 13706: DBMS_SQL.close_cursor(l_cursor);

13702:
13703: -- end of debugging section
13704: --
13705: IF DBMS_SQL.is_open(l_cursor) THEN
13706: DBMS_SQL.close_cursor(l_cursor);
13707: END IF;
13708:
13709: freeglobals;
13710: fnd_message.set_name('WMS', 'WMS_PACKAGE_GEN_FAILED');

Line 13734: IF DBMS_SQL.is_open(l_cursor) THEN

13730: IF rule%ISOPEN THEN
13731: CLOSE rule;
13732: END IF;
13733:
13734: IF DBMS_SQL.is_open(l_cursor) THEN
13735: DBMS_SQL.close_cursor(l_cursor);
13736: END IF;
13737:
13738: freeglobals;

Line 13735: DBMS_SQL.close_cursor(l_cursor);

13731: CLOSE rule;
13732: END IF;
13733:
13734: IF DBMS_SQL.is_open(l_cursor) THEN
13735: DBMS_SQL.close_cursor(l_cursor);
13736: END IF;
13737:
13738: freeglobals;
13739: fnd_message.set_name('WMS', 'WMS_PACKAGE_GEN_FAILED');

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

16351: -- Bug# 2430429
16352: -- The call to open_curs was not using bind variables.
16353: -- This was causing performance problems
16354:
16355: -- l_cursor := dbms_sql.open_cursor;
16356: --build dynamic PL/SQL for call to stored procedure;
16357: -- open_curs opens the appropriate cursor for the rule;
16358: -- this call has to be dynamic because of the name of the rule package
16359: IF p_type_code = 2 THEN