PACKAGE: APPS.PAY_ZA_UIF_ARCHIVE_PKG

Source

1 package pay_za_uif_archive_pkg as
2 /* $Header: pyzauifa.pkh 120.0.12010000.1 2008/07/28 00:06:37 appldev ship $ */
3 /*+======================================================================+
4   |       Copyright (c) 2002 Oracle Corporation                          |
5   |                           All rights reserved.                       |
6   +======================================================================+
7   SQL Script File name : pyzauifa.pkh
8   Description          : This sql script seeds the Package that creates
9                         the UIF Archive code
10 
11   Change List:
12   ------------
13 
14   Name           Date        Version Bug     Text
15   -------------- ----------- ------- ------  ----------------------------
16   L.Kloppers     21-Apr-2002   115.0 2266156 Initial Version
17   L.Kloppers     06-May-2002   115.1 2266156 Added p_effective_date parameter
18                                              to function get_balance_value
19   L.Kloppers     09-May-2002   115.2 2266156 Added range_cursor_mag for UIF File
20   Nirupa S       09-dec-2002   115.4 2686708 Added NOCOPY
21   Nageswara Rao  24-JAN-2003   115.5 2654703 Added new funtion
22                                              get_uif_total_remu_sub_uif
23  ========================================================================
24 */
25 type char240_data_type_table is table of varchar2(240)
26      index by binary_integer;
27 
28 
29 procedure get_parameters
30 (
31    p_payroll_action_id in  number,
32    p_token_name        in  varchar2,
33    p_token_value       out nocopy varchar2
34 );
35 
36 function get_balance_value
37    (
38    p_assignment_id in per_all_assignments_f.assignment_id%type,
39    p_balance_name in pay_balance_types.balance_name%type,
40    p_dimension in pay_balance_dimensions.dimension_name%type,
41    p_effective_date in date
42    )
43 return number;
44 
45 procedure range_cursor
46 (
47    pactid in  number,
48    sqlstr out nocopy varchar2
49 );
50 
51 procedure range_cursor_mag
52 (
53    pactid in  number,
54    sqlstr out nocopy varchar2
55 );
56 
57 procedure action_creation
58 (
59    pactid    in number,
60    stperson  in number,
61    endperson in number,
62    chunk     in number
63 );
64 
65 procedure archive_data
66 (
67    p_assactid       in number,
68    p_effective_date in date
69 );
70 
71 function process_uif_ref_no
72 (
73    p_employer_uif_ref_no in varchar2
74 )  return varchar2;
75 
76 procedure archinit
77 (
78    p_payroll_action_id in number
79 );
80 
81 function get_parameter
82 (
83    name        in varchar2,
84    parameter_list varchar2
85 )  return varchar2;
86 pragma restrict_references(get_parameter, WNDS, WNPS);
87 
88 
89 function names
90 (
91    name   varchar2
92 )  return varchar2;
93 pragma restrict_references(names, WNDS, WNPS);
94 
95 function clean
96 (
97    name   varchar2
98 )  return varchar2;
99 
100 
101 function get_uif_employer_count return number;
102 
103 function get_uif_total_gross_tax_rem return number;
104 
105 function get_uif_total_remu_sub_uif return number;  /* Bug 2654703 */
106 
107 function get_uif_total_uif_contrib return number;
108 
109 
110 function set_size
111 (
112    p_code  in varchar2,
113    p_type  in varchar2,
114    p_value in varchar2
115 )  return varchar2;
116 
117 function za_power
118 (
119    p_number in number,
120    p_power  in number
121 )  return number;
122 
123 function za_to_char
124 (
125    p_number in number,
126    p_format in varchar2 default '&&&'
127 )  return varchar2;
128 
129 
130 end pay_za_uif_archive_pkg;