1 PACKAGE pqp_us_ff_functions AUTHID CURRENT_USER AS
2 /* $Header: pqusfffn.pkh 115.15 2002/12/03 00:13:58 sshetty ship $ */
3 ---------------------------------------------------------------------------+
4 -- GET_COL_VAL
5 ---------------------------------------------------------------------------+
6 FUNCTION get_col_val(p_assignment_id IN NUMBER
7 ,p_payroll_action_id IN NUMBER
8 ,p_column_name IN VARCHAR2
9 ,p_income_code IN VARCHAR2)
10 RETURN varchar2;
11 ----------------------------------------------------------------------------+
12 -- STATE_HONORS_TREATY
13 ----------------------------------------------------------------------------+
14 FUNCTION state_honors_treaty (p_payroll_action_id IN NUMBER
15 ,p_ele_iv_jur_code IN VARCHAR2
16 ,p_override_loc_state IN VARCHAR2 )
17 RETURN varchar2;
18 ----------------------------------------------------------------------------+
19 -- ALIEN_TREATY_VALID
20 ----------------------------------------------------------------------------+
21 FUNCTION alien_treaty_valid (p_assignment_id IN NUMBER
22 ,p_payroll_action_id IN NUMBER
23 ,p_income_code IN VARCHAR2 )
24 RETURN varchar2;
25 ----------------------------------------------------------------------------+
26 -- GET_ALIEN_BAL
27 ----------------------------------------------------------------------------+
28 FUNCTION get_alien_bal(p_assignment_id IN NUMBER
29 ,p_effective_date IN DATE
30 ,p_payroll_action_id IN NUMBER DEFAULT NULL
31 ,p_tax_unit_id IN NUMBER DEFAULT NULL
32 ,p_income_code IN VARCHAR2 DEFAULT NULL
33 ,p_balance_name IN VARCHAR2 DEFAULT NULL
34 ,p_dimension_name IN VARCHAR2 DEFAULT NULL
35 ,p_state_code IN VARCHAR2 DEFAULT NULL
36 ,p_fit_wh_bal_flag IN VARCHAR2 DEFAULT 'N')
37
38 RETURN NUMBER;
39 ----------------------------------------------------------------------------+
40 -- FUNCTION IS_WINDSTAR
41 ----------------------------------------------------------------------------+
42 FUNCTION is_windstar(p_person_id IN NUMBER DEFAULT NULL
43 ,p_assignment_id IN NUMBER DEFAULT NULL)
44 --+
45 --+ Function to return a true/false value if the assignment was/is being
46 --+ processed by windstar
47 --+
48 RETURN VARCHAR2;
49
50 ----------------------------------------------------------------------------+
51 -- FUNCTION PQP_IS_WINDSTAR
52 ----------------------------------------------------------------------------+
53 FUNCTION pqp_is_windstar( p_assignment_id IN NUMBER DEFAULT NULL)
54 --+
55 --+ Function to return a true/false value if the assignment was/is being
56 --+ processed by windstar. Function has been added as person_id
57 --+ is not available as a CTX. This calls the function IS_WINDSTAR
58 --+
59 RETURN VARCHAR2;
60 --+
61 ----------------------------------------------------------------------------+
62 -- FUNCTION GET_NONW2_BAL
63 ----------------------------------------------------------------------------+
64 FUNCTION get_nonw2_bal (p_balance_name IN VARCHAR2,
65 p_period IN VARCHAR2,
66 p_assignment_action_id IN NUMBER,
67 p_jurisdiction_code IN VARCHAR2 DEFAULT NULL,
68 p_tax_unit_id IN NUMBER)
69 RETURN NUMBER;
70
71 --+ Function to return a 'Non W2' withheld balances for FIT and SIT
72 --+
73 --+
74
75 ----------------------------------------------------------------------------+
76 -- FUNCTION GET_PREV_CONTRIB
77 ----------------------------------------------------------------------------+
78 FUNCTION get_prev_contrib(p_assignment_id IN NUMBER
79 ,p_payroll_action_id IN NUMBER
80 ,p_income_code IN VARCHAR2 )
81 --+
82 --+ Function to return the previous contribution of the employee for the
83 --+ income code
84 --+
85 RETURN NUMBER;
86 --+
87 ----------------------------------------------------------------------------+
88 -- FUNCTION PQP_PROCESS_EVENTS_EXISTS
89 ----------------------------------------------------------------------------+
90 FUNCTION pqp_process_events_exist(p_assignment_id IN NUMBER
91 ,p_income_code IN VARCHAR2 )
92 --+
93 --+ Function to check whether there are any changes to the alien data that
94 --+ are not analyzed by Windstar
95 --+
96 RETURN VARCHAR2;
97 ----------------------------------------------------------------------------+
98 -- FUNCTION PQP_ALIEN_TAX_ELE_EXIST
99 ----------------------------------------------------------------------------+
100 FUNCTION pqp_alien_tax_ele_exist (p_assignment_id IN NUMBER
101 ,p_effective_date IN DATE)
102 --+
103 --+ Function to check whether the ALIEN_TAXATION element is attached if
104 --+ there are earnings for classification Alien Earnings.
105 --+
106 RETURN VARCHAR2;
107 ----------------------------------------------------------------------------+
108 -- FUNCTION GET_TRR_NONW2_BAL
109 --
110 -- Function to return the GRE level balances, Since we do no store
111 -- GRE level balances, we compute this by adding balances of all the
112 -- assignments for a given GRE. Function written to compute 'Non W2'
113 -- FIT and SIT balances at the 'GRE' level.
114 ----------------------------------------------------------------------------+
115 FUNCTION get_trr_nonw2_bal (p_gre IN NUMBER,
116 p_jd IN VARCHAR2 DEFAULT NULL,
117 p_start_date IN DATE,
118 p_end_date IN DATE,
119 p_bal_name IN VARCHAR2,
120 p_dim IN VARCHAR2)
121 RETURN NUMBER;
122 END pqp_us_ff_functions;