DBA Data[Home] [Help]

APPS.PER_SHA_BUS dependencies on STANDARD

Line 109: -- |----------------------< chk_standard_holiday_id >------------------------|

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

Line 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

Line 114: -- STANDARD_HOLIDAY_ID must exist in PER_STANDARD_HOLIDAYS

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: --

Line 121: -- p_standard_holiday_id

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: --

Line 139: procedure chk_standard_holiday_id

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

Line 141: ,p_standard_holiday_id in per_std_holiday_absences.standard_holiday_id%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: );

Line 152: -- ACTUAL_DATE_TAKEN must not overlap with any of the Standard Holidays

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