[Home] [Help]
PACKAGE BODY: APPS.HR_IN_CONTACT_EXTRA_INFO_API
Source
1 PACKAGE Body hr_in_contact_extra_info_api AS
2 /* $Header: pereiini.pkb 115.0 2004/05/25 03:57 gaugupta noship $ */
3 g_package VARCHAR2(33) := 'hr_in_contact_rel_api.';
4 g_trace boolean;
5
6 -- ----------------------------------------------------------------------------
7 -- |-----------------------< create_in_contact_extra_info >----------------------|
8 -- ----------------------------------------------------------------------------
9
10 PROCEDURE create_in_contact_extra_info
11 (p_validate IN boolean default false,
12 p_effective_date IN date,
13 p_contact_relationship_id IN NUMBER,
14 p_information_type IN VARCHAR2,
15 p_nomination_type IN VARCHAR2,
16 p_percent_share IN VARCHAR2,
17 p_nomination_change_reason IN VARCHAR2 DEFAULT NULL,
18 p_cei_attribute_category IN VARCHAR2 DEFAULT NULL,
19 p_cei_attribute1 IN VARCHAR2 DEFAULT NULL,
20 p_cei_attribute2 IN VARCHAR2 DEFAULT NULL,
21 p_cei_attribute3 IN VARCHAR2 DEFAULT NULL,
22 p_cei_attribute4 IN VARCHAR2 DEFAULT NULL,
23 p_cei_attribute5 IN VARCHAR2 DEFAULT NULL,
24 p_cei_attribute6 IN VARCHAR2 DEFAULT NULL,
25 p_cei_attribute7 IN VARCHAR2 DEFAULT NULL,
26 p_cei_attribute8 IN VARCHAR2 DEFAULT NULL,
27 p_cei_attribute9 IN VARCHAR2 DEFAULT NULL,
28 p_cei_attribute10 IN VARCHAR2 DEFAULT NULL,
29 p_cei_attribute11 IN VARCHAR2 DEFAULT NULL,
30 p_cei_attribute12 IN VARCHAR2 DEFAULT NULL,
31 p_cei_attribute13 IN VARCHAR2 DEFAULT NULL,
32 p_cei_attribute14 IN VARCHAR2 DEFAULT NULL,
33 p_cei_attribute15 IN VARCHAR2 DEFAULT NULL,
34 p_cei_attribute16 IN VARCHAR2 DEFAULT NULL,
35 p_cei_attribute17 IN VARCHAR2 DEFAULT NULL,
36 p_cei_attribute18 IN VARCHAR2 DEFAULT NULL,
37 p_cei_attribute19 IN VARCHAR2 DEFAULT NULL,
38 p_cei_attribute20 IN VARCHAR2 DEFAULT NULL,
39 p_contact_extra_info_id OUT NOCOPY number,
40 p_object_version_number OUT NOCOPY number,
41 p_effective_start_date OUT NOCOPY DATE,
42 p_effective_end_date OUT NOCOPY DATE
43 )
44 AS
45 --
46 -- Declare cursors and local variables
47 --
48 l_proc VARCHAR2(72);
49 BEGIN
50 l_proc := g_package||'create_in_contact_extra_info';
51 g_trace := hr_utility.debug_enabled ;
52
53 IF g_trace THEN
54 hr_utility.set_location('Entering: '||l_proc, 10);
55 END IF ;
56
57 hr_contact_extra_info_api.create_contact_extra_info(
58 p_validate => p_validate,
59 p_effective_date => p_effective_date,
60 p_contact_relationship_id => p_contact_relationship_id,
61 p_information_type => P_information_type,
62 p_cei_information_category => 'IN_NOMINATION_DETAILS',
63 p_cei_information3 => p_nomination_type,
64 p_cei_information2 => p_percent_share,
65 p_cei_information4 => p_nomination_change_reason ,
66 p_cei_attribute_category => p_cei_attribute_category,
67 p_cei_attribute1 => p_cei_attribute1 ,
68 p_cei_attribute2 => p_cei_attribute2,
69 p_cei_attribute3 => p_cei_attribute3,
70 p_cei_attribute4 => p_cei_attribute4,
71 p_cei_attribute5 => p_cei_attribute5,
72 p_cei_attribute6 => p_cei_attribute6,
73 p_cei_attribute7 => p_cei_attribute7,
74 p_cei_attribute8 => p_cei_attribute8,
75 p_cei_attribute9 => p_cei_attribute9,
76 p_cei_attribute10 => p_cei_attribute10,
77 p_cei_attribute11 => p_cei_attribute11,
78 p_cei_attribute12 => p_cei_attribute12,
79 p_cei_attribute13 => p_cei_attribute13,
80 p_cei_attribute14 => p_cei_attribute14,
81 p_cei_attribute15 => p_cei_attribute15,
82 p_cei_attribute16 => p_cei_attribute16,
83 p_cei_attribute17 => p_cei_attribute17,
84 p_cei_attribute18 => p_cei_attribute18,
85 p_cei_attribute19 => p_cei_attribute19,
86 p_cei_attribute20 => p_cei_attribute20,
87 p_contact_extra_info_id => p_contact_extra_info_id,
88 p_object_version_number => p_object_version_number,
89 p_effective_start_date => p_effective_start_date,
90 p_effective_end_date => p_effective_end_date);
91
92 if g_trace then
93 hr_utility.set_location('Leaving: '||l_proc, 20);
94 end if ;
95
96 END create_in_contact_extra_info;
97
98 -- ----------------------------------------------------------------------------
99 -- |-----------------------< update_in_contact_extra_info >----------------------|
100 -- ----------------------------------------------------------------------------
101
102 PROCEDURE update_in_contact_extra_info
103 (p_validate IN boolean DEFAULT false,
104 p_effective_date IN date,
105 p_datetrack_update_mode IN VARCHAR2,
106 p_contact_relationship_id IN NUMBER DEFAULT hr_api.g_number,
107 p_information_type IN VARCHAR2 DEFAULT hr_api.g_varchar2,
108 p_nomination_type IN VARCHAR2 DEFAULT hr_api.g_varchar2,
109 p_percent_share IN VARCHAR2 DEFAULT hr_api.g_varchar2,
110 p_nomination_change_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2,
111 p_cei_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
112 p_cei_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
113 p_cei_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
114 p_cei_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
115 p_cei_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
116 p_cei_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
117 p_cei_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
118 p_cei_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
119 p_cei_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
120 p_cei_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
121 p_cei_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
122 p_cei_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
123 p_cei_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
124 p_cei_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
125 p_cei_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
126 p_cei_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
127 p_cei_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
128 p_cei_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
129 p_cei_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
130 p_cei_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
131 p_cei_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
132 p_contact_extra_info_id IN number,
133 p_object_version_number IN OUT NOCOPY number,
134 p_effective_start_date OUT NOCOPY DATE,
135 p_effective_end_date OUT NOCOPY DATE
136 )
137 AS
138 --
139 -- Declare cursors and local variables
140 --
141 l_proc VARCHAR2(72);
142 BEGIN
143 l_proc := g_package||'update_in_contact_extra_info';
144 g_trace := hr_utility.debug_enabled ;
145
146 if g_trace then
147 hr_utility.set_location('Entering: '||l_proc, 10);
148 end if ;
149
150 hr_contact_extra_info_api.update_contact_extra_info(
151 p_validate => p_validate,
152 p_effective_date => p_effective_date,
153 p_contact_relationship_id => p_contact_relationship_id,
154 p_datetrack_update_mode => p_datetrack_update_mode,
155 p_information_type => p_information_type,
156 p_cei_information_category => 'IN_NOMINATION_DETAILS',
157 p_cei_information3 => p_nomination_type,
158 p_cei_information2 => p_percent_share,
159 p_cei_information4 => p_nomination_change_reason ,
160 p_cei_attribute_category => p_cei_attribute_category,
161 p_cei_attribute1 => p_cei_attribute1 ,
162 p_cei_attribute2 => p_cei_attribute2,
163 p_cei_attribute3 => p_cei_attribute3,
164 p_cei_attribute4 => p_cei_attribute4,
165 p_cei_attribute5 => p_cei_attribute5,
166 p_cei_attribute6 => p_cei_attribute6,
167 p_cei_attribute7 => p_cei_attribute7,
168 p_cei_attribute8 => p_cei_attribute8,
169 p_cei_attribute9 => p_cei_attribute9,
170 p_cei_attribute10 => p_cei_attribute10,
171 p_cei_attribute11 => p_cei_attribute11,
172 p_cei_attribute12 => p_cei_attribute12,
173 p_cei_attribute13 => p_cei_attribute13,
174 p_cei_attribute14 => p_cei_attribute14,
175 p_cei_attribute15 => p_cei_attribute15,
176 p_cei_attribute16 => p_cei_attribute16,
177 p_cei_attribute17 => p_cei_attribute17,
178 p_cei_attribute18 => p_cei_attribute18,
179 p_cei_attribute19 => p_cei_attribute19,
180 p_cei_attribute20 => p_cei_attribute20,
181 p_contact_extra_info_id => p_contact_extra_info_id,
182 p_object_version_number => p_object_version_number,
183 p_effective_start_date => p_effective_start_date,
184 p_effective_end_date => p_effective_end_date);
185 if g_trace then
186 hr_utility.set_location('Leaving: '||l_proc, 20);
187 end if ;
188 END update_in_contact_extra_info;
189 END hr_in_contact_extra_info_api;