1 PACKAGE per_cn_shared_info AUTHID CURRENT_USER AS
2 /* $Header: pecnshin.pkh 120.1 2010/05/27 18:04:35 sidsaxen noship $ */
3
4 FUNCTION get_lookup_meaning(p_code IN VARCHAR2, p_type IN VARCHAR2)
5 RETURN VARCHAR2;
6
7 Function cn_get_doc_details
8 (p_person_id IN NUMBER,
9 p_date IN DATE,
10 p_type IN VARCHAR2
11 )
12 RETURN VARCHAR2 ;
13
14 Function get_parent_org_id
15 (p_organization_id IN NUMBER
16 )
17 RETURN NUMBER ;
18
19 Function get_cadre_job_details(p_person_id IN NUMBER , p_date IN DATE)
20 return VARCHAR2;
21
22 Function get_tech_post_details(p_person_id IN NUMBER , p_date IN DATE)
23 return VARCHAR2;
24
25 END per_cn_shared_info;