APPS.PER_SOS_SHD SQL Statements

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

Line: 21

  If (p_constraint_name = 'PER_SELECTED_SOLUTIONS_FK1') Then
    fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line: 26

  ElsIf (p_constraint_name = 'PER_SOLUTIONS_SELECTED_FK2') Then
    fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line: 31

  ElsIf (p_constraint_name = 'PER_SOLUTIONS_SELECTED_PK') Then
    fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line: 60

    select
       solution_id
      ,solution_set_name
      ,user_id
      ,object_version_number
    from        per_solutions_selected
    where       solution_id = p_solution_id
    and   solution_set_name = p_solution_set_name
    and   user_id = p_user_id;

Line: 139

    select
       solution_id
      ,solution_set_name
      ,user_id
      ,object_version_number
    from        per_solutions_selected
    where       solution_id = p_solution_id
    and   solution_set_name = p_solution_set_name
    and   user_id = p_user_id
    for update nowait;

Line: 207

    fnd_message.set_token('TABLE_NAME', 'per_solutions_selected');