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 592: --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;';

588: l_category := 'EXPRESSION';
589: WHEN OTHERS THEN
590: Begin
591: -- modified by rassharm changed l_expression replacing p_operand_tbl to l_oper for immediate execution 5713302
592: --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;';
593: 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;';
594: --dbms_output.put_line('Exp is - ' || substr(l_expression,1,220));
595: Text(' dbms_output.put_line('''|| l_expression||''');',3);
596: execute immediate l_expression;

Line 593: 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;';

589: WHEN OTHERS THEN
590: Begin
591: -- modified by rassharm changed l_expression replacing p_operand_tbl to l_oper for immediate execution 5713302
592: --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;';
593: 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;';
594: --dbms_output.put_line('Exp is - ' || substr(l_expression,1,220));
595: Text(' dbms_output.put_line('''|| l_expression||''');',3);
596: execute immediate l_expression;
597: l_category := 'PLSQL';

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

618: Text('x_return_status := ''S''' || ';',4);
619: --dbms_output.put_line('IN EXPRESSION ');
620: ELSIF l_category = 'PLSQL' THEN
621: --Break_Text('oe_debug_pub.add(''Formula - ' || l_new_formula || ''')',4);
622: l_select_stmt := 'SELECT '|| l_new_formula || ' INTO x_formula_value FROM DUAL';
623: Break_Text(l_select_stmt, 4);
624: Text('x_return_status := ''S''' || ';',4);
625: --dbms_output.put_line('IN PLSQL ');
626: ELSIF l_category = 'SQL' THEN

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

624: Text('x_return_status := ''S''' || ';',4);
625: --dbms_output.put_line('IN PLSQL ');
626: ELSIF l_category = 'SQL' THEN
627: --Break_Text('oe_debug_pub.add(''Formula - ' || l_new_formula || ''')',4);
628: select replace(l_temp_new_formula,'''','''''') into l_temp_new_formula from dual;--6726052,7249280 smbalara
629: l_select_stmt := 'EXECUTE IMMEDIATE '' SELECT '|| l_temp_new_formula || ' FROM DUAL '' INTO x_formula_value using ' || l_using_clause;
630: Break_Text(l_select_stmt, 4);
631: Text('x_return_status := ''S''' || ';',4);
632: --dbms_output.put_line('IN SQL ');

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

625: --dbms_output.put_line('IN PLSQL ');
626: ELSIF l_category = 'SQL' THEN
627: --Break_Text('oe_debug_pub.add(''Formula - ' || l_new_formula || ''')',4);
628: select replace(l_temp_new_formula,'''','''''') into l_temp_new_formula from dual;--6726052,7249280 smbalara
629: l_select_stmt := 'EXECUTE IMMEDIATE '' SELECT '|| l_temp_new_formula || ' FROM DUAL '' INTO x_formula_value using ' || l_using_clause;
630: Break_Text(l_select_stmt, 4);
631: Text('x_return_status := ''S''' || ';',4);
632: --dbms_output.put_line('IN SQL ');
633: END IF;