DBA Data[Home] [Help]

APPS.PER_SHA_INS dependencies on STANDARD

Line 62: standard_holiday_id,

58: insert into per_std_holiday_absences
59: ( std_holiday_absences_id,
60: date_not_taken,
61: person_id,
62: standard_holiday_id,
63: actual_date_taken,
64: reason,
65: expired,
66: attribute_category,

Line 93: p_rec.standard_holiday_id,

89: Values
90: ( p_rec.std_holiday_absences_id,
91: p_rec.date_not_taken,
92: p_rec.person_id,
93: p_rec.standard_holiday_id,
94: p_rec.actual_date_taken,
95: p_rec.reason,
96: p_rec.expired,
97: p_rec.attribute_category,

Line 240: ,p_standard_holiday_id => p_rec.standard_holiday_id

236: per_sha_rki.after_insert
237: (p_std_holiday_absences_id => p_rec.std_holiday_absences_id
238: ,p_date_not_taken => p_rec.date_not_taken
239: ,p_person_id => p_rec.person_id
240: ,p_standard_holiday_id => p_rec.standard_holiday_id
241: ,p_actual_date_taken => p_rec.actual_date_taken
242: ,p_reason => p_rec.reason
243: ,p_expired => p_rec.expired
244: ,p_attribute_category => p_rec.attribute_category

Line 316: p_standard_holiday_id in number,

312: (
313: p_std_holiday_absences_id out nocopy number,
314: p_date_not_taken in date,
315: p_person_id in number,
316: p_standard_holiday_id in number,
317: p_actual_date_taken in date default null,
318: p_reason in varchar2 default null,
319: p_expired in varchar2 default null,
320: p_attribute_category in varchar2 default null,

Line 359: p_standard_holiday_id,

355: (
356: null,
357: p_date_not_taken,
358: p_person_id,
359: p_standard_holiday_id,
360: p_actual_date_taken,
361: p_reason,
362: p_expired,
363: p_attribute_category,