APPS.HR_CHKFMT dependencies on DBMS_SQL

Line 650: Use the translate function and dbms_sql package to check for

646: Used to ensure that a name passed in only comprises of:
647: First character : alpha characters (upper or lower case).
648: Subsequent chars: alpha, numeric, space and underscore.
649: NOTES
650: Use the translate function and dbms_sql package to check for
651: illegal chars. Cannot be called from pragma restrict_references
652: code.
653: */
654: function chkpay

Line 770: l_cursor_id := dbms_sql.open_cursor;

766: -- Build a dynamic SQL statement using the name as a variable
767: -- name. This will syntax check the name as a valid PL/SQL name.
768: statement := 'DECLARE ' || chunk || ' NUMBER;BEGIN ' ||
769: chunk || ':=1;END;';
770: l_cursor_id := dbms_sql.open_cursor;
771: dbms_sql.parse( l_cursor_id, statement, dbms_sql.native );
772: dbms_sql.close_cursor( l_cursor_id );
773:
774: -- Move onto next the chunk.

Line 771: dbms_sql.parse( l_cursor_id, statement, dbms_sql.native );

767: -- name. This will syntax check the name as a valid PL/SQL name.
768: statement := 'DECLARE ' || chunk || ' NUMBER;BEGIN ' ||
769: chunk || ':=1;END;';
770: l_cursor_id := dbms_sql.open_cursor;
771: dbms_sql.parse( l_cursor_id, statement, dbms_sql.native );
772: dbms_sql.close_cursor( l_cursor_id );
773:
774: -- Move onto next the chunk.
775: spos := epos + 1;

Line 772: dbms_sql.close_cursor( l_cursor_id );

768: statement := 'DECLARE ' || chunk || ' NUMBER;BEGIN ' ||
769: chunk || ':=1;END;';
770: l_cursor_id := dbms_sql.open_cursor;
771: dbms_sql.parse( l_cursor_id, statement, dbms_sql.native );
772: dbms_sql.close_cursor( l_cursor_id );
773:
774: -- Move onto next the chunk.
775: spos := epos + 1;
776: epos := clen;

Line 799: if ( dbms_sql.is_open( l_cursor_id ) ) then

795: begin
796: --
797: -- Make sure that the cursor was closed.
798: --
799: if ( dbms_sql.is_open( l_cursor_id ) ) then
800: dbms_sql.close_cursor( l_cursor_id );
801: end if;
802: return( FALSE );
803: end;

Line 800: dbms_sql.close_cursor( l_cursor_id );

796: --
797: -- Make sure that the cursor was closed.
798: --
799: if ( dbms_sql.is_open( l_cursor_id ) ) then
800: dbms_sql.close_cursor( l_cursor_id );
801: end if;
802: return( FALSE );
803: end;
804: end chkpay;

Line 820: Use the translate function and dbms_sql package to check for

816: JULY-2004: introduced a new style of database item name where
817: any text within double-quotes is allowed.
818:
819: NOTES
820: Use the translate function and dbms_sql package to check for
821: illegal chars. Cannot be called from pragma restrict_references
822: code.
823: */
824: function chkdbi

Line 1001: l_cursor_id := dbms_sql.open_cursor;

997: -- Build a dynamic SQL statement using the name as a variable
998: -- name. This will syntax check the name as a valid PL/SQL name.
999: statement := 'DECLARE ' || chunk || ' NUMBER;BEGIN ' ||
1000: chunk || ':=1;END;';
1001: l_cursor_id := dbms_sql.open_cursor;
1002: dbms_sql.parse( l_cursor_id, statement, dbms_sql.native );
1003: dbms_sql.close_cursor( l_cursor_id );
1004:
1005: -- Move onto next the chunk.

Line 1002: dbms_sql.parse( l_cursor_id, statement, dbms_sql.native );

998: -- name. This will syntax check the name as a valid PL/SQL name.
999: statement := 'DECLARE ' || chunk || ' NUMBER;BEGIN ' ||
1000: chunk || ':=1;END;';
1001: l_cursor_id := dbms_sql.open_cursor;
1002: dbms_sql.parse( l_cursor_id, statement, dbms_sql.native );
1003: dbms_sql.close_cursor( l_cursor_id );
1004:
1005: -- Move onto next the chunk.
1006: spos := epos + 1;

Line 1003: dbms_sql.close_cursor( l_cursor_id );

999: statement := 'DECLARE ' || chunk || ' NUMBER;BEGIN ' ||
1000: chunk || ':=1;END;';
1001: l_cursor_id := dbms_sql.open_cursor;
1002: dbms_sql.parse( l_cursor_id, statement, dbms_sql.native );
1003: dbms_sql.close_cursor( l_cursor_id );
1004:
1005: -- Move onto next the chunk.
1006: spos := epos + 1;
1007: epos := clen;

Line 1030: if ( dbms_sql.is_open( l_cursor_id ) ) then

1026: begin
1027: --
1028: -- Make sure that the cursor was closed.
1029: --
1030: if ( dbms_sql.is_open( l_cursor_id ) ) then
1031: dbms_sql.close_cursor( l_cursor_id );
1032: end if;
1033: return( FALSE );
1034: end;

Line 1031: dbms_sql.close_cursor( l_cursor_id );

1027: --
1028: -- Make sure that the cursor was closed.
1029: --
1030: if ( dbms_sql.is_open( l_cursor_id ) ) then
1031: dbms_sql.close_cursor( l_cursor_id );
1032: end if;
1033: return( FALSE );
1034: end;
1035: end chkdbi;