DBA Data[Home] [Help]

APPS.IEU_PUB dependencies on IEU_PUB

Line 1: PACKAGE BODY IEU_PUB AS

1: PACKAGE BODY IEU_PUB AS
2: /* $Header: IEU_PB.pls 120.0 2005/06/02 15:49:55 appldev noship $ */
3:
4: l_not_valid_flag VARCHAR2(1);
5: l_not_valid VARCHAR2(1);

Line 91: P_ENUMERATOR_DATAREC_LIST IN IEU_PUB.EnumeratorDataRecordList

87:
88: PROCEDURE ADD_UWQ_NODE_DATA
89: (P_RESOURCE_ID IN NUMBER,
90: P_SEL_ENUM_ID IN NUMBER,
91: P_ENUMERATOR_DATAREC_LIST IN IEU_PUB.EnumeratorDataRecordList
92: ) AS
93:
94: BEGIN
95:

Line 106: X_NODE_DETAIL_RECORD OUT NOCOPY IEU_PUB.NodeDetailRecord) IS

102:
103: PROCEDURE GET_UWQ_NODE_DETAILS
104: (P_RESOURCE_ID IN NUMBER,
105: P_NODE_ID IN NUMBER,
106: X_NODE_DETAIL_RECORD OUT NOCOPY IEU_PUB.NodeDetailRecord) IS
107:
108: l_where_clause varchar2(4000);
109: l_node_type IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE;
110: l_res_cat_enum_flag IEU_UWQ_SEL_RT_NODES.RES_CAT_ENUM_FLAG%TYPE;

Line 179: l_res_cat_where_clause := ieu_pub.get_enum_res_cat(l_sel_enum_id);

175: when no_data_found then
176: null;
177: end;
178: else
179: l_res_cat_where_clause := ieu_pub.get_enum_res_cat(l_sel_enum_id);
180: end if;
181:
182: -- Set the complete Where Clause
183:

Line 257: X_NODE_DETAIL_RECORD OUT NOCOPY IEU_PUB.NodeDetailRecord,

253:
254: PROCEDURE GET_UWQ_NODE_DETAILS
255: (P_RESOURCE_ID IN NUMBER,
256: P_NODE_ID IN NUMBER,
257: X_NODE_DETAIL_RECORD OUT NOCOPY IEU_PUB.NodeDetailRecord,
258: X_BIND_VARIABLE_RECORD_LIST OUT NOCOPY IEU_PUB.BindVariableRecordList) IS
259:
260: l_where_clause varchar2(4000);
261: l_node_type IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE;

Line 258: X_BIND_VARIABLE_RECORD_LIST OUT NOCOPY IEU_PUB.BindVariableRecordList) IS

254: PROCEDURE GET_UWQ_NODE_DETAILS
255: (P_RESOURCE_ID IN NUMBER,
256: P_NODE_ID IN NUMBER,
257: X_NODE_DETAIL_RECORD OUT NOCOPY IEU_PUB.NodeDetailRecord,
258: X_BIND_VARIABLE_RECORD_LIST OUT NOCOPY IEU_PUB.BindVariableRecordList) IS
259:
260: l_where_clause varchar2(4000);
261: l_node_type IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE;
262: l_res_cat_enum_flag IEU_UWQ_SEL_RT_NODES.RES_CAT_ENUM_FLAG%TYPE;

Line 334: l_res_cat_where_clause := ieu_pub.get_enum_res_cat(l_sel_enum_id);

330: when no_data_found then
331: null;
332: end;
333: else
334: l_res_cat_where_clause := ieu_pub.get_enum_res_cat(l_sel_enum_id);
335: end if;
336:
337: -- Set the complete Where Clause
338:

Line 414: END IEU_PUB;

410: X_NODE_DETAIL_RECORD.COMPLETE_WHERE_CLAUSE := l_where_clause;
411: X_NODE_DETAIL_RECORD.NODE_RUNTIME_WHERE_CLAUSE := l_extra_where_clause;
412:
413: END;
414: END IEU_PUB;