DBA Data[Home] [Help]

APPS.PER_SHA_BUS dependencies on PER_STD_HOLIDAY_ABSENCES

Line 65: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE

61: -- {End of Comments}
62: --
63: -- ---------------------------------------------------------------------------
64: procedure chk_date_not_taken
65: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
66: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
67: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
68: ,p_expired in per_std_holiday_absences.expired%TYPE
69: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE

Line 66: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE

62: --
63: -- ---------------------------------------------------------------------------
64: procedure chk_date_not_taken
65: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
66: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
67: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
68: ,p_expired in per_std_holiday_absences.expired%TYPE
69: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
70: );

Line 67: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE

63: -- ---------------------------------------------------------------------------
64: procedure chk_date_not_taken
65: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
66: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
67: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
68: ,p_expired in per_std_holiday_absences.expired%TYPE
69: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
70: );
71: --

Line 68: ,p_expired in per_std_holiday_absences.expired%TYPE

64: procedure chk_date_not_taken
65: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
66: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
67: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
68: ,p_expired in per_std_holiday_absences.expired%TYPE
69: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
70: );
71: --
72: -- ---------------------------------------------------------------------------

Line 69: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE

65: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
66: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
67: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
68: ,p_expired in per_std_holiday_absences.expired%TYPE
69: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
70: );
71: --
72: -- ---------------------------------------------------------------------------
73: -- |---------------------------< chk_person_id >-----------------------------|

Line 103: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE

99: -- {End of Comments}
100: --
101: -- ---------------------------------------------------------------------------
102: procedure chk_person_id
103: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
104: ,p_person_id in per_std_holiday_absences.person_id%TYPE
105: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
106: );
107: --

Line 104: ,p_person_id in per_std_holiday_absences.person_id%TYPE

100: --
101: -- ---------------------------------------------------------------------------
102: procedure chk_person_id
103: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
104: ,p_person_id in per_std_holiday_absences.person_id%TYPE
105: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
106: );
107: --
108: -- ---------------------------------------------------------------------------

Line 105: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE

101: -- ---------------------------------------------------------------------------
102: procedure chk_person_id
103: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
104: ,p_person_id in per_std_holiday_absences.person_id%TYPE
105: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
106: );
107: --
108: -- ---------------------------------------------------------------------------
109: -- |----------------------< chk_standard_holiday_id >------------------------|

Line 140: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE

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
144: ,p_object_version_number in per_std_holiday_absences.object_version_number%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 142: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE

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: );
146: --

Line 143: ,p_expired in per_std_holiday_absences.expired%TYPE

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: );
146: --
147: -- ---------------------------------------------------------------------------

Line 144: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE

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: );
146: --
147: -- ---------------------------------------------------------------------------
148: -- |-----------------------< chk_actual_date_taken >-------------------------|

Line 179: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE

175: -- {End of Comments}
176: --
177: -- ---------------------------------------------------------------------------
178: procedure chk_actual_date_taken
179: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
180: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
181: ,p_person_id in per_std_holiday_absences.person_id%TYPE
182: ,p_expired in per_std_holiday_absences.expired%TYPE
183: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE

Line 180: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE

176: --
177: -- ---------------------------------------------------------------------------
178: procedure chk_actual_date_taken
179: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
180: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
181: ,p_person_id in per_std_holiday_absences.person_id%TYPE
182: ,p_expired in per_std_holiday_absences.expired%TYPE
183: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
184: );

Line 181: ,p_person_id in per_std_holiday_absences.person_id%TYPE

177: -- ---------------------------------------------------------------------------
178: procedure chk_actual_date_taken
179: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
180: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
181: ,p_person_id in per_std_holiday_absences.person_id%TYPE
182: ,p_expired in per_std_holiday_absences.expired%TYPE
183: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
184: );
185: --

Line 182: ,p_expired in per_std_holiday_absences.expired%TYPE

178: procedure chk_actual_date_taken
179: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
180: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
181: ,p_person_id in per_std_holiday_absences.person_id%TYPE
182: ,p_expired in per_std_holiday_absences.expired%TYPE
183: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
184: );
185: --
186: -- ---------------------------------------------------------------------------

Line 183: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE

179: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
180: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
181: ,p_person_id in per_std_holiday_absences.person_id%TYPE
182: ,p_expired in per_std_holiday_absences.expired%TYPE
183: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
184: );
185: --
186: -- ---------------------------------------------------------------------------
187: -- |-----------------------------< chk_expired >-----------------------------|

Line 216: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE

212: -- {End of Comments}
213: --
214: -- ---------------------------------------------------------------------------
215: procedure chk_expired
216: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
217: ,p_expired in per_std_holiday_absences.expired%TYPE
218: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
219: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
220: );

Line 217: ,p_expired in per_std_holiday_absences.expired%TYPE

213: --
214: -- ---------------------------------------------------------------------------
215: procedure chk_expired
216: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
217: ,p_expired in per_std_holiday_absences.expired%TYPE
218: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
219: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
220: );
221: --

Line 218: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE

214: -- ---------------------------------------------------------------------------
215: procedure chk_expired
216: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
217: ,p_expired in per_std_holiday_absences.expired%TYPE
218: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
219: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
220: );
221: --
222: -- ----------------------------------------------------------------------------

Line 219: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE

215: procedure chk_expired
216: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
217: ,p_expired in per_std_holiday_absences.expired%TYPE
218: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
219: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
220: );
221: --
222: -- ----------------------------------------------------------------------------
223: -- |---------------------------< insert_validate >----------------------------|