1 PACKAGE PJM_TRANSFER_IPV_PKG AUTHID CURRENT_USER AS
2 /* $Header: PJMTIPVS.pls 115.13 2004/08/18 04:18:53 yliou ship $ */
3
4 Function Batch_Name return varchar2;
5
6 Function get_ipv_expenditure_type(X_Project_Id IN NUMBER,
7 X_Org_Id IN NUMBER) return varchar2;
8
9 Function get_erv_expenditure_type(X_Project_Id IN NUMBER,
10 X_Org_Id IN NUMBER) return varchar2;
11
12
13 ---------------------------------------------------------------------------
14 -- PUBLIC PROCEDURE
15 -- Transfer_IPV_to_PA
16 --
17 -- DESCRIPTION
18 -- This procedure will get the expenditure and costing data from Invoice
19 -- Distributions which has IPV amount and the destination type is
20 -- INVENTORY. And then push these data to PA_TRANSACTION_INTERFACES.
21 --
22 -- PARAMETERS
23 -- X_Project_Id IN
24 -- X_Start_Date IN
25 -- X_End_Date IN
26 -- ERRBUF OUT
27 -- RETCODE OUT
28 --
29 ---------------------------------------------------------------------------
30
31 PROCEDURE Transfer_IPV_to_PA
32 ( ERRBUF OUT NOCOPY VARCHAR2
33 , RETCODE OUT NOCOPY NUMBER
34 , X_Project_Id IN NUMBER
35 , X_Start_Date IN VARCHAR2
36 , X_End_Date IN VARCHAR2
37 , X_Submit_Trx_Import IN VARCHAR2
38 , X_Trx_Status_Code IN VARCHAR2
39 );
40
41 END PJM_TRANSFER_IPV_PKG;