PACKAGE: APPS.BEN_PRO_LER

Source

1 package ben_pro_ler as
2 /* $Header: beprotrg.pkh 120.1 2006/02/16 01:16:32 rtagarra noship $ */
3 TYPE g_pro_ler_rec is RECORD
4 (PERSON_ID NUMBER
5 ,BUSINESS_GROUP_ID NUMBER
6 ,PAY_PROPOSAL_ID                 NUMBER
7 ,OBJECT_VERSION_NUMBER           NUMBER
8 ,ASSIGNMENT_ID                   NUMBER
9 ,EVENT_ID                        NUMBER
10 ,CHANGE_DATE                     DATE
11 ,LAST_CHANGE_DATE                DATE
12 ,NEXT_PERF_REVIEW_DATE           DATE
13 ,NEXT_SAL_REVIEW_DATE            DATE
14 ,PERFORMANCE_RATING              VARCHAR2(30)
15 ,PROPOSAL_REASON                 VARCHAR2(30)
16 ,PROPOSED_SALARY_N               NUMBER
17 ,REVIEW_DATE                     DATE
18 ,APPROVED                        VARCHAR2(30)
19 ,MULTIPLE_COMPONENTS             VARCHAR2(30)
20 ,FORCED_RANKING                  NUMBER
21 ,PERFORMANCE_REVIEW_ID           NUMBER
22 ,ATTRIBUTE1                      VARCHAR2(150)
23 ,ATTRIBUTE2                      VARCHAR2(150)
24 ,ATTRIBUTE3                      VARCHAR2(150)
25 ,ATTRIBUTE4                      VARCHAR2(150)
26 ,ATTRIBUTE5                      VARCHAR2(150)
27 ,ATTRIBUTE6                      VARCHAR2(150)
28 ,ATTRIBUTE7                      VARCHAR2(150)
29 ,ATTRIBUTE8                      VARCHAR2(150)
30 ,ATTRIBUTE9                      VARCHAR2(150)
31 ,ATTRIBUTE10                     VARCHAR2(150)
32 ,ATTRIBUTE11                     VARCHAR2(150)
33 ,ATTRIBUTE12                     VARCHAR2(150)
34 ,ATTRIBUTE13                     VARCHAR2(150)
35 ,ATTRIBUTE14                     VARCHAR2(150)
36 ,ATTRIBUTE15                     VARCHAR2(150)
37 ,ATTRIBUTE16                     VARCHAR2(150)
38 ,ATTRIBUTE17                     VARCHAR2(150)
39 ,ATTRIBUTE18                     VARCHAR2(150)
40 ,ATTRIBUTE19                     VARCHAR2(150)
41 ,ATTRIBUTE20                     VARCHAR2(150)
42 ,PROPOSED_SALARY                 VARCHAR2(60)
43 ,date_to                         DATE
44 );
45 
46 procedure ler_chk(p_old IN g_pro_ler_rec
47                  ,p_new IN g_pro_ler_rec
48                  ,p_effective_date in date default null );
49 
50 procedure qua_in_gr_ler_chk( p_old_asg IN ben_asg_ler.g_asg_ler_rec
51                             ,p_new_asg IN ben_asg_ler.g_asg_ler_rec
52                             ,p_old_pro IN g_pro_ler_rec
53                             ,p_new_pro IN g_pro_ler_rec
54                             ,p_effective_date IN date default null
55                             ,p_called_from IN varchar2);
56 end;