APPS.HR_TRS_SHD SQL Statements

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

Line: 69

    select transaction_step_id,
    transaction_id,
    api_name,
    api_display_name,
    processing_order,
    item_type,
    item_key,
    activity_id,
    creator_person_id,
    update_person_id,
    object_version_number,
    object_type,
    object_name,
    object_identifier,
    object_state,
    pk1,
    pk2,
    pk3,
    pk4,
    pk5,
    information_category,
    information1,
    information2,
    information3,
    information4,
    information5,
    information6,
    information7,
    information8,
    information9,
    information10,
    information11,
    information12,
    information13,
    information14,
    information15,
    information16,
    information17,
    information18,
    information19,
    information20,
    information21,
    information22,
    information23,
    information24,
    information25,
    information26,
    information27,
    information28,
    information29,
    information30
    from    hr_api_transaction_steps
    where   transaction_step_id = p_transaction_step_id;

Line: 189

    select  transaction_step_id,
    transaction_id,
    api_name,
    api_display_name,
    processing_order,
    item_type,
    item_key,
    activity_id,
    creator_person_id,
    update_person_id,
    object_version_number,
    object_type,
    object_name,
    object_identifier,
    object_state,
    pk1,
    pk2,
    pk3,
    pk4,
    pk5,
    information_category,
    information1,
    information2,
    information3,
    information4,
    information5,
    information6,
    information7,
    information8,
    information9,
    information10,
    information11,
    information12,
    information13,
    information14,
    information15,
    information16,
    information17,
    information18,
    information19,
    information20,
    information21,
    information22,
    information23,
    information24,
    information25,
    information26,
    information27,
    information28,
    information29,
    information30
    from    hr_api_transaction_steps
    where   transaction_step_id = p_transaction_step_id
    for update nowait;

Line: 301

    p_update_person_id              in number,
    p_object_version_number         in number,
    p_object_type                   in varchar2,
    p_object_name                   in varchar2,
    p_object_identifier             in  varchar2,
    p_object_state                  in varchar2,
    p_pk1                           in  varchar2,
    p_pk2                           in  varchar2,
    p_pk3                           in  varchar2,
    p_pk4                           in  varchar2,
    p_pk5                           in  varchar2,
    p_information_category	    in  varchar2,
    p_information1		    in  varchar2,
    p_information2		    in  varchar2,
    p_information3		    in  varchar2,
    p_information4		    in  varchar2,
    p_information5		    in  varchar2,
    p_information6		    in  varchar2,
    p_information7		    in  varchar2,
    p_information8		    in  varchar2,
    p_information9		    in  varchar2,
    p_information10		    in  varchar2,
    p_information11		    in  varchar2,
    p_information12		    in  varchar2,
    p_information13		    in  varchar2,
    p_information14		    in  varchar2,
    p_information15		    in  varchar2,
    p_information16		    in  varchar2,
    p_information17		    in  varchar2,
    p_information18		    in  varchar2,
    p_information19		    in  varchar2,
    p_information20		    in  varchar2,
    p_information21		    in  varchar2,
    p_information22		    in  varchar2,
    p_information23		    in  varchar2,
    p_information24		    in  varchar2,
    p_information25		    in  varchar2,
    p_information26		    in  varchar2,
    p_information27		    in  varchar2,
    p_information28		    in  varchar2,
    p_information29		    in  varchar2,
    p_information30		    in  varchar2

    )
    Return g_rec_type is
--
  l_rec   g_rec_type;

Line: 365

  l_rec.update_person_id               := p_update_person_id;