1 PACKAGE pay_ca_balance_pkg AUTHID CURRENT_USER AS
2 /* $Header: pycabals.pkh 115.13 2002/10/21 23:54:47 tclewis ship $ */
3 /* +======================================================================+
4 | Copyright (c) 1997 Oracle Corporation |
5 | Redwood Shores, California, USA |
6 | All rights reserved. |
7 +======================================================================+
8 Package Header Name : pay_ca_balance_pkg
9 Package File Name : pycabals.pkh
10 Description : This package declares functions which are
11 call_ca_balance_get_value
12
13 Change List:
14 ------------
15
16 Name Date Version Bug Text
17 -------------- ---------- ------- ------- ------------------------------
18 RThirlby 23-0ct-98 110.0 Initial Version
19 RThirlby 17-Nov-98 110.1 Added jurisdiction_code
20 and removed p_tax_unit.
21 RThirlby 18-Mar-99 110.2 Changed default for
22 p_business_group to 0, so that
23 session variable doesn't have to
24 be set by
25 JARTHURT 24-NOV-99 110.3 Added get_current balance function
26 jgoswami 06-DEC-1999 110.4 Overloading of
27 call_ca_balance_get_value function
28 with parameter p_source_id
29 JARTHURT 26-JAN-99 110.5 Added get_current balance function
30 RThirlby 11-FEB-2000 115.6 Added payments_balance_required
31 function. This is copied from
32 pyustxbv.pkb.
33 RThirlby 05-JUN-2000 115.7 Added turn_off_dimension function
34 and turn_off_report_dimension
35 procedure. To help SOE view
36 performance.
37 mmukherj 17-JAN-2002 115.8 Changed the default value for
38 p_business_group_id to NULL.
39 Otherwise the pacakge body
40 does not get compiled in 9i db.
41 MMUKHERJ 25-JAN-01 115.9 dbdrv command added
42 TCLEWIS 12-sep-2002 115.10 Per Ankur removed pragma to
43 call_ca_balance_get_value.
44 TCLEWIS 21-OCT-2002 115.11 removed pragma on get_current_balance
45 ========================================================================
46 */
47 /*
48 FUNCTION call_ca_balance_get_value (p_balance_name IN VARCHAR2
49 ,p_time_period IN VARCHAR2
50 ,p_assignment_action_id IN NUMBER DEFAULT NULL
51 ,p_assignment_id IN NUMBER DEFAULT NULL
52 ,p_virtual_date IN DATE DEFAULT NULL
53 ,p_report_level IN VARCHAR2 DEFAULT NULL
54 ,p_gre_id IN NUMBER DEFAULT NULL
55 ,p_business_group_id IN NUMBER DEFAULT NULL
56 ,p_jurisdiction_code IN VARCHAR2 DEFAULT NULL)
57 RETURN NUMBER;
58 --PRAGMA RESTRICT_REFERENCES(call_ca_balance_get_value, WNDS);
59 */
60 -----------------------------------------------------------------------------
61 -- FUNCTION call_ca_balance_get_value - Overloaded version using source_id
62 -----------------------------------------------------------------------------
63 FUNCTION call_ca_balance_get_value (p_balance_name IN VARCHAR2
64 ,p_time_period IN VARCHAR2
65 ,p_assignment_action_id IN NUMBER DEFAULT NULL
66 ,p_assignment_id IN NUMBER DEFAULT NULL
67 ,p_virtual_date IN DATE DEFAULT NULL
68 ,p_report_level IN VARCHAR2 DEFAULT NULL
69 ,p_gre_id IN NUMBER DEFAULT NULL
70 ,p_business_group_id IN NUMBER DEFAULT NULL
71 ,p_jurisdiction_code IN VARCHAR2 DEFAULT NULL
72 ,p_source_id IN NUMBER DEFAULT NULL )
73 RETURN NUMBER;
74 --
75 --PRAGMA RESTRICT_REFERENCES(call_ca_balance_get_value, WNDS);
76 -----------------------------------------------------------------------------
77 -- FUNCTION get_current_balance
78 -----------------------------------------------------------------------------
79 FUNCTION get_current_balance (p_defined_balance_id NUMBER
80 ,p_run_action_id NUMBER)
81 RETURN NUMBER;
82 --PRAGMA RESTRICT_REFERENCES(get_current_balance, WNDS);
83 -----------------------------------------------------------------------------
84 -- FUNCTION payments_balance_required
85 -----------------------------------------------------------------------------
86 FUNCTION payments_balance_required(p_assignment_action_id NUMBER)
87 RETURN boolean;
88 PRAGMA RESTRICT_REFERENCES(payments_balance_required, WNDS);
89 -----------------------------------------------------------------------------
90 -- FUNCTION turn_off_dimension
91 -----------------------------------------------------------------------------
92 FUNCTION turn_off_dimension (p_dimension varchar2)
93 RETURN boolean;
94 PRAGMA RESTRICT_REFERENCES(turn_off_dimension, WNDS);
95 -----------------------------------------------------------------------------
96 -- PROCEDURE turn_off_report_dimension
97 -----------------------------------------------------------------------------
98 PROCEDURE turn_off_report_dimension(p_report_name varchar2);
99 -----------------------------------------------------------------------------
100 END pay_ca_balance_pkg;