1 Package ghr_prh_rku as
2 /* $Header: ghprhrhi.pkh 120.1.12000000.1 2007/01/18 14:09:34 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------< after_insert >------------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 -- Description :
9 -- If the user(customer) has any packages to be executed, then those will be
10 -- called by this procedure. The body of this procedure will be generated.
11 --
12 procedure after_update (
13 p_pa_routing_history_id in number,
14 p_pa_request_id in number,
15 p_attachment_modified_flag in varchar2,
16 p_initiator_flag in varchar2,
17 p_approver_flag in varchar2,
18 p_reviewer_flag in varchar2,
19 p_requester_flag in varchar2,
20 p_authorizer_flag in varchar2,
21 p_personnelist_flag in varchar2,
22 p_approved_flag in varchar2,
23 p_user_name in varchar2,
24 p_user_name_employee_id in number,
25 p_user_name_emp_first_name in varchar2,
26 p_user_name_emp_last_name in varchar2,
27 p_user_name_emp_middle_names in varchar2,
28 p_notepad in varchar2,
29 p_action_taken in varchar2,
30 p_groupbox_id in number,
31 p_routing_list_id in number,
32 p_routing_seq_number in number,
33 p_noa_family_code in varchar2,
34 p_nature_of_action_id in number,
35 p_second_nature_of_action_id in number,
36 p_approval_status in varchar2,
37 p_date_notification_sent in date,
38 p_object_version_number in number,
39 p_pa_request_id_o in number,
40 p_attachment_modified_flag_o in varchar2,
41 p_initiator_flag_o in varchar2,
42 p_approver_flag_o in varchar2,
43 p_reviewer_flag_o in varchar2,
44 p_requester_flag_o in varchar2,
45 p_authorizer_flag_o in varchar2,
46 p_personnelist_flag_o in varchar2,
47 p_approved_flag_o in varchar2,
48 p_user_name_o in varchar2,
49 p_user_name_employee_id_o in number,
50 p_user_name_emp_first_name_o in varchar2,
51 p_user_name_emp_last_name_o in varchar2,
52 p_user_name_emp_middle_names_o in varchar2,
53 p_notepad_o in varchar2,
54 p_action_taken_o in varchar2,
55 p_groupbox_id_o in number,
56 p_routing_list_id_o in number,
57 p_routing_seq_number_o in number,
58 p_noa_family_code_o in varchar2,
59 p_nature_of_action_id_o in number,
60 p_second_nature_of_action_id_o in number,
61 p_approval_status_o in varchar2,
62 p_date_notification_sent_o in date,
63 p_object_version_number_o in number );
64
65 end ghr_prh_rku;