1 Package pqh_WORKSHEET_PERIODS_bk2 as
2 /* $Header: pqwprapi.pkh 120.0 2005/05/29 03:02:15 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------------< update_WORKSHEET_PERIOD_b >-----------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure update_WORKSHEET_PERIOD_b
9 (
10 p_worksheet_period_id in number
11 ,p_end_time_period_id in number
12 ,p_worksheet_detail_id in number
13 ,p_budget_unit1_percent in number
14 ,p_budget_unit2_percent in number
15 ,p_budget_unit3_percent in number
16 ,p_budget_unit1_value in number
17 ,p_budget_unit2_value in number
18 ,p_budget_unit3_value in number
19 ,p_object_version_number in number
20 ,p_budget_unit1_value_type_cd in varchar2
21 ,p_budget_unit2_value_type_cd in varchar2
22 ,p_budget_unit3_value_type_cd in varchar2
23 ,p_start_time_period_id in number
24 ,p_budget_unit3_available in number
25 ,p_budget_unit2_available in number
26 ,p_budget_unit1_available in number
27 ,p_effective_date in date
28 );
29 --
30 -- ----------------------------------------------------------------------------
31 -- |---------------------------< update_WORKSHEET_PERIOD_a >-----------------|
32 -- ----------------------------------------------------------------------------
33 --
34 procedure update_WORKSHEET_PERIOD_a
35 (
36 p_worksheet_period_id in number
37 ,p_end_time_period_id in number
38 ,p_worksheet_detail_id in number
39 ,p_budget_unit1_percent in number
40 ,p_budget_unit2_percent in number
41 ,p_budget_unit3_percent in number
42 ,p_budget_unit1_value in number
43 ,p_budget_unit2_value in number
44 ,p_budget_unit3_value in number
45 ,p_object_version_number in number
46 ,p_budget_unit1_value_type_cd in varchar2
47 ,p_budget_unit2_value_type_cd in varchar2
48 ,p_budget_unit3_value_type_cd in varchar2
49 ,p_start_time_period_id in number
50 ,p_budget_unit3_available in number
51 ,p_budget_unit2_available in number
52 ,p_budget_unit1_available in number
53 ,p_effective_date in date
54 );
55 --
56 end pqh_WORKSHEET_PERIODS_bk2;