eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KR_ENTRIES_PKG SQL Statements

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

Line: 45


  select decode( substr( p_national_identifier, 8, 1 ),
                 '1', '19', '2', '19',
                 '3', '20', '4', '20',
                 '5', '19', '6', '19',
                 '7', '20', '8', '20',
                 '9', '18', '0', '18', '19' )
         || substr( p_national_identifier, 1, 6 )
  into l_date
  from sys.dual;

Line: 108


select *
from   pay_element_types_f pet
where  pet.element_name = p_element_name
and    p_effective_date between pet.effective_start_date
                            and pet.effective_end_date
and    ( pet.legislation_code = p_legislation_code
      or pet.business_group_id = p_business_group_id);

Line: 157


select piv.input_value_id,
       piv.display_sequence,
       piv.uom,
       piv.mandatory_flag
from   pay_input_values_f piv
where  piv.element_type_id = p_element_type_id
and    p_effective_date between piv.effective_start_date
                            and piv.effective_end_date;

Line: 280


  p_dt_update_mode        in     varchar2,
  p_dt_delete_mode        in     varchar2
)
is
begin
  hr_entry.chk_element_entry(
    p_element_entry_id      => p_element_entry_id,
    p_original_entry_id     => p_original_entry_id,
    p_session_date          => p_effective_date,
    p_element_link_id       => p_element_link_id,
    p_assignment_id         => p_assignment_id,
    p_entry_type            => p_entry_type,
    p_effective_start_date  => p_effective_start_date,
    p_effective_end_date    => p_effective_end_date,
    p_validation_start_date => p_validation_start_date,
    p_validation_end_date   => p_validation_end_date,
    p_dt_update_mode        => p_dt_update_mode,
    p_dt_delete_mode        => p_dt_delete_mode,
    p_usage                 => p_usage,
    p_target_entry_id       => p_target_entry_id
  );

Line: 330


select piv.input_value_id,
       piv.display_sequence,
       decode(piv.hot_default_flag,
         'Y',nvl(pliv.default_value,piv.default_value),
         pliv.default_value)  DEFAULT_VALUE,
       decode(piv.lookup_type,NULL,NULL,
         hr_general.decode_lookup(
           piv.lookup_type,
           decode(piv.hot_default_flag,
           'Y',nvl(pliv.default_value,piv.default_value),
           pliv.default_value)))  D_DEFAULT_VALUE
from  pay_input_values_f      piv,
      pay_link_input_values_f pliv
where pliv.element_link_id = p_element_link_id
and   p_effective_date between pliv.effective_start_date
                           and pliv.effective_end_date
and   piv.input_value_id = pliv.input_value_id
and   p_effective_date between piv.effective_start_date
                           and piv.effective_end_date
order by piv.display_sequence;

Line: 387


    p_usage                 => 'INSERT',
    p_dt_update_mode        => NULL,
    p_dt_delete_mode        => NULL);

Line: 427


select item_name                                            NAME,
       decode(data_type,'T','TEXT','N','NUMBER','D','DATE') DATATYPE,
       decode(usage,'U','CONTEXT','INPUT')                  CLASS
from   ff_fdi_usages_f
where  formula_id = p_formula_id
and    p_date_earned between effective_start_date
                         and effective_end_date;

Line: 515


select pivtl.name,
       piv.uom,
       piv.mandatory_flag,
       piv.hot_default_flag,
       piv.lookup_type,
       decode(piv.hot_default_flag,
          'Y',nvl(pliv.default_value,piv.default_value),
          pliv.default_value)  DEFAULT_VALUE,
       decode(piv.hot_default_flag,
          'Y',nvl(pliv.min_value,piv.min_value),
          pliv.min_value)    MIN_VALUE,
       decode(piv.hot_default_flag,
          'Y',nvl(pliv.max_value,piv.max_value),
          pliv.max_value)    MAX_VALUE,
       piv.formula_id,
       decode(piv.hot_default_flag,
          'Y',nvl(pliv.warning_or_error,piv.warning_or_error),
          pliv.warning_or_error)  WARNING_OR_ERROR,
       pet.input_currency_code
from   pay_element_types_f     pet,
       pay_input_values_f_tl   pivtl,
       pay_input_values_f      piv,
       pay_link_input_values_f pliv
where  pliv.element_link_id = p_element_link_id
and    pliv.input_value_id = p_input_value_id
and    p_effective_date between pliv.effective_start_date
                            and pliv.effective_end_date
and    piv.input_value_id = pliv.input_value_id
and    p_effective_date between piv.effective_start_date
                            and piv.effective_end_date
and    pivtl.input_value_id = piv.input_value_id
and    pivtl.language = userenv('LANG')
and    pet.element_type_id = piv.element_type_id
and    p_effective_date between pet.effective_start_date
                            and pet.effective_end_date;

Line: 759


  p_update               out NOCOPY boolean,
  p_update_override      out NOCOPY boolean,
  p_update_change_insert out NOCOPY boolean
)
is

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

Line: 770


select pee.entry_type,
       pet.processing_type
from   pay_element_types_f    pet,
       pay_element_links_f    pel,
       pay_element_entries_f  pee
where  pee.element_entry_id = p_base_key_value
and    p_effective_date between pee.effective_start_date
                            and pee.effective_end_date
and    pel.element_link_id = pee.element_link_id
and    p_effective_date between pel.effective_start_date
                            and pel.effective_end_date
and    pet.element_type_id = pel.element_type_id
and    p_effective_date between pet.effective_start_date
                            and pet.effective_end_date;

Line: 805


    p_update               := false;

Line: 806


    p_update_override      := false;

Line: 807


    p_update_change_insert := false;

Line: 818


      p_update               => p_update,
      p_update_override      => p_update_override,
      p_update_change_insert => p_update_change_insert
    );

Line: 843


  p_delete             out NOCOPY boolean,
  p_future_change      out NOCOPY boolean,
  p_delete_next_change out NOCOPY boolean
)
is

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

Line: 856


select pee.assignment_id,
       pee.element_link_id,
       pee.entry_type,
       pet.processing_type
from   pay_element_types_f    pet,
       pay_element_links_f    pel,
       pay_element_entries_f  pee
where  pee.element_entry_id = p_base_key_value
and    p_effective_date between pee.effective_start_date
                            and pee.effective_end_date
and    pel.element_link_id = pee.element_link_id
and    p_effective_date between pel.effective_start_date
                            and pel.effective_end_date
and    pet.element_type_id = pel.element_type_id
and    p_effective_date between pet.effective_start_date
                            and pet.effective_end_date;

Line: 896


    p_delete             := false;

Line: 898


    p_delete_next_change := false;

Line: 915


      p_delete             => p_delete,
      p_future_change      => p_future_change,
      p_delete_next_change => p_delete_next_change
    );

Line: 1015


select *
from   pay_element_entries_f
where  element_entry_id = p_element_entry_id
and    p_effective_date between effective_start_date
                            and effective_end_date
for update nowait;

Line: 1047


  If (p_datetrack_mode <> 'INSERT') then
    --
    -- We must select and lock the current row.
    --
    open  c_sel1;

Line: 1238


  p_datetrack_update_mode in            varchar2,
  p_element_entry_id      in            number,
  p_object_version_number in out NOCOPY number,
  p_ev_rec_tbl            in            ev_rec_tbl,
  p_business_group_id     in            number,
  p_effective_start_date  out NOCOPY    date,
  p_effective_end_date    out NOCOPY    date
)
is
l_warning    boolean;

Line: 1251


  py_element_entry_api.update_element_entry(
    P_VALIDATE              => p_validate,
    P_DATETRACK_UPDATE_MODE => p_datetrack_update_mode,
    P_EFFECTIVE_DATE        => p_effective_date,
    P_BUSINESS_GROUP_ID     => p_business_group_id,
    P_ELEMENT_ENTRY_ID      => p_element_entry_id,
    P_OBJECT_VERSION_NUMBER => p_object_version_number,
    P_INPUT_VALUE_ID1       => l_ev_rec_tbl(1).input_value_id,
    P_INPUT_VALUE_ID2       => l_ev_rec_tbl(2).input_value_id,
    P_INPUT_VALUE_ID3       => l_ev_rec_tbl(3).input_value_id,
    P_INPUT_VALUE_ID4       => l_ev_rec_tbl(4).input_value_id,
    P_INPUT_VALUE_ID5       => l_ev_rec_tbl(5).input_value_id,
    P_INPUT_VALUE_ID6       => l_ev_rec_tbl(6).input_value_id,
    P_INPUT_VALUE_ID7       => l_ev_rec_tbl(7).input_value_id,
    P_INPUT_VALUE_ID8       => l_ev_rec_tbl(8).input_value_id,
    P_INPUT_VALUE_ID9       => l_ev_rec_tbl(9).input_value_id,
    P_INPUT_VALUE_ID10      => l_ev_rec_tbl(10).input_value_id,
    P_INPUT_VALUE_ID11      => l_ev_rec_tbl(11).input_value_id,
    P_INPUT_VALUE_ID12      => l_ev_rec_tbl(12).input_value_id,
    P_INPUT_VALUE_ID13      => l_ev_rec_tbl(13).input_value_id,
    P_INPUT_VALUE_ID14      => l_ev_rec_tbl(14).input_value_id,
    P_INPUT_VALUE_ID15      => l_ev_rec_tbl(15).input_value_id,
    P_ENTRY_VALUE1          => l_ev_rec_tbl(1).entry_value,
    P_ENTRY_VALUE2          => l_ev_rec_tbl(2).entry_value,
    P_ENTRY_VALUE3          => l_ev_rec_tbl(3).entry_value,
    P_ENTRY_VALUE4          => l_ev_rec_tbl(4).entry_value,
    P_ENTRY_VALUE5          => l_ev_rec_tbl(5).entry_value,
    P_ENTRY_VALUE6          => l_ev_rec_tbl(6).entry_value,
    P_ENTRY_VALUE7          => l_ev_rec_tbl(7).entry_value,
    P_ENTRY_VALUE8          => l_ev_rec_tbl(8).entry_value,
    P_ENTRY_VALUE9          => l_ev_rec_tbl(9).entry_value,
    P_ENTRY_VALUE10         => l_ev_rec_tbl(10).entry_value,
    P_ENTRY_VALUE11         => l_ev_rec_tbl(11).entry_value,
    P_ENTRY_VALUE12         => l_ev_rec_tbl(12).entry_value,
    P_ENTRY_VALUE13         => l_ev_rec_tbl(13).entry_value,
    P_ENTRY_VALUE14         => l_ev_rec_tbl(14).entry_value,
    P_ENTRY_VALUE15         => l_ev_rec_tbl(15).entry_value,
    P_EFFECTIVE_START_DATE  => p_effective_start_date,
    P_EFFECTIVE_END_DATE    => p_effective_end_date,
    P_UPDATE_WARNING        => l_warning
  );

Line: 1304


  p_datetrack_delete_mode in            varchar2,
  p_element_entry_id      in            number,
  p_object_version_number in out NOCOPY number,
  p_effective_start_date  out    NOCOPY date,
  p_effective_end_date    out    NOCOPY date
)
is
  l_warning BOOLEAN;

Line: 1313


  py_element_entry_api.delete_element_entry(
    P_VALIDATE              => p_validate,
    P_DATETRACK_DELETE_MODE => p_datetrack_delete_mode,
    P_EFFECTIVE_DATE        => p_effective_date,
    P_ELEMENT_ENTRY_ID      => p_element_entry_id,
    P_OBJECT_VERSION_NUMBER => p_object_version_number,
    P_EFFECTIVE_START_DATE  => p_effective_start_date,
    P_EFFECTIVE_END_DATE    => p_effective_end_date,
    P_DELETE_WARNING        => l_warning
  );

Line: 1356


  hr_contact_rel_api.update_contact_relationship
  (p_validate                   => p_validate
  ,p_effective_date             => p_effective_date
  ,p_contact_relationship_id    => p_contact_relationship_id
  ,p_object_version_number      => p_object_version_number
  ,p_cont_information2          => p_cont_information2
  ,p_cont_information3          => p_cont_information3
  ,p_cont_information4          => p_cont_information4
  ,p_cont_information5          => p_cont_information5
  ,p_cont_information7          => p_cont_information7
  ,p_cont_information8          => p_cont_information8
  ,p_cont_information10         => p_cont_information10
  ,p_cont_information12         => p_cont_information12
  ,p_cont_information13         => p_cont_information13
  ,p_cont_information14         => p_cont_information14
  );

Line: 1425


  hr_contact_extra_info_api.update_contact_extra_info
      ( p_effective_date          => p_effective_date,
        p_datetrack_update_mode   => 'CORRECTION',
        p_contact_extra_info_id   => p_contact_extra_info_id,
        p_contact_relationship_id => p_contact_relationship_id,
        p_object_version_number   => p_contact_ovn,
        p_information_type        => 'KR_DPNT_EXPENSE_INFO',
        p_cei_information1        => p_cei_information1,
        p_cei_information2        => p_cei_information2,
        p_cei_information3        => p_cei_information3,
        p_cei_information4        => p_cei_information4,
        p_cei_information5        => p_cei_information5,
        p_cei_information6        => p_cei_information6,
        p_cei_information7        => p_cei_information7,
        p_cei_information8        => p_cei_information8,
        p_cei_information9        => p_cei_information9,
        p_cei_information10       => p_cei_information10, -- Bug 5667762
        p_cei_information11       => p_cei_information11,
        p_cei_information12       => p_cei_information12, -- Bug 6630135
        p_cei_information13       => p_cei_information13, -- Bug 6705170
        p_cei_information14       => p_cei_information14, -- Bug 7142612
        p_cei_information15       => p_cei_information15, -- Bug 7142612
        p_cei_information16       => p_cei_information16, -- Bug 9737699
        p_cei_information17       => p_cei_information17, -- Bug 9737699
       p_cei_information18        => p_cei_information18, -- Bug 14219478
       p_cei_information19         => p_cei_information19, -- Bug 14219478
       p_cei_information20         => p_cei_information20, -- Bug 14219478
       p_cei_information21         => p_cei_information21, -- Bug 14219478
       p_cei_information22         => p_cei_information22, -- Bug 14502155
       p_cei_information23         => p_cei_information23, -- Bug 14502155
       p_cei_information24         => p_cei_information24, -- Bug 14502155
        p_effective_start_date    => p_cei_effective_start_date,
        p_effective_end_date      => p_cei_effective_end_date
      );