[Home] [Help]
PACKAGE: APPS.PAY_PAYGB45L_XMLP_PKG
Source
1 PACKAGE PAY_PAYGB45L_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PAYGB45LS.pls 120.1 2007/12/24 12:42:31 amakrish noship $ */
3 P_SESSION_DATE date;
4 P_REPORT_TITLE varchar2(60);
5 P_CONC_REQUEST_ID number;
6 P_DATE_TODAY date;
7 P_ACTION_RESTRICTION varchar2(100);
8 P_ASSIGNMENT_ACTION_ID number;
9 P_PAYROLL_ACTION_ID number;
10 C_NI12 varchar2(2);
11 C_NI34 varchar2(2);
12 C_NI56 varchar2(2);
13 C_NI78 varchar2(2);
14 C_Ni9 varchar2(1);
15 C_DATE_OF_LEAVING_DD varchar2(2);
16 C_DATE_OF_LEAVING_MM varchar2(2);
17 C_DATE_OF_LEAVING_YYYY varchar2(4);
18 C_WEEK_NO number;
19 C_MONTH_NO number;
20 C_TOTAL_TAX_TD number;
21 C_TOTAL_PAY_TD number;
22 C_PER_ADDRESS_LINE1 varchar2(60);
23 C_PER_ADDRESS_LINE2 varchar2(60);
24 C_PER_ADDRESS_LINE3 varchar2(60);
25 C_PER_ADDRESS_LINE4 varchar2(38);
26 C_PAY_IN_EMP_POUNDS number := 0 ;
27 C_PAY_IN_EMP_PENCE number := 00 ;
28 C_TAX_IN_EMP_POUNDS number := 0 ;
29 C_TAX_IN_EMP_PENCE number := 00 ;
30 C_PAY_TD_POUNDS number := 0 ;
31 C_PAY_TD_PENCE number := 00 ;
32 C_TAX_TD_POUNDS number := 0 ;
33 C_TAX_TD_PENCE number := 00 ;
34 C_BUSINESS_GROUP_NAME varchar2(60);
35 C_REPORT_SUBTITLE varchar2(60);
36 C_FORMULA_ID number;
37 C_MESSAGE varchar2(80);
38 C_NEW_PAGE varchar2(1);
39 C_ERS_ADDR_LINE1 varchar2(38);
40 C_ERS_ADDR_LINE2 varchar2(38);
41 C_ERS_ADDR_LINE3 varchar2(38);
42 C_TAX_DIST_NO varchar2(3);
43 C_TAX_DIST_REF varchar2(32767);
44 C_ERS_NAME varchar2(40);
45 function BeforeReport return boolean ;
46 function c_format_dataformula(address_line1 in varchar2, address_line2 in varchar2,
47 address_line3 in varchar2, town_or_city in varchar2, county in varchar2, post_code in varchar2,
48 taxable_pay in number, previous_taxable_pay in number, tax_paid in number, previous_tax_paid in number,
49 ni_number in varchar2, termination_date in date, c_3_part in varchar2, w1_m1_indicator in varchar2,
50 month_number in number, week_number in number) return varchar2 ;
51 procedure get_pounds_pence(p_total in number,
52 p_pounds in out NOCOPY number,
53 p_pence in out NOCOPY number) ;
54 procedure split_employer_address(p_employer_address in varchar2,
55 p_emp_addr_line_1 in out NOCOPY varchar2,
56 p_emp_addr_line_2 in out NOCOPY varchar2,
57 p_emp_addr_line_3 in out NOCOPY varchar2) ;
58 function C_3_PARTFormula return VARCHAR2 ;
59 function AfterReport return boolean ;
60 Function C_NI12_p return varchar2;
61 Function C_NI34_p return varchar2;
62 Function C_NI56_p return varchar2;
63 Function C_NI78_p return varchar2;
64 Function C_Ni9_p return varchar2;
65 Function C_DATE_OF_LEAVING_DD_p return varchar2;
66 Function C_DATE_OF_LEAVING_MM_p return varchar2;
67 Function C_DATE_OF_LEAVING_YYYY_p return varchar2;
68 Function C_WEEK_NO_p return number;
69 Function C_MONTH_NO_p return number;
70 Function C_TOTAL_TAX_TD_p return number;
71 Function C_TOTAL_PAY_TD_p return number;
72 Function C_PER_ADDRESS_LINE1_p return varchar2;
73 Function C_PER_ADDRESS_LINE2_p return varchar2;
74 Function C_PER_ADDRESS_LINE3_p return varchar2;
75 Function C_PER_ADDRESS_LINE4_p return varchar2;
76 Function C_PAY_IN_EMP_POUNDS_p return number;
77 Function C_PAY_IN_EMP_PENCE_p return number;
78 Function C_TAX_IN_EMP_POUNDS_p return number;
79 Function C_TAX_IN_EMP_PENCE_p return number;
80 Function C_PAY_TD_POUNDS_p return number;
81 Function C_PAY_TD_PENCE_p return number;
82 Function C_TAX_TD_POUNDS_p return number;
83 Function C_TAX_TD_PENCE_p return number;
84 Function C_BUSINESS_GROUP_NAME_p return varchar2;
85 Function C_REPORT_SUBTITLE_p return varchar2;
86 Function C_FORMULA_ID_p return number;
87 Function C_MESSAGE_p return varchar2;
88 Function C_NEW_PAGE_p return varchar2;
89 Function C_ERS_ADDR_LINE1_p return varchar2;
90 Function C_ERS_ADDR_LINE2_p return varchar2;
91 Function C_ERS_ADDR_LINE3_p return varchar2;
92 Function C_TAX_DIST_NO_p return varchar2;
93 Function C_TAX_DIST_REF_p return varchar2;
94 Function C_ERS_NAME_p return varchar2;
95 END PAY_PAYGB45L_XMLP_PKG;