APPS.PER_EMPDIR_SS dependencies on DBMS_SQL

Line 68: ddl_curs := dbms_sql.open_cursor;

64:
65: ddl_curs integer;
66: v_Dummy integer;
67: BEGIN
68: ddl_curs := dbms_sql.open_cursor;
69: IF (p_enable) then
70: dbms_sql.parse(ddl_curs,'ALTER SESSION SET sql_trace = TRUE',dbms_sql.native);
71: ELSE
72: dbms_sql.parse(ddl_curs,'ALTER SESSION SET sql_trace = FALSE',dbms_sql.native);

Line 70: dbms_sql.parse(ddl_curs,'ALTER SESSION SET sql_trace = TRUE',dbms_sql.native);

66: v_Dummy integer;
67: BEGIN
68: ddl_curs := dbms_sql.open_cursor;
69: IF (p_enable) then
70: dbms_sql.parse(ddl_curs,'ALTER SESSION SET sql_trace = TRUE',dbms_sql.native);
71: ELSE
72: dbms_sql.parse(ddl_curs,'ALTER SESSION SET sql_trace = FALSE',dbms_sql.native);
73: END IF;
74: v_Dummy := DBMS_SQL.EXECUTE(ddl_curs);

Line 72: dbms_sql.parse(ddl_curs,'ALTER SESSION SET sql_trace = FALSE',dbms_sql.native);

68: ddl_curs := dbms_sql.open_cursor;
69: IF (p_enable) then
70: dbms_sql.parse(ddl_curs,'ALTER SESSION SET sql_trace = TRUE',dbms_sql.native);
71: ELSE
72: dbms_sql.parse(ddl_curs,'ALTER SESSION SET sql_trace = FALSE',dbms_sql.native);
73: END IF;
74: v_Dummy := DBMS_SQL.EXECUTE(ddl_curs);
75: dbms_sql.close_cursor(ddl_curs);
76: EXCEPTION WHEN OTHERS THEN

Line 74: v_Dummy := DBMS_SQL.EXECUTE(ddl_curs);

70: dbms_sql.parse(ddl_curs,'ALTER SESSION SET sql_trace = TRUE',dbms_sql.native);
71: ELSE
72: dbms_sql.parse(ddl_curs,'ALTER SESSION SET sql_trace = FALSE',dbms_sql.native);
73: END IF;
74: v_Dummy := DBMS_SQL.EXECUTE(ddl_curs);
75: dbms_sql.close_cursor(ddl_curs);
76: EXCEPTION WHEN OTHERS THEN
77: NULL;
78: END trace;

Line 75: dbms_sql.close_cursor(ddl_curs);

71: ELSE
72: dbms_sql.parse(ddl_curs,'ALTER SESSION SET sql_trace = FALSE',dbms_sql.native);
73: END IF;
74: v_Dummy := DBMS_SQL.EXECUTE(ddl_curs);
75: dbms_sql.close_cursor(ddl_curs);
76: EXCEPTION WHEN OTHERS THEN
77: NULL;
78: END trace;
79: