1 PACKAGE pay_us_sqwl_udf AUTHID CURRENT_USER as
2 /* $Header: pyussqut.pkh 115.6 2003/11/20 20:09:46 tmehra noship $ */
3 /* +======================================================================+
4 REM | Copyright (c) 1997 Oracle Corporation |
5 REM | Redwood Shores, California, USA |
6 REM | All rights reserved. |
7 REM +======================================================================+
8 REM SQL Script File Name : pyussqut.pkh
9 REM Description : Package and procedure to build sql for payroll
10 REM processes.
11 REM Package Name : pay_us_sqwl_udf
12 REM Purpose : Sets up the data to provide SQWL Ulitity
13 REM Processing.
14 REM
15 REM Notes : This data is US specific.
16 REM
17 REM Change List:
18 REM ------------
19 REM
20 REM Name Date Version Bug Text
21 REM ------------ ---------- ------- ------- ------------------------------
22 REM M Doody 16-FEB-2001 115.0 Initial Version
23 REM
24 REM
25 REM tmehra 17-AUG-2001 115.1 Added 'get_gre_wage_plan_code'
26 REM
27 REM tmehra 15-OCT-2001 115.2 Added 'get_asg_wage_plan_code'
28 REM tmehra 07-MAY-2003 115.4 Added new validation for
29 REM california sqwl as a new
30 REM new segment has been introduced
31 REM for the info type.
32 REM tmehra 26-AUG-2003 115.7 2219097 Added two new functions for the
33 REM US W2 enhancements for Govt
34 REM employer.
35 REM - get_employment_code
36 REM - chk_govt_employer
37 REM Added the following function
38 REM for US W2 enhancements for Govt
39 REM employer.
40 REM - get_archived_emp_code
41 REM ========================================================================
42
43 CREATE OR REPLACE PACKAGE pay_us_sqwl_udf as
44 */
45
46 FUNCTION get_qtr_hire_flag(p_emp_per_hire_date DATE, p_transfer_date DATE)
47 RETURN VARCHAR2;
48
49
50 FUNCTION get_gre_wage_plan_code
51 (
52 p_tax_unit_id in number,
53 p_transfer_state in varchar
54 )
55 RETURN VARCHAR2;
56
57
58 FUNCTION get_asg_wage_plan_code
59 (
60 p_assignment_id in number,
61 p_transfer_state in varchar
62 )
63 RETURN VARCHAR2;
64
65
66 PROCEDURE chk_for_default_wp ( p_organization_id number,
67 p_org_information_context varchar2,
68 p_org_information1 varchar2
69 );
70
71
72 FUNCTION chk_govt_employer ( p_tax_unit_id number DEFAULT NULL,
73 p_assignment_action_id number DEFAULT NULL
74 ) RETURN BOOLEAN;
75
76 FUNCTION get_employment_code ( p_medicare_wh number DEFAULT NULL,
77 p_ss_wh number DEFAULT NULL
78 ) RETURN varchar2;
79
80 FUNCTION get_archived_emp_code ( p_assignment_action_id number DEFAULT NULL
81 ) RETURN varchar2;
82
83 END pay_us_sqwl_udf;
84