APPS.WMS_RULES_PKG dependencies on DBMS_SQL

Line 392: l_cursor := DBMS_SQL.open_cursor;

388: l_package_name VARCHAR2(300);
389:
390: begin
391: /* 11858604 Start */
392: l_cursor := DBMS_SQL.open_cursor;
393: l_package_name := 'WMS_RULE_' || x_rule_id;
394: l_sql := 'DROP PACKAGE ' || l_package_name ;
395: /* 11858604 End */
396: delete from WMS_RULES_TL

Line 411: DBMS_SQL.parse(l_cursor, l_sql, DBMS_SQL.native);

407: raise no_data_found;
408: end if;
409: /* 11858604 Start */
410: --parse cursor
411: DBMS_SQL.parse(l_cursor, l_sql, DBMS_SQL.native);
412: --close cursor
413: DBMS_SQL.close_cursor(l_cursor);
414: EXCEPTION
415: WHEN OTHERS THEN

Line 413: DBMS_SQL.close_cursor(l_cursor);

409: /* 11858604 Start */
410: --parse cursor
411: DBMS_SQL.parse(l_cursor, l_sql, DBMS_SQL.native);
412: --close cursor
413: DBMS_SQL.close_cursor(l_cursor);
414: EXCEPTION
415: WHEN OTHERS THEN
416: DBMS_SQL.close_cursor(l_cursor);
417: /* 11858604 End */

Line 416: DBMS_SQL.close_cursor(l_cursor);

412: --close cursor
413: DBMS_SQL.close_cursor(l_cursor);
414: EXCEPTION
415: WHEN OTHERS THEN
416: DBMS_SQL.close_cursor(l_cursor);
417: /* 11858604 End */
418: end DELETE_ROW;
419:
420: procedure ADD_LANGUAGE