DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_COMPILE dependencies on DBMS_SQL

Line 733: c := dbms_sql.open_cursor;

729:
730: FUNCTION check_proc (p_rule_id NUMBER) RETURN BOOLEAN IS
731: c NUMBER;
732: BEGIN
733: c := dbms_sql.open_cursor;
734: dbms_sql.parse(c,replace(l_sql,'RULEID',to_char(p_rule_id)),2);
735: dbms_sql.close_cursor(c);
736: RETURN TRUE;
737: EXCEPTION

Line 734: dbms_sql.parse(c,replace(l_sql,'RULEID',to_char(p_rule_id)),2);

730: FUNCTION check_proc (p_rule_id NUMBER) RETURN BOOLEAN IS
731: c NUMBER;
732: BEGIN
733: c := dbms_sql.open_cursor;
734: dbms_sql.parse(c,replace(l_sql,'RULEID',to_char(p_rule_id)),2);
735: dbms_sql.close_cursor(c);
736: RETURN TRUE;
737: EXCEPTION
738: WHEN OTHERS THEN

Line 735: dbms_sql.close_cursor(c);

731: c NUMBER;
732: BEGIN
733: c := dbms_sql.open_cursor;
734: dbms_sql.parse(c,replace(l_sql,'RULEID',to_char(p_rule_id)),2);
735: dbms_sql.close_cursor(c);
736: RETURN TRUE;
737: EXCEPTION
738: WHEN OTHERS THEN
739: RETURN FALSE;

Line 12754: c := dbms_sql.open_cursor;

12750: n NUMBER;
12751: l_custom BOOLEAN;
12752:
12753: BEGIN
12754: c := dbms_sql.open_cursor;
12755: l_sql := 'select ' || proc ||
12756: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
12757: dbms_sql.parse(c,l_sql,2);
12758: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');

Line 12757: dbms_sql.parse(c,l_sql,2);

12753: BEGIN
12754: c := dbms_sql.open_cursor;
12755: l_sql := 'select ' || proc ||
12756: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
12757: dbms_sql.parse(c,l_sql,2);
12758: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12759: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12760: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12761: DBMS_SQL.BIND_VARIABLE(c,':entity','x');

Line 12758: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');

12754: c := dbms_sql.open_cursor;
12755: l_sql := 'select ' || proc ||
12756: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
12757: dbms_sql.parse(c,l_sql,2);
12758: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12759: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12760: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12761: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12762: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');

Line 12759: DBMS_SQL.BIND_VARIABLE(c,':lang','x');

12755: l_sql := 'select ' || proc ||
12756: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
12757: dbms_sql.parse(c,l_sql,2);
12758: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12759: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12760: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12761: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12762: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12763: n:=DBMS_SQL.execute(c);

Line 12760: DBMS_SQL.BIND_VARIABLE(c,':attr','x');

12756: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
12757: dbms_sql.parse(c,l_sql,2);
12758: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12759: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12760: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12761: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12762: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12763: n:=DBMS_SQL.execute(c);
12764: dbms_sql.close_cursor(c);

Line 12761: DBMS_SQL.BIND_VARIABLE(c,':entity','x');

12757: dbms_sql.parse(c,l_sql,2);
12758: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12759: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12760: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12761: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12762: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12763: n:=DBMS_SQL.execute(c);
12764: dbms_sql.close_cursor(c);
12765: RETURN TRUE;

Line 12762: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');

12758: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12759: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12760: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12761: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12762: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12763: n:=DBMS_SQL.execute(c);
12764: dbms_sql.close_cursor(c);
12765: RETURN TRUE;
12766: EXCEPTION

Line 12763: n:=DBMS_SQL.execute(c);

12759: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12760: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12761: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12762: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12763: n:=DBMS_SQL.execute(c);
12764: dbms_sql.close_cursor(c);
12765: RETURN TRUE;
12766: EXCEPTION
12767: WHEN OTHERS THEN

Line 12764: dbms_sql.close_cursor(c);

12760: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12761: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12762: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12763: n:=DBMS_SQL.execute(c);
12764: dbms_sql.close_cursor(c);
12765: RETURN TRUE;
12766: EXCEPTION
12767: WHEN OTHERS THEN
12768: dbms_sql.close_cursor(c);

Line 12768: dbms_sql.close_cursor(c);

12764: dbms_sql.close_cursor(c);
12765: RETURN TRUE;
12766: EXCEPTION
12767: WHEN OTHERS THEN
12768: dbms_sql.close_cursor(c);
12769: RETURN FALSE;
12770: END;
12771:
12772: --VJN Introduced for Bulk Match Rules