PACKAGE: APPS.PQH_RANKING

Source

1 PACKAGE pqh_ranking AUTHID CURRENT_USER AS
2 /* $Header: pqrnkpkg.pkh 120.0 2005/05/29 02:36:50 appldev noship $ */
3 --
4 --
5  FUNCTION  is_workflow_enabled ( p_pgm_id in number) return varchar2;
6 --
7  PROCEDURE get_pgi_info (
8            p_pgm_id in number
9            ,p_workflow_enabled out nocopy varchar2
10            ,p_rank_enabled out nocopy varchar2
11            ,p_handle_duplicate out nocopy varchar2
12            ,p_group_score  out nocopy varchar2
13            ,p_result out nocopy varchar2);
14 --
15  PROCEDURE compute_total_score (
16        p_benefit_action_id in number
17       ,p_module         in varchar2
18       ,p_per_in_ler_id  in number
19       ,p_person_id      in number
20       ,p_effective_date in date
21       );
22 --
23 --
24  PROCEDURE assign_ranks_for_CWB (
25         p_benefit_action_id     IN NUMBER) ;
26 --
27  FUNCTION get_criteria_name (
28         p_tab_short_name in varchar2) RETURN VARCHAR2;
29 --
30 PROCEDURE compute_rank_for_GSP (
31           errbuf              out nocopy VARCHAR2,
32           retcode             out nocopy NUMBER,
33           p_business_group_id in NUMBER,
34           p_pgm_id            in NUMBER,
35           p_pl_id             in NUMBER,
36           p_process_dt_start  in VARCHAR2,
37           p_process_dt_end    in VARCHAR2,
38           p_benefit_action_id in NUMBER,
39           p_audit_log         in VARCHAR2,
40           p_commit_data       in VARCHAR2,
41           p_rank_wf_pending   in VARCHAR2
42          );
43 --
44 END; -- Package Specification PQH_RANKING