1 Package pqh_wdt_rki as
2 /* $Header: pqwdtrhi.pkh 120.0.12000000.1 2007/01/17 00:29:48 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-----------------------------< after_insert >-----------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure after_insert
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 end pqh_wdt_rki;