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_ERN_UPD dependencies on SSP_ERN_SHD

Line 52: Procedure update_dml(p_rec in out nocopy ssp_ern_shd.g_rec_type) is

48: -- Access Status:
49: -- Internal Table Handler Use Only.
50: --
51: -- ----------------------------------------------------------------------------
52: Procedure update_dml(p_rec in out nocopy ssp_ern_shd.g_rec_type) is
53: --
54: l_proc varchar2(72) := g_package||'update_dml';
55: --
56: Begin

Line 63: ssp_ern_shd.g_api_dml := true; -- Set the api dml status

59: -- Increment the object version
60: --
61: p_rec.object_version_number := p_rec.object_version_number + 1;
62: --
63: ssp_ern_shd.g_api_dml := true; -- Set the api dml status
64: --
65: -- Update the ssp_earnings_calculations Row
66: --
67: update ssp_earnings_calculations

Line 75: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status

71: user_entered = p_rec.user_entered,
72: payment_periods = p_rec.payment_periods
73: where earnings_calculations_id = p_rec.earnings_calculations_id;
74: --
75: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status
76: --
77: hr_utility.set_location('Leaving :'||l_proc, 100);
78: --
79: Exception

Line 82: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status

78: --
79: Exception
80: When hr_api.check_integrity_violated Then
81: -- A check constraint has been violated
82: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status
83: ssp_ern_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.parent_integrity_violated Then
86: -- Parent integrity has been violated

Line 83: ssp_ern_shd.constraint_error

79: Exception
80: When hr_api.check_integrity_violated Then
81: -- A check constraint has been violated
82: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status
83: ssp_ern_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.parent_integrity_violated Then
86: -- Parent integrity has been violated
87: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status

Line 87: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status

83: ssp_ern_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.parent_integrity_violated Then
86: -- Parent integrity has been violated
87: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status
88: ssp_ern_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.unique_integrity_violated Then
91: -- Unique integrity has been violated

Line 88: ssp_ern_shd.constraint_error

84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.parent_integrity_violated Then
86: -- Parent integrity has been violated
87: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status
88: ssp_ern_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.unique_integrity_violated Then
91: -- Unique integrity has been violated
92: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status

Line 92: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status

88: ssp_ern_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.unique_integrity_violated Then
91: -- Unique integrity has been violated
92: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status
93: ssp_ern_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When Others Then
96: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status

Line 93: ssp_ern_shd.constraint_error

89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.unique_integrity_violated Then
91: -- Unique integrity has been violated
92: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status
93: ssp_ern_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When Others Then
96: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status
97: Raise;

Line 96: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status

92: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status
93: ssp_ern_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When Others Then
96: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status
97: Raise;
98: End update_dml;
99: --
100: -- ----------------------------------------------------------------------------

Line 130: Procedure pre_update(p_rec in ssp_ern_shd.g_rec_type) is

126: -- Access Status:
127: -- Internal Table Handler Use Only.
128: --
129: -- ----------------------------------------------------------------------------
130: Procedure pre_update(p_rec in ssp_ern_shd.g_rec_type) is
131: --
132: l_proc varchar2(72) := g_package||'pre_update';
133: --
134: Begin

Line 170: Procedure post_update(p_rec in ssp_ern_shd.g_rec_type) is

166: -- Access Status:
167: -- Internal Table Handler Use Only.
168: --
169: -- ----------------------------------------------------------------------------
170: Procedure post_update(p_rec in ssp_ern_shd.g_rec_type) is
171: --
172: l_proc varchar2(72) := g_package||'post_update';
173: --
174: Begin

Line 222: Procedure convert_defs(p_rec in out nocopy ssp_ern_shd.g_rec_type) is

218: -- Access Status:
219: -- Internal Table Handler Use Only.
220: --
221: -- ----------------------------------------------------------------------------
222: Procedure convert_defs(p_rec in out nocopy ssp_ern_shd.g_rec_type) is
223: --
224: l_proc varchar2(72) := g_package||'convert_defs';
225: --
226: Begin

Line 234: p_rec.person_id := ssp_ern_shd.g_old_rec.person_id;

230: -- to see if a system default is being used. If a system default is being used
231: -- then we must set to the 'current' argument value.
232: --
233: If (p_rec.person_id = hr_api.g_number) then
234: p_rec.person_id := ssp_ern_shd.g_old_rec.person_id;
235: End If;
236: If (p_rec.effective_date = hr_api.g_date) then
237: p_rec.effective_date := ssp_ern_shd.g_old_rec.effective_date;
238: End If;

Line 237: p_rec.effective_date := ssp_ern_shd.g_old_rec.effective_date;

233: If (p_rec.person_id = hr_api.g_number) then
234: p_rec.person_id := ssp_ern_shd.g_old_rec.person_id;
235: End If;
236: If (p_rec.effective_date = hr_api.g_date) then
237: p_rec.effective_date := ssp_ern_shd.g_old_rec.effective_date;
238: End If;
239: If (p_rec.average_earnings_amount = hr_api.g_number) then
240: p_rec.average_earnings_amount :=
241: ssp_ern_shd.g_old_rec.average_earnings_amount;

Line 241: ssp_ern_shd.g_old_rec.average_earnings_amount;

237: p_rec.effective_date := ssp_ern_shd.g_old_rec.effective_date;
238: End If;
239: If (p_rec.average_earnings_amount = hr_api.g_number) then
240: p_rec.average_earnings_amount :=
241: ssp_ern_shd.g_old_rec.average_earnings_amount;
242: End If;
243: If (p_rec.user_entered = hr_api.g_varchar2) then
244: p_rec.user_entered := ssp_ern_shd.g_old_rec.user_entered;
245: End If;

Line 244: p_rec.user_entered := ssp_ern_shd.g_old_rec.user_entered;

240: p_rec.average_earnings_amount :=
241: ssp_ern_shd.g_old_rec.average_earnings_amount;
242: End If;
243: If (p_rec.user_entered = hr_api.g_varchar2) then
244: p_rec.user_entered := ssp_ern_shd.g_old_rec.user_entered;
245: End If;
246: --
247: hr_utility.set_location('Leaving :'||l_proc, 100);
248: --

Line 257: p_rec in out nocopy ssp_ern_shd.g_rec_type,

253: -- ----------------------------------------------------------------------------
254: --
255: Procedure upd
256: (
257: p_rec in out nocopy ssp_ern_shd.g_rec_type,
258: p_validate in boolean default false
259: ) is
260: --
261: l_proc varchar2(72) := g_package||'upd';

Line 277: ssp_ern_shd.lck

273: End If;
274: --
275: -- We must lock the row which we need to update.
276: --
277: ssp_ern_shd.lck
278: (
279: p_rec.earnings_calculations_id,
280: p_rec.object_version_number
281: );

Line 338: l_rec ssp_ern_shd.g_rec_type;

334: p_average_earnings_amount in out nocopy number ,
335: p_validate in boolean default false
336: ) is
337: --
338: l_rec ssp_ern_shd.g_rec_type;
339: l_proc varchar2(72) := g_package||'upd (old)';
340: --
341: Begin
342: hr_utility.set_location('Entering:'||l_proc, 1);

Line 346: l_rec := ssp_ern_shd.convert_args (p_earnings_calculations_id,

342: hr_utility.set_location('Entering:'||l_proc, 1);
343: --
344: -- Call conversion function to turn arguments into the l_rec structure.
345: --
346: l_rec := ssp_ern_shd.convert_args (p_earnings_calculations_id,
347: p_object_version_number,
348: hr_api.g_number,
349: hr_api.g_date,
350: p_average_earnings_amount,

Line 384: l_rec ssp_ern_shd.g_rec_type;

380: p_payment_periods in out nocopy number,
381: p_validate in boolean default false
382: ) is
383: --
384: l_rec ssp_ern_shd.g_rec_type;
385: l_proc varchar2(72) := g_package||'upd';
386: --
387: Begin
388: hr_utility.set_location('Entering:'||l_proc, 1);

Line 392: l_rec := ssp_ern_shd.convert_args (p_earnings_calculations_id,

388: hr_utility.set_location('Entering:'||l_proc, 1);
389: --
390: -- Call conversion function to turn arguments into the l_rec structure.
391: --
392: l_rec := ssp_ern_shd.convert_args (p_earnings_calculations_id,
393: p_object_version_number,
394: hr_api.g_number,
395: hr_api.g_date,
396: p_average_earnings_amount,