1 package pqh_bdgt AUTHID CURRENT_USER as
2 /* $Header: pqbudget.pkh 115.9 2002/11/27 04:43:03 rpasapul ship $ */
3
4 procedure propagate_version_changes (p_change_mode in varchar2,
5 p_budget_version_id in number,
6 p_budget_style_cd in varchar2,
7 p_new_bgv_unit1_value in number,
8 p_new_bgv_unit2_value in number,
9 p_new_bgv_unit3_value in number,
10 p_unit1_precision in number,
11 p_unit2_precision in number,
12 p_unit3_precision in number,
13 p_unit1_aggregate in varchar2,
14 p_unit2_aggregate in varchar2,
15 p_unit3_aggregate in varchar2,
16 p_budget_version_status in out nocopy varchar2,
17 p_bgv_unit1_available in out nocopy number,
18 p_bgv_unit2_available in out nocopy number,
19 p_bgv_unit3_available in out nocopy number
20 );
21
22 procedure propagate_budget_changes (p_change_mode in varchar2,
23 p_budget_detail_id in number,
24 p_new_bgt_unit1_value in number,
25 p_new_bgt_unit2_value in number,
26 p_new_bgt_unit3_value in number,
27 p_unit1_precision in number,
28 p_unit2_precision in number,
29 p_unit3_precision in number,
30 p_unit1_aggregate in varchar2,
31 p_unit2_aggregate in varchar2,
32 p_unit3_aggregate in varchar2,
33 p_bgt_unit1_available in out nocopy number,
34 p_bgt_unit2_available in out nocopy number,
35 p_bgt_unit3_available in out nocopy number
36 );
37
38 procedure propagate_period_changes (p_change_mode in varchar2,
39 p_budget_period_id in number,
40 p_new_prd_unit1_value in number,
41 p_new_prd_unit2_value in number,
42 p_new_prd_unit3_value in number,
43 p_unit1_precision in number,
44 p_unit2_precision in number,
45 p_unit3_precision in number,
46 p_prd_unit1_available in out nocopy number,
47 p_prd_unit2_available in out nocopy number,
48 p_prd_unit3_available in out nocopy number
49 );
50
51 procedure insert_budget_detail(
52 p_budget_version_id in number,
53 p_organization_id in number default null,
54 p_job_id in number default null,
55 p_position_id in number default null,
56 p_grade_id in number default null,
57 p_budget_unit1_percent in number default null,
58 p_budget_unit1_value in number default null,
59 p_budget_unit2_percent in number default null,
60 p_budget_unit2_value in number default null,
61 p_budget_unit3_percent in number default null,
62 p_budget_unit3_value in number default null,
63 p_budget_unit1_value_type_cd in varchar2 default null,
64 p_budget_unit2_value_type_cd in varchar2 default null,
65 p_budget_unit3_value_type_cd in varchar2 default null,
66 p_gl_status in varchar2 default null,
67 p_budget_unit1_available in number default null,
68 p_budget_unit2_available in number default null,
69 p_budget_unit3_available in number default null,
70 p_budget_detail_id out nocopy number
71 ) ;
72
73 Procedure update_budget_detail
74 (
75 p_budget_detail_id in number,
76 p_budget_version_id in number default hr_api.g_number,
77 p_organization_id in number default hr_api.g_number,
78 p_job_id in number default hr_api.g_number,
79 p_position_id in number default hr_api.g_number,
80 p_grade_id in number default hr_api.g_number,
81 p_budget_unit1_percent in number default hr_api.g_number,
82 p_budget_unit1_value in number default hr_api.g_number,
83 p_budget_unit2_percent in number default hr_api.g_number,
84 p_budget_unit2_value in number default hr_api.g_number,
85 p_budget_unit3_percent in number default hr_api.g_number,
86 p_budget_unit3_value in number default hr_api.g_number,
87 p_object_version_number in out nocopy number,
88 p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
89 p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
90 p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
91 p_gl_status in varchar2 default hr_api.g_varchar2,
92 p_budget_unit1_available in number default hr_api.g_number,
93 p_budget_unit2_available in number default hr_api.g_number,
94 p_budget_unit3_available in number default hr_api.g_number
95 ) ;
96
97 procedure bgv_date_validation( p_budget_id in number,
98 p_version_number in number ,
99 p_date_from in date,
100 p_date_to in date,
101 p_bgv_ll_date out nocopy date,
102 p_bgv_ul_date out nocopy date,
103 p_status out nocopy varchar2) ;
104 function gl_post(p_budget_version_id in number) return number ;
105
106 end pqh_bdgt;
[Home] [Help]