1 PACKAGE IEU_DEFAULT_MEDIA_ENUMS_PVT AUTHID CURRENT_USER AS
2 /* $Header: IEUENMVS.pls 120.0 2005/06/02 16:02:43 appldev noship $ */
3
4
5 -- Sub-Program Unit Declarations
6
7
8 PROCEDURE UPDATE_SEL_RT_NODE
9 (P_RESOURCE_ID IN IEU_UWQ_SEL_RT_NODES.RESOURCE_ID%TYPE
10 ,P_SEL_ENUM_ID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_ID%TYPE
11 ,P_NODE_ID IN IEU_UWQ_SEL_RT_NODES.NODE_ID%TYPE
12 ,P_NODE_TYPE IN IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE
13 ,P_NODE_LABEL IN IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE
14 ,P_DATA_SOURCE IN IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE
15 ,P_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE
16 ,P_MEDIA_TYPE_ID IN IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE
17 ,P_SEL_ENUM_PID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_PID%TYPE
18 ,P_NODE_PID IN IEU_UWQ_SEL_RT_NODES.NODE_PID%TYPE
19 ,P_NODE_WEIGHT IN IEU_UWQ_SEL_RT_NODES.NODE_WEIGHT%TYPE
20 ,P_WHERE_CLAUSE IN IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE
21 ,P_HIDE_IF_EMPTY IN IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE
22 ,P_REFRESH_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE
23 DEFAULT NULL
24 ,P_REFRESH_VIEW_SUM_COL IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE
25 DEFAULT NULL
26 ,P_NODE_DEPTH IN IEU_UWQ_SEL_RT_NODES.NODE_DEPTH%TYPE
27 DEFAULT NULL -- Niraj, Bug 4389449, Added to handle node depth passed by Media nodes of IEU
28 );
29
30 PROCEDURE CREATE_MYWORK_NODE
31 (P_RESOURCE_ID IN NUMBER
32 ,P_LANGUAGE IN VARCHAR2
33 ,P_SOURCE_LANG IN VARCHAR2
34 );
35
36 PROCEDURE CREATE_BLENDED_NODE
37 (P_RESOURCE_ID IN NUMBER
38 ,P_LANGUAGE IN VARCHAR2
39 ,P_SOURCE_LANG IN VARCHAR2
40 );
41
42 PROCEDURE ENUMERATE_MEDIA_NODES
43 (P_RESOURCE_ID IN NUMBER
44 ,P_LANGUAGE IN VARCHAR2
45 ,P_SOURCE_LANG IN VARCHAR2
46 ,P_NODE_ID IN NUMBER
47 ,P_SEL_ENUM_ID IN NUMBER
48 ,P_SEL_ENUM_PID IN NUMBER
49 ,P_DATA_SRC IN VARCHAR2
50 ,P_VIEW_NAME IN VARCHAR2
51 ,P_MEDIA_TYPE_ID IN NUMBER
52 ,P_LOOKUP_CODE IN VARCHAR2
53 ,P_P_LOOKUP_CODE IN VARCHAR2
54 ,P_HIDE_IF_EMPTY IN VARCHAR2
55 ,P_NODE_DEPTH IN NUMBER DEFAULT NULL -- Niraj, Bug 4389499, Added to handle node depth passed by Media nodes of IEU
56 );
57
58 PROCEDURE ENUMERATE_OUTBOUND_NODES
59 (P_RESOURCE_ID IN NUMBER
60 ,P_LANGUAGE IN VARCHAR2
61 ,P_SOURCE_LANG IN VARCHAR2
62 ,P_SEL_ENUM_ID IN NUMBER );
63
64
65 PROCEDURE ENUMERATE_INBOUND_NODES
66 (P_RESOURCE_ID IN NUMBER
67 ,P_LANGUAGE IN VARCHAR2
68 ,P_SOURCE_LANG IN VARCHAR2
69 ,P_SEL_ENUM_ID IN NUMBER );
70
71
72 PROCEDURE ENUMERATE_EMAIL_NODES
73 (P_RESOURCE_ID IN NUMBER
74 ,P_LANGUAGE IN VARCHAR2
75 ,P_SOURCE_LANG IN VARCHAR2
76 ,P_SEL_ENUM_ID IN NUMBER );
77
78
79 PROCEDURE ENUMERATE_WEB_CALLBACK_NODES
80 (P_RESOURCE_ID IN NUMBER
81 ,P_LANGUAGE IN VARCHAR2
82 ,P_SOURCE_LANG IN VARCHAR2
83 ,P_SEL_ENUM_ID IN NUMBER );
84
85
86 END IEU_DEFAULT_MEDIA_ENUMS_PVT;