1 PACKAGE POR_RCV_POST_QUERY_PKG AUTHID CURRENT_USER AS
2 /* $Header: PORRCVQS.pls 120.1 2012/01/03 05:15:37 mzhussai ship $ */
3
4 procedure getDetails(pItemId IN NUMBER,
5 pOrgId IN NUMBER,
6 pRequestorId IN NUMBER,
7 pDistributionId IN NUMBER,
8 pOrderType IN VARCHAR2,
9 pReqLineId IN OUT NOCOPY NUMBER,
10 pItemNumber OUT NOCOPY VARCHAR2,
11 pRequestorName OUT NOCOPY VARCHAR2,
12 pReqNum OUT NOCOPY VARCHAR2,
13 pReqHeaderId OUT NOCOPY NUMBER,
14 pSPN OUT NOCOPY VARCHAR2,
15 pDistributionNum OUT NOCOPY NUMBER);
16
17 function getReqNum(pOrderType IN VARCHAR2,
18 pReqLineId IN Number,
19 pDistributionId IN Number) RETURN VARCHAR2;
20
21
22 procedure getItemNumber(pItemId IN NUMBER,
23 pOrgId IN NUMBER,
24 pItemNum OUT NOCOPY VARCHAR2);
25
26 procedure getRequestorName(pRequestorId IN NUMBER,
27 pName OUT NOCOPY VARCHAR2);
28
29 procedure getReqInfoREQ(pReqLineId IN NUMBER,
30 pReqNum OUT NOCOPY VARCHAR2,
31 pReqHeaderId OUT NOCOPY NUMBER);
32
33 procedure getReqInfo(pDistributionId IN NUMBER,
34 pReqNum OUT NOCOPY VARCHAR2,
35 pReqHeaderId OUT NOCOPY NUMBER,
36 pReqLineId OUT NOCOPY NUMBER);
37
38 procedure getSPN(pDistributionId IN NUMBER,
39 pSPN OUT NOCOPY VARCHAR2,
40 pDistributionNum OUT NOCOPY NUMBER);
41
42 function getOrderType(pOrderTypeCode IN VARCHAR2) RETURN VARCHAR2;
43
44 function getOrderNumber(pReqHeaderId IN NUMBER,pFederalFlag IN VARCHAR2) RETURN VARCHAR2;
45 function getSupplier(pReqHeaderId IN NUMBER,pFederalFlag IN VARCHAR2) RETURN VARCHAR2;
46
47
48 END POR_RCV_POST_QUERY_PKG;