1 Package PQP_HRTCA_Synchronization AUTHID CURRENT_USER AS
2 /* $Header: pqphrtcasync.pkh 120.0 2005/05/29 02:22:12 appldev noship $ */
3
4 -- =============================================================================
5 -- ~ Pei_DDF_Ins:
6 -- =============================================================================
7 PROCEDURE Pei_DDF_Ins
8 (p_person_extra_info_id IN Number
9 ,p_person_id IN Number
10 ,p_information_type IN Varchar2
11 -- DDF
12 ,p_pei_information_category IN Varchar2
13 ,p_pei_information1 IN Varchar2
14 ,p_pei_information2 IN Varchar2
15 ,p_pei_information3 IN Varchar2
16 ,p_pei_information4 IN Varchar2
17 ,p_pei_information5 IN Varchar2
18 ,p_pei_information6 IN Varchar2
19 ,p_pei_information7 IN Varchar2
20 ,p_pei_information8 IN Varchar2
21 ,p_pei_information9 IN Varchar2
22 ,p_pei_information10 IN Varchar2
23 ,p_pei_information11 IN Varchar2
24 ,p_pei_information12 IN Varchar2
25 ,p_pei_information13 IN Varchar2
26 ,p_pei_information14 IN Varchar2
27 ,p_pei_information15 IN Varchar2
28 ,p_pei_information16 IN Varchar2
29 ,p_pei_information17 IN Varchar2
30 ,p_pei_information18 IN Varchar2
31 ,p_pei_information19 IN Varchar2
32 ,p_pei_information20 IN Varchar2
33 ,p_pei_information21 IN Varchar2
34 ,p_pei_information22 IN Varchar2
35 ,p_pei_information23 IN Varchar2
36 ,p_pei_information24 IN Varchar2
37 ,p_pei_information25 IN Varchar2
38 ,p_pei_information26 IN Varchar2
39 ,p_pei_information27 IN Varchar2
40 ,p_pei_information28 IN Varchar2
41 ,p_pei_information29 IN Varchar2
42 ,p_pei_information30 IN Varchar2
43 );
44 -- =============================================================================
45 -- ~ Pei_DDF_Upd:
46 -- =============================================================================
47 PROCEDURE Pei_DDF_Upd
48 (-- New PEI Information
49 p_person_extra_info_id IN Number
50 ,p_person_id IN Number
51 ,p_information_type IN Varchar2
52 -- New DDF
53 ,p_pei_information_category IN Varchar2
54 ,p_pei_information1 IN Varchar2
55 ,p_pei_information2 IN Varchar2
56 ,p_pei_information3 IN Varchar2
57 ,p_pei_information4 IN Varchar2
58 ,p_pei_information5 IN Varchar2
59 ,p_pei_information6 IN Varchar2
60 ,p_pei_information7 IN Varchar2
61 ,p_pei_information8 IN Varchar2
62 ,p_pei_information9 IN Varchar2
63 ,p_pei_information10 IN Varchar2
64 ,p_pei_information11 IN Varchar2
65 ,p_pei_information12 IN Varchar2
66 ,p_pei_information13 IN Varchar2
67 ,p_pei_information14 IN Varchar2
68 ,p_pei_information15 IN Varchar2
69 ,p_pei_information16 IN Varchar2
70 ,p_pei_information17 IN Varchar2
71 ,p_pei_information18 IN Varchar2
72 ,p_pei_information19 IN Varchar2
73 ,p_pei_information20 IN Varchar2
74 ,p_pei_information21 IN Varchar2
75 ,p_pei_information22 IN Varchar2
76 ,p_pei_information23 IN Varchar2
77 ,p_pei_information24 IN Varchar2
78 ,p_pei_information25 IN Varchar2
79 ,p_pei_information26 IN Varchar2
80 ,p_pei_information27 IN Varchar2
81 ,p_pei_information28 IN Varchar2
82
83 ,p_pei_information29 IN Varchar2
84 ,p_pei_information30 IN Varchar2
85 -- Old PEI Information
86 ,p_person_id_o IN Number
87 ,p_information_type_o IN Varchar2
88 ,p_pei_attribute_category_o IN Varchar2
89 -- Old DDF
90 ,p_pei_information_category_o IN Varchar2
91 ,p_pei_information1_o IN Varchar2
92 ,p_pei_information2_o IN Varchar2
93 ,p_pei_information3_o IN Varchar2
94 ,p_pei_information4_o IN Varchar2
95 ,p_pei_information5_o IN Varchar2
96 ,p_pei_information6_o IN Varchar2
97 ,p_pei_information7_o IN Varchar2
98 ,p_pei_information8_o IN Varchar2
99 ,p_pei_information9_o IN Varchar2
100 ,p_pei_information10_o IN Varchar2
101 ,p_pei_information11_o IN Varchar2
102 ,p_pei_information12_o IN Varchar2
103 ,p_pei_information13_o IN Varchar2
104 ,p_pei_information14_o IN Varchar2
105 ,p_pei_information15_o IN Varchar2
106 ,p_pei_information16_o IN Varchar2
107 ,p_pei_information17_o IN Varchar2
108 ,p_pei_information18_o IN Varchar2
109 ,p_pei_information19_o IN Varchar2
110 ,p_pei_information20_o IN Varchar2
111 ,p_pei_information21_o IN Varchar2
112 ,p_pei_information22_o IN Varchar2
113 ,p_pei_information23_o IN Varchar2
114 ,p_pei_information24_o IN Varchar2
115 ,p_pei_information25_o IN Varchar2
116 ,p_pei_information26_o IN Varchar2
117 ,p_pei_information27_o IN Varchar2
118 ,p_pei_information28_o IN Varchar2
119 ,p_pei_information29_o IN Varchar2
120 ,p_pei_information30_o IN Varchar2
121 );
122 -- =============================================================================
123 -- ~ Pei_DDF_Del:
124 -- =============================================================================
125 PROCEDURE Pei_DDF_Del
126 (p_person_id_o IN Number
127 ,p_information_type_o IN Varchar2
128 ,p_pei_attribute_category_o IN Varchar2
129 -- Old DDF
130 ,p_pei_information_category_o IN Varchar2
131 ,p_pei_information1_o IN Varchar2
132 ,p_pei_information2_o IN Varchar2
133 ,p_pei_information3_o IN Varchar2
134 ,p_pei_information4_o IN Varchar2
135 ,p_pei_information5_o IN Varchar2
136 ,p_pei_information6_o IN Varchar2
137 ,p_pei_information7_o IN Varchar2
138 ,p_pei_information8_o IN Varchar2
139 ,p_pei_information9_o IN Varchar2
140 ,p_pei_information10_o IN Varchar2
141 ,p_pei_information11_o IN Varchar2
142 ,p_pei_information12_o IN Varchar2
143 ,p_pei_information13_o IN Varchar2
144 ,p_pei_information14_o IN Varchar2
145 ,p_pei_information15_o IN Varchar2
146 ,p_pei_information16_o IN Varchar2
147 ,p_pei_information17_o IN Varchar2
148 ,p_pei_information18_o IN Varchar2
149 ,p_pei_information19_o IN Varchar2
150 ,p_pei_information20_o IN Varchar2
151 ,p_pei_information21_o IN Varchar2
152 ,p_pei_information22_o IN Varchar2
153 ,p_pei_information23_o IN Varchar2
154 ,p_pei_information24_o IN Varchar2
155 ,p_pei_information25_o IN Varchar2
156 ,p_pei_information26_o IN Varchar2
157 ,p_pei_information27_o IN Varchar2
158 ,p_pei_information28_o IN Varchar2
159 ,p_pei_information29_o IN Varchar2
160 ,p_pei_information30_o IN Varchar2
161 );
162
163 END PQP_HRTCA_Synchronization;