APPS.ECX_OUTBOUND dependencies on DBMS_SQL

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

686: -- Set the Global Variable for Current Level
687: ecx_utils.g_current_level := i;
688: /* Bind the Variables for the Where Clause */
689: ecx_actions.bind_variables_for_view(10,i);
690: i_rows_processed := dbms_sql.execute (ecx_utils.g_source_levels(i).Cursor_Handle);
691: IF(l_statementEnabled) THEN
692: ecx_debug.log(l_statement,'Cursor Handle',ecx_utils.g_source_levels(i).Cursor_handle, i_method_name);
693: END IF;
694: WHILE (dbms_sql.fetch_rows( ecx_utils.g_source_levels(i).Cursor_handle) > 0)

Line 694: WHILE (dbms_sql.fetch_rows( ecx_utils.g_source_levels(i).Cursor_handle) > 0)

690: i_rows_processed := dbms_sql.execute (ecx_utils.g_source_levels(i).Cursor_Handle);
691: IF(l_statementEnabled) THEN
692: ecx_debug.log(l_statement,'Cursor Handle',ecx_utils.g_source_levels(i).Cursor_handle, i_method_name);
693: END IF;
694: WHILE (dbms_sql.fetch_rows( ecx_utils.g_source_levels(i).Cursor_handle) > 0)
695: LOOP
696: push(i);
697: IF(l_statementEnabled) THEN
698: ecx_debug.log(l_statement,'Executing Fetch Rows',i_method_Name);

Line 708: dbms_sql.column_value ( ecx_utils.g_source_levels(i).Cursor_handle, i_column_counter, ecx_utils.g_source(j).value );

704: LOOP
705: IF (ecx_utils.g_source(j).external_level = i) THEN
706: i_column_counter := i_column_counter + 1;
707: IF ecx_utils.g_source(j).data_type <> 112 THEN
708: dbms_sql.column_value ( ecx_utils.g_source_levels(i).Cursor_handle, i_column_counter, ecx_utils.g_source(j).value );
709: ELSE
710: dbms_sql.column_value ( ecx_utils.g_source_levels(i).Cursor_handle, i_column_counter, ecx_utils.g_source(j).clob_value );
711: /** Change required for Clob Support -- 2263729 ***/
712: ecx_utils.g_source(j).clob_length := dbms_lob.getlength( ecx_utils.g_source(j).clob_value);

Line 710: dbms_sql.column_value ( ecx_utils.g_source_levels(i).Cursor_handle, i_column_counter, ecx_utils.g_source(j).clob_value );

706: i_column_counter := i_column_counter + 1;
707: IF ecx_utils.g_source(j).data_type <> 112 THEN
708: dbms_sql.column_value ( ecx_utils.g_source_levels(i).Cursor_handle, i_column_counter, ecx_utils.g_source(j).value );
709: ELSE
710: dbms_sql.column_value ( ecx_utils.g_source_levels(i).Cursor_handle, i_column_counter, ecx_utils.g_source(j).clob_value );
711: /** Change required for Clob Support -- 2263729 ***/
712: ecx_utils.g_source(j).clob_length := dbms_lob.getlength( ecx_utils.g_source(j).clob_value);
713: i_len := ecx_utils.g_source(j).clob_length;
714: ecx_utils.g_source(j).is_clob := 'N';

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

773: fetch_data_from_view(i);
774: END IF;
775: END LOOP;
776: IF i = 1 THEN
777: ecx_utils.g_source_levels(i).rows_processed := dbms_sql.last_row_count;
778: ELSE
779: ecx_utils.g_source_levels(i).rows_processed := ecx_utils.g_source_levels(i).rows_processed + dbms_sql.last_row_count;
780: END IF;
781: END IF;

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

775: END LOOP;
776: IF i = 1 THEN
777: ecx_utils.g_source_levels(i).rows_processed := dbms_sql.last_row_count;
778: ELSE
779: ecx_utils.g_source_levels(i).rows_processed := ecx_utils.g_source_levels(i).rows_processed + dbms_sql.last_row_count;
780: END IF;
781: END IF;
782: END LOOP;
783: IF (l_procedureEnabled) THEN