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;
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;
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,
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,
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,
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,
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,
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,
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;
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;
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;
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:
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: