1 Package pqh_WORKSHEET_DETAILS_bk2 as
2 /* $Header: pqwdtapi.pkh 120.1.12000000.1 2007/01/17 00:29:38 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------------< update_WORKSHEET_DETAIL_b >-----------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure update_WORKSHEET_DETAIL_b
9 (
10 p_worksheet_detail_id in number
11 ,p_worksheet_id in number
12 ,p_organization_id in number
13 ,p_job_id in number
14 ,p_position_id in number
15 ,p_grade_id in number
16 ,p_position_transaction_id in number
17 ,p_budget_detail_id in number
18 ,p_parent_worksheet_detail_id in number
19 ,p_user_id in number
20 ,p_action_cd in varchar2
21 ,p_budget_unit1_percent in number
22 ,p_budget_unit1_value in number
23 ,p_budget_unit2_percent in number
24 ,p_budget_unit2_value in number
25 ,p_budget_unit3_percent in number
26 ,p_budget_unit3_value in number
27 ,p_object_version_number in number
28 ,p_budget_unit1_value_type_cd in varchar2
29 ,p_budget_unit2_value_type_cd in varchar2
30 ,p_budget_unit3_value_type_cd in varchar2
31 ,p_status in varchar2
32 ,p_budget_unit1_available in number
33 ,p_budget_unit2_available in number
34 ,p_budget_unit3_available in number
35 ,p_old_unit1_value in number
36 ,p_old_unit2_value in number
37 ,p_old_unit3_value in number
38 ,p_defer_flag in varchar2
39 ,p_propagation_method in varchar2
40 ,p_effective_date in date
41 );
42 --
43 -- ----------------------------------------------------------------------------
44 -- |---------------------------< update_WORKSHEET_DETAIL_a >-----------------|
45 -- ----------------------------------------------------------------------------
46 --
47 procedure update_WORKSHEET_DETAIL_a
48 (
49 p_worksheet_detail_id in number
50 ,p_worksheet_id in number
51 ,p_organization_id in number
52 ,p_job_id in number
53 ,p_position_id in number
54 ,p_grade_id in number
55 ,p_position_transaction_id in number
56 ,p_budget_detail_id in number
57 ,p_parent_worksheet_detail_id in number
58 ,p_user_id in number
59 ,p_action_cd in varchar2
60 ,p_budget_unit1_percent in number
61 ,p_budget_unit1_value in number
62 ,p_budget_unit2_percent in number
63 ,p_budget_unit2_value in number
64 ,p_budget_unit3_percent in number
65 ,p_budget_unit3_value in number
66 ,p_object_version_number in number
67 ,p_budget_unit1_value_type_cd in varchar2
68 ,p_budget_unit2_value_type_cd in varchar2
69 ,p_budget_unit3_value_type_cd in varchar2
70 ,p_status in varchar2
71 ,p_budget_unit1_available in number
72 ,p_budget_unit2_available in number
73 ,p_budget_unit3_available in number
74 ,p_old_unit1_value in number
75 ,p_old_unit2_value in number
76 ,p_old_unit3_value in number
77 ,p_defer_flag in varchar2
78 ,p_propagation_method in varchar2
79 ,p_effective_date in date
80 );
81 --
82 end pqh_WORKSHEET_DETAILS_bk2;