APPS.EC_EXECUTION_UTILS SQL Statements

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

Line: 593

select	epm.transtage_id transtage_id,
	upper(etsd.custom_procedure_name) procedure_name,
	upper(epm.parameter_name) parameter_name,
	epm.action_type action_type,
	epm.variable_level variable_level,
	upper(epm.variable_name) variable_name
from	ece_procedure_mappings epm,
	ece_tran_stage_data etsd
where	etsd.transtage_id = epm.transtage_id
and	etsd.transaction_type = p_transaction_type
and	etsd.map_id = ec_utils.g_map_id;

Line: 846

	select	external_level_id,
		external_level,
		start_element
	from	ece_external_levels
	where	transaction_type = p_transaction_type
	and	map_id		= p_map_id
	order by external_level;

Line: 860

	select	to_number(output_level) output_level,
		interface_table_name,
		parent_level,
		interface_table_id,
		key_column_name
	from	ece_interface_tables
	where	transaction_type = p_transaction_type
	and	map_id = p_map_id
	order by to_number(output_level);

Line: 875

	select	to_number(eit.output_level) output_level
	from	ece_level_matrices elm,
		ece_interface_tables eit
	where	elm.external_level_id = p_external_id
	and	eit.interface_table_id = elm.interface_table_id;

Line: 886

	select	interface_column_name,
		interface_column_id,
		base_column_name,
		conversion_sequence,
		conversion_group_id,
		xref_category_id,
		xref_category_allowed,
		xref_key1_source_column,
		xref_key2_source_column,
		xref_key3_source_column,
		xref_key4_source_column,
		xref_key5_source_column,
		staging_column,
		data_type,
		width,
		record_number,
		position,
		record_layout_code,
		record_layout_qualifier,
		element_tag_name,
		external_level
	from	ece_interface_columns
	where	interface_table_id = p_interface_table_id
	and	map_id	= p_map_id
	ORDER BY interface_column_id;

Line: 917

        select  column_rule_id,
                rule_type,
                action_code
        from   ece_column_rules
        where  interface_column_id = p_interface_column_id
        order  by sequence;

Line: 1120

                select 'Y'
	        into ec_utils.g_file_tbl(m_count).column_rule_flag
		from ece_column_rules
		where interface_column_id = c4.interface_column_id
                and rownum = 1;

Line: 1213

	Update the File/Stack pointer for Internal Levels over here.
	**/
	ec_utils.g_int_levels(i_count).file_end_pos := ec_utils.g_file_tbl.COUNT;

Line: 1244

Update the File_pointer for External Levels over here.
**/
if ec_utils.g_direction = 'I'
then
for i in 1..ec_utils.g_ext_levels.COUNT
loop
	i_first_found := FALSE;