97: -- ----------------------------------------------------------------------------
98: Procedure upd
99: (p_effective_date in date,
100: p_nota_history_id in number,
101: p_person_id in number default hr_api.g_number,
102: p_contact_id in number default hr_api.g_number,
103: p_trng_title in varchar2 default hr_api.g_varchar2,
104: p_provider in varchar2 default hr_api.g_varchar2,
105: p_type in varchar2 default hr_api.g_varchar2,
98: Procedure upd
99: (p_effective_date in date,
100: p_nota_history_id in number,
101: p_person_id in number default hr_api.g_number,
102: p_contact_id in number default hr_api.g_number,
103: p_trng_title in varchar2 default hr_api.g_varchar2,
104: p_provider in varchar2 default hr_api.g_varchar2,
105: p_type in varchar2 default hr_api.g_varchar2,
106: p_centre in varchar2 default hr_api.g_varchar2,
99: (p_effective_date in date,
100: p_nota_history_id in number,
101: p_person_id in number default hr_api.g_number,
102: p_contact_id in number default hr_api.g_number,
103: p_trng_title in varchar2 default hr_api.g_varchar2,
104: p_provider in varchar2 default hr_api.g_varchar2,
105: p_type in varchar2 default hr_api.g_varchar2,
106: p_centre in varchar2 default hr_api.g_varchar2,
107: p_completion_date in date default hr_api.g_date,
100: p_nota_history_id in number,
101: p_person_id in number default hr_api.g_number,
102: p_contact_id in number default hr_api.g_number,
103: p_trng_title in varchar2 default hr_api.g_varchar2,
104: p_provider in varchar2 default hr_api.g_varchar2,
105: p_type in varchar2 default hr_api.g_varchar2,
106: p_centre in varchar2 default hr_api.g_varchar2,
107: p_completion_date in date default hr_api.g_date,
108: p_award in varchar2 default hr_api.g_varchar2,
101: p_person_id in number default hr_api.g_number,
102: p_contact_id in number default hr_api.g_number,
103: p_trng_title in varchar2 default hr_api.g_varchar2,
104: p_provider in varchar2 default hr_api.g_varchar2,
105: p_type in varchar2 default hr_api.g_varchar2,
106: p_centre in varchar2 default hr_api.g_varchar2,
107: p_completion_date in date default hr_api.g_date,
108: p_award in varchar2 default hr_api.g_varchar2,
109: p_rating in varchar2 default hr_api.g_varchar2,
102: p_contact_id in number default hr_api.g_number,
103: p_trng_title in varchar2 default hr_api.g_varchar2,
104: p_provider in varchar2 default hr_api.g_varchar2,
105: p_type in varchar2 default hr_api.g_varchar2,
106: p_centre in varchar2 default hr_api.g_varchar2,
107: p_completion_date in date default hr_api.g_date,
108: p_award in varchar2 default hr_api.g_varchar2,
109: p_rating in varchar2 default hr_api.g_varchar2,
110: p_duration in number default hr_api.g_number,
103: p_trng_title in varchar2 default hr_api.g_varchar2,
104: p_provider in varchar2 default hr_api.g_varchar2,
105: p_type in varchar2 default hr_api.g_varchar2,
106: p_centre in varchar2 default hr_api.g_varchar2,
107: p_completion_date in date default hr_api.g_date,
108: p_award in varchar2 default hr_api.g_varchar2,
109: p_rating in varchar2 default hr_api.g_varchar2,
110: p_duration in number default hr_api.g_number,
111: p_duration_units in varchar2 default hr_api.g_varchar2,
104: p_provider in varchar2 default hr_api.g_varchar2,
105: p_type in varchar2 default hr_api.g_varchar2,
106: p_centre in varchar2 default hr_api.g_varchar2,
107: p_completion_date in date default hr_api.g_date,
108: p_award in varchar2 default hr_api.g_varchar2,
109: p_rating in varchar2 default hr_api.g_varchar2,
110: p_duration in number default hr_api.g_number,
111: p_duration_units in varchar2 default hr_api.g_varchar2,
112: p_activity_version_id in number default hr_api.g_number,
105: p_type in varchar2 default hr_api.g_varchar2,
106: p_centre in varchar2 default hr_api.g_varchar2,
107: p_completion_date in date default hr_api.g_date,
108: p_award in varchar2 default hr_api.g_varchar2,
109: p_rating in varchar2 default hr_api.g_varchar2,
110: p_duration in number default hr_api.g_number,
111: p_duration_units in varchar2 default hr_api.g_varchar2,
112: p_activity_version_id in number default hr_api.g_number,
113: p_status in varchar2 default hr_api.g_varchar2,
106: p_centre in varchar2 default hr_api.g_varchar2,
107: p_completion_date in date default hr_api.g_date,
108: p_award in varchar2 default hr_api.g_varchar2,
109: p_rating in varchar2 default hr_api.g_varchar2,
110: p_duration in number default hr_api.g_number,
111: p_duration_units in varchar2 default hr_api.g_varchar2,
112: p_activity_version_id in number default hr_api.g_number,
113: p_status in varchar2 default hr_api.g_varchar2,
114: p_verified_by_id in number default hr_api.g_number,
107: p_completion_date in date default hr_api.g_date,
108: p_award in varchar2 default hr_api.g_varchar2,
109: p_rating in varchar2 default hr_api.g_varchar2,
110: p_duration in number default hr_api.g_number,
111: p_duration_units in varchar2 default hr_api.g_varchar2,
112: p_activity_version_id in number default hr_api.g_number,
113: p_status in varchar2 default hr_api.g_varchar2,
114: p_verified_by_id in number default hr_api.g_number,
115: p_nth_information_category in varchar2 default hr_api.g_varchar2,
108: p_award in varchar2 default hr_api.g_varchar2,
109: p_rating in varchar2 default hr_api.g_varchar2,
110: p_duration in number default hr_api.g_number,
111: p_duration_units in varchar2 default hr_api.g_varchar2,
112: p_activity_version_id in number default hr_api.g_number,
113: p_status in varchar2 default hr_api.g_varchar2,
114: p_verified_by_id in number default hr_api.g_number,
115: p_nth_information_category in varchar2 default hr_api.g_varchar2,
116: p_nth_information1 in varchar2 default hr_api.g_varchar2,
109: p_rating in varchar2 default hr_api.g_varchar2,
110: p_duration in number default hr_api.g_number,
111: p_duration_units in varchar2 default hr_api.g_varchar2,
112: p_activity_version_id in number default hr_api.g_number,
113: p_status in varchar2 default hr_api.g_varchar2,
114: p_verified_by_id in number default hr_api.g_number,
115: p_nth_information_category in varchar2 default hr_api.g_varchar2,
116: p_nth_information1 in varchar2 default hr_api.g_varchar2,
117: p_nth_information2 in varchar2 default hr_api.g_varchar2,
110: p_duration in number default hr_api.g_number,
111: p_duration_units in varchar2 default hr_api.g_varchar2,
112: p_activity_version_id in number default hr_api.g_number,
113: p_status in varchar2 default hr_api.g_varchar2,
114: p_verified_by_id in number default hr_api.g_number,
115: p_nth_information_category in varchar2 default hr_api.g_varchar2,
116: p_nth_information1 in varchar2 default hr_api.g_varchar2,
117: p_nth_information2 in varchar2 default hr_api.g_varchar2,
118: p_nth_information3 in varchar2 default hr_api.g_varchar2,
111: p_duration_units in varchar2 default hr_api.g_varchar2,
112: p_activity_version_id in number default hr_api.g_number,
113: p_status in varchar2 default hr_api.g_varchar2,
114: p_verified_by_id in number default hr_api.g_number,
115: p_nth_information_category in varchar2 default hr_api.g_varchar2,
116: p_nth_information1 in varchar2 default hr_api.g_varchar2,
117: p_nth_information2 in varchar2 default hr_api.g_varchar2,
118: p_nth_information3 in varchar2 default hr_api.g_varchar2,
119: p_nth_information4 in varchar2 default hr_api.g_varchar2,
112: p_activity_version_id in number default hr_api.g_number,
113: p_status in varchar2 default hr_api.g_varchar2,
114: p_verified_by_id in number default hr_api.g_number,
115: p_nth_information_category in varchar2 default hr_api.g_varchar2,
116: p_nth_information1 in varchar2 default hr_api.g_varchar2,
117: p_nth_information2 in varchar2 default hr_api.g_varchar2,
118: p_nth_information3 in varchar2 default hr_api.g_varchar2,
119: p_nth_information4 in varchar2 default hr_api.g_varchar2,
120: p_nth_information5 in varchar2 default hr_api.g_varchar2,
113: p_status in varchar2 default hr_api.g_varchar2,
114: p_verified_by_id in number default hr_api.g_number,
115: p_nth_information_category in varchar2 default hr_api.g_varchar2,
116: p_nth_information1 in varchar2 default hr_api.g_varchar2,
117: p_nth_information2 in varchar2 default hr_api.g_varchar2,
118: p_nth_information3 in varchar2 default hr_api.g_varchar2,
119: p_nth_information4 in varchar2 default hr_api.g_varchar2,
120: p_nth_information5 in varchar2 default hr_api.g_varchar2,
121: p_nth_information6 in varchar2 default hr_api.g_varchar2,
114: p_verified_by_id in number default hr_api.g_number,
115: p_nth_information_category in varchar2 default hr_api.g_varchar2,
116: p_nth_information1 in varchar2 default hr_api.g_varchar2,
117: p_nth_information2 in varchar2 default hr_api.g_varchar2,
118: p_nth_information3 in varchar2 default hr_api.g_varchar2,
119: p_nth_information4 in varchar2 default hr_api.g_varchar2,
120: p_nth_information5 in varchar2 default hr_api.g_varchar2,
121: p_nth_information6 in varchar2 default hr_api.g_varchar2,
122: p_nth_information7 in varchar2 default hr_api.g_varchar2,
115: p_nth_information_category in varchar2 default hr_api.g_varchar2,
116: p_nth_information1 in varchar2 default hr_api.g_varchar2,
117: p_nth_information2 in varchar2 default hr_api.g_varchar2,
118: p_nth_information3 in varchar2 default hr_api.g_varchar2,
119: p_nth_information4 in varchar2 default hr_api.g_varchar2,
120: p_nth_information5 in varchar2 default hr_api.g_varchar2,
121: p_nth_information6 in varchar2 default hr_api.g_varchar2,
122: p_nth_information7 in varchar2 default hr_api.g_varchar2,
123: p_nth_information8 in varchar2 default hr_api.g_varchar2,
116: p_nth_information1 in varchar2 default hr_api.g_varchar2,
117: p_nth_information2 in varchar2 default hr_api.g_varchar2,
118: p_nth_information3 in varchar2 default hr_api.g_varchar2,
119: p_nth_information4 in varchar2 default hr_api.g_varchar2,
120: p_nth_information5 in varchar2 default hr_api.g_varchar2,
121: p_nth_information6 in varchar2 default hr_api.g_varchar2,
122: p_nth_information7 in varchar2 default hr_api.g_varchar2,
123: p_nth_information8 in varchar2 default hr_api.g_varchar2,
124: p_nth_information9 in varchar2 default hr_api.g_varchar2,
117: p_nth_information2 in varchar2 default hr_api.g_varchar2,
118: p_nth_information3 in varchar2 default hr_api.g_varchar2,
119: p_nth_information4 in varchar2 default hr_api.g_varchar2,
120: p_nth_information5 in varchar2 default hr_api.g_varchar2,
121: p_nth_information6 in varchar2 default hr_api.g_varchar2,
122: p_nth_information7 in varchar2 default hr_api.g_varchar2,
123: p_nth_information8 in varchar2 default hr_api.g_varchar2,
124: p_nth_information9 in varchar2 default hr_api.g_varchar2,
125: p_nth_information10 in varchar2 default hr_api.g_varchar2,
118: p_nth_information3 in varchar2 default hr_api.g_varchar2,
119: p_nth_information4 in varchar2 default hr_api.g_varchar2,
120: p_nth_information5 in varchar2 default hr_api.g_varchar2,
121: p_nth_information6 in varchar2 default hr_api.g_varchar2,
122: p_nth_information7 in varchar2 default hr_api.g_varchar2,
123: p_nth_information8 in varchar2 default hr_api.g_varchar2,
124: p_nth_information9 in varchar2 default hr_api.g_varchar2,
125: p_nth_information10 in varchar2 default hr_api.g_varchar2,
126: p_nth_information11 in varchar2 default hr_api.g_varchar2,
119: p_nth_information4 in varchar2 default hr_api.g_varchar2,
120: p_nth_information5 in varchar2 default hr_api.g_varchar2,
121: p_nth_information6 in varchar2 default hr_api.g_varchar2,
122: p_nth_information7 in varchar2 default hr_api.g_varchar2,
123: p_nth_information8 in varchar2 default hr_api.g_varchar2,
124: p_nth_information9 in varchar2 default hr_api.g_varchar2,
125: p_nth_information10 in varchar2 default hr_api.g_varchar2,
126: p_nth_information11 in varchar2 default hr_api.g_varchar2,
127: p_nth_information12 in varchar2 default hr_api.g_varchar2,
120: p_nth_information5 in varchar2 default hr_api.g_varchar2,
121: p_nth_information6 in varchar2 default hr_api.g_varchar2,
122: p_nth_information7 in varchar2 default hr_api.g_varchar2,
123: p_nth_information8 in varchar2 default hr_api.g_varchar2,
124: p_nth_information9 in varchar2 default hr_api.g_varchar2,
125: p_nth_information10 in varchar2 default hr_api.g_varchar2,
126: p_nth_information11 in varchar2 default hr_api.g_varchar2,
127: p_nth_information12 in varchar2 default hr_api.g_varchar2,
128: p_nth_information13 in varchar2 default hr_api.g_varchar2,
121: p_nth_information6 in varchar2 default hr_api.g_varchar2,
122: p_nth_information7 in varchar2 default hr_api.g_varchar2,
123: p_nth_information8 in varchar2 default hr_api.g_varchar2,
124: p_nth_information9 in varchar2 default hr_api.g_varchar2,
125: p_nth_information10 in varchar2 default hr_api.g_varchar2,
126: p_nth_information11 in varchar2 default hr_api.g_varchar2,
127: p_nth_information12 in varchar2 default hr_api.g_varchar2,
128: p_nth_information13 in varchar2 default hr_api.g_varchar2,
129: p_nth_information15 in varchar2 default hr_api.g_varchar2,
122: p_nth_information7 in varchar2 default hr_api.g_varchar2,
123: p_nth_information8 in varchar2 default hr_api.g_varchar2,
124: p_nth_information9 in varchar2 default hr_api.g_varchar2,
125: p_nth_information10 in varchar2 default hr_api.g_varchar2,
126: p_nth_information11 in varchar2 default hr_api.g_varchar2,
127: p_nth_information12 in varchar2 default hr_api.g_varchar2,
128: p_nth_information13 in varchar2 default hr_api.g_varchar2,
129: p_nth_information15 in varchar2 default hr_api.g_varchar2,
130: p_nth_information16 in varchar2 default hr_api.g_varchar2,
123: p_nth_information8 in varchar2 default hr_api.g_varchar2,
124: p_nth_information9 in varchar2 default hr_api.g_varchar2,
125: p_nth_information10 in varchar2 default hr_api.g_varchar2,
126: p_nth_information11 in varchar2 default hr_api.g_varchar2,
127: p_nth_information12 in varchar2 default hr_api.g_varchar2,
128: p_nth_information13 in varchar2 default hr_api.g_varchar2,
129: p_nth_information15 in varchar2 default hr_api.g_varchar2,
130: p_nth_information16 in varchar2 default hr_api.g_varchar2,
131: p_nth_information17 in varchar2 default hr_api.g_varchar2,
124: p_nth_information9 in varchar2 default hr_api.g_varchar2,
125: p_nth_information10 in varchar2 default hr_api.g_varchar2,
126: p_nth_information11 in varchar2 default hr_api.g_varchar2,
127: p_nth_information12 in varchar2 default hr_api.g_varchar2,
128: p_nth_information13 in varchar2 default hr_api.g_varchar2,
129: p_nth_information15 in varchar2 default hr_api.g_varchar2,
130: p_nth_information16 in varchar2 default hr_api.g_varchar2,
131: p_nth_information17 in varchar2 default hr_api.g_varchar2,
132: p_nth_information18 in varchar2 default hr_api.g_varchar2,
125: p_nth_information10 in varchar2 default hr_api.g_varchar2,
126: p_nth_information11 in varchar2 default hr_api.g_varchar2,
127: p_nth_information12 in varchar2 default hr_api.g_varchar2,
128: p_nth_information13 in varchar2 default hr_api.g_varchar2,
129: p_nth_information15 in varchar2 default hr_api.g_varchar2,
130: p_nth_information16 in varchar2 default hr_api.g_varchar2,
131: p_nth_information17 in varchar2 default hr_api.g_varchar2,
132: p_nth_information18 in varchar2 default hr_api.g_varchar2,
133: p_nth_information19 in varchar2 default hr_api.g_varchar2,
126: p_nth_information11 in varchar2 default hr_api.g_varchar2,
127: p_nth_information12 in varchar2 default hr_api.g_varchar2,
128: p_nth_information13 in varchar2 default hr_api.g_varchar2,
129: p_nth_information15 in varchar2 default hr_api.g_varchar2,
130: p_nth_information16 in varchar2 default hr_api.g_varchar2,
131: p_nth_information17 in varchar2 default hr_api.g_varchar2,
132: p_nth_information18 in varchar2 default hr_api.g_varchar2,
133: p_nth_information19 in varchar2 default hr_api.g_varchar2,
134: p_nth_information20 in varchar2 default hr_api.g_varchar2,
127: p_nth_information12 in varchar2 default hr_api.g_varchar2,
128: p_nth_information13 in varchar2 default hr_api.g_varchar2,
129: p_nth_information15 in varchar2 default hr_api.g_varchar2,
130: p_nth_information16 in varchar2 default hr_api.g_varchar2,
131: p_nth_information17 in varchar2 default hr_api.g_varchar2,
132: p_nth_information18 in varchar2 default hr_api.g_varchar2,
133: p_nth_information19 in varchar2 default hr_api.g_varchar2,
134: p_nth_information20 in varchar2 default hr_api.g_varchar2,
135: p_org_id in number default hr_api.g_number,
128: p_nth_information13 in varchar2 default hr_api.g_varchar2,
129: p_nth_information15 in varchar2 default hr_api.g_varchar2,
130: p_nth_information16 in varchar2 default hr_api.g_varchar2,
131: p_nth_information17 in varchar2 default hr_api.g_varchar2,
132: p_nth_information18 in varchar2 default hr_api.g_varchar2,
133: p_nth_information19 in varchar2 default hr_api.g_varchar2,
134: p_nth_information20 in varchar2 default hr_api.g_varchar2,
135: p_org_id in number default hr_api.g_number,
136: p_object_version_number in out nocopy number,
129: p_nth_information15 in varchar2 default hr_api.g_varchar2,
130: p_nth_information16 in varchar2 default hr_api.g_varchar2,
131: p_nth_information17 in varchar2 default hr_api.g_varchar2,
132: p_nth_information18 in varchar2 default hr_api.g_varchar2,
133: p_nth_information19 in varchar2 default hr_api.g_varchar2,
134: p_nth_information20 in varchar2 default hr_api.g_varchar2,
135: p_org_id in number default hr_api.g_number,
136: p_object_version_number in out nocopy number,
137: p_business_group_id in number default hr_api.g_number,
130: p_nth_information16 in varchar2 default hr_api.g_varchar2,
131: p_nth_information17 in varchar2 default hr_api.g_varchar2,
132: p_nth_information18 in varchar2 default hr_api.g_varchar2,
133: p_nth_information19 in varchar2 default hr_api.g_varchar2,
134: p_nth_information20 in varchar2 default hr_api.g_varchar2,
135: p_org_id in number default hr_api.g_number,
136: p_object_version_number in out nocopy number,
137: p_business_group_id in number default hr_api.g_number,
138: p_nth_information14 in varchar2 default hr_api.g_varchar2,
131: p_nth_information17 in varchar2 default hr_api.g_varchar2,
132: p_nth_information18 in varchar2 default hr_api.g_varchar2,
133: p_nth_information19 in varchar2 default hr_api.g_varchar2,
134: p_nth_information20 in varchar2 default hr_api.g_varchar2,
135: p_org_id in number default hr_api.g_number,
136: p_object_version_number in out nocopy number,
137: p_business_group_id in number default hr_api.g_number,
138: p_nth_information14 in varchar2 default hr_api.g_varchar2,
139: p_customer_id in number default hr_api.g_number,
133: p_nth_information19 in varchar2 default hr_api.g_varchar2,
134: p_nth_information20 in varchar2 default hr_api.g_varchar2,
135: p_org_id in number default hr_api.g_number,
136: p_object_version_number in out nocopy number,
137: p_business_group_id in number default hr_api.g_number,
138: p_nth_information14 in varchar2 default hr_api.g_varchar2,
139: p_customer_id in number default hr_api.g_number,
140: p_organization_id in number default hr_api.g_number
141: );
134: p_nth_information20 in varchar2 default hr_api.g_varchar2,
135: p_org_id in number default hr_api.g_number,
136: p_object_version_number in out nocopy number,
137: p_business_group_id in number default hr_api.g_number,
138: p_nth_information14 in varchar2 default hr_api.g_varchar2,
139: p_customer_id in number default hr_api.g_number,
140: p_organization_id in number default hr_api.g_number
141: );
142: --
135: p_org_id in number default hr_api.g_number,
136: p_object_version_number in out nocopy number,
137: p_business_group_id in number default hr_api.g_number,
138: p_nth_information14 in varchar2 default hr_api.g_varchar2,
139: p_customer_id in number default hr_api.g_number,
140: p_organization_id in number default hr_api.g_number
141: );
142: --
143: end ota_nhs_upd;
136: p_object_version_number in out nocopy number,
137: p_business_group_id in number default hr_api.g_number,
138: p_nth_information14 in varchar2 default hr_api.g_varchar2,
139: p_customer_id in number default hr_api.g_number,
140: p_organization_id in number default hr_api.g_number
141: );
142: --
143: end ota_nhs_upd;