PACKAGE: APPS.PQP_GB_PSI_GRADE_CODES

Source

1 PACKAGE PQP_GB_PSI_GRADE_CODES AS
2 --  /* $Header: pqpgbpsigrd.pkh 120.0 2006/04/13 04:59:59 anshghos noship $ */
3 
4 
5 
6 --
7 -- Debug Variables.
8 --
9    g_legislation_code   per_business_groups.legislation_code%TYPE   := 'GB';
10    g_debug              BOOLEAN                      := hr_utility.debug_enabled;
11    g_effective_date     DATE;
12    g_extract_type       VARCHAR2(100);
13 
14    g_proc_name           VARCHAR2(61):= 'PQP_GB_PSI_GRADE_CODES.';
15    g_business_group_id   NUMBER := NULL;
16    g_paypoint            VARCHAR2(5);
17 
18    g_grade_details       per_grades%rowtype;
19 
20 ----------------------------CURSORS ------------------
21 
22   --
23   -- For grade details to be fetched from grade DDFF
24   --
25   CURSOR csr_grade_details
26           (p_business_group_id   NUMBER
27           ,p_grade_id            NUMBER
28           ) IS
29   select *
30   from PER_GRADES
31   where information_category = 'GB_PQP_PENSERV_GRADE_INFO'
32 	and business_group_id = p_business_group_id
33 	and grade_id = p_grade_id;
34 
35 
36 
37   --
38 
39    -- Debug
40    PROCEDURE DEBUG (
41       p_trace_message    IN   VARCHAR2
42      ,p_trace_location   IN   NUMBER DEFAULT NULL
43    );
44 
45    -- Debug_Enter
46    PROCEDURE debug_enter (
47       p_proc_name   IN   VARCHAR2
48      ,p_trace_on    IN   VARCHAR2 DEFAULT NULL
49    );
50 
51    -- Debug_Exit
52    PROCEDURE debug_exit (
53       p_proc_name   IN   VARCHAR2
54      ,p_trace_off   IN   VARCHAR2 DEFAULT NULL
55    );
56 
57    -- Debug Others
58    PROCEDURE debug_others (
59       p_proc_name   IN   VARCHAR2
60      ,p_proc_step   IN   NUMBER DEFAULT NULL
61    );
62 
63 
64 ---
65 ---
66 ---
67   FUNCTION chk_grade_codes_crit
68     (p_business_group_id       IN         NUMBER
69     ,p_grade_id                IN         VARCHAR2
70     )
71   RETURN VARCHAR2;
72 
73 
74 
75   FUNCTION grade_extract_main
76     (p_rule_parameter           IN         VARCHAR2 -- parameter
77     ,p_output                   OUT NOCOPY VARCHAR2
78     )
79   RETURN number;
80 
81   FUNCTION grade_codes_post_processing RETURN VARCHAR2;
82 
83 
84 END PQP_GB_PSI_GRADE_CODES;