PACKAGE: APPS.HRI_APL_DGNSTC_WRKFC

Source

1 PACKAGE hri_apl_dgnstc_wrkfc AS
2 /* $Header: hriadgwf.pkh 120.2 2006/12/05 09:29:18 smohapat noship $ */
3 
4 FUNCTION get_missing_rates_sql(p_parameter_value   IN VARCHAR2)
5      RETURN VARCHAR2;
6 
7 FUNCTION get_user_not_in_suph
8      RETURN VARCHAR2;
9 
10 FUNCTION get_user_unassigned
11      RETURN VARCHAR2;
12 
13 FUNCTION get_no_asg_proj_end_date
14      RETURN VARCHAR2;
15 
16 FUNCTION get_mul_asg_breakup
17      RETURN VARCHAR2;
18 
19 FUNCTION get_total_hd
20      RETURN VARCHAR2;
21 
22 FUNCTION get_user_valid_setup
23      RETURN VARCHAR2;
24 
25 FUNCTION get_total_sal
26      RETURN VARCHAR2;
27 
28 FUNCTION get_no_review
29      RETURN VARCHAR2;
30 
31 FUNCTION get_total_asg
32      RETURN VARCHAR2;
33 
34 FUNCTION get_total_asg_by_asgtype
35      RETURN VARCHAR2;
36 
37 FUNCTION get_no_sprvsr
38      RETURN VARCHAR2;
39 
40 FUNCTION get_mul_asg
41      RETURN VARCHAR2;
42 
43 FUNCTION get_term_sprvsr
44      RETURN VARCHAR2;
45 
46 FUNCTION get_no_sal
47      RETURN VARCHAR2;
48 
49 FUNCTION get_dbl_cnt_abv
50      RETURN VARCHAR2;
51 
52 FUNCTION get_smlt_abv
53      RETURN VARCHAR2;
54 
55 FUNCTION get_no_abv
56      RETURN VARCHAR2;
57 
58 FUNCTION get_no_term_rsn
59      RETURN VARCHAR2;
60 
61 FUNCTION get_sup_loop_details
62      RETURN VARCHAR2;
63 
64 FUNCTION get_incomplete_req_sets
65      RETURN VARCHAR2;
66 
67 FUNCTION get_vac_wtht_mngrs
68      RETURN VARCHAR2;
69 
70 FUNCTION get_applcnt_wtht_vac
71      RETURN VARCHAR2;
72 
73 FUNCTION get_user_linemgr_info
74      RETURN VARCHAR2;
75 
76 FUNCTION get_user_anlstmgr_info
77      RETURN VARCHAR2;
78 
79 FUNCTION get_user_deptmgr_info
80      RETURN VARCHAR2;
81 
82 FUNCTION get_user_orgmgr_info
83      RETURN VARCHAR2;
84 
85 FUNCTION get_unassg_gndr_info
86      RETURN VARCHAR2;
87 
88 END hri_apl_dgnstc_wrkfc;