[Home] [Help]
47: l_legislation_code varchar2(150);
48: --
49: begin
50: --
51: hr_utility.set_location('Entering:'|| l_proc, 10);
52: --
53: -- Ensure that all the mandatory parameter are not null
54: --
55: hr_api.mandatory_arg_error
94: --
95: hr_api.set_legislation_context(l_legislation_code);
96: end if;
97: --
98: hr_utility.set_location(' Leaving:'|| l_proc, 20);
99: --
100: end set_security_group_id;
101: --
102: -- ---------------------------------------------------------------------------
132: l_proc varchar2(72) := g_package||'return_legislation_code';
133: --
134: Begin
135: --
136: hr_utility.set_location('Entering:'|| l_proc, 10);
137: --
138: -- Ensure that all the mandatory parameter are not null
139: --
140: hr_api.mandatory_arg_error
157: -- call to this function. Just return the value in the global
158: -- variable.
159: --
160: l_legislation_code := ff_fcu_bus.g_legislation_code;
161: hr_utility.set_location(l_proc, 20);
162: else
163: --
164: -- The ID is different to the last call to this function
165: -- or this is the first call to this function.
174: close csr_leg_code;
175: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
176: fnd_message.raise_error;
177: end if;
178: hr_utility.set_location(l_proc,30);
179: --
180: -- Set the global variables so the values are
181: -- available for the next call to this function.
182: --
184: ff_fcu_bus.g_function_id := p_function_id;
185: ff_fcu_bus.g_sequence_number := p_sequence_number;
186: ff_fcu_bus.g_legislation_code := l_legislation_code;
187: end if;
188: hr_utility.set_location(' Leaving:'|| l_proc, 40);
189: return l_legislation_code;
190: end return_legislation_code;
191: --
192: -- ----------------------------------------------------------------------------
468: l_business_group_id ff_functions.business_group_id%type;
469: l_legislation_code ff_functions.legislation_code%type;
470: --
471: Begin
472: hr_utility.set_location('Entering:'||l_proc, 5);
473: --
474: -- Call all supporting business operations
475: --
476: -----------------------------------------------------------------------------
496: chk_unique(p_function_id => p_rec.function_id
497: ,p_context_id => p_rec.context_id
498: ,p_sequence_number => p_rec.sequence_number);
499:
500: hr_utility.set_location(' Leaving:'||l_proc, 10);
501:
502: End insert_validate;
503: --
504: -- ----------------------------------------------------------------------------
518: l_legislation_code ff_functions.legislation_code%type;
519: l_proc varchar2(72) := g_package||'update_validate';
520: --
521: Begin
522: hr_utility.set_location('Entering:'||l_proc, 5);
523: --
524: -- Call all supporting business operations
525: --
526: -----------------------------------------------------------------------------
552: (p_rec => p_rec
553: );
554: --
555: --
556: hr_utility.set_location(' Leaving:'||l_proc, 10);
557: End update_validate;
558: --
559: -- ----------------------------------------------------------------------------
560: -- |---------------------------< delete_validate >----------------------------|
573: l_legislation_code ff_functions.legislation_code%type;
574: l_proc varchar2(72) := g_package||'delete_validate';
575: --
576: Begin
577: hr_utility.set_location('Entering:'||l_proc, 5);
578: --
579: -----------------------------------------------------------------------------
580: chk_function_id(p_function_id => p_rec.function_id);
581: -----------------------------------------------------------------------------
590: --
591: -- Validate Dependent Attributes
592: --
593: --
594: hr_utility.set_location(' Leaving:'||l_proc, 10);
595: End delete_validate;
596: --
597: end ff_fcu_bus;