APPS.HXC_APPROVAL_WF_PKG dependencies on DBMS_SQL

Line 1781: l_cursor := dbms_sql.open_cursor;

1777: hr_utility.trace('Period End Date (from function) is : ' ||
1778: to_char(l_period_end_date, 'DD-MM-YYYY'));
1779: end if;
1780:
1781: l_cursor := dbms_sql.open_cursor;
1782: dbms_sql.parse(l_cursor, l_call_proc, DBMS_SQL.V7);
1783: l_ret := dbms_sql.execute(l_cursor);
1784: dbms_sql.close_cursor(l_cursor);
1785:

Line 1782: dbms_sql.parse(l_cursor, l_call_proc, DBMS_SQL.V7);

1778: to_char(l_period_end_date, 'DD-MM-YYYY'));
1779: end if;
1780:
1781: l_cursor := dbms_sql.open_cursor;
1782: dbms_sql.parse(l_cursor, l_call_proc, DBMS_SQL.V7);
1783: l_ret := dbms_sql.execute(l_cursor);
1784: dbms_sql.close_cursor(l_cursor);
1785:
1786: if g_debug then

Line 1783: l_ret := dbms_sql.execute(l_cursor);

1779: end if;
1780:
1781: l_cursor := dbms_sql.open_cursor;
1782: dbms_sql.parse(l_cursor, l_call_proc, DBMS_SQL.V7);
1783: l_ret := dbms_sql.execute(l_cursor);
1784: dbms_sql.close_cursor(l_cursor);
1785:
1786: if g_debug then
1787: hr_utility.set_location(l_proc, 110);

Line 1784: dbms_sql.close_cursor(l_cursor);

1780:
1781: l_cursor := dbms_sql.open_cursor;
1782: dbms_sql.parse(l_cursor, l_call_proc, DBMS_SQL.V7);
1783: l_ret := dbms_sql.execute(l_cursor);
1784: dbms_sql.close_cursor(l_cursor);
1785:
1786: if g_debug then
1787: hr_utility.set_location(l_proc, 110);
1788: end if;