[Home] [Help]
PACKAGE: APPS.PQP_GB_SCOTLAND_LGPS_PENSIONPY
Source
1 PACKAGE PQP_GB_SCOTLAND_LGPS_PENSIONPY AUTHID CURRENT_USER 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;