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.QP_FORMULA_RULES_PVT dependencies on DUAL

Line 83: select replace(l_formula,'''','''''') into l_formula from dual;--6726052,7249280 smbalara

79: i integer := 0;
80: j integer := 1;
81: BEGIN
82: l_length := length(l_formula);
83: select replace(l_formula,'''','''''') into l_formula from dual;--6726052,7249280 smbalara
84: while (l_length > 200)
85: loop
86: i := i + 1;
87: l_formula_tab(i) := substr(l_formula,l_start,200);

Line 667: --l_expression := 'declare l_res number; TYPE t_Operand_Tbl_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; l_oper t_Operand_Tbl_Type; begin Select ' || l_new_formula || ' into l_res from dual; end;';

663: l_category := 'EXPRESSION';
664: WHEN OTHERS THEN
665: Begin
666: -- modified by rassharm changed l_expression replacing p_operand_tbl to l_oper for immediate execution 5713302
667: --l_expression := 'declare l_res number; TYPE t_Operand_Tbl_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; l_oper t_Operand_Tbl_Type; begin Select ' || l_new_formula || ' into l_res from dual; end;';
668: l_expression := 'declare l_res number; TYPE t_Operand_Tbl_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; p_Operand_Tbl t_Operand_Tbl_Type; begin Select ' || l_new_formula || ' into l_res from dual; end;';
669: --dbms_output.put_line('Exp is - ' || substr(l_expression,1,220));
670: Text(' dbms_output.put_line('''|| l_expression||''');',3);
671: execute immediate l_expression;

Line 668: l_expression := 'declare l_res number; TYPE t_Operand_Tbl_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; p_Operand_Tbl t_Operand_Tbl_Type; begin Select ' || l_new_formula || ' into l_res from dual; end;';

664: WHEN OTHERS THEN
665: Begin
666: -- modified by rassharm changed l_expression replacing p_operand_tbl to l_oper for immediate execution 5713302
667: --l_expression := 'declare l_res number; TYPE t_Operand_Tbl_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; l_oper t_Operand_Tbl_Type; begin Select ' || l_new_formula || ' into l_res from dual; end;';
668: l_expression := 'declare l_res number; TYPE t_Operand_Tbl_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; p_Operand_Tbl t_Operand_Tbl_Type; begin Select ' || l_new_formula || ' into l_res from dual; end;';
669: --dbms_output.put_line('Exp is - ' || substr(l_expression,1,220));
670: Text(' dbms_output.put_line('''|| l_expression||''');',3);
671: execute immediate l_expression;
672: l_category := 'PLSQL';

Line 697: l_select_stmt := 'SELECT '|| l_new_formula || ' INTO x_formula_value FROM DUAL';

693: Text('x_return_status := ''S''' || ';',4);
694: --dbms_output.put_line('IN EXPRESSION ');
695: ELSIF l_category = 'PLSQL' THEN
696: --Break_Text('oe_debug_pub.add(''Formula - ' || l_new_formula || ''')',4);
697: l_select_stmt := 'SELECT '|| l_new_formula || ' INTO x_formula_value FROM DUAL';
698: Break_Text(l_select_stmt, 4);
699: Text('x_return_status := ''S''' || ';',4);
700: --dbms_output.put_line('IN PLSQL ');
701: ELSIF l_category = 'SQL' THEN

Line 703: --select replace(l_temp_new_formula,'''','''''') into l_temp_new_formula from dual;--6726052,7249280 smbalara:commented for 8348005

699: Text('x_return_status := ''S''' || ';',4);
700: --dbms_output.put_line('IN PLSQL ');
701: ELSIF l_category = 'SQL' THEN
702: --Break_Text('oe_debug_pub.add(''Formula - ' || l_new_formula || ''')',4);
703: --select replace(l_temp_new_formula,'''','''''') into l_temp_new_formula from dual;--6726052,7249280 smbalara:commented for 8348005
704: l_select_stmt := 'EXECUTE IMMEDIATE '' SELECT '|| l_temp_new_formula || ' FROM DUAL '' INTO x_formula_value using ' || l_using_clause;
705: Break_Text(l_select_stmt, 4);
706: Text('x_return_status := ''S''' || ';',4);
707: --dbms_output.put_line('IN SQL ');

Line 704: l_select_stmt := 'EXECUTE IMMEDIATE '' SELECT '|| l_temp_new_formula || ' FROM DUAL '' INTO x_formula_value using ' || l_using_clause;

700: --dbms_output.put_line('IN PLSQL ');
701: ELSIF l_category = 'SQL' THEN
702: --Break_Text('oe_debug_pub.add(''Formula - ' || l_new_formula || ''')',4);
703: --select replace(l_temp_new_formula,'''','''''') into l_temp_new_formula from dual;--6726052,7249280 smbalara:commented for 8348005
704: l_select_stmt := 'EXECUTE IMMEDIATE '' SELECT '|| l_temp_new_formula || ' FROM DUAL '' INTO x_formula_value using ' || l_using_clause;
705: Break_Text(l_select_stmt, 4);
706: Text('x_return_status := ''S''' || ';',4);
707: --dbms_output.put_line('IN SQL ');
708: END IF;