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

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

Line: 32


PROCEDURE check_asg_extra_info_insert(
         p_assignment_id            IN NUMBER
        ,p_aei_information_category IN VARCHAR2
        ,p_aei_information1         IN VARCHAR2
        ,p_aei_information2         IN VARCHAR2
        ,p_aei_information3         IN VARCHAR2
        ,p_aei_information4         IN VARCHAR2
        ,p_aei_information5         IN VARCHAR2
        ,p_aei_information6         IN VARCHAR2
        ,p_aei_information7         IN VARCHAR2
        ,p_aei_information8         IN VARCHAR2
        ,p_aei_information9         IN VARCHAR2
        ,p_aei_information10        IN VARCHAR2
        ,p_aei_information11        IN VARCHAR2
        ,p_aei_information12        IN VARCHAR2
        ,p_aei_information13        IN VARCHAR2
        ,p_aei_information14        IN VARCHAR2
        ,p_aei_information15        IN VARCHAR2
        ,p_aei_information16        IN VARCHAR2
        ,p_aei_information17        IN VARCHAR2
        ,p_aei_information18        IN VARCHAR2
        ,p_aei_information19        IN VARCHAR2
        ,p_aei_information20        IN VARCHAR2
        ,p_aei_information21        IN VARCHAR2
        ,p_aei_information22        IN VARCHAR2
        ,p_aei_information23        IN VARCHAR2
        ,p_aei_information24        IN VARCHAR2
        ,p_aei_information25        IN VARCHAR2
        ,p_aei_information26        IN VARCHAR2
        ,p_aei_information27        IN VARCHAR2
        ,p_aei_information28        IN VARCHAR2
        ,p_aei_information29        IN VARCHAR2
        ,p_aei_information30        IN VARCHAR2
        ) IS

    l_procedure           VARCHAR2(100);

Line: 72


  l_procedure := g_package ||'check_asg_extra_info_insert';

Line: 131


END check_asg_extra_info_insert;

Line: 157


PROCEDURE check_asg_extra_info_update(
         p_assignment_extra_info_id IN NUMBER
        ,p_aei_information_category IN VARCHAR2
        ,p_aei_information1         IN VARCHAR2
        ,p_aei_information2         IN VARCHAR2
        ,p_aei_information3         IN VARCHAR2
        ,p_aei_information4         IN VARCHAR2
        ,p_aei_information5         IN VARCHAR2
        ,p_aei_information6         IN VARCHAR2
        ,p_aei_information7         IN VARCHAR2
        ,p_aei_information8         IN VARCHAR2
        ,p_aei_information9         IN VARCHAR2
        ,p_aei_information10        IN VARCHAR2
        ,p_aei_information11        IN VARCHAR2
        ,p_aei_information12        IN VARCHAR2
        ,p_aei_information13        IN VARCHAR2
        ,p_aei_information14        IN VARCHAR2
        ,p_aei_information15        IN VARCHAR2
        ,p_aei_information16        IN VARCHAR2
        ,p_aei_information17        IN VARCHAR2
        ,p_aei_information18        IN VARCHAR2
        ,p_aei_information19        IN VARCHAR2
        ,p_aei_information20        IN VARCHAR2
        ,p_aei_information21        IN VARCHAR2
        ,p_aei_information22        IN VARCHAR2
        ,p_aei_information23        IN VARCHAR2
        ,p_aei_information24        IN VARCHAR2
        ,p_aei_information25        IN VARCHAR2
        ,p_aei_information26        IN VARCHAR2
        ,p_aei_information27        IN VARCHAR2
        ,p_aei_information28        IN VARCHAR2
        ,p_aei_information29        IN VARCHAR2
        ,p_aei_information30        IN VARCHAR2
        ) IS


CURSOR get_assignment_id
IS
SELECT assignment_id
      ,aei_information1
      ,aei_information2
      ,aei_information3
      ,aei_information4
      ,aei_information5
      ,aei_information6
      ,aei_information7
      ,aei_information8
      ,aei_information9
      ,aei_information10
      ,aei_information11
      ,aei_information12
      ,aei_information13
      ,aei_information14
      ,aei_information15
      ,aei_information16
      ,aei_information17
      ,aei_information18
      ,aei_information19
      ,aei_information20
      ,aei_information21
      ,aei_information22
      ,aei_information23
      ,aei_information24
      ,aei_information25
      ,aei_information26
      ,aei_information27
      ,aei_information28
      ,aei_information29
      ,aei_information30
  FROM per_assignment_extra_info
 WHERE assignment_extra_info_id = p_assignment_extra_info_id;

Line: 265


  l_procedure := g_package ||'check_asg_extra_info_update';

Line: 451


END check_asg_extra_info_update;

Line: 516


SELECT 1
  FROM PER_ASSIGNMENT_EXTRA_INFO
 WHERE assignment_id    = p_assignment_id
   AND aei_information1 = p_aei_information1
   AND aei_information2 = p_aei_information2
   AND aei_information_category = p_aei_information_category;

Line: 525


SELECT 1
  FROM PER_ASSIGNMENT_EXTRA_INFO
 WHERE aei_information1 = p_aei_information1
   AND aei_information2 = p_aei_information2
   AND aei_information_category = p_aei_information_category
   AND assignment_id = p_assignment_id
   AND assignment_extra_info_id <> p_assignment_extra_info_id;