APPS.PAY_POPULATION_RANGES_PKG SQL Statements

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

Line: 24

   SELECT 1
   into   l_dummy
   FROM   SYS.DUAL
   WHERE  EXISTS (
          SELECT NULL
          FROM   PAY_ASSIGNMENT_ACTIONS ACT
          WHERE  ACT.PAYROLL_ACTION_ID = p_payroll_action_id)
   OR     EXISTS (
          SELECT NULL
          FROM   PAY_MESSAGE_LINES PML
          WHERE  PML.SOURCE_TYPE = 'P'
          AND    PML.SOURCE_ID   = p_payroll_action_id)
   OR     EXISTS (
          SELECT NULL
          FROM   PAY_POPULATION_RANGES POP
          WHERE  POP.PAYROLL_ACTION_ID = p_payroll_action_id);

Line: 321

  l_pay_act_tab.delete;

Line: 322

  l_chunk_num_tab.delete;

Line: 323

  l_rand_chunk_num_tab.delete;

Line: 333

    select (mod(fnd_crypto.SmallRandomNumber,p_chunk_number-1)+1)
    into rand_num
    from dual;

Line: 366

      update pay_population_ranges
         set rand_chunk_number = l_rand_chunk_num_tab(i)
       where payroll_action_id = l_pay_act_tab(i)
         and chunk_number = l_chunk_num_tab(i);

Line: 378

     insert_chunk_statii

     Create the rows in chunk status if needed
*/

procedure insert_chunk_statii(p_payroll_action_id in number)
is
begin
--
   pay_proc_logging.PY_ENTRY('pay_population_ranges_pkg.insert_chunk_statii');

Line: 389

   INSERT into PAY_CHUNK_STATUS
               (PAYROLL_ACTION_ID,
                CHUNK_NUMBER,
                RAND_CHUNK_NUMBER,
                POPULATION_STATUS,
                PROCESS_STATUS)
   SELECT DISTINCT p_payroll_action_id,
                   CHUNK_NUMBER,
                   nvl(RAND_CHUNK_NUMBER, CHUNK_NUMBER),
                   'U',
                   'U'
     FROM pay_population_ranges
    WHERE payroll_action_id = p_payroll_action_id;

Line: 403

    pay_proc_logging.PY_EXIT('pay_population_ranges_pkg.insert_chunk_statii');

Line: 405

end insert_chunk_statii;

Line: 408

      insert_ranges

      This is the procedure that actually inserts the ranges, then
      performs additional steps (randomisation etc).
*/

procedure insert_ranges(p_payroll_action_id in number,
                        p_statement         in varchar2)
is

type t_curs_ref is ref cursor;

Line: 450

    pay_proc_logging.PY_ENTRY('pay_population_ranges_pkg.insert_ranges');

Line: 458

                   l_pay_act_tab.delete;

Line: 459

                   l_strt_person_id_tab.delete;

Line: 460

                   l_end_person_id_tab.delete;

Line: 461

                   l_chunk_num_tab.delete;

Line: 462

                   l_rge_stat_tab.delete;

Line: 463

                   l_person_id_tab.delete;

Line: 464

                   l_source_id_tab.delete;

Line: 465

                   l_source_type_tab.delete;

Line: 500

               insert into pay_population_ranges (
                         payroll_action_id,
                         starting_person_id,
                         ending_person_id,
                         chunk_number,
                         range_status,
                         person_id,
                         source_id,
                         source_type)
               values (
                      l_pay_act_tab(i),
                      l_strt_person_id_tab(i),
                      l_end_person_id_tab(i),
                      l_chunk_num_tab(i),
                      l_rge_stat_tab(i),
                      l_person_id_tab(i),
                      l_source_id_tab(i),
                      l_source_type_tab(i));

Line: 521

            insert into pay_population_ranges (
                         payroll_action_id,
                         starting_person_id,
                         ending_person_id,
                         chunk_number,
                         range_status
                        )
               values (
                      p_payroll_action_id,
                      l_person_id_tab(1),
                      l_end_person_id,
                      chunk_number,
                      'U'
                      );

Line: 564

       insert_chunk_statii(p_payroll_action_id);

Line: 567

    pay_proc_logging.PY_EXIT('pay_population_ranges_pkg.insert_ranges');

Line: 569

end insert_ranges;

Line: 589

  pay_proc_environment_pkg.update_pop_action_status(
                           p_payroll_action_id,
                           APS_POP_RANGES );

Line: 599

  insert_ranges(p_payroll_action_id,
                l_statement);

Line: 602

  pay_proc_environment_pkg.update_pop_action_status(
                           p_payroll_action_id,
                           APS_POP_ACTIONS );

Line: 630

select payroll_action_id,
       nvl(rand_chunk_number, chunk_number)
  from pay_population_ranges
 where payroll_action_id = p_payroll_action_id
 and   range_status = 'E';

Line: 644

      l_pay_act_tab.delete;

Line: 645

      l_chunk_num_tab.delete;

Line: 652

        delete from pay_action_interlocks pai
           where pai.locking_action_id in
               (select aa.assignment_action_id
                from pay_assignment_actions aa
                where payroll_action_id = l_pay_act_tab(i)
                and   chunk_number      = l_chunk_num_tab(i));

Line: 660

           delete from pay_assignment_actions aa
           where aa.payroll_action_id = l_pay_act_tab(i)
           and   aa.chunk_number      = l_chunk_num_tab(i);

Line: 665

           delete from pay_temp_object_actions aa
           where aa.payroll_action_id = l_pay_act_tab(i)
           and   aa.chunk_number      = l_chunk_num_tab(i);

Line: 670

           update pay_population_ranges ppr
           set range_status = 'U'
           where ppr.payroll_action_id = l_pay_act_tab(i)
           and   ppr.chunk_number      = l_chunk_num_tab(i);

Line: 678

              update pay_chunk_status
              set population_status         = 'U'
              where payroll_action_id       = l_pay_act_tab(i)
              and   chunk_number = l_chunk_num_tab(i);

Line: 691

    pay_proc_environment_pkg.update_pop_action_status(
                           p_payroll_action_id,
                           APS_POP_ACTIONS );