DBA Data[Home] [Help]

APPS.PER_SHA_UPD dependencies on STANDARD

Line 66: standard_holiday_id = p_rec.standard_holiday_id,

62: set
63: std_holiday_absences_id = p_rec.std_holiday_absences_id,
64: date_not_taken = p_rec.date_not_taken,
65: person_id = p_rec.person_id,
66: standard_holiday_id = p_rec.standard_holiday_id,
67: actual_date_taken = p_rec.actual_date_taken,
68: reason = p_rec.reason,
69: expired = p_rec.expired,
70: attribute_category = p_rec.attribute_category,

Line 201: ,p_standard_holiday_id => p_rec.standard_holiday_id

197: per_sha_rku.after_update
198: (p_std_holiday_absences_id => p_rec.std_holiday_absences_id
199: ,p_date_not_taken => p_rec.date_not_taken
200: ,p_person_id => p_rec.person_id
201: ,p_standard_holiday_id => p_rec.standard_holiday_id
202: ,p_actual_date_taken => p_rec.actual_date_taken
203: ,p_reason => p_rec.reason
204: ,p_expired => p_rec.expired
205: ,p_attribute_category => p_rec.attribute_category

Line 229: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id

225: ,p_attribute20 => p_rec.attribute20
226: ,p_object_version_number => p_rec.object_version_number
227: ,p_date_not_taken_o => per_sha_shd.g_old_rec.date_not_taken
228: ,p_person_id_o => per_sha_shd.g_old_rec.person_id
229: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
230: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
231: ,p_reason_o => per_sha_shd.g_old_rec.reason
232: ,p_expired_o => per_sha_shd.g_old_rec.expired
233: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category

Line 332: If (p_rec.standard_holiday_id = hr_api.g_number) then

328: If (p_rec.person_id = hr_api.g_number) then
329: p_rec.person_id :=
330: per_sha_shd.g_old_rec.person_id;
331: End If;
332: If (p_rec.standard_holiday_id = hr_api.g_number) then
333: p_rec.standard_holiday_id :=
334: per_sha_shd.g_old_rec.standard_holiday_id;
335: End If;
336: If (p_rec.actual_date_taken = hr_api.g_date) then

Line 333: p_rec.standard_holiday_id :=

329: p_rec.person_id :=
330: per_sha_shd.g_old_rec.person_id;
331: End If;
332: If (p_rec.standard_holiday_id = hr_api.g_number) then
333: p_rec.standard_holiday_id :=
334: per_sha_shd.g_old_rec.standard_holiday_id;
335: End If;
336: If (p_rec.actual_date_taken = hr_api.g_date) then
337: p_rec.actual_date_taken :=

Line 334: per_sha_shd.g_old_rec.standard_holiday_id;

330: per_sha_shd.g_old_rec.person_id;
331: End If;
332: If (p_rec.standard_holiday_id = hr_api.g_number) then
333: p_rec.standard_holiday_id :=
334: per_sha_shd.g_old_rec.standard_holiday_id;
335: End If;
336: If (p_rec.actual_date_taken = hr_api.g_date) then
337: p_rec.actual_date_taken :=
338: per_sha_shd.g_old_rec.actual_date_taken;

Line 489: p_standard_holiday_id in number default hr_api.g_number,

485: (
486: p_std_holiday_absences_id in number,
487: p_date_not_taken in date default hr_api.g_date,
488: p_person_id in number default hr_api.g_number,
489: p_standard_holiday_id in number default hr_api.g_number,
490: p_actual_date_taken in date default hr_api.g_date,
491: p_reason in varchar2 default hr_api.g_varchar2,
492: p_expired in varchar2 default hr_api.g_varchar2,
493: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 532: p_standard_holiday_id,

528: (
529: p_std_holiday_absences_id,
530: p_date_not_taken,
531: p_person_id,
532: p_standard_holiday_id,
533: p_actual_date_taken,
534: p_reason,
535: p_expired,
536: p_attribute_category,