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