DBA Data[Home] [Help]

APPS.PAY_US_ELEMENT_ENTRY_HOOK dependencies on HR_ENTRY

Line 438: hr_entry_api.delete_element_entry (

434: exit when c_get_ele_entry_id%NOTFOUND;
435:
436: hr_utility.trace('Deleting Element Entry = ' || ln_ele_entry_id);
437: hr_utility.trace('Deletion Date = ' || ld_del_start_date);
438: hr_entry_api.delete_element_entry (
439: p_dt_delete_mode => 'ZAP',
440: p_session_date => ld_del_start_date,
441: p_element_entry_id => ln_ele_entry_id);
442: end loop;

Line 791: l_input_value_id_tbl hr_entry.number_table;

787: ld_rec_ele_end_date DATE;
788: ld_dummy_end_date DATE;
789: lb_auth_flag BOOLEAN;
790: l_input_value_name_tbl varchar2_table;
791: l_input_value_id_tbl hr_entry.number_table;
792: l_entry_value_tbl hr_entry.varchar2_table;
793: lvr number; -- loop variable
794:
795:

Line 792: l_entry_value_tbl hr_entry.varchar2_table;

788: ld_dummy_end_date DATE;
789: lb_auth_flag BOOLEAN;
790: l_input_value_name_tbl varchar2_table;
791: l_input_value_id_tbl hr_entry.number_table;
792: l_entry_value_tbl hr_entry.varchar2_table;
793: lvr number; -- loop variable
794:
795:
796: BEGIN

Line 956: hr_entry_api.insert_element_entry (

952:
953: l_entry_value_tbl(ln_daily_amt_index) := gn_daily_amount;
954: ld_dummy_end_date := gd_end_date_tbl(lvr);
955:
956: hr_entry_api.insert_element_entry (
957: p_effective_start_date => gd_start_date_tbl(lvr)
958: ,p_effective_end_date => ld_dummy_end_date
959: ,p_element_entry_id => ln_element_entry_id
960: ,p_original_entry_id => ln_original_entry_id

Line 979: hr_entry_api.delete_element_entry (

975: -- End dating the element using gd_end_date_tbl(lvr)
976: -- as ld_dummy_end_date gets overwritten by the
977: -- previous call
978: if ld_dummy_end_date <> gd_end_date_tbl(lvr) then
979: hr_entry_api.delete_element_entry (
980: p_dt_delete_mode => 'DELETE',
981: p_session_date => gd_end_date_tbl(lvr),
982: p_element_entry_id => ln_element_entry_id);
983: end if;

Line 993: hr_entry_api.update_element_entry

989: l_entry_value_tbl(ln_daily_amt_index) :=
990: ln_total_value - ((ln_no_of_days - 1) * gn_daily_amount);
991: if gd_start_date_tbl(lvr) = gd_end_date_tbl(lvr) then
992: -- Update the Element Entry values in Date-track mode
993: hr_entry_api.update_element_entry
994: (p_dt_update_mode => 'CORRECTION'
995: ,p_session_date => gd_end_date_tbl(lvr)
996: ,p_element_entry_id => ln_element_entry_id
997: ,p_num_entry_values => l_entry_value_tbl.count()

Line 1002: hr_entry_api.update_element_entry

998: ,p_input_value_id_tbl => l_input_value_id_tbl
999: ,p_entry_value_tbl => l_entry_value_tbl);
1000: else
1001: -- Update the Element Entry values in Date-track mode
1002: hr_entry_api.update_element_entry
1003: (p_dt_update_mode => 'UPDATE'
1004: ,p_session_date => gd_end_date_tbl(lvr)
1005: ,p_element_entry_id => ln_element_entry_id
1006: ,p_num_entry_values => l_entry_value_tbl.count()

Line 1563: ln_input_value_id_tbl hr_entry.number_table;

1559: lb_mop_up_flag boolean;
1560: ld_start_date_tbl date_table;
1561: ld_end_date_tbl date_table;
1562: ln_link_id_tbl number_table;
1563: ln_input_value_id_tbl hr_entry.number_table;
1564: lv_entry_value_tbl hr_entry.varchar2_table;
1565:
1566: BEGIN
1567:

Line 1564: lv_entry_value_tbl hr_entry.varchar2_table;

1560: ld_start_date_tbl date_table;
1561: ld_end_date_tbl date_table;
1562: ln_link_id_tbl number_table;
1563: ln_input_value_id_tbl hr_entry.number_table;
1564: lv_entry_value_tbl hr_entry.varchar2_table;
1565:
1566: BEGIN
1567:
1568: lb_mop_up_flag := FALSE;

Line 1787: hr_entry_api.insert_element_entry (

1783: hr_utility.trace('Element End Date = ' || ld_end_date_tbl(lvr));
1784:
1785: ld_dummy_end_date := ld_end_date_tbl(lvr);
1786:
1787: hr_entry_api.insert_element_entry (
1788: p_effective_start_date => ld_start_date_tbl(lvr)
1789: ,p_effective_end_date => ld_dummy_end_date
1790: ,p_element_entry_id => ln_element_entry_id
1791: ,p_original_entry_id => ln_original_entry_id

Line 1811: hr_entry_api.delete_element_entry (

1807: -- as ld_dummy_end_date gets overwritten by the
1808: -- previous call
1809: if ld_dummy_end_date <> ld_end_date_tbl(lvr) then
1810: hr_utility.trace('End dating the Element Entry Created');
1811: hr_entry_api.delete_element_entry (
1812: p_dt_delete_mode => 'DELETE',
1813: p_session_date => ld_end_date_tbl(lvr),
1814: p_element_entry_id => ln_element_entry_id);
1815: end if; -- if ld_dummy_end_date

Line 1988: l_input_value_id_tbl hr_entry.number_table;

1984: ld_new_rec_ele_end_date date;
1985: lb_aug_flag boolean;
1986: l_elem_entry_id_tbl number_table;
1987: l_del_start_date_tbl date_table;
1988: l_input_value_id_tbl hr_entry.number_table;
1989: l_entry_value_tbl hr_entry.varchar2_table;
1990:
1991: BEGIN
1992:

Line 1989: l_entry_value_tbl hr_entry.varchar2_table;

1985: lb_aug_flag boolean;
1986: l_elem_entry_id_tbl number_table;
1987: l_del_start_date_tbl date_table;
1988: l_input_value_id_tbl hr_entry.number_table;
1989: l_entry_value_tbl hr_entry.varchar2_table;
1990:
1991: BEGIN
1992:
1993: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_RECUR_ELEM_ENTRY');

Line 2104: hr_entry_api.delete_element_entry (

2100: -- Deleting the Recurring element entries previously created
2101: hr_utility.trace('Deleting Old Recurring Element Entries');
2102: if l_elem_entry_id_tbl.count() > 0 then
2103: for lvar in l_elem_entry_id_tbl.first..l_elem_entry_id_tbl.last loop
2104: hr_entry_api.delete_element_entry (
2105: p_dt_delete_mode => 'ZAP',
2106: p_session_date => l_del_start_date_tbl(lvar),
2107: p_element_entry_id => l_elem_entry_id_tbl(lvar));
2108: end loop; -- for lvar in l_elem_entry_id_tbl

Line 2149: hr_entry_api.update_element_entry

2145: ((ln_no_of_days-1) * ln_daily_amount);
2146: else
2147: l_entry_value_tbl(1) := to_char(ln_daily_amount);
2148: end if;
2149: hr_entry_api.update_element_entry
2150: (p_dt_update_mode => 'CORRECTION'
2151: ,p_session_date => l_del_start_date_tbl(lvar)
2152: ,p_element_entry_id => l_elem_entry_id_tbl(lvar)
2153: ,p_num_entry_values => 1

Line 2324: l_input_value_id_tbl hr_entry.number_table;

2320: lb_mop_up_flag boolean;
2321: lb_delete_mopup boolean;
2322: l_elem_entry_id_tbl number_table;
2323: l_del_start_date_tbl date_table;
2324: l_input_value_id_tbl hr_entry.number_table;
2325: l_entry_value_tbl hr_entry.varchar2_table;
2326:
2327: BEGIN
2328:

Line 2325: l_entry_value_tbl hr_entry.varchar2_table;

2321: lb_delete_mopup boolean;
2322: l_elem_entry_id_tbl number_table;
2323: l_del_start_date_tbl date_table;
2324: l_input_value_id_tbl hr_entry.number_table;
2325: l_entry_value_tbl hr_entry.varchar2_table;
2326:
2327: BEGIN
2328:
2329: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_PREMIUM_MOP_UP_ELEMENT');

Line 2450: hr_entry_api.update_element_entry

2446: end loop;
2447:
2448: for lvar in l_elem_entry_id_tbl.first..l_elem_entry_id_tbl.last
2449: loop
2450: hr_entry_api.update_element_entry
2451: (p_dt_update_mode => 'CORRECTION'
2452: ,p_session_date => l_del_start_date_tbl(lvar)
2453: ,p_element_entry_id => l_elem_entry_id_tbl(lvar)
2454: ,p_num_entry_values => l_entry_value_tbl.count()