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.OKC_CONDITION_EVAL_PVT dependencies on DBMS_SQL

Line 398: ---** Bug#2934909 converting execute immediate into dbms_sql to bind input variables

394:
395:
396: RETURN(x_function_value);
397: ELSE
398: ---** Bug#2934909 converting execute immediate into dbms_sql to bind input variables
399: -- ** as per new coding standards to avoid data security problems.
400: bind_var_tab.extend;
401: bind_ctr := bind_ctr+1;
402: l_string := pdf_rec.function_name || '('||pdf_rec.parameter_name||

Line 430: ---** Bug#2934909 converting execute immediate into dbms_sql to bind input variables

426: END IF;
427: -- return T or F
428: IF l_string IS NOT NULL THEN
429: func_string := 'begin '||l_string||' end;';
430: ---** Bug#2934909 converting execute immediate into dbms_sql to bind input variables
431: -- ** as per new coding standards to avoid data security problems.
432: BEGIN
433: bind_cur := dbms_sql.open_cursor;
434: dbms_sql.parse(bind_cur, func_string, dbms_sql.native);

Line 433: bind_cur := dbms_sql.open_cursor;

429: func_string := 'begin '||l_string||' end;';
430: ---** Bug#2934909 converting execute immediate into dbms_sql to bind input variables
431: -- ** as per new coding standards to avoid data security problems.
432: BEGIN
433: bind_cur := dbms_sql.open_cursor;
434: dbms_sql.parse(bind_cur, func_string, dbms_sql.native);
435: dbms_sql.bind_variable(bind_cur,'retval','A');
436: FOR i IN 1.. bind_var_tab.COUNT LOOP
437: dbms_sql.bind_variable(bind_cur,to_char(bind_var_tab(i).ctr),bind_var_tab(i).value);

Line 434: dbms_sql.parse(bind_cur, func_string, dbms_sql.native);

430: ---** Bug#2934909 converting execute immediate into dbms_sql to bind input variables
431: -- ** as per new coding standards to avoid data security problems.
432: BEGIN
433: bind_cur := dbms_sql.open_cursor;
434: dbms_sql.parse(bind_cur, func_string, dbms_sql.native);
435: dbms_sql.bind_variable(bind_cur,'retval','A');
436: FOR i IN 1.. bind_var_tab.COUNT LOOP
437: dbms_sql.bind_variable(bind_cur,to_char(bind_var_tab(i).ctr),bind_var_tab(i).value);
438: END LOOP;

Line 435: dbms_sql.bind_variable(bind_cur,'retval','A');

431: -- ** as per new coding standards to avoid data security problems.
432: BEGIN
433: bind_cur := dbms_sql.open_cursor;
434: dbms_sql.parse(bind_cur, func_string, dbms_sql.native);
435: dbms_sql.bind_variable(bind_cur,'retval','A');
436: FOR i IN 1.. bind_var_tab.COUNT LOOP
437: dbms_sql.bind_variable(bind_cur,to_char(bind_var_tab(i).ctr),bind_var_tab(i).value);
438: END LOOP;
439: x_function_value := dbms_sql.execute(bind_cur);

Line 437: dbms_sql.bind_variable(bind_cur,to_char(bind_var_tab(i).ctr),bind_var_tab(i).value);

433: bind_cur := dbms_sql.open_cursor;
434: dbms_sql.parse(bind_cur, func_string, dbms_sql.native);
435: dbms_sql.bind_variable(bind_cur,'retval','A');
436: FOR i IN 1.. bind_var_tab.COUNT LOOP
437: dbms_sql.bind_variable(bind_cur,to_char(bind_var_tab(i).ctr),bind_var_tab(i).value);
438: END LOOP;
439: x_function_value := dbms_sql.execute(bind_cur);
440: dbms_sql.variable_value(bind_cur,'retval',v_retval);
441: dbms_sql.close_cursor(bind_cur);

Line 439: x_function_value := dbms_sql.execute(bind_cur);

435: dbms_sql.bind_variable(bind_cur,'retval','A');
436: FOR i IN 1.. bind_var_tab.COUNT LOOP
437: dbms_sql.bind_variable(bind_cur,to_char(bind_var_tab(i).ctr),bind_var_tab(i).value);
438: END LOOP;
439: x_function_value := dbms_sql.execute(bind_cur);
440: dbms_sql.variable_value(bind_cur,'retval',v_retval);
441: dbms_sql.close_cursor(bind_cur);
442: END;
443: ---** Bug#2934909 END **----------

Line 440: dbms_sql.variable_value(bind_cur,'retval',v_retval);

436: FOR i IN 1.. bind_var_tab.COUNT LOOP
437: dbms_sql.bind_variable(bind_cur,to_char(bind_var_tab(i).ctr),bind_var_tab(i).value);
438: END LOOP;
439: x_function_value := dbms_sql.execute(bind_cur);
440: dbms_sql.variable_value(bind_cur,'retval',v_retval);
441: dbms_sql.close_cursor(bind_cur);
442: END;
443: ---** Bug#2934909 END **----------
444: --EXECUTE IMMEDIATE func_string into x_function_value;

Line 441: dbms_sql.close_cursor(bind_cur);

437: dbms_sql.bind_variable(bind_cur,to_char(bind_var_tab(i).ctr),bind_var_tab(i).value);
438: END LOOP;
439: x_function_value := dbms_sql.execute(bind_cur);
440: dbms_sql.variable_value(bind_cur,'retval',v_retval);
441: dbms_sql.close_cursor(bind_cur);
442: END;
443: ---** Bug#2934909 END **----------
444: --EXECUTE IMMEDIATE func_string into x_function_value;
445:

Line 457: dbms_sql.close_cursor(bind_cur);

453:
454: EXCEPTION
455: WHEN OTHERS THEN
456: -- close the cursor
457: dbms_sql.close_cursor(bind_cur);
458: RETURN(v_retval);
459: RAISE;
460:
461: END get_function_value;

Line 787: ---** Bug#2934909 converting execute immediate into dbms_sql to bind input variables

783: ELSIF UPPER(cnl_rec.relational_operator) = 'IS NOT NULL' THEN
784: rel_op := '<>';
785: ELSE rel_op := cnl_rec.relational_operator;
786: END IF;
787: ---** Bug#2934909 converting execute immediate into dbms_sql to bind input variables
788: -- ** as per new coding standards to avoid data security problems.
789: bind_var_tab.extend;
790: bind_ctr := bind_ctr+1;
791: l_string := l_string || cnl_rec.left_parenthesis;

Line 836: ---** Bug#2934909 converting execute immediate into dbms_sql to bind input variables

832: -- In R12 counter_group_log_id is discontinued added new method call get_last_counter_reading
833: l_previous_counter_val:= get_last_counter_reading(
834: p_cnh_id,
835: cnl_rec.acn_id);
836: ---** Bug#2934909 converting execute immediate into dbms_sql to bind input variables
837: -- ** as per new coding standards to avoid data security problems.
838: l_string :=evaluate_counter_condition(
839: cnl_rec.id ,
840: l_previous_counter_val,

Line 875: ---** Bug#2934909 converting execute immediate into dbms_sql to bind input variables

871: END LOOP;
872: CLOSE cnl_cur;
873: IF l_string is not null THEN
874: l_string := 'BEGIN select ''X'' INTO :v_result from dual where '||l_string||'; END;';
875: ---** Bug#2934909 converting execute immediate into dbms_sql to bind input variables
876: -- ** as per new coding standards to avoid data security problems.
877: BEGIN
878: b := dbms_sql.open_cursor;
879: dbms_sql.parse(b, l_string, dbms_sql.native);

Line 878: b := dbms_sql.open_cursor;

874: l_string := 'BEGIN select ''X'' INTO :v_result from dual where '||l_string||'; END;';
875: ---** Bug#2934909 converting execute immediate into dbms_sql to bind input variables
876: -- ** as per new coding standards to avoid data security problems.
877: BEGIN
878: b := dbms_sql.open_cursor;
879: dbms_sql.parse(b, l_string, dbms_sql.native);
880: dbms_sql.bind_variable(b,':v_result',v_result,20);
881: FOR i IN 1.. bind_var_tab.COUNT LOOP
882: dbms_sql.bind_variable(b,to_char(bind_var_tab(i).ctr),bind_var_tab(i).value);

Line 879: dbms_sql.parse(b, l_string, dbms_sql.native);

875: ---** Bug#2934909 converting execute immediate into dbms_sql to bind input variables
876: -- ** as per new coding standards to avoid data security problems.
877: BEGIN
878: b := dbms_sql.open_cursor;
879: dbms_sql.parse(b, l_string, dbms_sql.native);
880: dbms_sql.bind_variable(b,':v_result',v_result,20);
881: FOR i IN 1.. bind_var_tab.COUNT LOOP
882: dbms_sql.bind_variable(b,to_char(bind_var_tab(i).ctr),bind_var_tab(i).value);
883: END LOOP;

Line 880: dbms_sql.bind_variable(b,':v_result',v_result,20);

876: -- ** as per new coding standards to avoid data security problems.
877: BEGIN
878: b := dbms_sql.open_cursor;
879: dbms_sql.parse(b, l_string, dbms_sql.native);
880: dbms_sql.bind_variable(b,':v_result',v_result,20);
881: FOR i IN 1.. bind_var_tab.COUNT LOOP
882: dbms_sql.bind_variable(b,to_char(bind_var_tab(i).ctr),bind_var_tab(i).value);
883: END LOOP;
884: l_processed := dbms_sql.execute(b);

Line 882: dbms_sql.bind_variable(b,to_char(bind_var_tab(i).ctr),bind_var_tab(i).value);

878: b := dbms_sql.open_cursor;
879: dbms_sql.parse(b, l_string, dbms_sql.native);
880: dbms_sql.bind_variable(b,':v_result',v_result,20);
881: FOR i IN 1.. bind_var_tab.COUNT LOOP
882: dbms_sql.bind_variable(b,to_char(bind_var_tab(i).ctr),bind_var_tab(i).value);
883: END LOOP;
884: l_processed := dbms_sql.execute(b);
885: dbms_sql.variable_value(b,':v_result',v_result);
886:

Line 884: l_processed := dbms_sql.execute(b);

880: dbms_sql.bind_variable(b,':v_result',v_result,20);
881: FOR i IN 1.. bind_var_tab.COUNT LOOP
882: dbms_sql.bind_variable(b,to_char(bind_var_tab(i).ctr),bind_var_tab(i).value);
883: END LOOP;
884: l_processed := dbms_sql.execute(b);
885: dbms_sql.variable_value(b,':v_result',v_result);
886:
887: dbms_sql.close_cursor(b);
888: --EXECUTE IMMEDIATE l_string INTO v_result;

Line 885: dbms_sql.variable_value(b,':v_result',v_result);

881: FOR i IN 1.. bind_var_tab.COUNT LOOP
882: dbms_sql.bind_variable(b,to_char(bind_var_tab(i).ctr),bind_var_tab(i).value);
883: END LOOP;
884: l_processed := dbms_sql.execute(b);
885: dbms_sql.variable_value(b,':v_result',v_result);
886:
887: dbms_sql.close_cursor(b);
888: --EXECUTE IMMEDIATE l_string INTO v_result;
889: IF v_result = 'X' THEN

Line 887: dbms_sql.close_cursor(b);

883: END LOOP;
884: l_processed := dbms_sql.execute(b);
885: dbms_sql.variable_value(b,':v_result',v_result);
886:
887: dbms_sql.close_cursor(b);
888: --EXECUTE IMMEDIATE l_string INTO v_result;
889: IF v_result = 'X' THEN
890: x_status := 'TRUE';
891: ELSE x_status := 'FALSE';

Line 896: dbms_sql.close_cursor(b);

892: END IF;
893: EXCEPTION
894: WHEN NO_DATA_FOUND THEN
895: -- bug#3192369
896: dbms_sql.close_cursor(b);
897: x_status := 'FALSE';
898: WHEN others THEN
899: -- bug#3188367
900: dbms_sql.close_cursor(b);

Line 900: dbms_sql.close_cursor(b);

896: dbms_sql.close_cursor(b);
897: x_status := 'FALSE';
898: WHEN others THEN
899: -- bug#3188367
900: dbms_sql.close_cursor(b);
901:
902: x_status := 'FALSE';
903: END;
904: ---** Bug#2934909 converting execute immediate into dbms_sql ** END ** ----

Line 904: --- Bug#2934909 converting execute immediate into dbms_sql END ** ----

900: dbms_sql.close_cursor(b);
901:
902: x_status := 'FALSE';
903: END;
904: ---** Bug#2934909 converting execute immediate into dbms_sql ** END ** ----
905: END IF;
906: x_return_status := OKC_API.G_RET_STS_SUCCESS;
907:
908: IF (l_debug = 'Y') THEN