[Home] [Help]
PACKAGE BODY: APPS.PAY_PAYUSEAR_XMLP_PKG
Source
1 PACKAGE BODY PAY_PAYUSEAR_XMLP_PKG AS
2 /* $Header: PAYUSEARB.pls 120.0 2007/12/28 06:44:46 srikrish noship $ */
3
4 function BeforeReport return boolean is
5 begin
6
7 DECLARE l_time_period_name VARCHAR2(70);
8 l_period_start_date DATE;
9 l_period_end_date DATE;
10
11 begin
12
13 -- hr_standard.event('BEFORE REPORT');
14 null;
15 c_business_group_name :=
16 hr_reports.get_business_group(p_business_group_id);
17
18 if p_consolidation_set_id is not null then
19 c_consolidation_set_name :=
20 hr_us_reports.get_consolidation_set
21 (p_consolidation_set_id);
22 end if;
23
24 if p_time_period_id is not null then
25 hr_reports.get_time_period
26 (p_time_period_id
27 ,l_time_period_name
28 ,l_period_start_date
29 ,l_period_end_date);
30 c_time_period_name := l_time_period_name;
31 c_period_start_date := l_period_start_date;
32 c_period_end_date := l_period_end_date;
33 end if;
34
35 if p_payroll_id is not null then
36 c_payroll_name :=
37 hr_reports.get_payroll_name(l_period_end_date
38 ,p_payroll_id);
39 end if;
40
41 if p_tax_unit_id is not null then
42 c_tax_unit := hr_us_reports.get_org_name(p_tax_unit_id,p_business_group_id);
43 end if;
44
45 if p_payroll_action_id is not null then
46 c_payroll_action := hr_us_reports.get_payroll_action
47 (p_payroll_action_id);
48 end if;
49
50 if p_element_type_id is not null then
51 c_element_type_name := hr_us_reports.get_element_type_name
52 (p_element_type_id);
53 end if;
54
55 end; return (TRUE);
56 end;
57
58 function tax_unit_addressformula(location_id in number) return varchar2 is
59 begin
60
61 DECLARE l_tax_unit_address VARCHAR2(300);
62 l_location_id NUMBER(15);
63
64 begin
65
66 l_location_id := location_id;
67 hr_us_reports.get_address
68 (l_location_id
69 ,l_tax_unit_address);
70
71 c_tax_unit_address2 := l_tax_unit_address;
72
73 end;
74
75 RETURN NULL; end;
76
77 function c_valueformula(value in varchar2, uom in varchar2, currency1 in varchar2) return varchar2 is
78 begin
79
80 DECLARE
81 in_pay_value varchar2(30);
82 out_pay_value varchar2(30);
83 begin
84 in_pay_value := value;
85 hr_chkfmt.changeformat(in_pay_value,
86 out_pay_value,
87 uom,
88 currency1);
89 return (out_pay_value);
90 end;
91 RETURN NULL; end;
92
93 function G_tax_unit_headerGroupFilter return boolean is
94 begin
95
96 /*srw.message('001','GRE Name ->'||tax_unit_name);*/null;
97 return (TRUE);
98 end;
99
100 function AfterReport return boolean is
101 begin
102
103 -- hr_standard.event('AFTER REPORT');
104
105
106 return (TRUE);
107 end;
108
109 --Functions to refer Oracle report placeholders--
110
111 Function C_TAX_UNIT_ADDRESS2_p return varchar2 is
112 Begin
113 return C_TAX_UNIT_ADDRESS2;
114 END;
115 Function C_BUSINESS_GROUP_NAME_p return varchar2 is
116 Begin
117 return C_BUSINESS_GROUP_NAME;
118 END;
119 Function C_CONSOLIDATION_SET_NAME_p return varchar2 is
120 Begin
121 return C_CONSOLIDATION_SET_NAME;
122 END;
123 Function C_TIME_PERIOD_NAME_p return varchar2 is
124 Begin
125 return C_TIME_PERIOD_NAME;
126 END;
127 Function C_PAYROLL_NAME_p return varchar2 is
128 Begin
129 return C_PAYROLL_NAME;
130 END;
131 Function C_PAYROLL_ACTION_p return varchar2 is
132 Begin
133 return C_PAYROLL_ACTION;
134 END;
135 Function C_TAX_UNIT_p return varchar2 is
136 Begin
137 return C_TAX_UNIT;
138 END;
139 Function C_PERIOD_START_DATE_p return date is
140 Begin
141 return C_PERIOD_START_DATE;
142 END;
143 Function C_PERIOD_END_DATE_p return date is
144 Begin
145 return C_PERIOD_END_DATE;
146 END;
147 Function C_ELEMENT_TYPE_NAME_p return varchar2 is
148 Begin
149 return C_ELEMENT_TYPE_NAME;
150 END;
151 END PAY_PAYUSEAR_XMLP_PKG ;