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_EST_BUS dependencies on PER_ESTABLISHMENTS

Line 49: from per_establishments a

45: -- location.
46: --
47: cursor c1 is
48: select null
49: from per_establishments a
50: where a.name = p_name
51: and a.location = p_location;
52: --
53: begin

Line 99: per_est_shd.constraint_error('PER_ESTABLISHMENTS_UK');

95: --
96: -- raise error as name and location exists
97: --
98: close c1;
99: per_est_shd.constraint_error('PER_ESTABLISHMENTS_UK');
100: --
101: end if;
102: --
103: close c1;

Line 153: per_est_shd.constraint_error('PER_ESTABLISHMENTS_PK');

149: if p_establishment_id is not null then
150: --
151: -- raise error as establishment id is a not null value
152: --
153: per_est_shd.constraint_error('PER_ESTABLISHMENTS_PK');
154: --
155: end if;
156: --
157: elsif (l_api_updating

Line 163: per_est_shd.constraint_error('PER_ESTABLISHMENTS_PK');

159: <> per_est_shd.g_old_rec.establishment_id) then
160: --
161: -- raise error as PK has been updated
162: --
163: per_est_shd.constraint_error('PER_ESTABLISHMENTS_PK');
164: --
165: end if;
166: --
167: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 318: ,p_descflex_name => 'PER_ESTABLISHMENTS'

314: -- b) During insert.
315: --
316: hr_dflex_utility.ins_or_upd_descflex_attribs
317: (p_appl_short_name => 'PER'
318: ,p_descflex_name => 'PER_ESTABLISHMENTS'
319: ,p_attribute_category => p_rec.attribute_category
320: ,p_attribute1_name => 'ATTRIBUTE1'
321: ,p_attribute1_value => p_rec.attribute1
322: ,p_attribute2_name => 'ATTRIBUTE2'