APPS.PAY_DATABASE_ITEMS_PKG SQL Statements

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

Line: 17

  RThirlby  09-NOV-1999         Commented out if l_record_inserted clause
                                around create_db_item, so that dbi is
                                created even if user entity was previously
                                created.
  RThirlby  29-FEB-2000         No changes required for 11i upport
  EMunisek  13-NOV-2011         Changed parameter specification to
                                FF_ROUTES.TEXT%TYPE
*/
--
-- Procedures
--
PROCEDURE create_db_item(p_name                    VARCHAR2,
                         p_description             VARCHAR2 DEFAULT NULL,
                         p_data_type               VARCHAR2,
                         p_null_allowed            VARCHAR2,
			 p_definition_text         VARCHAR2,
                         p_user_entity_name        VARCHAR2,
			 p_user_entity_description VARCHAR2 DEFAULT NULL,
                         p_route_name              VARCHAR2,
                         p_param_value1            VARCHAR2 DEFAULT NULL,
			 p_param_value2            VARCHAR2 DEFAULT NULL,
                         p_route_description       VARCHAR2 DEFAULT NULL,
			 p_route_text              FF_ROUTES.TEXT%TYPE DEFAULT NULL,
			 p_context_name1           VARCHAR2 DEFAULT NULL,
			 p_context_name2           VARCHAR2 DEFAULT NULL,
			 p_context_name3           VARCHAR2 DEFAULT NULL,
			 p_context_name4           VARCHAR2 DEFAULT NULL,
                         p_param_name1             VARCHAR2 DEFAULT NULL,
			 p_param_type1             VARCHAR2 DEFAULT NULL,
			 p_param_name2             VARCHAR2 DEFAULT NULL,
                         p_param_type2             VARCHAR2 DEFAULT NULL,
                         p_legislation_code        VARCHAR2
   ) IS
--
l_route_id         NUMBER;

Line: 53

l_record_inserted  BOOLEAN;

Line: 76

    SELECT route_id
    INTO   l_route_id
    FROM   ff_routes
    WHERE  route_name = upper(p_route_name);

Line: 85

    INSERT INTO ff_routes
      (route_id,
       route_name,
       user_defined_flag,
       description,
       text,
       last_update_date,
       last_updated_by,
       last_update_login,
       created_by,
       creation_date)
    VALUES
      (ff_routes_s.nextval,
       upper(p_route_name),
       'N',
       p_route_description,
       p_route_text,
       sysdate,
       0,
       0,
       0,
      sysdate);

Line: 108

    SELECT ff_routes_s.currval
    INTO   l_route_id
    FROM   dual;

Line: 116

      INSERT INTO ff_route_context_usages
             (route_id,
              context_id,
              sequence_no)
      select  l_route_id,
              FFC.context_id,
              1
      from    ff_contexts FFC
      where   context_name = p_context_name1;

Line: 130

      INSERT INTO ff_route_context_usages
             (route_id,
              context_id,
              sequence_no)
      select  l_route_id,
              FFC.context_id,
              2
      from    ff_contexts FFC
      where   context_name = p_context_name2;

Line: 144

      INSERT INTO ff_route_context_usages
             (route_id,
              context_id,
              sequence_no)
      select  l_route_id,
              FFC.context_id,
              3
      from    ff_contexts FFC
      where   context_name = p_context_name3;

Line: 158

      INSERT INTO ff_route_context_usages
             (route_id,
              context_id,
              sequence_no)
      select  l_route_id,
              FFC.context_id,
              4
      from    ff_contexts FFC
      where   context_name = p_context_name4;

Line: 174

       INSERT INTO ff_route_parameters
         (route_parameter_id,
          route_id,
          sequence_no,
          parameter_name,
          data_type)
       VALUES
         (ff_route_parameters_s.nextval,
          l_route_id,
          1,
          p_param_name1,
          p_param_type1);

Line: 191

       INSERT INTO ff_route_parameters
         (route_parameter_id,
          route_id,
          sequence_no,
          parameter_name,
          data_type)
       VALUES
         (ff_route_parameters_s.nextval,
          l_route_id,
          1,
          p_param_name2,
          p_param_type2);

Line: 212

    SELECT user_entity_id
    INTO   l_user_entity_id
    FROM   ff_user_entities
    WHERE  user_entity_name = upper(p_user_entity_name);

Line: 221

    hrdyndbi.insert_user_entity (
                p_route_name =>         upper(p_route_name),
                p_user_entity_name  =>  p_user_entity_name,
                p_entity_description => p_user_entity_description,
                p_not_found_flag =>     'Y',
                p_creator_type =>       'SEH',
                p_creator_id =>         0,
                p_business_group_id =>  NULL,
                p_legislation_code =>   p_legislation_code,
                p_created_by =>         0,
                p_last_login =>         0,
                p_record_inserted =>	l_record_inserted);

Line: 234

    SELECT user_entity_id
    INTO   l_user_entity_id
    FROM   ff_user_entities
    WHERE  user_entity_name = p_user_entity_name;

Line: 241

    IF p_param_value1 is not null AND l_record_inserted THEN
--
      INSERT into ff_route_parameter_values
        (route_parameter_id,
         user_entity_id,
         value)
      SELECT route_parameter_id,
             l_user_entity_id,
             p_param_value1
      FROM   ff_route_parameters
      where  route_id = l_route_id
      and    sequence_no = 1;

Line: 256

    IF p_param_value2 is not null AND l_record_inserted THEN
--
      INSERT into ff_route_parameter_values
        (route_parameter_id,
         user_entity_id,
         value)
      SELECT route_parameter_id,
             l_user_entity_id,
             p_param_value2
      FROM   ff_route_parameters
      where  route_id = l_route_id
      and    sequence_no = 2;

Line: 276

  insert into ff_database_items (
          user_name,
          user_entity_id,
          data_type,
          definition_text,
          null_allowed_flag,
          description,
          last_update_date,
          last_updated_by,
          last_update_login,
          created_by,
          creation_date)
  --
  values (p_name,
          l_user_entity_id,
          p_data_type,
          p_definition_text,
          p_null_allowed,
          p_description,
          sysdate,
          0,
          0,
          0,
          sysdate);