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_EXECUTION_UTILS dependencies on DBMS_SQL

Line 241: ec_utils.g_procedure_stack(j).cursor_handle := dbms_sql.open_cursor;

237:
238: -- Load the Procedure Stack
239: j := ec_utils.g_procedure_stack.COUNT + 1;
240: ec_utils.g_procedure_stack(j).procedure_name := i_procedure_name;
241: ec_utils.g_procedure_stack(j).cursor_handle := dbms_sql.open_cursor;
242: ec_utils.g_procedure_stack(j).execution_clause := v_proc_string;
243:
244: if EC_DEBUG.G_debug_level >= 3 then
245: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(j).procedure_name);

Line 252: dbms_sql.parse(ec_utils.g_procedure_stack(j).cursor_handle,v_proc_string,dbms_sql.native);

248: end if;
249:
250: --Parse the Procedure String
251: BEGIN
252: dbms_sql.parse(ec_utils.g_procedure_stack(j).cursor_handle,v_proc_string,dbms_sql.native);
253: EXCEPTION
254: WHEN OTHERS THEN
255: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
256: error_position := dbms_sql.last_error_position;

Line 256: error_position := dbms_sql.last_error_position;

252: dbms_sql.parse(ec_utils.g_procedure_stack(j).cursor_handle,v_proc_string,dbms_sql.native);
253: EXCEPTION
254: WHEN OTHERS THEN
255: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
256: error_position := dbms_sql.last_error_position;
257: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');
258: ece_error_handling_pvt.print_parse_error (error_position,v_proc_string);
259: ec_utils.i_ret_code :=2;
260: raise EC_UTILS.PROGRAM_EXIT;

Line 292: -- DBMS_SQL variables

288: i_procedure_name IN varchar2
289: )
290: is
291:
292: -- DBMS_SQL variables
293: v_cursor pls_integer;
294: v_numrows pls_integer;
295:
296: v_proccall varchar2(500);

Line 340: dbms_sql.bind_variable

336: -- 2 Number
337: IF ec_utils.g_parameter_stack(j).data_type = 2
338: then
339: i_number := to_number(ec_utils.g_parameter_stack(j).value);
340: dbms_sql.bind_variable
341: (
342: ec_utils.g_procedure_stack(i).cursor_handle,
343: ':'||ec_utils.g_parameter_stack(j).parameter_name,
344: i_number

Line 352: dbms_sql.bind_variable

348: end if;
349: -- 1 VARCHAR2
350: elsif ec_utils.g_parameter_stack(j).data_type = 1
351: then
352: dbms_sql.bind_variable
353: (
354: ec_utils.g_procedure_stack(i).cursor_handle,
355: ':'||ec_utils.g_parameter_stack(j).parameter_name,
356: ec_utils.g_parameter_stack(j).value,

Line 366: dbms_sql.bind_variable

362: -- 12 DATE
363: elsif ec_utils.g_parameter_stack(j).data_type = 12
364: then
365: i_date := to_date(ec_utils.g_parameter_stack(j).value,'YYYYMMDD HH24MISS');
366: dbms_sql.bind_variable
367: (
368: ec_utils.g_procedure_stack(i).cursor_handle,
369: ':'||ec_utils.g_parameter_stack(j).parameter_name,
370: i_date

Line 378: dbms_sql.bind_variable

374: end if;
375: -- 96 CHAR
376: elsif ec_utils.g_parameter_stack(j).data_type = 96
377: then
378: dbms_sql.bind_variable
379: (
380: ec_utils.g_procedure_stack(i).cursor_handle,
381: ':'||ec_utils.g_parameter_stack(j).parameter_name,
382: ec_utils.g_parameter_stack(j).value,

Line 407: v_numrows := DBMS_SQL.execute(ec_utils.g_procedure_stack(i).cursor_handle);

403: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(i).procedure_name);
404: ec_debug.pl(3,'Cursor Handle ',ec_utils.g_procedure_stack(i).cursor_handle);
405: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(i).execution_clause);
406: end if;
407: v_numrows := DBMS_SQL.execute(ec_utils.g_procedure_stack(i).cursor_handle);
408: if EC_DEBUG.G_debug_level >= 3 then
409: ec_debug.pl(3,'Execution Successful','Yes');
410: end if;
411: -- Call Variable value for any OUT or IN/OUT parameters

Line 420: dbms_sql.variable_value

416: if ec_utils.g_parameter_stack(j).in_out = 1 or ec_utils.g_parameter_stack(j).in_out = 2
417: then
418: if ec_utils.g_parameter_stack(j).data_type= 2
419: then
420: dbms_sql.variable_value
421: (
422: ec_utils.g_procedure_stack(i).cursor_handle,
423: ':'||ec_utils.g_parameter_stack(j).parameter_name,
424: j_number

Line 432: dbms_sql.variable_value

428: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
429: end if;
430: elsif ec_utils.g_parameter_stack(j).data_type= 1
431: then
432: dbms_sql.variable_value
433: (
434: ec_utils.g_procedure_stack(i).cursor_handle,
435: ':'||ec_utils.g_parameter_stack(j).parameter_name,
436: ec_utils.g_parameter_stack(j).value

Line 443: dbms_sql.variable_value

439: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
440: end if;
441: elsif ec_utils.g_parameter_stack(j).data_type= 12
442: then
443: dbms_sql.variable_value
444: (
445: ec_utils.g_procedure_stack(i).cursor_handle,
446: ':'||ec_utils.g_parameter_stack(j).parameter_name,
447: j_date

Line 456: dbms_sql.variable_value

452: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
453: end if;
454: elsif ec_utils.g_parameter_stack(j).data_type= 96
455: then
456: dbms_sql.variable_value
457: (
458: ec_utils.g_procedure_stack(i).cursor_handle,
459: ':'||ec_utils.g_parameter_stack(j).parameter_name,
460: ec_utils.g_parameter_stack(j).value