PACKAGE: APPS.PQP_GB_GAP_BEN_FORMULAS

Source

1 PACKAGE pqp_gb_gap_ben_formulas AUTHID CURRENT_USER AS
2 --  $Header: pqpgbofm.pkh 115.1 2003/03/04 13:01:22 rrazdan noship $
3 --
4 -- Debug Variables.
5 --
6   g_proc_name              VARCHAR2(61):= 'pqp_gb_gap_ben_formulas.';
7   g_nested_level           NUMBER:= 0;
8 --
9 -- Global Varibales
10 --
11   g_use_this_functionality BOOLEAN:= FALSE;
12   g_business_group_id      NUMBER;
13   g_legislation_code       VARCHAR2(10):= 'GB';
14   g_effective_date         DATE;
15 --
16 --
17 --
18   TYPE t_formulas IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
19   g_formulas t_formulas;
20 
21   CURSOR csr_get_formula_id
22     (p_business_group_id            IN     NUMBER
23     ,p_formula_name                 IN     VARCHAR2
24     ) IS
25   SELECT formula_id
26     FROM ff_formulas_f
27    WHERE formula_name = p_formula_name
28      AND business_group_id = p_business_group_id
29   ;
30 
31   l_check_ler_formulas  csr_get_formula_id%ROWTYPE;
32 --
33 --
34 --
35   PROCEDURE create_ben_formulas
36     (p_business_group_id            IN     NUMBER
37     ,p_effective_date               IN     DATE
38     ,p_absence_pay_plan_category    IN     VARCHAR2
39     ,p_base_name                    IN     VARCHAR2
40     ,p_formulas IN OUT NOCOPY pqp_gb_gap_ben_formulas.t_formulas
41     ,p_error_code                      OUT NOCOPY NUMBER
42     ,p_error_message                   OUT NOCOPY VARCHAR2
43     )
44   ;
45 --
46 --
47 --
48   PROCEDURE delete_ben_formulas
49     (p_business_group_id            IN     NUMBER
50     ,p_effective_date               IN     DATE
51     ,p_absence_pay_plan_category    IN     VARCHAR2
52     ,p_base_name                    IN     VARCHAR2
53     ,p_error_code                      OUT NOCOPY NUMBER
54     ,p_error_message                   OUT NOCOPY VARCHAR2
55     )
56   ;
57 --
58 --
59 --
60 END pqp_gb_gap_ben_formulas;