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_DUT_BUS dependencies on GHR_DUT_SHD

Line 48: l_api_updating := ghr_dut_shd.api_updating

44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ghr_dut_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_duty_station_id => p_duty_station_id,
51: p_object_version_number => p_object_version_number);
52: --

Line 55: <> ghr_dut_shd.g_old_rec.duty_station_id) then

51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_duty_station_id,hr_api.g_number)
55: <> ghr_dut_shd.g_old_rec.duty_station_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ghr_dut_shd.constraint_error('GHR_DUTY_STATIONS_F_PK');

Line 59: ghr_dut_shd.constraint_error('GHR_DUTY_STATIONS_F_PK');

55: <> ghr_dut_shd.g_old_rec.duty_station_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ghr_dut_shd.constraint_error('GHR_DUTY_STATIONS_F_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null

Line 69: ghr_dut_shd.constraint_error('GHR_DUTY_STATIONS_F_PK');

65: if p_duty_station_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ghr_dut_shd.constraint_error('GHR_DUTY_STATIONS_F_PK');
70: --
71: end if;
72: --
73: end if;

Line 126: l_api_updating := ghr_dut_shd.api_updating

122: Begin
123: --
124: hr_utility.set_location('Entering:'||l_proc, 5);
125: --
126: l_api_updating := ghr_dut_shd.api_updating
127: (p_effective_date => p_effective_date,
128: p_duty_station_id => p_duty_station_id,
129: p_object_version_number => p_object_version_number);
130: --

Line 133: <> ghr_dut_shd.g_old_rec.duty_station_code) then

129: p_object_version_number => p_object_version_number);
130: --
131: if (l_api_updating
132: and nvl(p_duty_station_code,hr_api.g_number)
133: <> ghr_dut_shd.g_old_rec.duty_station_code) then
134: --
135: -- raise error as UK has changed
136: --
137: ghr_dut_shd.constraint_error('GHR_DUTY_STATIONS_F_UK');

Line 137: ghr_dut_shd.constraint_error('GHR_DUTY_STATIONS_F_UK');

133: <> ghr_dut_shd.g_old_rec.duty_station_code) then
134: --
135: -- raise error as UK has changed
136: --
137: ghr_dut_shd.constraint_error('GHR_DUTY_STATIONS_F_UK');
138: --
139: elsif not l_api_updating then
140: --
141: -- check if duty_station_code already exists

Line 147: ghr_dut_shd.constraint_error('GHR_DUTY_STATIONS_F_UK');

143: open c_duty_station_exists;
144: fetch c_duty_station_exists into l_dummy_flag;
145: close c_duty_station_exists;
146: IF l_dummy_flag = '1' Then
147: ghr_dut_shd.constraint_error('GHR_DUTY_STATIONS_F_UK');
148: End If;
149: --
150: -- check for cpdf edit#120.00.1. If first 2 characters of dutystation code are alphabets,
151: -- then last 3 characters should be zeroes(000)

Line 211: l_api_updating := ghr_dut_shd.api_updating

207: Begin
208: --
209: hr_utility.set_location('Entering:'||l_proc, 5);
210: --
211: l_api_updating := ghr_dut_shd.api_updating
212: (p_effective_date => p_effective_date,
213: p_duty_station_id => p_duty_station_id,
214: p_object_version_number => p_object_version_number);
215: --

Line 217: nvl(p_is_duty_station,hr_api.g_varchar2) <> ghr_dut_shd.g_old_rec.is_duty_station)

213: p_duty_station_id => p_duty_station_id,
214: p_object_version_number => p_object_version_number);
215: --
216: if ( (l_api_updating and
217: nvl(p_is_duty_station,hr_api.g_varchar2) <> ghr_dut_shd.g_old_rec.is_duty_station)
218: OR not l_api_updating
219: ) then
220: --
221: IF p_is_duty_station = 'Y'

Line 471: (p_rec in ghr_dut_shd.g_rec_type,

467: -- ----------------------------------------------------------------------------
468: -- |---------------------------< insert_validate >----------------------------|
469: -- ----------------------------------------------------------------------------
470: Procedure insert_validate
471: (p_rec in ghr_dut_shd.g_rec_type,
472: p_effective_date in date,
473: p_datetrack_mode in varchar2,
474: p_validation_start_date in date,
475: p_validation_end_date in date) is

Line 509: (p_rec in ghr_dut_shd.g_rec_type,

505: -- ----------------------------------------------------------------------------
506: -- |---------------------------< update_validate >----------------------------|
507: -- ----------------------------------------------------------------------------
508: Procedure update_validate
509: (p_rec in ghr_dut_shd.g_rec_type,
510: p_effective_date in date,
511: p_datetrack_mode in varchar2,
512: p_validation_start_date in date,
513: p_validation_end_date in date) is

Line 546: (p_rec in ghr_dut_shd.g_rec_type,

542: -- ----------------------------------------------------------------------------
543: -- |---------------------------< delete_validate >----------------------------|
544: -- ----------------------------------------------------------------------------
545: Procedure delete_validate
546: (p_rec in ghr_dut_shd.g_rec_type,
547: p_effective_date in date,
548: p_datetrack_mode in varchar2,
549: p_validation_start_date in date,
550: p_validation_end_date in date) is