APPS.FF_ARCHIVE_API SQL Statements

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

Line: 166

  select plc.context_id
  from pay_legislation_contexts plc
  where plc.legislation_name = c_context_name
  and plc.legislation_code = c_legislation_code;

Line: 172

  select ffc.context_id
  from ff_contexts ffc
  where ffc.context_name = c_context_name;

Line: 295

  select 1 from dual where exists
  (select prfi.archive_type
  from pay_report_format_items_f prfi
  where prfi.user_entity_id = c_user_entity_id);

Line: 519

procedure update_archive_item
  (p_archive_item_id               in     number
  ,p_effective_date                in     date
  ,p_validate                      in     boolean  default false
  ,p_archive_value                 in     varchar2
  ,p_object_version_number         in out nocopy number
  ,p_some_warning                     out nocopy boolean
  ) is
  --
  -- Declare cursors and local variables
  --
  l_archive_type varchar2(10);

Line: 542

  select user_entity_id,
         archive_type,
         context1
  from ff_archive_items
  where archive_item_id = c_archive_item_id;

Line: 549

  select ppa.report_type,
         ppa.report_qualifier,
         ppa.report_category
  from pay_payroll_actions ppa
  where ppa.payroll_action_id = c_payroll_action_id;

Line: 560

  select prfi.updatable_flag,
         prfi.archive_type
  from pay_report_format_items_f prfi
  where prfi.report_type = c_report_type
  and   prfi.report_qualifier = c_report_qualifier
  and   prfi.report_category = c_report_category
  and   prfi.user_entity_id = c_user_entity_id
  and   c_effective_date between
        prfi.effective_start_date and prfi.effective_end_date;

Line: 572

  select prfm.updatable_flag
  from pay_report_format_mappings_f prfm
  where prfm.report_type = c_report_type
  and   prfm.report_qualifier = c_report_qualifier
  and   prfm.report_category = c_report_category
  and   c_effective_date between
        prfm.effective_start_date and prfm.effective_end_date;

Line: 581

  select paa.assignment_action_id,
         paa.payroll_action_id
  from pay_assignment_actions paa
  where paa.assignment_action_id = c_context1;

Line: 587

  select locked_action_id
  from pay_action_interlocks
  where locked_action_id = c_assignment_action_id;

Line: 591

  l_proc                varchar2(72) := g_package||'update_archive_item';

Line: 594

  cannot_update_item    exception;

Line: 617

  savepoint update_archive_item;

Line: 672

     raise cannot_update_item;

Line: 684

     raise cannot_update_item;

Line: 694

     raise cannot_update_item;

Line: 738

  when cannot_update_item then
    --
    rollback to update_archive_item;

Line: 755

    rollback to update_archive_item;

Line: 765

    rollback to update_archive_item;

Line: 776

    rollback to update_archive_item;

Line: 788

   rollback to update_archive_item;

Line: 800

    rollback to update_archive_item;

Line: 809

end update_archive_item;