DBA Data[Home] [Help]

APPS.AML_PURGE_IMPORT_INTERFACE dependencies on DBMS_SESSION

Line 151: dbms_session.set_sql_trace(TRUE);

147: l_start_date := to_date(p_start_date,'YYYY/MM/DD HH24:MI:SS');
148: l_end_date := to_date(p_end_date, 'YYYY/MM/DD HH24:MI:SS');
149:
150: IF p_trace_mode = 'Y' THEN
151: dbms_session.set_sql_trace(TRUE);
152: ELSE
153: dbms_session.set_sql_trace(FALSE);
154: END IF;
155: G_DEBUG_MODE := P_DEBUG_MODE;

Line 153: dbms_session.set_sql_trace(FALSE);

149:
150: IF p_trace_mode = 'Y' THEN
151: dbms_session.set_sql_trace(TRUE);
152: ELSE
153: dbms_session.set_sql_trace(FALSE);
154: END IF;
155: G_DEBUG_MODE := P_DEBUG_MODE;
156:
157: write_log(2,'Purging import interface starts');