1 PACKAGE pay_wat_udfs AUTHID CURRENT_USER AS
2 /* $Header: pywatudf.pkh 120.0.12000000.1 2007/01/18 03:19:47 appldev noship $*/
3 FUNCTION entry_subpriority ( p_date_earned in date,
4 p_ele_entry_id in number) return number;
5 FUNCTION garn_cat( p_date_earned in date,
6 p_ele_entry_id in number) return varchar2 ;
7
8 FUNCTION FNC_FEE_CALCULATION ( IN_JURISDICTION IN VARCHAR2,
9 IN_GARN_FEE_FEE_RULE IN VARCHAR2,
10 IN_GARN_FEE_FEE_AMOUNT IN NUMBER,
11 IN_GARN_FEE_PCT_CURRENT IN NUMBER,
12 IN_TOTAL_OWED IN NUMBER,
13 IN_PRIMARY_AMOUNT_BALANCE IN NUMBER,
14 IN_ADDL_GARN_FEE_AMOUNT IN NUMBER,
15 IN_GARN_FEE_MAX_FEE_AMOUNT IN NUMBER,
16 IN_GARN_FEE_BAL_ASG_GRE_PTD IN NUMBER,
17 IN_GARN_TOTAL_FEES_ASG_GRE_RUN IN NUMBER,
18 IN_DEDN_AMT IN NUMBER,
19 IN_GARN_FEE_BAL_ASG_GRE_MONTH IN NUMBER,
20 IN_ACCRUED_FEES IN NUMBER) RETURN NUMBER ;
21
22 FUNCTION get_garn_limit_max_duration (p_element_type_id NUMBER,
23 p_element_entry_id NUMBER,
24 p_effective_date DATE,
25 p_jursd_code VARCHAR2)
26 /******************************************************************************
27 Function : get_garn_limit_max_duration
28 Description : This function is used to return the maximum duration, in
29 number of days, for which a particular garnishment can be
30 taken in a particular state. The duration is obtained with
31 respect to the 'Date Served' of the garnishment. If 'Date Served'
32 is null, then the mimimum effective_start_date for the
33 element_entry is used.
34 Parameters : p_element_type_id (element_type_id context)
35 p_element_entry_id (original_entry_id context)
36 p_effective_date (date_earned context)
37 p_jursd_code (jurisdiction_code context)
38 ******************************************************************************/
39 RETURN NUMBER;
40
41 END pay_wat_udfs;