1 PACKAGE UMX_PROXY_USER_PVT as
2 /*$Header: UMXVPRXS.pls 120.1 2005/07/02 04:25:17 appldev noship $*/
3
4 /**
5 * Function : GET_PERSON_ID
6 * Type : Private
7 * Description : Retrieve person_id from party_id
8 * Parameters :
9 * input parameters
10 * @param
11 * p_party_id
12 * description: Party Id of the person
13 * required : Y
14 * validation : Must be a valid party_id
15 * default : null
16 * output parameters
17 * @return : Person Id of the user
18 * Errors : possible errors raised by this API
19 * Other Comments :
20 */
21 function GET_PERSON_ID (p_party_id in hz_parties.party_id%type) return number;
22
23 /**
24 * Function : GET_PHONE_NUMBER
25 * Type : Private
26 * Description : Retrieve phone number
27 * Parameters :
28 * input parameters
29 * @param
30 * p_person_id
31 * description: Person Id of the person
32 * required : Y
33 * validation : Must be a valid person_id
34 * default : null
35 * output parameters
36 * @return : Phone Number of the person
37 * Errors : possible errors raised by this API
38 * Other Comments :
39 */
40 function GET_PHONE_NUMBER(p_person_id in per_all_people_f.person_id%type) return varchar2;
41
42 /**
43 * Function : GET_PHONE_NUMBER
44 * Type : Private
45 * Description : Retrieve phone number
46 * Parameters :
47 * input parameters
48 * @param
49 * p_person_id
50 * description: Person Id of the person
51 * required : Y
52 * validation : Must be a valid person_id
53 * default : null
54 * output parameters
55 * @return : Phone Number of the person
56 * Errors : possible errors raised by this API
57 * Other Comments :
58 */
59 procedure GET_EMP_DATA(p_person_id in per_all_people_f.person_id%type,
60 x_phone_number out NOCOPY PER_PHONES.PHONE_NUMBER%TYPE ,
61 x_job_title out NOCOPY PER_JOBS_VL.NAME%TYPE
62 );
63
64
65
66
67 end UMX_PROXY_USER_PVT;