1 Package ghr_complainant_appeals_bk_2 as
2 /* $Header: ghccaapi.pkh 120.1 2005/10/02 01:57:18 aroussel $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-------------------------< update_complainant_appeal_b >------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure update_complainant_appeal_b
9 (p_effective_date in date
10 ,p_complaint_id in number
11 ,p_appeal_date in date
12 ,p_appealed_to in varchar2
13 ,p_reason_for_appeal in varchar2
14 ,p_source_decision_date in date
15 ,p_docket_num in varchar2
16 ,p_org_notified_of_appeal in date
17 ,p_agency_recvd_req_for_files in date
18 ,p_files_due in date
19 ,p_files_forwd in date
20 ,p_agcy_recvd_appellant_brief in date
21 ,p_agency_brief_due in date
22 ,p_appellant_brief_forwd_org in date
23 ,p_org_forwd_brief_to_agency in date
24 ,p_agency_brief_forwd in date
25 ,p_decision_date in date
26 ,p_dec_recvd_by_agency in date
27 ,p_decision in varchar2
28 ,p_dec_forwd_to_org in date
29 ,p_agency_rfr_suspense in date
30 ,p_request_for_rfr in date
31 ,p_rfr_docket_num in varchar2
32 ,p_rfr_requested_by in varchar2
33 ,p_agency_rfr_due in date
34 ,p_rfr_forwd_to_org in date
35 ,p_org_forwd_rfr_to_agency in date
36 ,p_agency_forwd_rfr_ofo in date
37 ,p_rfr_decision in varchar2
38 ,p_rfr_decision_date in date
39 ,p_agency_recvd_rfr_dec in date
40 ,p_rfr_decision_forwd_to_org in date
41 ,p_compl_appeal_id in number
42 ,p_object_version_number in number
43 );
44 --
45 -- ----------------------------------------------------------------------------
46 -- |-------------------------< update_complainant_appeal_a >------------------|
47 -- ----------------------------------------------------------------------------
48 --
49 procedure update_complainant_appeal_a
50 (p_effective_date in date
51 ,p_complaint_id in number
52 ,p_appeal_date in date
53 ,p_appealed_to in varchar2
54 ,p_reason_for_appeal in varchar2
55 ,p_source_decision_date in date
56 ,p_docket_num in varchar2
57 ,p_org_notified_of_appeal in date
58 ,p_agency_recvd_req_for_files in date
59 ,p_files_due in date
60 ,p_files_forwd in date
61 ,p_agcy_recvd_appellant_brief in date
62 ,p_agency_brief_due in date
63 ,p_appellant_brief_forwd_org in date
64 ,p_org_forwd_brief_to_agency in date
65 ,p_agency_brief_forwd in date
66 ,p_decision_date in date
67 ,p_dec_recvd_by_agency in date
68 ,p_decision in varchar2
69 ,p_dec_forwd_to_org in date
70 ,p_agency_rfr_suspense in date
71 ,p_request_for_rfr in date
72 ,p_rfr_docket_num in varchar2
73 ,p_rfr_requested_by in varchar2
74 ,p_agency_rfr_due in date
75 ,p_rfr_forwd_to_org in date
76 ,p_org_forwd_rfr_to_agency in date
77 ,p_agency_forwd_rfr_ofo in date
78 ,p_rfr_decision in varchar2
79 ,p_rfr_decision_date in date
80 ,p_agency_recvd_rfr_dec in date
81 ,p_rfr_decision_forwd_to_org in date
82 ,p_compl_appeal_id in number
83 ,p_object_version_number in number
84 );
85 end ghr_complainant_appeals_bk_2;
[Home] [Help]