136: **
137: ******************************************************************/
138:
139: PROCEDURE update_alien_tax_records(
140: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
141: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
142: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
143: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
144: ,p_process VARCHAR2
137: ******************************************************************/
138:
139: PROCEDURE update_alien_tax_records(
140: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
141: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
142: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
143: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
144: ,p_process VARCHAR2
145: ,p_itemtype VARCHAR2
138:
139: PROCEDURE update_alien_tax_records(
140: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
141: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
142: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
143: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
144: ,p_process VARCHAR2
145: ,p_itemtype VARCHAR2
146: ,p_person_id per_people_f.person_id%TYPE default null
139: PROCEDURE update_alien_tax_records(
140: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
141: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
142: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
143: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
144: ,p_process VARCHAR2
145: ,p_itemtype VARCHAR2
146: ,p_person_id per_people_f.person_id%TYPE default null
147: ,p_effective_date date default null
161: ******************************************************************/
162:
163:
164: PROCEDURE update_tax_records(
165: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
166: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
167: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
168: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
169: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
162:
163:
164: PROCEDURE update_tax_records(
165: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
166: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
167: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
168: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
169: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
170: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
163:
164: PROCEDURE update_tax_records(
165: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
166: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
167: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
168: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
169: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
170: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
171: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
164: PROCEDURE update_tax_records(
165: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
166: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
167: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
168: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
169: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
170: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
171: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
172: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
165: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
166: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
167: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
168: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
169: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
170: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
171: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
172: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
173: ,p_transaction_id hr_api_transactions.transaction_id%type
167: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
168: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
169: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
170: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
171: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
172: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
173: ,p_transaction_id hr_api_transactions.transaction_id%type
174: ,p_person_id VARCHAR2
175: ,p_transaction_type VARCHAR2
168: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
169: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
170: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
171: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
172: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
173: ,p_transaction_id hr_api_transactions.transaction_id%type
174: ,p_person_id VARCHAR2
175: ,p_transaction_type VARCHAR2
176: ,p_source_name VARCHAR2
226: --
227: FUNCTION Fed_State_Filing_Status_Match(
228: p_state_code IN pay_us_states.state_code%TYPE
229: ,p_state_org_filing_status_code IN pay_us_emp_state_tax_rules_f.filing_status_code%TYPE
230: ,p_fed_org_filing_status_code IN pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
231: ,p_fed_org_wa IN pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
232: ,p_state_org_wa IN pay_us_emp_state_tax_rules_f.withholding_allowances%TYPE
233: ,p_fed_exmpt_cnt IN NUMBER
234: ,p_state_empt_cnt IN NUMBER
227: FUNCTION Fed_State_Filing_Status_Match(
228: p_state_code IN pay_us_states.state_code%TYPE
229: ,p_state_org_filing_status_code IN pay_us_emp_state_tax_rules_f.filing_status_code%TYPE
230: ,p_fed_org_filing_status_code IN pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
231: ,p_fed_org_wa IN pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
232: ,p_state_org_wa IN pay_us_emp_state_tax_rules_f.withholding_allowances%TYPE
233: ,p_fed_exmpt_cnt IN NUMBER
234: ,p_state_empt_cnt IN NUMBER
235: ,p_new_filing_status_code IN OUT NOCOPY pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
231: ,p_fed_org_wa IN pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
232: ,p_state_org_wa IN pay_us_emp_state_tax_rules_f.withholding_allowances%TYPE
233: ,p_fed_exmpt_cnt IN NUMBER
234: ,p_state_empt_cnt IN NUMBER
235: ,p_new_filing_status_code IN OUT NOCOPY pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
236: )
237: RETURN BOOLEAN;
238: --
239: --