1 PACKAGE FII_BUDGET_INTERFACE_PKG AS
2 /* $Header: FIIBUINS.pls 120.5 2005/10/30 05:07:40 appldev noship $ */
3
4 --
5 -- PUBLIC VARIABLES
6 --
7
8 --
9 -- PUBLIC PROCEDURES
10
11 --
12 -- Procedure
13 -- Web_Adi_Upload
14 -- Purpose
15 -- This is the routine called by Web ADI for uploading records
16 -- into FII_BUDGET_INTERFACE
17 -- History
18 -- 07-22-02 S Kung Created
19 -- Arguments
20 -- All columns in the FII_BUDGET_INTERFACE table
21 -- Example
22 -- FII_BUDGET_INTERFACE.Web_Adi_Upload;
23 -- Notes
24 --
25 FUNCTION Web_Adi_Upload
26 ( X_RowID IN VARCHAR2 DEFAULT NULL,
27 X_Plan_Type IN VARCHAR2,
28 X_Version_Date IN VARCHAR2 DEFAULT NULL,
29 X_Time_Period IN VARCHAR2 DEFAULT NULL,
30 X_Date IN DATE DEFAULT NULL,
31 X_Company IN VARCHAR2 DEFAULT NULL,
32 X_Cost_Center IN VARCHAR2 DEFAULT NULL,
33 X_CCC IN NUMBER DEFAULT NULL,
34 X_LOB IN VARCHAR2 DEFAULT NULL,
35 X_Acct IN VARCHAR2 DEFAULT NULL,
36 X_Fin_Item IN VARCHAR2 DEFAULT NULL,
37 X_Product IN NUMBER DEFAULT NULL,
38 X_User_Defined_Dim IN VARCHAR2 DEFAULT NULL,
39 X_Prim_Amt IN NUMBER,
40 X_Rate IN NUMBER DEFAULT NULL,
41 X_Sec_Amt IN NUMBER DEFAULT NULL,
42 X_Ledger IN NUMBER DEFAULT NULL
43 ) return VARCHAR2;
44
45 END FII_BUDGET_INTERFACE_PKG;
46