APPS.ICX_ON_UTILITIES dependencies on DBMS_SESSION

Line 1080: -- dbms_session.set_sql_trace(TRUE);

1076: end if;
1077:
1078: -- select HSECS into l_timer from v$timer;htp.p('start exec_query LOV @ '||l_timer);htp.nl;
1079:
1080: -- dbms_session.set_sql_trace(TRUE);
1081:
1082: unpack_whereSegment(p_where,l_where_clause,l_query_binds);
1083:
1084: /* DEBUG TRACE

Line 1123: -- dbms_session.set_sql_trace(FALSE);

1119: end if;
1120:
1121: -- icx_on_utilities2.printPLSQLtables;
1122:
1123: -- dbms_session.set_sql_trace(FALSE);
1124:
1125: -- select HSECS into l_timer from v$timer;htp.p('end exec_query LOV @ '||l_timer);htp.nl;
1126:
1127: c_table_count := 2;

Line 1155: -- dbms_session.set_sql_trace(TRUE);

1151: */
1152:
1153: -- select HSECS into l_timer from v$timer;htp.p('start exec_query PK @ '||l_timer);htp.nl;
1154:
1155: -- dbms_session.set_sql_trace(TRUE);
1156:
1157: ak_query_pkg.exec_query(
1158: P_FLOW_APPL_ID => l_flow_appl_id,
1159: P_FLOW_CODE => l_flow_code,

Line 1185: -- dbms_session.set_sql_trace(FALSE);

1181: P_RETURN_NODE_DISPLAY_ONLY => 'T');
1182:
1183: -- icx_on_utilities2.printPLSQLtables;
1184:
1185: -- dbms_session.set_sql_trace(FALSE);
1186:
1187: -- select HSECS into l_timer from v$timer;htp.p('start exec_query PK @ '||l_timer);htp.nl;
1188:
1189: c_table_count := 2;

Line 2106: dbms_session.set_nls('NLS_DATE_FORMAT', c_date_format);

2102: IF (nvl(icx_sec.g_date_format,'X') <> nvl(icx_sec.g_date_format_c,'Y')) or
2103: (nvl(icx_sec.g_date_format_c,'Y') <> l_dummy_db_date) THEN
2104:
2105: c_date_format := ''''||icx_sec.g_date_format||'''';
2106: dbms_session.set_nls('NLS_DATE_FORMAT', c_date_format);
2107: icx_sec.g_date_format_c := icx_sec.g_date_format;
2108:
2109: END IF;
2110: