APPS.PER_SOS_SHD dependencies on PER_SOLUTIONS_SELECTED

Line 26: ElsIf (p_constraint_name = 'PER_SOLUTIONS_SELECTED_FK2') Then

22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'PER_SOLUTIONS_SELECTED_FK2') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;

Line 31: ElsIf (p_constraint_name = 'PER_SOLUTIONS_SELECTED_PK') Then

27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: ElsIf (p_constraint_name = 'PER_SOLUTIONS_SELECTED_PK') Then
32: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('STEP','15');
35: fnd_message.raise_error;

Line 65: from per_solutions_selected

61: solution_id
62: ,solution_set_name
63: ,user_id
64: ,object_version_number
65: from per_solutions_selected
66: where solution_id = p_solution_id
67: and solution_set_name = p_solution_set_name
68: and user_id = p_user_id;
69: --

Line 144: from per_solutions_selected

140: solution_id
141: ,solution_set_name
142: ,user_id
143: ,object_version_number
144: from per_solutions_selected
145: where solution_id = p_solution_id
146: and solution_set_name = p_solution_set_name
147: and user_id = p_user_id
148: for update nowait;

Line 207: fnd_message.set_token('TABLE_NAME', 'per_solutions_selected');

203: -- The object is locked therefore we need to supply a meaningful
204: -- error message.
205: --
206: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
207: fnd_message.set_token('TABLE_NAME', 'per_solutions_selected');
208: fnd_message.raise_error;
209: End lck;
210: --
211: -- ----------------------------------------------------------------------------