[Home] [Help]
PACKAGE: APPS.PO_DOCUMENT_TOTALS_PVT
Source
1 PACKAGE PO_DOCUMENT_TOTALS_PVT AS
2 -- $Header: PO_DOCUMENT_TOTALS_PVT.pls 120.3 2006/06/29 19:43:50 arusingh noship $
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 ) RETURN NUMBER;
57
58
59 FUNCTION getAmountApprovedForLine(
60 p_line_id IN NUMBER
61 , p_data_source IN VARCHAR2
62 , p_doc_revision_num IN NUMBER DEFAULT NULL
63 ) RETURN NUMBER;
64
65
66 FUNCTION getAmountApprovedForHeader(
67 p_header_id IN NUMBER
68 , p_data_source IN VARCHAR2
69 , p_doc_revision_num IN NUMBER DEFAULT NULL
70 ) RETURN NUMBER;
71
72
73 FUNCTION getAmountDeliveredForLine(
74 p_line_id IN NUMBER
75 , p_data_source IN VARCHAR2
76 , p_doc_revision_num IN NUMBER DEFAULT NULL
77 ) RETURN NUMBER;
78
79
80 FUNCTION getAmountDeliveredForHeader(
81 p_header_id IN NUMBER
82 , p_data_source IN VARCHAR2
83 , p_doc_revision_num IN NUMBER DEFAULT NULL
84 ) RETURN NUMBER;
85
86
87 FUNCTION getAmountBilledForLine(
88 p_line_id IN NUMBER
89 , p_data_source IN VARCHAR2
90 , p_doc_revision_num IN NUMBER DEFAULT NULL
91 ) RETURN NUMBER;
92
93
94 FUNCTION getAmountBilledForHeader(
95 p_header_id IN NUMBER
96 , p_data_source IN VARCHAR2
97 , p_doc_revision_num IN NUMBER DEFAULT NULL
98 ) RETURN NUMBER;
99
100
101 FUNCTION getAmountFinancedForLine(
102 p_line_id IN NUMBER
103 , p_data_source IN VARCHAR2
104 , p_doc_revision_num IN NUMBER DEFAULT NULL
105 ) RETURN NUMBER;
106
107
108 FUNCTION getAmountFinancedForHeader(
109 p_header_id IN NUMBER
110 , p_data_source IN VARCHAR2
111 , p_doc_revision_num IN NUMBER DEFAULT NULL
112 ) RETURN NUMBER;
113
114
115 FUNCTION getAmountRecoupedForLine(
116 p_line_id IN NUMBER
117 , p_data_source IN VARCHAR2
118 , p_doc_revision_num IN NUMBER DEFAULT NULL
119 ) RETURN NUMBER;
120
121
122 FUNCTION getAmountRecoupedForHeader(
123 p_header_id IN NUMBER
124 , p_data_source IN VARCHAR2
125 , p_doc_revision_num IN NUMBER DEFAULT NULL
126 ) RETURN NUMBER;
127
128
129 FUNCTION getAmountRetainedForLine(
130 p_line_id IN NUMBER
131 , p_data_source IN VARCHAR2
132 , p_doc_revision_num IN NUMBER DEFAULT NULL
133 ) RETURN NUMBER;
134
135
136 FUNCTION getAmountRetainedForHeader(
137 p_header_id IN NUMBER
138 , p_data_source IN VARCHAR2
139 , p_doc_revision_num IN NUMBER DEFAULT NULL
140 ) RETURN NUMBER;
141
142
143 FUNCTION getLineLocQuantityForLine(
144 p_line_id IN NUMBER
145 ) RETURN NUMBER;
146
147
148 FUNCTION getLineLocAmountForLine(
149 p_line_id IN NUMBER
150 ) RETURN NUMBER;
151
152
153 FUNCTION getDistQuantityForLineLoc(
154 p_line_loc_id IN NUMBER
155 ) RETURN NUMBER;
156
157
158 FUNCTION getDistAmountForLineLoc(
159 p_line_loc_id IN NUMBER
160 ) RETURN NUMBER;
161
162
163
164 -- TODO: obsolete the 2 signatures below once impact to all
165 -- callers is handled
166 PROCEDURE get_order_totals(
167 p_doc_type IN VARCHAR2,
168 p_doc_subtype IN VARCHAR2,
169 p_doc_level IN VARCHAR2,
170 p_doc_level_id IN NUMBER,
171 x_quantity_total OUT NOCOPY NUMBER,
172 x_amount_total OUT NOCOPY NUMBER,
173 x_quantity_delivered OUT NOCOPY NUMBER,
174 x_amount_delivered OUT NOCOPY NUMBER,
175 x_quantity_received OUT NOCOPY NUMBER,
176 x_amount_received OUT NOCOPY NUMBER,
177 x_quantity_shipped OUT NOCOPY NUMBER,
178 x_amount_shipped OUT NOCOPY NUMBER,
179 x_quantity_billed OUT NOCOPY NUMBER,
180 x_amount_billed OUT NOCOPY NUMBER,
181 x_quantity_financed OUT NOCOPY NUMBER,
182 x_amount_financed OUT NOCOPY NUMBER,
183 x_quantity_recouped OUT NOCOPY NUMBER,
184 x_amount_recouped OUT NOCOPY NUMBER,
185 x_retainage_withheld_amount OUT NOCOPY NUMBER,
186 x_retainage_released_amount OUT NOCOPY NUMBER
187 );
188
189
190 PROCEDURE get_order_totals_from_archive(
191 p_doc_type IN VARCHAR2,
192 p_doc_subtype IN VARCHAR2,
193 p_doc_level IN VARCHAR2,
194 p_doc_level_id IN NUMBER,
195 p_doc_revision_num IN NUMBER,
196 x_quantity_total OUT NOCOPY NUMBER,
197 x_amount_total OUT NOCOPY NUMBER,
198 x_quantity_delivered OUT NOCOPY NUMBER,
199 x_amount_delivered OUT NOCOPY NUMBER,
200 x_quantity_received OUT NOCOPY NUMBER,
201 x_amount_received OUT NOCOPY NUMBER,
202 x_quantity_shipped OUT NOCOPY NUMBER,
203 x_amount_shipped OUT NOCOPY NUMBER,
204 x_quantity_billed OUT NOCOPY NUMBER,
205 x_amount_billed OUT NOCOPY NUMBER,
206 x_quantity_financed OUT NOCOPY NUMBER,
207 x_amount_financed OUT NOCOPY NUMBER,
208 x_quantity_recouped OUT NOCOPY NUMBER,
209 x_amount_recouped OUT NOCOPY NUMBER,
210 x_retainage_withheld_amount OUT NOCOPY NUMBER,
211 x_retainage_released_amount OUT NOCOPY NUMBER
212 );
213
214
215
216 END PO_DOCUMENT_TOTALS_PVT;