APPS.EC_XML_UTILS SQL Statements

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

Line: 9

	select	transaction_type
	from	ece_mappings
	where 	map_id = p_map_id;

Line: 19

	select	start_element,
		external_level,
		external_level_id,
		parent_level
	from	ece_external_levels
	where	transaction_type = p_transaction_type
	and	map_id = p_map_id
	start with parent_level = 0
	connect by prior external_level_id = parent_level;

Line: 35

	select	interface_column_name,
		staging_column,
		element_tag_name
	from	ece_interface_columns
	where	map_id = p_map_id
	and	external_level = p_external_level
	and	staging_column is not null
	and	element_tag_name is not null
	order by interface_column_id;

Line: 51

	select	root_element
	from	ece_mappings
	where	transaction_type = p_transaction_type
	and	map_id = p_map_id;

Line: 68

i_select_clause			varchar2(32000);

Line: 118

	i_string := 'select ';

Line: 157

	i_select_clause := substrb(i_string,1,length(i_string)-1);

Line: 166

			i_select_clause,
			i_from_clause,
			i_where_clause,
			i_orderby_clause,
			i_attributes_to_hide,
			i_product_code,
			i_apps_error_code,
			i_parameter0,
			i_parameter1,
			i_parameter2,
			i_parameter3,
			i_parameter4,
			i_error_string
			);

Line: 187

			i_select_clause,
			i_from_clause,
			i_where_clause,
			i_orderby_clause,
			i_attributes_to_hide,
			i_parent_data_object,
			i_bind_parent_attributealiases,
			i_bind_child_attributealiases,
			i_bind_child_attributecolumns,
			i_product_code,
			i_apps_error_code,
			i_parameter0,
			i_parameter1,
			i_parameter2,
			i_parameter3,
			i_parameter4,
			i_error_string
			);

Line: 240

	i_select_clause		IN	varchar2,
	i_from_clause		IN	varchar2,
	i_where_clause		IN	varchar2,
	i_orderby_clause	IN	varchar2,
	i_attributes_to_hide	IN	varchar2,
	i_product_code		OUT	varchar2,
	i_apps_error_code	OUT	varchar2,
	i_parameter0		OUT	varchar2,
	i_parameter1		OUT	varchar2,
	i_parameter2		OUT	varchar2,
	i_parameter3		OUT	varchar2,
	i_parameter4		OUT	varchar2,
	i_error_string		OUT	varchar2
	)
is
begin
	null;

Line: 264

	i_select_clause			IN	varchar2,
	i_from_clause			IN	varchar2,
	i_where_clause			IN	varchar2,
	i_orderby_clause		IN	varchar2,
	i_attributes_to_hide		IN	varchar2,
	i_parent_data_object		IN	varchar2,
	i_bind_parent_attributealiases	IN	varchar2,
	i_bind_child_attributealiases	IN	varchar2,
	i_bind_child_attributecolumns	IN	varchar2,
	i_product_code			OUT	varchar2,
	i_apps_error_code		OUT	varchar2,
	i_parameter0			OUT	varchar2,
	i_parameter1			OUT	varchar2,
	i_parameter2			OUT	varchar2,
	i_parameter3			OUT	varchar2,
	i_parameter4			OUT	varchar2,
	i_error_string			OUT	varchar2
	)
is
begin
	null;

Line: 413

                select  ece_output_runs_s.NEXTVAL
                into    c_run_id
                from    dual;