APPS.BEN_ECV_BUS dependencies on BEN_ECV_SHD

Line 51: l_api_updating := ben_ecv_shd.api_updating

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

Line 59: <> ben_ecv_shd.g_old_rec.eligy_crit_values_id) then

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

Line 63: ben_ecv_shd.constraint_error('BEN_ELIGY_CRIT_VALUES_F_PK');

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

Line 73: ben_ecv_shd.constraint_error('BEN_ELIGY_CRIT_VALUES_F_PK');

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

Line 127: l_api_updating := ben_ecv_shd.api_updating(

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

Line 135: <> ben_ecv_shd.g_old_rec.eligy_criteria_id

131: );
132: --
133: if (l_api_updating
134: and nvl(p_eligy_criteria_id,hr_api.g_number)
135: <> ben_ecv_shd.g_old_rec.eligy_criteria_id
136: or not l_api_updating) then
137: --
138: open csr_eligy_criteria_id;
139: --

Line 148: ben_ecv_shd.constraint_error('BEN_ELIGY_CRIT_VALUES_FK1');

144: close csr_eligy_criteria_id;
145: --
146: --Raise an error
147: --
148: ben_ecv_shd.constraint_error('BEN_ELIGY_CRIT_VALUES_FK1');
149: --
150: end if;
151: --
152: close csr_eligy_criteria_id;

Line 204: l_api_updating := ben_ecv_shd.api_updating(

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

Line 212: <> ben_ecv_shd.g_old_rec.eligy_prfl_id

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

Line 224: ben_ecv_shd.constraint_error('BEN_ELIGY_CRIT_VALUES_FK1');

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

Line 1070: (p_rec in ben_ecv_shd.g_rec_type,

1066: -- ----------------------------------------------------------------------------
1067: -- |---------------------------< insert_validate >----------------------------|
1068: -- ----------------------------------------------------------------------------
1069: Procedure insert_validate
1070: (p_rec in ben_ecv_shd.g_rec_type,
1071: p_effective_date in date,
1072: p_datetrack_mode in varchar2,
1073: p_validation_start_date in date,
1074: p_validation_end_date in date) is

Line 1154: (p_rec in ben_ecv_shd.g_rec_type,

1150: -- ----------------------------------------------------------------------------
1151: -- |---------------------------< update_validate >----------------------------|
1152: -- ----------------------------------------------------------------------------
1153: Procedure update_validate
1154: (p_rec in ben_ecv_shd.g_rec_type,
1155: p_effective_date in date,
1156: p_datetrack_mode in varchar2,
1157: p_validation_start_date in date,
1158: p_validation_end_date in date) is

Line 1249: (p_rec in ben_ecv_shd.g_rec_type,

1245: -- ----------------------------------------------------------------------------
1246: -- |---------------------------< delete_validate >-----------------------------|
1247: -- ----------------------------------------------------------------------------
1248: Procedure delete_validate
1249: (p_rec in ben_ecv_shd.g_rec_type,
1250: p_effective_date in date,
1251: p_datetrack_mode in varchar2,
1252: p_validation_start_date in date,
1253: p_validation_end_date in date) is