[Home] [Help]
PACKAGE: APPS.PO_DOCUMENT_TOTALS_PVT
Source
1 PACKAGE PO_DOCUMENT_TOTALS_PVT AUTHID CURRENT_USER AS
2 -- $Header: PO_DOCUMENT_TOTALS_PVT.pls 120.7.12020000.2 2013/02/11 01:53:49 vegajula ship $
3 -------------------------------------------------------------------------------
4 -- Package global constants
5 -------------------------------------------------------------------------------
6 -- doc types
7 g_doc_type_PO CONSTANT
8 PO_DOCUMENT_TYPES.document_type_code%TYPE
9 := PO_CORE_S.g_doc_type_PO;
10 g_doc_type_RELEASE CONSTANT
11 PO_DOCUMENT_TYPES.document_type_code%TYPE
12 := PO_CORE_S.g_doc_type_RELEASE;
13
14 -- doc subtypes
15 g_doc_subtype_STANDARD CONSTANT
16 PO_HEADERS_ALL.type_lookup_code%TYPE
17 := 'STANDARD';
18 g_doc_subtype_PLANNED CONSTANT
19 PO_HEADERS_ALL.type_lookup_code%TYPE
20 := 'PLANNED';
21 g_doc_subtype_BLANKET CONSTANT
22 PO_RELEASES_ALL.release_type%TYPE
23 := 'BLANKET';
24 g_doc_subtype_SCHEDULED CONSTANT
25 PO_RELEASES_ALL.release_type%TYPE
26 := 'SCHEDULED';
27
28 -- doc levels
29 g_doc_level_HEADER CONSTANT
30 VARCHAR2(25)
31 := PO_CORE_S.g_doc_level_HEADER;
32 g_doc_level_LINE CONSTANT
33 VARCHAR2(25)
34 := PO_CORE_S.g_doc_level_LINE;
35 g_doc_level_SHIPMENT CONSTANT
36 VARCHAR2(25)
37 := PO_CORE_S.g_doc_level_SHIPMENT;
38 g_doc_level_DISTRIBUTION CONSTANT
39 VARCHAR2(25)
40 := PO_CORE_S.g_doc_level_DISTRIBUTION;
41
42 g_data_source_TRANSACTION CONSTANT
43 VARCHAR2(15) := 'TRANSACTION';
44
45 g_data_source_ARCHIVE CONSTANT
46 VARCHAR2(15) := 'ARCHIVE';
47
48 -------------------------------------------------------------------------------
49 -- Spec definitions for public procedures
50 -------------------------------------------------------------------------------
51 FUNCTION getAmountOrdered(
52 p_doc_level IN VARCHAR2
53 , p_doc_level_id IN NUMBER
54 , p_data_source IN VARCHAR2
55 , p_doc_revision_num IN NUMBER DEFAULT NULL
56 , p_draft_id IN NUMBER DEFAULT -1 -- <Mod Project>
57 ) RETURN NUMBER;
58
59
60 FUNCTION getAmountApprovedForLine(
61 p_line_id IN NUMBER
62 , p_data_source IN VARCHAR2
63 , p_doc_revision_num IN NUMBER DEFAULT NULL
64 ) RETURN NUMBER;
65
66
67 FUNCTION getAmountApprovedForHeader(
68 p_header_id IN NUMBER
69 , p_data_source IN VARCHAR2
70 , p_doc_revision_num IN NUMBER DEFAULT NULL
71 ) RETURN NUMBER;
72
73
74 FUNCTION getAmountDeliveredForLine(
75 p_line_id IN NUMBER
76 , p_data_source IN VARCHAR2
77 , p_doc_revision_num IN NUMBER DEFAULT NULL
78 ) RETURN NUMBER;
79
80
81 FUNCTION getAmountDeliveredForHeader(
82 p_header_id IN NUMBER
83 , p_data_source IN VARCHAR2
84 , p_doc_revision_num IN NUMBER DEFAULT NULL
85 ) RETURN NUMBER;
86
87
88 FUNCTION getAmountBilledForLine(
89 p_line_id IN NUMBER
90 , p_data_source IN VARCHAR2
91 , p_doc_revision_num IN NUMBER DEFAULT NULL
92 ) RETURN NUMBER;
93
94
95 FUNCTION getAmountBilledForHeader(
96 p_header_id IN NUMBER
97 , p_data_source IN VARCHAR2
98 , p_doc_revision_num IN NUMBER DEFAULT NULL
99 ) RETURN NUMBER;
100
101
102 FUNCTION getAmountFinancedForLine(
103 p_line_id IN NUMBER
104 , p_data_source IN VARCHAR2
105 , p_doc_revision_num IN NUMBER DEFAULT NULL
106 ) RETURN NUMBER;
107
108
109 FUNCTION getAmountFinancedForHeader(
110 p_header_id IN NUMBER
111 , p_data_source IN VARCHAR2
112 , p_doc_revision_num IN NUMBER DEFAULT NULL
113 ) RETURN NUMBER;
114
115
116 FUNCTION getAmountRecoupedForLine(
117 p_line_id IN NUMBER
118 , p_data_source IN VARCHAR2
119 , p_doc_revision_num IN NUMBER DEFAULT NULL
120 ) RETURN NUMBER;
121
122
123 FUNCTION getAmountRecoupedForHeader(
124 p_header_id IN NUMBER
125 , p_data_source IN VARCHAR2
126 , p_doc_revision_num IN NUMBER DEFAULT NULL
127 ) RETURN NUMBER;
128
129
130 FUNCTION getAmountRetainedForLine(
131 p_line_id IN NUMBER
132 , p_data_source IN VARCHAR2
133 , p_doc_revision_num IN NUMBER DEFAULT NULL
134 ) RETURN NUMBER;
135
136
137 FUNCTION getAmountRetainedForHeader(
138 p_header_id IN NUMBER
139 , p_data_source IN VARCHAR2
140 , p_doc_revision_num IN NUMBER DEFAULT NULL
141 ) RETURN NUMBER;
142
143
144 FUNCTION getLineLocQuantityForLine(
145 p_line_id IN NUMBER,
146 p_draft_id IN NUMBER DEFAULT -1 -- <Mod Project>
147 ) RETURN NUMBER;
148
149
150 FUNCTION getLineLocAmountForLine(
151 p_line_id IN NUMBER,
152 p_draft_id IN NUMBER DEFAULT -1 -- <Mod Project>
153 ) RETURN NUMBER;
154
155
156 FUNCTION getDistQuantityForLineLoc(
157 p_line_loc_id IN NUMBER,
158 p_draft_id IN NUMBER DEFAULT -1 -- <Mod Project>
159 ) RETURN NUMBER;
160
161
162 FUNCTION getDistAmountForLineLoc(
163 p_line_loc_id IN NUMBER,
164 p_draft_id IN NUMBER DEFAULT -1 -- <Mod Project>
165 ) RETURN NUMBER;
166
167 -- CLM Partial Funding Changes
168 FUNCTION getEncumberedAmountForDist(
169 p_distribution_id IN NUMBER
170 ) RETURN NUMBER;
171
172 -- TODO: obsolete the 2 signatures below once impact to all
173 -- callers is handled
174 PROCEDURE get_order_totals(
175 p_doc_type IN VARCHAR2,
176 p_doc_subtype IN VARCHAR2,
177 p_doc_level IN VARCHAR2,
178 p_doc_level_id IN NUMBER,
179 x_quantity_total OUT NOCOPY NUMBER,
180 x_amount_total OUT NOCOPY NUMBER,
181 x_quantity_delivered OUT NOCOPY NUMBER,
182 x_amount_delivered OUT NOCOPY NUMBER,
183 x_quantity_received OUT NOCOPY NUMBER,
184 x_amount_received OUT NOCOPY NUMBER,
185 x_quantity_shipped OUT NOCOPY NUMBER,
186 x_amount_shipped OUT NOCOPY NUMBER,
187 x_quantity_billed OUT NOCOPY NUMBER,
188 x_amount_billed OUT NOCOPY NUMBER,
189 x_quantity_financed OUT NOCOPY NUMBER,
190 x_amount_financed OUT NOCOPY NUMBER,
191 x_quantity_recouped OUT NOCOPY NUMBER,
192 x_amount_recouped OUT NOCOPY NUMBER,
193 x_retainage_withheld_amount OUT NOCOPY NUMBER,
194 x_retainage_released_amount OUT NOCOPY NUMBER
195 );
196
197
198 PROCEDURE get_order_totals_from_archive(
199 p_doc_type IN VARCHAR2,
200 p_doc_subtype IN VARCHAR2,
201 p_doc_level IN VARCHAR2,
202 p_doc_level_id IN NUMBER,
203 p_doc_revision_num IN NUMBER,
204 x_quantity_total OUT NOCOPY NUMBER,
205 x_amount_total OUT NOCOPY NUMBER,
206 x_quantity_delivered OUT NOCOPY NUMBER,
207 x_amount_delivered OUT NOCOPY NUMBER,
208 x_quantity_received OUT NOCOPY NUMBER,
209 x_amount_received OUT NOCOPY NUMBER,
210 x_quantity_shipped OUT NOCOPY NUMBER,
211 x_amount_shipped OUT NOCOPY NUMBER,
212 x_quantity_billed OUT NOCOPY NUMBER,
213 x_amount_billed OUT NOCOPY NUMBER,
214 x_quantity_financed OUT NOCOPY NUMBER,
215 x_amount_financed OUT NOCOPY NUMBER,
216 x_quantity_recouped OUT NOCOPY NUMBER,
217 x_amount_recouped OUT NOCOPY NUMBER,
218 x_retainage_withheld_amount OUT NOCOPY NUMBER,
219 x_retainage_released_amount OUT NOCOPY NUMBER
220 );
221
222 FUNCTION getAmountOrderedExclOptions(
223 p_doc_level IN VARCHAR2
224 , p_doc_level_id IN NUMBER
225 , p_data_source IN VARCHAR2
226 , p_doc_revision_num IN NUMBER default null
227 , p_draft_id IN NUMBER DEFAULT -1 -- <Mod Project>
228 ) RETURN NUMBER;
229
230 -- CLM Phase 4 - Elins project
231 FUNCTION getValueForExhibit(
232 p_exhibit_name IN VARCHAR2
233 , p_doc_id IN NUMBER
234 , p_data_source IN VARCHAR2 DEFAULT g_data_source_TRANSACTION
235 , p_draft_id IN NUMBER DEFAULT -1
236 ) RETURN NUMBER;
237
238 END PO_DOCUMENT_TOTALS_PVT;