DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_ADJ_PKG dependencies on HR_ENTRY

Line 183: g_dummy_varchar_tbl hr_entry.varchar2_table;

179: g_sui_jd VARCHAR2(11) := '00-000-0000';
180: g_sui_state_code VARCHAR2(2);
181: g_county_jd VARCHAR2(11) := '00-000-0000';
182: g_city_jd VARCHAR2(11) := '00-000-0000';
183: g_dummy_varchar_tbl hr_entry.varchar2_table;
184: g_dummy_number_tbl hr_entry.number_table;
185: g_tax_type_tbl hr_entry.varchar2_table;
186: g_tax_adj_pactid_tbl hr_entry.number_table;
187: g_pact_cntr NUMBER := 1;

Line 184: g_dummy_number_tbl hr_entry.number_table;

180: g_sui_state_code VARCHAR2(2);
181: g_county_jd VARCHAR2(11) := '00-000-0000';
182: g_city_jd VARCHAR2(11) := '00-000-0000';
183: g_dummy_varchar_tbl hr_entry.varchar2_table;
184: g_dummy_number_tbl hr_entry.number_table;
185: g_tax_type_tbl hr_entry.varchar2_table;
186: g_tax_adj_pactid_tbl hr_entry.number_table;
187: g_pact_cntr NUMBER := 1;
188:

Line 185: g_tax_type_tbl hr_entry.varchar2_table;

181: g_county_jd VARCHAR2(11) := '00-000-0000';
182: g_city_jd VARCHAR2(11) := '00-000-0000';
183: g_dummy_varchar_tbl hr_entry.varchar2_table;
184: g_dummy_number_tbl hr_entry.number_table;
185: g_tax_type_tbl hr_entry.varchar2_table;
186: g_tax_adj_pactid_tbl hr_entry.number_table;
187: g_pact_cntr NUMBER := 1;
188:
189: /* federal level 'balances' */

Line 186: g_tax_adj_pactid_tbl hr_entry.number_table;

182: g_city_jd VARCHAR2(11) := '00-000-0000';
183: g_dummy_varchar_tbl hr_entry.varchar2_table;
184: g_dummy_number_tbl hr_entry.number_table;
185: g_tax_type_tbl hr_entry.varchar2_table;
186: g_tax_adj_pactid_tbl hr_entry.number_table;
187: g_pact_cntr NUMBER := 1;
188:
189: /* federal level 'balances' */
190: g_medicare_ee_taxable NUMBER := 0;

Line 221: p_entry_value_tbl IN OUT nocopy hr_entry.varchar2_table,

217: p_assignment_id IN NUMBER,
218: p_element_link_id IN NUMBER,
219: p_consolidation_set_id IN NUMBER,
220: p_num_entry_values IN OUT nocopy NUMBER,
221: p_entry_value_tbl IN OUT nocopy hr_entry.varchar2_table,
222: p_input_value_id_tbl IN OUT nocopy hr_entry.number_table,
223: p_original_entry_id IN NUMBER,
224: p_payroll_action_id IN OUT nocopy NUMBER,
225: p_cost IN VARCHAR2

Line 222: p_input_value_id_tbl IN OUT nocopy hr_entry.number_table,

218: p_element_link_id IN NUMBER,
219: p_consolidation_set_id IN NUMBER,
220: p_num_entry_values IN OUT nocopy NUMBER,
221: p_entry_value_tbl IN OUT nocopy hr_entry.varchar2_table,
222: p_input_value_id_tbl IN OUT nocopy hr_entry.number_table,
223: p_original_entry_id IN NUMBER,
224: p_payroll_action_id IN OUT nocopy NUMBER,
225: p_cost IN VARCHAR2
226: ) IS

Line 244: hr_entry_api.insert_element_entry(

240: -- set up adjustment date
241: l_adjustment_date := p_adjustmnt_date;
242:
243: -- create balance adjustment element entry
244: hr_entry_api.insert_element_entry(
245: p_effective_start_date => l_adjustment_date,
246: p_effective_end_date => l_dummy_date,
247: p_element_entry_id => l_element_entry_id,
248: p_assignment_id => p_assignment_id,

Line 309: p_iv_tbl IN OUT nocopy hr_entry.number_table,

305:
306: PROCEDURE process_input(
307: p_element_type IN VARCHAR2,
308: p_element_type_id NUMBER,
309: p_iv_tbl IN OUT nocopy hr_entry.number_table,
310: p_iv_names_tbl IN OUT nocopy hr_entry.varchar2_table,
311: p_ev_tbl IN OUT nocopy hr_entry.varchar2_table,
312: p_bg_id NUMBER,
313: p_adj_date DATE,

Line 310: p_iv_names_tbl IN OUT nocopy hr_entry.varchar2_table,

306: PROCEDURE process_input(
307: p_element_type IN VARCHAR2,
308: p_element_type_id NUMBER,
309: p_iv_tbl IN OUT nocopy hr_entry.number_table,
310: p_iv_names_tbl IN OUT nocopy hr_entry.varchar2_table,
311: p_ev_tbl IN OUT nocopy hr_entry.varchar2_table,
312: p_bg_id NUMBER,
313: p_adj_date DATE,
314: p_input_name VARCHAR2,

Line 311: p_ev_tbl IN OUT nocopy hr_entry.varchar2_table,

307: p_element_type IN VARCHAR2,
308: p_element_type_id NUMBER,
309: p_iv_tbl IN OUT nocopy hr_entry.number_table,
310: p_iv_names_tbl IN OUT nocopy hr_entry.varchar2_table,
311: p_ev_tbl IN OUT nocopy hr_entry.varchar2_table,
312: p_bg_id NUMBER,
313: p_adj_date DATE,
314: p_input_name VARCHAR2,
315: p_entry_value VARCHAR2,

Line 645: p_iv_tbl IN Hr_Entry.number_table,

641:
642: PROCEDURE process_limits(
643: p_element_type IN VARCHAR2,
644: p_earn_amount IN NUMBER,
645: p_iv_tbl IN Hr_Entry.number_table,
646: p_iv_names_tbl IN Hr_Entry.varchar2_table,
647: p_ev_tbl IN OUT nocopy Hr_Entry.varchar2_table,
648: p_num_ev IN NUMBER) IS
649:

Line 646: p_iv_names_tbl IN Hr_Entry.varchar2_table,

642: PROCEDURE process_limits(
643: p_element_type IN VARCHAR2,
644: p_earn_amount IN NUMBER,
645: p_iv_tbl IN Hr_Entry.number_table,
646: p_iv_names_tbl IN Hr_Entry.varchar2_table,
647: p_ev_tbl IN OUT nocopy Hr_Entry.varchar2_table,
648: p_num_ev IN NUMBER) IS
649:
650: c_proc VARCHAR2(100) := 'process_limits';

Line 647: p_ev_tbl IN OUT nocopy Hr_Entry.varchar2_table,

643: p_element_type IN VARCHAR2,
644: p_earn_amount IN NUMBER,
645: p_iv_tbl IN Hr_Entry.number_table,
646: p_iv_names_tbl IN Hr_Entry.varchar2_table,
647: p_ev_tbl IN OUT nocopy Hr_Entry.varchar2_table,
648: p_num_ev IN NUMBER) IS
649:
650: c_proc VARCHAR2(100) := 'process_limits';
651:

Line 866: l_iv_tbl hr_entry.number_table;

862: and i.lookup_type = hr.lookup_type (+)
863: and i.name NOT IN ('Pay Value')
864: ;
865:
866: l_iv_tbl hr_entry.number_table;
867: l_iv_names_tbl hr_entry.varchar2_table;
868: l_ev_tbl hr_entry.varchar2_table;
869: l_num_ev NUMBER;
870: l_element csr_element%ROWTYPE;

Line 867: l_iv_names_tbl hr_entry.varchar2_table;

863: and i.name NOT IN ('Pay Value')
864: ;
865:
866: l_iv_tbl hr_entry.number_table;
867: l_iv_names_tbl hr_entry.varchar2_table;
868: l_ev_tbl hr_entry.varchar2_table;
869: l_num_ev NUMBER;
870: l_element csr_element%ROWTYPE;
871: l_ele_link_id NUMBER;

Line 868: l_ev_tbl hr_entry.varchar2_table;

864: ;
865:
866: l_iv_tbl hr_entry.number_table;
867: l_iv_names_tbl hr_entry.varchar2_table;
868: l_ev_tbl hr_entry.varchar2_table;
869: l_num_ev NUMBER;
870: l_element csr_element%ROWTYPE;
871: l_ele_link_id NUMBER;
872: l_counter NUMBER;

Line 891: l_ele_link_id := hr_entry_api.get_link(

887: Hr_Utility.Raise_Error;
888: END IF;
889:
890: Hr_Utility.Set_Location(c_proc, 30);
891: l_ele_link_id := hr_entry_api.get_link(
892: p_assignment_id => p_assignment_id,
893: p_element_type_id => l_element.element_type_id,
894: p_session_date => p_adjustment_date);
895: