APPS.PAY_US_INS_ORG_INFO_PKG SQL Statements

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

Line: 3

 FUNCTION  insert_org_information
  ( P_ORGANIZATION_ID                 NUMBER
   ,P_ORG_INFORMATION_CONTEXT         VARCHAR2
   ,P_ORG_INFORMATION1                VARCHAR2
   ,P_ORG_INFORMATION2                VARCHAR2 DEFAULT null
   ,P_ORG_INFORMATION3                VARCHAR2 DEFAULT null
   ,P_ORG_INFORMATION4                VARCHAR2 DEFAULT null
   ,P_ORG_INFORMATION5                VARCHAR2 DEFAULT null
   ,P_ORG_INFORMATION6                VARCHAR2 DEFAULT null
   ,P_ORG_INFORMATION7                VARCHAR2 DEFAULT null
   ,P_ORG_INFORMATION8                VARCHAR2 DEFAULT null
   ,P_ORG_INFORMATION9                VARCHAR2 DEFAULT null
   ,P_ORG_INFORMATION10               VARCHAR2 DEFAULT null
   ,P_ORG_INFORMATION11               VARCHAR2 DEFAULT null
   ,P_ORG_INFORMATION12               VARCHAR2 DEFAULT null
   ,P_ORG_INFORMATION13               VARCHAR2 DEFAULT null
   ,P_ORG_INFORMATION14               VARCHAR2 DEFAULT null
   ,P_ORG_INFORMATION15               VARCHAR2 DEFAULT null
   ,P_ORG_INFORMATION16               VARCHAR2 DEFAULT null
   ,P_ORG_INFORMATION17               VARCHAR2 DEFAULT null
   ,P_ORG_INFORMATION18               VARCHAR2 DEFAULT null
   ,P_ORG_INFORMATION19               VARCHAR2 DEFAULT null
   ,P_ORG_INFORMATION20               VARCHAR2 DEFAULT null
  ) return NUMBER
  IS
--
  l_org_information_id NUMBER;

Line: 38

  hr_utility.trace('Entered insert_org_information');

Line: 40

  hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',1);

Line: 46

     hr_utility.set_message_token('PROCEDURE','insert_org_information');

Line: 51

  hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',5);

Line: 52

  SELECT organization_id
  INTO   l_organization_id
  FROM   hr_all_organization_units
  WHERE  organization_id = p_organization_id;

Line: 57

  hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',8);

Line: 59

     SELECT lookup_code
     INTO   l_org_information1
     FROM   hr_lookups
     WHERE  lookup_type = 'ORG_CLASS'
     AND    lookup_code = p_org_information1;

Line: 77

  hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',10);

Line: 78

SELECT 'x' INTO l_dummy from dual;

Line: 94

     hr_utility.set_message_token('PROCEDURE','insert_org_information');

Line: 102

  hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',15);

Line: 103

  SELECT 'Y'
  INTO   l_check
  FROM   hr_organization_information
  WHERE  organization_id = l_organization_id
  AND    org_information_context = l_org_information_type
  AND    org_information1        = l_org_information1;

Line: 112

     hr_utility.set_message_token('PROCEDURE','insert_org_information');

Line: 120

  hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',20);

Line: 121

  SELECT hr_organization_information_s.nextval
  INTO   l_org_information_id
  FROM   sys.dual;

Line: 131

  hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',25);

Line: 132

  INSERT INTO HR_ORGANIZATION_INFORMATION
  (org_information_id
  ,organization_id
  ,attribute_category
  ,org_information_context
  ,org_information1
  ,org_information2
  ,org_information3
  ,org_information4
  ,org_information5
  ,org_information6
  ,org_information7
  ,org_information8
  ,org_information9
  ,org_information10
  ,org_information11
  ,org_information12
  ,org_information13
  ,org_information14
  ,org_information15
  ,org_information16
  ,org_information17
  ,org_information18
  ,org_information19
  ,org_information20
  ,last_update_date
  ,last_updated_by
  ,last_update_login
  ,created_by
  ,creation_date)
  SELECT l_org_information_id
  ,hou.organization_id
  ,p_org_information_context
  ,p_org_information_context
  ,p_org_information1
  ,p_org_information2
  ,p_org_information3
  ,p_org_information4
  ,p_org_information5
  ,p_org_information6
  ,p_org_information7
  ,p_org_information8
  ,p_org_information9
  ,p_org_information10
  ,p_org_information11
  ,p_org_information12
  ,p_org_information13
  ,p_org_information14
  ,p_org_information15
  ,p_org_information16
  ,p_org_information17
  ,p_org_information18
  ,p_org_information19
  ,p_org_information20
  ,hou.last_update_date
  ,hou.last_updated_by
  ,hou.last_update_login
  ,hou.created_by
  ,hou.creation_date
  FROM  hr_organization_units hou
  WHERE hou.organization_id = p_organization_id;

Line: 194

  hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',30);

Line: 200

  end insert_org_information;