DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_ADJ_API dependencies on HR_ENTRY

Line 271: g_dummy_varchar_tbl hr_entry.varchar2_table;

267: g_sui_state_code VARCHAR2(2);
268: g_county_jd VARCHAR2(11) := '00-000-0000';
269: g_city_jd VARCHAR2(11) := '00-000-0000';
270: g_sch_dist_jur VARCHAR2(10) := '00-00000';
271: g_dummy_varchar_tbl hr_entry.varchar2_table;
272: g_dummy_number_tbl hr_entry.number_table;
273:
274: /* federal level 'balances' */
275: g_medicare_ee_taxable NUMBER := 0;

Line 272: g_dummy_number_tbl hr_entry.number_table;

268: g_county_jd VARCHAR2(11) := '00-000-0000';
269: g_city_jd VARCHAR2(11) := '00-000-0000';
270: g_sch_dist_jur VARCHAR2(10) := '00-00000';
271: g_dummy_varchar_tbl hr_entry.varchar2_table;
272: g_dummy_number_tbl hr_entry.number_table;
273:
274: /* federal level 'balances' */
275: g_medicare_ee_taxable NUMBER := 0;
276: g_medicare_er_taxable NUMBER := 0;

Line 322: p_iv_tbl IN OUT NOCOPY hr_entry.number_table,

318:
319: PROCEDURE process_input(
320: p_element_type IN VARCHAR2,
321: p_element_type_id IN NUMBER,
322: p_iv_tbl IN OUT NOCOPY hr_entry.number_table,
323: p_iv_names_tbl IN OUT NOCOPY hr_entry.varchar2_table,
324: p_ev_tbl IN OUT NOCOPY hr_entry.varchar2_table,
325: p_bg_id IN NUMBER,
326: p_adj_date IN DATE,

Line 323: p_iv_names_tbl IN OUT NOCOPY hr_entry.varchar2_table,

319: PROCEDURE process_input(
320: p_element_type IN VARCHAR2,
321: p_element_type_id IN NUMBER,
322: p_iv_tbl IN OUT NOCOPY hr_entry.number_table,
323: p_iv_names_tbl IN OUT NOCOPY hr_entry.varchar2_table,
324: p_ev_tbl IN OUT NOCOPY hr_entry.varchar2_table,
325: p_bg_id IN NUMBER,
326: p_adj_date IN DATE,
327: p_input_name IN VARCHAR2,

Line 324: p_ev_tbl IN OUT NOCOPY hr_entry.varchar2_table,

320: p_element_type IN VARCHAR2,
321: p_element_type_id IN NUMBER,
322: p_iv_tbl IN OUT NOCOPY hr_entry.number_table,
323: p_iv_names_tbl IN OUT NOCOPY hr_entry.varchar2_table,
324: p_ev_tbl IN OUT NOCOPY hr_entry.varchar2_table,
325: p_bg_id IN NUMBER,
326: p_adj_date IN DATE,
327: p_input_name IN VARCHAR2,
328: p_entry_value IN VARCHAR2,

Line 979: p_iv_tbl IN Hr_Entry.number_table,

975:
976: PROCEDURE process_limits(
977: p_element_type IN VARCHAR2,
978: p_earn_amount IN NUMBER,
979: p_iv_tbl IN Hr_Entry.number_table,
980: p_iv_names_tbl IN Hr_Entry.varchar2_table,
981: p_ev_tbl IN OUT NOCOPY Hr_Entry.varchar2_table,
982: p_num_ev IN NUMBER,
983: p_assignment_id IN NUMBER,

Line 980: p_iv_names_tbl IN Hr_Entry.varchar2_table,

976: PROCEDURE process_limits(
977: p_element_type IN VARCHAR2,
978: p_earn_amount IN NUMBER,
979: p_iv_tbl IN Hr_Entry.number_table,
980: p_iv_names_tbl IN Hr_Entry.varchar2_table,
981: p_ev_tbl IN OUT NOCOPY Hr_Entry.varchar2_table,
982: p_num_ev IN NUMBER,
983: p_assignment_id IN NUMBER,
984: p_jurisdiction IN VARCHAR2,

Line 981: p_ev_tbl IN OUT NOCOPY Hr_Entry.varchar2_table,

977: p_element_type IN VARCHAR2,
978: p_earn_amount IN NUMBER,
979: p_iv_tbl IN Hr_Entry.number_table,
980: p_iv_names_tbl IN Hr_Entry.varchar2_table,
981: p_ev_tbl IN OUT NOCOPY Hr_Entry.varchar2_table,
982: p_num_ev IN NUMBER,
983: p_assignment_id IN NUMBER,
984: p_jurisdiction IN VARCHAR2,
985: p_tax_unit_id IN VARCHAR2,

Line 1451: l_iv_tbl hr_entry.number_table;

1447: AND i.lookup_type = hr.lookup_type (+)
1448: AND i.name NOT IN ('Pay Value')
1449: ;
1450:
1451: l_iv_tbl hr_entry.number_table;
1452: l_iv_names_tbl hr_entry.varchar2_table;
1453: l_ev_tbl hr_entry.varchar2_table;
1454: l_num_ev NUMBER;
1455: l_element csr_element%ROWTYPE;

Line 1452: l_iv_names_tbl hr_entry.varchar2_table;

1448: AND i.name NOT IN ('Pay Value')
1449: ;
1450:
1451: l_iv_tbl hr_entry.number_table;
1452: l_iv_names_tbl hr_entry.varchar2_table;
1453: l_ev_tbl hr_entry.varchar2_table;
1454: l_num_ev NUMBER;
1455: l_element csr_element%ROWTYPE;
1456: l_ele_link_id NUMBER;

Line 1453: l_ev_tbl hr_entry.varchar2_table;

1449: ;
1450:
1451: l_iv_tbl hr_entry.number_table;
1452: l_iv_names_tbl hr_entry.varchar2_table;
1453: l_ev_tbl hr_entry.varchar2_table;
1454: l_num_ev NUMBER;
1455: l_element csr_element%ROWTYPE;
1456: l_ele_link_id NUMBER;
1457: l_counter NUMBER;

Line 1486: l_ele_link_id := hr_entry_api.get_link(

1482: hr_utility.raise_error;
1483: END IF;
1484:
1485: hr_utility.set_location(c_proc, 30);
1486: l_ele_link_id := hr_entry_api.get_link(
1487: p_assignment_id => p_assignment_id,
1488: p_element_type_id => l_element.element_type_id,
1489: p_session_date => p_adjustment_date);
1490:

Line 1979: l_ele_link_id := hr_entry_api.get_link(

1975: hr_utility.raise_error;
1976: END;
1977:
1978: /* Get Element Link ID */
1979: l_ele_link_id := hr_entry_api.get_link(
1980: p_assignment_id => p_assignment_id,
1981: p_element_type_id => l_element_type_id,
1982: p_session_date => p_adjustment_date);
1983: