[Home] [Help]
PACKAGE: APPS.PY_ZA_ROUTES
Source
1 PACKAGE py_za_routes AUTHID CURRENT_USER AS
2 /* $Header: pyzarout.pkh 120.3 2005/07/04 03:07:01 kapalani noship $ */
3 -----------------------------------------------------------------------------
4 --
5 -- Summed data for the ASSIGNMENT-LEVEL PAYROLL TAX PERIOD balance dimension
6 --
7 FUNCTION ASG_TAX_PTD(p_assignment_action_id NUMBER,
8 p_balance_type_id NUMBER)
9 RETURN NUMBER;
10 PRAGMA RESTRICT_REFERENCES (ASG_TAX_PTD, WNDS, WNPS);
11 -----------------------------------------------------------------------------
12 --
13 -- Summed data for the ASSIGNMENT-LEVEL PAYROLL TAX YEAR balance dimension
14 --
15 FUNCTION ASG_TAX_YTD(p_assignment_action_id NUMBER,
16 p_balance_type_id NUMBER)
17 RETURN NUMBER;
18 PRAGMA RESTRICT_REFERENCES (ASG_TAX_YTD, WNDS, WNPS);
19 -----------------------------------------------------------------------------
20 --
21 -- Summed data for the ASSIGNMENT-LEVEL PAYROLL TAX QUARTER balance dimension
22 --
23 FUNCTION ASG_TAX_QTD(p_assignment_action_id NUMBER,
24 p_balance_type_id NUMBER)
25 RETURN NUMBER;
26 PRAGMA RESTRICT_REFERENCES (ASG_TAX_QTD, WNDS, WNPS);
27 -----------------------------------------------------------------------------
28 --
29 -- Summed data for the ASSIGNMENT-LEVEL PAYROLL TAX MONTH balance dimension
30 --
31 FUNCTION ASG_TAX_MTD(p_assignment_action_id NUMBER,
32 p_balance_type_id NUMBER)
33 RETURN NUMBER;
34 PRAGMA RESTRICT_REFERENCES (ASG_TAX_MTD, WNDS, WNPS);
35 -----------------------------------------------------------------------------
36 -----------------------------------------------------------------------------
37 --
38 -- Summed data for the ASSIGNMENT-LEVEL PAYROLL CALENDAR PERIOD balance dimension
39 --
40 FUNCTION ASG_CAL_PTD(p_assignment_action_id NUMBER,
41 p_balance_type_id NUMBER)
42 RETURN NUMBER;
43 PRAGMA RESTRICT_REFERENCES (ASG_CAL_PTD, WNDS, WNPS);
44 -----------------------------------------------------------------------------
45 --
46 -- Summed data for the ASSIGNMENT-LEVEL PAYROLL CALENDAR YEAR balance dimension
47 --
48 FUNCTION ASG_CAL_YTD(p_assignment_action_id NUMBER,
49 p_balance_type_id NUMBER)
50 RETURN NUMBER;
51 PRAGMA RESTRICT_REFERENCES (ASG_CAL_YTD, WNDS, WNPS);
52 -----------------------------------------------------------------------------
53 --
54 -- Summed data for the ASSIGNMENT-LEVEL PAYROLL CALENDAR MONTH
55 -- balance dimension
56 --
57 FUNCTION ASG_CAL_MTD(p_assignment_action_id NUMBER,
58 p_balance_type_id NUMBER)
59 RETURN NUMBER;
60 PRAGMA RESTRICT_REFERENCES (ASG_CAL_MTD, WNDS, WNPS);
61 -----------------------------------------------------------------------------
62 -----------------------------------------------------------------------------
63 --
64 -- Summed data for the ASSIGNMENT-LEVEL PAYROLL INCEPTION-TO-DATE
65 -- balance dimension
66 --
67 FUNCTION ASG_ITD(p_assignment_action_id NUMBER,
68 p_balance_type_id NUMBER)
69 RETURN NUMBER;
70 PRAGMA RESTRICT_REFERENCES (ASG_ITD, WNDS, WNPS);
71 -----------------------------------------------------------------------------
72 -----------------------------------------------------------------------------
73 --
74 -- Summed data for the ASSIGNMENT-LEVEL PAYROLL RUN balance dimension
75 --
76 FUNCTION ASG_RUN(p_assignment_action_id NUMBER,
77 p_balance_type_id NUMBER)
78 RETURN NUMBER;
79 PRAGMA RESTRICT_REFERENCES (ASG_RUN, WNDS, WNPS);
80 -----------------------------------------------------------------------------
81 -----------------------------------------------------------------------------
82 --
83 -- Summed data for the ASSIGNMENT-LEVEL PAYMENTS balance dimension
84 --
85 FUNCTION PAYMENTS(p_assignment_action_id NUMBER,
86 p_balance_type_id NUMBER)
87 RETURN NUMBER;
88 PRAGMA RESTRICT_REFERENCES (PAYMENTS, WNDS, WNPS);
89 -----------------------------------------------------------------------------
90 --
91 END py_za_routes;