PACKAGE: APPS.PAY_PAYGBRRS_XMLP_PKG

Source

1 PACKAGE PAY_PAYGBRRS_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PAYGBRRSS.pls 120.1 2007/12/24 12:44:19 amakrish noship $ */
3 	P_BUSINESS_GROUP_ID	number;
4 	P_SESSION_DATE	date;
5 	P_CONC_REQUEST_ID	number;
6 	P_CONSOLIDATION_SET_ID	varchar2(40);
7 	P_TIME_PERIOD_ID	number;
8 	P_PAYROLL_ID	number;
9 	P_CONSOLIDATION_SET_LINE	varchar2(100);
10 	P_LEGISLATION_CODE	varchar2(150);
11 	P_BUSINESS_GROUP	varchar2(40);
12 	P_GROSS_PAY_ID	number;
13 	P_TOTAL_DEDUCTIONS_ID	varchar2(80);
14 	P_DIRECT_PAYMENT_ID	number;
15 	P_EMPLOYER_CHARGES_ID	number;
16 	P_Sort_Order	varchar2(30);
17 	P_CURRENCY_CODE	varchar2(15);
18 	CP_BUSINESS_GROUP_NAME	varchar2(240);
19 	CP_PAYROLL_NAME	varchar2(80);
20 	CP_Time_Period_Time	varchar2(35);
21 	CP_CONSOLIDATION_SET_NAME	varchar2(60);
22 	CP_NI_input_Value_ID	number;
23 	CP_Tax_Code_Input_Value_ID	number;
24 	CP_Tax_Basis_Input_Value_ID	number;
25 	--CP_Sort_Order	varchar2(30) := := 'Assignment_Number' ;
26 	CP_Sort_Order	varchar2(30) := 'Assignment_Number' ;
27 	CP_CURRENCY_TEXT	varchar2(12);
28 	----------------------
29 	--Additional package--
30 	----------------------
31 	Gross_Payment number(13,2) :=0;
32 	Net_Payment number(13,2)   :=0;
33 	Total_Payment number(13,2) :=0;
34 	Total_Cost number(13,2) :=0;
35 	Other_Deductions number(13,2) :=0;
36 	Calc_Amount number(13,2) :=0;
37 
38 	PROCEDURE Initialise_Variables;
39 	----------------------
40 	function Before_Report_Trigger return boolean  ;
41 	function Before_Parameter_Form_Trigger return boolean  ;
42 	function cf_total_paymentformula(Gross in number, Total_Deductions in number, Direct_Payments in number) return number  ;
43 	function cf_other_deductionsformula(Total_Deductions in number, PAYE in number, NI_Employee in number) return number  ;
44 	function cf_total_payments_currencyform(currency_code in varchar2, date_earned in date, net in number) return number  ;
45 	function cf_total_payments_currency(currency_code in varchar2, date_earned in date, Gross in number, Total_Deductions in number, Direct_Payments in number) return number  ;
46 	function CP_CURRENCY_TEXTFormula return VARCHAR2  ;
47 	function AfterReport return boolean  ;
48 	Function CP_BUSINESS_GROUP_NAME_p return varchar2;
49 	Function CP_PAYROLL_NAME_p return varchar2;
50 	Function CP_Time_Period_Time_p return varchar2;
51 	Function CP_CONSOLIDATION_SET_NAME_p return varchar2;
52 	Function CP_NI_input_Value_ID_p return number;
53 	Function CP_Tax_Code_Input_Value_ID_p return number;
54 	Function CP_Tax_Basis_Input_Value_ID_p return number;
55 	Function CP_Sort_Order_p return varchar2;
56 	Function CP_CURRENCY_TEXT_p return varchar2;
57 END PAY_PAYGBRRS_XMLP_PKG;