1 PACKAGE PA_PWP_SUMM_PKG AS
2 -- $Header: PAPWPSMS.pls 120.0.12010000.2 2009/01/17 06:07:06 jjgeorge noship $
3
4 -- This procedure populates data in PA_PWP_CUSTOMER_SUMM_ALL table.
5 -- The data populated in PA_PWP_CUSTOMER_SUMM_ALL table is used in subcontractor
6 --(supplier) workbench.
7 Procedure Populate_summary(P_Project_Id IN Number);
8
9
10 --The function gets the AR invoice number of a Project's Draft invoice.
11 FUNCTION GET_RAINVOICE_NUM
12 (
13 P_PROJECT_ID IN NUMBER ,
14 P_DRAFT_INVOICE_NUM IN NUMBER ) RETURN VARCHAR2;
15
16
17 --The function gets the Invoice Date of a Project's Draft invoice.
18 FUNCTION GET_LAST_INVOICE_DATE
19 (
20 P_PROJECT_ID IN NUMBER ,
21 P_DRAFT_INVOICE_NUM IN NUMBER )
22 RETURN DATE;
23
24 END PA_PWP_SUMM_PKG;
25