DBA Data[Home] [Help]

PACKAGE: APPS.PQP_GB_SCOTLAND_LGPS_PENSIONPY

Source


1 PACKAGE PQP_GB_SCOTLAND_LGPS_PENSIONPY AS
2 /* $Header: pqgbsclgps.pkh 120.4.12010000.1 2008/09/17 12:48:55 skpatil noship $ */
3 
4 
5 procedure DERIVE_PENSIONABLE_PAY(errbuf out nocopy varchar2,
6                                  retcode out nocopy number,
7                                  p_effective_start_dt IN varchar2,
8                                  p_effective_end_dt IN varchar2,
9                                  p_payroll_id IN NUMBER,
10                                  p_assignment_set_id IN NUMBER,
11                                  p_assignment_number IN varchar2,
12                                  p_employee_no IN varchar2,
13                                  p_business_group_id IN NUMBER,
14                                  p_mode in varchar2 );
15 --
16 /*Function GET_PQP_LGPS_TRANSITIONAL_FLAG(p_assignment_id IN NUMBER, p_effective_date Date, p_business_group_id number)
17 return varchar2; */
18 
19 Function GET_PQP_LGPS_PENSION_PAY(p_assignment_id IN NUMBER, p_effective_date Date, p_business_group_id number)
20 return number;
21 
22 /*Function GET_PQP_LGPS_ELEMENT_NAME(p_assignment_id IN NUMBER, p_effective_date Date)
23 return varchar2; */
24 
25 /*Function GET_FINANCIAL_YEAR(p_effective_date Date)
26 return number;/
27 --
28 /* 6666135 Begin
29 Function RUN_USER_FORMULA(p_assignment_id number,p_effective_date date, p_business_group_id number, p_payroll_id number)
30 return number;
31 6666135 End */
32 
33 
34 end PQP_GB_SCOTLAND_LGPS_PENSIONPY;