APPS.HXC_APPROVAL_WF_PKG dependencies on DBMS_SQL

Line 1602: l_cursor := dbms_sql.open_cursor;

1598: hr_utility.trace('Period End Date (from function) is : ' ||
1599: to_char(l_period_end_date, 'DD-MM-YYYY'));
1600: end if;
1601:
1602: l_cursor := dbms_sql.open_cursor;
1603: dbms_sql.parse(l_cursor, l_call_proc, DBMS_SQL.V7);
1604: l_ret := dbms_sql.execute(l_cursor);
1605: dbms_sql.close_cursor(l_cursor);
1606:

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

1599: to_char(l_period_end_date, 'DD-MM-YYYY'));
1600: end if;
1601:
1602: l_cursor := dbms_sql.open_cursor;
1603: dbms_sql.parse(l_cursor, l_call_proc, DBMS_SQL.V7);
1604: l_ret := dbms_sql.execute(l_cursor);
1605: dbms_sql.close_cursor(l_cursor);
1606:
1607: if g_debug then

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

1600: end if;
1601:
1602: l_cursor := dbms_sql.open_cursor;
1603: dbms_sql.parse(l_cursor, l_call_proc, DBMS_SQL.V7);
1604: l_ret := dbms_sql.execute(l_cursor);
1605: dbms_sql.close_cursor(l_cursor);
1606:
1607: if g_debug then
1608: hr_utility.set_location(l_proc, 110);

Line 1605: dbms_sql.close_cursor(l_cursor);

1601:
1602: l_cursor := dbms_sql.open_cursor;
1603: dbms_sql.parse(l_cursor, l_call_proc, DBMS_SQL.V7);
1604: l_ret := dbms_sql.execute(l_cursor);
1605: dbms_sql.close_cursor(l_cursor);
1606:
1607: if g_debug then
1608: hr_utility.set_location(l_proc, 110);
1609: end if;