DBA Data[Home] [Help]

APPS.HR_WPM_MASS_APR_PUSH dependencies on PER_WPM_PERSON_ACTIONS

Line 194: l_current_wpm_batch_action_id per_wpm_person_actions.wpm_batch_action_id%TYPE;

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,

Line 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,

Line 199: 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,
203: processing_status per_wpm_person_actions.processing_status%TYPE,

Line 200: person_id per_wpm_person_actions.person_id%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,

Line 201: assignment_id per_wpm_person_actions.assignment_id%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,

Line 202: business_group_id per_wpm_person_actions.business_group_id%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,

Line 203: processing_status per_wpm_person_actions.processing_status%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,

Line 204: eligibility_status per_wpm_person_actions.eligibility_status%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,

Line 205: MESSAGE_TYPE per_wpm_person_actions.MESSAGE_TYPE%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,

Line 206: message_number per_wpm_person_actions.message_number%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,

Line 207: MESSAGE_TEXT per_wpm_person_actions.MESSAGE_TEXT%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,

Line 208: transaction_ref_table per_wpm_person_actions.transaction_ref_table%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,

Line 209: transaction_ref_id per_wpm_person_actions.transaction_ref_id%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,

Line 210: information_category per_wpm_person_actions.information_category%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,

Line 211: information1 per_wpm_person_actions.information1%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,

Line 212: information2 per_wpm_person_actions.information2%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,

Line 213: information3 per_wpm_person_actions.information3%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,

Line 214: information4 per_wpm_person_actions.information4%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,

Line 215: information5 per_wpm_person_actions.information5%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,

Line 216: information6 per_wpm_person_actions.information6%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,

Line 217: information7 per_wpm_person_actions.information7%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,

Line 218: information8 per_wpm_person_actions.information8%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,

Line 219: information9 per_wpm_person_actions.information9%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,

Line 220: information10 per_wpm_person_actions.information10%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,

Line 221: information11 per_wpm_person_actions.information11%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,

Line 222: information12 per_wpm_person_actions.information12%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,

Line 223: information13 per_wpm_person_actions.information13%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,

Line 224: information14 per_wpm_person_actions.information14%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,

Line 225: information15 per_wpm_person_actions.information15%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,

Line 226: information16 per_wpm_person_actions.information16%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

Line 227: information17 per_wpm_person_actions.information17%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: );

Line 228: information18 per_wpm_person_actions.information18%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: );
232:

Line 229: information19 per_wpm_person_actions.information19%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:
233: TYPE g_wpm_person_actions_t IS TABLE OF g_wpm_person_actions_r

Line 230: information20 per_wpm_person_actions.information20%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
234: INDEX BY BINARY_INTEGER;