105: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
106: );
107: --
108: -- ---------------------------------------------------------------------------
109: -- |----------------------< chk_standard_holiday_id >------------------------|
110: -- ---------------------------------------------------------------------------
111: --
112: -- Desciption :
113: -- STANDARD_HOLIDAY_ID is mandatory
109: -- |----------------------< chk_standard_holiday_id >------------------------|
110: -- ---------------------------------------------------------------------------
111: --
112: -- Desciption :
113: -- STANDARD_HOLIDAY_ID is mandatory
114: -- STANDARD_HOLIDAY_ID must exist in PER_STANDARD_HOLIDAYS
115: --
116: -- Pre-conditions :
117: -- None
110: -- ---------------------------------------------------------------------------
111: --
112: -- Desciption :
113: -- STANDARD_HOLIDAY_ID is mandatory
114: -- STANDARD_HOLIDAY_ID must exist in PER_STANDARD_HOLIDAYS
115: --
116: -- Pre-conditions :
117: -- None
118: --
117: -- None
118: --
119: -- In Arguments :
120: -- p_std_holiday_absences_id
121: -- p_standard_holiday_id
122: -- p_actual_date_taken
123: -- p_expired
124: -- p_object_version_number
125: --
135: --
136: -- {End of Comments}
137: --
138: -- ---------------------------------------------------------------------------
139: procedure chk_standard_holiday_id
140: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
141: ,p_standard_holiday_id in per_std_holiday_absences.standard_holiday_id%TYPE
142: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
143: ,p_expired in per_std_holiday_absences.expired%TYPE
137: --
138: -- ---------------------------------------------------------------------------
139: procedure chk_standard_holiday_id
140: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
141: ,p_standard_holiday_id in per_std_holiday_absences.standard_holiday_id%TYPE
142: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
143: ,p_expired in per_std_holiday_absences.expired%TYPE
144: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
145: );
148: -- |-----------------------< chk_actual_date_taken >-------------------------|
149: -- ---------------------------------------------------------------------------
150: --
151: -- Desciption :
152: -- ACTUAL_DATE_TAKEN must not overlap with any of the Standard Holidays
153: -- defined for the current Legislation/Sub-legislation
154: --
155: -- Pre-conditions :
156: -- None