APPS.HR_GENERAL_UTILITIES dependencies on DBMS_SQL

Line 34: -- force to use Execute_Dynamic_SQL procedure which uses dbms_sql package.

30: -- The following global constant is for testing the old BPFD and the new BPFD (
31: -- which has an output parameter). This constant will indicate that beyond
32: -- certain number of parameters, the old BPFD which will create dynamic SQL with
33: -- literal will be used. For example, set g_num_dynamic_sql_parms to -1 will
34: -- force to use Execute_Dynamic_SQL procedure which uses dbms_sql package.
35: -------------------------------------------------------------------------------
36: g_num_dynamic_sql_parms constant number := 15;
37: --
38: -- ----------------------------------------------------------------------------

Line 2275: -- use dbms_sql package by calling Execute_Dynamic_SQL procedure.

2271: ,l_bind_values_tab(15);
2272: ELSE
2273: -- either the parameters are greater than 15 or the num of parameters
2274: -- are greater than the global constant g_num_dynamic_sql_parms, then
2275: -- use dbms_sql package by calling Execute_Dynamic_SQL procedure.
2276: -- From old code which uses literal SQL statement
2277:
2278: IF g_debug THEN
2279: hr_utility.set_location('Leaving : ' || l_proc, 10);

Line 2528: l_cursor_handle := dbms_sql.open_cursor;

2524: IF g_debug THEN
2525: hr_utility.set_location('Entering : ' || l_proc, 5);
2526: END IF;
2527:
2528: l_cursor_handle := dbms_sql.open_cursor;
2529: dbms_sql.parse
2530: ( l_cursor_handle
2531: , p_sql_string
2532: , dbms_sql.v7

Line 2529: dbms_sql.parse

2525: hr_utility.set_location('Entering : ' || l_proc, 5);
2526: END IF;
2527:
2528: l_cursor_handle := dbms_sql.open_cursor;
2529: dbms_sql.parse
2530: ( l_cursor_handle
2531: , p_sql_string
2532: , dbms_sql.v7
2533: );

Line 2532: , dbms_sql.v7

2528: l_cursor_handle := dbms_sql.open_cursor;
2529: dbms_sql.parse
2530: ( l_cursor_handle
2531: , p_sql_string
2532: , dbms_sql.v7
2533: );
2534: l_exec := dbms_sql.execute (l_cursor_handle);
2535: dbms_sql.close_cursor(l_cursor_handle);
2536:

Line 2534: l_exec := dbms_sql.execute (l_cursor_handle);

2530: ( l_cursor_handle
2531: , p_sql_string
2532: , dbms_sql.v7
2533: );
2534: l_exec := dbms_sql.execute (l_cursor_handle);
2535: dbms_sql.close_cursor(l_cursor_handle);
2536:
2537: IF g_debug THEN
2538: hr_utility.set_location('Leaving : ' || l_proc, 10);

Line 2535: dbms_sql.close_cursor(l_cursor_handle);

2531: , p_sql_string
2532: , dbms_sql.v7
2533: );
2534: l_exec := dbms_sql.execute (l_cursor_handle);
2535: dbms_sql.close_cursor(l_cursor_handle);
2536:
2537: IF g_debug THEN
2538: hr_utility.set_location('Leaving : ' || l_proc, 10);
2539: END IF;