DBA Data[Home] [Help]

APPS.HRENTMNT dependencies on HR_ENTRY

Line 633: hr_entry.entry_asg_pay_link_dates(p_assignment_id,

629: -- issue. Since ALU is only a part of the link eligibility rules,
630: -- we can determine the end date with the link and the assignment.
631: --
632: /***
633: hr_entry.entry_asg_pay_link_dates(p_assignment_id,
634: v_link.element_link_id,
635: v_alu_start_date,
636: v_alu_term_date,
637: v_dummy_date,

Line 1110: p_input_value_id_tbl out nocopy hr_entry.number_table,

1106: p_element_entry_id number,
1107: p_date date,
1108: p_ele_entry_rec out nocopy hrentmnt.t_ele_entry_rec,
1109: p_num_entry_values out nocopy number,
1110: p_input_value_id_tbl out nocopy hr_entry.number_table,
1111: p_entry_value_tbl out nocopy hr_entry.varchar2_table
1112: ) is
1113: --
1114: -- Finds all entry values for an entry.

Line 1111: p_entry_value_tbl out nocopy hr_entry.varchar2_table

1107: p_date date,
1108: p_ele_entry_rec out nocopy hrentmnt.t_ele_entry_rec,
1109: p_num_entry_values out nocopy number,
1110: p_input_value_id_tbl out nocopy hr_entry.number_table,
1111: p_entry_value_tbl out nocopy hr_entry.varchar2_table
1112: ) is
1113: --
1114: -- Finds all entry values for an entry.
1115: --

Line 1145: v_input_value_id_tbl hr_entry.number_table;

1141: -- Local Variables
1142: --
1143: v_ele_entry_rec hrentmnt.t_ele_entry_rec;
1144: v_num_values number := 0;
1145: v_input_value_id_tbl hr_entry.number_table;
1146: v_entry_value_tbl hr_entry.varchar2_table;
1147: v_db_format varchar2(60);
1148: v_screen_format varchar2(80);
1149: --

Line 1146: v_entry_value_tbl hr_entry.varchar2_table;

1142: --
1143: v_ele_entry_rec hrentmnt.t_ele_entry_rec;
1144: v_num_values number := 0;
1145: v_input_value_id_tbl hr_entry.number_table;
1146: v_entry_value_tbl hr_entry.varchar2_table;
1147: v_db_format varchar2(60);
1148: v_screen_format varchar2(80);
1149: --
1150: procedure check_parameters is

Line 1260: -- api call hr_entry_api.insert_element_entry.

1256: end;
1257: --
1258: -- Retrieve all entry values for the element entry and convert into screen
1259: -- format. Store these in a table to be used later by the element entry
1260: -- api call hr_entry_api.insert_element_entry.
1261: --
1262: for v_entry_value in csr_entry_values(p_element_entry_id,
1263: p_date) loop
1264: --

Line 1560: hr_entry.trigger_workload_shifting

1556: v_change_end_date := greatest(p_old_date,p_new_date);
1557: --
1558: end if;
1559: --
1560: hr_entry.trigger_workload_shifting
1561: ('ELEMENT_ENTRY',
1562: p_assignment_id,
1563: v_change_start_date,
1564: v_change_end_date);

Line 1566: hr_entry.chk_element_entry_open

1562: p_assignment_id,
1563: v_change_start_date,
1564: v_change_end_date);
1565: --
1566: hr_entry.chk_element_entry_open
1567: (v_ele_info_rec.element_type_id,
1568: v_change_start_date,
1569: v_change_start_date,
1570: v_change_end_date,

Line 1632: hr_entry.delete_covered_dependants(

1628: -- Update the covered dependents and beneficiaries for the element entry
1629: -- This should be called in both DELETE and UPDATE modes.
1630: --
1631: if p_start_or_end_date = 'START' then
1632: hr_entry.delete_covered_dependants(
1633: p_validation_start_date => p_old_date,
1634: p_element_entry_id => p_element_entry_id,
1635: p_start_date => p_new_date);
1636:

Line 1637: hr_entry.delete_beneficiaries(

1633: p_validation_start_date => p_old_date,
1634: p_element_entry_id => p_element_entry_id,
1635: p_start_date => p_new_date);
1636:
1637: hr_entry.delete_beneficiaries(
1638: p_validation_start_date => p_old_date,
1639: p_element_entry_id => p_element_entry_id,
1640: p_start_date => p_new_date);
1641:

Line 1643: hr_entry.delete_covered_dependants(

1639: p_element_entry_id => p_element_entry_id,
1640: p_start_date => p_new_date);
1641:
1642: elsif p_start_or_end_date = 'END' then
1643: hr_entry.delete_covered_dependants(
1644: p_validation_start_date => p_old_date,
1645: p_element_entry_id => p_element_entry_id,
1646: p_end_date => p_new_date);
1647:

Line 1648: hr_entry.delete_beneficiaries(

1644: p_validation_start_date => p_old_date,
1645: p_element_entry_id => p_element_entry_id,
1646: p_end_date => p_new_date);
1647:
1648: hr_entry.delete_beneficiaries(
1649: p_validation_start_date => p_old_date,
1650: p_element_entry_id => p_element_entry_id,
1651: p_end_date => p_new_date);
1652:

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

1876: -- make sure EL piece overlaps validation period
1877: --
1878: -- Bugfix 4627931
1879: -- Ensure the EL exists as at the validation start date.
1880: -- This is because hr_entry_api expects the EL to exist as at this date
1881: -- and raises error APP-PAY-07027 if it does not.
1882: -- Also, we should not re-create entries after there has been any gap in
1883: -- eligibility after the validation start date.
1884: and p_validation_start_date between el.effective_start_date and el.effective_end_date

Line 1990: p_tbl_ivids in hr_entry.number_table,

1986: p_ee_effective_end_date in date,
1987: p_ee_creator_type in varchar2,
1988: p_rec_ee in hrentmnt.t_ele_entry_rec,
1989: p_num_eevs in number,
1990: p_tbl_ivids in hr_entry.number_table,
1991: p_tbl_eevs in hr_entry.varchar2_table,
1992: p_entry_recreated out nocopy boolean
1993: )
1994: is

Line 1991: p_tbl_eevs in hr_entry.varchar2_table,

1987: p_ee_creator_type in varchar2,
1988: p_rec_ee in hrentmnt.t_ele_entry_rec,
1989: p_num_eevs in number,
1990: p_tbl_ivids in hr_entry.number_table,
1991: p_tbl_eevs in hr_entry.varchar2_table,
1992: p_entry_recreated out nocopy boolean
1993: )
1994: is
1995: --

Line 2087: hr_entry_api.insert_element_entry(

2083: p_validation_start_date);
2084: l_calc_ee_eed := least(p_ee_effective_end_date,
2085: rec_eligible_links.effective_end_date);
2086: --
2087: hr_entry_api.insert_element_entry(
2088: p_effective_start_date => l_calc_ee_esd,
2089: p_effective_end_date => l_ee_eed_out,
2090: p_element_entry_id => l_eeid_out,
2091: p_assignment_id => p_assignment_id,

Line 2462: l_tbl_ivids hr_entry.number_table;

2458: is
2459: --
2460: l_rec_ee hrentmnt.t_ele_entry_rec;
2461: l_num_eevs number := 0;
2462: l_tbl_ivids hr_entry.number_table;
2463: l_tbl_eevs hr_entry.varchar2_table;
2464: l_entry_recreated boolean := false;
2465: --
2466: begin

Line 2463: l_tbl_eevs hr_entry.varchar2_table;

2459: --
2460: l_rec_ee hrentmnt.t_ele_entry_rec;
2461: l_num_eevs number := 0;
2462: l_tbl_ivids hr_entry.number_table;
2463: l_tbl_eevs hr_entry.varchar2_table;
2464: l_entry_recreated boolean := false;
2465: --
2466: begin
2467: --

Line 2593: l_tbl_ivids hr_entry.number_table;

2589:
2590: --
2591: l_rec_ee hrentmnt.t_ele_entry_rec;
2592: l_num_eevs number := 0;
2593: l_tbl_ivids hr_entry.number_table;
2594: l_tbl_eevs hr_entry.varchar2_table;
2595: l_entry_recreated boolean := false;
2596: l_dyt_mode varchar2(75);
2597: l_business_group_id number;

Line 2594: l_tbl_eevs hr_entry.varchar2_table;

2590: --
2591: l_rec_ee hrentmnt.t_ele_entry_rec;
2592: l_num_eevs number := 0;
2593: l_tbl_ivids hr_entry.number_table;
2594: l_tbl_eevs hr_entry.varchar2_table;
2595: l_entry_recreated boolean := false;
2596: l_dyt_mode varchar2(75);
2597: l_business_group_id number;
2598: l_legislation_code varchar2(10);

Line 3190: hr_entry.return_qualifying_conditions

3186: -- element entries.
3187: --
3188: if p_standard_link_flag = 'Y' then
3189: --
3190: hr_entry.return_qualifying_conditions
3191: (p_assignment_id,
3192: p_element_link_id,
3193: greatest(p_link_start_date,p_asg_start_date),
3194: v_los_date,

Line 3215: v_entry_end_date := hr_entry.recurring_entry_end_date

3211: --
3212: -- Calculate the element entry end date taking into account future
3213: -- terminations.
3214: --
3215: v_entry_end_date := hr_entry.recurring_entry_end_date
3216: (p_assignment_id,
3217: p_element_link_id,
3218: greatest(p_link_start_date,p_asg_start_date),
3219: 'N',

Line 3859: hr_entry.get_nonrecurring_dates

3855:
3856: --
3857: -- Calculate the start and end dates of the nonrecurring entry.
3858: --
3859: hr_entry.get_nonrecurring_dates
3860: (p_assignment_id,
3861: v_session_date,
3862: v_effective_start_date,
3863: v_effective_end_date,

Line 4082: v_input_value_id_tbl hr_entry.number_table;

4078: v_calc_entry_start_date date;
4079: v_calc_entry_end_date date;
4080: v_ele_entry_rec hrentmnt.t_ele_entry_rec;
4081: v_num_entry_values number := 0;
4082: v_input_value_id_tbl hr_entry.number_table;
4083: v_entry_value_tbl hr_entry.varchar2_table;
4084:
4085: -- bugfix 1691062
4086: l_category fnd_descr_flex_contexts.descriptive_flex_context_code%type;

Line 4083: v_entry_value_tbl hr_entry.varchar2_table;

4079: v_calc_entry_end_date date;
4080: v_ele_entry_rec hrentmnt.t_ele_entry_rec;
4081: v_num_entry_values number := 0;
4082: v_input_value_id_tbl hr_entry.number_table;
4083: v_entry_value_tbl hr_entry.varchar2_table;
4084:
4085: -- bugfix 1691062
4086: l_category fnd_descr_flex_contexts.descriptive_flex_context_code%type;
4087: --

Line 4633: hr_entry_api.insert_element_entry

4629: --
4630: if g_debug then
4631: hr_utility.trace('Original_entry_id : ' || v_distinct_entry_id);
4632: end if;
4633: hr_entry_api.insert_element_entry
4634: (p_effective_start_date => v_calc_entry_start_date,
4635: p_effective_end_date => v_dummy_date,
4636: p_element_entry_id => v_element_entry_id,
4637: p_original_entry_id => v_distinct_entry_id,

Line 4759: hr_entry_api.insert_element_entry

4755: if g_debug then
4756: hr_utility.trace('********** ASG criteria delta');
4757: hr_utility.trace('********** for SL call EE insert interface');
4758: end if;
4759: hr_entry_api.insert_element_entry
4760: (p_effective_start_date => v_calc_entry_start_date,
4761: p_effective_end_date => v_dummy_date,
4762: p_element_entry_id => v_element_entry_id,
4763: p_assignment_id => p_assignment_id,

Line 4921: hr_entry.return_qualifying_conditions

4917: --
4918: -- Get the start date of the element entry accordinbg to the qualifying
4919: -- conditions.
4920: --
4921: hr_entry.return_qualifying_conditions
4922: (p_assignment_id,
4923: v_entry.element_link_id,
4924: v_entry.effective_start_date,
4925: v_los_date,

Line 5271: v_entry_end_date := hr_entry.recurring_entry_end_date

5267: c_sot) loop
5268: --
5269: -- Get the true end date of the recurring entry.
5270: --
5271: v_entry_end_date := hr_entry.recurring_entry_end_date
5272: (p_assignment_id,
5273: v_entry.element_link_id,
5274: v_entry.effective_start_date,
5275: 'N',

Line 6132: v_input_value_id_tbl hr_entry.number_table;

6128: v_entry_start_date date;
6129: v_entry_end_date date;
6130: v_dummy_number number;
6131: v_num_entry_values number;
6132: v_input_value_id_tbl hr_entry.number_table;
6133: v_entry_value_tbl hr_entry.varchar2_table;
6134: v_message_name varchar2(30);
6135: v_appl_short_name varchar2(30);
6136: v_asg_visible number;

Line 6133: v_entry_value_tbl hr_entry.varchar2_table;

6129: v_entry_end_date date;
6130: v_dummy_number number;
6131: v_num_entry_values number;
6132: v_input_value_id_tbl hr_entry.number_table;
6133: v_entry_value_tbl hr_entry.varchar2_table;
6134: v_message_name varchar2(30);
6135: v_appl_short_name varchar2(30);
6136: v_asg_visible number;
6137: -- bugfix 1691062

Line 6304: hr_entry_api.insert_element_entry

6300: if g_debug then
6301: hr_utility.trace('********** SL creation');
6302: hr_utility.trace('********** for SL call EE insert interface');
6303: end if;
6304: hr_entry_api.insert_element_entry
6305: (p_effective_start_date => v_entry_start_date,
6306: p_effective_end_date => v_entry_end_date,
6307: p_element_entry_id => v_dummy_number,
6308: p_assignment_id => v_asg_id,

Line 6966: -- hr_entry_api.move_fpd_entries --

6962: --
6963:
6964: ------------------------------------------------------------------------------
6965: -- NAME --
6966: -- hr_entry_api.move_fpd_entries --
6967: -- --
6968: -- DESCRIPTION --
6969: -- This procedure should be called from HR code to carry out entry changes --
6970: -- when final process date is changed. --

Line 7059: hr_entry.chk_element_entry_main

7055: hr_utility.set_location(l_proc,40);
7056: -- Non-recurring entry
7057: -- Derive new effective end date using chk_element_entry_main
7058: -- This will ensure the payroll period is considered
7059: hr_entry.chk_element_entry_main
7060: (
7061: p_element_entry_id => r_entry.element_entry_id,
7062: p_original_entry_id => r_entry.original_entry_id,
7063: p_session_date => l_session_date,

Line 7082: hr_entry.get_eligibility_period

7078: hr_utility.set_location(l_proc,50);
7079: -- Recurring entry
7080: -- Derive new effective end date using get_eligibility_period
7081: -- This will ensure entry is not extended beyond lifetime of link
7082: hr_entry.get_eligibility_period
7083: (
7084: p_assignment_id => r_entry.assignment_id,
7085: p_element_link_id => r_entry.element_link_id,
7086: p_session_date => l_session_date,