PACKAGE: APPS.BEN_PPS_LER

Source

1 package ben_pps_ler AUTHID CURRENT_USER as
2 /* $Header: bepsptrg.pkh 120.0.12000000.1 2007/01/19 22:29:16 appldev noship $*/
3 --
4 -- Bug 1805328 : Added FINAL_PROCESS_DATE
5 --
6 TYPE g_pps_ler_rec is RECORD
7 (PERSON_ID NUMBER
8 ,BUSINESS_GROUP_ID NUMBER
9 ,DATE_START DATE
10 ,ACTUAL_TERMINATION_DATE DATE
11 ,LEAVING_REASON VARCHAR2(30)
12 ,ADJUSTED_SVC_DATE DATE
13 ,ATTRIBUTE1 VARCHAR2(150)
14 ,ATTRIBUTE2 VARCHAR2(150)
15 ,ATTRIBUTE3 VARCHAR2(150)
16 ,ATTRIBUTE4 VARCHAR2(150)
17 ,ATTRIBUTE5 VARCHAR2(150)
18 ,FINAL_PROCESS_DATE DATE
19 ,PERIOD_OF_SERVICE_ID NUMBER
20 );
21 
22 procedure ler_chk(p_old            in g_pps_ler_rec
23                  ,p_new            in g_pps_ler_rec
24                  ,p_event          in varchar2
25                  ,p_effective_date in date);
26 
27 
28  -- this is added to avoid the life event created for termination while reversing the termination
29  -- this is to be removed when the HR fix the bug
30  ben_pps_evt_chk  number := 0 ;
31 
32 end;