1 PACKAGE HZ_FINANCIAL_REPORTS_PKG AUTHID CURRENT_USER as
2 /* $Header: ARHOFRTS.pls 115.9 2003/05/03 07:32:47 ssmohan ship $ */
3
4
5 PROCEDURE Insert_Row (
6 x_rowid IN OUT NOCOPY VARCHAR2,
7 x_financial_report_id IN OUT NOCOPY NUMBER,
8 x_date_report_issued IN DATE,
9 x_party_id IN NUMBER,
10 x_document_reference IN VARCHAR2,
11 x_issued_period IN VARCHAR2,
12 x_requiring_authority IN VARCHAR2,
13 x_type_of_financial_report IN VARCHAR2,
14 x_report_start_date IN DATE,
15 x_report_end_date IN DATE,
16 x_audit_ind IN VARCHAR2,
17 x_consolidated_ind IN VARCHAR2,
18 x_estimated_ind IN VARCHAR2,
19 x_fiscal_ind IN VARCHAR2,
20 x_final_ind IN VARCHAR2,
21 x_forecast_ind IN VARCHAR2,
22 x_opening_ind IN VARCHAR2,
23 x_proforma_ind IN VARCHAR2,
24 x_qualified_ind IN VARCHAR2,
25 x_restated_ind IN VARCHAR2,
26 x_signed_by_principals_ind IN VARCHAR2,
27 x_trial_balance_ind IN VARCHAR2,
28 x_unbalanced_ind IN VARCHAR2,
29 x_content_source_type IN VARCHAR2,
30 x_status IN VARCHAR2,
31 x_object_version_number IN NUMBER,
32 x_created_by_module IN VARCHAR2,
33 x_actual_content_source IN VARCHAR2
34 );
35
36 PROCEDURE Update_Row (
37 x_rowid IN OUT NOCOPY VARCHAR2,
38 x_financial_report_id IN NUMBER,
39 x_date_report_issued IN DATE,
40 x_party_id IN NUMBER,
41 x_document_reference IN VARCHAR2,
42 x_issued_period IN VARCHAR2,
43 x_requiring_authority IN VARCHAR2,
44 x_type_of_financial_report IN VARCHAR2,
45 x_report_start_date IN DATE,
46 x_report_end_date IN DATE,
47 x_audit_ind IN VARCHAR2,
48 x_consolidated_ind IN VARCHAR2,
49 x_estimated_ind IN VARCHAR2,
50 x_fiscal_ind IN VARCHAR2,
51 x_final_ind IN VARCHAR2,
52 x_forecast_ind IN VARCHAR2,
53 x_opening_ind IN VARCHAR2,
54 x_proforma_ind IN VARCHAR2,
55 x_qualified_ind IN VARCHAR2,
56 x_restated_ind IN VARCHAR2,
57 x_signed_by_principals_ind IN VARCHAR2,
58 x_trial_balance_ind IN VARCHAR2,
59 x_unbalanced_ind IN VARCHAR2,
60 x_content_source_type IN VARCHAR2,
61 x_status IN VARCHAR2,
62 x_object_version_number IN NUMBER,
63 x_created_by_module IN VARCHAR2,
64 x_actual_content_source IN VARCHAR2
65 );
66
67 PROCEDURE Lock_Row (
68 x_rowid IN OUT NOCOPY VARCHAR2,
69 x_financial_report_id IN NUMBER,
70 x_date_report_issued IN DATE,
71 x_party_id IN NUMBER,
72 x_document_reference IN VARCHAR2,
73 x_issued_period IN VARCHAR2,
74 x_requiring_authority IN VARCHAR2,
75 x_type_of_financial_report IN VARCHAR2,
76 x_report_start_date IN DATE,
77 x_report_end_date IN DATE,
78 x_audit_ind IN VARCHAR2,
79 x_consolidated_ind IN VARCHAR2,
80 x_estimated_ind IN VARCHAR2,
81 x_fiscal_ind IN VARCHAR2,
82 x_final_ind IN VARCHAR2,
83 x_forecast_ind IN VARCHAR2,
84 x_opening_ind IN VARCHAR2,
85 x_proforma_ind IN VARCHAR2,
86 x_qualified_ind IN VARCHAR2,
87 x_restated_ind IN VARCHAR2,
88 x_signed_by_principals_ind IN VARCHAR2,
89 x_trial_balance_ind IN VARCHAR2,
90 x_unbalanced_ind IN VARCHAR2,
91 x_content_source_type IN VARCHAR2,
92 x_created_by IN NUMBER,
93 x_creation_date IN DATE,
94 x_last_update_login IN NUMBER,
95 x_last_update_date IN DATE,
96 x_last_updated_by IN NUMBER,
97 x_request_id IN NUMBER,
98 x_program_application_id IN NUMBER,
99 x_program_id IN NUMBER,
100 x_program_update_date IN DATE,
101 x_status IN VARCHAR2,
102 x_object_version_number IN NUMBER,
103 x_created_by_module IN VARCHAR2,
104 x_application_id IN NUMBER,
105 x_actual_content_source IN VARCHAR2
106 );
107
108 PROCEDURE Delete_Row (
109 x_financial_report_id IN NUMBER
110 );
111
112 PROCEDURE Select_Row (
113 x_financial_report_id IN OUT NOCOPY NUMBER,
114 x_date_report_issued OUT NOCOPY DATE,
115 x_party_id OUT NOCOPY NUMBER,
116 x_document_reference OUT NOCOPY VARCHAR2,
117 x_issued_period OUT NOCOPY VARCHAR2,
118 x_requiring_authority OUT NOCOPY VARCHAR2,
119 x_type_of_financial_report OUT NOCOPY VARCHAR2,
120 x_report_start_date OUT NOCOPY DATE,
121 x_report_end_date OUT NOCOPY DATE,
122 x_audit_ind OUT NOCOPY VARCHAR2,
123 x_consolidated_ind OUT NOCOPY VARCHAR2,
124 x_estimated_ind OUT NOCOPY VARCHAR2,
125 x_fiscal_ind OUT NOCOPY VARCHAR2,
126 x_final_ind OUT NOCOPY VARCHAR2,
127 x_forecast_ind OUT NOCOPY VARCHAR2,
128 x_opening_ind OUT NOCOPY VARCHAR2,
132 x_signed_by_principals_ind OUT NOCOPY VARCHAR2,
129 x_proforma_ind OUT NOCOPY VARCHAR2,
130 x_qualified_ind OUT NOCOPY VARCHAR2,
131 x_restated_ind OUT NOCOPY VARCHAR2,
133 x_trial_balance_ind OUT NOCOPY VARCHAR2,
134 x_unbalanced_ind OUT NOCOPY VARCHAR2,
135 x_content_source_type OUT NOCOPY VARCHAR2,
136 x_status OUT NOCOPY VARCHAR2,
137 x_actual_content_source OUT NOCOPY VARCHAR2,
138 x_created_by_module OUT NOCOPY VARCHAR2
139 );
140
141 END HZ_FINANCIAL_REPORTS_PKG;