1 Package ghr_complaints_ca_headers_bk_2 AUTHID CURRENT_USER as
2 /* $Header: ghcahapi.pkh 120.1 2005/10/02 01:57:09 aroussel $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-------------------------< update_ca_header_b >-------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure update_ca_header_b
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 );
34 --
35 -- ----------------------------------------------------------------------------
36 -- |-------------------------< update_ca_header_a >-------------------------|
37 -- ----------------------------------------------------------------------------
38 --
39 procedure update_ca_header_a
40 (p_effective_date in date
41 ,p_compl_ca_header_id in number
42 ,p_complaint_id in number
43 ,p_ca_source in varchar2
44 ,p_last_compliance_report in date
45 ,p_compliance_closed in date
46 ,p_compl_docket_number in varchar2
47 ,p_appeal_docket_number in varchar2
48 ,p_pfe_docket_number in varchar2
49 ,p_pfe_received in date
50 ,p_agency_brief_pfe_due in date
51 ,p_agency_brief_pfe_date in date
52 ,p_decision_pfe_date in date
53 ,p_decision_pfe in varchar2
54 ,p_agency_recvd_pfe_decision in date
55 ,p_agency_pfe_brief_forwd in date
56 ,p_agency_notified_noncom in date
57 ,p_comrep_noncom_req in varchar2
58 ,p_eeo_off_req_data_from_org in date
59 ,p_org_forwd_data_to_eeo_off in date
60 ,p_dec_implemented in date
61 ,p_complaint_reinstated in date
62 ,p_stage_complaint_reinstated in varchar2
63 ,p_object_version_number in number
64 );
65 --
66 end ghr_complaints_ca_headers_bk_2;
[Home] [Help]