APPS.BEN_DPNT_EDC_BUS dependencies on BEN_DPNT_EDC_SHD

Line 51: l_api_updating := ben_dpnt_edc_shd.api_updating

47: Begin
48: --
49: hr_utility.set_location('Entering:'||l_proc, 5);
50: --
51: l_api_updating := ben_dpnt_edc_shd.api_updating
52: (p_effective_date => p_effective_date,
53: p_dpnt_eligy_crit_values_id => p_dpnt_eligy_crit_values_id,
54: p_object_version_number => p_object_version_number
55: );

Line 59: <> ben_dpnt_edc_shd.g_old_rec.dpnt_eligy_crit_values_id) then

55: );
56: --
57: if (l_api_updating
58: and nvl(p_dpnt_eligy_crit_values_id,hr_api.g_number)
59: <> ben_dpnt_edc_shd.g_old_rec.dpnt_eligy_crit_values_id) then
60: --
61: -- raise error as PK has changed
62: --
63: ben_dpnt_edc_shd.constraint_error('ben_dpnt_eligy_crit_values_f_PK');

Line 63: ben_dpnt_edc_shd.constraint_error('ben_dpnt_eligy_crit_values_f_PK');

59: <> ben_dpnt_edc_shd.g_old_rec.dpnt_eligy_crit_values_id) then
60: --
61: -- raise error as PK has changed
62: --
63: ben_dpnt_edc_shd.constraint_error('ben_dpnt_eligy_crit_values_f_PK');
64: --
65: elsif not l_api_updating then
66: --
67: --check if PK is NULL

Line 73: ben_dpnt_edc_shd.constraint_error('ben_dpnt_eligy_crit_values_f_PK');

69: if p_dpnt_eligy_crit_values_id is not null then
70: --
71: -- raise error as PK is not null
72: --
73: ben_dpnt_edc_shd.constraint_error('ben_dpnt_eligy_crit_values_f_PK');
74: --
75: end if;
76: --
77: end if;

Line 127: l_api_updating := ben_dpnt_edc_shd.api_updating(

123: begin
124: --
125: hr_utility.set_location('Entering:'||l_proc, 5);
126: --
127: l_api_updating := ben_dpnt_edc_shd.api_updating(
128: p_dpnt_eligy_crit_values_id => p_dpnt_eligy_crit_values_id,
129: p_effective_date => p_effective_date,
130: p_object_version_number => p_object_version_number
131: );

Line 135: <> ben_dpnt_edc_shd.g_old_rec.eligy_criteria_dpnt_id

131: );
132: --
133: if (l_api_updating
134: and nvl(p_eligy_criteria_dpnt_id,hr_api.g_number)
135: <> ben_dpnt_edc_shd.g_old_rec.eligy_criteria_dpnt_id
136: or not l_api_updating) then
137: --
138: open csr_eligy_criteria_dpnt_id;
139: --

Line 148: ben_dpnt_edc_shd.constraint_error('ben_dpnt_eligy_crit_values_fK1');

144: close csr_eligy_criteria_dpnt_id;
145: --
146: --Raise an error
147: --
148: ben_dpnt_edc_shd.constraint_error('ben_dpnt_eligy_crit_values_fK1');
149: --
150: end if;
151: --
152: close csr_eligy_criteria_dpnt_id;

Line 204: l_api_updating := ben_dpnt_edc_shd.api_updating(

200: begin
201: --
202: hr_utility.set_location('Entering:'||l_proc, 5);
203: --
204: l_api_updating := ben_dpnt_edc_shd.api_updating(
205: p_dpnt_eligy_crit_values_id => p_dpnt_eligy_crit_values_id,
206: p_effective_date => p_effective_date,
207: p_object_version_number => p_object_version_number
208: );

Line 212: <> ben_dpnt_edc_shd.g_old_rec.dpnt_cvg_eligy_prfl_id

208: );
209: --
210: if (l_api_updating
211: and nvl(p_dpnt_cvg_eligy_prfl_id,hr_api.g_number)
212: <> ben_dpnt_edc_shd.g_old_rec.dpnt_cvg_eligy_prfl_id
213: or not l_api_updating) then
214: --
215: open csr_eligy_prfl_id;
216: --

Line 224: ben_dpnt_edc_shd.constraint_error('ben_dpnt_eligy_crit_values_fK1');

220: --
221: close csr_eligy_prfl_id;
222: --Raise an error
223: --
224: ben_dpnt_edc_shd.constraint_error('ben_dpnt_eligy_crit_values_fK1');
225: --
226: end if;
227: --
228: close csr_eligy_prfl_id;

Line 861: (p_rec in ben_dpnt_edc_shd.g_rec_type,

857: -- ----------------------------------------------------------------------------
858: -- |---------------------------< insert_validate >----------------------------|
859: -- ----------------------------------------------------------------------------
860: Procedure insert_validate
861: (p_rec in ben_dpnt_edc_shd.g_rec_type,
862: p_effective_date in date,
863: p_datetrack_mode in varchar2,
864: p_validation_start_date in date,
865: p_validation_end_date in date) is

Line 945: (p_rec in ben_dpnt_edc_shd.g_rec_type,

941: -- ----------------------------------------------------------------------------
942: -- |---------------------------< update_validate >----------------------------|
943: -- ----------------------------------------------------------------------------
944: Procedure update_validate
945: (p_rec in ben_dpnt_edc_shd.g_rec_type,
946: p_effective_date in date,
947: p_datetrack_mode in varchar2,
948: p_validation_start_date in date,
949: p_validation_end_date in date) is

Line 1040: (p_rec in ben_dpnt_edc_shd.g_rec_type,

1036: -- ----------------------------------------------------------------------------
1037: -- |---------------------------< delete_validate >-----------------------------|
1038: -- ----------------------------------------------------------------------------
1039: Procedure delete_validate
1040: (p_rec in ben_dpnt_edc_shd.g_rec_type,
1041: p_effective_date in date,
1042: p_datetrack_mode in varchar2,
1043: p_validation_start_date in date,
1044: p_validation_end_date in date) is