1 PACKAGE pay_ac_util AUTHID CURRENT_USER AS
2 /* $Header: pyacdisc.pkh 115.1 2004/02/16 16:03 vpandya noship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1993 Oracle Corporation. *
7 * All rights reserved. *
8 * *
9 * This material has been provided pursuant to an agreement *
10 * containing restrictions on its use. The material is also *
11 * protected by copyright law. No part of this material may *
12 * be copied or distributed, transmitted or transcribed, in *
13 * any form or by any means, electronic, mechanical, magnetic, *
14 * manual, or otherwise, or disclosed to third parties without *
15 * the express written permission of Oracle Corporation, *
16 * 500 Oracle Parkway, Redwood City, CA, 94065. *
17 * *
18 ******************************************************************
19
20 Name : pay_ac_util
21
22 Description : This procedure is used by North American
23 packages and tools.
24
25 Change List
26 -----------
27 Date Name Vers Bug No Description
28 ----------- ---------- ----- ------- -----------------------------------
29 17-OCT-2003 Asasthan 115.0 Created.
30 16-FEB-2004 vpandya 115.1 Gross to Net Adhoc, Added functions
31 get_def_bal_for_seeded_bal and
32 get_value.
33 */
34
35
36 FUNCTION get_legis_parameter(p_parameter_name in varchar2,
37 p_parameter_list varchar2) return number;
38
39 FUNCTION get_jurisdiction_name( p_jurisdiction_code in varchar2)
40 return varchar2;
41
42 FUNCTION get_state_abbrev( p_jurisdiction_code in varchar2)
43 return varchar2;
44
45 FUNCTION get_format_value (p_business_group_id in number,
46 p_value in number)
47 return varchar2;
48
49 FUNCTION get_consolidation_set(p_business_group_id in number
50 ,p_consolidation_set_id in number)
51 return varchar2;
52
53 FUNCTION get_payroll_name(p_business_group_id in number
54 ,p_payroll_id in number
55 ,p_effective_date in date)
56
57 return varchar2;
58
59 FUNCTION format_to_date(p_char_date in varchar2)
60 RETURN date;
61
62 /********************************************************************
63 ** Function : get_def_bal_for_seeded_bal
64 ** Arguments: p_balance_name
65 ** p_legislation_code
66 ** Returns : Defined Balance Id
67 ** Purpose : This function has 2 parameters as input. The function
68 ** returns defined balance id of the seeded balance. This
69 ** function also uses PL/SQL table def_bal_tbl to cache
70 ** defined balance id for seeded balanced.
71 *********************************************************************/
72 FUNCTION get_def_bal_for_seeded_bal (p_balance_name in varchar2
73 ,p_legislation_code in varchar2)
74 RETURN number;
75
76 /********************************************************************
77 ** Function : get_value
78 ** Arguments: p_assignment_action_id
79 ** p_defined_balance_id
80 ** p_tax_unit_id
81 ** Returns : Valueed Balance Id
82 ** Purpose : This function has 3 parameters as input. This function
83 ** sets the context for Tax Unit Id and then calling
84 ** pay_balance_pkg.get_value to get value for given
85 ** assignment_action id and defined balance id.
86 *********************************************************************/
87 FUNCTION get_value(p_assignment_action_id in number
88 ,p_defined_balance_id in number
89 ,p_tax_unit_id in number)
90 RETURN number;
91
92 gn_tax_unit_id number := -1;
93
94 TYPE defined_balance_rec IS RECORD
95 ( balance_name varchar2(240)
96 ,legislation_code varchar2(10)
97 ,defined_balance_id NUMBER
98 ,balance_type_id NUMBER
99 ,balance_dimension_id NUMBER
100 );
101
102 TYPE def_bal_tbl IS TABLE OF
103 defined_balance_rec
104 INDEX BY BINARY_INTEGER;
105
106 ltr_def_bal def_bal_tbl;
107
108 END pay_ac_util;