99: Procedure upd
100: (
101: p_effective_date in date,
102: p_process_log_id in number,
103: p_module_cd in varchar2 default hr_api.g_varchar2,
104: p_txn_id in number default hr_api.g_number,
105: p_master_process_log_id in number default hr_api.g_number,
106: p_message_text in varchar2 default hr_api.g_varchar2,
107: p_message_type_cd in varchar2 default hr_api.g_varchar2,
100: (
101: p_effective_date in date,
102: p_process_log_id in number,
103: p_module_cd in varchar2 default hr_api.g_varchar2,
104: p_txn_id in number default hr_api.g_number,
105: p_master_process_log_id in number default hr_api.g_number,
106: p_message_text in varchar2 default hr_api.g_varchar2,
107: p_message_type_cd in varchar2 default hr_api.g_varchar2,
108: p_batch_status in varchar2 default hr_api.g_varchar2,
101: p_effective_date in date,
102: p_process_log_id in number,
103: p_module_cd in varchar2 default hr_api.g_varchar2,
104: p_txn_id in number default hr_api.g_number,
105: p_master_process_log_id in number default hr_api.g_number,
106: p_message_text in varchar2 default hr_api.g_varchar2,
107: p_message_type_cd in varchar2 default hr_api.g_varchar2,
108: p_batch_status in varchar2 default hr_api.g_varchar2,
109: p_batch_start_date in date default hr_api.g_date,
102: p_process_log_id in number,
103: p_module_cd in varchar2 default hr_api.g_varchar2,
104: p_txn_id in number default hr_api.g_number,
105: p_master_process_log_id in number default hr_api.g_number,
106: p_message_text in varchar2 default hr_api.g_varchar2,
107: p_message_type_cd in varchar2 default hr_api.g_varchar2,
108: p_batch_status in varchar2 default hr_api.g_varchar2,
109: p_batch_start_date in date default hr_api.g_date,
110: p_batch_end_date in date default hr_api.g_date,
103: p_module_cd in varchar2 default hr_api.g_varchar2,
104: p_txn_id in number default hr_api.g_number,
105: p_master_process_log_id in number default hr_api.g_number,
106: p_message_text in varchar2 default hr_api.g_varchar2,
107: p_message_type_cd in varchar2 default hr_api.g_varchar2,
108: p_batch_status in varchar2 default hr_api.g_varchar2,
109: p_batch_start_date in date default hr_api.g_date,
110: p_batch_end_date in date default hr_api.g_date,
111: p_txn_table_route_id in number default hr_api.g_number,
104: p_txn_id in number default hr_api.g_number,
105: p_master_process_log_id in number default hr_api.g_number,
106: p_message_text in varchar2 default hr_api.g_varchar2,
107: p_message_type_cd in varchar2 default hr_api.g_varchar2,
108: p_batch_status in varchar2 default hr_api.g_varchar2,
109: p_batch_start_date in date default hr_api.g_date,
110: p_batch_end_date in date default hr_api.g_date,
111: p_txn_table_route_id in number default hr_api.g_number,
112: p_log_context in varchar2 default hr_api.g_varchar2,
105: p_master_process_log_id in number default hr_api.g_number,
106: p_message_text in varchar2 default hr_api.g_varchar2,
107: p_message_type_cd in varchar2 default hr_api.g_varchar2,
108: p_batch_status in varchar2 default hr_api.g_varchar2,
109: p_batch_start_date in date default hr_api.g_date,
110: p_batch_end_date in date default hr_api.g_date,
111: p_txn_table_route_id in number default hr_api.g_number,
112: p_log_context in varchar2 default hr_api.g_varchar2,
113: p_information_category in varchar2 default hr_api.g_varchar2,
106: p_message_text in varchar2 default hr_api.g_varchar2,
107: p_message_type_cd in varchar2 default hr_api.g_varchar2,
108: p_batch_status in varchar2 default hr_api.g_varchar2,
109: p_batch_start_date in date default hr_api.g_date,
110: p_batch_end_date in date default hr_api.g_date,
111: p_txn_table_route_id in number default hr_api.g_number,
112: p_log_context in varchar2 default hr_api.g_varchar2,
113: p_information_category in varchar2 default hr_api.g_varchar2,
114: p_information1 in varchar2 default hr_api.g_varchar2,
107: p_message_type_cd in varchar2 default hr_api.g_varchar2,
108: p_batch_status in varchar2 default hr_api.g_varchar2,
109: p_batch_start_date in date default hr_api.g_date,
110: p_batch_end_date in date default hr_api.g_date,
111: p_txn_table_route_id in number default hr_api.g_number,
112: p_log_context in varchar2 default hr_api.g_varchar2,
113: p_information_category in varchar2 default hr_api.g_varchar2,
114: p_information1 in varchar2 default hr_api.g_varchar2,
115: p_information2 in varchar2 default hr_api.g_varchar2,
108: p_batch_status in varchar2 default hr_api.g_varchar2,
109: p_batch_start_date in date default hr_api.g_date,
110: p_batch_end_date in date default hr_api.g_date,
111: p_txn_table_route_id in number default hr_api.g_number,
112: p_log_context in varchar2 default hr_api.g_varchar2,
113: p_information_category in varchar2 default hr_api.g_varchar2,
114: p_information1 in varchar2 default hr_api.g_varchar2,
115: p_information2 in varchar2 default hr_api.g_varchar2,
116: p_information3 in varchar2 default hr_api.g_varchar2,
109: p_batch_start_date in date default hr_api.g_date,
110: p_batch_end_date in date default hr_api.g_date,
111: p_txn_table_route_id in number default hr_api.g_number,
112: p_log_context in varchar2 default hr_api.g_varchar2,
113: p_information_category in varchar2 default hr_api.g_varchar2,
114: p_information1 in varchar2 default hr_api.g_varchar2,
115: p_information2 in varchar2 default hr_api.g_varchar2,
116: p_information3 in varchar2 default hr_api.g_varchar2,
117: p_information4 in varchar2 default hr_api.g_varchar2,
110: p_batch_end_date in date default hr_api.g_date,
111: p_txn_table_route_id in number default hr_api.g_number,
112: p_log_context in varchar2 default hr_api.g_varchar2,
113: p_information_category in varchar2 default hr_api.g_varchar2,
114: p_information1 in varchar2 default hr_api.g_varchar2,
115: p_information2 in varchar2 default hr_api.g_varchar2,
116: p_information3 in varchar2 default hr_api.g_varchar2,
117: p_information4 in varchar2 default hr_api.g_varchar2,
118: p_information5 in varchar2 default hr_api.g_varchar2,
111: p_txn_table_route_id in number default hr_api.g_number,
112: p_log_context in varchar2 default hr_api.g_varchar2,
113: p_information_category in varchar2 default hr_api.g_varchar2,
114: p_information1 in varchar2 default hr_api.g_varchar2,
115: p_information2 in varchar2 default hr_api.g_varchar2,
116: p_information3 in varchar2 default hr_api.g_varchar2,
117: p_information4 in varchar2 default hr_api.g_varchar2,
118: p_information5 in varchar2 default hr_api.g_varchar2,
119: p_information6 in varchar2 default hr_api.g_varchar2,
112: p_log_context in varchar2 default hr_api.g_varchar2,
113: p_information_category in varchar2 default hr_api.g_varchar2,
114: p_information1 in varchar2 default hr_api.g_varchar2,
115: p_information2 in varchar2 default hr_api.g_varchar2,
116: p_information3 in varchar2 default hr_api.g_varchar2,
117: p_information4 in varchar2 default hr_api.g_varchar2,
118: p_information5 in varchar2 default hr_api.g_varchar2,
119: p_information6 in varchar2 default hr_api.g_varchar2,
120: p_information7 in varchar2 default hr_api.g_varchar2,
113: p_information_category in varchar2 default hr_api.g_varchar2,
114: p_information1 in varchar2 default hr_api.g_varchar2,
115: p_information2 in varchar2 default hr_api.g_varchar2,
116: p_information3 in varchar2 default hr_api.g_varchar2,
117: p_information4 in varchar2 default hr_api.g_varchar2,
118: p_information5 in varchar2 default hr_api.g_varchar2,
119: p_information6 in varchar2 default hr_api.g_varchar2,
120: p_information7 in varchar2 default hr_api.g_varchar2,
121: p_information8 in varchar2 default hr_api.g_varchar2,
114: p_information1 in varchar2 default hr_api.g_varchar2,
115: p_information2 in varchar2 default hr_api.g_varchar2,
116: p_information3 in varchar2 default hr_api.g_varchar2,
117: p_information4 in varchar2 default hr_api.g_varchar2,
118: p_information5 in varchar2 default hr_api.g_varchar2,
119: p_information6 in varchar2 default hr_api.g_varchar2,
120: p_information7 in varchar2 default hr_api.g_varchar2,
121: p_information8 in varchar2 default hr_api.g_varchar2,
122: p_information9 in varchar2 default hr_api.g_varchar2,
115: p_information2 in varchar2 default hr_api.g_varchar2,
116: p_information3 in varchar2 default hr_api.g_varchar2,
117: p_information4 in varchar2 default hr_api.g_varchar2,
118: p_information5 in varchar2 default hr_api.g_varchar2,
119: p_information6 in varchar2 default hr_api.g_varchar2,
120: p_information7 in varchar2 default hr_api.g_varchar2,
121: p_information8 in varchar2 default hr_api.g_varchar2,
122: p_information9 in varchar2 default hr_api.g_varchar2,
123: p_information10 in varchar2 default hr_api.g_varchar2,
116: p_information3 in varchar2 default hr_api.g_varchar2,
117: p_information4 in varchar2 default hr_api.g_varchar2,
118: p_information5 in varchar2 default hr_api.g_varchar2,
119: p_information6 in varchar2 default hr_api.g_varchar2,
120: p_information7 in varchar2 default hr_api.g_varchar2,
121: p_information8 in varchar2 default hr_api.g_varchar2,
122: p_information9 in varchar2 default hr_api.g_varchar2,
123: p_information10 in varchar2 default hr_api.g_varchar2,
124: p_information11 in varchar2 default hr_api.g_varchar2,
117: p_information4 in varchar2 default hr_api.g_varchar2,
118: p_information5 in varchar2 default hr_api.g_varchar2,
119: p_information6 in varchar2 default hr_api.g_varchar2,
120: p_information7 in varchar2 default hr_api.g_varchar2,
121: p_information8 in varchar2 default hr_api.g_varchar2,
122: p_information9 in varchar2 default hr_api.g_varchar2,
123: p_information10 in varchar2 default hr_api.g_varchar2,
124: p_information11 in varchar2 default hr_api.g_varchar2,
125: p_information12 in varchar2 default hr_api.g_varchar2,
118: p_information5 in varchar2 default hr_api.g_varchar2,
119: p_information6 in varchar2 default hr_api.g_varchar2,
120: p_information7 in varchar2 default hr_api.g_varchar2,
121: p_information8 in varchar2 default hr_api.g_varchar2,
122: p_information9 in varchar2 default hr_api.g_varchar2,
123: p_information10 in varchar2 default hr_api.g_varchar2,
124: p_information11 in varchar2 default hr_api.g_varchar2,
125: p_information12 in varchar2 default hr_api.g_varchar2,
126: p_information13 in varchar2 default hr_api.g_varchar2,
119: p_information6 in varchar2 default hr_api.g_varchar2,
120: p_information7 in varchar2 default hr_api.g_varchar2,
121: p_information8 in varchar2 default hr_api.g_varchar2,
122: p_information9 in varchar2 default hr_api.g_varchar2,
123: p_information10 in varchar2 default hr_api.g_varchar2,
124: p_information11 in varchar2 default hr_api.g_varchar2,
125: p_information12 in varchar2 default hr_api.g_varchar2,
126: p_information13 in varchar2 default hr_api.g_varchar2,
127: p_information14 in varchar2 default hr_api.g_varchar2,
120: p_information7 in varchar2 default hr_api.g_varchar2,
121: p_information8 in varchar2 default hr_api.g_varchar2,
122: p_information9 in varchar2 default hr_api.g_varchar2,
123: p_information10 in varchar2 default hr_api.g_varchar2,
124: p_information11 in varchar2 default hr_api.g_varchar2,
125: p_information12 in varchar2 default hr_api.g_varchar2,
126: p_information13 in varchar2 default hr_api.g_varchar2,
127: p_information14 in varchar2 default hr_api.g_varchar2,
128: p_information15 in varchar2 default hr_api.g_varchar2,
121: p_information8 in varchar2 default hr_api.g_varchar2,
122: p_information9 in varchar2 default hr_api.g_varchar2,
123: p_information10 in varchar2 default hr_api.g_varchar2,
124: p_information11 in varchar2 default hr_api.g_varchar2,
125: p_information12 in varchar2 default hr_api.g_varchar2,
126: p_information13 in varchar2 default hr_api.g_varchar2,
127: p_information14 in varchar2 default hr_api.g_varchar2,
128: p_information15 in varchar2 default hr_api.g_varchar2,
129: p_information16 in varchar2 default hr_api.g_varchar2,
122: p_information9 in varchar2 default hr_api.g_varchar2,
123: p_information10 in varchar2 default hr_api.g_varchar2,
124: p_information11 in varchar2 default hr_api.g_varchar2,
125: p_information12 in varchar2 default hr_api.g_varchar2,
126: p_information13 in varchar2 default hr_api.g_varchar2,
127: p_information14 in varchar2 default hr_api.g_varchar2,
128: p_information15 in varchar2 default hr_api.g_varchar2,
129: p_information16 in varchar2 default hr_api.g_varchar2,
130: p_information17 in varchar2 default hr_api.g_varchar2,
123: p_information10 in varchar2 default hr_api.g_varchar2,
124: p_information11 in varchar2 default hr_api.g_varchar2,
125: p_information12 in varchar2 default hr_api.g_varchar2,
126: p_information13 in varchar2 default hr_api.g_varchar2,
127: p_information14 in varchar2 default hr_api.g_varchar2,
128: p_information15 in varchar2 default hr_api.g_varchar2,
129: p_information16 in varchar2 default hr_api.g_varchar2,
130: p_information17 in varchar2 default hr_api.g_varchar2,
131: p_information18 in varchar2 default hr_api.g_varchar2,
124: p_information11 in varchar2 default hr_api.g_varchar2,
125: p_information12 in varchar2 default hr_api.g_varchar2,
126: p_information13 in varchar2 default hr_api.g_varchar2,
127: p_information14 in varchar2 default hr_api.g_varchar2,
128: p_information15 in varchar2 default hr_api.g_varchar2,
129: p_information16 in varchar2 default hr_api.g_varchar2,
130: p_information17 in varchar2 default hr_api.g_varchar2,
131: p_information18 in varchar2 default hr_api.g_varchar2,
132: p_information19 in varchar2 default hr_api.g_varchar2,
125: p_information12 in varchar2 default hr_api.g_varchar2,
126: p_information13 in varchar2 default hr_api.g_varchar2,
127: p_information14 in varchar2 default hr_api.g_varchar2,
128: p_information15 in varchar2 default hr_api.g_varchar2,
129: p_information16 in varchar2 default hr_api.g_varchar2,
130: p_information17 in varchar2 default hr_api.g_varchar2,
131: p_information18 in varchar2 default hr_api.g_varchar2,
132: p_information19 in varchar2 default hr_api.g_varchar2,
133: p_information20 in varchar2 default hr_api.g_varchar2,
126: p_information13 in varchar2 default hr_api.g_varchar2,
127: p_information14 in varchar2 default hr_api.g_varchar2,
128: p_information15 in varchar2 default hr_api.g_varchar2,
129: p_information16 in varchar2 default hr_api.g_varchar2,
130: p_information17 in varchar2 default hr_api.g_varchar2,
131: p_information18 in varchar2 default hr_api.g_varchar2,
132: p_information19 in varchar2 default hr_api.g_varchar2,
133: p_information20 in varchar2 default hr_api.g_varchar2,
134: p_information21 in varchar2 default hr_api.g_varchar2,
127: p_information14 in varchar2 default hr_api.g_varchar2,
128: p_information15 in varchar2 default hr_api.g_varchar2,
129: p_information16 in varchar2 default hr_api.g_varchar2,
130: p_information17 in varchar2 default hr_api.g_varchar2,
131: p_information18 in varchar2 default hr_api.g_varchar2,
132: p_information19 in varchar2 default hr_api.g_varchar2,
133: p_information20 in varchar2 default hr_api.g_varchar2,
134: p_information21 in varchar2 default hr_api.g_varchar2,
135: p_information22 in varchar2 default hr_api.g_varchar2,
128: p_information15 in varchar2 default hr_api.g_varchar2,
129: p_information16 in varchar2 default hr_api.g_varchar2,
130: p_information17 in varchar2 default hr_api.g_varchar2,
131: p_information18 in varchar2 default hr_api.g_varchar2,
132: p_information19 in varchar2 default hr_api.g_varchar2,
133: p_information20 in varchar2 default hr_api.g_varchar2,
134: p_information21 in varchar2 default hr_api.g_varchar2,
135: p_information22 in varchar2 default hr_api.g_varchar2,
136: p_information23 in varchar2 default hr_api.g_varchar2,
129: p_information16 in varchar2 default hr_api.g_varchar2,
130: p_information17 in varchar2 default hr_api.g_varchar2,
131: p_information18 in varchar2 default hr_api.g_varchar2,
132: p_information19 in varchar2 default hr_api.g_varchar2,
133: p_information20 in varchar2 default hr_api.g_varchar2,
134: p_information21 in varchar2 default hr_api.g_varchar2,
135: p_information22 in varchar2 default hr_api.g_varchar2,
136: p_information23 in varchar2 default hr_api.g_varchar2,
137: p_information24 in varchar2 default hr_api.g_varchar2,
130: p_information17 in varchar2 default hr_api.g_varchar2,
131: p_information18 in varchar2 default hr_api.g_varchar2,
132: p_information19 in varchar2 default hr_api.g_varchar2,
133: p_information20 in varchar2 default hr_api.g_varchar2,
134: p_information21 in varchar2 default hr_api.g_varchar2,
135: p_information22 in varchar2 default hr_api.g_varchar2,
136: p_information23 in varchar2 default hr_api.g_varchar2,
137: p_information24 in varchar2 default hr_api.g_varchar2,
138: p_information25 in varchar2 default hr_api.g_varchar2,
131: p_information18 in varchar2 default hr_api.g_varchar2,
132: p_information19 in varchar2 default hr_api.g_varchar2,
133: p_information20 in varchar2 default hr_api.g_varchar2,
134: p_information21 in varchar2 default hr_api.g_varchar2,
135: p_information22 in varchar2 default hr_api.g_varchar2,
136: p_information23 in varchar2 default hr_api.g_varchar2,
137: p_information24 in varchar2 default hr_api.g_varchar2,
138: p_information25 in varchar2 default hr_api.g_varchar2,
139: p_information26 in varchar2 default hr_api.g_varchar2,
132: p_information19 in varchar2 default hr_api.g_varchar2,
133: p_information20 in varchar2 default hr_api.g_varchar2,
134: p_information21 in varchar2 default hr_api.g_varchar2,
135: p_information22 in varchar2 default hr_api.g_varchar2,
136: p_information23 in varchar2 default hr_api.g_varchar2,
137: p_information24 in varchar2 default hr_api.g_varchar2,
138: p_information25 in varchar2 default hr_api.g_varchar2,
139: p_information26 in varchar2 default hr_api.g_varchar2,
140: p_information27 in varchar2 default hr_api.g_varchar2,
133: p_information20 in varchar2 default hr_api.g_varchar2,
134: p_information21 in varchar2 default hr_api.g_varchar2,
135: p_information22 in varchar2 default hr_api.g_varchar2,
136: p_information23 in varchar2 default hr_api.g_varchar2,
137: p_information24 in varchar2 default hr_api.g_varchar2,
138: p_information25 in varchar2 default hr_api.g_varchar2,
139: p_information26 in varchar2 default hr_api.g_varchar2,
140: p_information27 in varchar2 default hr_api.g_varchar2,
141: p_information28 in varchar2 default hr_api.g_varchar2,
134: p_information21 in varchar2 default hr_api.g_varchar2,
135: p_information22 in varchar2 default hr_api.g_varchar2,
136: p_information23 in varchar2 default hr_api.g_varchar2,
137: p_information24 in varchar2 default hr_api.g_varchar2,
138: p_information25 in varchar2 default hr_api.g_varchar2,
139: p_information26 in varchar2 default hr_api.g_varchar2,
140: p_information27 in varchar2 default hr_api.g_varchar2,
141: p_information28 in varchar2 default hr_api.g_varchar2,
142: p_information29 in varchar2 default hr_api.g_varchar2,
135: p_information22 in varchar2 default hr_api.g_varchar2,
136: p_information23 in varchar2 default hr_api.g_varchar2,
137: p_information24 in varchar2 default hr_api.g_varchar2,
138: p_information25 in varchar2 default hr_api.g_varchar2,
139: p_information26 in varchar2 default hr_api.g_varchar2,
140: p_information27 in varchar2 default hr_api.g_varchar2,
141: p_information28 in varchar2 default hr_api.g_varchar2,
142: p_information29 in varchar2 default hr_api.g_varchar2,
143: p_information30 in varchar2 default hr_api.g_varchar2,
136: p_information23 in varchar2 default hr_api.g_varchar2,
137: p_information24 in varchar2 default hr_api.g_varchar2,
138: p_information25 in varchar2 default hr_api.g_varchar2,
139: p_information26 in varchar2 default hr_api.g_varchar2,
140: p_information27 in varchar2 default hr_api.g_varchar2,
141: p_information28 in varchar2 default hr_api.g_varchar2,
142: p_information29 in varchar2 default hr_api.g_varchar2,
143: p_information30 in varchar2 default hr_api.g_varchar2,
144: p_object_version_number in out nocopy number
137: p_information24 in varchar2 default hr_api.g_varchar2,
138: p_information25 in varchar2 default hr_api.g_varchar2,
139: p_information26 in varchar2 default hr_api.g_varchar2,
140: p_information27 in varchar2 default hr_api.g_varchar2,
141: p_information28 in varchar2 default hr_api.g_varchar2,
142: p_information29 in varchar2 default hr_api.g_varchar2,
143: p_information30 in varchar2 default hr_api.g_varchar2,
144: p_object_version_number in out nocopy number
145: );
138: p_information25 in varchar2 default hr_api.g_varchar2,
139: p_information26 in varchar2 default hr_api.g_varchar2,
140: p_information27 in varchar2 default hr_api.g_varchar2,
141: p_information28 in varchar2 default hr_api.g_varchar2,
142: p_information29 in varchar2 default hr_api.g_varchar2,
143: p_information30 in varchar2 default hr_api.g_varchar2,
144: p_object_version_number in out nocopy number
145: );
146: --
139: p_information26 in varchar2 default hr_api.g_varchar2,
140: p_information27 in varchar2 default hr_api.g_varchar2,
141: p_information28 in varchar2 default hr_api.g_varchar2,
142: p_information29 in varchar2 default hr_api.g_varchar2,
143: p_information30 in varchar2 default hr_api.g_varchar2,
144: p_object_version_number in out nocopy number
145: );
146: --
147: end pqh_plg_upd;