1 package pay_au_exc as
2 /* $Header: pyauexch.pkh 120.1 2005/12/02 01:38:29 avenkatk noship $ */
3 --
4 -- Change List
5 -- ----------
6 -- DATE Name Vers Bug No Description
7 -- -----------+---------------+--------+--------+--------------------------------------------------+
8 -- 13-Aug-1999 sgoggin 1.0 Created
9 -- 23-Jul-2002 Ragovind 1.1 2123970 Overloaded the Functions asg_ptd_ec, asg_span_ec
10 -- for Handling the Balance Adjustment Enhancement.
11 -- 03-Dec-2002 Ragovind 1.2 2689226 Added NOCOPY for functions pyauexc.asg_ptd_ec,
12 -- pyauexc.asg_span_ec.
13 -- 22-Mar-2004 jkarouza 1.0 3830198 Renamed file to pyauexch.pkh and package to
14 -- PAY_AU_EXC.
15 -- 30-Nov-2005 avenkatk 1.4 4351318 Introduced procedure fbt_ytd_start.
16 -- -----------+---------------+--------+--------+--------------------------------------------------+
17 --
18 -- FUNCTION DECLARATIONS
19
20 FUNCTION next_period (p_payroll_action_id in number, p_given_date in date ) RETURN date ;
21
22 FUNCTION next_month (p_given_date in date ) RETURN date ;
23
24 FUNCTION next_quarter (p_given_date in date) RETURN date ;
25
26 FUNCTION next_year (p_given_date in date) RETURN date ;
27
28 FUNCTION next_fin_quarter (p_beg_of_the_year in date, p_given_date in date ) RETURN date;
29
30 FUNCTION next_fin_year (p_beg_of_the_year in date, p_given_date in date ) RETURN date ;
31
32 FUNCTION next_fbt_quarter (p_given_date in date ) RETURN date ;
33
34 FUNCTION next_fbt_year (p_given_date in date ) RETURN date ;
35
36
37 -------------------------------- asg_ptd_ec ---------------------------------
38 /*
39 * name
40 * asg_ptd_ec - assignment processing period to date expiry check.
41 * description
42 * expiry checking code for the following:
43 * au assignment-level process period to date balance dimension
44 * notes
45 * the associtated dimension is expiry checked at assignment action level
46 */
47 --
48 procedure asg_ptd_ec( p_owner_payroll_action_id in number -- run created balance.
49 , p_user_payroll_action_id in number -- current run.
50 , p_owner_assignment_action_id in number -- assact created balance.
51 , p_user_assignment_action_id in number -- current assact..
52 , p_owner_effective_date in date -- eff date of balance.
53 , p_user_effective_date in date -- eff date of current run.
54 , p_dimension_name in varchar2 -- balance dimension name.
55 , p_expiry_information out NOCOPY number -- dimension expired flag.
56 ) ;
57 --
58 -------------------------------- asg_span_ec -----------------------------------------
59 /*
60 *
61 * name
62 * asg_span_ec - assignment processing span to date expiry check.
63 * description
64 * expiry checking code for the following:
65 * au assignment-level process year to date balance dimension
66 * au assignment-level process fiscal year to date balance dimension
67 * au assignment-level process fiscal quarter to date balance dimension
68 * au assignment-level process FBT year to date balance dimension
69 * au assignment-level process Calendar year to date balance dimension
70 * notes
71 * the associated dimension is expiry checked at assignment action level
72 */
73 --
74 procedure asg_span_ec ( p_owner_payroll_action_id in number -- run created balance.
75 , p_user_payroll_action_id in number -- current run.
76 , p_owner_assignment_action_id in number -- assact created balance.
77 , p_user_assignment_action_id in number -- current assact.
78 , p_owner_effective_date in date -- eff date of balance.
79 , p_user_effective_date in date -- eff date of current run.
80 , p_dimension_name in varchar2 -- balance dimension name.
81 , p_expiry_information out NOCOPY number -- dimension expired flag.
82 ) ;
83 --
84
85 PROCEDURE asg_ptd_ec
86 ( p_owner_payroll_action_id in number -- run created balance.
87 , p_user_payroll_action_id in number -- current run.
88 , p_owner_assignment_action_id in number -- assact created balance.
89 , p_user_assignment_action_id in number -- current assact..
90 , p_owner_effective_date in date -- eff date of balance.
91 , p_user_effective_date in date -- eff date of current run.
92 , p_dimension_name in varchar2 -- balance dimension name.
93 , p_expiry_information out NOCOPY date -- dimension expired flag.
94 ) ;
95 --
96 PROCEDURE asg_span_ec
97 ( p_owner_payroll_action_id in number -- run created balance.
98 , p_user_payroll_action_id in number -- current run.
99 , p_owner_assignment_action_id in number -- assact created balance.
100 , p_user_assignment_action_id in number -- current assact.
101 , p_owner_effective_date in date -- eff date of balance.
102 , p_user_effective_date in date -- eff date of current run.
103 , p_dimension_name in varchar2 -- balance dimension name.
104 , p_expiry_information out NOCOPY date -- dimension expired date.
105 ) ;
106 --
107 /* Bug 4351318 - Introduced procedure for returning Start date for FBT year */
108 PROCEDURE fbt_ytd_start( p_effective_date IN DATE ,
109 p_start_date OUT NOCOPY DATE,
110 p_start_date_code IN VARCHAR2 DEFAULT NULL,
111 p_payroll_id IN NUMBER DEFAULT NULL,
112 p_bus_grp IN NUMBER DEFAULT NULL,
113 p_action_type IN VARCHAR2 DEFAULT NULL,
114 p_asg_action IN NUMBER DEFAULT NULL);
115
116 end pay_au_exc;