DBA Data[Home] [Help]

PACKAGE: APPS.PER_US_VALIDATE_AEI

Source


1 Package per_us_validate_aei AUTHID CURRENT_USER as
2 /* $Header: peusaeiv.pkh 120.0 2005/05/31 22:36:08 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-----------------------< chk_for_duplicate_rows >-------------------------|
6 -- ----------------------------------------------------------------------------
7 -- Description:
8 --   Verify that the information entered is not duplicated for a multi record
9 --   type extra information.
10 --
11 -- Pre Conditions:
12 --
13 --
14 -- In Parameters:
15 --   assignment_id, information_type, aei_information1, aei_information2
16 --
17 -- Post Success:
18 --   Processing continues.
19 --
20 -- Post Failure:
21 --   An application error will be raised and processing is terminated.
22 --
23 -- Access Status:
24 --   Internal Table Handler Use Only.
25 --
26 --
27   Procedure chk_for_duplicate_rows (p_assignment_id    number,
28                                     p_information_type varchar2,
29                                     p_aei_information1 varchar2,
30                                     p_aei_information2 varchar2,
31                                     p_aei_information3 varchar2);
32 --
33 --
34 end per_us_validate_aei;