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 66: intialized to 'N' before calling hr_entry_api

62: csr_fetch_asg_natid -- pass Ni ,Assignment always Null
63: csr_fetch_asg_other -- Pass Both
64: Both Null Errors
65: 11-MAY-2009 jvaradra 115.106 8485686 Variable pqp_gb_ad_ee.g_global_paye_validation is
66: intialized to 'N' before calling hr_entry_api
67: and reset to 'Y' at the end to ensure row handler validations
68: are not fired when p6/p9/SOY process are submitted.
69: 21-MAY-2009 rlingama 115.107 8497477 Added Employer's PAYE Reference on the output.
70: Earlier the report was sorted by person full name.

Line 219: g_uplift_suffix hr_entry.varchar2_table;

215: g_reject_count number;
216: g_E_line_count number;
217: g_P_line_count number;
218: g_T_line_count number;
219: g_uplift_suffix hr_entry.varchar2_table;
220: g_uplift_value hr_entry.number_table;
221: g_validate_only varchar2(1); /*Added soy 08-09*/
222: g_cpe_flag varchar2(1); /*Added soy 08-09*/
223: g_p_print_tax_ref varchar2(20) := '~'; -- Bug#8497477

Line 220: g_uplift_value hr_entry.number_table;

216: g_E_line_count number;
217: g_P_line_count number;
218: g_T_line_count number;
219: g_uplift_suffix hr_entry.varchar2_table;
220: g_uplift_value hr_entry.number_table;
221: g_validate_only varchar2(1); /*Added soy 08-09*/
222: g_cpe_flag varchar2(1); /*Added soy 08-09*/
223: g_p_print_tax_ref varchar2(20) := '~'; -- Bug#8497477
224: g_e_print_tax_ref varchar2(20) := '~'; -- Bug#8497477

Line 650: p_input_value_id_tbl in out nocopy hr_entry.number_table,

646: -- entry API --
647: ---------------------------------------------------------------------
648: PROCEDURE conv_to_table(p_paye_rec in g_typ_paye_record,
649: p_num_entry_values in out nocopy number,
650: p_input_value_id_tbl in out nocopy hr_entry.number_table,
651: p_entry_value_tbl in out nocopy hr_entry.varchar2_table)
652: IS
653: l_index number := 0;
654: BEGIN

Line 651: p_entry_value_tbl in out nocopy hr_entry.varchar2_table)

647: ---------------------------------------------------------------------
648: PROCEDURE conv_to_table(p_paye_rec in g_typ_paye_record,
649: p_num_entry_values in out nocopy number,
650: p_input_value_id_tbl in out nocopy hr_entry.number_table,
651: p_entry_value_tbl in out nocopy hr_entry.varchar2_table)
652: IS
653: l_index number := 0;
654: BEGIN
655: if p_paye_rec.tax_basis_amended then

Line 700: p_input_value_id_tbl in out nocopy hr_entry.number_table,

696: ---------------------------------------------------------------------
697: PROCEDURE conv_to_table_ni(p_process_type_updated in varchar2 ,
698: p_input_value_id in number ,
699: p_num_entry_values in out nocopy number,
700: p_input_value_id_tbl in out nocopy hr_entry.number_table,
701: p_entry_value_tbl in out nocopy hr_entry.varchar2_table)
702: IS
703: l_index number := 0;
704: BEGIN

Line 701: p_entry_value_tbl in out nocopy hr_entry.varchar2_table)

697: PROCEDURE conv_to_table_ni(p_process_type_updated in varchar2 ,
698: p_input_value_id in number ,
699: p_num_entry_values in out nocopy number,
700: p_input_value_id_tbl in out nocopy hr_entry.number_table,
701: p_entry_value_tbl in out nocopy hr_entry.varchar2_table)
702: IS
703: l_index number := 0;
704: BEGIN
705: l_index := l_index + 1;

Line 1400: l_input_value_id_tbl hr_entry.number_table;

1396: l_process_type varchar2(3);
1397: l_process_type_new_code varchar2(3);
1398: l_process_type_new varchar2(20);
1399: l_process_type_updated boolean;
1400: l_input_value_id_tbl hr_entry.number_table;
1401: l_entry_value_tbl hr_entry.varchar2_table;
1402:
1403: cursor csr_get_ni_process_type is
1404: select element_entry_id,

Line 1401: l_entry_value_tbl hr_entry.varchar2_table;

1397: l_process_type_new_code varchar2(3);
1398: l_process_type_new varchar2(20);
1399: l_process_type_updated boolean;
1400: l_input_value_id_tbl hr_entry.number_table;
1401: l_entry_value_tbl hr_entry.varchar2_table;
1402:
1403: cursor csr_get_ni_process_type is
1404: select element_entry_id,
1405: process_type,

Line 1444: hr_entry_api.update_element_entry (

1440:
1441: -- For bug 8485686
1442: pqp_gb_ad_ee.g_global_paye_validation := 'N';
1443:
1444: hr_entry_api.update_element_entry (
1445: p_dt_update_mode => 'UPDATE',
1446: p_session_date => g_effective_date,
1447: p_element_entry_id => l_element_entry_id,
1448: p_num_entry_values => l_num_entry_values,

Line 2395: l_input_value_id_tbl hr_entry.number_table;

2391: IS
2392: l_issue_date date;
2393: l_message_date date;
2394: l_paye_rec g_typ_paye_record;
2395: l_input_value_id_tbl hr_entry.number_table;
2396: l_entry_value_tbl hr_entry.varchar2_table;
2397: l_row_id rowid;
2398: l_num_entry_values number;
2399:

Line 2396: l_entry_value_tbl hr_entry.varchar2_table;

2392: l_issue_date date;
2393: l_message_date date;
2394: l_paye_rec g_typ_paye_record;
2395: l_input_value_id_tbl hr_entry.number_table;
2396: l_entry_value_tbl hr_entry.varchar2_table;
2397: l_row_id rowid;
2398: l_num_entry_values number;
2399:
2400: cursor c1 (c_row_id in rowid) is

Line 2428: hr_entry_api.update_element_entry(

2424:
2425: -- For bug 8485686
2426: pqp_gb_ad_ee.g_global_paye_validation := 'N';
2427:
2428: hr_entry_api.update_element_entry(
2429: p_dt_update_mode => rtrim(p_paye_rec.dt_update_mode),
2430: p_session_date => p_per_rec.effective_date,
2431: p_element_entry_id => p_paye_rec.element_entry_id,
2432: p_num_entry_values => l_num_entry_values,