118: ** Public
119: **
120: ******************************************************************/
121:
122: FUNCTION check_update_status(p_person_id IN per_people_f.person_id%TYPE)
123: RETURN VARCHAR2;
124: /******************************************************************
125: **
126: ** Description:
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
148: ,p_source_name VARCHAR2 default null
149: );
150: /******************************************************************
207: PROCEDURE update_w4_info(
208: p_validate in boolean default false ,
209: p_transaction_step_id in number);
210:
211: FUNCTION GET_STATE_LIST(p_person_id IN per_people_f.person_id%TYPE,
212: p_primary_flag IN varchar2 )
213: RETURN VARCHAR2;
214:
215: FUNCTION GET_ORG_CONTEXT(p_person_id IN per_people_f.person_id%TYPE,
211: FUNCTION GET_STATE_LIST(p_person_id IN per_people_f.person_id%TYPE,
212: p_primary_flag IN varchar2 )
213: RETURN VARCHAR2;
214:
215: FUNCTION GET_ORG_CONTEXT(p_person_id IN per_people_f.person_id%TYPE,
216: p_context hr_organization_information.org_information_context%TYPE,
217: p_level IN VARCHAR2)
218: RETURN VARCHAR2;
219: