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_STC_INS dependencies on PER_STC_INS

Line 1: Package Body per_stc_ins as

1: Package Body per_stc_ins as
2: /* $Header: pestcrhi.pkb 120.1 2005/08/29 11:48:34 ndorai noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_stc_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_stc_ins.g_component_name_i := p_component_name;

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

Line 31: per_stc_ins.g_solution_type_name_i := p_solution_type_name;

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

Line 32: per_stc_ins.g_legislation_code_i := p_legislation_code;

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

Line 184: where component_name = per_stc_ins.g_component_name_i

180: --
181: Cursor C_Sel2 is
182: Select null
183: from per_solution_type_cmpts
184: where component_name = per_stc_ins.g_component_name_i
185: and solution_type_name = per_stc_ins.g_solution_type_name_i
186: and legislation_code = per_stc_ins.g_legislation_code_i;
187: --
188: l_proc varchar2(72) := g_package||'pre_insert';

Line 185: and solution_type_name = per_stc_ins.g_solution_type_name_i

181: Cursor C_Sel2 is
182: Select null
183: from per_solution_type_cmpts
184: where component_name = per_stc_ins.g_component_name_i
185: and solution_type_name = per_stc_ins.g_solution_type_name_i
186: and legislation_code = per_stc_ins.g_legislation_code_i;
187: --
188: l_proc varchar2(72) := g_package||'pre_insert';
189: l_exists varchar2(1);

Line 186: and legislation_code = per_stc_ins.g_legislation_code_i;

182: Select null
183: from per_solution_type_cmpts
184: where component_name = per_stc_ins.g_component_name_i
185: and solution_type_name = per_stc_ins.g_solution_type_name_i
186: and legislation_code = per_stc_ins.g_legislation_code_i;
187: --
188: l_proc varchar2(72) := g_package||'pre_insert';
189: l_exists varchar2(1);
190: --

Line 194: If (per_stc_ins.g_component_name_i is not null or

190: --
191: Begin
192: hr_utility.set_location('Entering:'||l_proc, 5);
193: --
194: If (per_stc_ins.g_component_name_i is not null or
195: per_stc_ins.g_solution_type_name_i is not null or
196: per_stc_ins.g_legislation_code_i is not null) Then
197: --
198: -- Verify registered primary key values not already in use

Line 195: per_stc_ins.g_solution_type_name_i is not null or

191: Begin
192: hr_utility.set_location('Entering:'||l_proc, 5);
193: --
194: If (per_stc_ins.g_component_name_i is not null or
195: per_stc_ins.g_solution_type_name_i is not null or
196: per_stc_ins.g_legislation_code_i is not null) Then
197: --
198: -- Verify registered primary key values not already in use
199: --

Line 196: per_stc_ins.g_legislation_code_i is not null) Then

192: hr_utility.set_location('Entering:'||l_proc, 5);
193: --
194: If (per_stc_ins.g_component_name_i is not null or
195: per_stc_ins.g_solution_type_name_i is not null or
196: per_stc_ins.g_legislation_code_i is not null) Then
197: --
198: -- Verify registered primary key values not already in use
199: --
200: Open C_Sel2;

Line 215: p_rec.component_name := per_stc_ins.g_component_name_i;

211: Close C_Sel2;
212: --
213: -- Use registered key values and clear globals
214: --
215: p_rec.component_name := per_stc_ins.g_component_name_i;
216: per_stc_ins.g_component_name_i := null;
217: p_rec.solution_type_name := per_stc_ins.g_solution_type_name_i;
218: per_stc_ins.g_solution_type_name_i := null;
219: p_rec.legislation_code := per_stc_ins.g_legislation_code_i;

Line 216: per_stc_ins.g_component_name_i := null;

212: --
213: -- Use registered key values and clear globals
214: --
215: p_rec.component_name := per_stc_ins.g_component_name_i;
216: per_stc_ins.g_component_name_i := null;
217: p_rec.solution_type_name := per_stc_ins.g_solution_type_name_i;
218: per_stc_ins.g_solution_type_name_i := null;
219: p_rec.legislation_code := per_stc_ins.g_legislation_code_i;
220: per_stc_ins.g_legislation_code_i := null;

Line 217: p_rec.solution_type_name := per_stc_ins.g_solution_type_name_i;

213: -- Use registered key values and clear globals
214: --
215: p_rec.component_name := per_stc_ins.g_component_name_i;
216: per_stc_ins.g_component_name_i := null;
217: p_rec.solution_type_name := per_stc_ins.g_solution_type_name_i;
218: per_stc_ins.g_solution_type_name_i := null;
219: p_rec.legislation_code := per_stc_ins.g_legislation_code_i;
220: per_stc_ins.g_legislation_code_i := null;
221: Else

Line 218: per_stc_ins.g_solution_type_name_i := null;

214: --
215: p_rec.component_name := per_stc_ins.g_component_name_i;
216: per_stc_ins.g_component_name_i := null;
217: p_rec.solution_type_name := per_stc_ins.g_solution_type_name_i;
218: per_stc_ins.g_solution_type_name_i := null;
219: p_rec.legislation_code := per_stc_ins.g_legislation_code_i;
220: per_stc_ins.g_legislation_code_i := null;
221: Else
222: --

Line 219: p_rec.legislation_code := per_stc_ins.g_legislation_code_i;

215: p_rec.component_name := per_stc_ins.g_component_name_i;
216: per_stc_ins.g_component_name_i := null;
217: p_rec.solution_type_name := per_stc_ins.g_solution_type_name_i;
218: per_stc_ins.g_solution_type_name_i := null;
219: p_rec.legislation_code := per_stc_ins.g_legislation_code_i;
220: per_stc_ins.g_legislation_code_i := null;
221: Else
222: --
223: -- No registerd key values so raise an error

Line 220: per_stc_ins.g_legislation_code_i := null;

216: per_stc_ins.g_component_name_i := null;
217: p_rec.solution_type_name := per_stc_ins.g_solution_type_name_i;
218: per_stc_ins.g_solution_type_name_i := null;
219: p_rec.legislation_code := per_stc_ins.g_legislation_code_i;
220: per_stc_ins.g_legislation_code_i := null;
221: Else
222: --
223: -- No registerd key values so raise an error
224: --

Line 226: hr_utility.set_message_token('API_NAME', 'per_stc_ins');

222: --
223: -- No registerd key values so raise an error
224: --
225: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
226: hr_utility.set_message_token('API_NAME', 'per_stc_ins');
227: hr_utility.set_message_token('ARGUMENT', 'base_key_value');
228: hr_utility.raise_error;
229: End If;
230: --

Line 335: per_stc_ins.pre_insert(p_rec);

331: hr_multi_message.end_validation_set;
332: --
333: -- Call the supporting pre-insert operation
334: --
335: per_stc_ins.pre_insert(p_rec);
336: --
337: -- Insert the row
338: --
339: per_stc_ins.insert_dml(p_rec);

Line 339: per_stc_ins.insert_dml(p_rec);

335: per_stc_ins.pre_insert(p_rec);
336: --
337: -- Insert the row
338: --
339: per_stc_ins.insert_dml(p_rec);
340: --
341: -- Call the supporting post-insert operation
342: --
343: per_stc_ins.post_insert

Line 343: per_stc_ins.post_insert

339: per_stc_ins.insert_dml(p_rec);
340: --
341: -- Call the supporting post-insert operation
342: --
343: per_stc_ins.post_insert
344: (p_effective_date
345: ,p_rec
346: );
347: --

Line 393: per_stc_ins.ins

389: --
390: -- Having converted the arguments into the per_stc_rec
391: -- plsql record structure we call the corresponding record business process.
392: --
393: per_stc_ins.ins
394: (p_effective_date
395: ,l_rec
396: );
397: --

Line 409: end per_stc_ins;

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