APPS.ICX_ON SQL Statements

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

Line: 96

		select  REGION_CODE
		into    l_start_region
		from    AK_FLOW_PAGE_REGIONS
		where   PAGE_CODE = icx_on_utilities.g_on_parameters(5)
		and     PAGE_APPLICATION_ID = icx_on_utilities.g_on_parameters(4)
		and     FLOW_CODE = icx_on_utilities.g_on_parameters(3)
		and     FLOW_APPLICATION_ID = icx_on_utilities.g_on_parameters(2)
		and     PARENT_REGION_CODE is null;

Line: 110

                select  count(*)
                into    l_count
                from    AK_FLOW_PAGE_REGIONS
                where   PAGE_CODE = icx_on_utilities.g_on_parameters(5)
                and     PAGE_APPLICATION_ID = icx_on_utilities.g_on_parameters(4)
                and     FLOW_CODE = icx_on_utilities.g_on_parameters(3)
                and     FLOW_APPLICATION_ID = icx_on_utilities.g_on_parameters(2);

Line: 162

        select substr(l_message,12,512) into l_err_mesg from dual;

Line: 244

select  REGION_APPLICATION_ID,REGION_CODE
into	l_region_appl_id,l_region_code
from    AK_FLOW_PAGE_REGIONS
where   FLOW_CODE = l_flow_code
and     FLOW_APPLICATION_ID = l_flow_appl_id
and     PAGE_CODE = l_page_code
and     PAGE_APPLICATION_ID = l_page_appl_id;

Line: 292

select  FLOW_APPLICATION_ID,FLOW_CODE,
	FROM_PAGE_APPL_ID,FROM_PAGE_CODE,
        FROM_REGION_APPL_ID,FROM_REGION_CODE,
        TO_PAGE_APPL_ID,TO_PAGE_CODE
into    l_flow_appl_id,l_flow_code,
	c_from_page_appl_id,c_from_page_code,
        c_from_region_appl_id,c_from_region_code,
        c_to_page_appl_id,c_to_page_code
from    AK_FLOW_REGION_RELATIONS
where   ROWID = c_rowid;