[Home] [Help]
48: l_legislation_code varchar2(150);
49: --
50: begin
51: --
52: hr_utility.set_location('Entering:'|| l_proc, 10);
53: --
54: -- Ensure that all the mandatory parameter are not null
55: --
56: hr_api.mandatory_arg_error
89: --
90: hr_api.set_legislation_context(l_legislation_code);
91: end if;
92: --
93: hr_utility.set_location(' Leaving:'|| l_proc, 20);
94: --
95: end set_security_group_id;
96: --
97: -- ---------------------------------------------------------------------------
123: l_proc varchar2(72) := g_package||'return_legislation_code';
124: --
125: Begin
126: --
127: hr_utility.set_location('Entering:'|| l_proc, 10);
128: --
129: -- Ensure that all the mandatory parameter are not null
130: --
131: hr_api.mandatory_arg_error
144: -- call to this function. Just return the value in the global
145: -- variable.
146: --
147: l_legislation_code := ota_avt_bus.g_legislation_code;
148: hr_utility.set_location(l_proc, 20);
149: else
150: --
151: -- The ID is different to the last call to this function
152: -- or this is the first call to this function.
161: close csr_leg_code;
162: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
163: fnd_message.raise_error;
164: end if;
165: hr_utility.set_location(l_proc,30);
166: --
167: -- Set the global variables so the values are
168: -- available for the next call to this function.
169: --
171: ota_avt_bus.g_activity_version_id := p_activity_version_id;
172: ota_avt_bus.g_language := p_language;
173: ota_avt_bus.g_legislation_code := l_legislation_code;
174: end if;
175: hr_utility.set_location(' Leaving:'|| l_proc, 40);
176: return l_legislation_code;
177: end return_legislation_code;
178: --
179: -- ----------------------------------------------------------------------------
239: --
240: l_proc varchar2(72) := g_package||'insert_validate';
241: --
242: Begin
243: hr_utility.set_location('Entering:'||l_proc, 5);
244: --
245: -- Call all supporting business operations
246: --
247: --
254: ,p_language => p_rec.language ) ;
255: */
256: --
257: --
258: hr_utility.set_location(' Leaving:'||l_proc, 10);
259: End insert_validate;
260: --
261: -- ----------------------------------------------------------------------------
262: -- |---------------------------< update_validate >----------------------------|
268: --
269: l_proc varchar2(72) := g_package||'update_validate';
270: --
271: Begin
272: hr_utility.set_location('Entering:'||l_proc, 5);
273: --
274: -- Call all supporting business operations
275: --
276: --
288: ,p_rec => p_rec
289: );
290: --
291: --
292: hr_utility.set_location(' Leaving:'||l_proc, 10);
293: End update_validate;
294: --
295: -- ----------------------------------------------------------------------------
296: -- |---------------------------< delete_validate >----------------------------|
301: --
302: l_proc varchar2(72) := g_package||'delete_validate';
303: --
304: Begin
305: hr_utility.set_location('Entering:'||l_proc, 5);
306: --
307: -- Call all supporting business operations
308: --
309: hr_utility.set_location(' Leaving:'||l_proc, 10);
305: hr_utility.set_location('Entering:'||l_proc, 5);
306: --
307: -- Call all supporting business operations
308: --
309: hr_utility.set_location(' Leaving:'||l_proc, 10);
310: End delete_validate;
311: --
312: -- ----------------------------------------------------------------------------
313: -- |-----------------------< set_translation_globals >------------------------|
320: l_proc varchar2(72) := g_package||'set_translation_globals';
321: --
322: BEGIN
323: --
324: hr_utility.set_location('Entering:'||l_proc,5);
325: --
326: g_business_group_id := p_business_group_id;
327: g_activity_id := p_activity_id ;
328:
326: g_business_group_id := p_business_group_id;
327: g_activity_id := p_activity_id ;
328:
329: --
330: hr_utility.set_location('Leaving:'||l_proc,10);
331: --
332: END set_translation_globals;
333: --
334: -- ----------------------------------------------------------------------------
373:
374: --
375: BEGIN
376: --
377: hr_utility.set_location('Entering:'||l_proc,5);
378: --
379: /*
380: check_unique_version_name
381: ( p_activity_version_id => p_activity_version_id
385: , p_version_name => p_version_name
386: );
387: */
388: --
389: hr_utility.set_location('Leaving:'||l_proc,10);
390: --
391: END Validate_translation;
392: --
393: --
436:
437: --
438: Begin
439: --
440: hr_utility.set_location('Entering:'|| v_proc, 5);
441: --
442: if p_business_group_id is null or p_activity_id is null then
443: open get_activity;
444: fetch get_activity into v_business_group_id, v_activity_id ;
465: end if;
466: --
467: close sel_unique_key;
468: --
469: hr_utility.set_location(' Leaving:'|| v_proc, 10);
470: --
471: End check_unique_version_name;
472: --
473: --