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;
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:
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' */
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;
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
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
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,
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,
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,
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,
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:
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';
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:
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;
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;
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;
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: