1 Package ghr_cah_rku as
2 /* $Header: ghcahrhi.pkh 120.0 2005/05/29 02:48:37 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------< after_update >------------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure after_update
9 (p_effective_date in date
10 ,p_compl_ca_header_id in number
11 ,p_complaint_id in number
12 ,p_ca_source in varchar2
13 ,p_last_compliance_report in date
14 ,p_compliance_closed in date
15 ,p_compl_docket_number in varchar2
16 ,p_appeal_docket_number in varchar2
17 ,p_pfe_docket_number in varchar2
18 ,p_pfe_received in date
19 ,p_agency_brief_pfe_due in date
20 ,p_agency_brief_pfe_date in date
21 ,p_decision_pfe_date in date
22 ,p_decision_pfe in varchar2
23 ,p_agency_recvd_pfe_decision in date
24 ,p_agency_pfe_brief_forwd in date
25 ,p_agency_notified_noncom in date
26 ,p_comrep_noncom_req in varchar2
27 ,p_eeo_off_req_data_from_org in date
28 ,p_org_forwd_data_to_eeo_off in date
29 ,p_dec_implemented in date
30 ,p_complaint_reinstated in date
31 ,p_stage_complaint_reinstated in varchar2
32 ,p_object_version_number in number
33 ,p_complaint_id_o in number
34 ,p_ca_source_o in varchar2
35 ,p_last_compliance_report_o in date
36 ,p_compliance_closed_o in date
37 ,p_compl_docket_number_o in varchar2
38 ,p_appeal_docket_number_o in varchar2
39 ,p_pfe_docket_number_o in varchar2
40 ,p_pfe_received_o in date
41 ,p_agency_brief_pfe_due_o in date
42 ,p_agency_brief_pfe_date_o in date
43 ,p_decision_pfe_date_o in date
44 ,p_decision_pfe_o in varchar2
45 ,p_agency_recvd_pfe_decision_o in date
46 ,p_agency_pfe_brief_forwd_o in date
47 ,p_agency_notified_noncom_o in date
48 ,p_comrep_noncom_req_o in varchar2
49 ,p_eeo_off_req_data_from_org_o in date
50 ,p_org_forwd_data_to_eeo_off_o in date
51 ,p_dec_implemented_o in date
52 ,p_complaint_reinstated_o in date
53 ,p_stage_complaint_reinstated_o in varchar2
54 ,p_object_version_number_o in number
55 );
56 --
57 end ghr_cah_rku;
[Home] [Help]