APPS.BEN_QTR_BUS dependencies on BEN_QTR_SHD

Line 49: l_api_updating := ben_qtr_shd.api_updating

45: Begin
46: --
47: hr_utility.set_location('Entering:'||l_proc, 5);
48: --
49: l_api_updating := ben_qtr_shd.api_updating
50: (p_effective_date => p_effective_date,
51: p_qual_titl_rt_id => p_qual_titl_rt_id,
52: p_object_version_number => p_object_version_number);
53: --

Line 56: <> ben_qtr_shd.g_old_rec.qual_titl_rt_id) then

52: p_object_version_number => p_object_version_number);
53: --
54: if (l_api_updating
55: and nvl(p_qual_titl_rt_id,hr_api.g_number)
56: <> ben_qtr_shd.g_old_rec.qual_titl_rt_id) then
57: --
58: -- raise error as PK has changed
59: --
60: ben_qtr_shd.constraint_error('BEN_qual_titl_rt_F_PK');

Line 60: ben_qtr_shd.constraint_error('BEN_qual_titl_rt_F_PK');

56: <> ben_qtr_shd.g_old_rec.qual_titl_rt_id) then
57: --
58: -- raise error as PK has changed
59: --
60: ben_qtr_shd.constraint_error('BEN_qual_titl_rt_F_PK');
61: --
62: elsif not l_api_updating then
63: --
64: -- check if PK is null

Line 70: ben_qtr_shd.constraint_error('BEN_qual_titl_rt_F_PK');

66: if p_qual_titl_rt_id is not null then
67: --
68: -- raise error as PK is not null
69: --
70: ben_qtr_shd.constraint_error('BEN_qual_titl_rt_F_PK');
71: --
72: end if;
73: --
74: end if;

Line 118: l_api_updating := ben_qtr_shd.api_updating

114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc, 5);
117: --
118: l_api_updating := ben_qtr_shd.api_updating
119: (p_qual_titl_rt_id => p_qual_titl_rt_id,
120: p_effective_date => p_effective_date,
121: p_object_version_number => p_object_version_number);
122: --

Line 125: <> nvl(ben_qtr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and p_excld_flag
125: <> nvl(ben_qtr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
126: or not l_api_updating) then
127: --
128: -- check if value of lookup falls within lookup type.
129: --

Line 196: l_api_updating := ben_qtr_shd.api_updating

192: Begin
193: --
194: hr_utility.set_location('Entering:'||l_proc,5);
195: --
196: l_api_updating := ben_qtr_shd.api_updating
197: (p_qual_titl_rt_id => p_qual_titl_rt_id,
198: p_effective_date => p_effective_date,
199: p_object_version_number => p_object_version_number);
200: --

Line 203: <> nvl(ben_qtr_shd.g_old_rec.qualification_type_id,hr_api.g_number)

199: p_object_version_number => p_object_version_number);
200: --
201: if (l_api_updating
202: and nvl(p_qualification_type_id,hr_api.g_number)
203: <> nvl(ben_qtr_shd.g_old_rec.qualification_type_id,hr_api.g_number)
204: or not l_api_updating)
205: and p_qualification_type_id is not null then
206: --
207: -- check if qualification_type_id value exists in

Line 220: ben_qtr_shd.constraint_error('BEN_qual_titl_rt_F_FK2');

216: --
217: -- raise error as FK does not relate to PK in
218: -- per_absence_attendance_types table.
219: --
220: ben_qtr_shd.constraint_error('BEN_qual_titl_rt_F_FK2');
221: --
222: end if;
223: --
224: close c1;

Line 584: (p_rec in ben_qtr_shd.g_rec_type,

580: -- ----------------------------------------------------------------------------
581: -- |---------------------------< insert_validate >----------------------------|
582: -- ----------------------------------------------------------------------------
583: Procedure insert_validate
584: (p_rec in ben_qtr_shd.g_rec_type,
585: p_effective_date in date,
586: p_datetrack_mode in varchar2,
587: p_validation_start_date in date,
588: p_validation_end_date in date) is

Line 644: (p_rec in ben_qtr_shd.g_rec_type,

640: -- ----------------------------------------------------------------------------
641: -- |---------------------------< update_validate >----------------------------|
642: -- ----------------------------------------------------------------------------
643: Procedure update_validate
644: (p_rec in ben_qtr_shd.g_rec_type,
645: p_effective_date in date,
646: p_datetrack_mode in varchar2,
647: p_validation_start_date in date,
648: p_validation_end_date in date) is

Line 711: (p_rec in ben_qtr_shd.g_rec_type,

707: -- ----------------------------------------------------------------------------
708: -- |---------------------------< delete_validate >----------------------------|
709: -- ----------------------------------------------------------------------------
710: Procedure delete_validate
711: (p_rec in ben_qtr_shd.g_rec_type,
712: p_effective_date in date,
713: p_datetrack_mode in varchar2,
714: p_validation_start_date in date,
715: p_validation_end_date in date) is