APPS.AK_FLOW3_PVT SQL Statements

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

Line: 59

  select 1
  from   AK_FLOW_PAGES
  where  flow_application_id = p_flow_application_id
  and    flow_code = p_flow_code;

Line: 110

       p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
    l_error := TRUE;

Line: 121

       p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
    l_error := TRUE;

Line: 132

       p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
    l_error := TRUE;

Line: 249

  select 1
  from   AK_FLOW_PAGE_REGIONS
  where  flow_application_id = p_flow_application_id
  and    flow_code = p_flow_code
  and    page_application_id = p_page_application_id
  and    page_code = p_page_code;

Line: 340

       p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
    l_error := TRUE;

Line: 351

       p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
    l_error := TRUE;

Line: 362

       p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
    l_error := TRUE;

Line: 492

    select 1
    from   AK_FLOW_PAGE_REGIONS
    where  flow_application_id = p_flow_application_id
    and    flow_code = p_flow_code
    and    page_application_id = p_page_application_id
    and    page_code = p_page_code
    and    display_sequence = p_display_sequence
    and    ( (region_application_id <> p_region_application_id) or
             (region_code <> p_region_code) );

Line: 502

    select primary_region_appl_id, primary_region_code
    from   AK_FLOW_PAGES
    where  flow_application_id = p_flow_application_id
    and    flow_code = p_flow_code
    and    page_application_id = p_page_application_id
    and    page_code = p_page_code;

Line: 637

      (p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
    l_error := TRUE;

Line: 879

    select 1
    from   AK_ATTRIBUTES
    where  attribute_application_id = p_to_url_attribute_appl_id
    and    attribute_code = p_to_url_attribute_code
    and    upper(data_type) = 'URL';

Line: 885

    select 1
    from   AK_FLOW_REGION_RELATIONS
    where  flow_application_id = p_flow_application_id
    and    flow_code = p_flow_code
    and    from_page_appl_id = p_page_application_id
    and    from_page_code = p_page_code
    and    from_region_appl_id = p_region_application_id
    and    from_region_code = p_region_code
    and    to_page_appl_id = p_to_page_appl_id
    and    to_page_code = p_to_page_code;

Line: 1113

      FND_MESSAGE.SET_NAME('AK','AK_NO_LINK_SELECTED');

Line: 1127

      FND_MESSAGE.SET_NAME('AK','AK_TWO_LINK_SELECTED');

Line: 1274

  select 1
  from   ak_foreign_keys fk, ak_unique_keys uk,
         ak_regions ar1, ak_regions ar2
  where  fk.database_object_name = ar1.database_object_name
  and    fk.unique_key_name = uk.unique_key_name
  and    uk.database_object_name = ar2.database_object_name
  and    ar1.region_application_id = p_from_region_appl_id
  and    ar1.region_code = p_from_region_code
  and    ar2.region_application_id = p_to_region_appl_id
  and    ar2.region_code = p_to_region_code
  and    fk.foreign_key_name = p_foreign_key_name
  UNION
  select 1
  from   ak_foreign_keys fk, ak_unique_keys uk,
         ak_regions ar1, ak_regions ar2
  where  fk.database_object_name = ar2.database_object_name
  and    fk.unique_key_name = uk.unique_key_name
  and    uk.database_object_name = ar1.database_object_name
  and    ar1.region_application_id = p_from_region_appl_id
  and    ar1.region_code = p_from_region_code
  and    ar2.region_application_id = p_to_region_appl_id
  and    ar2.region_code = p_to_region_code
  and    fk.foreign_key_name = p_foreign_key_name;

Line: 1519

      (p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
    l_error := TRUE;