APPS.PAY_ARCHIVE_UTILS SQL Statements

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

Line: 13

   select context_id
   from   ff_contexts
   where context_name = c_context_name;

Line: 47

   select route_id from ff_routes
   where route_name = 'ARCHIVE_NUMBER_ROUTE';

Line: 65

         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,
            'ARCHIVE_NUMBER_ROUTE',
            'N',
            'Generic number archive route',
            l_text,
            sysdate,
            0,
            0,
            0,
            sysdate
         );

Line: 93

         insert into ff_route_parameters
         (
            route_parameter_id,
            route_id,
            data_type,
            parameter_name,
            sequence_no
         )
         select
            ff_route_parameters_s.nextval,
            ff_routes_s.currval,
            'N',
            'User Entity ID',
            1
         from dual;

Line: 113

         insert into ff_route_context_usages
         (
            route_id,
            context_id,
            sequence_no
         )
         select
            ff_routes_s.currval,
            l_assignment_action_context_id,
            1
         from dual;

Line: 127

         select ff_routes_s.currval into l_route_id from dual;

Line: 149

   select route_id from ff_routes
   where route_name = 'ARCHIVE_CHAR_ROUTE';

Line: 167

         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,
            'ARCHIVE_CHAR_ROUTE',
            'N',
            'Generic character archive route',
            l_text,
            sysdate,
            0,
            0,
            0,
            sysdate
         );

Line: 195

         insert into ff_route_parameters
         (
            route_parameter_id,
            route_id,
            data_type,
            parameter_name,
            sequence_no
         )
         select
            ff_route_parameters_s.nextval,
            ff_routes_s.currval,
            'N',
            'User Entity ID',
            1
         from dual;

Line: 216

         insert into ff_route_context_usages
         (
            route_id,
            context_id,
            sequence_no
         )
         select
            ff_routes_s.currval,
            l_assignment_action_context_id,
            1
         from dual;

Line: 230

      select ff_routes_s.currval into l_route_id from dual;

Line: 258

   select route_id from ff_routes
   where route_name = c_route_name;

Line: 285

      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,
         l_new_route_name,
         'N',
         'Two Context Generic archive route',
         l_text,
         sysdate,
         0,
         0,
         0,
         sysdate
      );

Line: 313

      insert into ff_route_parameters
      (
         route_parameter_id,
         route_id,
         data_type,
         parameter_name,
         sequence_no
      )
      select
         ff_route_parameters_s.nextval,
         ff_routes_s.currval,
         'N',
         'User Entity ID',
         1
      from dual;

Line: 334

      insert into ff_route_context_usages
      (
         route_id,
         context_id,
         sequence_no
      )
      select
         ff_routes_s.currval,
         l_assignment_action_context_id,
         1
      from dual;

Line: 350

      insert into ff_route_context_usages
      (
         route_id,
         context_id,
         sequence_no
      )
      select
         ff_routes_s.currval,
         l_second_context_id,
         2
      from dual;

Line: 364

      select ff_routes_s.currval into l_route_id from dual;

Line: 419

      select
         ue.notfound_allowed_flag,
         ue.creator_type,
         ue.entity_description,
         ue.route_id,
         ue.legislation_code,
         ue.business_group_id,
         dbi.null_allowed_flag,
         dbi.description ,
         dbi.data_type,
         dbi.user_name
      into
         l_ue_notfound_allowed_flag,
         l_ue_creator_type,
         l_ue_entity_description,
         l_live_route_id,
         l_ue_legislation_code,
         l_ue_business_group_id,
         l_dbi_null_allowed_flag,
         l_dbi_description,
         l_dbi_data_type,
         l_dbi_user_name
      from
         ff_database_items dbi,
         ff_user_entities  ue
      where dbi.user_name = p_live_dbi_name
      and   dbi.user_entity_id = ue.user_entity_id
      and   ue.business_group_id is null;

Line: 504

         select route_id
         into l_route_id
         from ff_routes where
         route_name = p_archive_route_name;

Line: 515

   select route_parameter_id
   into   l_route_parameter_id
   from   ff_route_parameters
   where  parameter_name = 'User Entity ID'
   and    route_id = l_route_id;

Line: 528

      select user_entity_id
      into   l_user_entity_seq
      from   ff_user_entities
      where  user_entity_name = l_archive_dbi_name
      and    business_group_id is null;

Line: 546

         select route_parameter_id
         into   l_dummy_id
         from   ff_route_parameter_values
         where  route_parameter_id = l_route_parameter_id
         and    user_entity_id = l_user_entity_seq;

Line: 552

         update ff_route_parameter_values
         set    value = l_user_entity_seq
         where  route_parameter_id = l_route_parameter_id
         and    user_entity_id = l_user_entity_seq;

Line: 561

         insert into ff_route_parameter_values
         (
            route_parameter_id,
            user_entity_id,
            value,
            last_update_date,
            last_updated_by,
            last_update_login,
            created_by,
            creation_date
         )
         values
         (
            l_route_parameter_id,
            l_user_entity_seq,
            l_user_entity_seq,
            sysdate,
            0,
            0,
            0,
            sysdate
         );

Line: 586

      update ff_database_items
      set    user_entity_id = l_user_entity_seq,
             data_type = l_dbi_data_type,
             definition_text = l_definition_text,
             null_allowed_flag = 'Y',   -- l_dbi_null_allowed_flag,
             description = substr('Archive of ' || l_dbi_description, 1, 240)
      where  user_name = l_archive_dbi_name;

Line: 599

      select ff_user_entities_s.nextval into l_user_entity_seq from dual;

Line: 601

      insert into ff_user_entities
      (
         user_entity_id,
         business_group_id,
         legislation_code,
         route_id,
         notfound_allowed_flag,
         user_entity_name,
         creator_id,
         creator_type,
         entity_description,
         last_update_date,
         last_updated_by,
         last_update_login,
         created_by,
         creation_date
      )
      values
      (
         l_user_entity_seq,                     /* user_entity_id */
         null,
         --l_ue_business_group_id,                /* business_group_id */
         l_ue_legislation_code,                 /* legislation_code */
         l_route_id,                            /* route_id */
         'Y',
--         l_ue_notfound_allowed_flag,          /* notfound_allowed_flag */
         l_archive_dbi_name,                    /* user_entity_name */
         0,                                     /* creator_id */
         'X',                                   /* archive extract creator_type */
         substr('Archive of ' || l_ue_entity_description, 1, 240),   /* entity_description */
         sysdate,                               /* last_update_date */
         0,                                     /* last_updated_by */
         0,                                     /* last_update_login */
         0,                                     /* created_by */
         sysdate                                /* creation_date */
      );

Line: 638

      insert into ff_route_parameter_values
      (
         route_parameter_id,
         user_entity_id,
         value,
         last_update_date,
         last_updated_by,
         last_update_login,
         created_by,
         creation_date
      )
      values
      (
         l_route_parameter_id,
         l_user_entity_seq,
         l_user_entity_seq,
         sysdate,
         0,
         0,
         0,
         sysdate
      );

Line: 661

      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
      (
         l_archive_dbi_name,
         l_user_entity_seq,
         l_dbi_data_type,
         l_definition_text,
         'Y',
--         l_dbi_null_allowed_flag,
         substr('Archive of item ' || l_dbi_description, 1, 240),
         sysdate,
         0,
         0,
         0,
         sysdate
      );

Line: 711

  select route_id
  from ff_routes
  where route_id = c_route_id;

Line: 716

  select user_entity_id
  from ff_user_entities
  where user_entity_name = c_user_entity_name;

Line: 721

  select route_parameter_id
  from ff_route_parameters
  where parameter_name = 'User Entity ID'
  and route_id = c_route_id;

Line: 773

     select ff_user_entities_s.nextval into l_user_entity_id from dual;

Line: 775

      insert into ff_user_entities
      (
         user_entity_id,
         business_group_id,
         legislation_code,
         route_id,
         notfound_allowed_flag,
         user_entity_name,
         creator_id,
         creator_type,
         entity_description,
         last_update_date,
         last_updated_by,
         last_update_login,
         created_by,
         creation_date
      )
      values
      (
         l_user_entity_id,
         null,
         p_legislation_code,
         p_route_id,
         p_notfound_allowed_flag,
         p_extract_item_name,
         0,
         'X',  -- SUBJECT TO CHECKING
         l_description,
         sysdate,
         0,
         0,
         0,
         sysdate
      );

Line: 810

      insert into ff_route_parameter_values
      (
         route_parameter_id,
         user_entity_id,
         value,
         last_update_date,
         last_updated_by,
         last_update_login,
         created_by,
         creation_date
      )
      values
      (
         l_route_parameter_id,
         l_user_entity_id,
         l_user_entity_id,
         sysdate,
         0,
         0,
         0,
         sysdate
      );

Line: 833

     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_extract_item_name,
         l_user_entity_id,
         p_data_type,
         l_definition_text,
         p_null_allowed_flag,
         l_description,
         sysdate,
         0,
         0,
         0,
         sysdate
      );