DBA Data[Home] [Help]

APPS.ECX_OUTBOUND dependencies on DBMS_SQL

Line 695: i_rows_processed := dbms_sql.execute (ecx_utils.g_source_levels(i).Cursor_Handle);

691: ecx_utils.g_current_level := i;
692:
693: /* Bind the Variables for the Where Clause */
694: ecx_actions.bind_variables_for_view(10,i);
695: i_rows_processed := dbms_sql.execute (ecx_utils.g_source_levels(i).Cursor_Handle);
696: if(l_statementEnabled) then
697: ecx_debug.log(l_statement,'Cursor Handle',ecx_utils.g_source_levels(i).Cursor_handle,
698: i_method_name);
699: end if;

Line 702: while (dbms_sql.fetch_rows( ecx_utils.g_source_levels(i).Cursor_handle) > 0)

698: i_method_name);
699: end if;
700:
701:
702: while (dbms_sql.fetch_rows( ecx_utils.g_source_levels(i).Cursor_handle) > 0)
703: LOOP
704: push(i);
705:
706: if(l_statementEnabled) then

Line 720: dbms_sql.column_value

716: then
717: i_column_counter := i_column_counter + 1;
718:
719: if ecx_utils.g_source(j).data_type <> 112 Then
720: dbms_sql.column_value
721: (
722: ecx_utils.g_source_levels(i).Cursor_handle,
723: i_column_counter,
724: ecx_utils.g_source(j).value

Line 727: dbms_sql.column_value

723: i_column_counter,
724: ecx_utils.g_source(j).value
725: );
726: else
727: dbms_sql.column_value
728: (
729: ecx_utils.g_source_levels(i).Cursor_handle,
730: i_column_counter,
731: ecx_utils.g_source(j).clob_value

Line 821: ecx_utils.g_source_levels(i).rows_processed := dbms_sql.last_row_count;

817:
818: END LOOP;
819: if i = 1
820: then
821: ecx_utils.g_source_levels(i).rows_processed := dbms_sql.last_row_count;
822: else
823: ecx_utils.g_source_levels(i).rows_processed :=
824: ecx_utils.g_source_levels(i).rows_processed + dbms_sql.last_row_count;
825: end if;

Line 824: ecx_utils.g_source_levels(i).rows_processed + dbms_sql.last_row_count;

820: then
821: ecx_utils.g_source_levels(i).rows_processed := dbms_sql.last_row_count;
822: else
823: ecx_utils.g_source_levels(i).rows_processed :=
824: ecx_utils.g_source_levels(i).rows_processed + dbms_sql.last_row_count;
825: end if;
826: END IF;
827: end loop;
828: if (l_procedureEnabled) then