PACKAGE: APPS.PQH_COMMITMENT_PKG

Source

1 Package pqh_commitment_pkg as
2 /* $Header: pqbgtcom.pkh 120.1 2006/12/18 09:13:58 krajarat noship $ */
3 PROCEDURE relieve_commitment(
4                     errbuf                 out nocopy varchar2,
5                     retcode                out nocopy varchar2,
6                     p_effective_date        in varchar2,
7                     p_budgeted_entity_cd    in varchar2,
8                     p_budget_version_id     in number,
9                     p_post_to_period_name in varchar2) ;
10 --
11 -- This procedure generates commitment between the supplied dates.
12 --
13 -- 2288274 Added paramenters p_budgeted_entity_cd, p_entity_id
14 -- p_budget_version_id depends on p_budged_entity_cd
15 --
16 PROCEDURE calculate_commitment(
17                          errbuf               out nocopy varchar2,
18                          retcode              out nocopy varchar2,
19   			 p_budgeted_entity_cd in varchar2,
20                          p_budget_version_id   in number,
21                          p_entity_id	       in number default null ,
22                        /*  p_cmmtmnt_start_dt    in varchar2,
23                          p_cmmtmnt_end_dt      in varchar2,*/
24                          p_period_frequency    in varchar2  default NULL);
25 --
26 FUNCTION standard_hours_worked( p_std_hrs	in NUMBER,
27 				p_range_start	in DATE,
28 				p_range_end	in DATE,
29 				p_std_freq	in VARCHAR2) RETURN NUMBER ;
30 --
31 Function get_number_per_fiscal_year(p_frequency  in varchar2) RETURN NUMBER ;
32 
33 Procedure refresh_asg_ele_commitments (p_assignment_id Number,
34                                        p_effective_date Date,
35                                        p_element_type_id Number default Null,
36                                        p_input_value_id Number default Null);
37 --
38 End;