APPS.EC_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 95

Executes a select string and returns the First Column from the select
clause as OUT parameter.
**/
procedure execute_string
	(
	cString			in	varchar2,
	o_value			OUT  NOCOPY	varchar2
	)
is
cursor_handle	pls_integer;

Line: 174

	cString := 'select  '||i_seq_name||'.NEXTVAL  from dual';

Line: 195

Returns the Function Value by building a select Clause for the
Function name.
**/
procedure get_function_value
	(
	i_function_name		IN	VARCHAR2,
	o_value			OUT NOCOPY	varchar2
	)
is
cString		varchar2(2000);

Line: 218

	cString := 'select  '||cString||'  from dual';

Line: 661

	select	transtage_id,
		transaction_level,
		stage,
		seq_number,
		action_type,
		variable_level,
		upper(variable_name) variable_name,
		variable_value,
		default_value,
		previous_variable_level,
		upper(previous_variable_name) previous_variable_name,
		upper(next_variable_name) next_variable_name,
		upper(sequence_name) sequence_name,
		upper(custom_procedure_name) custom_procedure_name,
		data_type,
		upper(function_name) function_name,
		where_clause
	from	ece_tran_stage_data
	where	transaction_type = p_transaction_type
	and	map_id = p_map_id
	order by stage,transaction_level,seq_number;

Line: 693

i_tmp_stage_data.DELETE;

Line: 694

i_tmp2_stage_data.DELETE;

Line: 695

i_stage_data.DELETE;

Line: 2575

			ec_debug.pl(3,'Select Stmt',g_int_levels(g_current_level).sql_stmt);

Line: 3154

procedure EXT_INSERT_VALUE
        (
        i_position        IN      number,
        i_value           IN     varchar2
        )
is
o_stack_pos             pls_integer;

Line: 3164

ec_debug.push('EC_UTILS.EXT_INSERT_VALUE');

Line: 3174

ec_debug.pop('EC_UTILS.EXT_INSERT_VALUE');

Line: 3178

        ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_UTILS.EXT_INSERT_VALUE');

Line: 3182

END EXT_INSERT_VALUE;