1 PACKAGE pay_ac_utility AUTHID CURRENT_USER as
2 /* $Header: pyacutil.pkh 120.2 2005/12/01 08:45 sdahiya noship $ */
3
4 /*********************************************************************
5 ** Name : get_defined_balance_id
6 ** Purpose : This function returns the defined_balance_id for a
7 ** given Balance Name and Dimension for Mexico.
8 ** Arguments : IN Parameters
9 ** p_balance_type_id -> Balance Type ID
10 ** p_balance_name -> Balance Name
11 ** p_dimension_name -> Dimension Name or
12 ** database_item_suffix
13 ** p_bus_grp_id -> Business Group ID
14 ** p_legislation_cd -> Legislation Code
15 **
16 ** Notes : The combination of Business Group ID and
17 ** Legislation Code would be 'Not NULL / NULL' or
18 ** 'NULL / Not NULL'.
19 **
20 ** When first character of p_dimension_name is
21 ** underscore, then it is considered as
22 ** database_item_suffix.
23 *********************************************************************/
24
25 FUNCTION get_defined_balance_id (p_balance_type_id IN NUMBER
26 ,p_dimension_name IN VARCHAR2
27 ,p_bus_grp_id IN NUMBER
28 ,p_legislation_cd IN VARCHAR2)
29 RETURN NUMBER;
30
31 FUNCTION get_defined_balance_id (p_balance_name IN VARCHAR2
32 ,p_dimension_name IN VARCHAR2
33 ,p_bus_grp_id IN NUMBER
34 ,p_legislation_cd IN VARCHAR2)
35 RETURN NUMBER;
36
37 /**********************************************************************
38 ** Name : get_balance_name
39 ** Purpose : This function returns translated value of the balance
40 ** name.
41 ** Arguments : IN Parameters
42 ** p_balance_type_id -> Balance Type ID
43 ** Notes :
44 **********************************************************************/
45
46 FUNCTION get_balance_name (p_balance_type_id IN NUMBER)
47 RETURN VARCHAR2;
48
49 /**********************************************************************
50 ** Name : get_bal_reporting_name
51 ** Purpose : This function returns translated value of reporting
52 ** name of the balance.
53 ** Arguments : IN Parameters
54 ** p_balance_type_id -> Balance Type ID
55 ** Notes :
56 **********************************************************************/
57
58 FUNCTION get_bal_reporting_name (p_balance_type_id IN NUMBER)
59 RETURN VARCHAR2;
60
61 /************************************************************************
62 ** Type : PL/SQL Table Structure
63 ** Purpose : Cached following values to get balance name and balance
64 ** reporting name.
65 **
66 ** bal_type_id -> Balance Type ID
67 ** bal_name -> Balance Name (Translated)
68 ** bal_rep_name -> Balance Reporting Name (Translated)
69 ** Notes :
70 ************************************************************************/
71
72 TYPE balance IS RECORD ( bal_type_id number(15),
73 bal_name varchar2(240),
74 bal_rep_name varchar2(240));
75
76 TYPE balance_tbl IS TABLE OF balance INDEX BY BINARY_INTEGER;
77
78 bal_tbl balance_tbl;
79
80 /**********************************************************************
81 ** Name : get_balance_type_id
82 ** Purpose : This function returns balance type ID of given Balance
83 ** Name, Business Group ID and Legislation Code.
84 ** Arguments : IN Parameters
85 ** p_balance_name -> Balance Name
86 ** p_bus_grp_id -> Business Group ID
87 ** p_legislation_cd -> Legislation Code
88 ** Notes :
89 **********************************************************************/
90 FUNCTION get_balance_type_id ( p_balance_name IN VARCHAR2
91 , p_bus_grp_id IN NUMBER
92 , p_legislation_cd IN VARCHAR2)
93 RETURN NUMBER;
94
95 /**********************************************************************
96 ** Name : get_value
97 ** Purpose : This function returns balance value
98 **
99 ** Arguments : IN Parameters
100 ** p_balance_type_id -> Balance Type ID
101 ** p_dimension_name -> Dimension Name or
102 ** database_item_suffix
103 ** p_bus_grp_id -> Business Group ID
104 ** p_legislation_cd -> Legislation Code
105 ** p_asg_act_id -> Assignment Action ID
106 ** p_tax_unit_id -> Tax Unit ID
107 ** p_date_paid -> Date Paid
108 ** Notes :
109 **********************************************************************/
110 FUNCTION get_value (p_balance_type_id IN NUMBER
111 ,p_dimension_name IN VARCHAR2
112 ,p_bus_grp_id IN NUMBER
113 ,p_legislation_cd IN VARCHAR2
114 ,p_asg_act_id IN NUMBER
115 ,p_tax_unit_id IN NUMBER
116 ,p_date_paid IN DATE)
117 RETURN NUMBER;
118
119 FUNCTION get_value (p_balance_name IN VARCHAR2
120 ,p_dimension_name IN VARCHAR2
121 ,p_bus_grp_id IN NUMBER
122 ,p_legislation_cd IN VARCHAR2
123 ,p_asg_act_id IN NUMBER
124 ,p_tax_unit_id IN NUMBER
125 ,p_date_paid IN DATE)
126 RETURN NUMBER;
127
128 /**************************************************************************
129 ** Function : range_person_on
130 ** Arguments: p_report_type
131 ** p_report_format
132 ** p_report_qualifier
133 ** p_report_category
134 ** Returns : Returns true if the range_person performance enhancement is
135 ** enabled for the process.
136 **************************************************************************/
137 FUNCTION range_person_on(p_report_type in varchar2
138 ,p_report_format in varchar2
139 ,p_report_qualifier in varchar2
140 ,p_report_category in varchar2) RETURN BOOLEAN;
141
142 /**************************************************************************
143 ** Function : get_geocode
144 ** Arguments: p_state_abbrev
145 ** p_county_name
146 ** p_city_name
147 ** p_zip_code
148 ** Returns : Returns Vertex geocode. The function will currently return
149 ** 00-000-0000 for Canadian Cities
150 **************************************************************************/
151 FUNCTION get_geocode(p_state_abbrev in VARCHAR2
152 ,p_county_name in VARCHAR2 DEFAULT null
153 ,p_city_name in VARCHAR2 DEFAULT null
154 ,p_zip_code in VARCHAR2 DEFAULT null)
155 RETURN VARCHAR2;
156
157 /****************************************************************************
158 Name : print_lob
159 Description : This procedure prints contents of LOB passed as parameter.
160 *****************************************************************************/
161
162 PROCEDURE print_lob(p_blob BLOB);
163
164
165 end pay_ac_utility;