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

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

Line: 720


                             p_message_name => 'HR_UPDATE_NOT_ALLOWED');

Line: 734


  || PROCEDURE: update_phone
  ||---------------------------------------------------------------------------
  ||
  || Description:
  || Description:
  ||     This procedure will call the actual API -
  ||                hr_phone_api.update_phone()
  ||
  || Pre Conditions:
  ||
  || In Arguments:
  ||     Contains entire list of parameters that are defined in the actual
  ||     API. For details see pephnapi.pkb file.
  ||
  || out nocopy Arguments:
  ||
  || In out nocopy Arguments:
  ||
  || Post Success:
  ||     Executes the API call.
  ||
  || Post Failure:
  ||     Raises an exception
  ||
  || Access Status:
  ||     Public.
  ||
  ||===========================================================================
  */

 procedure update_phone(p_phone_id  NUMBER
    , p_date_from  date
    , p_date_to  date
    , p_phone_type  VARCHAR2
    , p_phone_number  VARCHAR2
    , p_per_or_contact varchar2 default null
    --
    -- PB Add :
    -- The transaction steps have to be created by the login personid.
    -- In case of adding phones for contacts parent_is is contact_person_id.
    -- Login person id is say employee who is adding the phones to his contact.
    --
    , p_login_person_id     NUMBER default hr_api.g_number
    , p_attribute_category  VARCHAR2 default hr_api.g_varchar2
    , p_attribute1  VARCHAR2 default hr_api.g_varchar2
    , p_attribute2  VARCHAR2 default hr_api.g_varchar2
    , p_attribute3  VARCHAR2 default hr_api.g_varchar2
    , p_attribute4  VARCHAR2 default hr_api.g_varchar2
    , p_attribute5  VARCHAR2 default hr_api.g_varchar2
    , p_attribute6  VARCHAR2 default hr_api.g_varchar2
    , p_attribute7  VARCHAR2 default hr_api.g_varchar2
    , p_attribute8  VARCHAR2 default hr_api.g_varchar2
    , p_attribute9  VARCHAR2 default hr_api.g_varchar2
    , p_attribute10  VARCHAR2 default hr_api.g_varchar2
    , p_attribute11  VARCHAR2 default hr_api.g_varchar2
    , p_attribute12  VARCHAR2 default hr_api.g_varchar2
    , p_attribute13  VARCHAR2 default hr_api.g_varchar2
    , p_attribute14  VARCHAR2 default hr_api.g_varchar2
    , p_attribute15  VARCHAR2 default hr_api.g_varchar2
    , p_attribute16  VARCHAR2 default hr_api.g_varchar2
    , p_attribute17  VARCHAR2 default hr_api.g_varchar2
    , p_attribute18  VARCHAR2 default hr_api.g_varchar2
    , p_attribute19  VARCHAR2 default hr_api.g_varchar2
    , p_attribute20  VARCHAR2 default hr_api.g_varchar2
    , p_attribute21  VARCHAR2 default hr_api.g_varchar2
    , p_attribute22  VARCHAR2 default hr_api.g_varchar2
    , p_attribute23  VARCHAR2 default hr_api.g_varchar2
    , p_attribute24  VARCHAR2 default hr_api.g_varchar2
    , p_attribute25  VARCHAR2 default hr_api.g_varchar2
    , p_attribute26  VARCHAR2 default hr_api.g_varchar2
    , p_attribute27  VARCHAR2 default hr_api.g_varchar2
    , p_attribute28  VARCHAR2 default hr_api.g_varchar2
    , p_attribute29  VARCHAR2 default hr_api.g_varchar2
    , p_attribute30  VARCHAR2 default hr_api.g_varchar2
    , p_object_version_number in out nocopy  NUMBER
    , p_validate  number
    , p_effective_date  date
    , p_parent_id  NUMBER
    , p_item_type                     in     varchar2
    , p_item_key                      in     varchar2
    , p_activity_id                   in     number
    , p_phone_type_meaning            in     varchar2
    , p_save_mode                     in     varchar2 default null
    , p_error_message                 out nocopy    varchar2
    , p_contact_relationship_id       in number           default hr_api.g_number
  )
  as

  l_transaction_id             number default null;

Line: 830


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

Line: 842


    hr_phone_api.update_phone(
      p_phone_id => p_phone_id,
      p_date_from   => p_date_from,
      p_phone_type  => p_phone_type,
      p_phone_number => p_phone_number,
      p_attribute_category => p_attribute_category,
      p_attribute1 => p_attribute1,
      p_attribute2 => p_attribute2,
      p_attribute3 => p_attribute3,
      p_attribute4 => p_attribute4,
      p_attribute5 => p_attribute5,
      p_attribute6 => p_attribute6,
      p_attribute7 => p_attribute7,
      p_attribute8 => p_attribute8,
      p_attribute9 => p_attribute9,
      p_attribute10 => p_attribute10,
      p_attribute11 => p_attribute11,
      p_attribute12 => p_attribute12,
      p_attribute13 => p_attribute13,
      p_attribute14 => p_attribute14,
      p_attribute15 => p_attribute15,
      p_attribute16 => p_attribute16,
      p_attribute17 => p_attribute17,
      p_attribute18 => p_attribute18,
      p_attribute19 => p_attribute19,
      p_attribute20 => p_attribute20,
      p_attribute21 => p_attribute21,
      p_attribute22 => p_attribute22,
      p_attribute23 => p_attribute23,
      p_attribute24 => p_attribute24,
      p_attribute25 => p_attribute25,
      p_attribute26 => p_attribute26,
      p_attribute27 => p_attribute27,
      p_attribute28 => p_attribute28,
      p_attribute29 => p_attribute29,
      p_attribute30 => p_attribute30,
      p_object_version_number => p_object_version_number,
      p_validate => hr_java_conv_util_ss.get_boolean (p_number => p_validate),
      p_effective_date => p_effective_date);

Line: 961


                             p_message_name => 'HR_UPDATE_NOT_ALLOWED');

Line: 971


  end update_phone;

Line: 975


  || PROCEDURE: delete_phone
  ||---------------------------------------------------------------------------
  ||
  || Description:
  || Description:
  ||     This procedure will call the actual API -
  ||                hr_phone_api.delete_phone()
  ||
  || Pre Conditions:
  ||
  || In Arguments:
  ||     Contains entire list of parameters that are defined in the actual
  ||     API. For details see pephnapi.pkb file.
  ||
  || out nocopy Arguments:
  ||
  || In out nocopy Arguments:
  ||
  || Post Success:
  ||     Executes the API call.
  ||
  || Post Failure:
  ||     Raises an exception
  ||
  || Access Status:
  ||     Public.
  ||
  ||===========================================================================
  */

  procedure delete_phone(p_validate  number
    , p_phone_id  NUMBER
    , p_object_version_number  NUMBER
    , p_parent_id                     in     number
    --
    -- PB Add :
    -- The transaction steps have to be created by the login personid.
    -- In case of adding phones for contacts parent_is is contact_person_id.
    -- Login person id is say employee who is adding the phones to his contact.
    --
    , p_login_person_id     NUMBER default hr_api.g_number
    , p_item_type                     in     varchar2
    , p_item_key                      in     varchar2
    , p_activity_id                   in     number
    , p_phone_type_meaning            in     varchar2
    , p_save_mode                     in     varchar2 default null
    , p_error_message                 out nocopy    varchar2
    , p_per_or_contact varchar2 default null
 )
  as

  l_transaction_id             number default null;

Line: 1034


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

Line: 1044


    hr_phone_api.delete_phone(
      p_validate => hr_java_conv_util_ss.get_boolean (p_number => p_validate),
      p_phone_id => p_phone_id,
      p_object_version_number => p_object_version_number);

Line: 1056


  , p_phone_type => 'DELETE'
  , p_phone_number => 'DELETE_NUMBER'
  , p_parent_id  => p_parent_id
  , p_login_person_id  => p_login_person_id
  , p_per_or_contact => p_per_or_contact
  , p_object_version_number => p_object_version_number
  , p_phone_type_meaning => p_phone_type_meaning
  , p_error_message => l_error_message);

Line: 1093


                             p_message_name => 'HR_UPDATE_NOT_ALLOWED');

Line: 1103


  end delete_phone;

Line: 1107


  || PROCEDURE: create_or_update_phone
  ||---------------------------------------------------------------------------
  ||
  || Description:
  || Description:
  ||     This procedure will call the actual API -
  ||                hr_phone_api.create_or_update_phone()
  ||
  || Pre Conditions:
  ||
  || In Arguments:
  ||     Contains entire list of parameters that are defined in the actual
  ||     API. For details see pephnapi.pkb file.
  ||
  || out nocopy Arguments:
  ||
  || In out nocopy Arguments:
  ||
  || Post Success:
  ||     Executes the API call.
  ||
  || Post Failure:
  ||     Raises an exception
  ||
  || Access Status:
  ||     Public.
  ||
  ||===========================================================================
  */

  procedure create_or_update_phone(p_update_mode  VARCHAR2
    , p_phone_id in out nocopy  NUMBER
    , p_object_version_number in out nocopy  NUMBER
    , p_date_from  date
    , p_date_to  date
    , p_phone_type  VARCHAR2
    , p_phone_number  VARCHAR2
    , p_parent_id  NUMBER
    , p_parent_table  VARCHAR2
    , p_attribute_category  VARCHAR2
    , p_attribute1  VARCHAR2 default hr_api.g_varchar2
    , p_attribute2  VARCHAR2 default hr_api.g_varchar2
    , p_attribute3  VARCHAR2 default hr_api.g_varchar2
    , p_attribute4  VARCHAR2 default hr_api.g_varchar2
    , p_attribute5  VARCHAR2 default hr_api.g_varchar2
    , p_attribute6  VARCHAR2 default hr_api.g_varchar2
    , p_attribute7  VARCHAR2 default hr_api.g_varchar2
    , p_attribute8  VARCHAR2 default hr_api.g_varchar2
    , p_attribute9  VARCHAR2 default hr_api.g_varchar2
    , p_attribute10  VARCHAR2 default hr_api.g_varchar2
    , p_attribute11  VARCHAR2 default hr_api.g_varchar2
    , p_attribute12  VARCHAR2 default hr_api.g_varchar2
    , p_attribute13  VARCHAR2 default hr_api.g_varchar2
    , p_attribute14  VARCHAR2 default hr_api.g_varchar2
    , p_attribute15  VARCHAR2 default hr_api.g_varchar2
    , p_attribute16  VARCHAR2 default hr_api.g_varchar2
    , p_attribute17  VARCHAR2 default hr_api.g_varchar2
    , p_attribute18  VARCHAR2 default hr_api.g_varchar2
    , p_attribute19  VARCHAR2 default hr_api.g_varchar2
    , p_attribute20  VARCHAR2 default hr_api.g_varchar2
    , p_attribute21  VARCHAR2 default hr_api.g_varchar2
    , p_attribute22  VARCHAR2 default hr_api.g_varchar2
    , p_attribute23  VARCHAR2 default hr_api.g_varchar2
    , p_attribute24  VARCHAR2 default hr_api.g_varchar2
    , p_attribute25  VARCHAR2 default hr_api.g_varchar2
    , p_attribute26  VARCHAR2 default hr_api.g_varchar2
    , p_attribute27  VARCHAR2 default hr_api.g_varchar2
    , p_attribute28  VARCHAR2 default hr_api.g_varchar2
    , p_attribute29  VARCHAR2 default hr_api.g_varchar2
    , p_attribute30  VARCHAR2 default hr_api.g_varchar2
    , p_validate  number
    , p_effective_date  date
    , p_item_type                     in     varchar2
    , p_item_key                      in     varchar2
    , p_activity_id                   in     number
    , p_phone_type_meaning            in     varchar2
  )
  as
  l_proc   varchar2(72)  := g_package||'create_or_update_phone';

Line: 1191


    hr_phone_api.create_or_update_phone(
      p_update_mode => p_update_mode,
      p_phone_id => p_phone_id,
      p_object_version_number => p_object_version_number,
      p_date_from => p_date_from,
      p_phone_type => p_phone_type,
      p_phone_number => p_phone_number,
      p_parent_id => p_parent_id,
      p_parent_table => p_parent_table,
      p_attribute_category => p_attribute_category,
      p_attribute1 => p_attribute1,
      p_attribute2 => p_attribute2,
      p_attribute3 => p_attribute3,
      p_attribute4 => p_attribute4,
      p_attribute5 => p_attribute5,
      p_attribute6 => p_attribute6,
      p_attribute7 => p_attribute7,
      p_attribute8 => p_attribute8,
      p_attribute9 => p_attribute9,
      p_attribute10 => p_attribute10,
      p_attribute11 => p_attribute11,
      p_attribute12 => p_attribute12,
      p_attribute13 => p_attribute13,
      p_attribute14 => p_attribute14,
      p_attribute15 => p_attribute15,
      p_attribute16 => p_attribute16,
      p_attribute17 => p_attribute17,
      p_attribute18 => p_attribute18,
      p_attribute19 => p_attribute19,
      p_attribute20 => p_attribute20,
      p_attribute21 => p_attribute21,
      p_attribute22 => p_attribute22,
      p_attribute23 => p_attribute23,
      p_attribute24 => p_attribute24,
      p_attribute25 => p_attribute25,
      p_attribute26 => p_attribute26,
      p_attribute27 => p_attribute27,
      p_attribute28 => p_attribute28,
      p_attribute29 => p_attribute29,
      p_attribute30 => p_attribute30,
      p_validate => hr_java_conv_util_ss.get_boolean (p_number => p_validate),
      p_effective_date => p_effective_date);

Line: 1234


  end create_or_update_phone;

Line: 1258


    select hatv.number_value
    from   hr_api_transaction_values hatv
    where  hatv.transaction_step_id = cv_transaction_step_id
    and    hatv.name                = cv_name;

Line: 1446


    select hatv.number_value
    from   hr_api_transaction_values hatv
    where  hatv.transaction_step_id = cv_transaction_step_id
    and    hatv.name                = cv_name;

Line: 1686


    select hatv.number_value
    from   hr_api_transaction_values hatv
    where  hatv.transaction_step_id = cv_transaction_step_id
    and    hatv.name                = cv_name;

Line: 1937


l_deleted_phone_count INTEGER;

Line: 1942


l_deleted_ovn per_phones.object_version_number%TYPE;

Line: 2149


        ELSIF  l_phone_type = 'DELETE' THEN
               -- Delete the existing phone nuber.
                       hr_utility.set_location('l_phone_type = DELETE THEN:'||l_proc,35);

Line: 2152


                       hr_phone_api.delete_phone
                        (p_validate => FALSE
                        ,p_phone_id => l_phone_id
                        ,p_object_version_number => l_phone_ovn
                        );

Line: 2159


                        hr_phone_api.update_phone
                        (p_validate => FALSE
                        ,p_phone_id => l_phone_id
                        ,p_phone_number => l_phone_number
                        ,p_phone_type => l_phone_type
                        ,p_object_version_number => l_phone_ovn
                        ,p_effective_date =>  l_effective_date
                        ,p_attribute_category => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE_CATEGORY')
                        ,p_attribute1 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE1')
			,p_attribute2 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE2')
			,p_attribute3 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE3')
			,p_attribute4 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE4')
			,p_attribute5 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE5')
			,p_attribute6 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE6')
			,p_attribute7 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE7')
			,p_attribute8 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE8')
			,p_attribute9 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE9')
			,p_attribute10 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE10')
			,p_attribute11 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE11')
			,p_attribute12 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE12')
			,p_attribute13 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE13')
			,p_attribute14 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE14')
			,p_attribute15 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE15')
			,p_attribute16 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE16')
			,p_attribute17 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE17')
			,p_attribute18 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE18')
			,p_attribute19 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE19')
			,p_attribute20 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE20')
			,p_attribute21 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE21')
			,p_attribute22 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE22')
			,p_attribute23 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE23')
			,p_attribute24 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE24')
			,p_attribute25 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE25')
			,p_attribute26 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE26')
			,p_attribute27 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE27')
			,p_attribute28 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE28')
			,p_attribute29 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE29')
			,p_attribute30 => hr_transaction_api.get_varchar2_value
                                (p_transaction_step_id => p_transaction_step_id
                                ,p_name => 'P_ATTRIBUTE30'));