1 Package ghr_complaints_ca_headers_bk_1 as
2 /* $Header: ghcahapi.pkh 120.1 2005/10/02 01:57:09 aroussel $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-------------------------< create_ca_header_b >-------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure create_ca_header_b
9 (p_effective_date in date
10 ,p_complaint_id in number
11 ,p_ca_source in varchar2
12 ,p_last_compliance_report in date
13 ,p_compliance_closed in date
14 ,p_compl_docket_number in varchar2
15 ,p_appeal_docket_number in varchar2
16 ,p_pfe_docket_number in varchar2
17 ,p_pfe_received in date
18 ,p_agency_brief_pfe_due in date
19 ,p_agency_brief_pfe_date in date
20 ,p_decision_pfe_date in date
21 ,p_decision_pfe in varchar2
22 ,p_agency_recvd_pfe_decision in date
23 ,p_agency_pfe_brief_forwd in date
24 ,p_agency_notified_noncom in date
25 ,p_comrep_noncom_req in varchar2
26 ,p_eeo_off_req_data_from_org in date
27 ,p_org_forwd_data_to_eeo_off in date
28 ,p_dec_implemented in date
29 ,p_complaint_reinstated in date
30 ,p_stage_complaint_reinstated in varchar2
31 );
32 --
33 -- ----------------------------------------------------------------------------
34 -- |-------------------------< create_ca_header_a >-------------------------|
35 -- ----------------------------------------------------------------------------
36 --
37 procedure create_ca_header_a
38 (p_effective_date in date
39 ,p_complaint_id in number
40 ,p_ca_source in varchar2
41 ,p_last_compliance_report in date
42 ,p_compliance_closed in date
43 ,p_compl_docket_number in varchar2
44 ,p_appeal_docket_number in varchar2
45 ,p_pfe_docket_number in varchar2
46 ,p_pfe_received in date
47 ,p_agency_brief_pfe_due in date
48 ,p_agency_brief_pfe_date in date
49 ,p_decision_pfe_date in date
50 ,p_decision_pfe in varchar2
51 ,p_agency_recvd_pfe_decision in date
52 ,p_agency_pfe_brief_forwd in date
53 ,p_agency_notified_noncom in date
54 ,p_comrep_noncom_req in varchar2
55 ,p_eeo_off_req_data_from_org in date
56 ,p_org_forwd_data_to_eeo_off in date
57 ,p_dec_implemented in date
58 ,p_complaint_reinstated in date
59 ,p_stage_complaint_reinstated in varchar2
60 ,p_compl_ca_header_id in number
61 ,p_object_version_number in number
62 );
63 --
64 end ghr_complaints_ca_headers_bk_1;
[Home] [Help]