PACKAGE: APPS.HRI_APL_DGNSTC_OPEN_ENRT

Source

1 PACKAGE hri_apl_dgnstc_open_enrt AUTHID CURRENT_USER AS
2 /* $Header: hriadgoe.pkh 120.0 2005/10/10 08:29:41 abparekh noship $ */
3 --
4    FUNCTION get_pgm_for_open_le
5       RETURN VARCHAR2;
6 
7 --
8    FUNCTION get_actn_itm_for_open_le
9       RETURN VARCHAR2;
10 
11 --
12    FUNCTION get_ben_user_valid_setup
13       RETURN VARCHAR2;
14 
15 --
16    FUNCTION get_pgm_witn_no_elctbl_chc
17       RETURN VARCHAR2;
18 
19 --
20    FUNCTION get_pgm_with_no_actn_item
21       RETURN VARCHAR2;
22 
23 --
24    FUNCTION get_emp_with_open_mnl_ler
25       RETURN VARCHAR2;
26 
27 --
28    FUNCTION get_pln_with_no_opt
29       RETURN VARCHAR2;
30 
31 --
32    FUNCTION get_pgm_with_rqd_actn_item
33       RETURN VARCHAR2;
34 
35 --
36    FUNCTION get_pgm_with_inactive_status
37       RETURN VARCHAR2;
38 --
39    FUNCTION pgm_has_pln_with_rqd_actn_item (cv_pgm_id                   number,
40                                             cv_end_date                 date,
41                                             cv_dpnt_dsgn_lvl_cd         varchar2
42                                             )
43       RETURN VARCHAR2;
44 --
45 END hri_apl_dgnstc_open_enrt;