1 PACKAGE pqh_rank_utility AS
2 /* $Header: pqrnkutl.pkh 120.2 2005/06/17 14:36:06 nsanghal noship $ */
3 --
4 --
5 function is_ranking_enabled_for_txn(
6 p_copy_entity_txn_id in number )
7 return varchar2 ;
8
9
10 function get_ben_action_id(
11 p_per_in_ler_id in number
12 ,p_pgm_id in number
13 ,p_pl_id in number )
14 return number;
15
16 procedure update_proposed_rank (
17 p_proposed_rank in number
18 ,p_assignment_id in number
19 ,p_life_event_dt in date
20 ,p_pgm_id in number
21 ,p_pl_id in number );
22
23 procedure update_proposed_rank (
24 p_proposed_rank in number
25 ,p_per_in_ler_id in number
26 ,p_pgm_id in number
27 ,p_pl_id in number );
28
29 function get_rank (
30 p_rank_type in varchar2
31 ,p_per_in_ler_id in number
32 ,p_pgm_id in number
33 ,p_pl_id in number )
34 return number;
35
36 function get_total_score(
37 p_per_in_ler_id in number
38 ,p_pgm_id in number
39 ,p_pl_id in number )
40 return number;
41
42 function get_grade_ladder_option (
43 p_pgm_id in number
44 ,p_option in varchar2)
45 return Varchar2 ;
46
47 function is_ranking_enabled_for_bg (
48 p_business_group_id in number)
49 return Varchar2 ;
50
51 function is_ranking_enabled_for_person(p_person_id in number
52 ,p_business_group_id in number
53 ,p_effective_date in date)
54 return varchar2;
55
56 -- ---------------------------------------------------------------
57 -- ---- Added by Nischal to Initate workflow from approval UI ----
58 -- ---------- <on_approval_init_workflow > -----------------------
59 -- ---------------------------------------------------------------
60 procedure on_approval_init_workflow(
61 p_elctbl_chc_id in number
62 ,p_pgm_id in number
63 ,p_person_id in number
64 ,p_person_name in varchar2
65 ,p_prog_dt in date
66 ,p_sal_chg_dt in date
67 ,p_comments in varchar2
68 ,p_ameTranType in varchar2
69 ,p_ameAppId in varchar2
70 ,p_itemType in varchar2
71 ,p_processName in varchar2
72 ,p_functionName in varchar2
73 ,p_currentUser in varchar2
74 ,p_supervisorId in number );
75
76 End pqh_rank_utility;