DBA Data[Home] [Help]

APPS.PAY_ETU_BUS dependencies on PAY_ETU_SHD

Line 177: ,p_rec in pay_etu_shd.g_rec_type

173: -- {End Of Comments}
174: -- ----------------------------------------------------------------------------
175: Procedure chk_non_updateable_args
176: (p_effective_date in date
177: ,p_rec in pay_etu_shd.g_rec_type
178: ) IS
179: --
180: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
181: l_error EXCEPTION;

Line 189: IF NOT pay_etu_shd.api_updating

185: --
186: -- Only proceed with the validation if a row exists for the current
187: -- record in the HR Schema.
188: --
189: IF NOT pay_etu_shd.api_updating
190: (p_element_type_usage_id => p_rec.element_type_usage_id
191: ,p_effective_date => p_effective_date
192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN

Line 203: nvl(pay_etu_shd.g_old_rec.business_group_id, hr_api.g_number) then

199: --
200: hr_utility.set_location(l_proc, 10);
201: --
202: if nvl(p_rec.business_group_id, hr_api.g_number) <>
203: nvl(pay_etu_shd.g_old_rec.business_group_id, hr_api.g_number) then
204: l_argument := 'business_group_id';
205: raise l_error;
206: end if;
207: hr_utility.set_location(l_proc, 15);

Line 210: nvl(pay_etu_shd.g_old_rec.element_type_usage_id,hr_api.g_number) then

206: end if;
207: hr_utility.set_location(l_proc, 15);
208: --
209: if nvl(p_rec.element_type_usage_id,hr_api.g_number) <>
210: nvl(pay_etu_shd.g_old_rec.element_type_usage_id,hr_api.g_number) then
211: l_argument := 'element_type_usage_id';
212: raise l_error;
213: end if;
214: hr_utility.set_location(l_proc, 20);

Line 217: nvl(pay_etu_shd.g_old_rec.legislation_code,hr_api.g_varchar2) then

213: end if;
214: hr_utility.set_location(l_proc, 20);
215: --
216: if nvl(p_rec.legislation_code,hr_api.g_varchar2) <>
217: nvl(pay_etu_shd.g_old_rec.legislation_code,hr_api.g_varchar2) then
218: l_argument := 'legislation_code';
219: raise l_error;
220: end if;
221: hr_utility.set_location(l_proc, 25);

Line 224: nvl(pay_etu_shd.g_old_rec.element_type_id, hr_api.g_number) then

220: end if;
221: hr_utility.set_location(l_proc, 25);
222: --
223: if nvl(p_rec.element_type_id, hr_api.g_number) <>
224: nvl(pay_etu_shd.g_old_rec.element_type_id, hr_api.g_number) then
225: l_argument := 'element_type_id';
226: raise l_error;
227: end if;
228: hr_utility.set_location(l_proc, 30);

Line 231: nvl(pay_etu_shd.g_old_rec.run_type_id,hr_api.g_number) then

227: end if;
228: hr_utility.set_location(l_proc, 30);
229: --
230: if nvl(p_rec.run_type_id,hr_api.g_number) <>
231: nvl(pay_etu_shd.g_old_rec.run_type_id,hr_api.g_number) then
232: l_argument := 'run_type_id';
233: raise l_error;
234: end if;
235: hr_utility.set_location(l_proc, 35);

Line 239: nvl(pay_etu_shd.g_old_rec.inclusion_flag,hr_api.g_varchar2) then

235: hr_utility.set_location(l_proc, 35);
236: --
237: --commented out as not required
238: /* if nvl(p_rec.inclusion_flag,hr_api.g_varchar2) <>
239: nvl(pay_etu_shd.g_old_rec.inclusion_flag,hr_api.g_varchar2) then
240: l_argument := 'inclusion_flag';
241: raise l_error;
242: end if;
243: hr_utility.set_location(l_proc, 40);

Line 246: nvl(pay_etu_shd.g_old_rec.usage_type,hr_api.g_varchar2) then

242: end if;
243: hr_utility.set_location(l_proc, 40);
244: --
245: if nvl(p_rec.usage_type,hr_api.g_varchar2) <>
246: nvl(pay_etu_shd.g_old_rec.usage_type,hr_api.g_varchar2) then
247: l_argument := 'usage_type';
248: raise l_error;
249: end if;*/
250: hr_utility.set_location(l_proc, 50);

Line 367: nvl(pay_etu_shd.g_old_rec.run_type_id, hr_api.g_number) <>

363: -- primary key value. For update it will be not null. For insert it will be
364: -- null because pre_insert has not been called yet.
365: --
366: IF (((p_element_type_usage_id is not null) and
367: nvl(pay_etu_shd.g_old_rec.run_type_id, hr_api.g_number) <>
368: nvl(p_run_type_id, hr_api.g_number)) or
369: (p_element_type_usage_id is null)) THEN
370: --
371: hr_utility.set_location(l_proc, 10);

Line 584: nvl(pay_etu_shd.g_old_rec.element_type_id, hr_api.g_number) <>

580: -- primary key value. For update it will be not null. For insert it will be
581: -- null because pre_insert has not been called yet.
582: --
583: IF (((p_element_type_usage_id is not null) and
584: nvl(pay_etu_shd.g_old_rec.element_type_id, hr_api.g_number) <>
585: nvl(p_element_type_id, hr_api.g_number)) or
586: (p_element_type_usage_id is null)) THEN
587: --
588: hr_utility.set_location(l_proc, 10);

Line 1071: (p_rec in pay_etu_shd.g_rec_type

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

Line 1127: (p_rec in pay_etu_shd.g_rec_type

1123: -- ----------------------------------------------------------------------------
1124: -- |---------------------------< update_validate >----------------------------|
1125: -- ----------------------------------------------------------------------------
1126: Procedure update_validate
1127: (p_rec in pay_etu_shd.g_rec_type
1128: ,p_effective_date in date
1129: ,p_datetrack_mode in varchar2
1130: ,p_validation_start_date in date
1131: ,p_validation_end_date in date

Line 1203: (p_rec in pay_etu_shd.g_rec_type

1199: -- ----------------------------------------------------------------------------
1200: -- |---------------------------< delete_validate >----------------------------|
1201: -- ----------------------------------------------------------------------------
1202: Procedure delete_validate
1203: (p_rec in pay_etu_shd.g_rec_type
1204: ,p_effective_date in date
1205: ,p_datetrack_mode in varchar2
1206: ,p_validation_start_date in date
1207: ,p_validation_end_date in date

Line 1218: ,pay_etu_shd.g_old_rec.business_group_id

1214: --
1215: -- Call all supporting business operations
1216: --
1217: chk_startup_action(False
1218: ,pay_etu_shd.g_old_rec.business_group_id
1219: ,pay_etu_shd.g_old_rec.legislation_code);
1220: --
1221: dt_delete_validate
1222: (p_datetrack_mode => p_datetrack_mode

Line 1219: ,pay_etu_shd.g_old_rec.legislation_code);

1215: -- Call all supporting business operations
1216: --
1217: chk_startup_action(False
1218: ,pay_etu_shd.g_old_rec.business_group_id
1219: ,pay_etu_shd.g_old_rec.legislation_code);
1220: --
1221: dt_delete_validate
1222: (p_datetrack_mode => p_datetrack_mode
1223: ,p_validation_start_date => p_validation_start_date