1 PACKAGE AP_CLM_PVT_PKG AUTHID CURRENT_USER AS
2 /* $Header: apclmpfs.pls 120.0.12010000.5 2010/03/23 07:07:38 sjetti noship $ */
3
4 -- This function will determine whether a PO is a clm PO.
5 FUNCTION is_clm_po
6 (
7 p_po_header_id IN NUMBER DEFAULT NULL,
8 p_po_line_id IN NUMBER DEFAULT NULL,
9 p_po_line_location_id IN NUMBER DEFAULT NULL,
10 p_po_distribution_id IN NUMBER DEFAULT NULL
11 )
12 RETURN VARCHAR2;
13
14 -- This function will determine whether CLM is installed
15 FUNCTION is_clm_installed
16 RETURN VARCHAR2;
17
18 -- This procedure returns the PO Funding Information for a given entity id
19 PROCEDURE Get_Funding_Info
20 (
21 p_PO_HEADER_ID IN NUMBER DEFAULT NULL,
22 p_PO_LINE_ID IN NUMBER DEFAULT NULL,
23 p_LINE_LOCATION_ID IN NUMBER DEFAULT NULL,
24 p_PO_DISTRIBUTION_ID IN NUMBER DEFAULT NULL,
25 x_DISTRIBUTION_TYPE OUT NOCOPY VARCHAR2,
26 x_MATCHING_BASIS OUT NOCOPY VARCHAR2,
27 x_ACCRUE_ON_RECEIPT_FLAG OUT NOCOPY VARCHAR2,
28 x_CODE_COMBINATION_ID OUT NOCOPY NUMBER,
29 x_BUDGET_ACCOUNT_ID OUT NOCOPY NUMBER,
30 x_PARTIAL_FUNDED_FLAG OUT NOCOPY VARCHAR2,
31 x_UNIT_MEAS_LOOKUP_CODE OUT NOCOPY VARCHAR2,
32 x_FUNDED_VALUE OUT NOCOPY NUMBER,
33 x_QUANTITY_FUNDED OUT NOCOPY NUMBER,
34 x_AMOUNT_FUNDED OUT NOCOPY NUMBER,
35 x_QUANTITY_RECEIVED OUT NOCOPY NUMBER,
36 x_AMOUNT_RECEIVED OUT NOCOPY NUMBER,
37 x_QUANTITY_DELIVERED OUT NOCOPY NUMBER,
38 x_AMOUNT_DELIVERED OUT NOCOPY NUMBER,
39 x_QUANTITY_BILLED OUT NOCOPY NUMBER,
40 x_AMOUNT_BILLED OUT NOCOPY NUMBER,
41 x_QUANTITY_CANCELLED OUT NOCOPY NUMBER,
42 x_AMOUNT_CANCELLED OUT NOCOPY NUMBER,
43 X_RETURN_STATUS OUT NOCOPY VARCHAR2) ;
44 END ;