APPS.ORACLEON SQL Statements

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

Line: 107

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

Line: 145

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

Line: 183

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

Line: 208

    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: 235

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

Line: 320

select  PRIMARY_REGION_CODE,NAME,DESCRIPTION
into    c_region_code,c_name,c_description
from    AK_FLOW_PAGES_VL
where   FLOW_CODE = c_flow_code
and	FLOW_APPLICATION_ID = c_flow_appl_id
and     PAGE_CODE = c_page_code
and	PAGE_APPLICATION_ID = c_page_appl_id;

Line: 355

        select  REGION_APPLICATION_ID,REGION_CODE
        from    AK_FLOW_PAGE_REGIONS
        where   PAGE_APPLICATION_ID = c_page_appl_id
	and	PAGE_CODE = c_page_code
	and	FLOW_APPLICATION_ID = c_flow_appl_id
        and     FLOW_CODE = c_flow_code
        order by DISPLAY_SEQUENCE;

Line: 364

        select  c.TO_PAGE_APPL_ID,c.TO_PAGE_CODE,a.ATTRIBUTE_CODE,a.ATTRIBUTE_LABEL_LONG
        from    AK_REGION_ITEMS_VL a,
                AK_FLOW_PAGE_REGION_ITEMS c
        where   a.REGION_CODE = l_region_code
	and	a.REGION_APPLICATION_ID = l_region_appl_id
        and     c.FLOW_CODE = c_flow_code
	and	c.FLOW_APPLICATION_ID = c_flow_appl_id
        and     c.PAGE_CODE = c_page_code
	and	c.PAGE_APPLICATION_ID = c_page_appl_id
        and     c.REGION_CODE = a.REGION_CODE
	and	c.REGION_APPLICATION_ID = a.REGION_APPLICATION_ID
        and     c.ATTRIBUTE_CODE = a.ATTRIBUTE_CODE
	and	c.TO_PAGE_CODE is not null
        order by DISPLAY_SEQUENCE;