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.PY_ROLLBACK_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 236: from pay_element_entries_f pee,

232: procedure remove_retro_ee(p_assact_id in number) is
233: c_indent varchar2(40);
234: cursor ceev is
235: select pee.element_entry_id
236: from pay_element_entries_f pee,
237: pay_assignment_actions paa
238: where paa.assignment_action_id = p_assact_id
239: and pee.assignment_id = paa.assignment_id
240: and pee.creator_id = paa.assignment_action_id

Line 253: delete from pay_element_entries_f

249: for ceevrec in ceev loop
250: delete from pay_element_entry_values_f pev
251: where element_entry_id = ceevrec.element_entry_id;
252: --
253: delete from pay_element_entries_f
254: where creator_id = p_assact_id
255: and creator_type = 'P'
256: and element_entry_id = ceevrec.element_entry_id;
257: end loop;

Line 272: from pay_element_entries_f pee,

268: procedure remove_adv_ee(p_assact_id in number) is
269: c_indent varchar2(40);
270: cursor aeev is
271: select pee.element_entry_id
272: from pay_element_entries_f pee,
273: pay_assignment_actions paa
274: where paa.assignment_action_id = p_assact_id
275: and pee.assignment_id = paa.assignment_id
276: and pee.creator_id = paa.assignment_action_id

Line 289: delete from pay_element_entries_f

285: for aeevrec in aeev loop
286: delete from pay_element_entry_values_f pev
287: where element_entry_id = aeevrec.element_entry_id;
288: --
289: delete from pay_element_entries_f
290: where creator_id = p_assact_id
291: and creator_type = 'D'
292: and element_entry_id = aeevrec.element_entry_id;
293: end loop;

Line 306: from pay_element_entries_f pee,

302: procedure remove_advpayele_ee(p_assact_id in number) is
303: c_indent varchar2(40);
304: cursor aeev is
305: select pee.element_entry_id
306: from pay_element_entries_f pee,
307: pay_assignment_actions paa
308: where paa.assignment_action_id = p_assact_id
309: and pee.assignment_id = paa.assignment_id
310: and pee.creator_id = paa.assignment_action_id

Line 323: delete from pay_element_entries_f

319: for aeevrec in aeev loop
320: delete from pay_element_entry_values_f pev
321: where element_entry_id = aeevrec.element_entry_id;
322: --
323: delete from pay_element_entries_f
324: where creator_id = p_assact_id
325: and creator_type in ('AD', 'AE','D')
326: and element_entry_id = aeevrec.element_entry_id;
327: end loop;

Line 339: from pay_element_entries_f pee,

335: procedure remove_retroact_ee(p_assact_id in number) is
336: c_indent varchar2(40);
337: cursor raeev is
338: select pee.element_entry_id
339: from pay_element_entries_f pee,
340: pay_assignment_actions paa
341: where paa.assignment_action_id = p_assact_id
342: and pee.assignment_id = paa.assignment_id
343: and pee.creator_id = paa.assignment_action_id

Line 356: delete from pay_element_entries_f

352: for raeevrec in raeev loop
353: delete from pay_element_entry_values_f pev
354: where element_entry_id = raeevrec.element_entry_id;
355: --
356: delete from pay_element_entries_f
357: where creator_id = p_assact_id
358: and creator_type = 'R'
359: and element_entry_id = raeevrec.element_entry_id;
360: end loop;

Line 373: from pay_element_entries_f pee,

369: p_rollback_mode in varchar2) is
370: c_indent varchar2(40);
371: cursor remove_eev is
372: select pee.element_entry_id
373: from pay_element_entries_f pee,
374: pay_assignment_actions paa
375: where paa.assignment_action_id = p_assact_id
376: and pee.creator_id = paa.assignment_action_id
377: and pee.creator_type in ('RR', 'EE', 'NR', 'PR') ;

Line 402: delete from pay_element_entries_f

398: --
399: delete from pay_entry_process_details
400: where element_entry_id = eev_rec.element_entry_id;
401: --
402: delete from pay_element_entries_f
403: where creator_id = p_assact_id
404: and creator_type in ('RR', 'EE', 'NR', 'PR')
405: and element_entry_id = eev_rec.element_entry_id;
406: end loop;

Line 1001: from pay_element_entries_f pee,

997: -- Batch balance adjustment can have many adjustments
998: -- for an assignment action.
999: cursor c1 is
1000: select pee.element_entry_id
1001: from pay_element_entries_f pee,
1002: pay_assignment_actions paa
1003: where paa.assignment_action_id = p_assact_id
1004: and pee.assignment_id = paa.assignment_id
1005: and pee.creator_id = paa.assignment_action_id

Line 1025: delete from pay_element_entries_f pee

1021: -- Note, if this procedure is called from the balance
1022: -- adjustment form, the form may be attempting to delete
1023: -- this row. However, this could be called from the
1024: -- actions form, in which case we do need to do the delete.
1025: delete from pay_element_entries_f pee
1026: where pee.element_entry_id = c1rec.element_entry_id
1027: and p_action_date between
1028: pee.effective_start_date and pee.effective_end_date;
1029: end loop;

Line 1320: from pay_element_entries_f pee

1316: pee.original_entry_id,
1317: pee.assignment_id,
1318: pee.element_link_id
1319: into effstart, effend, orig_ee_id, asg_id, el_id
1320: from pay_element_entries_f pee
1321: where pee.element_entry_id = p_ee_id
1322: and p_date between
1323: pee.effective_start_date and pee.effective_end_date;
1324: --

Line 1338: from pay_element_entries_f ee

1334: hr_utility.set_location(c_indent, 20);
1335: end if;
1336: select min(ee.effective_end_date)
1337: into next_end
1338: from pay_element_entries_f ee
1339: where ee.element_entry_id = p_ee_id
1340: and ee.effective_start_date > effend;
1341: exception
1342: when no_data_found then null;

Line 1383: update pay_element_entries_f ee

1379: if g_debug then
1380: hr_utility.set_location(c_indent, 25);
1381: end if;
1382: if(p_mode = 'DELETE_NEXT_CHANGE') then
1383: update pay_element_entries_f ee
1384: set updating_action_id=NULL
1385: ,updating_action_type =NULL
1386: where ee.element_entry_id = p_ee_id
1387: and ee.effective_start_date = val_start;

Line 1389: update pay_element_entries_f ee

1385: ,updating_action_type =NULL
1386: where ee.element_entry_id = p_ee_id
1387: and ee.effective_start_date = val_start;
1388: elsif(p_mode = 'FUTURE_CHANGE') then
1389: update pay_element_entries_f ee
1390: set updating_action_id=NULL
1391: ,updating_action_type =NULL
1392: where ee.element_entry_id = p_ee_id
1393: and ee.effective_start_date = effstart;

Line 1405: delete from pay_element_entries_f ee

1401: --
1402: -- Process the delete of element entries.
1403: if(p_mode = 'DELETE_NEXT_CHANGE') then
1404: hr_utility.set_location(c_indent, 40);
1405: delete from pay_element_entries_f ee
1406: where ee.element_entry_id = p_ee_id
1407: and ee.effective_start_date = val_start;
1408: --
1409: hr_utility.set_location(c_indent, 45);

Line 1415: update pay_element_entries_f ee

1411: where eev.element_entry_id = p_ee_id
1412: and eev.effective_start_date = val_start;
1413: --
1414: hr_utility.set_location(c_indent, 50);
1415: update pay_element_entries_f ee
1416: set ee.effective_end_date = next_end
1417: where ee.element_entry_id = p_ee_id
1418: and ee.effective_start_date = effstart;
1419: --

Line 1429: delete from pay_element_entries_f ee

1425: --
1426: elsif(p_mode = 'FUTURE_CHANGE') then
1427: --
1428: hr_utility.set_location(c_indent, 60);
1429: delete from pay_element_entries_f ee
1430: where ee.element_entry_id = p_ee_id
1431: and ee.effective_start_date > effstart;
1432: --
1433: hr_utility.set_location(c_indent, 65);

Line 1439: update pay_element_entries_f ee

1435: where eev.element_entry_id = p_ee_id
1436: and eev.effective_start_date > effstart;
1437: --
1438: hr_utility.set_location(c_indent, 70);
1439: update pay_element_entries_f ee
1440: set ee.effective_end_date = max_end,
1441: ee.updating_action_id=NULL,
1442: ee.updating_action_type=NULL
1443: where ee.element_entry_id = p_ee_id

Line 1449: from pay_element_entries_f ee

1445: /*BUG#6200530*/
1446: /*check for the additional assignment id (in case of an STOP RECURRING after an UPDATE RECURRING)*/
1447: select ee.prev_upd_action_id
1448: into prev_asgact_id
1449: from pay_element_entries_f ee
1450: where ee.element_entry_id = p_ee_id
1451: and ee.effective_start_date = effstart;
1452: /*If it is the case then update the updating_action_id with the asg_action_id of the previous UPDATE RECURRING operation*/
1453: if(prev_asgact_id is not null) then

Line 1454: update pay_element_entries_f ee

1450: where ee.element_entry_id = p_ee_id
1451: and ee.effective_start_date = effstart;
1452: /*If it is the case then update the updating_action_id with the asg_action_id of the previous UPDATE RECURRING operation*/
1453: if(prev_asgact_id is not null) then
1454: update pay_element_entries_f ee
1455: set ee.updating_action_id=prev_asgact_id,
1456: ee.prev_upd_action_id=NULL,
1457: ee.updating_action_type='U'
1458: where ee.element_entry_id = p_ee_id

Line 1488: pay_element_entries_f pee

1484: select pet.multiple_entries_allowed_flag,
1485: pee.element_entry_id,pee.updating_action_type
1486: from pay_element_types_f pet,
1487: pay_element_links_f pel,
1488: pay_element_entries_f pee
1489: where pee.assignment_id = p_info.assignment_id
1490: and pee.entry_type = 'E'
1491: and pel.element_link_id = pee.element_link_id
1492: and p_info.action_date between

Line 1515: pay_element_entries_f pee

1511: select pet.multiple_entries_allowed_flag,
1512: pee.element_entry_id
1513: from pay_element_types_f pet,
1514: pay_element_links_f pel,
1515: pay_element_entries_f pee
1516: where pee.assignment_id = p_info.assignment_id
1517: and pee.entry_type = 'E'
1518: and ((pee.effective_start_date = p_info.action_date
1519: and pee.updating_action_type is NULL)

Line 1549: from pay_element_entries_f pee

1545: hr_utility.set_location(c_indent,90);
1546: end if;
1547: select max(pee.effective_end_date)
1548: into v_max_date
1549: from pay_element_entries_f pee
1550: where pee.element_entry_id = stprec.element_entry_id;
1551: else
1552: v_max_date := p_info.date_earned;
1553: end if;