[Home] [Help]
3: --
4: g_debug boolean := hr_utility.debug_enabled;
5: indent varchar2 (32767) := null;
6: g_package constant varchar2 (32) := 'hrentmnt.';
7: g_original_entry_id pay_element_entries_f.original_entry_id%type := null;
8: --
9: -- Record type to cache an element entry for use when splitting into two.
10: --
11: type t_ele_entry_rec is record
581: where pp.assignment_id = p_assignment_id
582: and pp.pay_proposal_id = p_pay_proposal_id
583: and not exists
584: (select null
585: from pay_element_entries_f ee
586: where ee.assignment_id = pp.assignment_id
587: and ee.creator_type = 'SP'
588: and ee.creator_id = pp.pay_proposal_id));
589: --
591: where pp.assignment_id = p_assignment_id
592: and pp.pay_proposal_id = p_pay_proposal_id
593: and not exists
594: (select null
595: from pay_element_entries_f ee
596: where ee.assignment_id = pp.assignment_id
597: and ee.creator_type = 'SP'
598: and ee.creator_id = pp.pay_proposal_id);
599: end remove_pay_proposals;
1101: ee.entry_information28,
1102: ee.entry_information29,
1103: ee.entry_information30
1104: into v_ele_entry_rec
1105: from pay_element_entries_f ee
1106: where ee.element_entry_id = p_element_entry_id
1107: and p_date between ee.effective_start_date
1108: and ee.effective_end_date;
1109: exception
1256: into v_entry_overridden
1257: from sys.dual
1258: where exists
1259: (select null
1260: from pay_element_entries_f ee
1261: where ee.assignment_id = p_assignment_id
1262: and ee.entry_type in ('A','R')
1263: and ee.target_entry_id = p_element_entry_id
1264: and ee.effective_start_date <= p_validation_end_date
1287: -- 2) Extendinging the end date of an entry. --
1288: -- For test case Ref Bug#9197105
1289: ------------------------------------------------------------------------------
1290: --
1291: procedure log_entry_event (p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE
1292: ,p_old_date in date
1293: ,p_new_date in date
1294: ,p_start_or_end_date in varchar2
1295: ,p_old_start_date in date
1293: ,p_new_date in date
1294: ,p_start_or_end_date in varchar2
1295: ,p_old_start_date in date
1296: ,p_old_end_date in date
1297: ,p_old_upd_action_id in pay_element_entries_f.updating_action_id%TYPE
1298: ,p_old_upd_action_type in pay_element_entries_f.updating_action_type%TYPE) is
1299:
1300: cursor csr_entry is
1301: select ee.original_entry_id,
1294: ,p_start_or_end_date in varchar2
1295: ,p_old_start_date in date
1296: ,p_old_end_date in date
1297: ,p_old_upd_action_id in pay_element_entries_f.updating_action_id%TYPE
1298: ,p_old_upd_action_type in pay_element_entries_f.updating_action_type%TYPE) is
1299:
1300: cursor csr_entry is
1301: select ee.original_entry_id,
1302: ee.cost_allocation_keyflex_id,
1375: ee.entry_information27,
1376: ee.entry_information28,
1377: ee.entry_information29,
1378: ee.entry_information30
1379: from pay_element_entries_f ee
1380: where ee.element_entry_id = p_element_entry_id
1381: and ee.effective_start_date = decode(p_start_or_end_date,
1382: 'START',p_new_date,
1383: ee.effective_start_date)
1386: ee.effective_end_date);
1387: v_entry_rec csr_entry%rowtype;
1388: l_proc varchar2(100) := g_package||' log_entry_event';
1389:
1390: l_updating_action_id pay_element_entries_f.updating_action_id%TYPE;
1391: l_updating_action_type pay_element_entries_f.updating_action_type%TYPE;
1392: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
1393: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
1394:
1387: v_entry_rec csr_entry%rowtype;
1388: l_proc varchar2(100) := g_package||' log_entry_event';
1389:
1390: l_updating_action_id pay_element_entries_f.updating_action_id%TYPE;
1391: l_updating_action_type pay_element_entries_f.updating_action_type%TYPE;
1392: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
1393: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
1394:
1395: l_datetrack_mode varchar2(10);
1388: l_proc varchar2(100) := g_package||' log_entry_event';
1389:
1390: l_updating_action_id pay_element_entries_f.updating_action_id%TYPE;
1391: l_updating_action_type pay_element_entries_f.updating_action_type%TYPE;
1392: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
1393: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
1394:
1395: l_datetrack_mode varchar2(10);
1396: l_effective_date date;
1389:
1390: l_updating_action_id pay_element_entries_f.updating_action_id%TYPE;
1391: l_updating_action_type pay_element_entries_f.updating_action_type%TYPE;
1392: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
1393: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
1394:
1395: l_datetrack_mode varchar2(10);
1396: l_effective_date date;
1397:
1618: );
1619: exception
1620: when hr_api.cannot_find_prog_unit then
1621: hr_api.cannot_find_prog_unit_error
1622: (p_module_name => 'PAY_ELEMENT_ENTRIES_F'
1623: ,p_hook_type => 'AU'
1624: );
1625: end;
1626: end if;
1659: --
1660: cursor csr_ele_info is
1661: select EL.element_type_id element_type_id,
1662: 'Y' salary_element
1663: from pay_element_entries_f EE,
1664: pay_element_links_f EL
1665: where EE.element_entry_id = p_element_entry_id
1666: and EL.element_link_id = EE.element_link_id
1667: and nvl(p_old_date,p_effective_start_date) between
1675: and PB.input_value_id = IV.input_value_id)
1676: UNION ALL
1677: select EL.element_type_id element_type_id,
1678: 'N' salary_element
1679: from pay_element_entries_f EE,
1680: pay_element_links_f EL
1681: where EE.element_entry_id = p_element_entry_id
1682: and EL.element_link_id = EE.element_link_id
1683: and nvl(p_old_date,p_effective_start_date) between
1696: v_change_start_date date;
1697: v_change_end_date date;
1698: v_ele_info_rec csr_ele_info%rowtype;
1699:
1700: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
1701: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
1702: l_updating_action_type pay_element_entries_f.updating_action_type%TYPE;
1703: l_updating_action_id pay_element_entries_f.updating_action_id%TYPE;
1704: --
1697: v_change_end_date date;
1698: v_ele_info_rec csr_ele_info%rowtype;
1699:
1700: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
1701: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
1702: l_updating_action_type pay_element_entries_f.updating_action_type%TYPE;
1703: l_updating_action_id pay_element_entries_f.updating_action_id%TYPE;
1704: --
1705: procedure check_parameters is
1698: v_ele_info_rec csr_ele_info%rowtype;
1699:
1700: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
1701: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
1702: l_updating_action_type pay_element_entries_f.updating_action_type%TYPE;
1703: l_updating_action_id pay_element_entries_f.updating_action_id%TYPE;
1704: --
1705: procedure check_parameters is
1706: --
1699:
1700: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
1701: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
1702: l_updating_action_type pay_element_entries_f.updating_action_type%TYPE;
1703: l_updating_action_id pay_element_entries_f.updating_action_id%TYPE;
1704: --
1705: procedure check_parameters is
1706: --
1707: begin
1890: into l_effective_start_date,
1891: l_effective_end_date,
1892: l_updating_action_id,
1893: l_updating_action_type
1894: from pay_element_entries_f ee
1895: where ee.element_entry_id = p_element_entry_id
1896: and ee.effective_start_date = p_old_date;
1897:
1898: /*Back-dating the start date of the entry.*/
1896: and ee.effective_start_date = p_old_date;
1897:
1898: /*Back-dating the start date of the entry.*/
1899: hr_utility.trace('Calling actual DML to back-date the effective start date');
1900: update pay_element_entries_f ee
1901: set ee.effective_start_date = p_new_date,
1902: ee.updating_action_id = decode(ee.updating_action_type, 'S', ee.updating_action_id,
1903: null),
1904: ee.updating_action_type = decode(ee.updating_action_type, 'S', 'S', null)
1922: into l_effective_start_date,
1923: l_effective_end_date,
1924: l_updating_action_id,
1925: l_updating_action_type
1926: from pay_element_entries_f ee
1927: where ee.element_entry_id = p_element_entry_id
1928: and ee.effective_end_date = p_old_date;
1929:
1930: /*Extending the effective_end_date of the entry.*/
1928: and ee.effective_end_date = p_old_date;
1929:
1930: /*Extending the effective_end_date of the entry.*/
1931: hr_utility.trace('Calling actual DML to extend the effective end date');
1932: update pay_element_entries_f ee
1933: set ee.effective_end_date = p_new_date,
1934: ee.updating_action_id = decode(ee.updating_action_type, 'U', ee.updating_action_id,
1935: null),
1936: ee.updating_action_type = decode(ee.updating_action_type, 'U', 'U', null)
2005: and pet.element_type_id = pel.element_type_id
2006: and pec.classification_id = pet.classification_id
2007: and not exists (
2008: select null
2009: from pay_element_entries_f pee
2010: where pee.element_entry_id = p_element_entry_id)
2011: and rownum = 1;
2012: exception
2013: -- If we didn't get a row, this means that we haven't
2283: l_eeid_out number;
2284: l_calc_ee_esd date;
2285: l_calc_ee_eed date;
2286: l_ee_eed_out date;
2287: l_original_entry_id pay_element_entries_f.original_entry_id%type;
2288: v_original_entry_exists number; -- Bug 14184639
2289: sp_exists number; --Bug 9295968
2290: --
2291: begin
2393: into v_original_entry_exists
2394: from sys.dual
2395: where exists
2396: (select null
2397: from pay_element_entries_f ee
2398: ,pay_element_links_f el
2399: ,pay_element_types_f et
2400: where ee.assignment_id = p_assignment_id
2401: and ee.element_entry_id = p_element_entry_id
2523: hr_utility.trace('***** bring EED of new EE back');
2524: end if;
2525: --
2526: -- Change l_ee_eed_out here, for separate update to
2527: -- pay_element_entries_f, below, which *always* occurs.
2528: --
2529: l_ee_eed_out := l_calc_ee_eed;
2530: --
2531: update pay_element_entry_values_f eev
2533: where eev.element_entry_id = l_eeid_out;
2534: --
2535: end if;
2536: --
2537: -- Set attributes on pay_element_entries_f that are not supported by API.
2538: -- Also, effective_end_date of new entry is brought back here, if
2539: -- necessary.
2540: --
2541: update pay_element_entries_f pee
2537: -- Set attributes on pay_element_entries_f that are not supported by API.
2538: -- Also, effective_end_date of new entry is brought back here, if
2539: -- necessary.
2540: --
2541: update pay_element_entries_f pee
2542: set pee.effective_end_date = l_ee_eed_out,
2543: pee.balance_adj_cost_flag = p_rec_ee.balance_adj_cost_flag,
2544: pee.source_asg_action_id = p_rec_ee.source_asg_action_id,
2545: pee.source_link_id = p_rec_ee.source_link_id,
2609: (
2610: p_assignment_id number
2611: ) is
2612: select distinct ee.element_entry_id
2613: from pay_element_entries_f ee
2614: where ee.assignment_id = p_assignment_id;
2615: --
2616: cursor csr_entry
2617: (
2629: el.element_link_id,
2630: el.standard_link_flag,
2631: el.element_type_id
2632: from
2633: pay_element_entries_f ee,
2634: pay_element_links_f el,
2635: pay_element_types_f et
2636: where ee.assignment_id = p_assignment_id
2637: and ee.effective_start_date <= p_validation_end_date
2836: --
2837: /* Bug 14184639 Changes start */
2838: select ee.original_entry_id
2839: into g_original_entry_id
2840: from pay_element_entries_f ee
2841: where ee.element_entry_id = p_element_entry_id
2842: and ee.effective_start_date >= p_ee_effective_start_date
2843: and ee.effective_end_date <= p_ee_effective_end_date;
2844: /* Bug 14184639 Changes end */
2846: where eev.element_entry_id = p_element_entry_id
2847: and eev.effective_start_date >= p_ee_effective_start_date
2848: and eev.effective_end_date <= p_ee_effective_end_date;
2849: --
2850: delete from pay_element_entries_f ee
2851: where ee.element_entry_id = p_element_entry_id
2852: and ee.effective_start_date >= p_ee_effective_start_date
2853: and ee.effective_end_date <= p_ee_effective_end_date;
2854: --
2885: where exc.source_id = p_element_entry_id
2886: and exc.source_type = 'EE'
2887: and not exists
2888: ( select null
2889: from pay_element_entries_f pee
2890: where pee.element_entry_id = p_element_entry_id);
2891: --
2892: -- Call the routine that checks whether an illegal purge
2893: -- has occurred (i.e. disallowed by profile).
3011: and eev.effective_end_date >= p_validation_start_date
3012: -- End of change 115.60
3013: ;
3014: --
3015: UPDATE PAY_ELEMENT_ENTRIES_F ee
3016: SET ee.effective_end_date = p_validation_start_date - 1,
3017: ee.updating_action_id = decode(ee.updating_action_type, 'U', ee.updating_action_id,
3018: null),
3019: ee.updating_action_type = decode(ee.updating_action_type, 'U', 'U', null)
3121: where business_group_id=p_business_group_id;
3122:
3123: CURSOR csr_ele_entry_details(p_element_entry_id number, p_date in date) IS
3124: SELECT *
3125: from pay_element_entries_f
3126: where element_entry_id = p_element_entry_id
3127: and p_date between effective_start_date and effective_end_date;
3128:
3129: l_business_group_id number;
3164: -- End of change 115.60
3165: and eev.effective_end_date > p_validation_end_date
3166: ;
3167:
3168: UPDATE PAY_ELEMENT_ENTRIES_F ee
3169: SET ee.effective_start_date = p_validation_end_date + 1,
3170: ee.updating_action_id = decode(ee.updating_action_type, 'S', ee.updating_action_id, null),
3171: ee.updating_action_type = decode(ee.updating_action_type, 'S', 'S', null)
3172: WHERE ee.element_entry_id = p_element_entry_id
3222:
3223: l_dyt_mode := pay_dyn_triggers.g_dyt_mode;
3224: pay_dyn_triggers.g_dyt_mode := 'UPDATE';
3225:
3226: pay_continuous_calc.PAY_ELEMENT_ENTRIES_F_aru(
3227: p_business_group_id => l_business_group_id,
3228: p_legislation_code => l_legislation_code,
3229: --p_effective_date => p_validation_end_date+1,
3230: p_effective_date => p_ee_effective_start_date,
3385: --
3386: delete from pay_element_entry_values_f eev
3387: where eev.element_entry_id = v_entry.element_entry_id;
3388: --
3389: delete from pay_element_entries_f ee
3390: where ee.element_entry_id = v_entry.element_entry_id;
3391: --
3392: end loop;
3393: --
3540: select ee.element_entry_id,
3541: ee.effective_start_date,
3542: ee.effective_end_date,
3543: ee.element_link_id
3544: from pay_element_entries_f ee
3545: where ee.assignment_id = p_assignment_id
3546: and ee.effective_start_date <= p_validation_end_date
3547: and ee.effective_end_date >= p_validation_start_date
3548: and ee.creator_type in ('F','H')
3668:
3669: -- Added for Bug 7578009
3670:
3671: -- Bug 8230599. Using only element_entry_id in the where clause to get ovn, as
3672: -- every non-recurring element entry has only one record in pay_element_Entries_f.
3673: -- Call the entry api for 'ZAP' mode also to enable logging of events.
3674:
3675: select OBJECT_VERSION_NUMBER into l_obj_ver_num
3676: from pay_element_entries_f
3672: -- every non-recurring element entry has only one record in pay_element_Entries_f.
3673: -- Call the entry api for 'ZAP' mode also to enable logging of events.
3674:
3675: select OBJECT_VERSION_NUMBER into l_obj_ver_num
3676: from pay_element_entries_f
3677: where element_entry_id=v_entry.element_entry_id;
3678:
3679: if g_debug then
3680: hr_utility.trace(' obj vber no : '||l_obj_ver_num);
3710:
3711: delete from pay_element_entry_values_f eev
3712: where eev.element_entry_id = v_entry.element_entry_id;
3713: --
3714: delete from pay_element_entries_f ee
3715: where ee.element_entry_id = v_entry.element_entry_id;
3716:
3717: else
3718:
3745: --Commented the below code as part of 6809717
3746: /* delete from pay_element_entry_values_f eev
3747: where eev.element_entry_id = v_entry.element_entry_id;
3748: --
3749: delete from pay_element_entries_f ee
3750: where ee.element_entry_id = v_entry.element_entry_id;*/
3751: --
3752: -- Call the routine that checks whether an illegal purge
3753: -- has occurred (i.e. disallowed by profile).
3988: p_validation_end_date date,
3989: p_adjust_ee_source varchar2
3990: ) is
3991: select ee.*
3992: from pay_element_entries_f ee
3993: ,pay_element_types_f et
3994: where ee.assignment_id = p_assignment_id
3995: and ee.effective_start_date <= p_validation_end_date
3996: and ee.effective_end_date >= p_validation_start_date
4285: -- Do bulk update of element entries, to point to their respective new
4286: -- alternative links
4287: --
4288: forall i in 1 .. l_entry_table.element_entry_id.count
4289: update pay_element_entries_f
4290: set element_link_id = l_entry_table.element_link_id(i)
4291: where element_entry_id = l_entry_table.element_entry_id(i)
4292: and effective_start_date = l_entry_table.effective_start_date(i)
4293: and effective_end_date = l_entry_table.effective_end_date(i);
4320: select null
4321: from dual
4322: where exists
4323: (select null
4324: from pay_element_entries_f pee,
4325: per_time_periods ptp
4326: where pee.assignment_id = p_assignment_id
4327: and pee.entry_type in ('A','R','S')
4328: and pee.effective_start_date > p_val_start_date
4373: select ee.element_entry_id,
4374: ee.effective_start_date,
4375: ee.effective_end_date,
4376: ee.element_link_id
4377: from pay_element_entries_f ee
4378: where ee.assignment_id = p_assignment_id
4379: and ee.effective_start_date <= p_val_end_date_plus_one
4380: and ee.effective_end_date >= p_val_start_date_minus_one
4381: and ((ee.entry_type <> 'E') or
4724: p_entry_start_date date,
4725: p_entry_end_date date
4726: ) is
4727: select distinct nvl(ee.original_entry_id,ee.element_entry_id)
4728: from pay_element_entries_f ee
4729: where p_mult_ent_allowed_flag = 'Y'
4730: and ee.entry_type = 'E'
4731: and ee.assignment_id = p_assignment_id
4732: and ee.element_link_id = p_element_link_id
4737: from sys.dual
4738: where p_mult_ent_allowed_flag = 'N'
4739: and exists
4740: (select null
4741: from pay_element_entries_f ee
4742: where ee.entry_type = 'E'
4743: and ee.assignment_id = p_assignment_id
4744: and ee.element_link_id = p_element_link_id
4745: and ee.effective_start_date <= p_entry_end_date
4765: ee.effective_start_date,
4766: ee.effective_end_date,
4767: ee.element_link_id,
4768: ee.creator_type
4769: from pay_element_entries_f ee
4770: where ee.entry_type = 'E'
4771: and ee.effective_start_date <= p_entry_end_date
4772: and ee.effective_end_date >= p_entry_start_date
4773: and p_mult_ent_allowed_flag = 'Y'
4779: ee.effective_start_date,
4780: ee.effective_end_date,
4781: ee.element_link_id,
4782: ee.creator_type
4783: from pay_element_entries_f ee
4784: where ee.entry_type = 'E'
4785: and ee.effective_start_date <= p_entry_end_date
4786: and ee.effective_end_date >= p_entry_start_date
4787: and p_mult_ent_allowed_flag = 'Y'
4786: and ee.effective_end_date >= p_entry_start_date
4787: and p_mult_ent_allowed_flag = 'Y'
4788: and ee.original_entry_id = p_element_entry_id
4789: UNION ALL
4790: select /*+ index(ee PAY_ELEMENT_ENTRIES_F_N51) */ ee.element_entry_id,
4791: ee.original_entry_id,
4792: ee.effective_start_date,
4793: ee.effective_end_date,
4794: ee.element_link_id,
4792: ee.effective_start_date,
4793: ee.effective_end_date,
4794: ee.element_link_id,
4795: ee.creator_type
4796: from pay_element_entries_f ee
4797: where ee.entry_type = 'E'
4798: and ee.effective_start_date <= p_entry_end_date
4799: and ee.effective_end_date >= p_entry_start_date
4800: and p_mult_ent_allowed_flag = 'N'
5479: p_entry_value_tbl => v_entry_value_tbl);
5480:
5481: -- ** remove ** following update when api supports
5482: -- the attributes that are being updated.
5483: update pay_element_entries_f pee
5484: set pee.balance_adj_cost_flag = v_ele_entry_rec.balance_adj_cost_flag,
5485: pee.source_asg_action_id = v_ele_entry_rec.source_asg_action_id,
5486: pee.source_link_id = v_ele_entry_rec.source_link_id,
5487: pee.source_trigger_entry = v_ele_entry_rec.source_trigger_entry,
5560:
5561: --
5562: -- only single element entry row exists, no need for effective dates
5563: --
5564: UPDATE pay_element_entries_f
5565: SET entry_information_category = l_category
5566: WHERE element_entry_id = v_element_entry_id;
5567: end if;
5568: --
5610: ee.creator_id,
5611: ee.effective_start_date,
5612: ee.effective_end_date,
5613: ee.element_link_id
5614: from pay_element_entries_f ee
5615: where ee.assignment_id = p_assignment_id
5616: and ee.entry_type = 'E'
5617: and exists
5618: (select null
5743: and eev.effective_end_date = v_entry.effective_end_date;
5744: --
5745: -- Remove element entries.
5746: --
5747: delete from pay_element_entries_f ee
5748: where ee.element_entry_id = v_entry.element_entry_id
5749: and ee.effective_start_date = v_entry.effective_start_date
5750: and ee.effective_end_date = v_entry.effective_end_date;
5751: --
5939: select ee.element_entry_id,
5940: ee.effective_start_date,
5941: ee.effective_end_date,
5942: ee.element_link_id
5943: from pay_element_entries_f ee
5944: where ee.assignment_id = p_assignment_id
5945: and ee.entry_type = 'E'
5946: and nvl(ee.updating_action_type,'null') <> 'S' -- Bugfix 2249308
5947: and exists
5977: and p_final_process_date
5978: between effective_start_date and asg.effective_end_date
5979: and ptp.payroll_id = asg.payroll_id
5980: and p_final_process_date between ptp.start_date and ptp.end_date
5981: and exists ( select null from pay_element_entries_f ent,
5982: pay_element_types_f et
5983: where ent.assignment_id = asg.assignment_id
5984: and et.element_type_id = ent.element_type_id
5985: and et.processing_type = 'N'
6302: (exists
6303: (
6304: -- change 115.40
6305: --select null
6306: select /*+ index(ee pay_element_entries_f_n51) */ null
6307: from pay_element_entries_f ee,
6308: pay_element_types_f et
6309: where ee.element_type_id = et.element_type_id
6310: and et.processing_type = 'R'
6303: (
6304: -- change 115.40
6305: --select null
6306: select /*+ index(ee pay_element_entries_f_n51) */ null
6307: from pay_element_entries_f ee,
6308: pay_element_types_f et
6309: where ee.element_type_id = et.element_type_id
6310: and et.processing_type = 'R'
6311: and ee.entry_type = 'E'
6329: -- Bugfix 2121907
6330: -- Ensure no entries exist for this element link and assignment
6331: and not exists (
6332: select null
6333: from pay_element_entries_f ee
6334: where ee.assignment_id = p_assignment_id
6335: and ee.element_link_id = el.element_link_id
6336: and ee.effective_start_date <= p_validation_end_date
6337: and ee.effective_end_date >= p_validation_start_date
6343: -- Ensure when salary basis is removed in CORRECTION mode, salary
6344: -- element link is not picked up for eligibility criteria validation.
6345: and not exists (
6346: SELECT null
6347: FROM per_all_assignments_f asg_cur, pay_element_entries_f peef
6348: WHERE asg_cur.assignment_id = p_assignment_id
6349: AND asg_cur.effective_start_date = p_validation_start_date
6350: AND asg_cur.pay_basis_id is null
6351: AND EXISTS ( select null
7036: --
7037: -- ensure no entries exist for the assignment
7038: --
7039: and not exists
7040: (select null from pay_element_entries_f pee
7041: where pee.assignment_id = asg.assignment_id
7042: and pee.element_link_id = p_element_link_id
7043: )
7044: order by asg.assignment_id, asg.effective_start_date
7105: --
7106: -- ensure no entries exist for the assignment
7107: --
7108: and not exists
7109: (select null from pay_element_entries_f pee
7110: where pee.assignment_id = asg.assignment_id
7111: and pee.element_link_id = p_element_link_id
7112: )
7113: order by asg.assignment_id, asg.effective_start_date
7229: hr_utility.trace('********** SL creation');
7230: hr_utility.trace('********** l_category>' || l_category || '<');
7231: end if;
7232:
7233: UPDATE pay_element_entries_f
7234: SET entry_information_category = l_category
7235: WHERE element_entry_id = v_dummy_number;
7236: end if;
7237:
7323: pel.grade_id,
7324: pel.pay_basis_id,
7325: pel.link_to_all_payrolls_flag,
7326: pel.standard_link_flag
7327: from pay_element_entries_f pee,
7328: pay_element_links_f pel
7329: where pee.assignment_id = p_assignment_id
7330: and pel.element_link_id = pee.element_link_id;
7331:
8023: ee.updating_action_id,
8024: ee.updating_action_type,
8025: ee.object_version_number
8026: from per_all_assignments_f asg
8027: , pay_element_entries_f ee
8028: , pay_element_types_f et
8029: where asg.assignment_id = c_assignment_id
8030: and asg.assignment_id = ee.assignment_id
8031: and ee.element_type_id = et.element_type_id
8137: set effective_end_date = l_new_eed
8138: where element_entry_id = r_entry.element_entry_id
8139: and p_old_final_process_date between effective_start_date and effective_end_date;
8140:
8141: update pay_element_entries_f
8142: set effective_end_date = l_new_eed
8143: where element_entry_id = r_entry.element_entry_id
8144: and p_old_final_process_date between effective_start_date and effective_end_date;
8145:
8157: where element_entry_id = r_entry.element_entry_id
8158: and p_old_final_process_date between effective_start_date and effective_end_date
8159: and l_new_eed >= effective_start_date;
8160:
8161: update pay_element_entries_f
8162: set effective_end_date = l_new_eed
8163: where element_entry_id = r_entry.element_entry_id
8164: and p_old_final_process_date between effective_start_date and effective_end_date
8165: and l_new_eed >= effective_start_date;