1 PACKAGE per_in_prev_employer_leg_hook AUTHID CURRENT_USER AS
2 /* $Header: peinlhpr.pkh 120.1 2007/11/22 10:36:50 sivanara ship $ */
3
4 --------------------------------------------------------------------------
5 -- Name : validate_ltc_availed --
6 -- Type : Procedure --
7 -- Access : Public --
8 -- Description : Dummy Procedure is required as seed data with --
9 -- call has already been shipped --
10 ---------------------------------------------------------------------------
11 PROCEDURE validate_ltc_availed(
12 p_pem_information_category IN VARCHAR2
13 ,p_end_date IN DATE
14 ) ;
15
16 --------------------------------------------------------------------------
17 -- Name : check_prev_emp_create --
18 -- Type : Procedure --
19 -- Access : Public --
20 -- Description : Main Procedure to be called from the PEM Info Hook --
21 -- Parameters : --
22 -- IN : p_effective_date IN DATE --
23 -- p_previous_employer_id IN NUMBER --
24 -- p_business_group_id IN NUMBER --
25 -- p_person_id IN NUMBER --
26 -- p_start_date IN DATE --
27 -- p_end_date IN DATE --
28 -- p_pem_information_category IN VARCHAR2 --
29 -- p_pem_information1..30 IN VARCHAR2 --
30 --------------------------------------------------------------------------
31 PROCEDURE check_prev_emp_create(
32 p_effective_date IN DATE
33 ,p_previous_employer_id IN NUMBER
34 ,p_business_group_id IN NUMBER
35 ,p_person_id IN NUMBER
36 ,p_start_date IN DATE
37 ,p_end_date IN DATE
38 ,p_pem_information_category IN VARCHAR2
39 ,p_pem_information1 IN VARCHAR2
40 ,p_pem_information2 IN VARCHAR2
41 ,p_pem_information3 IN VARCHAR2
42 ,p_pem_information4 IN VARCHAR2
43 ,p_pem_information5 IN VARCHAR2
44 ,p_pem_information6 IN VARCHAR2
45 ,p_pem_information7 IN VARCHAR2
46 ,p_pem_information8 IN VARCHAR2
47 ,p_pem_information9 IN VARCHAR2
48 ,p_pem_information10 IN VARCHAR2
49 ,p_pem_information11 IN VARCHAR2
50 ,p_pem_information12 IN VARCHAR2
51 ,p_pem_information13 IN VARCHAR2
52 ,p_pem_information14 IN VARCHAR2
53 ,p_pem_information15 IN VARCHAR2
54 ,p_pem_information16 IN VARCHAR2
55 ,p_pem_information17 IN VARCHAR2
56 ,p_pem_information18 IN VARCHAR2
57 ,p_pem_information19 IN VARCHAR2
58 ,p_pem_information20 IN VARCHAR2
59 ,p_pem_information21 IN VARCHAR2
60 ,p_pem_information22 IN VARCHAR2
61 ,p_pem_information23 IN VARCHAR2
62 ,p_pem_information24 IN VARCHAR2
63 ,p_pem_information25 IN VARCHAR2
64 ,p_pem_information26 IN VARCHAR2
65 ,p_pem_information27 IN VARCHAR2
66 ,p_pem_information28 IN VARCHAR2
67 ,p_pem_information29 IN VARCHAR2
68 ,p_pem_information30 IN VARCHAR2);
69
70 --------------------------------------------------------------------------
71 -- Name : check_prev_emp_update --
72 -- Type : Procedure --
73 -- Access : Public --
74 -- Description : Main Procedure to be called from the PEM Info Hook --
75 -- Parameters : --
76 -- IN : p_effective_date IN DATE --
77 -- p_previous_employer_id IN NUMBER --
78 -- p_business_group_id IN NUMBER --
79 -- p_person_id IN NUMBER --
80 -- p_start_date IN DATE --
81 -- p_end_date IN DATE --
82 -- p_pem_information_category IN VARCHAR2 --
83 -- p_pem_information1..30 IN VARCHAR2 --
84 --------------------------------------------------------------------------
85 PROCEDURE check_prev_emp_update(
86 p_effective_date IN DATE
87 ,p_previous_employer_id IN NUMBER
88 ,p_start_date IN DATE
89 ,p_end_date IN DATE
90 ,p_pem_information_category IN VARCHAR2
91 ,p_pem_information1 IN VARCHAR2
92 ,p_pem_information2 IN VARCHAR2
93 ,p_pem_information3 IN VARCHAR2
94 ,p_pem_information4 IN VARCHAR2
95 ,p_pem_information5 IN VARCHAR2
96 ,p_pem_information6 IN VARCHAR2
97 ,p_pem_information7 IN VARCHAR2
98 ,p_pem_information8 IN VARCHAR2
99 ,p_pem_information9 IN VARCHAR2
100 ,p_pem_information10 IN VARCHAR2
101 ,p_pem_information11 IN VARCHAR2
102 ,p_pem_information12 IN VARCHAR2
103 ,p_pem_information13 IN VARCHAR2
104 ,p_pem_information14 IN VARCHAR2
105 ,p_pem_information15 IN VARCHAR2
106 ,p_pem_information16 IN VARCHAR2
107 ,p_pem_information17 IN VARCHAR2
108 ,p_pem_information18 IN VARCHAR2
109 ,p_pem_information19 IN VARCHAR2
110 ,p_pem_information20 IN VARCHAR2
111 ,p_pem_information21 IN VARCHAR2
112 ,p_pem_information22 IN VARCHAR2
113 ,p_pem_information23 IN VARCHAR2
114 ,p_pem_information24 IN VARCHAR2
115 ,p_pem_information25 IN VARCHAR2
116 ,p_pem_information26 IN VARCHAR2
117 ,p_pem_information27 IN VARCHAR2
118 ,p_pem_information28 IN VARCHAR2
119 ,p_pem_information29 IN VARCHAR2
120 ,p_pem_information30 IN VARCHAR2);
121
122 END per_in_prev_employer_leg_hook;