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