DBA Data[Home] [Help]

APPS.UMX_PROXY_USER_PVT dependencies on PER_ALL_PEOPLE_F

Line 40: function GET_PHONE_NUMBER(p_person_id in per_all_people_f.person_id%type) return varchar2;

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

Line 59: procedure GET_EMP_DATA(p_person_id in per_all_people_f.person_id%type,

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: