APPS.HR_H2PI_PERSON_UPLOAD dependencies on DBMS_SQL

Line 630: l_csr_handle := dbms_sql.open_cursor;

626: ','||''''||'YYYY/MM/DD'||''''||'));'||fnd_global.local_chr(10)||
627: 'END;';
628:
629: hr_utility.trace(l_sql_parse);
630: l_csr_handle := dbms_sql.open_cursor;
631: dbms_sql.parse(l_csr_handle,
632: l_sql_parse,
633: dbms_sql.native);
634: l_csr_rows := dbms_sql.execute(l_csr_handle);

Line 631: dbms_sql.parse(l_csr_handle,

627: 'END;';
628:
629: hr_utility.trace(l_sql_parse);
630: l_csr_handle := dbms_sql.open_cursor;
631: dbms_sql.parse(l_csr_handle,
632: l_sql_parse,
633: dbms_sql.native);
634: l_csr_rows := dbms_sql.execute(l_csr_handle);
635: dbms_sql.close_cursor(l_csr_handle);

Line 633: dbms_sql.native);

629: hr_utility.trace(l_sql_parse);
630: l_csr_handle := dbms_sql.open_cursor;
631: dbms_sql.parse(l_csr_handle,
632: l_sql_parse,
633: dbms_sql.native);
634: l_csr_rows := dbms_sql.execute(l_csr_handle);
635: dbms_sql.close_cursor(l_csr_handle);
636:
637: EXCEPTION

Line 634: l_csr_rows := dbms_sql.execute(l_csr_handle);

630: l_csr_handle := dbms_sql.open_cursor;
631: dbms_sql.parse(l_csr_handle,
632: l_sql_parse,
633: dbms_sql.native);
634: l_csr_rows := dbms_sql.execute(l_csr_handle);
635: dbms_sql.close_cursor(l_csr_handle);
636:
637: EXCEPTION
638: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN

Line 635: dbms_sql.close_cursor(l_csr_handle);

631: dbms_sql.parse(l_csr_handle,
632: l_sql_parse,
633: dbms_sql.native);
634: l_csr_rows := dbms_sql.execute(l_csr_handle);
635: dbms_sql.close_cursor(l_csr_handle);
636:
637: EXCEPTION
638: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
639: hr_utility.set_location(l_proc, 50);