PACKAGE: APPS.PERCOMPSTATUS

Source

1 Package PerCompStatus AUTHID CURRENT_USER AS
2 /* $Header: hrcpstats.pkh 120.0 2005/05/31 23:56:09 appldev noship $*/
3 g_date_format constant varchar2(15) := 'RRRR-MM-DD';
4 FUNCTION Get_Competence_Status
5     (p_competence_id          in varchar2
6     ,p_competence_element_id  in varchar2
7     ,p_item_type               IN VARCHAR2 DEFAULT null
8     ,p_item_key                IN VARCHAR2 DEFAULT null
9     ,p_activity_id             IN VARCHAR2 DEFAULT null
10     ,p_eff_date               in date default trunc(sysdate)
11     ) Return varchar2;
12 
13 FUNCTION Get_Competence_Status
14     (p_item_type       in varchar2
15     ,p_item_key        IN varchar2
16     ,p_activity_id     IN varchar2
17     ,p_competence_id   in number
18     ,p_competence_element_id IN NUMBER DEFAULT null
19     ,p_person_id             IN number
20     ,p_eff_date                in date default trunc(sysdate)
21     ) return VARCHAR2;
22 
23 
24 function get_status_meaning_and_id
25     (p_competence_id         in varchar2
26     ,p_competence_element_id in varchar2
27     ,p_item_type               IN VARCHAR2 DEFAULT null
28     ,p_item_key                IN VARCHAR2 DEFAULT null
29     ,p_activity_id             IN VARCHAR2 DEFAULT null
30     ,p_eff_date              in date default trunc(sysdate))
31     RETURN varchar2;
32 
33 Function IsAllCompAchieved
34      ( p_qualification_type_id IN number
35      , p_person_id             IN number)
36      RETURN varchar2;
37 
38 END PerCompStatus;