DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_ADJ_API dependencies on HR_ENTRY

Line 182: g_dummy_varchar_tbl hr_entry.varchar2_table;

178: g_sui_state_code VARCHAR2(2);
179: g_county_jd VARCHAR2(11) := '00-000-0000';
180: g_city_jd VARCHAR2(11) := '00-000-0000';
181: g_sch_dist_jur VARCHAR2(10) := '00-00000';
182: g_dummy_varchar_tbl hr_entry.varchar2_table;
183: g_dummy_number_tbl hr_entry.number_table;
184:
185: /* federal level 'balances' */
186: g_medicare_ee_taxable NUMBER := 0;

Line 183: g_dummy_number_tbl hr_entry.number_table;

179: g_county_jd VARCHAR2(11) := '00-000-0000';
180: g_city_jd VARCHAR2(11) := '00-000-0000';
181: g_sch_dist_jur VARCHAR2(10) := '00-00000';
182: g_dummy_varchar_tbl hr_entry.varchar2_table;
183: g_dummy_number_tbl hr_entry.number_table;
184:
185: /* federal level 'balances' */
186: g_medicare_ee_taxable NUMBER := 0;
187: g_medicare_er_taxable NUMBER := 0;

Line 224: p_iv_tbl IN OUT NOCOPY hr_entry.number_table,

220:
221: PROCEDURE process_input(
222: p_element_type IN VARCHAR2,
223: p_element_type_id IN NUMBER,
224: p_iv_tbl IN OUT NOCOPY hr_entry.number_table,
225: p_iv_names_tbl IN OUT NOCOPY hr_entry.varchar2_table,
226: p_ev_tbl IN OUT NOCOPY hr_entry.varchar2_table,
227: p_bg_id IN NUMBER,
228: p_adj_date IN DATE,

Line 225: p_iv_names_tbl IN OUT NOCOPY hr_entry.varchar2_table,

221: PROCEDURE process_input(
222: p_element_type IN VARCHAR2,
223: p_element_type_id IN NUMBER,
224: p_iv_tbl IN OUT NOCOPY hr_entry.number_table,
225: p_iv_names_tbl IN OUT NOCOPY hr_entry.varchar2_table,
226: p_ev_tbl IN OUT NOCOPY hr_entry.varchar2_table,
227: p_bg_id IN NUMBER,
228: p_adj_date IN DATE,
229: p_input_name IN VARCHAR2,

Line 226: p_ev_tbl IN OUT NOCOPY hr_entry.varchar2_table,

222: p_element_type IN VARCHAR2,
223: p_element_type_id IN NUMBER,
224: p_iv_tbl IN OUT NOCOPY hr_entry.number_table,
225: p_iv_names_tbl IN OUT NOCOPY hr_entry.varchar2_table,
226: p_ev_tbl IN OUT NOCOPY hr_entry.varchar2_table,
227: p_bg_id IN NUMBER,
228: p_adj_date IN DATE,
229: p_input_name IN VARCHAR2,
230: p_entry_value IN VARCHAR2,

Line 854: p_iv_tbl IN Hr_Entry.number_table,

850:
851: PROCEDURE process_limits(
852: p_element_type IN VARCHAR2,
853: p_earn_amount IN NUMBER,
854: p_iv_tbl IN Hr_Entry.number_table,
855: p_iv_names_tbl IN Hr_Entry.varchar2_table,
856: p_ev_tbl IN OUT NOCOPY Hr_Entry.varchar2_table,
857: p_num_ev IN NUMBER,
858: p_assignment_id IN NUMBER,

Line 855: p_iv_names_tbl IN Hr_Entry.varchar2_table,

851: PROCEDURE process_limits(
852: p_element_type IN VARCHAR2,
853: p_earn_amount IN NUMBER,
854: p_iv_tbl IN Hr_Entry.number_table,
855: p_iv_names_tbl IN Hr_Entry.varchar2_table,
856: p_ev_tbl IN OUT NOCOPY Hr_Entry.varchar2_table,
857: p_num_ev IN NUMBER,
858: p_assignment_id IN NUMBER,
859: p_jurisdiction IN VARCHAR2,

Line 856: p_ev_tbl IN OUT NOCOPY Hr_Entry.varchar2_table,

852: p_element_type IN VARCHAR2,
853: p_earn_amount IN NUMBER,
854: p_iv_tbl IN Hr_Entry.number_table,
855: p_iv_names_tbl IN Hr_Entry.varchar2_table,
856: p_ev_tbl IN OUT NOCOPY Hr_Entry.varchar2_table,
857: p_num_ev IN NUMBER,
858: p_assignment_id IN NUMBER,
859: p_jurisdiction IN VARCHAR2,
860: p_tax_unit_id IN VARCHAR2,

Line 1302: l_iv_tbl hr_entry.number_table;

1298: AND i.lookup_type = hr.lookup_type (+)
1299: AND i.name NOT IN ('Pay Value')
1300: ;
1301:
1302: l_iv_tbl hr_entry.number_table;
1303: l_iv_names_tbl hr_entry.varchar2_table;
1304: l_ev_tbl hr_entry.varchar2_table;
1305: l_num_ev NUMBER;
1306: l_element csr_element%ROWTYPE;

Line 1303: l_iv_names_tbl hr_entry.varchar2_table;

1299: AND i.name NOT IN ('Pay Value')
1300: ;
1301:
1302: l_iv_tbl hr_entry.number_table;
1303: l_iv_names_tbl hr_entry.varchar2_table;
1304: l_ev_tbl hr_entry.varchar2_table;
1305: l_num_ev NUMBER;
1306: l_element csr_element%ROWTYPE;
1307: l_ele_link_id NUMBER;

Line 1304: l_ev_tbl hr_entry.varchar2_table;

1300: ;
1301:
1302: l_iv_tbl hr_entry.number_table;
1303: l_iv_names_tbl hr_entry.varchar2_table;
1304: l_ev_tbl hr_entry.varchar2_table;
1305: l_num_ev NUMBER;
1306: l_element csr_element%ROWTYPE;
1307: l_ele_link_id NUMBER;
1308: l_counter NUMBER;

Line 1328: l_ele_link_id := hr_entry_api.get_link(

1324: hr_utility.raise_error;
1325: END IF;
1326:
1327: hr_utility.set_location(c_proc, 30);
1328: l_ele_link_id := hr_entry_api.get_link(
1329: p_assignment_id => p_assignment_id,
1330: p_element_type_id => l_element.element_type_id,
1331: p_session_date => p_adjustment_date);
1332: