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.FF_ARC_UPD dependencies on HR_API

Line 93: When hr_api.check_integrity_violated Then

89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 10);
91: --
92: Exception
93: When hr_api.check_integrity_violated Then
94: -- A check constraint has been violated
95: ff_arc_shd.g_api_dml := false; -- Unset the api dml status
96: ff_arc_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

93: When hr_api.check_integrity_violated Then
94: -- A check constraint has been violated
95: ff_arc_shd.g_api_dml := false; -- Unset the api dml status
96: ff_arc_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: ff_arc_shd.g_api_dml := false; -- Unset the api dml status
101: ff_arc_shd.constraint_error

Line 98: When hr_api.parent_integrity_violated Then

94: -- A check constraint has been violated
95: ff_arc_shd.g_api_dml := false; -- Unset the api dml status
96: ff_arc_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: ff_arc_shd.g_api_dml := false; -- Unset the api dml status
101: ff_arc_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: ff_arc_shd.g_api_dml := false; -- Unset the api dml status
101: ff_arc_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated
105: ff_arc_shd.g_api_dml := false; -- Unset the api dml status
106: ff_arc_shd.constraint_error

Line 103: When hr_api.unique_integrity_violated Then

99: -- Parent integrity has been violated
100: ff_arc_shd.g_api_dml := false; -- Unset the api dml status
101: ff_arc_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated
105: ff_arc_shd.g_api_dml := false; -- Unset the api dml status
106: ff_arc_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated
105: ff_arc_shd.g_api_dml := false; -- Unset the api dml status
106: ff_arc_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When Others Then
109: ff_arc_shd.g_api_dml := false; -- Unset the api dml status
110: Raise;
111: End update_dml;

Line 254: If (p_rec.user_entity_id = hr_api.g_number) then

250: -- p_rec plsql record structure
251: -- to see if a system default is being used. If a system default
252: -- is being used then we must set to the 'current' argument value.
253: --
254: If (p_rec.user_entity_id = hr_api.g_number) then
255: p_rec.user_entity_id :=
256: ff_arc_shd.g_old_rec.user_entity_id;
257: End If;
258: If (p_rec.context1 = hr_api.g_number) then

Line 258: If (p_rec.context1 = hr_api.g_number) then

254: If (p_rec.user_entity_id = hr_api.g_number) then
255: p_rec.user_entity_id :=
256: ff_arc_shd.g_old_rec.user_entity_id;
257: End If;
258: If (p_rec.context1 = hr_api.g_number) then
259: p_rec.context1 :=
260: ff_arc_shd.g_old_rec.context1;
261: End If;
262: If (p_rec.archive_type = hr_api.g_varchar2) then

Line 262: If (p_rec.archive_type = hr_api.g_varchar2) then

258: If (p_rec.context1 = hr_api.g_number) then
259: p_rec.context1 :=
260: ff_arc_shd.g_old_rec.context1;
261: End If;
262: If (p_rec.archive_type = hr_api.g_varchar2) then
263: p_rec.archive_type :=
264: ff_arc_shd.g_old_rec.archive_type;
265: End If;
266: If (p_rec.value = hr_api.g_varchar2) then

Line 266: If (p_rec.value = hr_api.g_varchar2) then

262: If (p_rec.archive_type = hr_api.g_varchar2) then
263: p_rec.archive_type :=
264: ff_arc_shd.g_old_rec.archive_type;
265: End If;
266: If (p_rec.value = hr_api.g_varchar2) then
267: p_rec.value :=
268: ff_arc_shd.g_old_rec.value;
269: End If;
270:

Line 325: p_value in varchar2 default hr_api.g_varchar2,

321: -- ----------------------------------------------------------------------------
322: Procedure upd
323: (
324: p_archive_item_id in number,
325: p_value in varchar2 default hr_api.g_varchar2,
326: p_object_version_number in out nocopy number
327: ) is
328: --
329: l_rec ff_arc_shd.g_rec_type;

Line 342: hr_api.g_number,

338: l_rec :=
339: ff_arc_shd.convert_args
340: (
341: p_archive_item_id,
342: hr_api.g_number,
343: hr_api.g_varchar2,
344: hr_api.g_number,
345: p_value,
346: p_object_version_number

Line 343: hr_api.g_varchar2,

339: ff_arc_shd.convert_args
340: (
341: p_archive_item_id,
342: hr_api.g_number,
343: hr_api.g_varchar2,
344: hr_api.g_number,
345: p_value,
346: p_object_version_number
347: );

Line 344: hr_api.g_number,

340: (
341: p_archive_item_id,
342: hr_api.g_number,
343: hr_api.g_varchar2,
344: hr_api.g_number,
345: p_value,
346: p_object_version_number
347: );
348: --