[Home] [Help]
121: l_current_user_id integer;
122: l_object_version_number number;
123: --
124: Begin
125: hr_utility.set_location('Entering:'||l_proc, 5);
126: --
127: -- Because we are updating a row we must get the next object
128: -- version number.
129: --
131: ame_itc_shd.get_object_version_number
132: (p_item_class_id => p_item_class_id
133: );
134: --
135: hr_utility.set_location(l_proc, 10);
136: --
137: l_current_user_id := fnd_global.user_id;
138: --
139: -- Update the specified datetrack row setting the effective
150: and nvl(t.end_date - (1/86400),sysdate);
151: --
152: --
153: p_object_version_number := l_object_version_number;
154: hr_utility.set_location(' Leaving:'||l_proc, 15);
155: --
156: End upd_effective_end_date;
157: --
158: -- ----------------------------------------------------------------------------
190: --
191: --
192: --
193: Begin
194: hr_utility.set_location('Entering:'||l_proc, 5);
195: --
196: -- Ensure that all the mandatory arguments are not null
197: --
198: hr_api.mandatory_arg_error(p_api_name => l_proc
261: p_validation_start_date := p_effective_date;
262: p_validation_end_date := p_effective_date;
263: end if;
264: --
265: hr_utility.set_location(' Leaving:'||l_proc, 30);
266: --
267: -- We need to trap the ORA LOCK exception
268: --
269: Exception