1 package hr_tca_utility AUTHID CURRENT_USER as
2 /* $Header: petcautl.pkh 115.2 2004/06/21 16:02:00 tpapired noship $ */
3
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------< get_person_id >-------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This procedure returns the person id for a given party id. If multiple
11 -- persons match to the given party_id, then PERSON ID is returned in the
12 -- following order of preference
13 -- EMPLOYEE - CONTINGENT WORKER - APPLICANT - OTHERS
14 --
15 -- This procedure also returns the value for p_matches depending on number
16 -- of matches exist for the given party_id.
17 --
18 -- If NO person matches to the party, p_matches is set to 'N'
19 -- If ONE person matches to the party, p_matches is set to 'Y'
20 -- If MULITIPLE persons match to the party, p_matches is set to 'W'
21 --
22 -- Prerequisites:
23 -- A valid record should be existing in per_all_people_f table for the
24 -- given party id and effective date
25 --
26 -- In Parameters:
27 -- Name Reqd Type Description
28 -- p_party_id Yes Number Identifies the party
29 -- p_effective_date No Date Effective date
30 --
31 -- This procedure sets the following Out Parameters:
32 --
33 -- p_person_id Yes Number If a match exists for the party, then set to the
34 -- Person record identified by the party.
35 -- p_matches Yes varchar If only one person record matches to the party, then set to 'Y'
36 -- if more than one person record matches, then set to 'W'
37 -- and if no person record matches, then set to 'N'
38 --
39 -- Post Success:
40 -- A valid Person id is returned if there is a match exists. p_matches
41 -- returns one of the following values based on number of matches
42 -- found for the party_id.
43 -- 'Y' - one match
44 -- 'N' - no matches
45 -- 'W' - multiple matches
46 --
47 --
48 -- Post Failure:
49 -- No person id is returned (Null person_id)
50 -- p_matches is set to 'N'
51 --
52 -- Access Status:
53 -- Internal development use only.
54 --
55 -- {End Of Comments}
56 --
57 -- ---------------------------------------------------------------------------
58 PROCEDURE get_person_id
59 (p_party_id in number
60 ,p_effective_date in date default sysdate
61 ,p_person_id out nocopy number
62 ,p_matches out nocopy varchar
63 ) ;
64 end hr_tca_utility;
65 --