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.GHR_PAH_INS dependencies on GHR_PAH_SHD

Line 53: Procedure insert_dml(p_rec in out nocopy ghr_pah_shd.g_rec_type) is

49: -- Internal Row Handler Use Only.
50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml(p_rec in out nocopy ghr_pah_shd.g_rec_type) is
54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin

Line 61: ghr_pah_shd.g_api_dml := true; -- Set the api dml status

57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: --
61: ghr_pah_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: ghr_pa_history
64: --
65: insert into ghr_pa_history

Line 492: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status

488: p_rec.information199,
489: p_rec.information200
490: );
491: --
492: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
493: --
494: hr_utility.set_location(' Leaving:'||l_proc, 10);
495: Exception
496: When hr_api.check_integrity_violated Then

Line 498: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status

494: hr_utility.set_location(' Leaving:'||l_proc, 10);
495: Exception
496: When hr_api.check_integrity_violated Then
497: -- A check constraint has been violated
498: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
499: ghr_pah_shd.constraint_error
500: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
501: When hr_api.parent_integrity_violated Then
502: -- Parent integrity has been violated

Line 499: ghr_pah_shd.constraint_error

495: Exception
496: When hr_api.check_integrity_violated Then
497: -- A check constraint has been violated
498: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
499: ghr_pah_shd.constraint_error
500: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
501: When hr_api.parent_integrity_violated Then
502: -- Parent integrity has been violated
503: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status

Line 503: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status

499: ghr_pah_shd.constraint_error
500: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
501: When hr_api.parent_integrity_violated Then
502: -- Parent integrity has been violated
503: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
504: ghr_pah_shd.constraint_error
505: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
506: When hr_api.unique_integrity_violated Then
507: -- Unique integrity has been violated

Line 504: ghr_pah_shd.constraint_error

500: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
501: When hr_api.parent_integrity_violated Then
502: -- Parent integrity has been violated
503: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
504: ghr_pah_shd.constraint_error
505: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
506: When hr_api.unique_integrity_violated Then
507: -- Unique integrity has been violated
508: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status

Line 508: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status

504: ghr_pah_shd.constraint_error
505: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
506: When hr_api.unique_integrity_violated Then
507: -- Unique integrity has been violated
508: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
509: ghr_pah_shd.constraint_error
510: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
511: When Others Then
512: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status

Line 509: ghr_pah_shd.constraint_error

505: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
506: When hr_api.unique_integrity_violated Then
507: -- Unique integrity has been violated
508: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
509: ghr_pah_shd.constraint_error
510: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
511: When Others Then
512: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
513: Raise;

Line 512: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status

508: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
509: ghr_pah_shd.constraint_error
510: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
511: When Others Then
512: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
513: Raise;
514: End insert_dml;
515: --
516: -- ----------------------------------------------------------------------------

Line 553: Procedure pre_insert(p_rec in out nocopy ghr_pah_shd.g_rec_type) is

549: -- Internal Row Handler Use Only.
550: --
551: -- {End Of Comments}
552: -- ----------------------------------------------------------------------------
553: Procedure pre_insert(p_rec in out nocopy ghr_pah_shd.g_rec_type) is
554: --
555: l_proc varchar2(72) := g_package||'pre_insert';
556: --
557: Cursor C_Sel1 is select ghr_pa_history_s.nextval from sys.dual;

Line 604: Procedure post_insert(p_rec in ghr_pah_shd.g_rec_type) is

600: -- Internal Row Handler Use Only.
601: --
602: -- {End Of Comments}
603: -- ----------------------------------------------------------------------------
604: Procedure post_insert(p_rec in ghr_pah_shd.g_rec_type) is
605: --
606: l_proc varchar2(72) := g_package||'post_insert';
607: --
608: Begin

Line 844: p_rec in out nocopy ghr_pah_shd.g_rec_type

840: -- |---------------------------------< ins >----------------------------------|
841: -- ----------------------------------------------------------------------------
842: Procedure ins
843: (
844: p_rec in out nocopy ghr_pah_shd.g_rec_type
845: ) is
846: --
847: l_proc varchar2(72) := g_package||'ins';
848: --

Line 1087: l_rec ghr_pah_shd.g_rec_type;

1083: p_information199 in varchar2 default null,
1084: p_information200 in varchar2 default null
1085: ) is
1086: --
1087: l_rec ghr_pah_shd.g_rec_type;
1088: l_proc varchar2(72) := g_package||'ins';
1089: --
1090: Begin
1091: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1097: ghr_pah_shd.convert_args

1093: -- Call conversion function to turn arguments into the
1094: -- p_rec structure.
1095: --
1096: l_rec :=
1097: ghr_pah_shd.convert_args
1098: (
1099: null,
1100: p_pa_request_id,
1101: p_process_date,