PACKAGE: APPS.PA_PWP_INVOICE_REL

Source

1 PACKAGE PA_PWP_INVOICE_REL AUTHID CURRENT_USER AS
2 --  $Header: PAPWPRIS.pls 120.0.12010000.3 2008/11/24 06:50:29 jjgeorge noship $
3 
4    G_ORG_ID                         NUMBER;
5    G_REQUEST_ID                     NUMBER;
6    P_DEBUG_MODE                     VARCHAR(1);
7  /* TYPE OF MESSAGE */
8    LOG                      NUMBER := 1;
9    DEBUG                    NUMBER := 2;
10 
11 
12 Type InvoiceId Is Table Of AP_INVOICES_ALL.INVOICE_ID%Type Index By Binary_Integer;
13 
14 PROCEDURE  RELEASE_INVOICE (  ERRBUF                  OUT NOCOPY VARCHAR2
15                              ,RETCODE                 OUT NOCOPY VARCHAR2
16                              ,P_MODE           VARCHAR2
17                              ,P_PROJECT_TYPE       VARCHAR2
18                              ,P_PROJ_NUM          VARCHAR2
19                              ,P_FROM_PROJ_NUM    VARCHAR2
20                              ,P_TO_PROJ_NUM      VARCHAR2
21                              ,P_CUSTOMER_NAME    VARCHAR2
22                              ,P_CUSTOMER_NUMBER  NUMBER
23                              ,P_REC_DATE_FROM    VARCHAR2
24                              ,P_REC_DATE_TO      VARCHAR2
25 			                       ,P_SORT VARCHAR2
26 			    );
27 
28 
29 PROCEDURE PAAP_RELEASE_HOLD (P_INV_TBL          IN INVOICEID
30                               ,X_RETURN_STATUS   OUT NOCOPY VARCHAR2
31                               ,X_MSG_COUNT       OUT NOCOPY NUMBER
32                               ,X_MSG_DATA        OUT NOCOPY VARCHAR2);
33 
34 
35 PROCEDURE WRITE_LOG (   P_MESSAGE_TYPE   IN NUMBER,
36                         P_MESSAGE     IN VARCHAR2);
37 
38 FUNCTION IS_PROCESSED ( P_INVOICE_ID IN NUMBER )
39 	RETURN VARCHAR2 ;
40 
41 FUNCTION IS_ELIGIBLE ( P_INVOICE_ID IN NUMBER )
42 	RETURN VARCHAR2 ;
43 
44 FUNCTION IS_BILLED ( P_INVOICE_ID IN NUMBER )
45 	RETURN VARCHAR2 ;
46 END PA_PWP_INVOICE_REL;