84: ,p_per_information9 in varchar2 default null
85: ,p_per_information10 in varchar2 default null
86: );
87: PROCEDURE previous_employer_validate
88: (p_employer_name IN varchar2 default hr_api.g_varchar2
89: ,p_start_date IN date default hr_api.g_date
90: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
91: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
92: );
85: ,p_per_information10 in varchar2 default null
86: );
87: PROCEDURE previous_employer_validate
88: (p_employer_name IN varchar2 default hr_api.g_varchar2
89: ,p_start_date IN date default hr_api.g_date
90: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
91: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
92: );
93: PROCEDURE contract_validate
86: );
87: PROCEDURE previous_employer_validate
88: (p_employer_name IN varchar2 default hr_api.g_varchar2
89: ,p_start_date IN date default hr_api.g_date
90: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
91: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
92: );
93: PROCEDURE contract_validate
94: (p_effective_date in date
87: PROCEDURE previous_employer_validate
88: (p_employer_name IN varchar2 default hr_api.g_varchar2
89: ,p_start_date IN date default hr_api.g_date
90: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
91: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
92: );
93: PROCEDURE contract_validate
94: (p_effective_date in date
95: ,p_type in varchar2
104: ,p_ctr_information5 in varchar2 default null
105: );
106: PROCEDURE periods_of_service_validate
107: (p_period_of_service_id IN number
108: ,p_pds_information_category IN varchar2 default hr_api.g_varchar2
109: ,p_pds_information1 IN varchar2 default hr_api.g_varchar2
110: );
111: PROCEDURE person_eit_validate
112: (p_pei_information_category IN varchar2 default hr_api.g_varchar2
105: );
106: PROCEDURE periods_of_service_validate
107: (p_period_of_service_id IN number
108: ,p_pds_information_category IN varchar2 default hr_api.g_varchar2
109: ,p_pds_information1 IN varchar2 default hr_api.g_varchar2
110: );
111: PROCEDURE person_eit_validate
112: (p_pei_information_category IN varchar2 default hr_api.g_varchar2
113: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
108: ,p_pds_information_category IN varchar2 default hr_api.g_varchar2
109: ,p_pds_information1 IN varchar2 default hr_api.g_varchar2
110: );
111: PROCEDURE person_eit_validate
112: (p_pei_information_category IN varchar2 default hr_api.g_varchar2
113: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
114: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
115: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
116: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
109: ,p_pds_information1 IN varchar2 default hr_api.g_varchar2
110: );
111: PROCEDURE person_eit_validate
112: (p_pei_information_category IN varchar2 default hr_api.g_varchar2
113: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
114: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
115: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
116: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
117: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
110: );
111: PROCEDURE person_eit_validate
112: (p_pei_information_category IN varchar2 default hr_api.g_varchar2
113: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
114: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
115: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
116: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
117: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
118: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
111: PROCEDURE person_eit_validate
112: (p_pei_information_category IN varchar2 default hr_api.g_varchar2
113: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
114: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
115: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
116: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
117: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
118: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
119: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
112: (p_pei_information_category IN varchar2 default hr_api.g_varchar2
113: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
114: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
115: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
116: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
117: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
118: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
119: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
120: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
113: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
114: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
115: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
116: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
117: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
118: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
119: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
120: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
121: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
114: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
115: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
116: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
117: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
118: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
119: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
120: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
121: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
122: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
115: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
116: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
117: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
118: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
119: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
120: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
121: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
122: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
123: );
116: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
117: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
118: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
119: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
120: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
121: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
122: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
123: );
124: PROCEDURE create_person_eit_validate
117: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
118: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
119: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
120: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
121: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
122: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
123: );
124: PROCEDURE create_person_eit_validate
125: (p_person_id IN number
118: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
119: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
120: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
121: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
122: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
123: );
124: PROCEDURE create_person_eit_validate
125: (p_person_id IN number
126: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
122: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
123: );
124: PROCEDURE create_person_eit_validate
125: (p_person_id IN number
126: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
127: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
128: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
129: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
130: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
123: );
124: PROCEDURE create_person_eit_validate
125: (p_person_id IN number
126: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
127: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
128: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
129: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
130: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
131: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
124: PROCEDURE create_person_eit_validate
125: (p_person_id IN number
126: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
127: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
128: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
129: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
130: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
131: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
132: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
125: (p_person_id IN number
126: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
127: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
128: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
129: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
130: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
131: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
132: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
133: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
126: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
127: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
128: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
129: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
130: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
131: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
132: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
133: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
134: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
127: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
128: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
129: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
130: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
131: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
132: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
133: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
134: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
135: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
128: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
129: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
130: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
131: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
132: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
133: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
134: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
135: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
136: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
129: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
130: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
131: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
132: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
133: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
134: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
135: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
136: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
137: );
130: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
131: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
132: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
133: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
134: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
135: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
136: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
137: );
138: PROCEDURE update_person_eit_validate
131: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
132: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
133: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
134: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
135: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
136: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
137: );
138: PROCEDURE update_person_eit_validate
139: (p_person_extra_info_id IN number
132: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
133: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
134: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
135: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
136: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
137: );
138: PROCEDURE update_person_eit_validate
139: (p_person_extra_info_id IN number
140: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
136: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
137: );
138: PROCEDURE update_person_eit_validate
139: (p_person_extra_info_id IN number
140: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
141: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
142: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
143: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
144: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
137: );
138: PROCEDURE update_person_eit_validate
139: (p_person_extra_info_id IN number
140: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
141: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
142: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
143: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
144: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
145: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
138: PROCEDURE update_person_eit_validate
139: (p_person_extra_info_id IN number
140: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
141: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
142: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
143: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
144: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
145: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
146: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
139: (p_person_extra_info_id IN number
140: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
141: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
142: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
143: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
144: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
145: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
146: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
147: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
140: ,p_pei_information_category IN varchar2 default hr_api.g_varchar2
141: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
142: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
143: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
144: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
145: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
146: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
147: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
148: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
141: ,p_pei_information1 IN varchar2 default hr_api.g_varchar2
142: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
143: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
144: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
145: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
146: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
147: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
148: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
149: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
142: ,p_pei_information2 IN varchar2 default hr_api.g_varchar2
143: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
144: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
145: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
146: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
147: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
148: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
149: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
150: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
143: ,p_pei_information3 IN varchar2 default hr_api.g_varchar2
144: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
145: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
146: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
147: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
148: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
149: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
150: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
151: );
144: ,p_pei_information4 IN varchar2 default hr_api.g_varchar2
145: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
146: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
147: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
148: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
149: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
150: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
151: );
152: PROCEDURE assignment_annuities_validate
145: ,p_pei_information5 IN varchar2 default hr_api.g_varchar2
146: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
147: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
148: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
149: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
150: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
151: );
152: PROCEDURE assignment_annuities_validate
153: (p_segment3 IN VARCHAR2
146: ,p_pei_information6 IN varchar2 default hr_api.g_varchar2
147: ,p_pei_information7 IN varchar2 default hr_api.g_varchar2
148: ,p_pei_information8 IN varchar2 default hr_api.g_varchar2
149: ,p_pei_information9 IN varchar2 default hr_api.g_varchar2
150: ,p_pei_information10 IN varchar2 default hr_api.g_varchar2
151: );
152: PROCEDURE assignment_annuities_validate
153: (p_segment3 IN VARCHAR2
154: ,p_effective_date IN DATE