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_PDS_INS dependencies on PER_PDS_SHD

Line 75: Procedure insert_dml(p_rec in out nocopy per_pds_shd.g_rec_type) is

71: -- Internal Table Handler Use Only.
72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml(p_rec in out nocopy per_pds_shd.g_rec_type) is
76: --
77: l_proc varchar2(72) := g_package||'insert_dml';
78: --
79: Begin

Line 83: per_pds_shd.g_api_dml := true; -- Set the api dml status

79: Begin
80: hr_utility.set_location('Entering:'||l_proc, 5);
81: p_rec.object_version_number := 1; -- Initialise the object version
82: --
83: per_pds_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Insert the row into: per_periods_of_service
86: --
87: insert into per_periods_of_service

Line 238: per_pds_shd.g_api_dml := false; -- Unset the api dml status

234: p_rec.pds_information29,
235: p_rec.pds_information30
236: );
237: --
238: per_pds_shd.g_api_dml := false; -- Unset the api dml status
239: --
240: hr_utility.set_location(' Leaving:'||l_proc, 10);
241: Exception
242: When hr_api.check_integrity_violated Then

Line 244: per_pds_shd.g_api_dml := false; -- Unset the api dml status

240: hr_utility.set_location(' Leaving:'||l_proc, 10);
241: Exception
242: When hr_api.check_integrity_violated Then
243: -- A check constraint has been violated
244: per_pds_shd.g_api_dml := false; -- Unset the api dml status
245: per_pds_shd.constraint_error
246: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
247: When hr_api.parent_integrity_violated Then
248: -- Parent integrity has been violated

Line 245: per_pds_shd.constraint_error

241: Exception
242: When hr_api.check_integrity_violated Then
243: -- A check constraint has been violated
244: per_pds_shd.g_api_dml := false; -- Unset the api dml status
245: per_pds_shd.constraint_error
246: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
247: When hr_api.parent_integrity_violated Then
248: -- Parent integrity has been violated
249: per_pds_shd.g_api_dml := false; -- Unset the api dml status

Line 249: per_pds_shd.g_api_dml := false; -- Unset the api dml status

245: per_pds_shd.constraint_error
246: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
247: When hr_api.parent_integrity_violated Then
248: -- Parent integrity has been violated
249: per_pds_shd.g_api_dml := false; -- Unset the api dml status
250: per_pds_shd.constraint_error
251: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
252: When hr_api.unique_integrity_violated Then
253: -- Unique integrity has been violated

Line 250: per_pds_shd.constraint_error

246: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
247: When hr_api.parent_integrity_violated Then
248: -- Parent integrity has been violated
249: per_pds_shd.g_api_dml := false; -- Unset the api dml status
250: per_pds_shd.constraint_error
251: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
252: When hr_api.unique_integrity_violated Then
253: -- Unique integrity has been violated
254: per_pds_shd.g_api_dml := false; -- Unset the api dml status

Line 254: per_pds_shd.g_api_dml := false; -- Unset the api dml status

250: per_pds_shd.constraint_error
251: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
252: When hr_api.unique_integrity_violated Then
253: -- Unique integrity has been violated
254: per_pds_shd.g_api_dml := false; -- Unset the api dml status
255: per_pds_shd.constraint_error
256: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
257: When Others Then
258: per_pds_shd.g_api_dml := false; -- Unset the api dml status

Line 255: per_pds_shd.constraint_error

251: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
252: When hr_api.unique_integrity_violated Then
253: -- Unique integrity has been violated
254: per_pds_shd.g_api_dml := false; -- Unset the api dml status
255: per_pds_shd.constraint_error
256: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
257: When Others Then
258: per_pds_shd.g_api_dml := false; -- Unset the api dml status
259: Raise;

Line 258: per_pds_shd.g_api_dml := false; -- Unset the api dml status

254: per_pds_shd.g_api_dml := false; -- Unset the api dml status
255: per_pds_shd.constraint_error
256: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
257: When Others Then
258: per_pds_shd.g_api_dml := false; -- Unset the api dml status
259: Raise;
260: End insert_dml;
261: --
262: -- ----------------------------------------------------------------------------

Line 299: Procedure pre_insert(p_rec in out nocopy per_pds_shd.g_rec_type) is

295: -- Internal Table Handler Use Only.
296: --
297: -- {End Of Comments}
298: -- ----------------------------------------------------------------------------
299: Procedure pre_insert(p_rec in out nocopy per_pds_shd.g_rec_type) is
300: --
301: l_proc varchar2(72) := g_package||'pre_insert';
302: --
303: Cursor C_Sel1 is select per_periods_of_service_s.nextval from sys.dual;

Line 350: Procedure post_insert(p_rec in per_pds_shd.g_rec_type,p_effective_date in date) is

346: -- Internal Table Handler Use Only.
347: --
348: -- {End Of Comments}
349: -- ----------------------------------------------------------------------------
350: Procedure post_insert(p_rec in per_pds_shd.g_rec_type,p_effective_date in date) is
351: --
352: l_proc varchar2(72) := g_package||'post_insert';
353: --
354: -- START WWBUG 1390173 fix

Line 489: p_rec in out nocopy per_pds_shd.g_rec_type,

485: -- |---------------------------------< ins >----------------------------------|
486: -- ----------------------------------------------------------------------------
487: Procedure ins
488: (
489: p_rec in out nocopy per_pds_shd.g_rec_type,
490: p_effective_date in date,
491: p_validate in boolean default false,
492: p_validate_df_flex in boolean default true
493: ) is

Line 621: l_rec per_pds_shd.g_rec_type;

617: p_validate in boolean default false,
618: p_validate_df_flex in boolean default true
619: ) is
620: --
621: l_rec per_pds_shd.g_rec_type;
622: l_proc varchar2(72) := g_package||'ins';
623: --
624: Begin
625: hr_utility.set_location('Entering:'||l_proc, 5);

Line 631: per_pds_shd.convert_args

627: -- Call conversion function to turn arguments into the
628: -- p_rec structure.
629: --
630: l_rec :=
631: per_pds_shd.convert_args
632: (
633: null,
634: p_business_group_id,
635: null,