eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_IN_EXTRA_ASG_INFO_LEG_HOOK dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 226: FROM per_assignment_extra_info

222: ,aei_information27
223: ,aei_information28
224: ,aei_information29
225: ,aei_information30
226: FROM per_assignment_extra_info
227: WHERE assignment_extra_info_id = p_assignment_extra_info_id;
228:
229: l_procedure VARCHAR2(100);
230: l_message_name VARCHAR2(255);

Line 231: l_assignment_id per_assignment_extra_info.assignment_id%type;

227: WHERE assignment_extra_info_id = p_assignment_extra_info_id;
228:
229: l_procedure VARCHAR2(100);
230: l_message_name VARCHAR2(255);
231: l_assignment_id per_assignment_extra_info.assignment_id%type;
232: l_aei_information1 per_assignment_extra_info.aei_information1%type;
233: l_aei_information2 per_assignment_extra_info.aei_information1%type;
234: l_aei_information3 per_assignment_extra_info.aei_information1%type;
235: l_aei_information4 per_assignment_extra_info.aei_information1%type;

Line 232: l_aei_information1 per_assignment_extra_info.aei_information1%type;

228:
229: l_procedure VARCHAR2(100);
230: l_message_name VARCHAR2(255);
231: l_assignment_id per_assignment_extra_info.assignment_id%type;
232: l_aei_information1 per_assignment_extra_info.aei_information1%type;
233: l_aei_information2 per_assignment_extra_info.aei_information1%type;
234: l_aei_information3 per_assignment_extra_info.aei_information1%type;
235: l_aei_information4 per_assignment_extra_info.aei_information1%type;
236: l_aei_information5 per_assignment_extra_info.aei_information1%type;

Line 233: l_aei_information2 per_assignment_extra_info.aei_information1%type;

229: l_procedure VARCHAR2(100);
230: l_message_name VARCHAR2(255);
231: l_assignment_id per_assignment_extra_info.assignment_id%type;
232: l_aei_information1 per_assignment_extra_info.aei_information1%type;
233: l_aei_information2 per_assignment_extra_info.aei_information1%type;
234: l_aei_information3 per_assignment_extra_info.aei_information1%type;
235: l_aei_information4 per_assignment_extra_info.aei_information1%type;
236: l_aei_information5 per_assignment_extra_info.aei_information1%type;
237: l_aei_information6 per_assignment_extra_info.aei_information1%type;

Line 234: l_aei_information3 per_assignment_extra_info.aei_information1%type;

230: l_message_name VARCHAR2(255);
231: l_assignment_id per_assignment_extra_info.assignment_id%type;
232: l_aei_information1 per_assignment_extra_info.aei_information1%type;
233: l_aei_information2 per_assignment_extra_info.aei_information1%type;
234: l_aei_information3 per_assignment_extra_info.aei_information1%type;
235: l_aei_information4 per_assignment_extra_info.aei_information1%type;
236: l_aei_information5 per_assignment_extra_info.aei_information1%type;
237: l_aei_information6 per_assignment_extra_info.aei_information1%type;
238: l_aei_information7 per_assignment_extra_info.aei_information1%type;

Line 235: l_aei_information4 per_assignment_extra_info.aei_information1%type;

231: l_assignment_id per_assignment_extra_info.assignment_id%type;
232: l_aei_information1 per_assignment_extra_info.aei_information1%type;
233: l_aei_information2 per_assignment_extra_info.aei_information1%type;
234: l_aei_information3 per_assignment_extra_info.aei_information1%type;
235: l_aei_information4 per_assignment_extra_info.aei_information1%type;
236: l_aei_information5 per_assignment_extra_info.aei_information1%type;
237: l_aei_information6 per_assignment_extra_info.aei_information1%type;
238: l_aei_information7 per_assignment_extra_info.aei_information1%type;
239: l_aei_information8 per_assignment_extra_info.aei_information1%type;

Line 236: l_aei_information5 per_assignment_extra_info.aei_information1%type;

232: l_aei_information1 per_assignment_extra_info.aei_information1%type;
233: l_aei_information2 per_assignment_extra_info.aei_information1%type;
234: l_aei_information3 per_assignment_extra_info.aei_information1%type;
235: l_aei_information4 per_assignment_extra_info.aei_information1%type;
236: l_aei_information5 per_assignment_extra_info.aei_information1%type;
237: l_aei_information6 per_assignment_extra_info.aei_information1%type;
238: l_aei_information7 per_assignment_extra_info.aei_information1%type;
239: l_aei_information8 per_assignment_extra_info.aei_information1%type;
240: l_aei_information9 per_assignment_extra_info.aei_information1%type;

Line 237: l_aei_information6 per_assignment_extra_info.aei_information1%type;

233: l_aei_information2 per_assignment_extra_info.aei_information1%type;
234: l_aei_information3 per_assignment_extra_info.aei_information1%type;
235: l_aei_information4 per_assignment_extra_info.aei_information1%type;
236: l_aei_information5 per_assignment_extra_info.aei_information1%type;
237: l_aei_information6 per_assignment_extra_info.aei_information1%type;
238: l_aei_information7 per_assignment_extra_info.aei_information1%type;
239: l_aei_information8 per_assignment_extra_info.aei_information1%type;
240: l_aei_information9 per_assignment_extra_info.aei_information1%type;
241: l_aei_information10 per_assignment_extra_info.aei_information1%type;

Line 238: l_aei_information7 per_assignment_extra_info.aei_information1%type;

234: l_aei_information3 per_assignment_extra_info.aei_information1%type;
235: l_aei_information4 per_assignment_extra_info.aei_information1%type;
236: l_aei_information5 per_assignment_extra_info.aei_information1%type;
237: l_aei_information6 per_assignment_extra_info.aei_information1%type;
238: l_aei_information7 per_assignment_extra_info.aei_information1%type;
239: l_aei_information8 per_assignment_extra_info.aei_information1%type;
240: l_aei_information9 per_assignment_extra_info.aei_information1%type;
241: l_aei_information10 per_assignment_extra_info.aei_information1%type;
242: l_aei_information11 per_assignment_extra_info.aei_information1%type;

Line 239: l_aei_information8 per_assignment_extra_info.aei_information1%type;

235: l_aei_information4 per_assignment_extra_info.aei_information1%type;
236: l_aei_information5 per_assignment_extra_info.aei_information1%type;
237: l_aei_information6 per_assignment_extra_info.aei_information1%type;
238: l_aei_information7 per_assignment_extra_info.aei_information1%type;
239: l_aei_information8 per_assignment_extra_info.aei_information1%type;
240: l_aei_information9 per_assignment_extra_info.aei_information1%type;
241: l_aei_information10 per_assignment_extra_info.aei_information1%type;
242: l_aei_information11 per_assignment_extra_info.aei_information1%type;
243: l_aei_information12 per_assignment_extra_info.aei_information1%type;

Line 240: l_aei_information9 per_assignment_extra_info.aei_information1%type;

236: l_aei_information5 per_assignment_extra_info.aei_information1%type;
237: l_aei_information6 per_assignment_extra_info.aei_information1%type;
238: l_aei_information7 per_assignment_extra_info.aei_information1%type;
239: l_aei_information8 per_assignment_extra_info.aei_information1%type;
240: l_aei_information9 per_assignment_extra_info.aei_information1%type;
241: l_aei_information10 per_assignment_extra_info.aei_information1%type;
242: l_aei_information11 per_assignment_extra_info.aei_information1%type;
243: l_aei_information12 per_assignment_extra_info.aei_information1%type;
244: l_aei_information13 per_assignment_extra_info.aei_information1%type;

Line 241: l_aei_information10 per_assignment_extra_info.aei_information1%type;

237: l_aei_information6 per_assignment_extra_info.aei_information1%type;
238: l_aei_information7 per_assignment_extra_info.aei_information1%type;
239: l_aei_information8 per_assignment_extra_info.aei_information1%type;
240: l_aei_information9 per_assignment_extra_info.aei_information1%type;
241: l_aei_information10 per_assignment_extra_info.aei_information1%type;
242: l_aei_information11 per_assignment_extra_info.aei_information1%type;
243: l_aei_information12 per_assignment_extra_info.aei_information1%type;
244: l_aei_information13 per_assignment_extra_info.aei_information1%type;
245: l_aei_information14 per_assignment_extra_info.aei_information1%type;

Line 242: l_aei_information11 per_assignment_extra_info.aei_information1%type;

238: l_aei_information7 per_assignment_extra_info.aei_information1%type;
239: l_aei_information8 per_assignment_extra_info.aei_information1%type;
240: l_aei_information9 per_assignment_extra_info.aei_information1%type;
241: l_aei_information10 per_assignment_extra_info.aei_information1%type;
242: l_aei_information11 per_assignment_extra_info.aei_information1%type;
243: l_aei_information12 per_assignment_extra_info.aei_information1%type;
244: l_aei_information13 per_assignment_extra_info.aei_information1%type;
245: l_aei_information14 per_assignment_extra_info.aei_information1%type;
246: l_aei_information15 per_assignment_extra_info.aei_information1%type;

Line 243: l_aei_information12 per_assignment_extra_info.aei_information1%type;

239: l_aei_information8 per_assignment_extra_info.aei_information1%type;
240: l_aei_information9 per_assignment_extra_info.aei_information1%type;
241: l_aei_information10 per_assignment_extra_info.aei_information1%type;
242: l_aei_information11 per_assignment_extra_info.aei_information1%type;
243: l_aei_information12 per_assignment_extra_info.aei_information1%type;
244: l_aei_information13 per_assignment_extra_info.aei_information1%type;
245: l_aei_information14 per_assignment_extra_info.aei_information1%type;
246: l_aei_information15 per_assignment_extra_info.aei_information1%type;
247: l_aei_information16 per_assignment_extra_info.aei_information1%type;

Line 244: l_aei_information13 per_assignment_extra_info.aei_information1%type;

240: l_aei_information9 per_assignment_extra_info.aei_information1%type;
241: l_aei_information10 per_assignment_extra_info.aei_information1%type;
242: l_aei_information11 per_assignment_extra_info.aei_information1%type;
243: l_aei_information12 per_assignment_extra_info.aei_information1%type;
244: l_aei_information13 per_assignment_extra_info.aei_information1%type;
245: l_aei_information14 per_assignment_extra_info.aei_information1%type;
246: l_aei_information15 per_assignment_extra_info.aei_information1%type;
247: l_aei_information16 per_assignment_extra_info.aei_information1%type;
248: l_aei_information17 per_assignment_extra_info.aei_information1%type;

Line 245: l_aei_information14 per_assignment_extra_info.aei_information1%type;

241: l_aei_information10 per_assignment_extra_info.aei_information1%type;
242: l_aei_information11 per_assignment_extra_info.aei_information1%type;
243: l_aei_information12 per_assignment_extra_info.aei_information1%type;
244: l_aei_information13 per_assignment_extra_info.aei_information1%type;
245: l_aei_information14 per_assignment_extra_info.aei_information1%type;
246: l_aei_information15 per_assignment_extra_info.aei_information1%type;
247: l_aei_information16 per_assignment_extra_info.aei_information1%type;
248: l_aei_information17 per_assignment_extra_info.aei_information1%type;
249: l_aei_information18 per_assignment_extra_info.aei_information1%type;

Line 246: l_aei_information15 per_assignment_extra_info.aei_information1%type;

242: l_aei_information11 per_assignment_extra_info.aei_information1%type;
243: l_aei_information12 per_assignment_extra_info.aei_information1%type;
244: l_aei_information13 per_assignment_extra_info.aei_information1%type;
245: l_aei_information14 per_assignment_extra_info.aei_information1%type;
246: l_aei_information15 per_assignment_extra_info.aei_information1%type;
247: l_aei_information16 per_assignment_extra_info.aei_information1%type;
248: l_aei_information17 per_assignment_extra_info.aei_information1%type;
249: l_aei_information18 per_assignment_extra_info.aei_information1%type;
250: l_aei_information19 per_assignment_extra_info.aei_information1%type;

Line 247: l_aei_information16 per_assignment_extra_info.aei_information1%type;

243: l_aei_information12 per_assignment_extra_info.aei_information1%type;
244: l_aei_information13 per_assignment_extra_info.aei_information1%type;
245: l_aei_information14 per_assignment_extra_info.aei_information1%type;
246: l_aei_information15 per_assignment_extra_info.aei_information1%type;
247: l_aei_information16 per_assignment_extra_info.aei_information1%type;
248: l_aei_information17 per_assignment_extra_info.aei_information1%type;
249: l_aei_information18 per_assignment_extra_info.aei_information1%type;
250: l_aei_information19 per_assignment_extra_info.aei_information1%type;
251: l_aei_information20 per_assignment_extra_info.aei_information1%type;

Line 248: l_aei_information17 per_assignment_extra_info.aei_information1%type;

244: l_aei_information13 per_assignment_extra_info.aei_information1%type;
245: l_aei_information14 per_assignment_extra_info.aei_information1%type;
246: l_aei_information15 per_assignment_extra_info.aei_information1%type;
247: l_aei_information16 per_assignment_extra_info.aei_information1%type;
248: l_aei_information17 per_assignment_extra_info.aei_information1%type;
249: l_aei_information18 per_assignment_extra_info.aei_information1%type;
250: l_aei_information19 per_assignment_extra_info.aei_information1%type;
251: l_aei_information20 per_assignment_extra_info.aei_information1%type;
252: l_aei_information21 per_assignment_extra_info.aei_information1%type;

Line 249: l_aei_information18 per_assignment_extra_info.aei_information1%type;

245: l_aei_information14 per_assignment_extra_info.aei_information1%type;
246: l_aei_information15 per_assignment_extra_info.aei_information1%type;
247: l_aei_information16 per_assignment_extra_info.aei_information1%type;
248: l_aei_information17 per_assignment_extra_info.aei_information1%type;
249: l_aei_information18 per_assignment_extra_info.aei_information1%type;
250: l_aei_information19 per_assignment_extra_info.aei_information1%type;
251: l_aei_information20 per_assignment_extra_info.aei_information1%type;
252: l_aei_information21 per_assignment_extra_info.aei_information1%type;
253: l_aei_information22 per_assignment_extra_info.aei_information1%type;

Line 250: l_aei_information19 per_assignment_extra_info.aei_information1%type;

246: l_aei_information15 per_assignment_extra_info.aei_information1%type;
247: l_aei_information16 per_assignment_extra_info.aei_information1%type;
248: l_aei_information17 per_assignment_extra_info.aei_information1%type;
249: l_aei_information18 per_assignment_extra_info.aei_information1%type;
250: l_aei_information19 per_assignment_extra_info.aei_information1%type;
251: l_aei_information20 per_assignment_extra_info.aei_information1%type;
252: l_aei_information21 per_assignment_extra_info.aei_information1%type;
253: l_aei_information22 per_assignment_extra_info.aei_information1%type;
254: l_aei_information23 per_assignment_extra_info.aei_information1%type;

Line 251: l_aei_information20 per_assignment_extra_info.aei_information1%type;

247: l_aei_information16 per_assignment_extra_info.aei_information1%type;
248: l_aei_information17 per_assignment_extra_info.aei_information1%type;
249: l_aei_information18 per_assignment_extra_info.aei_information1%type;
250: l_aei_information19 per_assignment_extra_info.aei_information1%type;
251: l_aei_information20 per_assignment_extra_info.aei_information1%type;
252: l_aei_information21 per_assignment_extra_info.aei_information1%type;
253: l_aei_information22 per_assignment_extra_info.aei_information1%type;
254: l_aei_information23 per_assignment_extra_info.aei_information1%type;
255: l_aei_information24 per_assignment_extra_info.aei_information1%type;

Line 252: l_aei_information21 per_assignment_extra_info.aei_information1%type;

248: l_aei_information17 per_assignment_extra_info.aei_information1%type;
249: l_aei_information18 per_assignment_extra_info.aei_information1%type;
250: l_aei_information19 per_assignment_extra_info.aei_information1%type;
251: l_aei_information20 per_assignment_extra_info.aei_information1%type;
252: l_aei_information21 per_assignment_extra_info.aei_information1%type;
253: l_aei_information22 per_assignment_extra_info.aei_information1%type;
254: l_aei_information23 per_assignment_extra_info.aei_information1%type;
255: l_aei_information24 per_assignment_extra_info.aei_information1%type;
256: l_aei_information25 per_assignment_extra_info.aei_information1%type;

Line 253: l_aei_information22 per_assignment_extra_info.aei_information1%type;

249: l_aei_information18 per_assignment_extra_info.aei_information1%type;
250: l_aei_information19 per_assignment_extra_info.aei_information1%type;
251: l_aei_information20 per_assignment_extra_info.aei_information1%type;
252: l_aei_information21 per_assignment_extra_info.aei_information1%type;
253: l_aei_information22 per_assignment_extra_info.aei_information1%type;
254: l_aei_information23 per_assignment_extra_info.aei_information1%type;
255: l_aei_information24 per_assignment_extra_info.aei_information1%type;
256: l_aei_information25 per_assignment_extra_info.aei_information1%type;
257: l_aei_information26 per_assignment_extra_info.aei_information1%type;

Line 254: l_aei_information23 per_assignment_extra_info.aei_information1%type;

250: l_aei_information19 per_assignment_extra_info.aei_information1%type;
251: l_aei_information20 per_assignment_extra_info.aei_information1%type;
252: l_aei_information21 per_assignment_extra_info.aei_information1%type;
253: l_aei_information22 per_assignment_extra_info.aei_information1%type;
254: l_aei_information23 per_assignment_extra_info.aei_information1%type;
255: l_aei_information24 per_assignment_extra_info.aei_information1%type;
256: l_aei_information25 per_assignment_extra_info.aei_information1%type;
257: l_aei_information26 per_assignment_extra_info.aei_information1%type;
258: l_aei_information27 per_assignment_extra_info.aei_information1%type;

Line 255: l_aei_information24 per_assignment_extra_info.aei_information1%type;

251: l_aei_information20 per_assignment_extra_info.aei_information1%type;
252: l_aei_information21 per_assignment_extra_info.aei_information1%type;
253: l_aei_information22 per_assignment_extra_info.aei_information1%type;
254: l_aei_information23 per_assignment_extra_info.aei_information1%type;
255: l_aei_information24 per_assignment_extra_info.aei_information1%type;
256: l_aei_information25 per_assignment_extra_info.aei_information1%type;
257: l_aei_information26 per_assignment_extra_info.aei_information1%type;
258: l_aei_information27 per_assignment_extra_info.aei_information1%type;
259: l_aei_information28 per_assignment_extra_info.aei_information1%type;

Line 256: l_aei_information25 per_assignment_extra_info.aei_information1%type;

252: l_aei_information21 per_assignment_extra_info.aei_information1%type;
253: l_aei_information22 per_assignment_extra_info.aei_information1%type;
254: l_aei_information23 per_assignment_extra_info.aei_information1%type;
255: l_aei_information24 per_assignment_extra_info.aei_information1%type;
256: l_aei_information25 per_assignment_extra_info.aei_information1%type;
257: l_aei_information26 per_assignment_extra_info.aei_information1%type;
258: l_aei_information27 per_assignment_extra_info.aei_information1%type;
259: l_aei_information28 per_assignment_extra_info.aei_information1%type;
260: l_aei_information29 per_assignment_extra_info.aei_information1%type;

Line 257: l_aei_information26 per_assignment_extra_info.aei_information1%type;

253: l_aei_information22 per_assignment_extra_info.aei_information1%type;
254: l_aei_information23 per_assignment_extra_info.aei_information1%type;
255: l_aei_information24 per_assignment_extra_info.aei_information1%type;
256: l_aei_information25 per_assignment_extra_info.aei_information1%type;
257: l_aei_information26 per_assignment_extra_info.aei_information1%type;
258: l_aei_information27 per_assignment_extra_info.aei_information1%type;
259: l_aei_information28 per_assignment_extra_info.aei_information1%type;
260: l_aei_information29 per_assignment_extra_info.aei_information1%type;
261: l_aei_information30 per_assignment_extra_info.aei_information1%type;

Line 258: l_aei_information27 per_assignment_extra_info.aei_information1%type;

254: l_aei_information23 per_assignment_extra_info.aei_information1%type;
255: l_aei_information24 per_assignment_extra_info.aei_information1%type;
256: l_aei_information25 per_assignment_extra_info.aei_information1%type;
257: l_aei_information26 per_assignment_extra_info.aei_information1%type;
258: l_aei_information27 per_assignment_extra_info.aei_information1%type;
259: l_aei_information28 per_assignment_extra_info.aei_information1%type;
260: l_aei_information29 per_assignment_extra_info.aei_information1%type;
261: l_aei_information30 per_assignment_extra_info.aei_information1%type;
262: BEGIN

Line 259: l_aei_information28 per_assignment_extra_info.aei_information1%type;

255: l_aei_information24 per_assignment_extra_info.aei_information1%type;
256: l_aei_information25 per_assignment_extra_info.aei_information1%type;
257: l_aei_information26 per_assignment_extra_info.aei_information1%type;
258: l_aei_information27 per_assignment_extra_info.aei_information1%type;
259: l_aei_information28 per_assignment_extra_info.aei_information1%type;
260: l_aei_information29 per_assignment_extra_info.aei_information1%type;
261: l_aei_information30 per_assignment_extra_info.aei_information1%type;
262: BEGIN
263:

Line 260: l_aei_information29 per_assignment_extra_info.aei_information1%type;

256: l_aei_information25 per_assignment_extra_info.aei_information1%type;
257: l_aei_information26 per_assignment_extra_info.aei_information1%type;
258: l_aei_information27 per_assignment_extra_info.aei_information1%type;
259: l_aei_information28 per_assignment_extra_info.aei_information1%type;
260: l_aei_information29 per_assignment_extra_info.aei_information1%type;
261: l_aei_information30 per_assignment_extra_info.aei_information1%type;
262: BEGIN
263:
264:

Line 261: l_aei_information30 per_assignment_extra_info.aei_information1%type;

257: l_aei_information26 per_assignment_extra_info.aei_information1%type;
258: l_aei_information27 per_assignment_extra_info.aei_information1%type;
259: l_aei_information28 per_assignment_extra_info.aei_information1%type;
260: l_aei_information29 per_assignment_extra_info.aei_information1%type;
261: l_aei_information30 per_assignment_extra_info.aei_information1%type;
262: BEGIN
263:
264:
265: l_procedure := g_package ||'check_asg_extra_info_update';

Line 517: FROM PER_ASSIGNMENT_EXTRA_INFO

513: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type) IS
514: CURSOR cur_check_unique_record_ins
515: IS
516: SELECT 1
517: FROM PER_ASSIGNMENT_EXTRA_INFO
518: WHERE assignment_id = p_assignment_id
519: AND aei_information1 = p_aei_information1
520: AND aei_information2 = p_aei_information2
521: AND aei_information_category = p_aei_information_category;

Line 526: FROM PER_ASSIGNMENT_EXTRA_INFO

522:
523: CURSOR cur_check_unique_record_upd
524: IS
525: SELECT 1
526: FROM PER_ASSIGNMENT_EXTRA_INFO
527: WHERE aei_information1 = p_aei_information1
528: AND aei_information2 = p_aei_information2
529: AND aei_information_category = p_aei_information_category
530: AND assignment_id = p_assignment_id