[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
87: --
88: hr_api.set_legislation_context(l_legislation_code);
89: end if;
90: --
91: hr_utility.set_location(' Leaving:'|| l_proc, 20);
92: --
93: end set_security_group_id;
94: --
95: -- ---------------------------------------------------------------------------
116: l_proc varchar2(72) := g_package||'return_veh_legislation_code';
117: --
118: Begin
119: --
120: hr_utility.set_location('Entering:'|| l_proc, 10);
121: --
122: -- Ensure that all the mandatory parameter are not null
123: --
124: hr_api.mandatory_arg_error
134: -- call to this function. Just return the value in the global
135: -- variable.
136: --
137: l_legislation_code := pqp_vri_bus.g_legislation_code;
138: hr_utility.set_location(l_proc, 20);
139: ELSE
140: --
141: -- The ID is different to the last call to this function
142: -- or this is the first call to this function.
151: CLOSE csr_leg_code;
152: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
153: fnd_message.raise_error;
154: END IF;
155: hr_utility.set_location(l_proc,30);
156: --
157: -- Set the global variables so the values are
158: -- available for the next call to this function.
159: --
160: CLOSE csr_leg_code;
161: pqp_vri_bus.g_vehicle_repository_id := g_vehicle_repository_id;
162: pqp_vri_bus.g_legislation_code := l_legislation_code;
163: END IF;
164: hr_utility.set_location(' Leaving:'|| l_proc, 40);
165: return l_legislation_code;
166: END return_veh_legislation_code;
167:
168: --
190: l_proc varchar2(72) := g_package||'return_legislation_code';
191: --
192: Begin
193: --
194: hr_utility.set_location('Entering:'|| l_proc, 10);
195: --
196: -- Ensure that all the mandatory parameter are not null
197: --
198: hr_api.mandatory_arg_error
208: -- call to this function. Just return the value in the global
209: -- variable.
210: --
211: l_legislation_code := pqp_vri_bus.g_legislation_code;
212: hr_utility.set_location(l_proc, 20);
213: else
214: --
215: -- The ID is different to the last call to this function
216: -- or this is the first call to this function.
225: close csr_leg_code;
226: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
227: fnd_message.raise_error;
228: end if;
229: hr_utility.set_location(l_proc,30);
230: --
231: -- Set the global variables so the values are
232: -- available for the next call to this function.
233: --
235: pqp_vri_bus.g_vehicle_repository_id := p_vehicle_repository_id;
236: pqp_vri_bus.g_legislation_code := l_legislation_code;
237: end if;
238:
239: hr_utility.set_location(' Leaving:'|| l_proc, 40);
240: return l_legislation_code;
241: end return_legislation_code;
242: --
243: -- ----------------------------------------------------------------------------
274: --
275: l_proc varchar2(72) := g_package || 'chk_ddf';
276: --
277: begin
278: hr_utility.set_location('Entering:'||l_proc,10);
279: --
280: if ((p_rec.veh_repos_extra_info_id is not null) and (
281: nvl(pqp_vri_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
282: nvl(p_rec.information_type, hr_api.g_varchar2) or
415: ,p_attribute30_value => p_rec.vrei_information30
416: );
417: end if;
418: --
419: hr_utility.set_location(' Leaving:'||l_proc,20);
420: end chk_ddf;
421: --
422: -- ----------------------------------------------------------------------------
423: -- |------------------------------< chk_df >----------------------------------|
453: --
454: l_proc varchar2(72) := g_package || 'chk_df';
455: --
456: begin
457: hr_utility.set_location('Entering:'||l_proc,10);
458: --
459: if ((p_rec.veh_repos_extra_info_id is not null) and (
460: nvl(pqp_vri_shd.g_old_rec.vrei_attribute_category, hr_api.g_varchar2) <>
461: nvl(p_rec.vrei_attribute_category, hr_api.g_varchar2) or
552: ,p_attribute20_value => p_rec.vrei_attribute20
553: );
554: end if;
555: --
556: hr_utility.set_location(' Leaving:'||l_proc,20);
557: end chk_df;
558: --
559: -- ----------------------------------------------------------------------------
560: -- |-----------------------< chk_non_updateable_args >------------------------|
618: --
619: l_proc varchar2(72) := g_package||'insert_validate';
620: --
621: Begin
622: hr_utility.set_location('Entering:'||l_proc, 5);
623: --
624: -- Call all supporting business operations
625: --
626: --
637: pqp_vri_bus.chk_ddf(p_rec);
638: --
639: pqp_vri_bus.chk_df(p_rec);
640: --
641: hr_utility.set_location(' Leaving:'||l_proc, 10);
642: End insert_validate;
643: --
644: -- ----------------------------------------------------------------------------
645: -- |---------------------------< update_validate >----------------------------|
650: --
651: l_proc varchar2(72) := g_package||'update_validate';
652: --
653: Begin
654: hr_utility.set_location('Entering:'||l_proc, 5);
655: --
656: -- Call all supporting business operations
657: --
658: --
673: pqp_vri_bus.chk_ddf(p_rec);
674: --
675: pqp_vri_bus.chk_df(p_rec);
676: --
677: hr_utility.set_location(' Leaving:'||l_proc, 10);
678: End update_validate;
679: --
680: -- ----------------------------------------------------------------------------
681: -- |---------------------------< delete_validate >----------------------------|
686: --
687: l_proc varchar2(72) := g_package||'delete_validate';
688: --
689: Begin
690: hr_utility.set_location('Entering:'||l_proc, 5);
691: --
692: -- Call all supporting business operations
693: --
694: hr_utility.set_location(' Leaving:'||l_proc, 10);
690: hr_utility.set_location('Entering:'||l_proc, 5);
691: --
692: -- Call all supporting business operations
693: --
694: hr_utility.set_location(' Leaving:'||l_proc, 10);
695: End delete_validate;
696: --
697: end pqp_vri_bus;