1 PACKAGE IEU_PUB AUTHID CURRENT_USER AS
2 /* $Header: IEU_PS.pls 120.0 2005/06/02 15:42:38 appldev noship $ */
3
4
5 TYPE EnumeratorDataRecord IS RECORD (
6 NODE_LABEL IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE,
7 VIEW_NAME IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE,
8 DATA_SOURCE IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE,
9 MEDIA_TYPE_ID IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE,
10 WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
11 NODE_TYPE IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE,
12 HIDE_IF_EMPTY IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE,
13 NODE_DEPTH NUMBER(2),
14 BIND_VARS VARCHAR2(4000),
15 REFRESH_VIEW_NAME IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE,
16 RES_CAT_ENUM_FLAG IEU_UWQ_SEL_RT_NODES.RES_CAT_ENUM_FLAG%TYPE,
17 REFRESH_VIEW_SUM_COL IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE := NULL
18 );
19
20 TYPE EnumeratorDataRecordList IS
21 TABLE OF EnumeratorDataRecord INDEX BY BINARY_INTEGER;
22
23 TYPE BindVariableRecord IS RECORD (
24 BIND_VAR_NAME IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_NAME%TYPE,
25 BIND_VAR_VALUE IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_VALUE%TYPE,
26 BIND_VAR_DATA_TYPE IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_DATATYPE%TYPE
27 );
28
29 TYPE BindVariableRecordList IS
30 TABLE OF BindVariableRecord INDEX BY BINARY_INTEGER;
31
32 TYPE PluginDataRecord is RECORD (
33 DATASET_REC_ID NUMBER,
34 NAME VARCHAR2(4000),
35 VALUE VARCHAR2(4000),
36 TYPE VARCHAR2(4000));
37
38 TYPE PluginDataRecList IS
39 TABLE OF PluginDataRecord INDEX BY BINARY_INTEGER;
40
41 TYPE NodeDetailRecord IS RECORD (
42 NODE_TYPE IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE,
43 NODE_RUNTIME_WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
44 COMPLETE_WHERE_CLAUSE VARCHAR2(4000),
45 VIEW_NAME IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE,
46 REFRESH_VIEW_NAME IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE,
47 REFRESH_VIEW_SUM_COL IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE := NULL,
48 RAW_NODE_RUNTIME_WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
49 RAW_COMPLETE_WHERE_CLAUSE VARCHAR2(4000)
50 );
51
52 TYPE NodeDetailRecList IS
53 TABLE OF NodeDetailRecord INDEX BY BINARY_INTEGER;
54
55 /* Used to convert the Bind variable Data from Table Of Records to a String
56 <name1=val1><name2=val2> */
57 FUNCTION SET_BIND_VAR_DATA(P_BindDataList IN BindVariableRecordList)
58 RETURN VARCHAR2;
59
60 /* Used to get the Resource Categorization Where Clause based on sel_enum_id */
61 FUNCTION GET_ENUM_RES_CAT(P_SEL_ENUM_ID IN NUMBER)
62 RETURN VARCHAR2;
63
64 /* Used to determine if agent is eligible for ANY media */
65 FUNCTION IS_AGENT_ELIGIBLE_FOR_MEDIA( P_RESOURCE_ID IN NUMBER )
66 RETURN BOOLEAN;
67
68
69 /* Used to determine if a connection to the UWQ server is required */
70 FUNCTION IS_UWQ_SERVER_REQUIRED( P_RESOURCE_ID IN NUMBER )
71 RETURN BOOLEAN;
72
73
74 PROCEDURE ADD_UWQ_NODE_DATA
75 (P_RESOURCE_ID IN NUMBER,
76 P_SEL_ENUM_ID IN NUMBER,
77 P_ENUMERATOR_DATAREC_LIST IN IEU_PUB.EnumeratorDataRecordList
78 );
79
80 PROCEDURE GET_UWQ_NODE_DETAILS
81 (P_RESOURCE_ID IN NUMBER,
82 P_NODE_ID IN NUMBER,
83 X_NODE_DETAIL_RECORD OUT NOCOPY IEU_PUB.NodeDetailRecord);
84
85 PROCEDURE GET_UWQ_NODE_DETAILS
86 (P_RESOURCE_ID IN NUMBER,
87 P_NODE_ID IN NUMBER,
88 X_NODE_DETAIL_RECORD OUT NOCOPY IEU_PUB.NodeDetailRecord,
89 X_BIND_VARIABLE_RECORD_LIST OUT NOCOPY IEU_PUB.BindVariableRecordList);
90
91 END IEU_PUB;
92