DBA Data[Home] [Help]

APPS.HRENTMNT dependencies on HR_ENTRY

Line 970: p_input_value_id_tbl out nocopy hr_entry.number_table,

966: p_element_entry_id number,
967: p_date date,
968: p_ele_entry_rec out nocopy hrentmnt.t_ele_entry_rec,
969: p_num_entry_values out nocopy number,
970: p_input_value_id_tbl out nocopy hr_entry.number_table,
971: p_entry_value_tbl out nocopy hr_entry.varchar2_table
972: ) is
973: --
974: -- Finds all entry values for an entry.

Line 971: p_entry_value_tbl out nocopy hr_entry.varchar2_table

967: p_date date,
968: p_ele_entry_rec out nocopy hrentmnt.t_ele_entry_rec,
969: p_num_entry_values out nocopy number,
970: p_input_value_id_tbl out nocopy hr_entry.number_table,
971: p_entry_value_tbl out nocopy hr_entry.varchar2_table
972: ) is
973: --
974: -- Finds all entry values for an entry.
975: --

Line 1005: v_input_value_id_tbl hr_entry.number_table;

1001: -- Local Variables
1002: --
1003: v_ele_entry_rec hrentmnt.t_ele_entry_rec;
1004: v_num_values number := 0;
1005: v_input_value_id_tbl hr_entry.number_table;
1006: v_entry_value_tbl hr_entry.varchar2_table;
1007: v_db_format varchar2(60);
1008: v_screen_format varchar2(80);
1009: --

Line 1006: v_entry_value_tbl hr_entry.varchar2_table;

1002: --
1003: v_ele_entry_rec hrentmnt.t_ele_entry_rec;
1004: v_num_values number := 0;
1005: v_input_value_id_tbl hr_entry.number_table;
1006: v_entry_value_tbl hr_entry.varchar2_table;
1007: v_db_format varchar2(60);
1008: v_screen_format varchar2(80);
1009: --
1010: procedure check_parameters is

Line 1120: -- api call hr_entry_api.insert_element_entry.

1116: end;
1117: --
1118: -- Retrieve all entry values for the element entry and convert into screen
1119: -- format. Store these in a table to be used later by the element entry
1120: -- api call hr_entry_api.insert_element_entry.
1121: --
1122: for v_entry_value in csr_entry_values(p_element_entry_id,
1123: p_date) loop
1124: --

Line 1778: hr_entry.trigger_workload_shifting

1774: v_change_end_date := greatest(p_old_date,p_new_date);
1775: --
1776: end if;
1777: --
1778: hr_entry.trigger_workload_shifting
1779: ('ELEMENT_ENTRY',
1780: p_assignment_id,
1781: v_change_start_date,
1782: v_change_end_date);

Line 1784: hr_entry.chk_element_entry_open

1780: p_assignment_id,
1781: v_change_start_date,
1782: v_change_end_date);
1783: --
1784: hr_entry.chk_element_entry_open
1785: (v_ele_info_rec.element_type_id,
1786: v_change_start_date,
1787: v_change_start_date,
1788: v_change_end_date,

Line 1850: hr_entry.delete_covered_dependants(

1846: -- Update the covered dependents and beneficiaries for the element entry
1847: -- This should be called in both DELETE and UPDATE modes.
1848: --
1849: if p_start_or_end_date = 'START' then
1850: hr_entry.delete_covered_dependants(
1851: p_validation_start_date => p_old_date,
1852: p_element_entry_id => p_element_entry_id,
1853: p_start_date => p_new_date);
1854:

Line 1855: hr_entry.delete_beneficiaries(

1851: p_validation_start_date => p_old_date,
1852: p_element_entry_id => p_element_entry_id,
1853: p_start_date => p_new_date);
1854:
1855: hr_entry.delete_beneficiaries(
1856: p_validation_start_date => p_old_date,
1857: p_element_entry_id => p_element_entry_id,
1858: p_start_date => p_new_date);
1859:

Line 1861: hr_entry.delete_covered_dependants(

1857: p_element_entry_id => p_element_entry_id,
1858: p_start_date => p_new_date);
1859:
1860: elsif p_start_or_end_date = 'END' then
1861: hr_entry.delete_covered_dependants(
1862: p_validation_start_date => p_old_date,
1863: p_element_entry_id => p_element_entry_id,
1864: p_end_date => p_new_date);
1865:

Line 1866: hr_entry.delete_beneficiaries(

1862: p_validation_start_date => p_old_date,
1863: p_element_entry_id => p_element_entry_id,
1864: p_end_date => p_new_date);
1865:
1866: hr_entry.delete_beneficiaries(
1867: p_validation_start_date => p_old_date,
1868: p_element_entry_id => p_element_entry_id,
1869: p_end_date => p_new_date);
1870:

Line 2054: hr_entry.maintain_covered_dependants(

2050: hr_utility.trace('p_new_element_entry_ESD>' || p_new_element_entry_ESD || '<');
2051: hr_utility.trace('p_new_element_entry_EED>' || p_new_element_entry_EED || '<');
2052: end if;
2053:
2054: hr_entry.maintain_covered_dependants(
2055: p_element_entry_id => p_element_entry_id
2056: ,p_element_entry_ESD => p_element_entry_ESD
2057: ,p_element_entry_EED => p_element_entry_EED
2058: ,p_new_element_entry_id => p_new_element_entry_id

Line 2062: hr_entry.maintain_beneficiaries(

2058: ,p_new_element_entry_id => p_new_element_entry_id
2059: ,p_new_element_entry_ESD => p_new_element_entry_ESD
2060: ,p_new_element_entry_EED => p_new_element_entry_EED);
2061:
2062: hr_entry.maintain_beneficiaries(
2063: p_element_entry_id => p_element_entry_id
2064: ,p_element_entry_ESD => p_element_entry_ESD
2065: ,p_element_entry_EED => p_element_entry_EED
2066: ,p_new_element_entry_id => p_new_element_entry_id

Line 2160: -- This is because hr_entry_api expects the EL to exist as at this date

2156: -- make sure EL piece overlaps validation period
2157: --
2158: -- Bugfix 4627931
2159: -- Ensure the EL exists as at the validation start date.
2160: -- This is because hr_entry_api expects the EL to exist as at this date
2161: -- and raises error APP-PAY-07027 if it does not.
2162: -- Also, we should not re-create entries after there has been any gap in
2163: -- eligibility after the validation start date.
2164: and p_validation_start_date between el.effective_start_date and el.effective_end_date

Line 2270: p_tbl_ivids in hr_entry.number_table,

2266: p_ee_effective_end_date in date,
2267: p_ee_creator_type in varchar2,
2268: p_rec_ee in hrentmnt.t_ele_entry_rec,
2269: p_num_eevs in number,
2270: p_tbl_ivids in hr_entry.number_table,
2271: p_tbl_eevs in hr_entry.varchar2_table,
2272: p_entry_recreated out nocopy boolean
2273: )
2274: is

Line 2271: p_tbl_eevs in hr_entry.varchar2_table,

2267: p_ee_creator_type in varchar2,
2268: p_rec_ee in hrentmnt.t_ele_entry_rec,
2269: p_num_eevs in number,
2270: p_tbl_ivids in hr_entry.number_table,
2271: p_tbl_eevs in hr_entry.varchar2_table,
2272: p_entry_recreated out nocopy boolean
2273: )
2274: is
2275: --

Line 2417: hr_entry_api.insert_element_entry(

2413: end;
2414: hr_utility.trace('After:l_original_entry_id: '||l_original_entry_id);
2415: /* Bug 14184639 Changes end */
2416: --
2417: hr_entry_api.insert_element_entry(
2418: p_effective_start_date => l_calc_ee_esd,
2419: p_effective_end_date => l_ee_eed_out,
2420: p_element_entry_id => l_eeid_out,
2421: p_original_entry_id => l_original_entry_id, -- Bug fix 12364433

Line 2804: l_tbl_ivids hr_entry.number_table;

2800: where business_group_id=p_business_group_id;
2801:
2802: l_rec_ee hrentmnt.t_ele_entry_rec;
2803: l_num_eevs number := 0;
2804: l_tbl_ivids hr_entry.number_table;
2805: l_tbl_eevs hr_entry.varchar2_table;
2806: l_entry_recreated boolean := false;
2807: -- below variables added for 8870436
2808: l_dyt_mode varchar2(75);

Line 2805: l_tbl_eevs hr_entry.varchar2_table;

2801:
2802: l_rec_ee hrentmnt.t_ele_entry_rec;
2803: l_num_eevs number := 0;
2804: l_tbl_ivids hr_entry.number_table;
2805: l_tbl_eevs hr_entry.varchar2_table;
2806: l_entry_recreated boolean := false;
2807: -- below variables added for 8870436
2808: l_dyt_mode varchar2(75);
2809: l_business_group_id number;

Line 2972: l_tbl_ivids hr_entry.number_table;

2968:
2969: --
2970: l_rec_ee hrentmnt.t_ele_entry_rec;
2971: l_num_eevs number := 0;
2972: l_tbl_ivids hr_entry.number_table;
2973: l_tbl_eevs hr_entry.varchar2_table;
2974: l_entry_recreated boolean := false;
2975: l_dyt_mode varchar2(75);
2976: l_business_group_id number;

Line 2973: l_tbl_eevs hr_entry.varchar2_table;

2969: --
2970: l_rec_ee hrentmnt.t_ele_entry_rec;
2971: l_num_eevs number := 0;
2972: l_tbl_ivids hr_entry.number_table;
2973: l_tbl_eevs hr_entry.varchar2_table;
2974: l_entry_recreated boolean := false;
2975: l_dyt_mode varchar2(75);
2976: l_business_group_id number;
2977: l_legislation_code varchar2(10);

Line 3827: hr_entry.return_qualifying_conditions

3823: -- element entries.
3824: --
3825: if p_standard_link_flag = 'Y' then
3826: --
3827: hr_entry.return_qualifying_conditions
3828: (p_assignment_id,
3829: p_element_link_id,
3830: greatest(p_link_start_date,p_asg_start_date),
3831: v_los_date,

Line 3852: v_entry_end_date := hr_entry.recurring_entry_end_date

3848: --
3849: -- Calculate the element entry end date taking into account future
3850: -- terminations.
3851: --
3852: v_entry_end_date := hr_entry.recurring_entry_end_date
3853: (p_assignment_id,
3854: p_element_link_id,
3855: greatest(p_link_start_date,p_asg_start_date),
3856: 'N',

Line 4561: hr_entry.get_nonrecurring_dates

4557: v_max_eligible_date := null;
4558: --
4559: -- Calculate the start and end dates of the nonrecurring entry.
4560: --
4561: hr_entry.get_nonrecurring_dates
4562: (p_assignment_id,
4563: v_session_date,
4564: v_effective_start_date,
4565: v_effective_end_date,

Line 4570: /*Bug 8798020 Added Call to hr_entry.get_eligibility_period */

4566: v_payroll_id,
4567: v_period_start_date,
4568: v_period_end_date);
4569:
4570: /*Bug 8798020 Added Call to hr_entry.get_eligibility_period */
4571: hr_entry.get_eligibility_period (p_assignment_id,
4572: v_entry.element_link_id,
4573: v_session_date,
4574: v_min_eligible_date,

Line 4571: hr_entry.get_eligibility_period (p_assignment_id,

4567: v_period_start_date,
4568: v_period_end_date);
4569:
4570: /*Bug 8798020 Added Call to hr_entry.get_eligibility_period */
4571: hr_entry.get_eligibility_period (p_assignment_id,
4572: v_entry.element_link_id,
4573: v_session_date,
4574: v_min_eligible_date,
4575: v_max_eligible_date);

Line 4818: v_input_value_id_tbl hr_entry.number_table;

4814: v_calc_entry_start_date date;
4815: v_calc_entry_end_date date;
4816: v_ele_entry_rec hrentmnt.t_ele_entry_rec;
4817: v_num_entry_values number := 0;
4818: v_input_value_id_tbl hr_entry.number_table;
4819: v_entry_value_tbl hr_entry.varchar2_table;
4820:
4821: -- bugfix 1691062
4822: l_category fnd_descr_flex_contexts.descriptive_flex_context_code%type;

Line 4819: v_entry_value_tbl hr_entry.varchar2_table;

4815: v_calc_entry_end_date date;
4816: v_ele_entry_rec hrentmnt.t_ele_entry_rec;
4817: v_num_entry_values number := 0;
4818: v_input_value_id_tbl hr_entry.number_table;
4819: v_entry_value_tbl hr_entry.varchar2_table;
4820:
4821: -- bugfix 1691062
4822: l_category fnd_descr_flex_contexts.descriptive_flex_context_code%type;
4823: --

Line 4910: return hr_entry.assignment_eligible_for_link(p_assignment_id

4906: ,p_effective_date date)
4907: return varchar2 is
4908: PRAGMA AUTONOMOUS_TRANSACTION;
4909: begin
4910: return hr_entry.assignment_eligible_for_link(p_assignment_id
4911: ,p_element_link_id
4912: ,p_effective_date);
4913: exception
4914: when others then

Line 5405: hr_entry_api.insert_element_entry

5401: --
5402: if g_debug then
5403: hr_utility.trace('Original_entry_id : ' || v_distinct_entry_id);
5404: end if;
5405: hr_entry_api.insert_element_entry
5406: (p_effective_start_date => v_calc_entry_start_date,
5407: p_effective_end_date => v_dummy_date,
5408: p_element_entry_id => v_element_entry_id,
5409: p_original_entry_id => v_distinct_entry_id,

Line 5531: hr_entry_api.insert_element_entry

5527: if g_debug then
5528: hr_utility.trace('********** ASG criteria delta');
5529: hr_utility.trace('********** for SL call EE insert interface');
5530: end if;
5531: hr_entry_api.insert_element_entry
5532: (p_effective_start_date => v_calc_entry_start_date,
5533: p_effective_end_date => v_dummy_date,
5534: p_element_entry_id => v_element_entry_id,
5535: p_assignment_id => p_assignment_id,

Line 5693: hr_entry.return_qualifying_conditions

5689: --
5690: -- Get the start date of the element entry accordinbg to the qualifying
5691: -- conditions.
5692: --
5693: hr_entry.return_qualifying_conditions
5694: (p_assignment_id,
5695: v_entry.element_link_id,
5696: v_entry.effective_start_date,
5697: v_los_date,

Line 6086: v_entry_end_date := hr_entry.recurring_entry_end_date

6082: c_sot) loop
6083: --
6084: -- Get the true end date of the recurring entry.
6085: --
6086: v_entry_end_date := hr_entry.recurring_entry_end_date
6087: (p_assignment_id,
6088: v_entry.element_link_id,
6089: v_entry.effective_start_date,
6090: 'N',

Line 6918: v_input_value_id_tbl hr_entry.number_table;

6914: v_entry_start_date date;
6915: v_entry_end_date date;
6916: v_dummy_number number;
6917: v_num_entry_values number;
6918: v_input_value_id_tbl hr_entry.number_table;
6919: v_entry_value_tbl hr_entry.varchar2_table;
6920: v_message_name varchar2(30);
6921: v_appl_short_name varchar2(30);
6922: v_asg_visible number;

Line 6919: v_entry_value_tbl hr_entry.varchar2_table;

6915: v_entry_end_date date;
6916: v_dummy_number number;
6917: v_num_entry_values number;
6918: v_input_value_id_tbl hr_entry.number_table;
6919: v_entry_value_tbl hr_entry.varchar2_table;
6920: v_message_name varchar2(30);
6921: v_appl_short_name varchar2(30);
6922: v_asg_visible number;
6923: -- bugfix 1691062

Line 7214: hr_entry_api.insert_element_entry

7210: if g_debug then
7211: hr_utility.trace('********** SL creation');
7212: hr_utility.trace('********** for SL call EE insert interface');
7213: end if;
7214: hr_entry_api.insert_element_entry
7215: (p_effective_start_date => v_entry_start_date,
7216: p_effective_end_date => v_entry_end_date,
7217: p_element_entry_id => v_dummy_number,
7218: p_assignment_id => v_asg_id,

Line 7989: -- hr_entry_api.move_fpd_entries --

7985: --
7986:
7987: ------------------------------------------------------------------------------
7988: -- NAME --
7989: -- hr_entry_api.move_fpd_entries --
7990: -- --
7991: -- DESCRIPTION --
7992: -- This procedure should be called from HR code to carry out entry changes --
7993: -- when final process date is changed. --

Line 8083: hr_entry.chk_element_entry_main

8079: hr_utility.set_location(l_proc,40);
8080: -- Non-recurring entry
8081: -- Derive new effective end date using chk_element_entry_main
8082: -- This will ensure the payroll period is considered
8083: hr_entry.chk_element_entry_main
8084: (
8085: p_element_entry_id => r_entry.element_entry_id,
8086: p_original_entry_id => r_entry.original_entry_id,
8087: p_session_date => l_session_date,

Line 8106: hr_entry.get_eligibility_period

8102: hr_utility.set_location(l_proc,50);
8103: -- Recurring entry
8104: -- Derive new effective end date using get_eligibility_period
8105: -- This will ensure entry is not extended beyond lifetime of link
8106: hr_entry.get_eligibility_period
8107: (
8108: p_assignment_id => r_entry.assignment_id,
8109: p_element_link_id => r_entry.element_link_id,
8110: p_session_date => l_session_date,