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 231: from pay_element_entries_f pee,

227: procedure remove_retro_ee(p_assact_id in number) is
228: c_indent varchar2(40);
229: cursor ceev is
230: select pee.element_entry_id
231: from pay_element_entries_f pee,
232: pay_assignment_actions paa
233: where paa.assignment_action_id = p_assact_id
234: and pee.assignment_id = paa.assignment_id
235: and pee.creator_id = paa.assignment_action_id

Line 248: delete from pay_element_entries_f

244: for ceevrec in ceev loop
245: delete from pay_element_entry_values_f pev
246: where element_entry_id = ceevrec.element_entry_id;
247: --
248: delete from pay_element_entries_f
249: where creator_id = p_assact_id
250: and creator_type = 'P'
251: and element_entry_id = ceevrec.element_entry_id;
252: end loop;

Line 267: from pay_element_entries_f pee,

263: procedure remove_adv_ee(p_assact_id in number) is
264: c_indent varchar2(40);
265: cursor aeev is
266: select pee.element_entry_id
267: from pay_element_entries_f pee,
268: pay_assignment_actions paa
269: where paa.assignment_action_id = p_assact_id
270: and pee.assignment_id = paa.assignment_id
271: and pee.creator_id = paa.assignment_action_id

Line 284: delete from pay_element_entries_f

280: for aeevrec in aeev loop
281: delete from pay_element_entry_values_f pev
282: where element_entry_id = aeevrec.element_entry_id;
283: --
284: delete from pay_element_entries_f
285: where creator_id = p_assact_id
286: and creator_type = 'D'
287: and element_entry_id = aeevrec.element_entry_id;
288: end loop;

Line 301: from pay_element_entries_f pee,

297: procedure remove_advpayele_ee(p_assact_id in number) is
298: c_indent varchar2(40);
299: cursor aeev is
300: select pee.element_entry_id
301: from pay_element_entries_f pee,
302: pay_assignment_actions paa
303: where paa.assignment_action_id = p_assact_id
304: and pee.assignment_id = paa.assignment_id
305: and pee.creator_id = paa.assignment_action_id

Line 318: delete from pay_element_entries_f

314: for aeevrec in aeev loop
315: delete from pay_element_entry_values_f pev
316: where element_entry_id = aeevrec.element_entry_id;
317: --
318: delete from pay_element_entries_f
319: where creator_id = p_assact_id
320: and creator_type in ('AD', 'AE','D')
321: and element_entry_id = aeevrec.element_entry_id;
322: end loop;

Line 334: from pay_element_entries_f pee,

330: procedure remove_retroact_ee(p_assact_id in number) is
331: c_indent varchar2(40);
332: cursor raeev is
333: select pee.element_entry_id
334: from pay_element_entries_f pee,
335: pay_assignment_actions paa
336: where paa.assignment_action_id = p_assact_id
337: and pee.assignment_id = paa.assignment_id
338: and pee.creator_id = paa.assignment_action_id

Line 351: delete from pay_element_entries_f

347: for raeevrec in raeev loop
348: delete from pay_element_entry_values_f pev
349: where element_entry_id = raeevrec.element_entry_id;
350: --
351: delete from pay_element_entries_f
352: where creator_id = p_assact_id
353: and creator_type = 'R'
354: and element_entry_id = raeevrec.element_entry_id;
355: end loop;

Line 368: from pay_element_entries_f pee,

364: p_rollback_mode in varchar2) is
365: c_indent varchar2(40);
366: cursor remove_eev is
367: select pee.element_entry_id
368: from pay_element_entries_f pee,
369: pay_assignment_actions paa
370: where paa.assignment_action_id = p_assact_id
371: and pee.creator_id = paa.assignment_action_id
372: and pee.creator_type in ('RR', 'EE', 'NR', 'PR') ;

Line 397: delete from pay_element_entries_f

393: --
394: delete from pay_entry_process_details
395: where element_entry_id = eev_rec.element_entry_id;
396: --
397: delete from pay_element_entries_f
398: where creator_id = p_assact_id
399: and creator_type in ('RR', 'EE', 'NR', 'PR')
400: and element_entry_id = eev_rec.element_entry_id;
401: end loop;

Line 996: from pay_element_entries_f pee,

992: -- Batch balance adjustment can have many adjustments
993: -- for an assignment action.
994: cursor c1 is
995: select pee.element_entry_id
996: from pay_element_entries_f pee,
997: pay_assignment_actions paa
998: where paa.assignment_action_id = p_assact_id
999: and pee.assignment_id = paa.assignment_id
1000: and pee.creator_id = paa.assignment_action_id

Line 1020: delete from pay_element_entries_f pee

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

Line 1315: from pay_element_entries_f pee

1311: pee.original_entry_id,
1312: pee.assignment_id,
1313: pee.element_link_id
1314: into effstart, effend, orig_ee_id, asg_id, el_id
1315: from pay_element_entries_f pee
1316: where pee.element_entry_id = p_ee_id
1317: and p_date between
1318: pee.effective_start_date and pee.effective_end_date;
1319: --

Line 1333: from pay_element_entries_f ee

1329: hr_utility.set_location(c_indent, 20);
1330: end if;
1331: select min(ee.effective_end_date)
1332: into next_end
1333: from pay_element_entries_f ee
1334: where ee.element_entry_id = p_ee_id
1335: and ee.effective_start_date > effend;
1336: exception
1337: when no_data_found then null;

Line 1378: update pay_element_entries_f ee

1374: if g_debug then
1375: hr_utility.set_location(c_indent, 25);
1376: end if;
1377: if(p_mode = 'DELETE_NEXT_CHANGE') then
1378: update pay_element_entries_f ee
1379: set updating_action_id=NULL
1380: ,updating_action_type =NULL
1381: where ee.element_entry_id = p_ee_id
1382: and ee.effective_start_date = val_start;

Line 1384: update pay_element_entries_f ee

1380: ,updating_action_type =NULL
1381: where ee.element_entry_id = p_ee_id
1382: and ee.effective_start_date = val_start;
1383: elsif(p_mode = 'FUTURE_CHANGE') then
1384: update pay_element_entries_f ee
1385: set updating_action_id=NULL
1386: ,updating_action_type =NULL
1387: where ee.element_entry_id = p_ee_id
1388: and ee.effective_start_date = effstart;

Line 1400: delete from pay_element_entries_f ee

1396: --
1397: -- Process the delete of element entries.
1398: if(p_mode = 'DELETE_NEXT_CHANGE') then
1399: hr_utility.set_location(c_indent, 40);
1400: delete from pay_element_entries_f ee
1401: where ee.element_entry_id = p_ee_id
1402: and ee.effective_start_date = val_start;
1403: --
1404: hr_utility.set_location(c_indent, 45);

Line 1410: update pay_element_entries_f ee

1406: where eev.element_entry_id = p_ee_id
1407: and eev.effective_start_date = val_start;
1408: --
1409: hr_utility.set_location(c_indent, 50);
1410: update pay_element_entries_f ee
1411: set ee.effective_end_date = next_end
1412: where ee.element_entry_id = p_ee_id
1413: and ee.effective_start_date = effstart;
1414: --

Line 1424: delete from pay_element_entries_f ee

1420: --
1421: elsif(p_mode = 'FUTURE_CHANGE') then
1422: --
1423: hr_utility.set_location(c_indent, 60);
1424: delete from pay_element_entries_f ee
1425: where ee.element_entry_id = p_ee_id
1426: and ee.effective_start_date > effstart;
1427: --
1428: hr_utility.set_location(c_indent, 65);

Line 1434: update pay_element_entries_f ee

1430: where eev.element_entry_id = p_ee_id
1431: and eev.effective_start_date > effstart;
1432: --
1433: hr_utility.set_location(c_indent, 70);
1434: update pay_element_entries_f ee
1435: set ee.effective_end_date = max_end,
1436: ee.updating_action_id=NULL,
1437: ee.updating_action_type=NULL
1438: where ee.element_entry_id = p_ee_id

Line 1444: from pay_element_entries_f ee

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

Line 1449: update pay_element_entries_f ee

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

Line 1483: pay_element_entries_f pee

1479: select pet.multiple_entries_allowed_flag,
1480: pee.element_entry_id,pee.updating_action_type
1481: from pay_element_types_f pet,
1482: pay_element_links_f pel,
1483: pay_element_entries_f pee
1484: where pee.assignment_id = p_info.assignment_id
1485: and pee.entry_type = 'E'
1486: and pel.element_link_id = pee.element_link_id
1487: and p_info.action_date between

Line 1510: pay_element_entries_f pee

1506: select pet.multiple_entries_allowed_flag,
1507: pee.element_entry_id
1508: from pay_element_types_f pet,
1509: pay_element_links_f pel,
1510: pay_element_entries_f pee
1511: where pee.assignment_id = p_info.assignment_id
1512: and pee.entry_type = 'E'
1513: and ((pee.effective_start_date = p_info.action_date
1514: and pee.updating_action_type is NULL)

Line 1544: from pay_element_entries_f pee

1540: hr_utility.set_location(c_indent,90);
1541: end if;
1542: select max(pee.effective_end_date)
1543: into v_max_date
1544: from pay_element_entries_f pee
1545: where pee.element_entry_id = stprec.element_entry_id;
1546: else
1547: v_max_date := p_info.date_earned;
1548: end if;