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.ECX_ACTIONS dependencies on DBMS_SQL

Line 327: p_insert_cursor := dbms_sql.open_cursor;

323: cInsert_stmt := cInsert_stmt || cValue_stmt;
324: if(l_statementEnabled) then
325: ecx_debug.log(l_statement,'Insert_statement ', cInsert_stmt,i_method_name);
326: end if;
327: p_insert_cursor := dbms_sql.open_cursor;
328: if(l_statementEnabled) then
329: ecx_debug.log(l_statement,'p_insert_cursor', p_insert_cursor,i_method_name);
330: end if;
331:

Line 333: dbms_sql.parse (p_insert_cursor, cInsert_stmt, dbms_sql.native);

329: ecx_debug.log(l_statement,'p_insert_cursor', p_insert_cursor,i_method_name);
330: end if;
331:
332: begin
333: dbms_sql.parse (p_insert_cursor, cInsert_stmt, dbms_sql.native);
334: exception
335: when others then
336: l_error_position := dbms_sql.last_error_position;
337: raise l_parse_error;

Line 336: l_error_position := dbms_sql.last_error_position;

332: begin
333: dbms_sql.parse (p_insert_cursor, cInsert_stmt, dbms_sql.native);
334: exception
335: when others then
336: l_error_position := dbms_sql.last_error_position;
337: raise l_parse_error;
338: end;
339:
340: if (l_procedureEnabled) then

Line 428: dbms_sql.bind_variable (l_insert_cursor, 'f' || k, l_date);

424: end if;
425: if(l_statementEnabled) then
426: ecx_debug.log(l_statement,ecx_utils.g_target(k).base_column_name, l_date,i_method_name);
427: end if;
428: dbms_sql.bind_variable (l_insert_cursor, 'f' || k, l_date);
429:
430: elsif ecx_utils.g_target(k).data_type = 2 then
431: if ecx_utils.g_target(k).value is null then
432: l_number := null;

Line 439: dbms_sql.bind_variable (l_insert_cursor, 'f' || k, l_number);

435: end if;
436: if(l_statementEnabled) then
437: ecx_debug.log(l_statement,ecx_utils.g_target(k).base_column_name, l_number,i_method_name);
438: end if;
439: dbms_sql.bind_variable (l_insert_cursor, 'f' || k, l_number);
440:
441: -- Target is a CLOB datatype
442: elsif ecx_utils.g_target(k).data_type = 112 then
443:

Line 448: dbms_sql.bind_variable (l_insert_cursor, 'f' || k,l_clob_value );

444: get_clob (ecx_utils.g_target(k).clob_value ,
445: ecx_utils.g_target(k).value,
446: l_clob_value);
447:
448: dbms_sql.bind_variable (l_insert_cursor, 'f' || k,l_clob_value );
449:
450: if ecx_utils.g_target(k).clob_value is not null Then
451: if(l_statementEnabled) then
452: ecx_debug.log(l_statement,ecx_utils.g_target(k).base_column_name,

Line 469: dbms_sql.bind_variable (l_insert_cursor, 'f' || k,l_value);

465: get_varchar(ecx_utils.g_target(k).clob_value ,
466: ecx_utils.g_target(k).value,
467: l_value);
468:
469: dbms_sql.bind_variable (l_insert_cursor, 'f' || k,l_value);
470:
471:
472: if ecx_utils.g_target(k).clob_value is not null Then
473: if(l_statementEnabled) then

Line 504: l_dummy := dbms_sql.execute(l_insert_cursor);

500: end if;
501:
502: end loop;
503:
504: l_dummy := dbms_sql.execute(l_insert_cursor);
505: if (l_dummy <> 1) then
506: raise l_insert_failed;
507: end if;
508:

Line 590: cursor_handle := dbms_sql.open_cursor;

586: if(l_statementEnabled) then
587: ecx_debug.log(l_statement,'cString',cString,i_method_name);
588: end if;
589:
590: cursor_handle := dbms_sql.open_cursor;
591:
592: BEGIN
593: dbms_sql.parse(cursor_handle,cString,dbms_sql.native);
594:

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

589:
590: cursor_handle := dbms_sql.open_cursor;
591:
592: BEGIN
593: dbms_sql.parse(cursor_handle,cString,dbms_sql.native);
594:
595: EXCEPTION
596: WHEN OTHERS THEN
597: raise parse_error;

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

596: WHEN OTHERS THEN
597: raise parse_error;
598: END;
599:
600: dbms_sql.define_column(cursor_handle,1,m_value,20000);
601: ret_query := dbms_sql.execute_and_fetch(cursor_handle,m_success);
602: dbms_sql.column_value(cursor_handle,1,m_value);
603: dbms_sql.close_cursor(cursor_handle);
604: o_value := m_value;

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

597: raise parse_error;
598: END;
599:
600: dbms_sql.define_column(cursor_handle,1,m_value,20000);
601: ret_query := dbms_sql.execute_and_fetch(cursor_handle,m_success);
602: dbms_sql.column_value(cursor_handle,1,m_value);
603: dbms_sql.close_cursor(cursor_handle);
604: o_value := m_value;
605:

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

598: END;
599:
600: dbms_sql.define_column(cursor_handle,1,m_value,20000);
601: ret_query := dbms_sql.execute_and_fetch(cursor_handle,m_success);
602: dbms_sql.column_value(cursor_handle,1,m_value);
603: dbms_sql.close_cursor(cursor_handle);
604: o_value := m_value;
605:
606: if(l_statementEnabled) then

Line 603: dbms_sql.close_cursor(cursor_handle);

599:
600: dbms_sql.define_column(cursor_handle,1,m_value,20000);
601: ret_query := dbms_sql.execute_and_fetch(cursor_handle,m_success);
602: dbms_sql.column_value(cursor_handle,1,m_value);
603: dbms_sql.close_cursor(cursor_handle);
604: o_value := m_value;
605:
606: if(l_statementEnabled) then
607: ecx_debug.log(l_statement,'o_value',o_value,i_method_name);

Line 616: error_position := dbms_sql.last_error_position;

612:
613:
614: EXCEPTION
615: WHEN PARSE_ERROR then
616: error_position := dbms_sql.last_error_position;
617: ecx_error_handling_pvt.print_parse_error (error_position,cString);
618: if(l_unexpectedEnabled) then
619: ecx_debug.log(l_unexpected, 'ECX', 'ECX_PROGRAM_ERROR', i_method_name, 'PROGRESS_LEVEL', 'ECX_ACTIONS.EXECUTE_STRING');
620: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', i_method_name, 'ERROR_MESSAGE', SQLERRM);

Line 622: if dbms_sql.is_open(cursor_handle) then

618: if(l_unexpectedEnabled) then
619: ecx_debug.log(l_unexpected, 'ECX', 'ECX_PROGRAM_ERROR', i_method_name, 'PROGRESS_LEVEL', 'ECX_ACTIONS.EXECUTE_STRING');
620: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', i_method_name, 'ERROR_MESSAGE', SQLERRM);
621: end if;
622: if dbms_sql.is_open(cursor_handle) then
623: dbms_sql.close_cursor(cursor_handle);
624: end if;
625: ecx_debug.seTErrorInfo(2,30,SQLERRM||' - ECX_UTILS.EXECUTE_STRING');
626: raise ecx_utils.PROGRAM_EXIT;

Line 623: dbms_sql.close_cursor(cursor_handle);

619: ecx_debug.log(l_unexpected, 'ECX', 'ECX_PROGRAM_ERROR', i_method_name, 'PROGRESS_LEVEL', 'ECX_ACTIONS.EXECUTE_STRING');
620: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', i_method_name, 'ERROR_MESSAGE', SQLERRM);
621: end if;
622: if dbms_sql.is_open(cursor_handle) then
623: dbms_sql.close_cursor(cursor_handle);
624: end if;
625: ecx_debug.seTErrorInfo(2,30,SQLERRM||' - ECX_UTILS.EXECUTE_STRING');
626: raise ecx_utils.PROGRAM_EXIT;
627:

Line 635: if DBMS_SQL.IS_OPEN(cursor_handle) then

631: end if;
632: raise;
633:
634: WHEN OTHERS then
635: if DBMS_SQL.IS_OPEN(cursor_handle) then
636: dbms_sql.close_cursor(cursor_handle);
637: end if;
638: if(l_unexpectedEnabled) then
639: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name,'PROGRESS_LEVEL',

Line 636: dbms_sql.close_cursor(cursor_handle);

632: raise;
633:
634: WHEN OTHERS then
635: if DBMS_SQL.IS_OPEN(cursor_handle) then
636: dbms_sql.close_cursor(cursor_handle);
637: end if;
638: if(l_unexpectedEnabled) then
639: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name,'PROGRESS_LEVEL',
640: 'ECX_ACTIONS.EXECUTE_STRING');

Line 1422: dbms_sql.bind_variable (

1418:
1419:
1420: if l_data_type = 2 then
1421: i_number := to_number(pre_var_value);
1422: dbms_sql.bind_variable (
1423: ecx_utils.g_source_levels(i_level).Cursor_Handle,
1424: i_variable_name, i_number);
1425: if(l_statementEnabled) then
1426: ecx_debug.log(l_statement, 'Binding Value ',i_number,i_method_name);

Line 1431: dbms_sql.bind_variable (

1427: end if;
1428:
1429: elsif l_data_type = 12 then
1430: i_date := to_date(pre_var_value,'YYYYMMDD HH24MISS');
1431: dbms_sql.bind_variable (
1432: ecx_utils.g_source_levels(i_level).Cursor_Handle,
1433: i_variable_name, i_date);
1434: if(l_statementEnabled) then
1435: ecx_debug.log(l_statement,'Binding Value ',i_date,i_method_name);

Line 1438: dbms_sql.bind_variable (

1434: if(l_statementEnabled) then
1435: ecx_debug.log(l_statement,'Binding Value ',i_date,i_method_name);
1436: end if;
1437: else
1438: dbms_sql.bind_variable (
1439: ecx_utils.g_source_levels(i_level).Cursor_Handle,
1440: i_variable_name, pre_var_value);
1441: if(l_statementEnabled) then
1442: ecx_debug.log(l_statement,'Binding Value ',pre_var_value,i_method_name);

Line 1528: x_proc_cursor := dbms_sql.open_cursor;

1524:
1525: if(l_statementEnabled) then
1526: ecx_debug.log(l_statement,'proc_call', l_proc_call, i_method_name);
1527: end if;
1528: x_proc_cursor := dbms_sql.open_cursor;
1529:
1530: BEGIN
1531: dbms_sql.parse (x_proc_cursor, l_proc_call, dbms_sql.native);
1532:

Line 1531: dbms_sql.parse (x_proc_cursor, l_proc_call, dbms_sql.native);

1527: end if;
1528: x_proc_cursor := dbms_sql.open_cursor;
1529:
1530: BEGIN
1531: dbms_sql.parse (x_proc_cursor, l_proc_call, dbms_sql.native);
1532:
1533: EXCEPTION
1534: when others then
1535: raise parse_error;

Line 1544: error_position := dbms_sql.last_error_position;

1540: end if;
1541:
1542: EXCEPTION
1543: WHEN PARSE_ERROR then
1544: error_position := dbms_sql.last_error_position;
1545: if(l_unexpectedEnabled) then
1546: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
1547: 'PROGRESS_LEVEL','ECX_ACTIONS.BUILD_PROCEDURE_CALL');
1548: end if;

Line 1699: dbms_sql.bind_variable(p_proc_cursor,

1695: i_method_name);
1696: end if;
1697:
1698: if (ecx_utils.g_procedure_mappings(i).data_type = 1) then
1699: dbms_sql.bind_variable(p_proc_cursor,
1700: ':' ||ecx_utils.g_procedure_mappings(i).parameter_name,
1701: l_var_value,ecx_utils.G_VARCHAR_LEN);
1702:
1703: elsif (ecx_utils.g_procedure_mappings(i).data_type = 2) then

Line 1704: dbms_sql.bind_variable(p_proc_cursor,

1700: ':' ||ecx_utils.g_procedure_mappings(i).parameter_name,
1701: l_var_value,ecx_utils.G_VARCHAR_LEN);
1702:
1703: elsif (ecx_utils.g_procedure_mappings(i).data_type = 2) then
1704: dbms_sql.bind_variable(p_proc_cursor,
1705: ':' ||ecx_utils.g_procedure_mappings(i).parameter_name,
1706: to_number(l_var_value));
1707: if(l_statementEnabled) then
1708: ecx_debug.log(l_statement,'after binding',i_method_name);

Line 1711: dbms_sql.bind_variable(p_proc_cursor,

1707: if(l_statementEnabled) then
1708: ecx_debug.log(l_statement,'after binding',i_method_name);
1709: end if;
1710: elsif (ecx_utils.g_procedure_mappings(i).data_type = 12) then
1711: dbms_sql.bind_variable(p_proc_cursor,
1712: ':' || ecx_utils.g_procedure_mappings(i).parameter_name,
1713: to_date(l_var_value, 'YYYYMMDD HH24MISS'));
1714:
1715: elsif (ecx_utils.g_procedure_mappings(i).data_type = 96) then

Line 1716: dbms_sql.bind_variable(p_proc_cursor,

1712: ':' || ecx_utils.g_procedure_mappings(i).parameter_name,
1713: to_date(l_var_value, 'YYYYMMDD HH24MISS'));
1714:
1715: elsif (ecx_utils.g_procedure_mappings(i).data_type = 96) then
1716: dbms_sql.bind_variable(p_proc_cursor,
1717: ':' ||ecx_utils.g_procedure_mappings(i).parameter_name, l_var_value, 600);
1718:
1719: /** Change required for Clob Support -- 2263729 ***/
1720: elsif (ecx_utils.g_procedure_mappings(i).data_type = 112) then

Line 1725: dbms_sql.bind_variable(p_proc_cursor,

1721: if l_clob_value is not null Then
1722: if(l_statementEnabled) then
1723: ecx_debug.log(l_statement,'Binding clob is not null',i_method_name);
1724: end if;
1725: dbms_sql.bind_variable(p_proc_cursor,
1726: ':' ||ecx_utils.g_procedure_mappings(i).parameter_name, l_clob_value);
1727:
1728: elsif l_var_value is not null Then
1729: if(l_statementEnabled) then

Line 1734: dbms_sql.bind_variable(p_proc_cursor,

1730: ecx_debug.log(l_statement,'Binding varchar is not null',i_method_name);
1731: end if;
1732: /** bind the varchar2 variable to clob. ***/
1733: get_clob(l_clob_value,l_var_value,l_temp_loc);
1734: dbms_sql.bind_variable(p_proc_cursor,
1735: ':' ||ecx_utils.g_procedure_mappings(i).parameter_name,l_temp_loc);
1736:
1737: else
1738: if(l_statementEnabled) then

Line 1743: dbms_sql.bind_variable(p_proc_cursor,

1739: ecx_debug.log(l_statement,'Binding clob is null',i_method_name);
1740: end if;
1741:
1742: /** just bind the null clob so that bind will not fail***/
1743: dbms_sql.bind_variable(p_proc_cursor,
1744: ':' ||ecx_utils.g_procedure_mappings(i).parameter_name,l_clob_value);
1745: end if;
1746: else
1747: if(l_statementEnabled) then

Line 1769: l_numrows := dbms_sql.execute (p_proc_cursor);

1765: end if;
1766: if(l_statementEnabled) then
1767: ecx_debug.log(l_statement,'before execute procedure',i_method_name);
1768: end if;
1769: l_numrows := dbms_sql.execute (p_proc_cursor);
1770: if(l_statementEnabled) then
1771: ecx_debug.log(l_statement,'after execute procedure',i_method_name);
1772: end if;
1773: if dbms_lob.istemporary(l_temp_loc) = 1 Then

Line 1862: dbms_sql.variable_value (p_proc_cursor,

1858: end if;
1859:
1860:
1861: if (ecx_utils.g_procedure_mappings(i).data_type = 1) then
1862: dbms_sql.variable_value (p_proc_cursor,
1863: ':' ||ecx_utils.g_procedure_mappings(i).parameter_name,
1864: l_varchar_value);
1865: frag_found := FALSE;
1866: -- XML Fragment change

Line 1903: dbms_sql.variable_value (p_proc_cursor,

1899: ecx_utils.g_procedure_mappings(i).variable_direction,l_varchar_value);
1900: end if;
1901:
1902: elsif (ecx_utils.g_procedure_mappings(i).data_type = 2) then
1903: dbms_sql.variable_value (p_proc_cursor,
1904: ':' ||ecx_utils.g_procedure_mappings(i).parameter_name,
1905: l_num);
1906: frag_found := FALSE;
1907: if (instr(p_procedure_name,ECX_UTILS.G_XML_FRAG_PROC) > 0 and l_var_pos is

Line 1940: dbms_sql.variable_value (p_proc_cursor,

1936: to_char(l_num));
1937: end if;
1938:
1939: elsif (ecx_utils.g_procedure_mappings(i).data_type = 12) then
1940: dbms_sql.variable_value (p_proc_cursor,
1941: ':' ||ecx_utils.g_procedure_mappings(i).parameter_name,
1942: l_date);
1943: frag_found := FALSE;
1944: if (instr(p_procedure_name,ECX_UTILS.G_XML_FRAG_PROC) > 0 and l_var_pos is

Line 1977: dbms_sql.variable_value (p_proc_cursor,

1973: end if;
1974:
1975:
1976: elsif (ecx_utils.g_procedure_mappings(i).data_type = 96) then
1977: dbms_sql.variable_value (p_proc_cursor,
1978: ':' ||ecx_utils.g_procedure_mappings(i).parameter_name,
1979: l_varchar_value);
1980: frag_found := FALSE;
1981: if (instr(p_procedure_name,ECX_UTILS.G_XML_FRAG_PROC) > 0 and l_var_pos is

Line 2014: dbms_sql.variable_value (p_proc_cursor,

2010: l_varchar_value );
2011: end if;
2012: /** Change required for Clob Support -- 2263729 ***/
2013: elsif (ecx_utils.g_procedure_mappings(i).data_type = 112) then
2014: dbms_sql.variable_value (p_proc_cursor,
2015: ':' ||ecx_utils.g_procedure_mappings(i).parameter_name,
2016: l_clob_value);
2017:
2018: assign_value (l_stack_var, l_stack_pos, l_var_pos,