DBA Data[Home] [Help]

PACKAGE: APPS.PAY_US_PTO_CO_PKG

Source


1 package pay_us_pto_co_pkg as
2 /* $Header: pyuspaco.pkh 120.0.12010000.1 2008/07/27 23:54:55 appldev ship $ */
3 
4   --
5   -- Package global constants.
6   --
7   DEBUG   CONSTANT NUMBER := 0;
8   NORMAL  CONSTANT NUMBER := 1;
9 
10   SUCCESS CONSTANT NUMBER := 0;
11   WARNING CONSTANT NUMBER := 1;
12   ERROR   CONSTANT NUMBER := 2;
13 
14   --
15   -- Package global variables.
16   --
17   g_errbuf        VARCHAR2(2000);
18   g_retcode       NUMBER;
19 
20 PROCEDURE initialize_logging
21     (p_action_parameter_group_id IN NUMBER DEFAULT NULL);
22 
23 PROCEDURE write_log
24     (p_text IN VARCHAR2
25     ,p_type IN NUMBER DEFAULT NORMAL);
26 
27 PROCEDURE carry_over( ERRBUF           OUT NOCOPY varchar2,
28                       RETCODE          OUT NOCOPY number,
29                       P_calculation_date          varchar2,
30                       P_business_group_id         number,
31                       P_plan_id                   number   DEFAULT NULL,
32                       P_plan_category             varchar2 DEFAULT NULL,
33                       P_mode                      varchar2 DEFAULT 'N',
34 		      p_accrual_term              varchar2 DEFAULT 'C',
35                       p_action_parameter_group_id number   DEFAULT NULL
36 		      );
37 --
38 
39 /* For 2932073 P_Legislation_cd             Varchar2 DEFAULT NULL is added */
40 /* In the pto_carry_over_for_plan Procedure */
41 PROCEDURE pto_carry_over_for_plan
42                     ( p_plan_id                    number,
43                       p_co_formula_id              number,
44                       P_plan_ele_type_id           number,
45                       P_co_ele_type_id             number,
46                       P_co_input_val_id            number,
47                       P_co_date_input_value_id     number,
48 		      P_co_exp_date_input_value_id number,
49                       P_res_ele_type_id            number,
50                       P_res_input_val_id           number,
51                       P_res_date_input_value_id    number,
52 		      P_business_group_id          number,
53                       P_Calculation_date           date,
54                       P_co_mode                    varchar2,
55 		      p_accrual_term               varchar2,
56 		      p_session_date               date,
57 		      p_legislation_code           Varchar2 DEFAULT NULL
58 		      );
59 --
60 
61 /* For 2932073 P_Legislation_cd             Varchar2 DEFAULT NULL is added */
62 /* In the pto_carry_over_for_asg Procedure */
63 PROCEDURE pto_carry_over_for_asg
64                     ( p_plan_id                    number,
65                       p_assignment_id              number,
66                       p_co_formula_id              number,
67                       p_plan_ele_type_id           number,
68                       p_co_ele_type_id             number,
69                       p_co_input_val_id            number,
70                       p_co_date_input_value_id     number,
71 		      p_co_exp_date_input_value_id number,
72                       p_res_ele_type_id            number,
73                       p_res_input_val_id           number,
74                       p_res_date_input_value_id    number,
75 		      p_business_group_id          number,
76                       p_calculation_date           date,
77                       p_co_mode                    varchar2,
78 		      p_accrual_term               varchar2,
79 		      p_session_date               date,
80 		      p_legislation_code           Varchar2 DEFAULT NULL
81 		      );
82 --
83 END pay_us_pto_co_pkg;