1 PACKAGE FII_PMV_HELPER_TABLES_C AS
2 /* $Header: FIIPMVHS.pls 120.1 2005/10/30 05:05:43 appldev noship $ */
3
4 -- *******************************************************************
5 -- Package level variables
6 -- *******************************************************************
7
8
9 FIIDIM_Debug BOOLEAN := FALSE;
10 FII_User_Id NUMBER := NULL;
11 FII_Login_Id NUMBER := NULL;
12 FII_Req_Id NUMBER := NULL;
13 PMVH_fatal_err EXCEPTION;
14
15 TYPE dim_nodes_rec is RECORD (number_of_nodes number (15), dim_short_name varchar2 (30), gain number);
16 type dim_nodes_tab is table of dim_nodes_rec
17 index by binary_integer;
18
19 -- ************************************************************************
20 -- Procedure
21 -- Load_Main This is the main procedure of PMV Helper Table Population
22 -- program.
23 -- It will take in all parameters, initialize all necessary
24 -- variables and start calling the appropriate routines.
25 -- Arguments
26 -- p_load_mode Load Mode INIT/INCRE
27 -- errbuf Standard error buffer
28 -- retcode Standard return code
29
30 PROCEDURE Load_Main (errbuf OUT NOCOPY VARCHAR2,
31 retcode OUT NOCOPY VARCHAR2,
32 p_load_mode IN VARCHAR2);
33
34 END FII_PMV_HELPER_TABLES_C;