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

Line 88: When hr_api.check_integrity_violated Then

84: --
85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: --
87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: ssp_stp_shd.g_api_dml := false; -- Unset the api dml status
91: ssp_stp_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: ssp_stp_shd.g_api_dml := false; -- Unset the api dml status
91: ssp_stp_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: ssp_stp_shd.g_api_dml := false; -- Unset the api dml status
96: ssp_stp_shd.constraint_error

Line 93: When hr_api.parent_integrity_violated Then

89: -- A check constraint has been violated
90: ssp_stp_shd.g_api_dml := false; -- Unset the api dml status
91: ssp_stp_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: ssp_stp_shd.g_api_dml := false; -- Unset the api dml status
96: ssp_stp_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.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: ssp_stp_shd.g_api_dml := false; -- Unset the api dml status
96: ssp_stp_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: ssp_stp_shd.g_api_dml := false; -- Unset the api dml status
101: ssp_stp_shd.constraint_error

Line 98: When hr_api.unique_integrity_violated Then

94: -- Parent integrity has been violated
95: ssp_stp_shd.g_api_dml := false; -- Unset the api dml status
96: ssp_stp_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: ssp_stp_shd.g_api_dml := false; -- Unset the api dml status
101: ssp_stp_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.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: ssp_stp_shd.g_api_dml := false; -- Unset the api dml status
101: ssp_stp_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: ssp_stp_shd.g_api_dml := false; -- Unset the api dml status
105: Raise;
106: End update_dml;

Line 249: If (p_rec.absence_attendance_id = hr_api.g_number) then

245: -- p_rec plsql record structure
246: -- to see if a system default is being used. If a system default
247: -- is being used then we must set to the 'current' argument value.
248: --
249: If (p_rec.absence_attendance_id = hr_api.g_number) then
250: p_rec.absence_attendance_id :=
251: ssp_stp_shd.g_old_rec.absence_attendance_id;
252: End If;
253: If (p_rec.maternity_id = hr_api.g_number) then

Line 253: If (p_rec.maternity_id = hr_api.g_number) then

249: If (p_rec.absence_attendance_id = hr_api.g_number) then
250: p_rec.absence_attendance_id :=
251: ssp_stp_shd.g_old_rec.absence_attendance_id;
252: End If;
253: If (p_rec.maternity_id = hr_api.g_number) then
254: p_rec.maternity_id :=
255: ssp_stp_shd.g_old_rec.maternity_id;
256: End If;
257: If (p_rec.reason_id = hr_api.g_number) then

Line 257: If (p_rec.reason_id = hr_api.g_number) then

253: If (p_rec.maternity_id = hr_api.g_number) then
254: p_rec.maternity_id :=
255: ssp_stp_shd.g_old_rec.maternity_id;
256: End If;
257: If (p_rec.reason_id = hr_api.g_number) then
258: p_rec.reason_id :=
259: ssp_stp_shd.g_old_rec.reason_id;
260: End If;
261: If (p_rec.user_entered = hr_api.g_varchar2) then

Line 261: If (p_rec.user_entered = hr_api.g_varchar2) then

257: If (p_rec.reason_id = hr_api.g_number) then
258: p_rec.reason_id :=
259: ssp_stp_shd.g_old_rec.reason_id;
260: End If;
261: If (p_rec.user_entered = hr_api.g_varchar2) then
262: p_rec.user_entered :=
263: ssp_stp_shd.g_old_rec.user_entered;
264: End If;
265: If (p_rec.override_stoppage = hr_api.g_varchar2) then

Line 265: If (p_rec.override_stoppage = hr_api.g_varchar2) then

261: If (p_rec.user_entered = hr_api.g_varchar2) then
262: p_rec.user_entered :=
263: ssp_stp_shd.g_old_rec.user_entered;
264: End If;
265: If (p_rec.override_stoppage = hr_api.g_varchar2) then
266: p_rec.override_stoppage :=
267: ssp_stp_shd.g_old_rec.override_stoppage;
268: End If;
269: If (p_rec.employee_notified = hr_api.g_varchar2) then

Line 269: If (p_rec.employee_notified = hr_api.g_varchar2) then

265: If (p_rec.override_stoppage = hr_api.g_varchar2) then
266: p_rec.override_stoppage :=
267: ssp_stp_shd.g_old_rec.override_stoppage;
268: End If;
269: If (p_rec.employee_notified = hr_api.g_varchar2) then
270: p_rec.employee_notified :=
271: ssp_stp_shd.g_old_rec.employee_notified;
272: End If;
273: If (p_rec.withhold_from = hr_api.g_date) then

Line 273: If (p_rec.withhold_from = hr_api.g_date) then

269: If (p_rec.employee_notified = hr_api.g_varchar2) then
270: p_rec.employee_notified :=
271: ssp_stp_shd.g_old_rec.employee_notified;
272: End If;
273: If (p_rec.withhold_from = hr_api.g_date) then
274: p_rec.withhold_from :=
275: ssp_stp_shd.g_old_rec.withhold_from;
276: End If;
277: If (p_rec.withhold_to = hr_api.g_date) then

Line 277: If (p_rec.withhold_to = hr_api.g_date) then

273: If (p_rec.withhold_from = hr_api.g_date) then
274: p_rec.withhold_from :=
275: ssp_stp_shd.g_old_rec.withhold_from;
276: End If;
277: If (p_rec.withhold_to = hr_api.g_date) then
278: p_rec.withhold_to :=
279: ssp_stp_shd.g_old_rec.withhold_to;
280: End If;
281: --

Line 341: Raise HR_Api.Validate_Enabled;

337: --
338: -- If we are validating then raise the Validate_Enabled exception
339: --
340: If p_validate then
341: Raise HR_Api.Validate_Enabled;
342: End If;
343: --
344: hr_utility.set_location(' Leaving:'||l_proc, 10);
345: Exception

Line 346: When HR_Api.Validate_Enabled Then

342: End If;
343: --
344: hr_utility.set_location(' Leaving:'||l_proc, 10);
345: Exception
346: When HR_Api.Validate_Enabled Then
347: --
348: -- As the Validate_Enabled exception has been raised
349: -- we must rollback to the savepoint
350: --

Line 361: p_absence_attendance_id in number default hr_api.g_number,

357: Procedure upd
358: (
359: p_stoppage_id in number,
360: p_object_version_number in out number,
361: p_absence_attendance_id in number default hr_api.g_number,
362: p_maternity_id in number default hr_api.g_number,
363: p_reason_id in number default hr_api.g_number,
364: p_user_entered in varchar2 default hr_api.g_varchar2,
365: p_override_stoppage in varchar2 default hr_api.g_varchar2,

Line 362: p_maternity_id in number default hr_api.g_number,

358: (
359: p_stoppage_id in number,
360: p_object_version_number in out number,
361: p_absence_attendance_id in number default hr_api.g_number,
362: p_maternity_id in number default hr_api.g_number,
363: p_reason_id in number default hr_api.g_number,
364: p_user_entered in varchar2 default hr_api.g_varchar2,
365: p_override_stoppage in varchar2 default hr_api.g_varchar2,
366: p_employee_notified in varchar2 default hr_api.g_varchar2,

Line 363: p_reason_id in number default hr_api.g_number,

359: p_stoppage_id in number,
360: p_object_version_number in out number,
361: p_absence_attendance_id in number default hr_api.g_number,
362: p_maternity_id in number default hr_api.g_number,
363: p_reason_id in number default hr_api.g_number,
364: p_user_entered in varchar2 default hr_api.g_varchar2,
365: p_override_stoppage in varchar2 default hr_api.g_varchar2,
366: p_employee_notified in varchar2 default hr_api.g_varchar2,
367: p_withhold_from in date default hr_api.g_date,

Line 364: p_user_entered in varchar2 default hr_api.g_varchar2,

360: p_object_version_number in out number,
361: p_absence_attendance_id in number default hr_api.g_number,
362: p_maternity_id in number default hr_api.g_number,
363: p_reason_id in number default hr_api.g_number,
364: p_user_entered in varchar2 default hr_api.g_varchar2,
365: p_override_stoppage in varchar2 default hr_api.g_varchar2,
366: p_employee_notified in varchar2 default hr_api.g_varchar2,
367: p_withhold_from in date default hr_api.g_date,
368: p_withhold_to in date default hr_api.g_date,

Line 365: p_override_stoppage in varchar2 default hr_api.g_varchar2,

361: p_absence_attendance_id in number default hr_api.g_number,
362: p_maternity_id in number default hr_api.g_number,
363: p_reason_id in number default hr_api.g_number,
364: p_user_entered in varchar2 default hr_api.g_varchar2,
365: p_override_stoppage in varchar2 default hr_api.g_varchar2,
366: p_employee_notified in varchar2 default hr_api.g_varchar2,
367: p_withhold_from in date default hr_api.g_date,
368: p_withhold_to in date default hr_api.g_date,
369: p_validate in boolean default false

Line 366: p_employee_notified in varchar2 default hr_api.g_varchar2,

362: p_maternity_id in number default hr_api.g_number,
363: p_reason_id in number default hr_api.g_number,
364: p_user_entered in varchar2 default hr_api.g_varchar2,
365: p_override_stoppage in varchar2 default hr_api.g_varchar2,
366: p_employee_notified in varchar2 default hr_api.g_varchar2,
367: p_withhold_from in date default hr_api.g_date,
368: p_withhold_to in date default hr_api.g_date,
369: p_validate in boolean default false
370: ) is

Line 367: p_withhold_from in date default hr_api.g_date,

363: p_reason_id in number default hr_api.g_number,
364: p_user_entered in varchar2 default hr_api.g_varchar2,
365: p_override_stoppage in varchar2 default hr_api.g_varchar2,
366: p_employee_notified in varchar2 default hr_api.g_varchar2,
367: p_withhold_from in date default hr_api.g_date,
368: p_withhold_to in date default hr_api.g_date,
369: p_validate in boolean default false
370: ) is
371: --

Line 368: p_withhold_to in date default hr_api.g_date,

364: p_user_entered in varchar2 default hr_api.g_varchar2,
365: p_override_stoppage in varchar2 default hr_api.g_varchar2,
366: p_employee_notified in varchar2 default hr_api.g_varchar2,
367: p_withhold_from in date default hr_api.g_date,
368: p_withhold_to in date default hr_api.g_date,
369: p_validate in boolean default false
370: ) is
371: --
372: l_rec ssp_stp_shd.g_rec_type;