APPS.HR_TRN_SHD SQL Statements

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

Line: 68

    select transaction_id,
    creator_person_id,
    transaction_privilege,
    product_code,
    url,
    status,
    transaction_state,  --ns
    section_display_name,
    function_id,
    transaction_ref_table,
    transaction_ref_id,
    transaction_type,
    assignment_id,
    api_addtnl_info,
    selected_person_id,
    item_type,
    item_key,
    transaction_effective_date,
    process_name,
    plan_id ,
    rptg_grp_id,
    effective_date_option,
    creator_role,
    last_update_role,
    parent_transaction_id,
    relaunch_function,
    transaction_group,
    transaction_identifier,
    transaction_document
    from    hr_api_transactions
    where   transaction_id = p_transaction_id;

Line: 162

    select  transaction_id,
    creator_person_id,
    transaction_privilege,
    product_code,
    url,
    status,
    transaction_state, --ns
    section_display_name,
    function_id,
    transaction_ref_table,
    transaction_ref_id,
    transaction_type,
    assignment_id,
    api_addtnl_info,
    selected_person_id,
    item_type,
    item_key,
    transaction_effective_date,
    process_name,
    plan_id ,
    rptg_grp_id,
    effective_date_option,
    creator_role,
    last_update_role,
    parent_transaction_id,
    relaunch_function,
    transaction_group,
    transaction_identifier,
    transaction_document
    from    hr_api_transactions
    where   transaction_id = p_transaction_id
    for update nowait;

Line: 290

    p_selected_person_id            in number,
    p_item_type                     in varchar2,
    p_item_key                      in varchar2,
    p_transaction_effective_date    in date,
    p_process_name                  in varchar2,
    p_plan_id                      in number,
    p_rptg_grp_id                  in number,
    p_effective_date_option        in varchar2,
    p_creator_role                 in varchar2,
    p_last_update_role             in varchar2,
    p_parent_transaction_id        in number,
    p_relaunch_function            in varchar2,
    p_transaction_group            in varchar2,
    p_transaction_identifier       in varchar2,
    p_transaction_document         in clob

    )
    Return g_rec_type is
--
-- p_plan_id, p_rptg_grp_id, p_effective_date_option added by sanej
--
  l_rec   g_rec_type;

Line: 335

  l_rec.selected_person_id               := p_selected_person_id;

Line: 344

  l_rec.last_update_role                 := p_last_update_role;