APPS.BIS_BUSINESS_VIEWS_CATALOG SQL Statements

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

Line: 11

, p_delete        IN  VARCHAR2   DEFAULT 'N'
)

IS
l_lang           varchar2(100);

Line: 23

  IF  upper( p_delete ) <> 'Y'  --  if p_delete is set to yes, STOP
  AND ICX_SEC.validatePlugSession( p_plug_id, p_session_id )  THEN

    -- Get the Language CODE and USERID from the ICX environment
    l_user_id := ICX_SEC.getID(ICX_SEC.pv_user_id, '', p_session_id);

Line: 64

        insert_blank_cell;

Line: 116

    l_sql:= 'select ba_name from ' || p_eul ||'.eul_business_areas ba, ' ||
                                  p_eul ||'.eul_ba_obj_links bol ' ||
        'where ' || p_folder_id || ' = bol.bol_obj_id ' ||
        'and        bol.bol_ba_id    =  ba.ba_id ';

Line: 144

procedure  insert_heading_cell( p_text  in  varchar2 )
is
begin

  htp.p('');

Line: 159

end  insert_heading_cell;

Line: 164

procedure  insert_blank_heading_cell
is
begin

  htp.p('');

Line: 178

end  insert_blank_heading_cell;

Line: 183

procedure  insert_blank_cell
is
begin

  htp.p(''||'&'||'nbsp');

Line: 189

end  insert_blank_cell;

Line: 223

    insert_blank_heading_cell;

Line: 224

    insert_heading_cell(c_folder);

Line: 226

    insert_blank_heading_cell;

Line: 233

    insert_blank_heading_cell;

Line: 350

  insert_blank_cell;