1 package pyfrexc AUTHID CURRENT_USER as
2 /* $Header: pyfrexc.pkh 115.1 2002/11/25 15:53:28 asnell noship $ */
3 /* Copyright (c) Oracle Corporation 1994. All rights reserved. */
4 /*
5 PRODUCT
6 Oracle*Payroll
7 NAME
8 pyfrexc.pkh - PaYroll Test FR legislation EXpiry Checking code.
9 DESCRIPTION
10 Contains the expiry checking code for dimensions defined in
11 script pyfrbdim.sql.
12 PUBLIC FUNCTIONS
13 <none>
14 PRIVATE FUNCTIONS
15 <none>
16 NOTES
17 <none>
18 MODIFIED (DD/MM/YY)
19 asnell 22/06/00 - first created.
20 asnell 25/11/02 - added nocopy to out parms
21 */
22 /*------------------------------ ASG_RUN_EC ----------------------------*/
23 /*
24 NAME
25 ASG_RUN_EC - Assignment Run to Date expiry check.
26 DESCRIPTION
27 Expiry checking code for the following:
28 FR Assignment-level Run To Date Balance Dimension
29 NOTES
30 The associtated dimension is expiry checked at payroll action level
31 */
32 procedure ASG_RUN_EC
33 (
34 p_owner_payroll_action_id in number, -- run created balance.
35 p_user_payroll_action_id in number, -- current run.
36 p_owner_assignment_action_id in number, -- assact created balance.
37 p_user_assignment_action_id in number, -- current assact..
38 p_owner_effective_date in date, -- eff date of balance.
39 p_user_effective_date in date, -- eff date of current run.
40 p_dimension_name in varchar2, -- balance dimension name.
41 p_expiry_information out nocopy number -- dimension expired flag.
42 ) ;
43
44 /*------------------------------ ASG_PTD_EC ----------------------------*/
45 /*
46 NAME
47 ASG_PTD_EC - Assignment Processing Period to Date expiry check.
48 DESCRIPTION
49 Expiry checking code for the following:
50 FR Assignment-level Process Period To Date Balance Dimension
51 NOTES
52 The associtated dimension is expiry checked at assignment action level
53 */
54 procedure ASG_PTD_EC
55 (
56 p_owner_payroll_action_id in number, -- run created balance.
57 p_user_payroll_action_id in number, -- current run.
58 p_owner_assignment_action_id in number, -- assact created balance.
59 p_user_assignment_action_id in number, -- current assact..
60 p_owner_effective_date in date, -- eff date of balance.
61 p_user_effective_date in date, -- eff date of current run.
62 p_dimension_name in varchar2, -- balance dimension name.
63 p_expiry_information out nocopy number -- dimension expired flag.
64 ) ;
65
66 /*------------------------------ ASG_PROC_YTD_EC ----------------------------*/
67 /*
68 NAME
69 ASG_PROC_YTD_EC - Assignment Processing Year to Date expiry check.
70 DESCRIPTION
71 Expiry checking code for the following:
72 FR Assignment-level Process Year To Date Balance Dimension
73 NOTES
74 The associated dimension is expiry checked at assignment action level
75 */
76 procedure ASG_PROC_YTD_EC
77 (
78 p_owner_payroll_action_id in number, -- run created balance.
79 p_user_payroll_action_id in number, -- current run.
80 p_owner_assignment_action_id in number, -- assact created balance.
81 p_user_assignment_action_id in number, -- current assact..
82 p_owner_effective_date in date, -- eff date of balance.
83 p_user_effective_date in date, -- eff date of current run.
84 p_dimension_name in varchar2, -- balance dimension name.
85 p_expiry_information out nocopy number -- dimension expired flag.
86 ) ;
87
88 /*------------------------------ feed_month ---------------------------------*/
89 /*
90 NAME
91 feed_month - Feed only during the month specified
92 DESCRIPTION
93 Feed checking code for the following:
94 FR ASG Month
95 NOTES
96 <none>
97 */
98 procedure feed_month
99 (
100 p_payroll_action_id in number,
101 p_assignment_action_id in number,
102 p_assignment_id in number,
103 p_effective_date in date,
104 p_dimension_name in varchar2,
105 p_balance_contexts in varchar2,
106 p_feed_flag in out nocopy number
107 ) ;
108
109 end pyfrexc;