1 Package pqh_gsp_Post_Process AUTHID CURRENT_USER as
2 /* $Header: pqhgsppp.pkh 120.0.12010000.1 2008/07/28 12:59:25 appldev ship $ */
3
4 Function DT_Mode
5 (P_EFFECTIVE_DATE IN DATE
6 ,P_BASE_TABLE_NAME IN VARCHAR2
7 ,P_BASE_KEY_COLUMN IN VARCHAR2
8 ,P_BASE_KEY_VALUE IN NUMBER) Return Varchar2;
9
10 Procedure Call_PP_From_Assignments
11 (P_Effective_Date IN Date,
12 P_Assignment_Id IN Number,
13 P_Date_track_Mode IN Varchar2,
14 P_Warning_Mesg OUT NOCOPY Varchar2);
15
16 Procedure Call_PP_From_Benmngle
17 (P_Effective_Date IN Date,
18 P_Elig_per_Elctbl_Chc_Id IN Number);
19
20
21 Procedure Call_PP_From_AUI
22 (P_Errbuf OUT NOCOPY Varchar2,
23 P_Retcode OUT NOCOPY Number,
24 P_Effective_Date IN Varchar2,
25 P_Approval_Status_Cd IN Varchar2 Default NULL,
26 P_Elig_per_Elctbl_Chc_Id IN Number Default NULL);
27
28 Procedure Call_PP_For_Batch_Enrl
29 (P_Errbuf OUT NOCOPY Varchar2
30 ,P_Retcode OUT NOCOPY Number
31 ,P_Effective_Date IN Varchar2
32 ,P_Grade_Ladder_Id IN Number Default NULL
33 ,P_Person_Id IN Number Default NULL
34 ,p_grade_id IN Number Default Null
35 ,p_person_selection_rule_id IN Number Default Null);
36
37 /* Create Enrollment procedure creates an Enrollment for the Electable Choice record and
38 also Updates the Life Event as processed */
39
40 Procedure Override_Eligibility
41 (P_Effective_Date IN Date
42 ,P_Assignment_id IN Number
43 ,P_Called_From In Varchar2
44 ,P_Date_Track_Mode IN Varchar2 Default 'UPDATE'
45 ,P_Elig_Per_Elctbl_Chc_Id OUT NOCOPY Number);
46
47 Procedure Create_Enrollment
48 (P_Elig_Per_Elctbl_Chc_Id IN Number
49 ,P_Person_id IN Number
50 ,P_Progression_Style IN Varchar2
51 ,P_Effective_Date IN Date
52 ,P_PRTT_ENRT_RSLT_ID IN OUT NOCOPY Number
53 ,P_Status OUT NOCOPY Varchar2);
54
55 /* Update Salary procedure creates Pay Proposal for the Salary Basis
56 attached to the assignment. It Also Links the Pay proposal to Rates */
57
58 Procedure Update_Salary_Info
59 (P_Elig_per_Elctbl_Chc_Id IN Number
60 ,P_Effective_Date IN Date
61 ,P_Dt_Mode IN Varchar2 Default NULL
62 ,P_Called_From IN Varchar2 Default 'PP'
63 ,P_Prv_Sal_Chg_Dt IN Date Default NULL);
64
65 /* Updates the Assignment with the New Grade - Step */
66
67 Procedure Update_Assgmt_Info
68 (P_Elig_Per_Elctbl_Chc_Id IN Number,
69 P_Effective_Date IN Date);
70
71 Procedure Approve_Reject_AUI
72 (P_Elig_Per_Elctbl_Chc_id IN Number
73 ,P_Prog_Dt IN Date Default NULL
74 ,P_Sal_Chg_Dt IN Date Default NULL
75 ,P_Comments IN Varchar2 Default NULL
76 ,P_Approve_Rej IN Varchar2);
77
78 Procedure get_persons_gl_and_grade(p_person_id in number,
79 p_business_group_id in number,
80 p_effective_date in date,
81 p_persons_pgm_id out nocopy number,
82 p_persons_plip_id out nocopy number,
83 p_prog_style out nocopy varchar2);
84
85 Procedure Call_Concurrent_Req_Aui
86 (P_Approval_Status_Cd IN Varchar2
87 ,P_Req_Id OUT NOCOPY Varchar2);
88 Procedure Update_Rate_Sync_Salary
89 (P_per_in_ler_Id IN Number
90 ,P_Effective_Date IN Date
91 );
92
93 Procedure gsp_rate_sync
94 (P_Effective_Date IN Date
95 ,p_per_in_ler_id IN NUMBER
96 ,p_person_id IN NUMBER
97 ,p_assignment_id IN NUMBER
98 );
99 --
100 Procedure call_from_webadi
101 (P_Elig_Per_Elctbl_Chc_id IN Number
102 ,P_PROGRESSION_DATE IN Date
103 ,P_Sal_Chg_Dt IN Date
104 ,p_assignment_id IN NUMBER
105 ,p_proposed_rank in number
106 ,p_life_event_dt in date
107 ,p_grade_ladder_id in number
108 ,p_pl_id in number
109 ,p_oipl_id in number
110 );
111 --
112 END pqh_gsp_Post_Process;