APPS.ZPB_BISM SQL Statements

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

Line: 23

  SELECT subject_id
    INTO l_subject_id
  FROM
    bism_subjects
  WHERE
    subject_type = 'u' and
    subject_name = (SELECT user_name FROM fnd_user WHERE user_id = p_user_id);

Line: 54

  SELECT subject_id
    INTO l_subject_id
  FROM
    bism_subjects
  WHERE
    subject_type = 'u' and
    subject_name = (SELECT user_name FROM fnd_user WHERE user_id = p_user_id);

Line: 83

  SELECT subject_id
    INTO l_subject_id
  FROM
    bism_subjects
  WHERE
    subject_name = upper(p_user_name) and
    subject_type = 'u';

Line: 112

  SELECT
    subject_id into subject_id
  FROM
    bism_subjects
  WHERE subject_name = p_resp_key AND
    subject_type = 'g';

Line: 187

  select description
  into l_bism_object_desc
  from bism_objects
  where object_id = l_bism_object_id;

Line: 205

PROCEDURE delete_bism_object (
  p_folder_path  varchar2,
  p_object_name BISM_OBJECTS.OBJECT_NAME%TYPE,
  p_user_id varchar2 default NULL)

IS

  l_bism_folder_id BISM_OBJECTS.OBJECT_ID%TYPE;

Line: 227

    bism_core.delete_object(l_bism_folder_id, p_object_name, l_bism_subject_id);

Line: 231

                                            'delete_bism_object');

Line: 246

PROCEDURE delete_bism_folder (
  p_folder_path  varchar2,
  p_user_id IN fnd_user.user_id%TYPE)

IS

  l_bism_folder_id BISM_OBJECTS.OBJECT_ID%TYPE;

Line: 261

    bism_core.delete_folder(l_bism_folder_id, l_bism_subject_id);

Line: 265

                                            'delete_bism_folder');

Line: 282

PROCEDURE delete_bism_folder_wo_security (
  p_folder_path  varchar2,
  p_user_id IN fnd_user.user_id%TYPE)

IS

  l_bism_folder_id BISM_OBJECTS.OBJECT_ID%TYPE;

Line: 296

    bism_core.delete_folder_wo_security(l_bism_folder_id, l_bism_subject_id);

Line: 300

                                            'delete_bism_object_wo_security');