APPS.ICX_ON_CABO SQL Statements

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

Line: 79

  select  PRIMARY_REGION_APPL_ID,PRIMARY_REGION_CODE,
          NAME,DESCRIPTION
  into    l_region_appl_id,l_region_code,
          l_page_title,l_page_description
  from    AK_FLOW_PAGES_VL
  where   PAGE_CODE = p_page_code
  and     PAGE_APPLICATION_ID = p_page_appl_id
  and     FLOW_CODE = p_flow_code
  and     FLOW_APPLICATION_ID = p_flow_appl_id;

Line: 89

  select  REGION_APPLICATION_ID,REGION_CODE,
          NAME,DESCRIPTION
  into    l_region_appl_id,l_region_code,
          l_page_title,l_page_description
  from    AK_REGIONS_VL
  where   REGION_CODE = p_region_code
  and     REGION_APPLICATION_ID = p_region_appl_id;

Line: 101

l_toolbar.menu_url := 'insert_help_url_here';

Line: 105

l_toolbar.help_url := 'insert_help_url_here';

Line: 207

        select  d.COLUMN_NAME,b.DATA_TYPE,a.ATTRIBUTE_LABEL_LONG,e.ICX_CUSTOM_CALL
        from    AK_ATTRIBUTES b,
                AK_REGIONS c,
                AK_OBJECT_ATTRIBUTES d,
		AK_REGION_ITEMS e,
		AK_REGION_ITEMS_VL a
        where   a.REGION_APPLICATION_ID = p_region_appl_id
        and     a.REGION_CODE = p_region_code
        and     a.NODE_QUERY_FLAG = 'Y'
        and     a.REGION_APPLICATION_ID = c.REGION_APPLICATION_ID
        and     a.REGION_CODE = c.REGION_CODE
        and     c.DATABASE_OBJECT_NAME = d.DATABASE_OBJECT_NAME
        and     a.ATTRIBUTE_APPLICATION_ID = d.ATTRIBUTE_APPLICATION_ID
        and     a.ATTRIBUTE_CODE = d.ATTRIBUTE_CODE
	and	a.ATTRIBUTE_APPLICATION_ID = b.ATTRIBUTE_APPLICATION_ID
	and	a.ATTRIBUTE_CODE = b.ATTRIBUTE_CODE
	and	a.REGION_APPLICATION_ID = e.REGION_APPLICATION_ID
	and	a.REGION_CODE = e.REGION_CODE
	and     a.ATTRIBUTE_APPLICATION_ID = e.ATTRIBUTE_APPLICATION_ID
	and     a.ATTRIBUTE_CODE = e.ATTRIBUTE_CODE
	and	not exists     (select  'X'
				from 	AK_EXCLUDED_ITEMS
				where	RESPONSIBILITY_ID = l_responsibility_id
				and	ATTRIBUTE_CODE = a.ATTRIBUTE_CODE
				and	ATTRIBUTE_APPLICATION_ID = a.ATTRIBUTE_APPLICATION_ID)
        order by a.DISPLAY_SEQUENCE;

Line: 260

c_attributes(0) := htf.formSelectOption(' ');

Line: 316

        c_attributes(i) := ''||P_ATTR_TAB(f).ATTRIBUTE_LABEL_LONG;

Line: 321

c_attributes(i) := c_attributes(i)||htf.formSelectClose;

Line: 324

c_condition(0) := htf.formSelectOption(' ');

Line: 337

	c_condition(x) := c_condition(x)||''||l_lookup_meanings(i);

Line: 340

	c_condition(x) := c_condition(x)||''||l_lookup_meanings(i);

Line: 345

c_condition(x) := c_condition(x)||htf.formSelectClose;

Line: 360

select  icx_custom_call
into    l_icx_custom_call
from    ak_regions
where   REGION_APPLICATION_ID = p_region_appl_id
and     REGION_CODE = p_region_code;

Line: 500

select  NAME,DESCRIPTION
into    l_page_title,l_page_description
from    AK_FLOW_PAGES_VL
where   PAGE_CODE = p_page_code
and     PAGE_APPLICATION_ID = p_page_appl_id
and     FLOW_CODE = p_flow_code
and     FLOW_APPLICATION_ID = p_flow_appl_id;

Line: 511

select  NAME,DESCRIPTION
into    l_region_title,l_region_description
from    AK_REGIONS_VL
where   REGION_CODE = p_region_code
and     REGION_APPLICATION_ID = p_region_appl_id;

Line: 579

                htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(1));

Line: 580

        	htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(1));

Line: 582

                htp.tableData(htf.formSelectOpen('a_'||i)||c_attributes(0));

Line: 583

        	htp.tableData(htf.formSelectOpen('c_'||i)||c_condition(0));

Line: 703

select  NAME,DESCRIPTION
into    l_page_title,l_page_description
from    AK_FLOW_PAGES_VL
where   PAGE_CODE = l_page_code
and	PAGE_APPLICATION_ID = l_page_appl_id
and	FLOW_CODE = l_flow_code
and	FLOW_APPLICATION_ID = l_flow_appl_id;

Line: 802

      select	DESCRIPTION
      into	l_region_description
      from	AK_REGIONS_VL
      where	REGION_APPLICATION_ID = ak_query_pkg.g_regions_table(r).region_application_id
      and	REGION_CODE = ak_query_pkg.g_regions_table(r).region_code;

Line: 877

  select  NAME,DESCRIPTION
  into    l_page_title,l_page_description
  from    AK_FLOW_PAGES_VL
  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: 886

  l_toolbar.menu_url := 'insert_help_url_here';

Line: 890

  l_toolbar.help_url := 'insert_help_url_here';

Line: 892

  l_toolbar.custom_option1_url := 'insert_help_url_here';

Line: 934

  select  FLOW_APPLICATION_ID,FLOW_CODE,
          TO_PAGE_APPL_ID,TO_PAGE_CODE
  into    l_flow_appl_id,l_flow_code,
          l_page_appl_id,l_page_code
  from    AK_FLOW_REGION_RELATIONS
  where   ROWID = icx_on_utilities.g_on_parameters(10);

Line: 941

  select  NAME,DESCRIPTION
  into    l_page_title,l_page_description
  from    AK_FLOW_PAGES_VL
  where   PAGE_CODE = l_page_code
  and     PAGE_APPLICATION_ID = l_page_appl_id
  and     FLOW_CODE = l_flow_code
  and     FLOW_APPLICATION_ID = l_flow_appl_id;

Line: 950

  l_toolbar.menu_url := 'insert_help_url_here';

Line: 954

  l_toolbar.help_url := 'insert_help_url_here';

Line: 956

  l_toolbar.custom_option1_url := 'insert_help_url_here';