APPS.GHR_DUT_BUS dependencies on GHR_DUTY_STATIONS_F

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 117: FROM ghr_duty_stations_f

113: l_dummy_flag varchar2(1);
114:
115: CURSOR c_duty_station_exists is
116: SELECT '1'
117: FROM ghr_duty_stations_f
118: WHERE duty_station_code = p_duty_station_code
119: AND p_effective_date between effective_start_date
120: and effective_end_date;
121: --

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)