190:
191:
192: -- WPM Logging Changes code Start :
193:
194: l_current_wpm_batch_action_id per_wpm_person_actions.wpm_batch_action_id%TYPE;
195:
196: -- Used for Logging the error/Warning/Eligibility Information of each assignment/scorecard/person
197: TYPE g_wpm_person_actions_r IS RECORD (
198: wpm_person_action_id per_wpm_person_actions.wpm_person_action_id%TYPE,
194: l_current_wpm_batch_action_id per_wpm_person_actions.wpm_batch_action_id%TYPE;
195:
196: -- Used for Logging the error/Warning/Eligibility Information of each assignment/scorecard/person
197: TYPE g_wpm_person_actions_r IS RECORD (
198: wpm_person_action_id per_wpm_person_actions.wpm_person_action_id%TYPE,
199: wpm_batch_action_id per_wpm_person_actions.wpm_batch_action_id%TYPE,
200: person_id per_wpm_person_actions.person_id%TYPE,
201: assignment_id per_wpm_person_actions.assignment_id%TYPE,
202: business_group_id per_wpm_person_actions.business_group_id%TYPE,
195:
196: -- Used for Logging the error/Warning/Eligibility Information of each assignment/scorecard/person
197: TYPE g_wpm_person_actions_r IS RECORD (
198: wpm_person_action_id per_wpm_person_actions.wpm_person_action_id%TYPE,
199: wpm_batch_action_id per_wpm_person_actions.wpm_batch_action_id%TYPE,
200: person_id per_wpm_person_actions.person_id%TYPE,
201: assignment_id per_wpm_person_actions.assignment_id%TYPE,
202: business_group_id per_wpm_person_actions.business_group_id%TYPE,
203: processing_status per_wpm_person_actions.processing_status%TYPE,
196: -- Used for Logging the error/Warning/Eligibility Information of each assignment/scorecard/person
197: TYPE g_wpm_person_actions_r IS RECORD (
198: wpm_person_action_id per_wpm_person_actions.wpm_person_action_id%TYPE,
199: wpm_batch_action_id per_wpm_person_actions.wpm_batch_action_id%TYPE,
200: person_id per_wpm_person_actions.person_id%TYPE,
201: assignment_id per_wpm_person_actions.assignment_id%TYPE,
202: business_group_id per_wpm_person_actions.business_group_id%TYPE,
203: processing_status per_wpm_person_actions.processing_status%TYPE,
204: eligibility_status per_wpm_person_actions.eligibility_status%TYPE,
197: TYPE g_wpm_person_actions_r IS RECORD (
198: wpm_person_action_id per_wpm_person_actions.wpm_person_action_id%TYPE,
199: wpm_batch_action_id per_wpm_person_actions.wpm_batch_action_id%TYPE,
200: person_id per_wpm_person_actions.person_id%TYPE,
201: assignment_id per_wpm_person_actions.assignment_id%TYPE,
202: business_group_id per_wpm_person_actions.business_group_id%TYPE,
203: processing_status per_wpm_person_actions.processing_status%TYPE,
204: eligibility_status per_wpm_person_actions.eligibility_status%TYPE,
205: MESSAGE_TYPE per_wpm_person_actions.MESSAGE_TYPE%TYPE,
198: wpm_person_action_id per_wpm_person_actions.wpm_person_action_id%TYPE,
199: wpm_batch_action_id per_wpm_person_actions.wpm_batch_action_id%TYPE,
200: person_id per_wpm_person_actions.person_id%TYPE,
201: assignment_id per_wpm_person_actions.assignment_id%TYPE,
202: business_group_id per_wpm_person_actions.business_group_id%TYPE,
203: processing_status per_wpm_person_actions.processing_status%TYPE,
204: eligibility_status per_wpm_person_actions.eligibility_status%TYPE,
205: MESSAGE_TYPE per_wpm_person_actions.MESSAGE_TYPE%TYPE,
206: message_number per_wpm_person_actions.message_number%TYPE,
199: wpm_batch_action_id per_wpm_person_actions.wpm_batch_action_id%TYPE,
200: person_id per_wpm_person_actions.person_id%TYPE,
201: assignment_id per_wpm_person_actions.assignment_id%TYPE,
202: business_group_id per_wpm_person_actions.business_group_id%TYPE,
203: processing_status per_wpm_person_actions.processing_status%TYPE,
204: eligibility_status per_wpm_person_actions.eligibility_status%TYPE,
205: MESSAGE_TYPE per_wpm_person_actions.MESSAGE_TYPE%TYPE,
206: message_number per_wpm_person_actions.message_number%TYPE,
207: MESSAGE_TEXT per_wpm_person_actions.MESSAGE_TEXT%TYPE,
200: person_id per_wpm_person_actions.person_id%TYPE,
201: assignment_id per_wpm_person_actions.assignment_id%TYPE,
202: business_group_id per_wpm_person_actions.business_group_id%TYPE,
203: processing_status per_wpm_person_actions.processing_status%TYPE,
204: eligibility_status per_wpm_person_actions.eligibility_status%TYPE,
205: MESSAGE_TYPE per_wpm_person_actions.MESSAGE_TYPE%TYPE,
206: message_number per_wpm_person_actions.message_number%TYPE,
207: MESSAGE_TEXT per_wpm_person_actions.MESSAGE_TEXT%TYPE,
208: transaction_ref_table per_wpm_person_actions.transaction_ref_table%TYPE,
201: assignment_id per_wpm_person_actions.assignment_id%TYPE,
202: business_group_id per_wpm_person_actions.business_group_id%TYPE,
203: processing_status per_wpm_person_actions.processing_status%TYPE,
204: eligibility_status per_wpm_person_actions.eligibility_status%TYPE,
205: MESSAGE_TYPE per_wpm_person_actions.MESSAGE_TYPE%TYPE,
206: message_number per_wpm_person_actions.message_number%TYPE,
207: MESSAGE_TEXT per_wpm_person_actions.MESSAGE_TEXT%TYPE,
208: transaction_ref_table per_wpm_person_actions.transaction_ref_table%TYPE,
209: transaction_ref_id per_wpm_person_actions.transaction_ref_id%TYPE,
202: business_group_id per_wpm_person_actions.business_group_id%TYPE,
203: processing_status per_wpm_person_actions.processing_status%TYPE,
204: eligibility_status per_wpm_person_actions.eligibility_status%TYPE,
205: MESSAGE_TYPE per_wpm_person_actions.MESSAGE_TYPE%TYPE,
206: message_number per_wpm_person_actions.message_number%TYPE,
207: MESSAGE_TEXT per_wpm_person_actions.MESSAGE_TEXT%TYPE,
208: transaction_ref_table per_wpm_person_actions.transaction_ref_table%TYPE,
209: transaction_ref_id per_wpm_person_actions.transaction_ref_id%TYPE,
210: information_category per_wpm_person_actions.information_category%TYPE,
203: processing_status per_wpm_person_actions.processing_status%TYPE,
204: eligibility_status per_wpm_person_actions.eligibility_status%TYPE,
205: MESSAGE_TYPE per_wpm_person_actions.MESSAGE_TYPE%TYPE,
206: message_number per_wpm_person_actions.message_number%TYPE,
207: MESSAGE_TEXT per_wpm_person_actions.MESSAGE_TEXT%TYPE,
208: transaction_ref_table per_wpm_person_actions.transaction_ref_table%TYPE,
209: transaction_ref_id per_wpm_person_actions.transaction_ref_id%TYPE,
210: information_category per_wpm_person_actions.information_category%TYPE,
211: information1 per_wpm_person_actions.information1%TYPE,
204: eligibility_status per_wpm_person_actions.eligibility_status%TYPE,
205: MESSAGE_TYPE per_wpm_person_actions.MESSAGE_TYPE%TYPE,
206: message_number per_wpm_person_actions.message_number%TYPE,
207: MESSAGE_TEXT per_wpm_person_actions.MESSAGE_TEXT%TYPE,
208: transaction_ref_table per_wpm_person_actions.transaction_ref_table%TYPE,
209: transaction_ref_id per_wpm_person_actions.transaction_ref_id%TYPE,
210: information_category per_wpm_person_actions.information_category%TYPE,
211: information1 per_wpm_person_actions.information1%TYPE,
212: information2 per_wpm_person_actions.information2%TYPE,
205: MESSAGE_TYPE per_wpm_person_actions.MESSAGE_TYPE%TYPE,
206: message_number per_wpm_person_actions.message_number%TYPE,
207: MESSAGE_TEXT per_wpm_person_actions.MESSAGE_TEXT%TYPE,
208: transaction_ref_table per_wpm_person_actions.transaction_ref_table%TYPE,
209: transaction_ref_id per_wpm_person_actions.transaction_ref_id%TYPE,
210: information_category per_wpm_person_actions.information_category%TYPE,
211: information1 per_wpm_person_actions.information1%TYPE,
212: information2 per_wpm_person_actions.information2%TYPE,
213: information3 per_wpm_person_actions.information3%TYPE,
206: message_number per_wpm_person_actions.message_number%TYPE,
207: MESSAGE_TEXT per_wpm_person_actions.MESSAGE_TEXT%TYPE,
208: transaction_ref_table per_wpm_person_actions.transaction_ref_table%TYPE,
209: transaction_ref_id per_wpm_person_actions.transaction_ref_id%TYPE,
210: information_category per_wpm_person_actions.information_category%TYPE,
211: information1 per_wpm_person_actions.information1%TYPE,
212: information2 per_wpm_person_actions.information2%TYPE,
213: information3 per_wpm_person_actions.information3%TYPE,
214: information4 per_wpm_person_actions.information4%TYPE,
207: MESSAGE_TEXT per_wpm_person_actions.MESSAGE_TEXT%TYPE,
208: transaction_ref_table per_wpm_person_actions.transaction_ref_table%TYPE,
209: transaction_ref_id per_wpm_person_actions.transaction_ref_id%TYPE,
210: information_category per_wpm_person_actions.information_category%TYPE,
211: information1 per_wpm_person_actions.information1%TYPE,
212: information2 per_wpm_person_actions.information2%TYPE,
213: information3 per_wpm_person_actions.information3%TYPE,
214: information4 per_wpm_person_actions.information4%TYPE,
215: information5 per_wpm_person_actions.information5%TYPE,
208: transaction_ref_table per_wpm_person_actions.transaction_ref_table%TYPE,
209: transaction_ref_id per_wpm_person_actions.transaction_ref_id%TYPE,
210: information_category per_wpm_person_actions.information_category%TYPE,
211: information1 per_wpm_person_actions.information1%TYPE,
212: information2 per_wpm_person_actions.information2%TYPE,
213: information3 per_wpm_person_actions.information3%TYPE,
214: information4 per_wpm_person_actions.information4%TYPE,
215: information5 per_wpm_person_actions.information5%TYPE,
216: information6 per_wpm_person_actions.information6%TYPE,
209: transaction_ref_id per_wpm_person_actions.transaction_ref_id%TYPE,
210: information_category per_wpm_person_actions.information_category%TYPE,
211: information1 per_wpm_person_actions.information1%TYPE,
212: information2 per_wpm_person_actions.information2%TYPE,
213: information3 per_wpm_person_actions.information3%TYPE,
214: information4 per_wpm_person_actions.information4%TYPE,
215: information5 per_wpm_person_actions.information5%TYPE,
216: information6 per_wpm_person_actions.information6%TYPE,
217: information7 per_wpm_person_actions.information7%TYPE,
210: information_category per_wpm_person_actions.information_category%TYPE,
211: information1 per_wpm_person_actions.information1%TYPE,
212: information2 per_wpm_person_actions.information2%TYPE,
213: information3 per_wpm_person_actions.information3%TYPE,
214: information4 per_wpm_person_actions.information4%TYPE,
215: information5 per_wpm_person_actions.information5%TYPE,
216: information6 per_wpm_person_actions.information6%TYPE,
217: information7 per_wpm_person_actions.information7%TYPE,
218: information8 per_wpm_person_actions.information8%TYPE,
211: information1 per_wpm_person_actions.information1%TYPE,
212: information2 per_wpm_person_actions.information2%TYPE,
213: information3 per_wpm_person_actions.information3%TYPE,
214: information4 per_wpm_person_actions.information4%TYPE,
215: information5 per_wpm_person_actions.information5%TYPE,
216: information6 per_wpm_person_actions.information6%TYPE,
217: information7 per_wpm_person_actions.information7%TYPE,
218: information8 per_wpm_person_actions.information8%TYPE,
219: information9 per_wpm_person_actions.information9%TYPE,
212: information2 per_wpm_person_actions.information2%TYPE,
213: information3 per_wpm_person_actions.information3%TYPE,
214: information4 per_wpm_person_actions.information4%TYPE,
215: information5 per_wpm_person_actions.information5%TYPE,
216: information6 per_wpm_person_actions.information6%TYPE,
217: information7 per_wpm_person_actions.information7%TYPE,
218: information8 per_wpm_person_actions.information8%TYPE,
219: information9 per_wpm_person_actions.information9%TYPE,
220: information10 per_wpm_person_actions.information10%TYPE,
213: information3 per_wpm_person_actions.information3%TYPE,
214: information4 per_wpm_person_actions.information4%TYPE,
215: information5 per_wpm_person_actions.information5%TYPE,
216: information6 per_wpm_person_actions.information6%TYPE,
217: information7 per_wpm_person_actions.information7%TYPE,
218: information8 per_wpm_person_actions.information8%TYPE,
219: information9 per_wpm_person_actions.information9%TYPE,
220: information10 per_wpm_person_actions.information10%TYPE,
221: information11 per_wpm_person_actions.information11%TYPE,
214: information4 per_wpm_person_actions.information4%TYPE,
215: information5 per_wpm_person_actions.information5%TYPE,
216: information6 per_wpm_person_actions.information6%TYPE,
217: information7 per_wpm_person_actions.information7%TYPE,
218: information8 per_wpm_person_actions.information8%TYPE,
219: information9 per_wpm_person_actions.information9%TYPE,
220: information10 per_wpm_person_actions.information10%TYPE,
221: information11 per_wpm_person_actions.information11%TYPE,
222: information12 per_wpm_person_actions.information12%TYPE,
215: information5 per_wpm_person_actions.information5%TYPE,
216: information6 per_wpm_person_actions.information6%TYPE,
217: information7 per_wpm_person_actions.information7%TYPE,
218: information8 per_wpm_person_actions.information8%TYPE,
219: information9 per_wpm_person_actions.information9%TYPE,
220: information10 per_wpm_person_actions.information10%TYPE,
221: information11 per_wpm_person_actions.information11%TYPE,
222: information12 per_wpm_person_actions.information12%TYPE,
223: information13 per_wpm_person_actions.information13%TYPE,
216: information6 per_wpm_person_actions.information6%TYPE,
217: information7 per_wpm_person_actions.information7%TYPE,
218: information8 per_wpm_person_actions.information8%TYPE,
219: information9 per_wpm_person_actions.information9%TYPE,
220: information10 per_wpm_person_actions.information10%TYPE,
221: information11 per_wpm_person_actions.information11%TYPE,
222: information12 per_wpm_person_actions.information12%TYPE,
223: information13 per_wpm_person_actions.information13%TYPE,
224: information14 per_wpm_person_actions.information14%TYPE,
217: information7 per_wpm_person_actions.information7%TYPE,
218: information8 per_wpm_person_actions.information8%TYPE,
219: information9 per_wpm_person_actions.information9%TYPE,
220: information10 per_wpm_person_actions.information10%TYPE,
221: information11 per_wpm_person_actions.information11%TYPE,
222: information12 per_wpm_person_actions.information12%TYPE,
223: information13 per_wpm_person_actions.information13%TYPE,
224: information14 per_wpm_person_actions.information14%TYPE,
225: information15 per_wpm_person_actions.information15%TYPE,
218: information8 per_wpm_person_actions.information8%TYPE,
219: information9 per_wpm_person_actions.information9%TYPE,
220: information10 per_wpm_person_actions.information10%TYPE,
221: information11 per_wpm_person_actions.information11%TYPE,
222: information12 per_wpm_person_actions.information12%TYPE,
223: information13 per_wpm_person_actions.information13%TYPE,
224: information14 per_wpm_person_actions.information14%TYPE,
225: information15 per_wpm_person_actions.information15%TYPE,
226: information16 per_wpm_person_actions.information16%TYPE,
219: information9 per_wpm_person_actions.information9%TYPE,
220: information10 per_wpm_person_actions.information10%TYPE,
221: information11 per_wpm_person_actions.information11%TYPE,
222: information12 per_wpm_person_actions.information12%TYPE,
223: information13 per_wpm_person_actions.information13%TYPE,
224: information14 per_wpm_person_actions.information14%TYPE,
225: information15 per_wpm_person_actions.information15%TYPE,
226: information16 per_wpm_person_actions.information16%TYPE,
227: information17 per_wpm_person_actions.information17%TYPE,
220: information10 per_wpm_person_actions.information10%TYPE,
221: information11 per_wpm_person_actions.information11%TYPE,
222: information12 per_wpm_person_actions.information12%TYPE,
223: information13 per_wpm_person_actions.information13%TYPE,
224: information14 per_wpm_person_actions.information14%TYPE,
225: information15 per_wpm_person_actions.information15%TYPE,
226: information16 per_wpm_person_actions.information16%TYPE,
227: information17 per_wpm_person_actions.information17%TYPE,
228: information18 per_wpm_person_actions.information18%TYPE,
221: information11 per_wpm_person_actions.information11%TYPE,
222: information12 per_wpm_person_actions.information12%TYPE,
223: information13 per_wpm_person_actions.information13%TYPE,
224: information14 per_wpm_person_actions.information14%TYPE,
225: information15 per_wpm_person_actions.information15%TYPE,
226: information16 per_wpm_person_actions.information16%TYPE,
227: information17 per_wpm_person_actions.information17%TYPE,
228: information18 per_wpm_person_actions.information18%TYPE,
229: information19 per_wpm_person_actions.information19%TYPE,
222: information12 per_wpm_person_actions.information12%TYPE,
223: information13 per_wpm_person_actions.information13%TYPE,
224: information14 per_wpm_person_actions.information14%TYPE,
225: information15 per_wpm_person_actions.information15%TYPE,
226: information16 per_wpm_person_actions.information16%TYPE,
227: information17 per_wpm_person_actions.information17%TYPE,
228: information18 per_wpm_person_actions.information18%TYPE,
229: information19 per_wpm_person_actions.information19%TYPE,
230: information20 per_wpm_person_actions.information20%TYPE
223: information13 per_wpm_person_actions.information13%TYPE,
224: information14 per_wpm_person_actions.information14%TYPE,
225: information15 per_wpm_person_actions.information15%TYPE,
226: information16 per_wpm_person_actions.information16%TYPE,
227: information17 per_wpm_person_actions.information17%TYPE,
228: information18 per_wpm_person_actions.information18%TYPE,
229: information19 per_wpm_person_actions.information19%TYPE,
230: information20 per_wpm_person_actions.information20%TYPE
231: );
224: information14 per_wpm_person_actions.information14%TYPE,
225: information15 per_wpm_person_actions.information15%TYPE,
226: information16 per_wpm_person_actions.information16%TYPE,
227: information17 per_wpm_person_actions.information17%TYPE,
228: information18 per_wpm_person_actions.information18%TYPE,
229: information19 per_wpm_person_actions.information19%TYPE,
230: information20 per_wpm_person_actions.information20%TYPE
231: );
232:
225: information15 per_wpm_person_actions.information15%TYPE,
226: information16 per_wpm_person_actions.information16%TYPE,
227: information17 per_wpm_person_actions.information17%TYPE,
228: information18 per_wpm_person_actions.information18%TYPE,
229: information19 per_wpm_person_actions.information19%TYPE,
230: information20 per_wpm_person_actions.information20%TYPE
231: );
232:
233: TYPE g_wpm_person_actions_t IS TABLE OF g_wpm_person_actions_r
226: information16 per_wpm_person_actions.information16%TYPE,
227: information17 per_wpm_person_actions.information17%TYPE,
228: information18 per_wpm_person_actions.information18%TYPE,
229: information19 per_wpm_person_actions.information19%TYPE,
230: information20 per_wpm_person_actions.information20%TYPE
231: );
232:
233: TYPE g_wpm_person_actions_t IS TABLE OF g_wpm_person_actions_r
234: INDEX BY BINARY_INTEGER;