1 PACKAGE AP_ACCOUNTING_UTILITIES_PKG AUTHID CURRENT_USER AS
2 /* $Header: apslauts.pls 115.3 2004/04/02 18:46:41 schitlap noship $ */
3
4 /*============================================================================
5 | FUNCTION - Get_PO_REVERSED_ENCUMB_AMOUNT
6 |
7 | DESCRIPTION
8 | fetch the amount of PO encumbrance reversed against the given PO
9 | distribution from all invoices for a given date range in functional
10 | currency. Calculation includes PO encumbrance which are in GL only.
11 | In case Invoice encumbrance type is the same as PO encumbrance, we
12 | need to exclude the variance.
13 | it returns actual amount or 0 if there is po reversed encumbrance
14 | line existing, otherwise returns NULL.
15 |
16 | PARAMETERS
17 | P_Po_distribution_id - po_distribution_id (in)
18 | P_Start_date - Start gl date (in)
19 | P_End_date - End gl date (in)
20 | P_Calling_Sequence - debug usage
21 |
22 | KNOWN ISSUES:
23 |
24 | NOTES:
25 |
26 | 1. In case user changes the purchase order encumbrance
27 | type or Invoice encumbrance type after invoice is
28 | validated, this API might not return a valid value.
29 |
30 | MODIFICATION HISTORY
31 | Date Author Description of Change
32 |
33 *===========================================================================*/
34
35 FUNCTION Get_PO_Reversed_Encumb_Amount(
36 P_Po_Distribution_Id IN NUMBER,
37 P_Start_gl_Date IN DATE,
38 P_End_gl_Date IN DATE,
39 P_Calling_Sequence IN VARCHAR2 DEFAULT NULL)
40
41 RETURN NUMBER;
42
43 PRAGMA RESTRICT_REFERENCES(Get_PO_Reversed_Encumb_Amount, WNDS, WNPS);
44
45 END AP_ACCOUNTING_UTILITIES_PKG;
46