eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EC_UTILS dependencies on DBMS_SQL

Line 115: /* cursor_handle := dbms_sql.open_cursor;

111: ec_debug.push('EC_UTILS.EXECUTE_STRING');
112: ec_debug.pl(3,'cString',cString);
113: end if;
114:
115: /* cursor_handle := dbms_sql.open_cursor;
116:
117: BEGIN
118: dbms_sql.parse(cursor_handle,cString,dbms_sql.native);
119: EXCEPTION

Line 118: dbms_sql.parse(cursor_handle,cString,dbms_sql.native);

114:
115: /* cursor_handle := dbms_sql.open_cursor;
116:
117: BEGIN
118: dbms_sql.parse(cursor_handle,cString,dbms_sql.native);
119: EXCEPTION
120: WHEN OTHERS THEN
121: error_position := dbms_sql.last_error_position;
122: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_UTILS.EXECUTE_STRING');

Line 121: error_position := dbms_sql.last_error_position;

117: BEGIN
118: dbms_sql.parse(cursor_handle,cString,dbms_sql.native);
119: EXCEPTION
120: WHEN OTHERS THEN
121: error_position := dbms_sql.last_error_position;
122: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_UTILS.EXECUTE_STRING');
123: ece_error_handling_pvt.print_parse_error (error_position,cString);
124:
125: if dbms_sql.is_open(cursor_handle)

Line 125: if dbms_sql.is_open(cursor_handle)

121: error_position := dbms_sql.last_error_position;
122: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_UTILS.EXECUTE_STRING');
123: ece_error_handling_pvt.print_parse_error (error_position,cString);
124:
125: if dbms_sql.is_open(cursor_handle)
126: then
127: dbms_sql.close_cursor(cursor_handle);
128: end if;
129: i_ret_code :=2;

Line 127: dbms_sql.close_cursor(cursor_handle);

123: ece_error_handling_pvt.print_parse_error (error_position,cString);
124:
125: if dbms_sql.is_open(cursor_handle)
126: then
127: dbms_sql.close_cursor(cursor_handle);
128: end if;
129: i_ret_code :=2;
130: raise EC_UTILS.PROGRAM_EXIT;
131: END;

Line 133: dbms_sql.define_column(cursor_handle,1,m_value,20000);

129: i_ret_code :=2;
130: raise EC_UTILS.PROGRAM_EXIT;
131: END;
132:
133: dbms_sql.define_column(cursor_handle,1,m_value,20000);
134: ret_query := dbms_sql.execute_and_fetch(cursor_handle,m_success);
135: dbms_sql.column_value(cursor_handle,1,m_value);
136: dbms_sql.close_cursor(cursor_handle);
137: o_value := m_value;

Line 134: ret_query := dbms_sql.execute_and_fetch(cursor_handle,m_success);

130: raise EC_UTILS.PROGRAM_EXIT;
131: END;
132:
133: dbms_sql.define_column(cursor_handle,1,m_value,20000);
134: ret_query := dbms_sql.execute_and_fetch(cursor_handle,m_success);
135: dbms_sql.column_value(cursor_handle,1,m_value);
136: dbms_sql.close_cursor(cursor_handle);
137: o_value := m_value;
138: */

Line 135: dbms_sql.column_value(cursor_handle,1,m_value);

131: END;
132:
133: dbms_sql.define_column(cursor_handle,1,m_value,20000);
134: ret_query := dbms_sql.execute_and_fetch(cursor_handle,m_success);
135: dbms_sql.column_value(cursor_handle,1,m_value);
136: dbms_sql.close_cursor(cursor_handle);
137: o_value := m_value;
138: */
139:

Line 136: dbms_sql.close_cursor(cursor_handle);

132:
133: dbms_sql.define_column(cursor_handle,1,m_value,20000);
134: ret_query := dbms_sql.execute_and_fetch(cursor_handle,m_success);
135: dbms_sql.column_value(cursor_handle,1,m_value);
136: dbms_sql.close_cursor(cursor_handle);
137: o_value := m_value;
138: */
139:
140: /*Bug 1853627- Replaced the above dbms_sql with execute immediate statement */

Line 140: /Bug 1853627- Replaced the above dbms_sql with execute immediate statement /

136: dbms_sql.close_cursor(cursor_handle);
137: o_value := m_value;
138: */
139:
140: /*Bug 1853627- Replaced the above dbms_sql with execute immediate statement */
141:
142: EXECUTE IMMEDIATE cString
143: INTO o_value;
144: if EC_DEBUG.G_debug_level >= 2 then

Line 152: /* if DBMS_SQL.IS_OPEN(cursor_handle) then

148: exception
149: WHEN EC_UTILS.PROGRAM_EXIT then
150: raise;
151: WHEN OTHERS then
152: /* if DBMS_SQL.IS_OPEN(cursor_handle) then
153: dbms_sql.close_cursor(cursor_handle);
154: end if;
155: */
156: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_UTILS.EXECUTE_STRING');

Line 153: dbms_sql.close_cursor(cursor_handle);

149: WHEN EC_UTILS.PROGRAM_EXIT then
150: raise;
151: WHEN OTHERS then
152: /* if DBMS_SQL.IS_OPEN(cursor_handle) then
153: dbms_sql.close_cursor(cursor_handle);
154: end if;
155: */
156: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_UTILS.EXECUTE_STRING');
157: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 2590: dbms_sql.bind_variable

2586:
2587: if g_stack(o_stack_pos).data_type = 'NUMBER'
2588: then
2589: i_number := to_number(g_stack(o_stack_pos).variable_value);
2590: dbms_sql.bind_variable
2591: (
2592: g_int_levels(g_current_level).Cursor_Handle,
2593: i_variable_name,
2594: i_number

Line 2606: dbms_sql.bind_variable

2602: Bug 5763541
2603: i_date := to_date(g_stack(o_stack_pos).variable_value,'DD-MM-RR'); */
2604:
2605: i_date := FND_CONC_DATE.string_to_date(g_stack(o_stack_pos).variable_value);
2606: dbms_sql.bind_variable
2607: (
2608: g_int_levels(g_current_level).Cursor_Handle,
2609: i_variable_name,
2610: i_date

Line 2616: dbms_sql.bind_variable

2612: if EC_DEBUG.G_debug_level >= 3 then
2613: ec_debug.pl(3,'Binding Value ',i_date);
2614: end if;
2615: else
2616: dbms_sql.bind_variable
2617: (
2618: g_int_levels(g_current_level).Cursor_Handle,
2619: i_variable_name,
2620: g_stack(o_stack_pos).variable_value

Line 2628: dbms_sql.bind_variable

2624: end if;
2625: end if;
2626: end if;
2627: else
2628: dbms_sql.bind_variable
2629: (
2630: g_int_levels(g_current_level).Cursor_Handle,
2631: i_variable_name,
2632: g_file_tbl(o_plsql_pos).value