APPS.PER_PDS_SHD dependencies on PER_PERIODS_OF_SERVICE

Line 36: If (p_constraint_name = 'PER_PERIODS_OF_SERVICE_FK1') Then

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PER_PERIODS_OF_SERVICE_FK1') Then
37: --
38: -- The business_group_id is invalid
39: --
40: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

Line 42: ElsIf (p_constraint_name = 'PER_PERIODS_OF_SERVICE_PK') Then

38: -- The business_group_id is invalid
39: --
40: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
41: --
42: ElsIf (p_constraint_name = 'PER_PERIODS_OF_SERVICE_PK') Then
43: --
44: -- The primary key is not unique
45: --
46: hr_utility.set_message(801, 'HR_7391_ASG_INV_PERIOD_OF_SERV');

Line 175: from per_periods_of_service pds

171: pds_information27,
172: pds_information28,
173: pds_information29,
174: pds_information30
175: from per_periods_of_service pds
176: where pds.period_of_service_id = p_period_of_service_id;
177: --
178: l_proc varchar2(72) := g_package||'api_updating';
179: l_fct_ret boolean;

Line 318: from per_periods_of_service pds

314: pds_information27,
315: pds_information28,
316: pds_information29,
317: pds_information30
318: from per_periods_of_service pds
319: where pds.period_of_service_id = p_period_of_service_id
320: for update nowait;
321: --
322: l_proc varchar2(72) := g_package||'lck';

Line 382: hr_utility.set_message_token('TABLE_NAME', 'per_periods_of_service');

378: -- The object is locked therefore we need to supply a meaningful
379: -- error message.
380: --
381: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
382: hr_utility.set_message_token('TABLE_NAME', 'per_periods_of_service');
383: hr_utility.raise_error;
384: End lck;
385: --
386: -- ----------------------------------------------------------------------------