eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_PAGE_PUB SQL Statements

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

Line: 48


    select BIS_COMMON_UTILS.getParameterValue(parameters, c_SOURCE_TYPE) into l_type
    from fnd_form_functions
    where function_name = p_page_function_name;

Line: 68


    select count(1) into l_count
    from fnd_form_functions
    where function_name = p_internal_name;

Line: 73


      select count(1) into l_count
      from ak_regions
      where region_code = p_internal_name
      and region_application_id = p_application_id;

Line: 86


    BIS_AK_REGION_PUB.INSERT_REGION_ROW (
      p_REGION_CODE => p_internal_name,
      p_REGION_APPLICATION_ID => p_application_id,
      p_DATABASE_OBJECT_NAME => c_DUMMY_DB_OBJECT,
      p_APPL_MODULE_OBJECT_TYPE => c_APP_MOD,
      p_NAME => p_title,
      p_REGION_STYLE => c_PAGE_LAYOUT,
      p_ATTRIBUTE_CATEGORY => c_ATTRIBUTE_CATEGORY,
      x_return_status => x_return_status,
      x_msg_count => x_msg_count,
      x_msg_data =>x_msg_data);

Line: 99


    select lower(application_short_name) into l_app_short_name
    from fnd_application
    where application_id = p_application_id;

Line: 107


    BIS_FORM_FUNCTIONS_PUB.INSERT_ROW (
      p_FUNCTION_NAME => p_internal_name,
      p_WEB_HTML_CALL => c_WEB_HTML_CALL,
      p_PARAMETERS => l_parameters,
      p_TYPE => c_FUNCTION_TYPE,
      p_USER_FUNCTION_NAME => p_title,
      x_FUNCTION_ID => x_page_id,
      x_return_status => x_return_status,
      x_msg_count => x_msg_count,
      x_msg_data =>x_msg_data);

Line: 142


procedure Update_Page_Region(
 p_internal_name    IN VARCHAR2
,p_application_id               IN NUMBER
,p_title      IN VARCHAR2
,p_page_id      IN NUMBER
,p_new_internal_name    IN VARCHAR2
,p_new_application_id   IN NUMBER
,x_return_status                OUT NOCOPY VARCHAR2
,x_msg_count                    OUT NOCOPY NUMBER
,x_msg_data                     OUT NOCOPY VARCHAR2
) is

l_count     NUMBER;

Line: 178


    BIS_AK_REGION_PUB.UPDATE_REGION_ROW (
      p_REGION_CODE => p_internal_name,
      p_REGION_APPLICATION_ID => p_application_id,
      p_DATABASE_OBJECT_NAME => c_DUMMY_DB_OBJECT,
      p_NAME => p_title,
      p_ATTRIBUTE_CATEGORY => c_ATTRIBUTE_CATEGORY,
      x_return_status => x_return_status,
      x_msg_count => x_msg_count,
      x_msg_data =>x_msg_data);

Line: 189


    BIS_FORM_FUNCTIONS_PUB.UPDATE_ROW (
      p_FUNCTION_ID => p_page_id,
      p_USER_FUNCTION_NAME => p_title,
      x_return_status => x_return_status,
      x_msg_count => x_msg_count,
      x_msg_data =>x_msg_data);

Line: 201


    select count(1) into l_count
    from fnd_form_functions
    where function_name = l_new_internal_name;

Line: 206


      select count(1) into l_count
      from ak_regions
      where region_code = l_new_internal_name
      and region_application_id = l_new_application_id;

Line: 219


    BIS_AK_REGION_PUB.DELETE_REGION_ROW(
      p_REGION_CODE => p_internal_name,
      p_REGION_APPLICATION_ID => p_application_id,
      x_return_status => x_return_status,
      x_msg_count => x_msg_count,
      x_msg_data =>x_msg_data);

Line: 227


    BIS_AK_REGION_PUB.INSERT_REGION_ROW (
      p_REGION_CODE => l_new_internal_name,
      p_REGION_APPLICATION_ID => l_new_application_id,
      p_DATABASE_OBJECT_NAME => c_DUMMY_DB_OBJECT,
      p_APPL_MODULE_OBJECT_TYPE => c_APP_MOD,
      p_NAME => p_title,
      p_REGION_STYLE => c_PAGE_LAYOUT,
      p_ATTRIBUTE_CATEGORY => c_ATTRIBUTE_CATEGORY,
      x_return_status => x_return_status,
      x_msg_count => x_msg_count,
      x_msg_data =>x_msg_data);

Line: 240


    select lower(application_short_name) into l_app_short_name
    from fnd_application
    where application_id = l_new_application_id;

Line: 244


    select parameters into l_parameters from fnd_form_functions
    where function_id = p_page_id;

Line: 250


      UPDATE fnd_form_functions
      SET    function_name = l_new_internal_name
      WHERE  function_id = p_page_id;

Line: 255


    BIS_FORM_FUNCTIONS_PUB.UPDATE_ROW (
      p_FUNCTION_ID => p_page_id,
      p_USER_FUNCTION_NAME => p_title,
      p_PARAMETERS => l_parameters,
      x_return_status => x_return_status,
      x_msg_count => x_msg_count,
      x_msg_data =>x_msg_data);

Line: 266


  Delete_Page_Racks(
      p_internal_name => p_internal_name,
      p_application_id => p_application_id,
      x_return_status => x_return_status,
      x_msg_count => x_msg_count,
      x_msg_data =>x_msg_data);

Line: 295


end Update_page_Region;

Line: 297


Procedure Delete_Page_Region (
 p_internal_name    IN VARCHAR2
,p_application_id               IN NUMBER
,p_page_id      IN NUMBER
,x_return_status                OUT NOCOPY VARCHAR2
,x_msg_count                    OUT NOCOPY NUMBER
,x_msg_data                     OUT NOCOPY VARCHAR2
) is

begin
  fnd_msg_pub.initialize;

Line: 310


  Delete_Page_Racks(
    p_internal_name => p_internal_name,
    p_application_id => p_application_id,
    x_return_status => x_return_status,
    x_msg_count => x_msg_count,
    x_msg_data =>x_msg_data);

Line: 317


  BIS_AK_REGION_PUB.DELETE_REGION_ROW(
    p_REGION_CODE => p_internal_name,
    p_REGION_APPLICATION_ID => p_application_id,
    x_return_status => x_return_status,
    x_msg_count => x_msg_count,
    x_msg_data =>x_msg_data);

Line: 324


  BIS_FORM_FUNCTIONS_PUB.DELETE_ROW(
    p_FUNCTION_ID => p_page_id,
    x_return_status => x_return_status,
    x_msg_count => x_msg_count,
    x_msg_data =>x_msg_data);

Line: 352


END Delete_Page_Region;

Line: 367


  BIS_AK_REGION_PUB.INSERT_REGION_ROW (
    p_REGION_CODE => p_internal_name,
    p_REGION_APPLICATION_ID => p_application_id,
    p_DATABASE_OBJECT_NAME => c_DUMMY_DB_OBJECT,
    p_NAME => p_internal_name,
    p_REGION_STYLE => c_ROW_LAYOUT,
    p_ATTRIBUTE_CATEGORY => c_ATTRIBUTE_CATEGORY,
    x_return_status => x_return_status,
    x_msg_count => x_msg_count,
    x_msg_data =>x_msg_data);

Line: 403


Procedure Delete_Rack_Region (
 p_internal_name    IN VARCHAR2
,p_application_id               IN NUMBER
,x_return_status                OUT NOCOPY VARCHAR2
,x_msg_count                    OUT NOCOPY NUMBER
,x_msg_data                     OUT NOCOPY VARCHAR2
) is
begin

  fnd_msg_pub.initialize;

Line: 414


  delete_region_items(
      p_internal_name => p_internal_name,
      p_application_id => p_application_id,
      x_return_status => x_return_status,
      x_msg_count => x_msg_count,
      x_msg_data =>x_msg_data);

Line: 421


  BIS_AK_REGION_PUB.DELETE_REGION_ROW(
    p_REGION_CODE => p_internal_name,
    p_REGION_APPLICATION_ID => p_application_id,
    x_return_status => x_return_status,
    x_msg_count => x_msg_count,
    x_msg_data =>x_msg_data);

Line: 449


END Delete_Rack_Region;

Line: 469


  BIS_AK_REGION_PUB.INSERT_REGION_ITEM_ROW (
    p_REGION_CODE => p_internal_name,
    p_REGION_APPLICATION_ID => p_application_id,
    p_ATTRIBUTE_CODE => c_RACK_ATTRIBUTE_CODE || p_Rack_Num,
    p_ATTRIBUTE_APPLICATION_ID => c_BIS_APP_ID,
    p_DISPLAY_SEQUENCE => p_Rack_Num,
    p_NODE_DISPLAY_FLAG => p_display_flag,
    p_NESTED_REGION_CODE => p_rack_region,
    p_NESTED_REGION_APPL_ID => p_rack_region_application_id,
    p_ATTRIBUTE_CATEGORY => c_ATTRIBUTE_CATEGORY,
    x_return_status => x_return_status,
    x_msg_count => x_msg_count,
    x_msg_data =>x_msg_data);

Line: 506


Procedure Delete_Rack_Item (
 p_internal_name    IN VARCHAR2
,p_application_id               IN NUMBER
,p_rack_Num     IN NUMBER
,x_return_status                OUT NOCOPY VARCHAR2
,x_msg_count                    OUT NOCOPY NUMBER
,x_msg_data                     OUT NOCOPY VARCHAR2
) is
begin

  fnd_msg_pub.initialize;

Line: 518


    BIS_AK_REGION_PUB.DELETE_REGION_ITEM_ROW(
        p_REGION_CODE => p_internal_name,
        p_REGION_APPLICATION_ID => p_application_id,
        p_ATTRIBUTE_CODE => c_RACK_ATTRIBUTE_CODE || p_Rack_Num,
        p_ATTRIBUTE_APPLICATION_ID => c_BIS_APP_ID,
    x_return_status => x_return_status,
    x_msg_count => x_msg_count,
    x_msg_data =>x_msg_data);

Line: 549


END Delete_Rack_Item;

Line: 569


  BIS_AK_REGION_PUB.INSERT_REGION_ITEM_ROW (
    p_REGION_CODE => p_internal_name,
    p_REGION_APPLICATION_ID => p_application_id,
    p_ATTRIBUTE_CODE => c_PORTLET_ATTRIBUTE_CODE || p_Portlet_Num,
    p_ATTRIBUTE_APPLICATION_ID => c_BIS_APP_ID,
    p_DISPLAY_SEQUENCE => p_Portlet_Num,
    p_NODE_DISPLAY_FLAG => p_display_flag,
    p_ATTRIBUTE_LABEL_LONG => p_Title,
    p_ATTRIBUTE_CATEGORY => c_ATTRIBUTE_CATEGORY,
    p_ATTRIBUTE1 => p_function_name,
    x_return_status => x_return_status,
    x_msg_count => x_msg_count,
    x_msg_data =>x_msg_data);

Line: 606


Procedure Delete_Rack_Item (
 p_internal_name    IN VARCHAR2
,p_application_id               IN NUMBER
,p_portlet_Num      IN NUMBER
,x_return_status                OUT NOCOPY VARCHAR2
,x_msg_count                    OUT NOCOPY NUMBER
,x_msg_data                     OUT NOCOPY VARCHAR2
) is
begin

    fnd_msg_pub.initialize;

Line: 618


    BIS_AK_REGION_PUB.DELETE_REGION_ITEM_ROW(
        p_REGION_CODE => p_internal_name,
        p_REGION_APPLICATION_ID => p_application_id,
        p_ATTRIBUTE_CODE => c_PORTLET_ATTRIBUTE_CODE || p_Portlet_Num,
        p_ATTRIBUTE_APPLICATION_ID => c_BIS_APP_ID,
    x_return_status => x_return_status,
    x_msg_count => x_msg_count,
    x_msg_data =>x_msg_data);

Line: 648


END Delete_Rack_Item;

Line: 650


Procedure Delete_Page_Racks (
 p_internal_name    IN VARCHAR2
,p_application_id               IN NUMBER
,x_return_status                OUT NOCOPY VARCHAR2
,x_msg_count                    OUT NOCOPY NUMBER
,x_msg_data                     OUT NOCOPY VARCHAR2
) is

cursor pageRacks_cursor IS
    select nested_region_code, nested_region_application_id
    from ak_region_items
    where region_code = p_internal_name
    and region_application_id = p_application_id;

Line: 671


    Delete_Rack_Region(
      p_internal_name => cr.nested_region_code,
      p_application_id => cr.nested_region_application_id,
      x_return_status => x_return_status,
      x_msg_count => x_msg_count,
      x_msg_data =>x_msg_data);

Line: 679


  delete_region_items(
      p_internal_name => p_internal_name,
      p_application_id => p_application_id,
      x_return_status => x_return_status,
      x_msg_count => x_msg_count,
      x_msg_data =>x_msg_data);

Line: 712


END Delete_Page_Racks;

Line: 714


Procedure Delete_Region_Items (
 p_internal_name    IN VARCHAR2
,p_application_id               IN NUMBER
,x_return_status                OUT NOCOPY VARCHAR2
,x_msg_count                    OUT NOCOPY NUMBER
,x_msg_data                     OUT NOCOPY VARCHAR2
) is

cursor items_cursor IS
    select attribute_code, attribute_application_id
    from ak_region_items
    where region_code = p_internal_name
    and region_application_id = p_application_id;

Line: 734


      BIS_AK_REGION_PUB.DELETE_REGION_ITEM_ROW(
          p_REGION_CODE => p_internal_name,
          p_REGION_APPLICATION_ID => p_application_id,
          p_ATTRIBUTE_CODE => cr.attribute_code,
          p_ATTRIBUTE_APPLICATION_ID => cr.attribute_application_id,
      x_return_status => x_return_status,
      x_msg_count => x_msg_count,
      x_msg_data =>x_msg_data);

Line: 770


END Delete_Region_Items;

Line: 782


  select region_code
  from ak_regions
  where region_code like p_region_code || '%'
  and region_application_id = p_application_id;

Line: 860


    select 1, attribute_category into l_count, l_attr_category
    from ak_regions
    where region_code = p_internal_name
    and region_application_id = p_application_id;

Line: 872


      Delete_Page_Racks(
        p_internal_name => p_internal_name,
        p_application_id => p_application_id,
        x_return_status => x_return_status,
        x_msg_count => x_msg_count,
        x_msg_data =>x_msg_data);

Line: 878


      BIS_AK_REGION_PUB.DELETE_REGION_ROW(
        p_REGION_CODE => p_internal_name,
        p_REGION_APPLICATION_ID => p_application_id,
        x_return_status => x_return_status,
        x_msg_count => x_msg_count,
        x_msg_data =>x_msg_data);

Line: 892


  BIS_AK_REGION_PUB.INSERT_REGION_ROW (
    p_REGION_CODE => p_internal_name,
    p_REGION_APPLICATION_ID => p_application_id,
    p_DATABASE_OBJECT_NAME => c_DUMMY_DB_OBJECT,
    p_NAME => p_title,
    p_REGION_STYLE => c_PAGE_LAYOUT,
    p_APPL_MODULE_OBJECT_TYPE => c_APP_MOD,
    p_ATTRIBUTE_CATEGORY => c_ATTRIBUTE_CATEGORY,
    x_return_status => x_return_status,
    x_msg_count => x_msg_count,
    x_msg_data =>x_msg_data);

Line: 905


  select parameters, function_id into l_parameters, l_function_id
  from fnd_form_functions
  where function_name = p_page_function_name;

Line: 909


  select lower(application_short_name) into l_app_short_name
  from fnd_application
  where application_id = p_application_id;

Line: 922


  BIS_FORM_FUNCTIONS_PUB.UPDATE_ROW (
    p_FUNCTION_ID => l_function_id,
    p_PARAMETERS => l_parameters,
    x_return_status => x_return_status,
    x_msg_count => x_msg_count,
    x_msg_data =>x_msg_data);

Line: 931


    UPDATE fnd_form_functions
    SET    function_name = p_internal_name
    WHERE  function_id = l_function_id;

Line: 981


  select count(1) into l_count
  from fnd_form_functions
  where function_name = p_page_function_name;

Line: 992


    select lower(application_short_name) into l_app_short_name
    from fnd_application
    where application_id = p_application_id;

Line: 1008


    BIS_FORM_FUNCTIONS_PUB.INSERT_ROW (
      p_FUNCTION_NAME => p_page_function_name,
      p_WEB_HTML_CALL => c_WEB_HTML_CALL,
      p_PARAMETERS => l_parameters,
      p_TYPE => c_FUNCTION_TYPE,
      p_USER_FUNCTION_NAME => p_title,
      p_DESCRIPTION => p_description,
      x_FUNCTION_ID => x_page_id,
      x_return_status => x_return_status,
      x_msg_count => x_msg_count,
      x_msg_data =>x_msg_data);

Line: 1045


procedure Update_Page_Function(
 p_page_function_name   IN VARCHAR2
,p_application_id           IN NUMBER
,p_title                    IN VARCHAR2
,p_page_xml_name            IN VARCHAR2 := null
,p_new_page_function_name   IN VARCHAR2
,p_new_application_id       IN NUMBER
,p_new_page_xml_name        IN VARCHAR2 := null
,p_description              IN VARCHAR2 := NULL
,x_return_status                OUT NOCOPY VARCHAR2
,x_msg_count                    OUT NOCOPY NUMBER
,x_msg_data                     OUT NOCOPY VARCHAR2
) is

l_count       NUMBER;

Line: 1072


    select  BIS_COMMON_UTILS.getParameterValue(parameters, c_SOURCE_TYPE),
      function_id,
      parameters
      into l_type, l_function_id, l_parameters
    from fnd_form_functions
    where function_name = p_page_function_name;

Line: 1094


  select lower(application_short_name) into l_app_short_name
  from fnd_application
  where application_id = l_application_id;

Line: 1117


    select count(1) into l_count
    from fnd_form_functions
    where function_name = l_page_function_name;

Line: 1128


    UPDATE fnd_form_functions
    SET    function_name = l_page_function_name
    WHERE  function_id = l_function_id;

Line: 1133


  BIS_FORM_FUNCTIONS_PUB.UPDATE_ROW (
    p_FUNCTION_ID => l_function_id,
    p_USER_FUNCTION_NAME => p_title,
    p_PARAMETERS => l_parameters,
    p_DESCRIPTION => p_description,
    x_return_status => x_return_status,
    x_msg_count => x_msg_count,
    x_msg_data =>x_msg_data);

Line: 1163


end Update_Page_Function;

Line: 1177


  SELECT user_function_name,parameters
  INTO l_custom_view_name,l_parameters
  FROM fnd_form_functions_vl
  WHERE function_id = p_Function_Id;

Line: 1184


    SELECT name
    INTO l_tab_name
    FROM bsc_tabs_vl
    WHERE tab_id = l_tab_id;