[Home] [Help]
PACKAGE BODY: APPS.PAY_PYNZQES_XMLP_PKG
Source
1 PACKAGE BODY PAY_PYNZQES_XMLP_PKG AS
2 /* $Header: PYNZQESB.pls 120.0 2007/12/13 12:22:16 amakrish noship $ */
3
4 function AfterReport return boolean is
5 begin
6 /*srw.user_exit('FND SRWEXIT');*/null;
7
8 return (TRUE);
9 end;
10
11 function CF_business_groupFormula return VARCHAR2 is
12 v_business_group hr_all_organization_units.name%type;
13
14 begin
15 v_business_group := hr_reports.get_business_group(p_business_group_id);
16 return v_business_group;
17 end;
18
19 function BeforeReport return boolean is
20 begin
21 cp_report_name := 'PAYNZQES';
22 cp_statistics_balance_name := 'Statistics NZ ';
23 cp_balance_dimension := '_ASG_PTD';
24 cp_payout_balance_name := 'Payout';
25 cp_hours_balance_name := 'Hours';
26 cp_application_id := 800;
27 cp_week_hours := 30;
28 cp_week_frequency := 'Week';
29
30 /*srw.user_exit('FND SRWINIT');*/null;
31
32 return (TRUE);
33 end;
34
35 function CF_legislation_codeFormula return VARCHAR2 is
36
37 v_legislation_code hr_organization_information.org_information9%type := null;
38
39 cursor legislation_code
40 (c_business_group_id hr_organization_information.organization_id%type) is
41
42 select org_information9
43 from hr_organization_information
44 where organization_id = c_business_group_id
45 and org_information9 is not null;
46 begin
47 open legislation_code (p_business_group_id);
48 fetch legislation_code into v_legislation_code;
49 close legislation_code;
50
51 return v_legislation_code;
52 end;
53
54 function CP_report_nameFormula return VARCHAR2 is
55 begin
56 return ('PAYNZREC');
57 end;
58
59 function CP_statistics_balance_nameForm return VARCHAR2 is
60 begin
61 return 'Statistics NZ ';
62 end;
63
64 function CP_balance_dimensionFormula return VARCHAR2 is
65 begin
66 return '_ASG_PTD';
67 end;
68
69 function cf_currency_format_maskformula(cf_legislation_code in varchar2) return varchar2 is
70
71 v_currency_code fnd_currencies.currency_code%type;
72 v_format_mask varchar2(100) := null;
73 v_field_length number(3) := 15;
74
75 cursor currency_format_mask
76 (c_territory_code in fnd_currencies.issuing_territory_code%type) is
77 select currency_code
78 from fnd_currencies
79 where issuing_territory_code = c_territory_code;
80
81 begin
82 open currency_format_mask (cf_legislation_code);
83 fetch currency_format_mask into v_currency_code;
84 close currency_format_mask;
85
86 v_format_mask := fnd_currency.get_format_mask(v_currency_code, v_field_length);
87
88 return v_format_mask;
89 end;
90
91 function CP_hours_balance_nameFormula return VARCHAR2 is
92 begin
93 return 'Hours';
94 end;
95
96 function CP_payout_balance_nameFormula return VARCHAR2 is
97 begin
98 return 'Payout';
99 end;
100
101 function CP_application_idFormula return Number is
102 begin
103 return 800;
104 end;
105
106 function CP_week_frequencyFormula return Char is
107 begin
108 return 'Week';
109 end;
110
111 function CP_week_hoursFormula return Number is
112 begin
113 return 30;
114 end;
115
116 --Functions to refer Oracle report placeholders--
117
118 Function CP_report_name_p return varchar2 is
119 Begin
120 return CP_report_name;
121 END;
122 Function CP_statistics_balance_name_p return varchar2 is
123 Begin
124 return CP_statistics_balance_name;
125 END;
126 Function CP_balance_dimension_p return varchar2 is
127 Begin
128 return CP_balance_dimension;
129 END;
130 Function CP_hours_balance_name_p return varchar2 is
131 Begin
132 return CP_hours_balance_name;
133 END;
134 Function CP_payout_balance_name_p return varchar2 is
135 Begin
136 return CP_payout_balance_name;
137 END;
138 Function CP_application_id_p return number is
139 Begin
140 return CP_application_id;
141 END;
142 Function CP_week_hours_p return number is
143 Begin
144 return CP_week_hours;
145 END;
146 Function CP_week_frequency_p return varchar2 is
147 Begin
148 return CP_week_frequency;
149 END;
150 END PAY_PYNZQES_XMLP_PKG ;