1 PACKAGE PO_CLM_INTG_GRP AUTHID CURRENT_USER AS
2 -- $Header: PO_CLM_INTG_GRP.pls 120.4 2010/04/07 15:19:40 ssreekum 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 function will determine wheter its a clm document or Not
19 FUNCTION is_clm_document(p_doc_type IN VARCHAR2, p_document_id IN NUMBER) RETURN VARCHAR2;
20
21 -- This procedure returns the PO Funding Information for a given entity id
22 PROCEDURE Get_Funding_Info
23 (
24 p_PO_HEADER_ID IN NUMBER DEFAULT NULL,
25 p_PO_LINE_ID IN NUMBER DEFAULT NULL,
26 p_LINE_LOCATION_ID IN NUMBER DEFAULT NULL,
27 p_PO_DISTRIBUTION_ID IN NUMBER DEFAULT NULL,
28 x_DISTRIBUTION_TYPE OUT NOCOPY VARCHAR2,
29 x_MATCHING_BASIS OUT NOCOPY VARCHAR2,
30 x_ACCRUE_ON_RECEIPT_FLAG OUT NOCOPY VARCHAR2,
31 x_CODE_COMBINATION_ID OUT NOCOPY NUMBER,
32 x_BUDGET_ACCOUNT_ID OUT NOCOPY NUMBER,
33 x_PARTIAL_FUNDED_FLAG OUT NOCOPY VARCHAR2,
34 x_UNIT_MEAS_LOOKUP_CODE OUT NOCOPY VARCHAR2,
35 x_FUNDED_VALUE OUT NOCOPY NUMBER,
36 x_QUANTITY_FUNDED OUT NOCOPY NUMBER,
37 x_AMOUNT_FUNDED OUT NOCOPY NUMBER,
38 x_QUANTITY_RECEIVED OUT NOCOPY NUMBER,
39 x_AMOUNT_RECEIVED OUT NOCOPY NUMBER,
40 x_QUANTITY_DELIVERED OUT NOCOPY NUMBER,
41 x_AMOUNT_DELIVERED OUT NOCOPY NUMBER,
42 x_QUANTITY_BILLED OUT NOCOPY NUMBER,
43 x_AMOUNT_BILLED OUT NOCOPY NUMBER,
44 x_quantity_cancelled OUT NOCOPY NUMBER,
45 x_amount_cancelled OUT NOCOPY NUMBER,
46 X_RETURN_STATUS OUT NOCOPY VARCHAR2
47 );
48
49 Function Hide_Nonfunded(p_doc_type IN varchar2, p_header_id IN NUMBER, p_line_id IN NUMBER DEFAULT NULL, p_line_location_id IN NUMBER DEFAULT NULL, p_distribution_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
50 END PO_CLM_INTG_GRP;