DBA Data[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;