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.PQP_GENERIC_EIT_SS SQL Statements

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

Line: 27


SELECT pvrei.object_version_number
  FROM pqp_veh_repos_extra_info pvrei
 WHERE pvrei.veh_repos_extra_info_id = p_extra_info_id
   AND pvrei.vehicle_repository_id=p_key_id;

Line: 34


SELECT pvaei.object_version_number
  FROM pqp_veh_alloc_extra_info pvaei
 WHERE pvaei.veh_alloc_extra_info_id = p_extra_info_id
   AND pvaei.vehicle_allocation_id=p_key_id;

Line: 56


PROCEDURE clear_delete_trans (p_item_type           in     varchar2,
                              p_item_key            in     varchar2,
                              p_transaction_step_id in     number
                             )
IS
BEGIN
 DELETE from hr_api_transaction_values
  WHERE transaction_step_id = p_transaction_step_id;

Line: 65


  DELETE from hr_api_transaction_steps
   WHERE transaction_step_id = p_transaction_step_id;

Line: 156


l_update                   NUMBER;

Line: 157


l_update_override          NUMBER;

Line: 158


l_update_change_insert     NUMBER;

Line: 293


  ELSIF p_action = 'UPDATE_ROW' THEN
   IF p_eit_type= 'REPOSITORY' THEN
    l_object_version_number:=get_ovn
           ( p_eit_type      => p_eit_type
            ,p_extra_info_id => p_extra_info_id
            ,p_key_id        => p_eit_type_id
           );

Line: 301


    pqp_veh_repos_extra_info_api.update_veh_repos_extra_info
    (p_validate                     => false
    ,p_veh_repos_extra_info_id      => p_extra_info_id
    ,p_object_version_number        => l_object_version_number
    ,p_vehicle_repository_id        => p_eit_type_id
    ,p_information_type             => p_information_type
    ,p_vrei_attribute_category      => p_attribute_category
    ,p_vrei_attribute1              => p_attribute1
    ,p_vrei_attribute2              => p_attribute2
    ,p_vrei_attribute3              => p_attribute3
    ,p_vrei_attribute4              => p_attribute4
    ,p_vrei_attribute5              => p_attribute5
    ,p_vrei_attribute6              => p_attribute6
    ,p_vrei_attribute7              => p_attribute7
    ,p_vrei_attribute8              => p_attribute8
    ,p_vrei_attribute9              => p_attribute9
    ,p_vrei_attribute10             => p_attribute10
    ,p_vrei_attribute11             => p_attribute11
    ,p_vrei_attribute12             => p_attribute12
    ,p_vrei_attribute13             => p_attribute13
    ,p_vrei_attribute14             => p_attribute14
    ,p_vrei_attribute15             => p_attribute15
    ,p_vrei_attribute16             => p_attribute16
    ,p_vrei_attribute17             => p_attribute17
    ,p_vrei_attribute18             => p_attribute18
    ,p_vrei_attribute19             => p_attribute19
    ,p_vrei_attribute20             => p_attribute20
    ,p_vrei_information_category    => p_information_category
    ,p_vrei_information1            => p_information1
    ,p_vrei_information2            => p_information2
    ,p_vrei_information3            => p_information3
    ,p_vrei_information4            => p_information4
    ,p_vrei_information5            => p_information5
    ,p_vrei_information6            => p_information6
    ,p_vrei_information7            => p_information7
    ,p_vrei_information8            => p_information8
    ,p_vrei_information9            => p_information9
    ,p_vrei_information10           => p_information10
    ,p_vrei_information11           => p_information11
    ,p_vrei_information12           => p_information12
    ,p_vrei_information13           => p_information13
    ,p_vrei_information14           => p_information14
    ,p_vrei_information15           => p_information15
    ,p_vrei_information16           => p_information16
    ,p_vrei_information17           => p_information17
    ,p_vrei_information18           => p_information18
    ,p_vrei_information19           => p_information19
    ,p_vrei_information20           => p_information20
    ,p_vrei_information21           => p_information21
    ,p_vrei_information22           => p_information22
    ,p_vrei_information23           => p_information23
    ,p_vrei_information24           => p_information24
    ,p_vrei_information25           => p_information25
    ,p_vrei_information26           => p_information26
    ,p_vrei_information27           => p_information27
    ,p_vrei_information28           => p_information28
    ,p_vrei_information29           => p_information29
    ,p_vrei_information30           => p_information30
    );

Line: 367


    pqp_veh_alloc_extra_info_api.update_veh_alloc_extra_info
    (p_validate                     => false
    ,p_veh_alloc_extra_info_id      => p_extra_info_id
    ,p_object_version_number        => l_object_version_number
    ,p_vehicle_allocation_id        => p_eit_type_id
    ,p_information_type             => p_information_type
    ,p_vaei_attribute_category      => p_attribute_category
    ,p_vaei_attribute1              => p_attribute1
    ,p_vaei_attribute2              => p_attribute2
    ,p_vaei_attribute3              => p_attribute3
    ,p_vaei_attribute4              => p_attribute4
    ,p_vaei_attribute5              => p_attribute5
    ,p_vaei_attribute6              => p_attribute6
    ,p_vaei_attribute7              => p_attribute7
    ,p_vaei_attribute8              => p_attribute8
    ,p_vaei_attribute9              => p_attribute9
    ,p_vaei_attribute10             => p_attribute10
    ,p_vaei_attribute11             => p_attribute11
    ,p_vaei_attribute12             => p_attribute12
    ,p_vaei_attribute13             => p_attribute13
    ,p_vaei_attribute14             => p_attribute14
    ,p_vaei_attribute15             => p_attribute15
    ,p_vaei_attribute16             => p_attribute16
    ,p_vaei_attribute17             => p_attribute17
    ,p_vaei_attribute18             => p_attribute18
    ,p_vaei_attribute19             => p_attribute19
    ,p_vaei_attribute20             => p_attribute20
    ,p_vaei_information_category    => p_information_category
    ,p_vaei_information1            => p_information1
    ,p_vaei_information2            => p_information2
    ,p_vaei_information3            => p_information3
    ,p_vaei_information4            => p_information4
    ,p_vaei_information5            => p_information5
    ,p_vaei_information6            => p_information6
    ,p_vaei_information7            => p_information7
    ,p_vaei_information8            => p_information8
    ,p_vaei_information9            => p_information9
    ,p_vaei_information10           => p_information10
    ,p_vaei_information11           => p_information11
    ,p_vaei_information12           => p_information12
    ,p_vaei_information13           => p_information13
    ,p_vaei_information14           => p_information14
    ,p_vaei_information15           => p_information15
    ,p_vaei_information16           => p_information16
    ,p_vaei_information17           => p_information17
    ,p_vaei_information18           => p_information18
    ,p_vaei_information19           => p_information19
    ,p_vaei_information20           => p_information20
    ,p_vaei_information21           => p_information21
    ,p_vaei_information22           => p_information22
    ,p_vaei_information23           => p_information23
    ,p_vaei_information24           => p_information24
    ,p_vaei_information25           => p_information25
    ,p_vaei_information26           => p_information26
    ,p_vaei_information27           => p_information27
    ,p_vaei_information28           => p_information28
    ,p_vaei_information29           => p_information29
    ,p_vaei_information30           => p_information30
    );

Line: 427


  ELSIF p_action= 'DELETE_ROW' THEN

   IF  p_eit_type='REPOSITORY' THEN
    l_object_version_number:=get_ovn
           ( p_eit_type      => p_eit_type
            ,p_extra_info_id => p_extra_info_id
            ,p_key_id        => p_eit_type_id
           );

Line: 435


    pqp_veh_repos_extra_info_api.delete_veh_repos_extra_info
    (p_validate                     => false
    ,p_veh_repos_extra_info_id      => p_extra_info_id
    ,p_object_version_number        => l_object_version_number
    );

Line: 447


    pqp_veh_alloc_extra_info_api.delete_veh_alloc_extra_info
    (p_validate                     => false
    ,p_veh_alloc_extra_info_id      => p_extra_info_id
    ,p_object_version_number        => l_object_version_number
    );

Line: 920


              ,p_selected_person_id             =>p_person_id
              ,p_item_type                      =>p_item_type
              ,p_item_key                       =>p_item_key
              ,p_transaction_effective_date     =>p_effective_date
              ,p_process_name                   =>NULL
              ,p_plan_id                        =>NULL
              ,p_rptg_grp_id                    =>NULL
              ,p_effective_date_option          =>p_effective_date
              ,p_transaction_id                 => l_transaction_id
              );

Line: 953


   hr_transaction_api.update_transaction
                      (p_transaction_id        =>l_transaction_id
                      ,p_status                =>p_status
                      );

Line: 957


   DELETE from hr_api_transaction_values
    WHERE transaction_step_id = p_transaction_step_id;

Line: 1518


  hr_transaction_ss.delete_transaction_steps(
    p_item_type           => p_item_type
    ,p_item_key           => p_item_key
    ,p_actid              => p_activity_id
    ,p_login_person_id    => p_login_person_id
  );

Line: 1556


SELECT hats.item_type,hats.item_key
  FROM hr_api_transaction_steps hats
 WHERE  hats.transaction_step_id =p_transaction_step_id;

Line: 1561


SELECT pvr.vehicle_repository_id
       ,pva.vehicle_allocation_id
  FROM pqp_vehicle_repository_f pvr
       ,pqp_vehicle_allocations_f pva
 WHERE pvr.vehicle_repository_id =pva.vehicle_repository_id
   AND pva.assignment_id =l_assignment_id
   AND NVL(l_effective_date,SYSDATE) BETWEEN pvr.effective_start_date
                            AND pvr.effective_end_date
   AND NVL(l_effective_date,sysdate) BETWEEN pva.effective_start_date
                            AND pva.effective_end_date
                            AND pvr.registration_number=l_key_id;

Line: 1576


  hr_util_misc_web.insert_session_row(to_date(p_effective_date, 'RRRR-MM-DD'));

Line: 1578


  hr_util_misc_web.insert_session_row(SYSDATE);