DBA Data[Home] [Help]

APPS.PYUDET dependencies on HR_ENTRY

Line 12: Uses : hr_entry_api, hr_utility

8: Cumulative, clear Previous Tax Paid and Taxable Pay,
9: uplift Tax Codes or read new Tax Codes from tape.
10: Author : Barry Goodsell
11: Date Created : 15-Aug-95
12: Uses : hr_entry_api, hr_utility
13:
14: Change List
15: -----------
16: Date Name Vers Bug No Description

Line 157: g_uplift_suffix hr_entry.varchar2_table;

153: g_reject_count number;
154: g_E_line_count number;
155: g_P_line_count number;
156: g_T_line_count number;
157: g_uplift_suffix hr_entry.varchar2_table;
158: g_uplift_value hr_entry.number_table;
159: g_validate_only varchar2(1); /*Added soy 08-09*/
160: g_cpe_flag varchar2(1); /*Added soy 08-09*/
161:

Line 158: g_uplift_value hr_entry.number_table;

154: g_E_line_count number;
155: g_P_line_count number;
156: g_T_line_count number;
157: g_uplift_suffix hr_entry.varchar2_table;
158: g_uplift_value hr_entry.number_table;
159: g_validate_only varchar2(1); /*Added soy 08-09*/
160: g_cpe_flag varchar2(1); /*Added soy 08-09*/
161:
162: ------------------------------------------------------------

Line 571: p_input_value_id_tbl in out nocopy hr_entry.number_table,

567: -- entry API --
568: ---------------------------------------------------------------------
569: PROCEDURE conv_to_table(p_paye_rec in g_typ_paye_record,
570: p_num_entry_values in out nocopy number,
571: p_input_value_id_tbl in out nocopy hr_entry.number_table,
572: p_entry_value_tbl in out nocopy hr_entry.varchar2_table)
573: IS
574: l_index number := 0;
575: BEGIN

Line 572: p_entry_value_tbl in out nocopy hr_entry.varchar2_table)

568: ---------------------------------------------------------------------
569: PROCEDURE conv_to_table(p_paye_rec in g_typ_paye_record,
570: p_num_entry_values in out nocopy number,
571: p_input_value_id_tbl in out nocopy hr_entry.number_table,
572: p_entry_value_tbl in out nocopy hr_entry.varchar2_table)
573: IS
574: l_index number := 0;
575: BEGIN
576: if p_paye_rec.tax_basis_amended then

Line 614: p_input_value_id_tbl in out nocopy hr_entry.number_table,

610: ---------------------------------------------------------------------
611: PROCEDURE conv_to_table_ni(p_process_type_updated in varchar2 ,
612: p_input_value_id in number ,
613: p_num_entry_values in out nocopy number,
614: p_input_value_id_tbl in out nocopy hr_entry.number_table,
615: p_entry_value_tbl in out nocopy hr_entry.varchar2_table)
616: IS
617: l_index number := 0;
618: BEGIN

Line 615: p_entry_value_tbl in out nocopy hr_entry.varchar2_table)

611: PROCEDURE conv_to_table_ni(p_process_type_updated in varchar2 ,
612: p_input_value_id in number ,
613: p_num_entry_values in out nocopy number,
614: p_input_value_id_tbl in out nocopy hr_entry.number_table,
615: p_entry_value_tbl in out nocopy hr_entry.varchar2_table)
616: IS
617: l_index number := 0;
618: BEGIN
619: l_index := l_index + 1;

Line 1253: l_input_value_id_tbl hr_entry.number_table;

1249: l_process_type varchar2(3);
1250: l_process_type_new_code varchar2(3);
1251: l_process_type_new varchar2(20);
1252: l_process_type_updated boolean;
1253: l_input_value_id_tbl hr_entry.number_table;
1254: l_entry_value_tbl hr_entry.varchar2_table;
1255:
1256: cursor csr_get_ni_process_type is
1257: select element_entry_id,

Line 1254: l_entry_value_tbl hr_entry.varchar2_table;

1250: l_process_type_new_code varchar2(3);
1251: l_process_type_new varchar2(20);
1252: l_process_type_updated boolean;
1253: l_input_value_id_tbl hr_entry.number_table;
1254: l_entry_value_tbl hr_entry.varchar2_table;
1255:
1256: cursor csr_get_ni_process_type is
1257: select element_entry_id,
1258: process_type,

Line 1293: hr_entry_api.update_element_entry (

1289: l_entry_value_tbl) ;
1290:
1291: if g_validate_only = 'N' then /*Added soy 08-09*/
1292: hr_utility.trace(' In Validate And Commit Mode therefore updating');
1293: hr_entry_api.update_element_entry (
1294: p_dt_update_mode => 'UPDATE',
1295: p_session_date => g_effective_date,
1296: p_element_entry_id => l_element_entry_id,
1297: p_num_entry_values => l_num_entry_values,

Line 2019: l_input_value_id_tbl hr_entry.number_table;

2015: IS
2016: l_issue_date date;
2017: l_message_date date;
2018: l_paye_rec g_typ_paye_record;
2019: l_input_value_id_tbl hr_entry.number_table;
2020: l_entry_value_tbl hr_entry.varchar2_table;
2021: l_row_id rowid;
2022: l_num_entry_values number;
2023:

Line 2020: l_entry_value_tbl hr_entry.varchar2_table;

2016: l_issue_date date;
2017: l_message_date date;
2018: l_paye_rec g_typ_paye_record;
2019: l_input_value_id_tbl hr_entry.number_table;
2020: l_entry_value_tbl hr_entry.varchar2_table;
2021: l_row_id rowid;
2022: l_num_entry_values number;
2023:
2024: cursor c1 (c_row_id in rowid) is

Line 2048: hr_entry_api.update_element_entry(

2044: ----------------------------
2045:
2046: if g_validate_only ='N' then /*Added soy 08-09*/
2047: hr_utility.trace(' In Validate And Commit Mode therefore updating.');
2048: hr_entry_api.update_element_entry(
2049: p_dt_update_mode => rtrim(p_paye_rec.dt_update_mode),
2050: p_session_date => p_per_rec.effective_date,
2051: p_element_entry_id => p_paye_rec.element_entry_id,
2052: p_num_entry_values => l_num_entry_values,