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_SCN_INS dependencies on PER_SCN_INS

Line 1: Package Body per_scn_ins as

1: Package Body per_scn_ins as
2: /* $Header: pescnrhi.pkb 120.1 2011/04/28 09:51:49 sidsaxen ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_scn_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_scn_ins.g_solution_id_i := p_solution_id;

26: --
27: Begin
28: hr_utility.set_location('Entering:'||l_proc, 10);
29: --
30: per_scn_ins.g_solution_id_i := p_solution_id;
31: per_scn_ins.g_component_name_i := p_component_name;
32: per_scn_ins.g_solution_type_name_i := p_solution_type_name;
33: --
34: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 31: per_scn_ins.g_component_name_i := p_component_name;

27: Begin
28: hr_utility.set_location('Entering:'||l_proc, 10);
29: --
30: per_scn_ins.g_solution_id_i := p_solution_id;
31: per_scn_ins.g_component_name_i := p_component_name;
32: per_scn_ins.g_solution_type_name_i := p_solution_type_name;
33: --
34: hr_utility.set_location(' Leaving:'||l_proc, 20);
35: End set_base_key_value;

Line 32: per_scn_ins.g_solution_type_name_i := p_solution_type_name;

28: hr_utility.set_location('Entering:'||l_proc, 10);
29: --
30: per_scn_ins.g_solution_id_i := p_solution_id;
31: per_scn_ins.g_component_name_i := p_component_name;
32: per_scn_ins.g_solution_type_name_i := p_solution_type_name;
33: --
34: hr_utility.set_location(' Leaving:'||l_proc, 20);
35: End set_base_key_value;
36: --

Line 199: where solution_id = per_scn_ins.g_solution_id_i

195: --
196: Cursor C_Sel2 is
197: Select null
198: from per_solution_cmpt_names
199: where solution_id = per_scn_ins.g_solution_id_i
200: and component_name = per_scn_ins.g_component_name_i
201: and solution_type_name = per_scn_ins.g_solution_type_name_i;
202: --
203: l_proc varchar2(72) := g_package||'pre_insert';

Line 200: and component_name = per_scn_ins.g_component_name_i

196: Cursor C_Sel2 is
197: Select null
198: from per_solution_cmpt_names
199: where solution_id = per_scn_ins.g_solution_id_i
200: and component_name = per_scn_ins.g_component_name_i
201: and solution_type_name = per_scn_ins.g_solution_type_name_i;
202: --
203: l_proc varchar2(72) := g_package||'pre_insert';
204: l_exists varchar2(1);

Line 201: and solution_type_name = per_scn_ins.g_solution_type_name_i;

197: Select null
198: from per_solution_cmpt_names
199: where solution_id = per_scn_ins.g_solution_id_i
200: and component_name = per_scn_ins.g_component_name_i
201: and solution_type_name = per_scn_ins.g_solution_type_name_i;
202: --
203: l_proc varchar2(72) := g_package||'pre_insert';
204: l_exists varchar2(1);
205: --

Line 209: If (per_scn_ins.g_solution_id_i is not null or

205: --
206: Begin
207: hr_utility.set_location('Entering:'||l_proc, 5);
208: --
209: If (per_scn_ins.g_solution_id_i is not null or
210: per_scn_ins.g_component_name_i is not null or
211: per_scn_ins.g_solution_type_name_i is not null) Then
212: --
213: -- Verify registered primary key values not already in use

Line 210: per_scn_ins.g_component_name_i is not null or

206: Begin
207: hr_utility.set_location('Entering:'||l_proc, 5);
208: --
209: If (per_scn_ins.g_solution_id_i is not null or
210: per_scn_ins.g_component_name_i is not null or
211: per_scn_ins.g_solution_type_name_i is not null) Then
212: --
213: -- Verify registered primary key values not already in use
214: --

Line 211: per_scn_ins.g_solution_type_name_i is not null) Then

207: hr_utility.set_location('Entering:'||l_proc, 5);
208: --
209: If (per_scn_ins.g_solution_id_i is not null or
210: per_scn_ins.g_component_name_i is not null or
211: per_scn_ins.g_solution_type_name_i is not null) Then
212: --
213: -- Verify registered primary key values not already in use
214: --
215: Open C_Sel2;

Line 231: per_scn_ins.g_solution_id_i;

227: --
228: -- Use registered key values and clear globals
229: --
230: p_rec.solution_id :=
231: per_scn_ins.g_solution_id_i;
232: per_scn_ins.g_solution_id_i := null;
233: p_rec.component_name :=
234: per_scn_ins.g_component_name_i;
235: per_scn_ins.g_component_name_i := null;

Line 232: per_scn_ins.g_solution_id_i := null;

228: -- Use registered key values and clear globals
229: --
230: p_rec.solution_id :=
231: per_scn_ins.g_solution_id_i;
232: per_scn_ins.g_solution_id_i := null;
233: p_rec.component_name :=
234: per_scn_ins.g_component_name_i;
235: per_scn_ins.g_component_name_i := null;
236: p_rec.solution_type_name :=

Line 234: per_scn_ins.g_component_name_i;

230: p_rec.solution_id :=
231: per_scn_ins.g_solution_id_i;
232: per_scn_ins.g_solution_id_i := null;
233: p_rec.component_name :=
234: per_scn_ins.g_component_name_i;
235: per_scn_ins.g_component_name_i := null;
236: p_rec.solution_type_name :=
237: per_scn_ins.g_solution_type_name_i;
238: per_scn_ins.g_solution_type_name_i := null;

Line 235: per_scn_ins.g_component_name_i := null;

231: per_scn_ins.g_solution_id_i;
232: per_scn_ins.g_solution_id_i := null;
233: p_rec.component_name :=
234: per_scn_ins.g_component_name_i;
235: per_scn_ins.g_component_name_i := null;
236: p_rec.solution_type_name :=
237: per_scn_ins.g_solution_type_name_i;
238: per_scn_ins.g_solution_type_name_i := null;
239: Else

Line 237: per_scn_ins.g_solution_type_name_i;

233: p_rec.component_name :=
234: per_scn_ins.g_component_name_i;
235: per_scn_ins.g_component_name_i := null;
236: p_rec.solution_type_name :=
237: per_scn_ins.g_solution_type_name_i;
238: per_scn_ins.g_solution_type_name_i := null;
239: Else
240: --
241: -- No registerd key values, so raise an error.

Line 238: per_scn_ins.g_solution_type_name_i := null;

234: per_scn_ins.g_component_name_i;
235: per_scn_ins.g_component_name_i := null;
236: p_rec.solution_type_name :=
237: per_scn_ins.g_solution_type_name_i;
238: per_scn_ins.g_solution_type_name_i := null;
239: Else
240: --
241: -- No registerd key values, so raise an error.
242: --

Line 244: hr_utility.set_message_token('API_NAME', 'per_scn_ins');

240: --
241: -- No registerd key values, so raise an error.
242: --
243: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
244: hr_utility.set_message_token('API_NAME', 'per_scn_ins');
245: hr_utility.set_message_token('ARGUMENT', 'base_key_value');
246: hr_utility.raise_error;
247: End If;
248: --

Line 343: per_scn_ins.pre_insert(p_rec);

339: hr_multi_message.end_validation_set;
340: --
341: -- Call the supporting pre-insert operation
342: --
343: per_scn_ins.pre_insert(p_rec);
344: --
345: -- Insert the row
346: --
347: per_scn_ins.insert_dml(p_rec);

Line 347: per_scn_ins.insert_dml(p_rec);

343: per_scn_ins.pre_insert(p_rec);
344: --
345: -- Insert the row
346: --
347: per_scn_ins.insert_dml(p_rec);
348: --
349: -- Call the supporting post-insert operation
350: --
351: per_scn_ins.post_insert

Line 351: per_scn_ins.post_insert

347: per_scn_ins.insert_dml(p_rec);
348: --
349: -- Call the supporting post-insert operation
350: --
351: per_scn_ins.post_insert
352: (p_rec
353: );
354: --
355: -- Call to raise any errors on multi-message list

Line 393: per_scn_ins.ins

389: --
390: -- Having converted the arguments into the per_scn_rec
391: -- plsql record structure we call the corresponding record business process.
392: --
393: per_scn_ins.ins
394: (l_rec
395: );
396: --
397: -- As the primary key argument(s)

Line 408: end per_scn_ins;

404: --
405: hr_utility.set_location(' Leaving:'||l_proc, 10);
406: End ins;
407: --
408: end per_scn_ins;