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
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;
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: --
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
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)