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 12810: c := dbms_sql.open_cursor;

12806: n NUMBER;
12807: l_custom BOOLEAN;
12808:
12809: BEGIN
12810: c := dbms_sql.open_cursor;
12811: l_sql := 'select ' || proc ||
12812: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
12813: dbms_sql.parse(c,l_sql,2);
12814: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');

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

12809: BEGIN
12810: c := dbms_sql.open_cursor;
12811: l_sql := 'select ' || proc ||
12812: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
12813: dbms_sql.parse(c,l_sql,2);
12814: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12815: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12816: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12817: DBMS_SQL.BIND_VARIABLE(c,':entity','x');

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

12810: c := dbms_sql.open_cursor;
12811: l_sql := 'select ' || proc ||
12812: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
12813: dbms_sql.parse(c,l_sql,2);
12814: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12815: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12816: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12817: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12818: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');

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

12811: l_sql := 'select ' || proc ||
12812: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
12813: dbms_sql.parse(c,l_sql,2);
12814: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12815: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12816: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12817: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12818: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12819: n:=DBMS_SQL.execute(c);

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

12812: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
12813: dbms_sql.parse(c,l_sql,2);
12814: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12815: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12816: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12817: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12818: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12819: n:=DBMS_SQL.execute(c);
12820: dbms_sql.close_cursor(c);

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

12813: dbms_sql.parse(c,l_sql,2);
12814: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12815: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12816: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12817: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12818: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12819: n:=DBMS_SQL.execute(c);
12820: dbms_sql.close_cursor(c);
12821: RETURN TRUE;

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

12814: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12815: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12816: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12817: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12818: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12819: n:=DBMS_SQL.execute(c);
12820: dbms_sql.close_cursor(c);
12821: RETURN TRUE;
12822: EXCEPTION

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

12815: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12816: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12817: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12818: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12819: n:=DBMS_SQL.execute(c);
12820: dbms_sql.close_cursor(c);
12821: RETURN TRUE;
12822: EXCEPTION
12823: WHEN OTHERS THEN

Line 12820: dbms_sql.close_cursor(c);

12816: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12817: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12818: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12819: n:=DBMS_SQL.execute(c);
12820: dbms_sql.close_cursor(c);
12821: RETURN TRUE;
12822: EXCEPTION
12823: WHEN OTHERS THEN
12824: dbms_sql.close_cursor(c);

Line 12824: dbms_sql.close_cursor(c);

12820: dbms_sql.close_cursor(c);
12821: RETURN TRUE;
12822: EXCEPTION
12823: WHEN OTHERS THEN
12824: dbms_sql.close_cursor(c);
12825: RETURN FALSE;
12826: END;
12827:
12828: --VJN Introduced for Bulk Match Rules