[Home] [Help]
30: l_proc varchar2(72) := g_package||'set_translation_globals';
31: --
32: BEGIN
33: --
34: hr_utility.set_location('Entering:'||l_proc,5);
35: --
36: g_business_group_id := p_business_group_id;
37:
38: --
35: --
36: g_business_group_id := p_business_group_id;
37:
38: --
39: hr_utility.set_location('Leaving:'||l_proc,10);
40: --
41: END set_translation_globals;
42: --
43: -- ----------------------------------------------------------------------------
78:
79: --
80: BEGIN
81: --
82: hr_utility.set_location('Entering:'||l_proc,5);
83: --
84:
85: check_unique_name
86: ( p_activity_id => activity_id
88: , p_language => language
89: , p_name => name
90: );
91: --
92: hr_utility.set_location('Leaving:'||l_proc,10);
93: --
94: END Validate_translation;
95: --
96: -- ----------------------------------------------------------------------------
125: and adt.language = p_language ;
126: --
127: Begin
128: --
129: hr_utility.set_location('Entering:'|| v_proc, 5);
130: --
131: Open csr_unique_name;
132: fetch csr_unique_name into v_exists;
133: --
146: end if;
147: --
148: close csr_unique_name;
149: --
150: hr_utility.set_location(' Leaving:'|| v_proc, 10);
151: --
152: End check_unique_name;
153: --
154: -- ----------------------------------------------------------------------------
175: l_business_group_id ota_activity_definitions.business_group_id%TYPE ;
176: --
177: Begin
178: --
179: hr_utility.set_location('Entering:'||l_proc,5);
180: --
181: open csr_adtbsg ;
182: --
183: fetch csr_adtbsg into l_business_group_id ;
190: ,p_language => p_rec.language
191: ,p_name => p_rec.name );
192:
193: --
194: hr_utility.set_location('Leaving:'||l_proc,10);
195: --
196: End check_unique_name ;
197: --
198: --
222: l_legislation_code varchar2(150);
223: --
224: begin
225: --
226: hr_utility.set_location('Entering:'|| l_proc, 10);
227: --
228: -- Ensure that all the mandatory parameter are not null
229: --
230: hr_api.mandatory_arg_error
263: --
264: hr_api.set_legislation_context(l_legislation_code);
265: end if;
266: --
267: hr_utility.set_location(' Leaving:'|| l_proc, 20);
268: --
269: end set_security_group_id;
270: --
271: -- ---------------------------------------------------------------------------
293: l_proc varchar2(72) := g_package||'return_legislation_code';
294: --
295: Begin
296: --
297: hr_utility.set_location('Entering:'|| l_proc, 10);
298: --
299: -- Ensure that all the mandatory parameter are not null
300: --
301: hr_api.mandatory_arg_error
314: -- call to this function. Just return the value in the global
315: -- variable.
316: --
317: l_legislation_code := ota_adt_bus.g_legislation_code;
318: hr_utility.set_location(l_proc, 20);
319: else
320: --
321: -- The ID is different to the last call to this function
322: -- or this is the first call to this function.
331: close csr_leg_code;
332: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
333: fnd_message.raise_error;
334: end if;
335: hr_utility.set_location(l_proc,30);
336: --
337: -- Set the global variables so the values are
338: -- available for the next call to this function.
339: --
341: ota_adt_bus.g_activity_id := p_activity_id;
342: ota_adt_bus.g_language := p_language;
343: ota_adt_bus.g_legislation_code := l_legislation_code;
344: end if;
345: hr_utility.set_location(' Leaving:'|| l_proc, 40);
346: return l_legislation_code;
347: end return_legislation_code;
348: --
349: -- ----------------------------------------------------------------------------
409: --
410: l_proc varchar2(72) := g_package||'insert_validate';
411: --
412: Begin
413: hr_utility.set_location('Entering:'||l_proc, 5);
414: --
415: -- Call all supporting business operations
416: --
417:
420: -- Validate Dependent Attributes
421: check_unique_name(p_rec,p_activity_id) ;
422: --
423: --
424: hr_utility.set_location(' Leaving:'||l_proc, 10);
425: End insert_validate;
426: --
427: -- ----------------------------------------------------------------------------
428: -- |---------------------------< update_validate >----------------------------|
434: --
435: l_proc varchar2(72) := g_package||'update_validate';
436: --
437: Begin
438: hr_utility.set_location('Entering:'||l_proc, 5);
439: --
440: -- Call all supporting business operations
441: --
442: --
450: ,p_rec => p_rec
451: );
452: --
453: --
454: hr_utility.set_location(' Leaving:'||l_proc, 10);
455: End update_validate;
456: --
457: -- ----------------------------------------------------------------------------
458: -- |---------------------------< delete_validate >----------------------------|
463: --
464: l_proc varchar2(72) := g_package||'delete_validate';
465: --
466: Begin
467: hr_utility.set_location('Entering:'||l_proc, 5);
468: --
469: -- Call all supporting business operations
470: --
471: hr_utility.set_location(' Leaving:'||l_proc, 10);
467: hr_utility.set_location('Entering:'||l_proc, 5);
468: --
469: -- Call all supporting business operations
470: --
471: hr_utility.set_location(' Leaving:'||l_proc, 10);
472: End delete_validate;
473: --
474: --
475: