1 PACKAGE per_jp_contact_relationships AS
2 /* $Header: pejpcrlh.pkh 120.0 2005/05/31 10:50:19 appldev noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------------------< chk_si_itax_flag >--------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start Of Comments}
7 --
8 -- Description:
9 -- This procedure verifies there is only 1 row that has 'Y' in si_itax_flag
10 -- for a person and a contact person.
11 --
12 -- Prerequisites:
13 -- None.
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 -- p_contact_relationship_id Yes NUMBER Contact Releationship ID.
18 -- p_person_id Yes NUMBER Person ID.
19 -- p_contact_person_id Yes NUMBER Contact Person ID.
20 -- p_cont_information1 Yes VARCHAR2 Social Insurance and Income
21 -- Tax.
22 --
23 -- Post Success:
24 -- Process continues.
25 --
26 -- Post Failure:
27 -- An application error will be raised and process is terminated.
28 --
29 -- Access Status:
30 -- Internal Table Handler Use Only.
31 --
32 -- {End Of Comments}
33 --
34 PROCEDURE chk_si_itax_flag(
35 p_contact_relationship_id NUMBER DEFAULT NULL,
36 p_person_id NUMBER,
37 p_contact_person_id NUMBER,
38 p_cont_information1 VARCHAR2);
39 --
40 END per_jp_contact_relationships;