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_STL_UPD dependencies on PER_STL_SHD

Line 55: (p_rec in out nocopy per_stl_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_stl_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 86: per_stl_shd.constraint_error

82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: --
86: per_stl_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.parent_integrity_violated Then
89: -- Parent integrity has been violated
90: --

Line 91: per_stl_shd.constraint_error

87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.parent_integrity_violated Then
89: -- Parent integrity has been violated
90: --
91: per_stl_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.unique_integrity_violated Then
94: -- Unique integrity has been violated
95: --

Line 96: per_stl_shd.constraint_error

92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.unique_integrity_violated Then
94: -- Unique integrity has been violated
95: --
96: per_stl_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When Others Then
99: --
100: Raise;

Line 136: (p_rec in per_stl_shd.g_rec_type

132: --
133: -- {End Of Comments}
134: -- ----------------------------------------------------------------------------
135: Procedure pre_update
136: (p_rec in per_stl_shd.g_rec_type
137: ) is
138: --
139: l_proc varchar2(72) := g_package||'pre_update';
140: --

Line 180: (p_rec in per_stl_shd.g_rec_type

176: --
177: -- {End Of Comments}
178: -- ----------------------------------------------------------------------------
179: Procedure post_update
180: (p_rec in per_stl_shd.g_rec_type
181: ) is
182: --
183: l_proc varchar2(72) := g_package||'post_update';
184: --

Line 195: ,p_language_o => per_stl_shd.g_old_rec.language

191: ,p_language => p_rec.language
192: ,p_source_lang => p_rec.source_lang
193: ,p_setup_task_name => p_rec.setup_task_name
194: ,p_setup_task_description => p_rec.setup_task_description
195: ,p_language_o => per_stl_shd.g_old_rec.language
196: ,p_source_lang_o => per_stl_shd.g_old_rec.source_lang
197: ,p_setup_task_name_o => per_stl_shd.g_old_rec.setup_task_name
198: ,p_setup_task_description_o => per_stl_shd.g_old_rec.setup_task_description
199: );

Line 196: ,p_source_lang_o => per_stl_shd.g_old_rec.source_lang

192: ,p_source_lang => p_rec.source_lang
193: ,p_setup_task_name => p_rec.setup_task_name
194: ,p_setup_task_description => p_rec.setup_task_description
195: ,p_language_o => per_stl_shd.g_old_rec.language
196: ,p_source_lang_o => per_stl_shd.g_old_rec.source_lang
197: ,p_setup_task_name_o => per_stl_shd.g_old_rec.setup_task_name
198: ,p_setup_task_description_o => per_stl_shd.g_old_rec.setup_task_description
199: );
200: --

Line 197: ,p_setup_task_name_o => per_stl_shd.g_old_rec.setup_task_name

193: ,p_setup_task_name => p_rec.setup_task_name
194: ,p_setup_task_description => p_rec.setup_task_description
195: ,p_language_o => per_stl_shd.g_old_rec.language
196: ,p_source_lang_o => per_stl_shd.g_old_rec.source_lang
197: ,p_setup_task_name_o => per_stl_shd.g_old_rec.setup_task_name
198: ,p_setup_task_description_o => per_stl_shd.g_old_rec.setup_task_description
199: );
200: --
201: exception

Line 198: ,p_setup_task_description_o => per_stl_shd.g_old_rec.setup_task_description

194: ,p_setup_task_description => p_rec.setup_task_description
195: ,p_language_o => per_stl_shd.g_old_rec.language
196: ,p_source_lang_o => per_stl_shd.g_old_rec.source_lang
197: ,p_setup_task_name_o => per_stl_shd.g_old_rec.setup_task_name
198: ,p_setup_task_description_o => per_stl_shd.g_old_rec.setup_task_description
199: );
200: --
201: exception
202: --

Line 258: (p_rec in out nocopy per_stl_shd.g_rec_type

254: --
255: -- {End Of Comments}
256: -- ----------------------------------------------------------------------------
257: Procedure convert_defs
258: (p_rec in out nocopy per_stl_shd.g_rec_type
259: ) is
260: --
261: Begin
262: --

Line 270: per_stl_shd.g_old_rec.language;

266: -- is being used then we must set to the 'current' argument value.
267: --
268: If (p_rec.language = hr_api.g_varchar2) then
269: p_rec.language :=
270: per_stl_shd.g_old_rec.language;
271: End If;
272: If (p_rec.source_lang = hr_api.g_varchar2) then
273: p_rec.source_lang :=
274: per_stl_shd.g_old_rec.source_lang;

Line 274: per_stl_shd.g_old_rec.source_lang;

270: per_stl_shd.g_old_rec.language;
271: End If;
272: If (p_rec.source_lang = hr_api.g_varchar2) then
273: p_rec.source_lang :=
274: per_stl_shd.g_old_rec.source_lang;
275: End If;
276: If (p_rec.setup_task_name = hr_api.g_varchar2) then
277: p_rec.setup_task_name :=
278: per_stl_shd.g_old_rec.setup_task_name;

Line 278: per_stl_shd.g_old_rec.setup_task_name;

274: per_stl_shd.g_old_rec.source_lang;
275: End If;
276: If (p_rec.setup_task_name = hr_api.g_varchar2) then
277: p_rec.setup_task_name :=
278: per_stl_shd.g_old_rec.setup_task_name;
279: End If;
280: If (p_rec.setup_task_description = hr_api.g_varchar2) then
281: p_rec.setup_task_description :=
282: per_stl_shd.g_old_rec.setup_task_description;

Line 282: per_stl_shd.g_old_rec.setup_task_description;

278: per_stl_shd.g_old_rec.setup_task_name;
279: End If;
280: If (p_rec.setup_task_description = hr_api.g_varchar2) then
281: p_rec.setup_task_description :=
282: per_stl_shd.g_old_rec.setup_task_description;
283: End If;
284: --
285: End convert_defs;
286: --

Line 291: (p_rec in out nocopy per_stl_shd.g_rec_type

287: -- ----------------------------------------------------------------------------
288: -- |---------------------------------< upd >----------------------------------|
289: -- ----------------------------------------------------------------------------
290: Procedure upd
291: (p_rec in out nocopy per_stl_shd.g_rec_type
292: ) is
293: --
294: l_proc varchar2(72) := g_package||'upd';
295: --

Line 301: per_stl_shd.lck

297: hr_utility.set_location('Entering:'||l_proc, 5);
298: --
299: -- We must lock the row which we need to update.
300: --
301: per_stl_shd.lck
302: (p_rec.setup_task_code
303: );
304: --
305: -- 1. During an update system defaults are used to determine if

Line 348: l_rec per_stl_shd.g_rec_type;

344: ,p_setup_task_name in varchar2 default hr_api.g_varchar2
345: ,p_setup_task_description in varchar2 default hr_api.g_varchar2
346: ) is
347: --
348: l_rec per_stl_shd.g_rec_type;
349: l_proc varchar2(72) := g_package||'upd';
350: --
351: Begin
352: hr_utility.set_location('Entering:'||l_proc, 5);

Line 358: per_stl_shd.convert_args

354: -- Call conversion function to turn arguments into the
355: -- l_rec structure.
356: --
357: l_rec :=
358: per_stl_shd.convert_args
359: (p_setup_task_code
360: ,p_language
361: ,p_source_lang
362: ,p_setup_task_name