1 PACKAGE ZPB_AW_STATUS AS
2 /* $Header: zpb_aw_status.pls 120.0.12010.4 2006/08/03 12:08:09 appldev noship $ */
3
4
5 ------------------------------------------------------------------------------
6 -- GET_STATUS
7 --
8 -- Takes a query defined in ZPB_SQL_STATUS and sets the status of the
9 -- LASTQUERYVS for each dimension defined in that query. Also sets the
10 -- LASTQUERYDIMVS structure for all dimensions affected by the query
11 --
12 -- IN: p_aw - The AW the query is defined on
13 -- p_query - The query name
14 ------------------------------------------------------------------------------
15 PROCEDURE GET_STATUS (p_aw IN VARCHAR2,
16 p_query IN VARCHAR2);
17
18 ------------------------------------------------------------------------------
19 -- GET__EXCPETION_STATUS
20 --
21 -- Takes a query defined in ZPB_SQL_STATUS and sets the status of the
22 -- LASTQUERYVS for each dimension defined in that query. Also sets the
23 -- LASTQUERYDIMVS structure for all dimensions affected by the query
24 --
25 -- This query is expected to be defined on the exception table. The instance
26 -- passed in will modify the SQL to be executed on the current instance view
27 -- of that instance/BP
28 --
29 -- IN: p_aw - The AW the query is defined on
30 -- p_query - The query name
31 ------------------------------------------------------------------------------
32 PROCEDURE GET_EXCEPTION_STATUS (p_user_id IN VARCHAR2,
33 p_query IN VARCHAR2,
34 p_instance IN VARCHAR2);
35
36 ------------------------------------------------------------------------------
37 -- GET_QUERY_DIMS
38 --
39 -- Sets the LastQueryDimVS for the dimensions that are part of the query
40 ------------------------------------------------------------------------------
41 PROCEDURE GET_QUERY_DIMS (p_aw IN VARCHAR2,
42 p_query IN VARCHAR2);
43
44 ------------------------------------------------------------------------------
45 -- GET_STATUS_COUNT
46 --
47 -- Returns the # of dimension members that are part of a particular query and
48 -- dimension. p_dimension is the AW name of the dimension, like CCTR_ORGS
49 ------------------------------------------------------------------------------
50 FUNCTION GET_STATUS_COUNT (p_aw IN VARCHAR2,
51 p_query IN VARCHAR2,
52 p_dimension IN VARCHAR2)
53 return NUMBER;
54
55 PROCEDURE SET_PERSONAL_ALIAS_FLAG ;
56 PROCEDURE RESET_PERSONAL_ALIAS_FLAG ;
57 FUNCTION GET_PERSONAL_ALIAS_FLAG return VARCHAR2 ;
58
59 END ZPB_AW_STATUS;