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.PER_SOS_INS dependencies on PER_SOS_INS

Line 1: Package Body per_sos_ins as

1: Package Body per_sos_ins as
2: /* $Header: pesosrhi.pkb 115.2 2003/08/08 00:05:41 vkonda noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' per_sos_ins.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_sos_ins.'; -- Global package name
9: --
10: -- The following global variables are only to be used by
11: -- the set_base_key_value and pre_insert procedures.
12: --

Line 30: per_sos_ins.g_solution_id_i := p_solution_id;

26: --
27: Begin
28: hr_utility.set_location('Entering:'||l_proc, 10);
29: --
30: per_sos_ins.g_solution_id_i := p_solution_id;
31: per_sos_ins.g_solution_set_name_i := p_solution_set_name;
32: per_sos_ins.g_user_id_i := p_user_id;
33: --
34: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 31: per_sos_ins.g_solution_set_name_i := p_solution_set_name;

27: Begin
28: hr_utility.set_location('Entering:'||l_proc, 10);
29: --
30: per_sos_ins.g_solution_id_i := p_solution_id;
31: per_sos_ins.g_solution_set_name_i := p_solution_set_name;
32: per_sos_ins.g_user_id_i := p_user_id;
33: --
34: hr_utility.set_location(' Leaving:'||l_proc, 20);
35: End set_base_key_value;

Line 32: per_sos_ins.g_user_id_i := p_user_id;

28: hr_utility.set_location('Entering:'||l_proc, 10);
29: --
30: per_sos_ins.g_solution_id_i := p_solution_id;
31: per_sos_ins.g_solution_set_name_i := p_solution_set_name;
32: per_sos_ins.g_user_id_i := p_user_id;
33: --
34: hr_utility.set_location(' Leaving:'||l_proc, 20);
35: End set_base_key_value;
36: --

Line 177: per_sos_ins.g_solution_id_i

173: Cursor C_Sel2 is
174: Select null
175: from per_solutions_selected
176: where solution_id =
177: per_sos_ins.g_solution_id_i
178: and solution_set_name =
179: per_sos_ins.g_solution_set_name_i
180: and user_id =
181: per_sos_ins.g_user_id_i;

Line 179: per_sos_ins.g_solution_set_name_i

175: from per_solutions_selected
176: where solution_id =
177: per_sos_ins.g_solution_id_i
178: and solution_set_name =
179: per_sos_ins.g_solution_set_name_i
180: and user_id =
181: per_sos_ins.g_user_id_i;
182: --
183: l_proc varchar2(72) := g_package||'pre_insert';

Line 181: per_sos_ins.g_user_id_i;

177: per_sos_ins.g_solution_id_i
178: and solution_set_name =
179: per_sos_ins.g_solution_set_name_i
180: and user_id =
181: per_sos_ins.g_user_id_i;
182: --
183: l_proc varchar2(72) := g_package||'pre_insert';
184: l_exists varchar2(1);
185: --

Line 189: If (per_sos_ins.g_solution_id_i is not null or

185: --
186: Begin
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: If (per_sos_ins.g_solution_id_i is not null or
190: per_sos_ins.g_solution_set_name_i is not null or
191: per_sos_ins.g_user_id_i is not null) Then
192: --
193: -- Verify registered primary key values not already in use

Line 190: per_sos_ins.g_solution_set_name_i is not null or

186: Begin
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: If (per_sos_ins.g_solution_id_i is not null or
190: per_sos_ins.g_solution_set_name_i is not null or
191: per_sos_ins.g_user_id_i is not null) Then
192: --
193: -- Verify registered primary key values not already in use
194: --

Line 191: per_sos_ins.g_user_id_i is not null) Then

187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: If (per_sos_ins.g_solution_id_i is not null or
190: per_sos_ins.g_solution_set_name_i is not null or
191: per_sos_ins.g_user_id_i is not null) Then
192: --
193: -- Verify registered primary key values not already in use
194: --
195: Open C_Sel2;

Line 211: per_sos_ins.g_solution_id_i;

207: --
208: -- Use registered key values and clear globals
209: --
210: p_rec.solution_id :=
211: per_sos_ins.g_solution_id_i;
212: per_sos_ins.g_solution_id_i := null;
213: p_rec.solution_set_name :=
214: per_sos_ins.g_solution_set_name_i;
215: per_sos_ins.g_solution_set_name_i := null;

Line 212: per_sos_ins.g_solution_id_i := null;

208: -- Use registered key values and clear globals
209: --
210: p_rec.solution_id :=
211: per_sos_ins.g_solution_id_i;
212: per_sos_ins.g_solution_id_i := null;
213: p_rec.solution_set_name :=
214: per_sos_ins.g_solution_set_name_i;
215: per_sos_ins.g_solution_set_name_i := null;
216: p_rec.user_id :=

Line 214: per_sos_ins.g_solution_set_name_i;

210: p_rec.solution_id :=
211: per_sos_ins.g_solution_id_i;
212: per_sos_ins.g_solution_id_i := null;
213: p_rec.solution_set_name :=
214: per_sos_ins.g_solution_set_name_i;
215: per_sos_ins.g_solution_set_name_i := null;
216: p_rec.user_id :=
217: per_sos_ins.g_user_id_i;
218: per_sos_ins.g_user_id_i := null;

Line 215: per_sos_ins.g_solution_set_name_i := null;

211: per_sos_ins.g_solution_id_i;
212: per_sos_ins.g_solution_id_i := null;
213: p_rec.solution_set_name :=
214: per_sos_ins.g_solution_set_name_i;
215: per_sos_ins.g_solution_set_name_i := null;
216: p_rec.user_id :=
217: per_sos_ins.g_user_id_i;
218: per_sos_ins.g_user_id_i := null;
219: Else

Line 217: per_sos_ins.g_user_id_i;

213: p_rec.solution_set_name :=
214: per_sos_ins.g_solution_set_name_i;
215: per_sos_ins.g_solution_set_name_i := null;
216: p_rec.user_id :=
217: per_sos_ins.g_user_id_i;
218: per_sos_ins.g_user_id_i := null;
219: Else
220: --
221: -- No registerd key values, so raise an error

Line 218: per_sos_ins.g_user_id_i := null;

214: per_sos_ins.g_solution_set_name_i;
215: per_sos_ins.g_solution_set_name_i := null;
216: p_rec.user_id :=
217: per_sos_ins.g_user_id_i;
218: per_sos_ins.g_user_id_i := null;
219: Else
220: --
221: -- No registerd key values, so raise an error
222: --

Line 224: hr_utility.set_message_token('API_NAME', 'per_sos_ins');

220: --
221: -- No registerd key values, so raise an error
222: --
223: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
224: hr_utility.set_message_token('API_NAME', 'per_sos_ins');
225: hr_utility.set_message_token('ARGUMENT', 'base_key_value');
226: hr_utility.raise_error;
227: End If;
228: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 320: per_sos_ins.pre_insert(p_rec);

316: hr_multi_message.end_validation_set;
317: --
318: -- Call the supporting pre-insert operation
319: --
320: per_sos_ins.pre_insert(p_rec);
321: --
322: -- Insert the row
323: --
324: per_sos_ins.insert_dml(p_rec);

Line 324: per_sos_ins.insert_dml(p_rec);

320: per_sos_ins.pre_insert(p_rec);
321: --
322: -- Insert the row
323: --
324: per_sos_ins.insert_dml(p_rec);
325: --
326: -- Call the supporting post-insert operation
327: --
328: per_sos_ins.post_insert

Line 328: per_sos_ins.post_insert

324: per_sos_ins.insert_dml(p_rec);
325: --
326: -- Call the supporting post-insert operation
327: --
328: per_sos_ins.post_insert
329: (p_rec
330: );
331: --
332: -- Call to raise any errors on multi-message list

Line 368: per_sos_ins.ins

364: --
365: -- Having converted the arguments into the per_sos_rec
366: -- plsql record structure we call the corresponding record business process.
367: --
368: per_sos_ins.ins
369: (l_rec
370: );
371: --
372: -- As the primary key argument(s)

Line 383: end per_sos_ins;

379: --
380: hr_utility.set_location(' Leaving:'||l_proc, 10);
381: End ins;
382: --
383: end per_sos_ins;