APPS.PER_SUB_BUS dependencies on PER_SUBJECTS_TAKEN

Line 54: per_sub_shd.constraint_error('PER_SUBJECTS_TAKEN_PK');

50: <> per_sub_shd.g_old_rec.subjects_taken_id) then
51: --
52: -- raise error as PK has changed
53: --
54: per_sub_shd.constraint_error('PER_SUBJECTS_TAKEN_PK');
55: --
56: elsif not l_api_updating then
57: --
58: -- check if PK is null

Line 64: per_sub_shd.constraint_error('PER_SUBJECTS_TAKEN_PK');

60: if p_subjects_taken_id is not null then
61: --
62: -- raise error as PK is not null
63: --
64: per_sub_shd.constraint_error('PER_SUBJECTS_TAKEN_PK');
65: --
66: end if;
67: --
68: end if;

Line 134: per_sub_shd.constraint_error('PER_SUBJECTS_TAKEN_FK1');

130: fetch c1 into l_dummy;
131: if c1%notfound then
132: --
133: close c1;
134: per_sub_shd.constraint_error('PER_SUBJECTS_TAKEN_FK1');
135: --
136: end if;
137: --
138: close c1;

Line 542: from per_subjects_taken per

538: -- this option must be catered for.
539: --
540: cursor c1 is
541: select null
542: from per_subjects_taken per
543: where per.qualification_id = p_qualification_id
544: and per.subject = p_subject
545: and (p_start_date
546: between per.start_date

Line 551: and per.subjects_taken_id <> nvl(p_subjects_taken_id,-1);

547: and nvl(per.end_date,hr_api.g_eot)
548: or p_end_date
549: between per.start_date
550: and nvl(per.end_date,hr_api.g_eot))
551: and per.subjects_taken_id <> nvl(p_subjects_taken_id,-1);
552: --
553: Begin
554: --
555: hr_utility.set_location('Entering:'||l_proc,5);

Line 701: ,p_descflex_name => 'PER_SUBJECTS_TAKEN'

697: -- b) During insert.
698: --
699: hr_dflex_utility.ins_or_upd_descflex_attribs
700: (p_appl_short_name => 'PER'
701: ,p_descflex_name => 'PER_SUBJECTS_TAKEN'
702: ,p_attribute_category => p_rec.attribute_category
703: ,p_attribute1_name => 'ATTRIBUTE1'
704: ,p_attribute1_value => p_rec.attribute1
705: ,p_attribute2_name => 'ATTRIBUTE2'