1 Package pqh_wdt_rku AUTHID CURRENT_USER as
2 /* $Header: pqwdtrhi.pkh 120.0.12000000.1 2007/01/17 00:29:48 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------< after_update >------------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure after_update
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 ,p_worksheet_id_o in number
42 ,p_organization_id_o in number
43 ,p_job_id_o in number
44 ,p_position_id_o in number
45 ,p_grade_id_o in number
46 ,p_position_transaction_id_o in number
47 ,p_budget_detail_id_o in number
48 ,p_parent_worksheet_detail_id_o in number
49 ,p_user_id_o in number
50 ,p_action_cd_o in varchar2
51 ,p_budget_unit1_percent_o in number
52 ,p_budget_unit1_value_o in number
53 ,p_budget_unit2_percent_o in number
54 ,p_budget_unit2_value_o in number
55 ,p_budget_unit3_percent_o in number
56 ,p_budget_unit3_value_o in number
57 ,p_object_version_number_o in number
58 ,p_budget_unit1_value_type_cd_o in varchar2
59 ,p_budget_unit2_value_type_cd_o in varchar2
60 ,p_budget_unit3_value_type_cd_o in varchar2
61 ,p_status_o in varchar2
62 ,p_budget_unit1_available_o in number
63 ,p_budget_unit2_available_o in number
64 ,p_budget_unit3_available_o in number
65 ,p_old_unit1_value_o in number
66 ,p_old_unit2_value_o in number
67 ,p_old_unit3_value_o in number
68 ,p_defer_flag_o in varchar2
69 ,p_propagation_method_o in varchar2
70 );
71 --
72 end pqh_wdt_rku;
[Home] [Help]