1 PACKAGE PA_STRUCT_UPGR_PUB AS
2 /* $Header: PAPRUPGS.pls 120.0 2005/05/30 19:05:05 appldev noship $ */
3
4 -- Bug No. 4049574
5 G_PROJECT_ID NUMBER;
6
7 -- Global variable to store max wbs level
8 G_MAX_WBS_LEVEL NUMBER := 1;
9
10 TYPE INDEX_TABLE IS TABLE OF VARCHAR2(255)
11 INDEX BY BINARY_INTEGER;
12
13 G_WBS_NUM_TBL INDEX_TABLE;
14
15 FUNCTION GET_WBS_NUMBER
16 (p_wbs_level IN NUMBER, p_project_id IN NUMBER DEFAULT NULL)
17 RETURN VARCHAR2;
18
19 --maansari
20 TYPE display_sequence_table IS TABLE OF NUMBER
21 INDEX BY BINARY_INTEGER;
22 G_DISP_SEQ_TBL display_sequence_table;
23
24 FUNCTION GET_DISP_SEQUENCE
25 (p_display_sequence IN NUMBER)
26 RETURN NUMBER;
27
28 --maansari
29
30 PROCEDURE CLEAR_GLOBALS;
31
32 END PA_STRUCT_UPGR_PUB;