1 Package pqh_bdgt_actual_cmmtmnt_pkg as
2 /* $Header: pqbgtact.pkh 120.0 2005/05/29 01:30:48 appldev noship $ */
3 --
4 FUNCTION get_last_payroll_dt (
5 p_assignment_id in number,
6 p_start_date in date,
7 p_end_date in date ) return date ;
8 --
9
10 function get_factor( p_from_start_date in date,
11 p_from_end_date in date,
12 p_to_start_date in date,
13 p_to_end_date in date )
14 RETURN NUMBER;
15 --
16 FUNCTION get_budget_actuals(p_budget_version_id in number,
17 p_period_start_date in date,
18 p_period_end_date in date,
19 p_unit_of_measure_id in number)
20 RETURN NUMBER;
21 --
22 --
23 -- The following procedure returns commitment for a budget version.
24 --
25 FUNCTION get_budget_commitment( p_budget_version_id in number,
26 p_period_start_date in date,
27 p_period_end_date in date,
28 p_unit_of_measure_id in number)
29 RETURN NUMBER;
30 --
31 FUNCTION get_budget_actuals(p_budget_version_id in number,
32 p_budgeted_entity_cd in varchar2,
33 p_period_start_date in date,
34 p_period_end_date in date,
35 p_unit_of_measure_id in number)
36 RETURN NUMBER;
37 --
38 FUNCTION get_budget_commitment(p_budget_version_id in number,
39 p_budgeted_entity_cd in varchar2,
40 p_period_start_date in date,
41 p_period_end_date in date,
42 p_unit_of_measure_id in number)
43 RETURN NUMBER;
44 --
45 --
46 -- The foll function returns either a total of actuals and commitment for a
47 -- position or actuals alone or commitment alone.
48 --
49 Function get_pos_actual_and_cmmtmnt
50 (
51 p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
52 p_position_id IN per_positions.position_id%TYPE,
53 p_element_type_id IN number default NULL,
54 p_start_date IN pqh_budgets.budget_start_date%TYPE,
55 p_end_date IN pqh_budgets.budget_end_date%TYPE,
56 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
57 p_value_type IN varchar2,
58 p_ex_assignment_id IN number default -1,
59 p_validate IN varchar2 default 'Y'
60 )
61 RETURN NUMBER;
62
63 Function get_ent_actual_and_cmmtmnt
64 (
65 p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
66 p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
67 p_entity_id IN pqh_budget_details.position_id%TYPE,
68 p_element_type_id IN number default NULL,
69 p_start_date IN pqh_budgets.budget_start_date%TYPE,
70 p_end_date IN pqh_budgets.budget_end_date%TYPE,
71 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
72 p_value_type IN varchar2
73 )
74 RETURN NUMBER;
75
76 --
77 --
78 Procedure get_actual_and_cmmtmnt( p_position_id in number default null
79 ,p_job_id in number default null
80 ,p_grade_id in number default null
81 ,p_organization_id in number default null
82 ,p_budget_entity in varchar2
83 ,p_element_type_id in number default null--later
84 ,p_start_date in date default sysdate
85 ,p_end_date in date default sysdate
86 ,p_effective_date in date default sysdate
87 ,p_unit_of_measure in varchar2
88 ,p_business_group_id in number
89 ,p_actual_value out nocopy number
90 ,p_commt_value out nocopy number
91 );
92 --
93 --
94 --
95 -- This procedure returns money actuals,commitment and total for a position.
96 --
97 PROCEDURE get_pos_money_amounts
98 (
99 p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
100 p_position_id IN per_positions.position_id%TYPE,
101 p_start_date IN pqh_budgets.budget_start_date%TYPE,
102 p_end_date IN pqh_budgets.budget_end_date%TYPE,
103 p_actual_amount OUT NOCOPY number,
104 p_commitment_amount OUT NOCOPY number,
105 p_total_amount OUT NOCOPY number
106 );
107 --
108 --
109 FUNCTION get_assignment_actuals
110 (p_assignment_id in number,
111 p_element_type_id in number default NULL,
112 p_actuals_start_date in date,
113 p_actuals_end_date in date,
114 p_unit_of_measure_id in number,
115 p_last_payroll_dt out nocopy date)
116 RETURN NUMBER;
117 --
118 --
119 --
120 FUNCTION get_assignment_commitment(p_assignment_id in number,
121 p_budget_version_id in number default NULL,
122 p_element_type_id in number default NULL,
123 p_period_start_date in date,
124 p_period_end_date in date,
125 p_unit_of_measure_id in number)
126 RETURN NUMBER;
127 --
128 FUNCTION get_bg_legislation_code (p_business_group_id in number)
129 RETURN varchar2;
130 --
131 FUNCTION get_pos_money_total9(
132 p_position_id number,
133 p_budget_version_id number,
134 p_actuals_start_date date,
135 p_actuals_end_date date)
136 -- p_ex_assignment_id IN number default -1)
137 RETURN NUMBER;
138
139 End pqh_bdgt_actual_cmmtmnt_pkg;