APPS.IEU_PVT dependencies on IEU_PVT

Line 1: PACKAGE BODY IEU_PVT AS

1: PACKAGE BODY IEU_PVT AS
2: /* $Header: IEU_VB.pls 120.4.12010000.4 2008/10/24 09:57:47 majha ship $ */
3:
4: IEU_UWQ_SEL_RT_NODES_LIST IEU_UWQ_SEL_RT_NODES_TAB;
5: IEU_UWQ_RTNODE_BIND_VALS_LIST IEU_UWQ_RTNODE_BIND_VALS_TAB;

Line 728: l_wb_style := ieu_pvt.determine_wb_style( p_resource_id );

724: -- case we want to have some procedures that are capable of doing multiple
725: -- media types. The procedure can simply check the UUID if needed.
726: --
727:
728: l_wb_style := ieu_pvt.determine_wb_style( p_resource_id );
729:
730: FOR cur_rec IN c_enum LOOP
731:
732: BEGIN

Line 763: IF (IEU_PVT.IS_MEDIA_TYPE_ELIGIBLE

759:
760: IF ((cur_rec.work_q_register_type = 'M') and (cur_rec.media_type_id is not NULL))
761: THEN
762:
763: IF (IEU_PVT.IS_MEDIA_TYPE_ELIGIBLE
764: (P_RESOURCE_ID ,cur_rec.media_type_id) = FALSE)
765: THEN
766: l_media_eligible := 'FALSE';
767: ELSE

Line 996: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN

992:
993: BEGIN
994:
995: j := 0;
996: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN
997: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.DELETE;
998: IEU_PVT.REF_COUNT_LIST.DELETE;
999: END IF;
1000:

Line 997: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.DELETE;

993: BEGIN
994:
995: j := 0;
996: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN
997: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.DELETE;
998: IEU_PVT.REF_COUNT_LIST.DELETE;
999: END IF;
1000:
1001: For b in c_bindVal

Line 998: IEU_PVT.REF_COUNT_LIST.DELETE;

994:
995: j := 0;
996: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN
997: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.DELETE;
998: IEU_PVT.REF_COUNT_LIST.DELETE;
999: END IF;
1000:
1001: For b in c_bindVal
1002: loop

Line 1052: IEU_PVT.SEL_RT_NODE_ID_REF_LIST(j) := node.sel_rt_node_id;

1048: refresh_node(node.node_id, node.node_pid, node.sel_enum_id, node.where_clause,
1049: node.res_cat_enum_flag, node.refresh_view_name, node.refresh_view_sum_col,
1050: node.sel_rt_node_id, l_count, p_resource_id, node.view_name,l_bindvallist, l_bulk_count );
1051:
1052: IEU_PVT.SEL_RT_NODE_ID_REF_LIST(j) := node.sel_rt_node_id;
1053: IEU_PVT.REF_COUNT_LIST(j) := l_bulk_count;
1054: j := j + 1;
1055: end if;
1056:

Line 1053: IEU_PVT.REF_COUNT_LIST(j) := l_bulk_count;

1049: node.res_cat_enum_flag, node.refresh_view_name, node.refresh_view_sum_col,
1050: node.sel_rt_node_id, l_count, p_resource_id, node.view_name,l_bindvallist, l_bulk_count );
1051:
1052: IEU_PVT.SEL_RT_NODE_ID_REF_LIST(j) := node.sel_rt_node_id;
1053: IEU_PVT.REF_COUNT_LIST(j) := l_bulk_count;
1054: j := j + 1;
1055: end if;
1056:
1057: END LOOP;

Line 1060: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN

1056:
1057: END LOOP;
1058:
1059: BEGIN
1060: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN
1061: FORALL x IN IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST..IEU_PVT.SEL_RT_NODE_ID_REF_LIST.LAST SAVE EXCEPTIONS
1062: UPDATE IEU_UWQ_SEL_RT_NODES
1063: SET COUNT = IEU_PVT.REF_COUNT_LIST(x)
1064: WHERE SEL_RT_NODE_ID = IEU_PVT.SEL_RT_NODE_ID_REF_LIST(x)

Line 1061: FORALL x IN IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST..IEU_PVT.SEL_RT_NODE_ID_REF_LIST.LAST SAVE EXCEPTIONS

1057: END LOOP;
1058:
1059: BEGIN
1060: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN
1061: FORALL x IN IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST..IEU_PVT.SEL_RT_NODE_ID_REF_LIST.LAST SAVE EXCEPTIONS
1062: UPDATE IEU_UWQ_SEL_RT_NODES
1063: SET COUNT = IEU_PVT.REF_COUNT_LIST(x)
1064: WHERE SEL_RT_NODE_ID = IEU_PVT.SEL_RT_NODE_ID_REF_LIST(x)
1065: AND RESOURCE_ID = P_RESOURCE_ID;

Line 1063: SET COUNT = IEU_PVT.REF_COUNT_LIST(x)

1059: BEGIN
1060: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN
1061: FORALL x IN IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST..IEU_PVT.SEL_RT_NODE_ID_REF_LIST.LAST SAVE EXCEPTIONS
1062: UPDATE IEU_UWQ_SEL_RT_NODES
1063: SET COUNT = IEU_PVT.REF_COUNT_LIST(x)
1064: WHERE SEL_RT_NODE_ID = IEU_PVT.SEL_RT_NODE_ID_REF_LIST(x)
1065: AND RESOURCE_ID = P_RESOURCE_ID;
1066: COMMIT;
1067:

Line 1064: WHERE SEL_RT_NODE_ID = IEU_PVT.SEL_RT_NODE_ID_REF_LIST(x)

1060: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN
1061: FORALL x IN IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST..IEU_PVT.SEL_RT_NODE_ID_REF_LIST.LAST SAVE EXCEPTIONS
1062: UPDATE IEU_UWQ_SEL_RT_NODES
1063: SET COUNT = IEU_PVT.REF_COUNT_LIST(x)
1064: WHERE SEL_RT_NODE_ID = IEU_PVT.SEL_RT_NODE_ID_REF_LIST(x)
1065: AND RESOURCE_ID = P_RESOURCE_ID;
1066: COMMIT;
1067:
1068: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.delete;

Line 1068: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.delete;

1064: WHERE SEL_RT_NODE_ID = IEU_PVT.SEL_RT_NODE_ID_REF_LIST(x)
1065: AND RESOURCE_ID = P_RESOURCE_ID;
1066: COMMIT;
1067:
1068: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.delete;
1069: IEU_PVT.REF_COUNT_LIST.delete;
1070: END IF;
1071:
1072: EXCEPTION

Line 1069: IEU_PVT.REF_COUNT_LIST.delete;

1065: AND RESOURCE_ID = P_RESOURCE_ID;
1066: COMMIT;
1067:
1068: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.delete;
1069: IEU_PVT.REF_COUNT_LIST.delete;
1070: END IF;
1071:
1072: EXCEPTION
1073: WHEN OTHERS THEN

Line 1074: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.delete;

1070: END IF;
1071:
1072: EXCEPTION
1073: WHEN OTHERS THEN
1074: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.delete;
1075: IEU_PVT.REF_COUNT_LIST.delete;
1076: END;
1077:
1078: end;

Line 1075: IEU_PVT.REF_COUNT_LIST.delete;

1071:
1072: EXCEPTION
1073: WHEN OTHERS THEN
1074: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.delete;
1075: IEU_PVT.REF_COUNT_LIST.delete;
1076: END;
1077:
1078: end;
1079:

Line 2371: IEU_PVT.L_IND_LIST_ITR := 0;

2367: else
2368: l_prnt_node_id := 0;
2369: end if;
2370:
2371: IEU_PVT.L_IND_LIST_ITR := 0;
2372: IEU_PVT.L_RT_NODES_ITR := 0;
2373: IEU_PVT.L_BIND_VALS_ITR := 0;
2374:
2375: -- Call the recursive procedure to insert or update the nodes

Line 2372: IEU_PVT.L_RT_NODES_ITR := 0;

2368: l_prnt_node_id := 0;
2369: end if;
2370:
2371: IEU_PVT.L_IND_LIST_ITR := 0;
2372: IEU_PVT.L_RT_NODES_ITR := 0;
2373: IEU_PVT.L_BIND_VALS_ITR := 0;
2374:
2375: -- Call the recursive procedure to insert or update the nodes
2376: IEU_PVT.WALK_TREE_ADD (

Line 2373: IEU_PVT.L_BIND_VALS_ITR := 0;

2369: end if;
2370:
2371: IEU_PVT.L_IND_LIST_ITR := 0;
2372: IEU_PVT.L_RT_NODES_ITR := 0;
2373: IEU_PVT.L_BIND_VALS_ITR := 0;
2374:
2375: -- Call the recursive procedure to insert or update the nodes
2376: IEU_PVT.WALK_TREE_ADD (
2377: P_ENUMERATOR_DATAREC_LIST,

Line 2376: IEU_PVT.WALK_TREE_ADD (

2372: IEU_PVT.L_RT_NODES_ITR := 0;
2373: IEU_PVT.L_BIND_VALS_ITR := 0;
2374:
2375: -- Call the recursive procedure to insert or update the nodes
2376: IEU_PVT.WALK_TREE_ADD (
2377: P_ENUMERATOR_DATAREC_LIST,
2378: l_prnt_node_id,
2379: l_curr_node_id,
2380: 0,

Line 2388: IF IEU_PVT.NODE_ID_LIST.FIRST IS NOT NULL THEN

2384: x_new_node_id
2385: );
2386:
2387: BEGIN
2388: IF IEU_PVT.NODE_ID_LIST.FIRST IS NOT NULL THEN
2389: FORALL i IN IEU_PVT.NODE_ID_LIST.FIRST..IEU_PVT.NODE_ID_LIST.LAST SAVE EXCEPTIONS
2390: UPDATE IEU_UWQ_SEL_RT_NODES SET
2391: SEL_ENUM_ID = IEU_PVT.SEL_ENUM_ID_LIST(i),
2392: NODE_TYPE = IEU_PVT.NODE_TYPE_LIST(i),

Line 2389: FORALL i IN IEU_PVT.NODE_ID_LIST.FIRST..IEU_PVT.NODE_ID_LIST.LAST SAVE EXCEPTIONS

2385: );
2386:
2387: BEGIN
2388: IF IEU_PVT.NODE_ID_LIST.FIRST IS NOT NULL THEN
2389: FORALL i IN IEU_PVT.NODE_ID_LIST.FIRST..IEU_PVT.NODE_ID_LIST.LAST SAVE EXCEPTIONS
2390: UPDATE IEU_UWQ_SEL_RT_NODES SET
2391: SEL_ENUM_ID = IEU_PVT.SEL_ENUM_ID_LIST(i),
2392: NODE_TYPE = IEU_PVT.NODE_TYPE_LIST(i),
2393: NODE_PID = IEU_PVT.NODE_PID_LIST(i),

Line 2391: SEL_ENUM_ID = IEU_PVT.SEL_ENUM_ID_LIST(i),

2387: BEGIN
2388: IF IEU_PVT.NODE_ID_LIST.FIRST IS NOT NULL THEN
2389: FORALL i IN IEU_PVT.NODE_ID_LIST.FIRST..IEU_PVT.NODE_ID_LIST.LAST SAVE EXCEPTIONS
2390: UPDATE IEU_UWQ_SEL_RT_NODES SET
2391: SEL_ENUM_ID = IEU_PVT.SEL_ENUM_ID_LIST(i),
2392: NODE_TYPE = IEU_PVT.NODE_TYPE_LIST(i),
2393: NODE_PID = IEU_PVT.NODE_PID_LIST(i),
2394: NODE_WEIGHT = IEU_PVT.NODE_WEIGHT_LIST(i),
2395: NODE_DEPTH = IEU_PVT.NODE_DEPTH_LIST(i),

Line 2392: NODE_TYPE = IEU_PVT.NODE_TYPE_LIST(i),

2388: IF IEU_PVT.NODE_ID_LIST.FIRST IS NOT NULL THEN
2389: FORALL i IN IEU_PVT.NODE_ID_LIST.FIRST..IEU_PVT.NODE_ID_LIST.LAST SAVE EXCEPTIONS
2390: UPDATE IEU_UWQ_SEL_RT_NODES SET
2391: SEL_ENUM_ID = IEU_PVT.SEL_ENUM_ID_LIST(i),
2392: NODE_TYPE = IEU_PVT.NODE_TYPE_LIST(i),
2393: NODE_PID = IEU_PVT.NODE_PID_LIST(i),
2394: NODE_WEIGHT = IEU_PVT.NODE_WEIGHT_LIST(i),
2395: NODE_DEPTH = IEU_PVT.NODE_DEPTH_LIST(i),
2396: SEL_ENUM_PID = IEU_PVT.SEL_ENUM_PID_LIST(i),

Line 2393: NODE_PID = IEU_PVT.NODE_PID_LIST(i),

2389: FORALL i IN IEU_PVT.NODE_ID_LIST.FIRST..IEU_PVT.NODE_ID_LIST.LAST SAVE EXCEPTIONS
2390: UPDATE IEU_UWQ_SEL_RT_NODES SET
2391: SEL_ENUM_ID = IEU_PVT.SEL_ENUM_ID_LIST(i),
2392: NODE_TYPE = IEU_PVT.NODE_TYPE_LIST(i),
2393: NODE_PID = IEU_PVT.NODE_PID_LIST(i),
2394: NODE_WEIGHT = IEU_PVT.NODE_WEIGHT_LIST(i),
2395: NODE_DEPTH = IEU_PVT.NODE_DEPTH_LIST(i),
2396: SEL_ENUM_PID = IEU_PVT.SEL_ENUM_PID_LIST(i),
2397: MEDIA_TYPE_ID = IEU_PVT.MEDIA_TYPE_ID_LIST(i),

Line 2394: NODE_WEIGHT = IEU_PVT.NODE_WEIGHT_LIST(i),

2390: UPDATE IEU_UWQ_SEL_RT_NODES SET
2391: SEL_ENUM_ID = IEU_PVT.SEL_ENUM_ID_LIST(i),
2392: NODE_TYPE = IEU_PVT.NODE_TYPE_LIST(i),
2393: NODE_PID = IEU_PVT.NODE_PID_LIST(i),
2394: NODE_WEIGHT = IEU_PVT.NODE_WEIGHT_LIST(i),
2395: NODE_DEPTH = IEU_PVT.NODE_DEPTH_LIST(i),
2396: SEL_ENUM_PID = IEU_PVT.SEL_ENUM_PID_LIST(i),
2397: MEDIA_TYPE_ID = IEU_PVT.MEDIA_TYPE_ID_LIST(i),
2398: COUNT = IEU_PVT.COUNT_LIST(i),

Line 2395: NODE_DEPTH = IEU_PVT.NODE_DEPTH_LIST(i),

2391: SEL_ENUM_ID = IEU_PVT.SEL_ENUM_ID_LIST(i),
2392: NODE_TYPE = IEU_PVT.NODE_TYPE_LIST(i),
2393: NODE_PID = IEU_PVT.NODE_PID_LIST(i),
2394: NODE_WEIGHT = IEU_PVT.NODE_WEIGHT_LIST(i),
2395: NODE_DEPTH = IEU_PVT.NODE_DEPTH_LIST(i),
2396: SEL_ENUM_PID = IEU_PVT.SEL_ENUM_PID_LIST(i),
2397: MEDIA_TYPE_ID = IEU_PVT.MEDIA_TYPE_ID_LIST(i),
2398: COUNT = IEU_PVT.COUNT_LIST(i),
2399: DATA_SOURCE = IEU_PVT.DATA_SOURCE_LIST(i),

Line 2396: SEL_ENUM_PID = IEU_PVT.SEL_ENUM_PID_LIST(i),

2392: NODE_TYPE = IEU_PVT.NODE_TYPE_LIST(i),
2393: NODE_PID = IEU_PVT.NODE_PID_LIST(i),
2394: NODE_WEIGHT = IEU_PVT.NODE_WEIGHT_LIST(i),
2395: NODE_DEPTH = IEU_PVT.NODE_DEPTH_LIST(i),
2396: SEL_ENUM_PID = IEU_PVT.SEL_ENUM_PID_LIST(i),
2397: MEDIA_TYPE_ID = IEU_PVT.MEDIA_TYPE_ID_LIST(i),
2398: COUNT = IEU_PVT.COUNT_LIST(i),
2399: DATA_SOURCE = IEU_PVT.DATA_SOURCE_LIST(i),
2400: VIEW_NAME = IEU_PVT.VIEW_NAME_LIST(i),

Line 2397: MEDIA_TYPE_ID = IEU_PVT.MEDIA_TYPE_ID_LIST(i),

2393: NODE_PID = IEU_PVT.NODE_PID_LIST(i),
2394: NODE_WEIGHT = IEU_PVT.NODE_WEIGHT_LIST(i),
2395: NODE_DEPTH = IEU_PVT.NODE_DEPTH_LIST(i),
2396: SEL_ENUM_PID = IEU_PVT.SEL_ENUM_PID_LIST(i),
2397: MEDIA_TYPE_ID = IEU_PVT.MEDIA_TYPE_ID_LIST(i),
2398: COUNT = IEU_PVT.COUNT_LIST(i),
2399: DATA_SOURCE = IEU_PVT.DATA_SOURCE_LIST(i),
2400: VIEW_NAME = IEU_PVT.VIEW_NAME_LIST(i),
2401: WHERE_CLAUSE = IEU_PVT.WHERE_CLAUSE_LIST(i),

Line 2398: COUNT = IEU_PVT.COUNT_LIST(i),

2394: NODE_WEIGHT = IEU_PVT.NODE_WEIGHT_LIST(i),
2395: NODE_DEPTH = IEU_PVT.NODE_DEPTH_LIST(i),
2396: SEL_ENUM_PID = IEU_PVT.SEL_ENUM_PID_LIST(i),
2397: MEDIA_TYPE_ID = IEU_PVT.MEDIA_TYPE_ID_LIST(i),
2398: COUNT = IEU_PVT.COUNT_LIST(i),
2399: DATA_SOURCE = IEU_PVT.DATA_SOURCE_LIST(i),
2400: VIEW_NAME = IEU_PVT.VIEW_NAME_LIST(i),
2401: WHERE_CLAUSE = IEU_PVT.WHERE_CLAUSE_LIST(i),
2402: HIDE_IF_EMPTY = IEU_PVT.HIDE_IF_EMPTY_LIST(i),

Line 2399: DATA_SOURCE = IEU_PVT.DATA_SOURCE_LIST(i),

2395: NODE_DEPTH = IEU_PVT.NODE_DEPTH_LIST(i),
2396: SEL_ENUM_PID = IEU_PVT.SEL_ENUM_PID_LIST(i),
2397: MEDIA_TYPE_ID = IEU_PVT.MEDIA_TYPE_ID_LIST(i),
2398: COUNT = IEU_PVT.COUNT_LIST(i),
2399: DATA_SOURCE = IEU_PVT.DATA_SOURCE_LIST(i),
2400: VIEW_NAME = IEU_PVT.VIEW_NAME_LIST(i),
2401: WHERE_CLAUSE = IEU_PVT.WHERE_CLAUSE_LIST(i),
2402: HIDE_IF_EMPTY = IEU_PVT.HIDE_IF_EMPTY_LIST(i),
2403: REFRESH_VIEW_NAME = IEU_PVT.REFRESH_VIEW_NAME_LIST(i),

Line 2400: VIEW_NAME = IEU_PVT.VIEW_NAME_LIST(i),

2396: SEL_ENUM_PID = IEU_PVT.SEL_ENUM_PID_LIST(i),
2397: MEDIA_TYPE_ID = IEU_PVT.MEDIA_TYPE_ID_LIST(i),
2398: COUNT = IEU_PVT.COUNT_LIST(i),
2399: DATA_SOURCE = IEU_PVT.DATA_SOURCE_LIST(i),
2400: VIEW_NAME = IEU_PVT.VIEW_NAME_LIST(i),
2401: WHERE_CLAUSE = IEU_PVT.WHERE_CLAUSE_LIST(i),
2402: HIDE_IF_EMPTY = IEU_PVT.HIDE_IF_EMPTY_LIST(i),
2403: REFRESH_VIEW_NAME = IEU_PVT.REFRESH_VIEW_NAME_LIST(i),
2404: REFRESH_VIEW_SUM_COL = IEU_PVT.REFRESH_VIEW_SUM_COL_LIST(i),

Line 2401: WHERE_CLAUSE = IEU_PVT.WHERE_CLAUSE_LIST(i),

2397: MEDIA_TYPE_ID = IEU_PVT.MEDIA_TYPE_ID_LIST(i),
2398: COUNT = IEU_PVT.COUNT_LIST(i),
2399: DATA_SOURCE = IEU_PVT.DATA_SOURCE_LIST(i),
2400: VIEW_NAME = IEU_PVT.VIEW_NAME_LIST(i),
2401: WHERE_CLAUSE = IEU_PVT.WHERE_CLAUSE_LIST(i),
2402: HIDE_IF_EMPTY = IEU_PVT.HIDE_IF_EMPTY_LIST(i),
2403: REFRESH_VIEW_NAME = IEU_PVT.REFRESH_VIEW_NAME_LIST(i),
2404: REFRESH_VIEW_SUM_COL = IEU_PVT.REFRESH_VIEW_SUM_COL_LIST(i),
2405: RES_CAT_ENUM_FLAG = IEU_PVT.RES_CAT_ENUM_FLAG_LIST(i),

Line 2402: HIDE_IF_EMPTY = IEU_PVT.HIDE_IF_EMPTY_LIST(i),

2398: COUNT = IEU_PVT.COUNT_LIST(i),
2399: DATA_SOURCE = IEU_PVT.DATA_SOURCE_LIST(i),
2400: VIEW_NAME = IEU_PVT.VIEW_NAME_LIST(i),
2401: WHERE_CLAUSE = IEU_PVT.WHERE_CLAUSE_LIST(i),
2402: HIDE_IF_EMPTY = IEU_PVT.HIDE_IF_EMPTY_LIST(i),
2403: REFRESH_VIEW_NAME = IEU_PVT.REFRESH_VIEW_NAME_LIST(i),
2404: REFRESH_VIEW_SUM_COL = IEU_PVT.REFRESH_VIEW_SUM_COL_LIST(i),
2405: RES_CAT_ENUM_FLAG = IEU_PVT.RES_CAT_ENUM_FLAG_LIST(i),
2406: NOT_VALID = IEU_PVT.NOT_VALID_LIST(i),

Line 2403: REFRESH_VIEW_NAME = IEU_PVT.REFRESH_VIEW_NAME_LIST(i),

2399: DATA_SOURCE = IEU_PVT.DATA_SOURCE_LIST(i),
2400: VIEW_NAME = IEU_PVT.VIEW_NAME_LIST(i),
2401: WHERE_CLAUSE = IEU_PVT.WHERE_CLAUSE_LIST(i),
2402: HIDE_IF_EMPTY = IEU_PVT.HIDE_IF_EMPTY_LIST(i),
2403: REFRESH_VIEW_NAME = IEU_PVT.REFRESH_VIEW_NAME_LIST(i),
2404: REFRESH_VIEW_SUM_COL = IEU_PVT.REFRESH_VIEW_SUM_COL_LIST(i),
2405: RES_CAT_ENUM_FLAG = IEU_PVT.RES_CAT_ENUM_FLAG_LIST(i),
2406: NOT_VALID = IEU_PVT.NOT_VALID_LIST(i),
2407: NODE_LABEL = IEU_PVT.NODE_LABEL_LIST(i),

Line 2404: REFRESH_VIEW_SUM_COL = IEU_PVT.REFRESH_VIEW_SUM_COL_LIST(i),

2400: VIEW_NAME = IEU_PVT.VIEW_NAME_LIST(i),
2401: WHERE_CLAUSE = IEU_PVT.WHERE_CLAUSE_LIST(i),
2402: HIDE_IF_EMPTY = IEU_PVT.HIDE_IF_EMPTY_LIST(i),
2403: REFRESH_VIEW_NAME = IEU_PVT.REFRESH_VIEW_NAME_LIST(i),
2404: REFRESH_VIEW_SUM_COL = IEU_PVT.REFRESH_VIEW_SUM_COL_LIST(i),
2405: RES_CAT_ENUM_FLAG = IEU_PVT.RES_CAT_ENUM_FLAG_LIST(i),
2406: NOT_VALID = IEU_PVT.NOT_VALID_LIST(i),
2407: NODE_LABEL = IEU_PVT.NODE_LABEL_LIST(i),
2408: LAST_UPDATE_DATE = IEU_PVT.LAST_UPDATE_DATE_LIST(i),

Line 2405: RES_CAT_ENUM_FLAG = IEU_PVT.RES_CAT_ENUM_FLAG_LIST(i),

2401: WHERE_CLAUSE = IEU_PVT.WHERE_CLAUSE_LIST(i),
2402: HIDE_IF_EMPTY = IEU_PVT.HIDE_IF_EMPTY_LIST(i),
2403: REFRESH_VIEW_NAME = IEU_PVT.REFRESH_VIEW_NAME_LIST(i),
2404: REFRESH_VIEW_SUM_COL = IEU_PVT.REFRESH_VIEW_SUM_COL_LIST(i),
2405: RES_CAT_ENUM_FLAG = IEU_PVT.RES_CAT_ENUM_FLAG_LIST(i),
2406: NOT_VALID = IEU_PVT.NOT_VALID_LIST(i),
2407: NODE_LABEL = IEU_PVT.NODE_LABEL_LIST(i),
2408: LAST_UPDATE_DATE = IEU_PVT.LAST_UPDATE_DATE_LIST(i),
2409: LAST_UPDATED_BY = IEU_PVT.LAST_UPDATED_BY_LIST(i),

Line 2406: NOT_VALID = IEU_PVT.NOT_VALID_LIST(i),

2402: HIDE_IF_EMPTY = IEU_PVT.HIDE_IF_EMPTY_LIST(i),
2403: REFRESH_VIEW_NAME = IEU_PVT.REFRESH_VIEW_NAME_LIST(i),
2404: REFRESH_VIEW_SUM_COL = IEU_PVT.REFRESH_VIEW_SUM_COL_LIST(i),
2405: RES_CAT_ENUM_FLAG = IEU_PVT.RES_CAT_ENUM_FLAG_LIST(i),
2406: NOT_VALID = IEU_PVT.NOT_VALID_LIST(i),
2407: NODE_LABEL = IEU_PVT.NODE_LABEL_LIST(i),
2408: LAST_UPDATE_DATE = IEU_PVT.LAST_UPDATE_DATE_LIST(i),
2409: LAST_UPDATED_BY = IEU_PVT.LAST_UPDATED_BY_LIST(i),
2410: LAST_UPDATE_LOGIN = IEU_PVT.LAST_UPDATE_LOGIN_LIST(i)

Line 2407: NODE_LABEL = IEU_PVT.NODE_LABEL_LIST(i),

2403: REFRESH_VIEW_NAME = IEU_PVT.REFRESH_VIEW_NAME_LIST(i),
2404: REFRESH_VIEW_SUM_COL = IEU_PVT.REFRESH_VIEW_SUM_COL_LIST(i),
2405: RES_CAT_ENUM_FLAG = IEU_PVT.RES_CAT_ENUM_FLAG_LIST(i),
2406: NOT_VALID = IEU_PVT.NOT_VALID_LIST(i),
2407: NODE_LABEL = IEU_PVT.NODE_LABEL_LIST(i),
2408: LAST_UPDATE_DATE = IEU_PVT.LAST_UPDATE_DATE_LIST(i),
2409: LAST_UPDATED_BY = IEU_PVT.LAST_UPDATED_BY_LIST(i),
2410: LAST_UPDATE_LOGIN = IEU_PVT.LAST_UPDATE_LOGIN_LIST(i)
2411: WHERE RESOURCE_ID = IEU_PVT.RESOURCE_ID_LIST(i)

Line 2408: LAST_UPDATE_DATE = IEU_PVT.LAST_UPDATE_DATE_LIST(i),

2404: REFRESH_VIEW_SUM_COL = IEU_PVT.REFRESH_VIEW_SUM_COL_LIST(i),
2405: RES_CAT_ENUM_FLAG = IEU_PVT.RES_CAT_ENUM_FLAG_LIST(i),
2406: NOT_VALID = IEU_PVT.NOT_VALID_LIST(i),
2407: NODE_LABEL = IEU_PVT.NODE_LABEL_LIST(i),
2408: LAST_UPDATE_DATE = IEU_PVT.LAST_UPDATE_DATE_LIST(i),
2409: LAST_UPDATED_BY = IEU_PVT.LAST_UPDATED_BY_LIST(i),
2410: LAST_UPDATE_LOGIN = IEU_PVT.LAST_UPDATE_LOGIN_LIST(i)
2411: WHERE RESOURCE_ID = IEU_PVT.RESOURCE_ID_LIST(i)
2412: AND NODE_ID = IEU_PVT.NODE_ID_LIST(i);

Line 2409: LAST_UPDATED_BY = IEU_PVT.LAST_UPDATED_BY_LIST(i),

2405: RES_CAT_ENUM_FLAG = IEU_PVT.RES_CAT_ENUM_FLAG_LIST(i),
2406: NOT_VALID = IEU_PVT.NOT_VALID_LIST(i),
2407: NODE_LABEL = IEU_PVT.NODE_LABEL_LIST(i),
2408: LAST_UPDATE_DATE = IEU_PVT.LAST_UPDATE_DATE_LIST(i),
2409: LAST_UPDATED_BY = IEU_PVT.LAST_UPDATED_BY_LIST(i),
2410: LAST_UPDATE_LOGIN = IEU_PVT.LAST_UPDATE_LOGIN_LIST(i)
2411: WHERE RESOURCE_ID = IEU_PVT.RESOURCE_ID_LIST(i)
2412: AND NODE_ID = IEU_PVT.NODE_ID_LIST(i);
2413:

Line 2410: LAST_UPDATE_LOGIN = IEU_PVT.LAST_UPDATE_LOGIN_LIST(i)

2406: NOT_VALID = IEU_PVT.NOT_VALID_LIST(i),
2407: NODE_LABEL = IEU_PVT.NODE_LABEL_LIST(i),
2408: LAST_UPDATE_DATE = IEU_PVT.LAST_UPDATE_DATE_LIST(i),
2409: LAST_UPDATED_BY = IEU_PVT.LAST_UPDATED_BY_LIST(i),
2410: LAST_UPDATE_LOGIN = IEU_PVT.LAST_UPDATE_LOGIN_LIST(i)
2411: WHERE RESOURCE_ID = IEU_PVT.RESOURCE_ID_LIST(i)
2412: AND NODE_ID = IEU_PVT.NODE_ID_LIST(i);
2413:
2414: IEU_PVT.LAST_UPDATED_BY_LIST.delete;

Line 2411: WHERE RESOURCE_ID = IEU_PVT.RESOURCE_ID_LIST(i)

2407: NODE_LABEL = IEU_PVT.NODE_LABEL_LIST(i),
2408: LAST_UPDATE_DATE = IEU_PVT.LAST_UPDATE_DATE_LIST(i),
2409: LAST_UPDATED_BY = IEU_PVT.LAST_UPDATED_BY_LIST(i),
2410: LAST_UPDATE_LOGIN = IEU_PVT.LAST_UPDATE_LOGIN_LIST(i)
2411: WHERE RESOURCE_ID = IEU_PVT.RESOURCE_ID_LIST(i)
2412: AND NODE_ID = IEU_PVT.NODE_ID_LIST(i);
2413:
2414: IEU_PVT.LAST_UPDATED_BY_LIST.delete;
2415: IEU_PVT.LAST_UPDATE_DATE_LIST.delete;

Line 2412: AND NODE_ID = IEU_PVT.NODE_ID_LIST(i);

2408: LAST_UPDATE_DATE = IEU_PVT.LAST_UPDATE_DATE_LIST(i),
2409: LAST_UPDATED_BY = IEU_PVT.LAST_UPDATED_BY_LIST(i),
2410: LAST_UPDATE_LOGIN = IEU_PVT.LAST_UPDATE_LOGIN_LIST(i)
2411: WHERE RESOURCE_ID = IEU_PVT.RESOURCE_ID_LIST(i)
2412: AND NODE_ID = IEU_PVT.NODE_ID_LIST(i);
2413:
2414: IEU_PVT.LAST_UPDATED_BY_LIST.delete;
2415: IEU_PVT.LAST_UPDATE_DATE_LIST.delete;
2416: IEU_PVT.LAST_UPDATE_LOGIN_LIST.delete;

Line 2414: IEU_PVT.LAST_UPDATED_BY_LIST.delete;

2410: LAST_UPDATE_LOGIN = IEU_PVT.LAST_UPDATE_LOGIN_LIST(i)
2411: WHERE RESOURCE_ID = IEU_PVT.RESOURCE_ID_LIST(i)
2412: AND NODE_ID = IEU_PVT.NODE_ID_LIST(i);
2413:
2414: IEU_PVT.LAST_UPDATED_BY_LIST.delete;
2415: IEU_PVT.LAST_UPDATE_DATE_LIST.delete;
2416: IEU_PVT.LAST_UPDATE_LOGIN_LIST.delete;
2417: IEU_PVT.RESOURCE_ID_LIST.delete;
2418: IEU_PVT.SEL_ENUM_ID_LIST.delete;

Line 2415: IEU_PVT.LAST_UPDATE_DATE_LIST.delete;

2411: WHERE RESOURCE_ID = IEU_PVT.RESOURCE_ID_LIST(i)
2412: AND NODE_ID = IEU_PVT.NODE_ID_LIST(i);
2413:
2414: IEU_PVT.LAST_UPDATED_BY_LIST.delete;
2415: IEU_PVT.LAST_UPDATE_DATE_LIST.delete;
2416: IEU_PVT.LAST_UPDATE_LOGIN_LIST.delete;
2417: IEU_PVT.RESOURCE_ID_LIST.delete;
2418: IEU_PVT.SEL_ENUM_ID_LIST.delete;
2419: IEU_PVT.NODE_ID_LIST.delete;

Line 2416: IEU_PVT.LAST_UPDATE_LOGIN_LIST.delete;

2412: AND NODE_ID = IEU_PVT.NODE_ID_LIST(i);
2413:
2414: IEU_PVT.LAST_UPDATED_BY_LIST.delete;
2415: IEU_PVT.LAST_UPDATE_DATE_LIST.delete;
2416: IEU_PVT.LAST_UPDATE_LOGIN_LIST.delete;
2417: IEU_PVT.RESOURCE_ID_LIST.delete;
2418: IEU_PVT.SEL_ENUM_ID_LIST.delete;
2419: IEU_PVT.NODE_ID_LIST.delete;
2420: IEU_PVT.NODE_TYPE_LIST.delete;

Line 2417: IEU_PVT.RESOURCE_ID_LIST.delete;

2413:
2414: IEU_PVT.LAST_UPDATED_BY_LIST.delete;
2415: IEU_PVT.LAST_UPDATE_DATE_LIST.delete;
2416: IEU_PVT.LAST_UPDATE_LOGIN_LIST.delete;
2417: IEU_PVT.RESOURCE_ID_LIST.delete;
2418: IEU_PVT.SEL_ENUM_ID_LIST.delete;
2419: IEU_PVT.NODE_ID_LIST.delete;
2420: IEU_PVT.NODE_TYPE_LIST.delete;
2421: IEU_PVT.NODE_LABEL_LIST.delete;

Line 2418: IEU_PVT.SEL_ENUM_ID_LIST.delete;

2414: IEU_PVT.LAST_UPDATED_BY_LIST.delete;
2415: IEU_PVT.LAST_UPDATE_DATE_LIST.delete;
2416: IEU_PVT.LAST_UPDATE_LOGIN_LIST.delete;
2417: IEU_PVT.RESOURCE_ID_LIST.delete;
2418: IEU_PVT.SEL_ENUM_ID_LIST.delete;
2419: IEU_PVT.NODE_ID_LIST.delete;
2420: IEU_PVT.NODE_TYPE_LIST.delete;
2421: IEU_PVT.NODE_LABEL_LIST.delete;
2422: IEU_PVT.COUNT_LIST.delete;

Line 2419: IEU_PVT.NODE_ID_LIST.delete;

2415: IEU_PVT.LAST_UPDATE_DATE_LIST.delete;
2416: IEU_PVT.LAST_UPDATE_LOGIN_LIST.delete;
2417: IEU_PVT.RESOURCE_ID_LIST.delete;
2418: IEU_PVT.SEL_ENUM_ID_LIST.delete;
2419: IEU_PVT.NODE_ID_LIST.delete;
2420: IEU_PVT.NODE_TYPE_LIST.delete;
2421: IEU_PVT.NODE_LABEL_LIST.delete;
2422: IEU_PVT.COUNT_LIST.delete;
2423: IEU_PVT.DATA_SOURCE_LIST.delete;

Line 2420: IEU_PVT.NODE_TYPE_LIST.delete;

2416: IEU_PVT.LAST_UPDATE_LOGIN_LIST.delete;
2417: IEU_PVT.RESOURCE_ID_LIST.delete;
2418: IEU_PVT.SEL_ENUM_ID_LIST.delete;
2419: IEU_PVT.NODE_ID_LIST.delete;
2420: IEU_PVT.NODE_TYPE_LIST.delete;
2421: IEU_PVT.NODE_LABEL_LIST.delete;
2422: IEU_PVT.COUNT_LIST.delete;
2423: IEU_PVT.DATA_SOURCE_LIST.delete;
2424: IEU_PVT.VIEW_NAME_LIST.delete;

Line 2421: IEU_PVT.NODE_LABEL_LIST.delete;

2417: IEU_PVT.RESOURCE_ID_LIST.delete;
2418: IEU_PVT.SEL_ENUM_ID_LIST.delete;
2419: IEU_PVT.NODE_ID_LIST.delete;
2420: IEU_PVT.NODE_TYPE_LIST.delete;
2421: IEU_PVT.NODE_LABEL_LIST.delete;
2422: IEU_PVT.COUNT_LIST.delete;
2423: IEU_PVT.DATA_SOURCE_LIST.delete;
2424: IEU_PVT.VIEW_NAME_LIST.delete;
2425: IEU_PVT.MEDIA_TYPE_ID_LIST.delete;

Line 2422: IEU_PVT.COUNT_LIST.delete;

2418: IEU_PVT.SEL_ENUM_ID_LIST.delete;
2419: IEU_PVT.NODE_ID_LIST.delete;
2420: IEU_PVT.NODE_TYPE_LIST.delete;
2421: IEU_PVT.NODE_LABEL_LIST.delete;
2422: IEU_PVT.COUNT_LIST.delete;
2423: IEU_PVT.DATA_SOURCE_LIST.delete;
2424: IEU_PVT.VIEW_NAME_LIST.delete;
2425: IEU_PVT.MEDIA_TYPE_ID_LIST.delete;
2426: IEU_PVT.SEL_ENUM_PID_LIST.delete;

Line 2423: IEU_PVT.DATA_SOURCE_LIST.delete;

2419: IEU_PVT.NODE_ID_LIST.delete;
2420: IEU_PVT.NODE_TYPE_LIST.delete;
2421: IEU_PVT.NODE_LABEL_LIST.delete;
2422: IEU_PVT.COUNT_LIST.delete;
2423: IEU_PVT.DATA_SOURCE_LIST.delete;
2424: IEU_PVT.VIEW_NAME_LIST.delete;
2425: IEU_PVT.MEDIA_TYPE_ID_LIST.delete;
2426: IEU_PVT.SEL_ENUM_PID_LIST.delete;
2427: IEU_PVT.NODE_PID_LIST.delete;

Line 2424: IEU_PVT.VIEW_NAME_LIST.delete;

2420: IEU_PVT.NODE_TYPE_LIST.delete;
2421: IEU_PVT.NODE_LABEL_LIST.delete;
2422: IEU_PVT.COUNT_LIST.delete;
2423: IEU_PVT.DATA_SOURCE_LIST.delete;
2424: IEU_PVT.VIEW_NAME_LIST.delete;
2425: IEU_PVT.MEDIA_TYPE_ID_LIST.delete;
2426: IEU_PVT.SEL_ENUM_PID_LIST.delete;
2427: IEU_PVT.NODE_PID_LIST.delete;
2428: IEU_PVT.NODE_WEIGHT_LIST.delete;

Line 2425: IEU_PVT.MEDIA_TYPE_ID_LIST.delete;

2421: IEU_PVT.NODE_LABEL_LIST.delete;
2422: IEU_PVT.COUNT_LIST.delete;
2423: IEU_PVT.DATA_SOURCE_LIST.delete;
2424: IEU_PVT.VIEW_NAME_LIST.delete;
2425: IEU_PVT.MEDIA_TYPE_ID_LIST.delete;
2426: IEU_PVT.SEL_ENUM_PID_LIST.delete;
2427: IEU_PVT.NODE_PID_LIST.delete;
2428: IEU_PVT.NODE_WEIGHT_LIST.delete;
2429: IEU_PVT.WHERE_CLAUSE_LIST.delete;

Line 2426: IEU_PVT.SEL_ENUM_PID_LIST.delete;

2422: IEU_PVT.COUNT_LIST.delete;
2423: IEU_PVT.DATA_SOURCE_LIST.delete;
2424: IEU_PVT.VIEW_NAME_LIST.delete;
2425: IEU_PVT.MEDIA_TYPE_ID_LIST.delete;
2426: IEU_PVT.SEL_ENUM_PID_LIST.delete;
2427: IEU_PVT.NODE_PID_LIST.delete;
2428: IEU_PVT.NODE_WEIGHT_LIST.delete;
2429: IEU_PVT.WHERE_CLAUSE_LIST.delete;
2430: IEU_PVT.HIDE_IF_EMPTY_LIST.delete;

Line 2427: IEU_PVT.NODE_PID_LIST.delete;

2423: IEU_PVT.DATA_SOURCE_LIST.delete;
2424: IEU_PVT.VIEW_NAME_LIST.delete;
2425: IEU_PVT.MEDIA_TYPE_ID_LIST.delete;
2426: IEU_PVT.SEL_ENUM_PID_LIST.delete;
2427: IEU_PVT.NODE_PID_LIST.delete;
2428: IEU_PVT.NODE_WEIGHT_LIST.delete;
2429: IEU_PVT.WHERE_CLAUSE_LIST.delete;
2430: IEU_PVT.HIDE_IF_EMPTY_LIST.delete;
2431: IEU_PVT.NOT_VALID_LIST.delete;

Line 2428: IEU_PVT.NODE_WEIGHT_LIST.delete;

2424: IEU_PVT.VIEW_NAME_LIST.delete;
2425: IEU_PVT.MEDIA_TYPE_ID_LIST.delete;
2426: IEU_PVT.SEL_ENUM_PID_LIST.delete;
2427: IEU_PVT.NODE_PID_LIST.delete;
2428: IEU_PVT.NODE_WEIGHT_LIST.delete;
2429: IEU_PVT.WHERE_CLAUSE_LIST.delete;
2430: IEU_PVT.HIDE_IF_EMPTY_LIST.delete;
2431: IEU_PVT.NOT_VALID_LIST.delete;
2432: IEU_PVT.REFRESH_VIEW_NAME_LIST.delete;

Line 2429: IEU_PVT.WHERE_CLAUSE_LIST.delete;

2425: IEU_PVT.MEDIA_TYPE_ID_LIST.delete;
2426: IEU_PVT.SEL_ENUM_PID_LIST.delete;
2427: IEU_PVT.NODE_PID_LIST.delete;
2428: IEU_PVT.NODE_WEIGHT_LIST.delete;
2429: IEU_PVT.WHERE_CLAUSE_LIST.delete;
2430: IEU_PVT.HIDE_IF_EMPTY_LIST.delete;
2431: IEU_PVT.NOT_VALID_LIST.delete;
2432: IEU_PVT.REFRESH_VIEW_NAME_LIST.delete;
2433: IEU_PVT.RES_CAT_ENUM_FLAG_LIST.delete;

Line 2430: IEU_PVT.HIDE_IF_EMPTY_LIST.delete;

2426: IEU_PVT.SEL_ENUM_PID_LIST.delete;
2427: IEU_PVT.NODE_PID_LIST.delete;
2428: IEU_PVT.NODE_WEIGHT_LIST.delete;
2429: IEU_PVT.WHERE_CLAUSE_LIST.delete;
2430: IEU_PVT.HIDE_IF_EMPTY_LIST.delete;
2431: IEU_PVT.NOT_VALID_LIST.delete;
2432: IEU_PVT.REFRESH_VIEW_NAME_LIST.delete;
2433: IEU_PVT.RES_CAT_ENUM_FLAG_LIST.delete;
2434: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST.delete;

Line 2431: IEU_PVT.NOT_VALID_LIST.delete;

2427: IEU_PVT.NODE_PID_LIST.delete;
2428: IEU_PVT.NODE_WEIGHT_LIST.delete;
2429: IEU_PVT.WHERE_CLAUSE_LIST.delete;
2430: IEU_PVT.HIDE_IF_EMPTY_LIST.delete;
2431: IEU_PVT.NOT_VALID_LIST.delete;
2432: IEU_PVT.REFRESH_VIEW_NAME_LIST.delete;
2433: IEU_PVT.RES_CAT_ENUM_FLAG_LIST.delete;
2434: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST.delete;
2435: IEU_PVT.NODE_DEPTH_LIST.delete;

Line 2432: IEU_PVT.REFRESH_VIEW_NAME_LIST.delete;

2428: IEU_PVT.NODE_WEIGHT_LIST.delete;
2429: IEU_PVT.WHERE_CLAUSE_LIST.delete;
2430: IEU_PVT.HIDE_IF_EMPTY_LIST.delete;
2431: IEU_PVT.NOT_VALID_LIST.delete;
2432: IEU_PVT.REFRESH_VIEW_NAME_LIST.delete;
2433: IEU_PVT.RES_CAT_ENUM_FLAG_LIST.delete;
2434: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST.delete;
2435: IEU_PVT.NODE_DEPTH_LIST.delete;
2436: END IF;

Line 2433: IEU_PVT.RES_CAT_ENUM_FLAG_LIST.delete;

2429: IEU_PVT.WHERE_CLAUSE_LIST.delete;
2430: IEU_PVT.HIDE_IF_EMPTY_LIST.delete;
2431: IEU_PVT.NOT_VALID_LIST.delete;
2432: IEU_PVT.REFRESH_VIEW_NAME_LIST.delete;
2433: IEU_PVT.RES_CAT_ENUM_FLAG_LIST.delete;
2434: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST.delete;
2435: IEU_PVT.NODE_DEPTH_LIST.delete;
2436: END IF;
2437:

Line 2434: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST.delete;

2430: IEU_PVT.HIDE_IF_EMPTY_LIST.delete;
2431: IEU_PVT.NOT_VALID_LIST.delete;
2432: IEU_PVT.REFRESH_VIEW_NAME_LIST.delete;
2433: IEU_PVT.RES_CAT_ENUM_FLAG_LIST.delete;
2434: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST.delete;
2435: IEU_PVT.NODE_DEPTH_LIST.delete;
2436: END IF;
2437:
2438: IF IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.FIRST IS NOT NULL THEN

Line 2435: IEU_PVT.NODE_DEPTH_LIST.delete;

2431: IEU_PVT.NOT_VALID_LIST.delete;
2432: IEU_PVT.REFRESH_VIEW_NAME_LIST.delete;
2433: IEU_PVT.RES_CAT_ENUM_FLAG_LIST.delete;
2434: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST.delete;
2435: IEU_PVT.NODE_DEPTH_LIST.delete;
2436: END IF;
2437:
2438: IF IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.FIRST IS NOT NULL THEN
2439: FORALL i IN IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.FIRST..IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.LAST SAVE EXCEPTIONS

Line 2438: IF IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.FIRST IS NOT NULL THEN

2434: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST.delete;
2435: IEU_PVT.NODE_DEPTH_LIST.delete;
2436: END IF;
2437:
2438: IF IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.FIRST IS NOT NULL THEN
2439: FORALL i IN IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.FIRST..IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.LAST SAVE EXCEPTIONS
2440: insert into IEU_UWQ_SEL_RT_NODES values IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(i);
2441:
2442: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.delete;

Line 2439: FORALL i IN IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.FIRST..IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.LAST SAVE EXCEPTIONS

2435: IEU_PVT.NODE_DEPTH_LIST.delete;
2436: END IF;
2437:
2438: IF IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.FIRST IS NOT NULL THEN
2439: FORALL i IN IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.FIRST..IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.LAST SAVE EXCEPTIONS
2440: insert into IEU_UWQ_SEL_RT_NODES values IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(i);
2441:
2442: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.delete;
2443: END IF;

Line 2440: insert into IEU_UWQ_SEL_RT_NODES values IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(i);

2436: END IF;
2437:
2438: IF IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.FIRST IS NOT NULL THEN
2439: FORALL i IN IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.FIRST..IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.LAST SAVE EXCEPTIONS
2440: insert into IEU_UWQ_SEL_RT_NODES values IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(i);
2441:
2442: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.delete;
2443: END IF;
2444:

Line 2442: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.delete;

2438: IF IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.FIRST IS NOT NULL THEN
2439: FORALL i IN IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.FIRST..IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.LAST SAVE EXCEPTIONS
2440: insert into IEU_UWQ_SEL_RT_NODES values IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(i);
2441:
2442: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.delete;
2443: END IF;
2444:
2445: IF IEU_PVT.BIND_VAR_NAME_LIST.FIRST IS NOT NULL THEN
2446: FORALL i IN IEU_PVT.BIND_VAR_NAME_LIST.FIRST..IEU_PVT.BIND_VAR_NAME_LIST.LAST SAVE EXCEPTIONS

Line 2445: IF IEU_PVT.BIND_VAR_NAME_LIST.FIRST IS NOT NULL THEN

2441:
2442: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.delete;
2443: END IF;
2444:
2445: IF IEU_PVT.BIND_VAR_NAME_LIST.FIRST IS NOT NULL THEN
2446: FORALL i IN IEU_PVT.BIND_VAR_NAME_LIST.FIRST..IEU_PVT.BIND_VAR_NAME_LIST.LAST SAVE EXCEPTIONS
2447: UPDATE IEU_UWQ_RTNODE_BIND_VALS SET
2448: LAST_UPDATED_BY = IEU_PVT.BIND_LAST_UPDATED_BY_LIST(i),
2449: LAST_UPDATE_DATE = IEU_PVT.BIND_LAST_UPDATE_DATE_LIST(i),

Line 2446: FORALL i IN IEU_PVT.BIND_VAR_NAME_LIST.FIRST..IEU_PVT.BIND_VAR_NAME_LIST.LAST SAVE EXCEPTIONS

2442: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.delete;
2443: END IF;
2444:
2445: IF IEU_PVT.BIND_VAR_NAME_LIST.FIRST IS NOT NULL THEN
2446: FORALL i IN IEU_PVT.BIND_VAR_NAME_LIST.FIRST..IEU_PVT.BIND_VAR_NAME_LIST.LAST SAVE EXCEPTIONS
2447: UPDATE IEU_UWQ_RTNODE_BIND_VALS SET
2448: LAST_UPDATED_BY = IEU_PVT.BIND_LAST_UPDATED_BY_LIST(i),
2449: LAST_UPDATE_DATE = IEU_PVT.BIND_LAST_UPDATE_DATE_LIST(i),
2450: LAST_UPDATE_LOGIN = IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST(i),

Line 2448: LAST_UPDATED_BY = IEU_PVT.BIND_LAST_UPDATED_BY_LIST(i),

2444:
2445: IF IEU_PVT.BIND_VAR_NAME_LIST.FIRST IS NOT NULL THEN
2446: FORALL i IN IEU_PVT.BIND_VAR_NAME_LIST.FIRST..IEU_PVT.BIND_VAR_NAME_LIST.LAST SAVE EXCEPTIONS
2447: UPDATE IEU_UWQ_RTNODE_BIND_VALS SET
2448: LAST_UPDATED_BY = IEU_PVT.BIND_LAST_UPDATED_BY_LIST(i),
2449: LAST_UPDATE_DATE = IEU_PVT.BIND_LAST_UPDATE_DATE_LIST(i),
2450: LAST_UPDATE_LOGIN = IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST(i),
2451: BIND_VAR_VALUE = IEU_PVT.BIND_VAR_VALUE_LIST(i),
2452: BIND_VAR_DATATYPE = IEU_PVT.BIND_VAR_DATATYPE_LIST(i),

Line 2449: LAST_UPDATE_DATE = IEU_PVT.BIND_LAST_UPDATE_DATE_LIST(i),

2445: IF IEU_PVT.BIND_VAR_NAME_LIST.FIRST IS NOT NULL THEN
2446: FORALL i IN IEU_PVT.BIND_VAR_NAME_LIST.FIRST..IEU_PVT.BIND_VAR_NAME_LIST.LAST SAVE EXCEPTIONS
2447: UPDATE IEU_UWQ_RTNODE_BIND_VALS SET
2448: LAST_UPDATED_BY = IEU_PVT.BIND_LAST_UPDATED_BY_LIST(i),
2449: LAST_UPDATE_DATE = IEU_PVT.BIND_LAST_UPDATE_DATE_LIST(i),
2450: LAST_UPDATE_LOGIN = IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST(i),
2451: BIND_VAR_VALUE = IEU_PVT.BIND_VAR_VALUE_LIST(i),
2452: BIND_VAR_DATATYPE = IEU_PVT.BIND_VAR_DATATYPE_LIST(i),
2453: NOT_VALID_FLAG = IEU_PVT.NOT_VALID_FLAG_LIST(i),

Line 2450: LAST_UPDATE_LOGIN = IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST(i),

2446: FORALL i IN IEU_PVT.BIND_VAR_NAME_LIST.FIRST..IEU_PVT.BIND_VAR_NAME_LIST.LAST SAVE EXCEPTIONS
2447: UPDATE IEU_UWQ_RTNODE_BIND_VALS SET
2448: LAST_UPDATED_BY = IEU_PVT.BIND_LAST_UPDATED_BY_LIST(i),
2449: LAST_UPDATE_DATE = IEU_PVT.BIND_LAST_UPDATE_DATE_LIST(i),
2450: LAST_UPDATE_LOGIN = IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST(i),
2451: BIND_VAR_VALUE = IEU_PVT.BIND_VAR_VALUE_LIST(i),
2452: BIND_VAR_DATATYPE = IEU_PVT.BIND_VAR_DATATYPE_LIST(i),
2453: NOT_VALID_FLAG = IEU_PVT.NOT_VALID_FLAG_LIST(i),
2454: SEL_RT_NODE_ID = IEU_PVT.BIND_SEL_RT_NODE_ID_LIST(i),

Line 2451: BIND_VAR_VALUE = IEU_PVT.BIND_VAR_VALUE_LIST(i),

2447: UPDATE IEU_UWQ_RTNODE_BIND_VALS SET
2448: LAST_UPDATED_BY = IEU_PVT.BIND_LAST_UPDATED_BY_LIST(i),
2449: LAST_UPDATE_DATE = IEU_PVT.BIND_LAST_UPDATE_DATE_LIST(i),
2450: LAST_UPDATE_LOGIN = IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST(i),
2451: BIND_VAR_VALUE = IEU_PVT.BIND_VAR_VALUE_LIST(i),
2452: BIND_VAR_DATATYPE = IEU_PVT.BIND_VAR_DATATYPE_LIST(i),
2453: NOT_VALID_FLAG = IEU_PVT.NOT_VALID_FLAG_LIST(i),
2454: SEL_RT_NODE_ID = IEU_PVT.BIND_SEL_RT_NODE_ID_LIST(i),
2455: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1

Line 2452: BIND_VAR_DATATYPE = IEU_PVT.BIND_VAR_DATATYPE_LIST(i),

2448: LAST_UPDATED_BY = IEU_PVT.BIND_LAST_UPDATED_BY_LIST(i),
2449: LAST_UPDATE_DATE = IEU_PVT.BIND_LAST_UPDATE_DATE_LIST(i),
2450: LAST_UPDATE_LOGIN = IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST(i),
2451: BIND_VAR_VALUE = IEU_PVT.BIND_VAR_VALUE_LIST(i),
2452: BIND_VAR_DATATYPE = IEU_PVT.BIND_VAR_DATATYPE_LIST(i),
2453: NOT_VALID_FLAG = IEU_PVT.NOT_VALID_FLAG_LIST(i),
2454: SEL_RT_NODE_ID = IEU_PVT.BIND_SEL_RT_NODE_ID_LIST(i),
2455: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
2456: WHERE RESOURCE_ID = IEU_PVT.BIND_RESOURCE_ID_LIST(i)

Line 2453: NOT_VALID_FLAG = IEU_PVT.NOT_VALID_FLAG_LIST(i),

2449: LAST_UPDATE_DATE = IEU_PVT.BIND_LAST_UPDATE_DATE_LIST(i),
2450: LAST_UPDATE_LOGIN = IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST(i),
2451: BIND_VAR_VALUE = IEU_PVT.BIND_VAR_VALUE_LIST(i),
2452: BIND_VAR_DATATYPE = IEU_PVT.BIND_VAR_DATATYPE_LIST(i),
2453: NOT_VALID_FLAG = IEU_PVT.NOT_VALID_FLAG_LIST(i),
2454: SEL_RT_NODE_ID = IEU_PVT.BIND_SEL_RT_NODE_ID_LIST(i),
2455: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
2456: WHERE RESOURCE_ID = IEU_PVT.BIND_RESOURCE_ID_LIST(i)
2457: AND NODE_ID = IEU_PVT.BIND_NODE_ID_LIST(i)

Line 2454: SEL_RT_NODE_ID = IEU_PVT.BIND_SEL_RT_NODE_ID_LIST(i),

2450: LAST_UPDATE_LOGIN = IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST(i),
2451: BIND_VAR_VALUE = IEU_PVT.BIND_VAR_VALUE_LIST(i),
2452: BIND_VAR_DATATYPE = IEU_PVT.BIND_VAR_DATATYPE_LIST(i),
2453: NOT_VALID_FLAG = IEU_PVT.NOT_VALID_FLAG_LIST(i),
2454: SEL_RT_NODE_ID = IEU_PVT.BIND_SEL_RT_NODE_ID_LIST(i),
2455: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
2456: WHERE RESOURCE_ID = IEU_PVT.BIND_RESOURCE_ID_LIST(i)
2457: AND NODE_ID = IEU_PVT.BIND_NODE_ID_LIST(i)
2458: AND BIND_VAR_NAME = IEU_PVT.BIND_VAR_NAME_LIST(i);

Line 2456: WHERE RESOURCE_ID = IEU_PVT.BIND_RESOURCE_ID_LIST(i)

2452: BIND_VAR_DATATYPE = IEU_PVT.BIND_VAR_DATATYPE_LIST(i),
2453: NOT_VALID_FLAG = IEU_PVT.NOT_VALID_FLAG_LIST(i),
2454: SEL_RT_NODE_ID = IEU_PVT.BIND_SEL_RT_NODE_ID_LIST(i),
2455: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
2456: WHERE RESOURCE_ID = IEU_PVT.BIND_RESOURCE_ID_LIST(i)
2457: AND NODE_ID = IEU_PVT.BIND_NODE_ID_LIST(i)
2458: AND BIND_VAR_NAME = IEU_PVT.BIND_VAR_NAME_LIST(i);
2459:
2460: IEU_PVT.BIND_LAST_UPDATED_BY_LIST.delete;

Line 2457: AND NODE_ID = IEU_PVT.BIND_NODE_ID_LIST(i)

2453: NOT_VALID_FLAG = IEU_PVT.NOT_VALID_FLAG_LIST(i),
2454: SEL_RT_NODE_ID = IEU_PVT.BIND_SEL_RT_NODE_ID_LIST(i),
2455: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
2456: WHERE RESOURCE_ID = IEU_PVT.BIND_RESOURCE_ID_LIST(i)
2457: AND NODE_ID = IEU_PVT.BIND_NODE_ID_LIST(i)
2458: AND BIND_VAR_NAME = IEU_PVT.BIND_VAR_NAME_LIST(i);
2459:
2460: IEU_PVT.BIND_LAST_UPDATED_BY_LIST.delete;
2461: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST.delete;

Line 2458: AND BIND_VAR_NAME = IEU_PVT.BIND_VAR_NAME_LIST(i);

2454: SEL_RT_NODE_ID = IEU_PVT.BIND_SEL_RT_NODE_ID_LIST(i),
2455: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
2456: WHERE RESOURCE_ID = IEU_PVT.BIND_RESOURCE_ID_LIST(i)
2457: AND NODE_ID = IEU_PVT.BIND_NODE_ID_LIST(i)
2458: AND BIND_VAR_NAME = IEU_PVT.BIND_VAR_NAME_LIST(i);
2459:
2460: IEU_PVT.BIND_LAST_UPDATED_BY_LIST.delete;
2461: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST.delete;
2462: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST.delete;

Line 2460: IEU_PVT.BIND_LAST_UPDATED_BY_LIST.delete;

2456: WHERE RESOURCE_ID = IEU_PVT.BIND_RESOURCE_ID_LIST(i)
2457: AND NODE_ID = IEU_PVT.BIND_NODE_ID_LIST(i)
2458: AND BIND_VAR_NAME = IEU_PVT.BIND_VAR_NAME_LIST(i);
2459:
2460: IEU_PVT.BIND_LAST_UPDATED_BY_LIST.delete;
2461: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST.delete;
2462: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST.delete;
2463: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST.delete;
2464: IEU_PVT.BIND_RESOURCE_ID_LIST.delete;

Line 2461: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST.delete;

2457: AND NODE_ID = IEU_PVT.BIND_NODE_ID_LIST(i)
2458: AND BIND_VAR_NAME = IEU_PVT.BIND_VAR_NAME_LIST(i);
2459:
2460: IEU_PVT.BIND_LAST_UPDATED_BY_LIST.delete;
2461: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST.delete;
2462: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST.delete;
2463: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST.delete;
2464: IEU_PVT.BIND_RESOURCE_ID_LIST.delete;
2465: IEU_PVT.BIND_NODE_ID_LIST.delete;

Line 2462: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST.delete;

2458: AND BIND_VAR_NAME = IEU_PVT.BIND_VAR_NAME_LIST(i);
2459:
2460: IEU_PVT.BIND_LAST_UPDATED_BY_LIST.delete;
2461: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST.delete;
2462: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST.delete;
2463: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST.delete;
2464: IEU_PVT.BIND_RESOURCE_ID_LIST.delete;
2465: IEU_PVT.BIND_NODE_ID_LIST.delete;
2466: IEU_PVT.BIND_VAR_NAME_LIST.delete;

Line 2463: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST.delete;

2459:
2460: IEU_PVT.BIND_LAST_UPDATED_BY_LIST.delete;
2461: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST.delete;
2462: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST.delete;
2463: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST.delete;
2464: IEU_PVT.BIND_RESOURCE_ID_LIST.delete;
2465: IEU_PVT.BIND_NODE_ID_LIST.delete;
2466: IEU_PVT.BIND_VAR_NAME_LIST.delete;
2467: IEU_PVT.BIND_VAR_VALUE_LIST.delete;

Line 2464: IEU_PVT.BIND_RESOURCE_ID_LIST.delete;

2460: IEU_PVT.BIND_LAST_UPDATED_BY_LIST.delete;
2461: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST.delete;
2462: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST.delete;
2463: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST.delete;
2464: IEU_PVT.BIND_RESOURCE_ID_LIST.delete;
2465: IEU_PVT.BIND_NODE_ID_LIST.delete;
2466: IEU_PVT.BIND_VAR_NAME_LIST.delete;
2467: IEU_PVT.BIND_VAR_VALUE_LIST.delete;
2468: IEU_PVT.BIND_VAR_DATATYPE_LIST.delete;

Line 2465: IEU_PVT.BIND_NODE_ID_LIST.delete;

2461: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST.delete;
2462: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST.delete;
2463: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST.delete;
2464: IEU_PVT.BIND_RESOURCE_ID_LIST.delete;
2465: IEU_PVT.BIND_NODE_ID_LIST.delete;
2466: IEU_PVT.BIND_VAR_NAME_LIST.delete;
2467: IEU_PVT.BIND_VAR_VALUE_LIST.delete;
2468: IEU_PVT.BIND_VAR_DATATYPE_LIST.delete;
2469: IEU_PVT.NOT_VALID_FLAG_LIST.delete;

Line 2466: IEU_PVT.BIND_VAR_NAME_LIST.delete;

2462: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST.delete;
2463: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST.delete;
2464: IEU_PVT.BIND_RESOURCE_ID_LIST.delete;
2465: IEU_PVT.BIND_NODE_ID_LIST.delete;
2466: IEU_PVT.BIND_VAR_NAME_LIST.delete;
2467: IEU_PVT.BIND_VAR_VALUE_LIST.delete;
2468: IEU_PVT.BIND_VAR_DATATYPE_LIST.delete;
2469: IEU_PVT.NOT_VALID_FLAG_LIST.delete;
2470: END IF;

Line 2467: IEU_PVT.BIND_VAR_VALUE_LIST.delete;

2463: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST.delete;
2464: IEU_PVT.BIND_RESOURCE_ID_LIST.delete;
2465: IEU_PVT.BIND_NODE_ID_LIST.delete;
2466: IEU_PVT.BIND_VAR_NAME_LIST.delete;
2467: IEU_PVT.BIND_VAR_VALUE_LIST.delete;
2468: IEU_PVT.BIND_VAR_DATATYPE_LIST.delete;
2469: IEU_PVT.NOT_VALID_FLAG_LIST.delete;
2470: END IF;
2471:

Line 2468: IEU_PVT.BIND_VAR_DATATYPE_LIST.delete;

2464: IEU_PVT.BIND_RESOURCE_ID_LIST.delete;
2465: IEU_PVT.BIND_NODE_ID_LIST.delete;
2466: IEU_PVT.BIND_VAR_NAME_LIST.delete;
2467: IEU_PVT.BIND_VAR_VALUE_LIST.delete;
2468: IEU_PVT.BIND_VAR_DATATYPE_LIST.delete;
2469: IEU_PVT.NOT_VALID_FLAG_LIST.delete;
2470: END IF;
2471:
2472: IF IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST IS NOT NULL THEN

Line 2469: IEU_PVT.NOT_VALID_FLAG_LIST.delete;

2465: IEU_PVT.BIND_NODE_ID_LIST.delete;
2466: IEU_PVT.BIND_VAR_NAME_LIST.delete;
2467: IEU_PVT.BIND_VAR_VALUE_LIST.delete;
2468: IEU_PVT.BIND_VAR_DATATYPE_LIST.delete;
2469: IEU_PVT.NOT_VALID_FLAG_LIST.delete;
2470: END IF;
2471:
2472: IF IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST IS NOT NULL THEN
2473: FORALL i IN IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST..IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.LAST SAVE EXCEPTIONS

Line 2472: IF IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST IS NOT NULL THEN

2468: IEU_PVT.BIND_VAR_DATATYPE_LIST.delete;
2469: IEU_PVT.NOT_VALID_FLAG_LIST.delete;
2470: END IF;
2471:
2472: IF IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST IS NOT NULL THEN
2473: FORALL i IN IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST..IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.LAST SAVE EXCEPTIONS
2474: insert into IEU_UWQ_RTNODE_BIND_VALS values IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(i);
2475:
2476: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.delete;

Line 2473: FORALL i IN IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST..IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.LAST SAVE EXCEPTIONS

2469: IEU_PVT.NOT_VALID_FLAG_LIST.delete;
2470: END IF;
2471:
2472: IF IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST IS NOT NULL THEN
2473: FORALL i IN IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST..IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.LAST SAVE EXCEPTIONS
2474: insert into IEU_UWQ_RTNODE_BIND_VALS values IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(i);
2475:
2476: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.delete;
2477: END IF;

Line 2474: insert into IEU_UWQ_RTNODE_BIND_VALS values IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(i);

2470: END IF;
2471:
2472: IF IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST IS NOT NULL THEN
2473: FORALL i IN IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST..IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.LAST SAVE EXCEPTIONS
2474: insert into IEU_UWQ_RTNODE_BIND_VALS values IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(i);
2475:
2476: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.delete;
2477: END IF;
2478: -- COMMIT;

Line 2476: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.delete;

2472: IF IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST IS NOT NULL THEN
2473: FORALL i IN IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.FIRST..IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.LAST SAVE EXCEPTIONS
2474: insert into IEU_UWQ_RTNODE_BIND_VALS values IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(i);
2475:
2476: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.delete;
2477: END IF;
2478: -- COMMIT;
2479:
2480: EXCEPTION

Line 2482: IEU_PVT.LAST_UPDATED_BY_LIST.delete;

2478: -- COMMIT;
2479:
2480: EXCEPTION
2481: WHEN OTHERS THEN
2482: IEU_PVT.LAST_UPDATED_BY_LIST.delete;
2483: IEU_PVT.LAST_UPDATE_DATE_LIST.delete;
2484: IEU_PVT.LAST_UPDATE_LOGIN_LIST.delete;
2485: IEU_PVT.RESOURCE_ID_LIST.delete;
2486: IEU_PVT.SEL_ENUM_ID_LIST.delete;

Line 2483: IEU_PVT.LAST_UPDATE_DATE_LIST.delete;

2479:
2480: EXCEPTION
2481: WHEN OTHERS THEN
2482: IEU_PVT.LAST_UPDATED_BY_LIST.delete;
2483: IEU_PVT.LAST_UPDATE_DATE_LIST.delete;
2484: IEU_PVT.LAST_UPDATE_LOGIN_LIST.delete;
2485: IEU_PVT.RESOURCE_ID_LIST.delete;
2486: IEU_PVT.SEL_ENUM_ID_LIST.delete;
2487: IEU_PVT.NODE_ID_LIST.delete;

Line 2484: IEU_PVT.LAST_UPDATE_LOGIN_LIST.delete;

2480: EXCEPTION
2481: WHEN OTHERS THEN
2482: IEU_PVT.LAST_UPDATED_BY_LIST.delete;
2483: IEU_PVT.LAST_UPDATE_DATE_LIST.delete;
2484: IEU_PVT.LAST_UPDATE_LOGIN_LIST.delete;
2485: IEU_PVT.RESOURCE_ID_LIST.delete;
2486: IEU_PVT.SEL_ENUM_ID_LIST.delete;
2487: IEU_PVT.NODE_ID_LIST.delete;
2488: IEU_PVT.NODE_TYPE_LIST.delete;

Line 2485: IEU_PVT.RESOURCE_ID_LIST.delete;

2481: WHEN OTHERS THEN
2482: IEU_PVT.LAST_UPDATED_BY_LIST.delete;
2483: IEU_PVT.LAST_UPDATE_DATE_LIST.delete;
2484: IEU_PVT.LAST_UPDATE_LOGIN_LIST.delete;
2485: IEU_PVT.RESOURCE_ID_LIST.delete;
2486: IEU_PVT.SEL_ENUM_ID_LIST.delete;
2487: IEU_PVT.NODE_ID_LIST.delete;
2488: IEU_PVT.NODE_TYPE_LIST.delete;
2489: IEU_PVT.NODE_LABEL_LIST.delete;

Line 2486: IEU_PVT.SEL_ENUM_ID_LIST.delete;

2482: IEU_PVT.LAST_UPDATED_BY_LIST.delete;
2483: IEU_PVT.LAST_UPDATE_DATE_LIST.delete;
2484: IEU_PVT.LAST_UPDATE_LOGIN_LIST.delete;
2485: IEU_PVT.RESOURCE_ID_LIST.delete;
2486: IEU_PVT.SEL_ENUM_ID_LIST.delete;
2487: IEU_PVT.NODE_ID_LIST.delete;
2488: IEU_PVT.NODE_TYPE_LIST.delete;
2489: IEU_PVT.NODE_LABEL_LIST.delete;
2490: IEU_PVT.COUNT_LIST.delete;

Line 2487: IEU_PVT.NODE_ID_LIST.delete;

2483: IEU_PVT.LAST_UPDATE_DATE_LIST.delete;
2484: IEU_PVT.LAST_UPDATE_LOGIN_LIST.delete;
2485: IEU_PVT.RESOURCE_ID_LIST.delete;
2486: IEU_PVT.SEL_ENUM_ID_LIST.delete;
2487: IEU_PVT.NODE_ID_LIST.delete;
2488: IEU_PVT.NODE_TYPE_LIST.delete;
2489: IEU_PVT.NODE_LABEL_LIST.delete;
2490: IEU_PVT.COUNT_LIST.delete;
2491: IEU_PVT.DATA_SOURCE_LIST.delete;

Line 2488: IEU_PVT.NODE_TYPE_LIST.delete;

2484: IEU_PVT.LAST_UPDATE_LOGIN_LIST.delete;
2485: IEU_PVT.RESOURCE_ID_LIST.delete;
2486: IEU_PVT.SEL_ENUM_ID_LIST.delete;
2487: IEU_PVT.NODE_ID_LIST.delete;
2488: IEU_PVT.NODE_TYPE_LIST.delete;
2489: IEU_PVT.NODE_LABEL_LIST.delete;
2490: IEU_PVT.COUNT_LIST.delete;
2491: IEU_PVT.DATA_SOURCE_LIST.delete;
2492: IEU_PVT.VIEW_NAME_LIST.delete;

Line 2489: IEU_PVT.NODE_LABEL_LIST.delete;

2485: IEU_PVT.RESOURCE_ID_LIST.delete;
2486: IEU_PVT.SEL_ENUM_ID_LIST.delete;
2487: IEU_PVT.NODE_ID_LIST.delete;
2488: IEU_PVT.NODE_TYPE_LIST.delete;
2489: IEU_PVT.NODE_LABEL_LIST.delete;
2490: IEU_PVT.COUNT_LIST.delete;
2491: IEU_PVT.DATA_SOURCE_LIST.delete;
2492: IEU_PVT.VIEW_NAME_LIST.delete;
2493: IEU_PVT.MEDIA_TYPE_ID_LIST.delete;

Line 2490: IEU_PVT.COUNT_LIST.delete;

2486: IEU_PVT.SEL_ENUM_ID_LIST.delete;
2487: IEU_PVT.NODE_ID_LIST.delete;
2488: IEU_PVT.NODE_TYPE_LIST.delete;
2489: IEU_PVT.NODE_LABEL_LIST.delete;
2490: IEU_PVT.COUNT_LIST.delete;
2491: IEU_PVT.DATA_SOURCE_LIST.delete;
2492: IEU_PVT.VIEW_NAME_LIST.delete;
2493: IEU_PVT.MEDIA_TYPE_ID_LIST.delete;
2494: IEU_PVT.SEL_ENUM_PID_LIST.delete;

Line 2491: IEU_PVT.DATA_SOURCE_LIST.delete;

2487: IEU_PVT.NODE_ID_LIST.delete;
2488: IEU_PVT.NODE_TYPE_LIST.delete;
2489: IEU_PVT.NODE_LABEL_LIST.delete;
2490: IEU_PVT.COUNT_LIST.delete;
2491: IEU_PVT.DATA_SOURCE_LIST.delete;
2492: IEU_PVT.VIEW_NAME_LIST.delete;
2493: IEU_PVT.MEDIA_TYPE_ID_LIST.delete;
2494: IEU_PVT.SEL_ENUM_PID_LIST.delete;
2495: IEU_PVT.NODE_PID_LIST.delete;

Line 2492: IEU_PVT.VIEW_NAME_LIST.delete;

2488: IEU_PVT.NODE_TYPE_LIST.delete;
2489: IEU_PVT.NODE_LABEL_LIST.delete;
2490: IEU_PVT.COUNT_LIST.delete;
2491: IEU_PVT.DATA_SOURCE_LIST.delete;
2492: IEU_PVT.VIEW_NAME_LIST.delete;
2493: IEU_PVT.MEDIA_TYPE_ID_LIST.delete;
2494: IEU_PVT.SEL_ENUM_PID_LIST.delete;
2495: IEU_PVT.NODE_PID_LIST.delete;
2496: IEU_PVT.NODE_WEIGHT_LIST.delete;

Line 2493: IEU_PVT.MEDIA_TYPE_ID_LIST.delete;

2489: IEU_PVT.NODE_LABEL_LIST.delete;
2490: IEU_PVT.COUNT_LIST.delete;
2491: IEU_PVT.DATA_SOURCE_LIST.delete;
2492: IEU_PVT.VIEW_NAME_LIST.delete;
2493: IEU_PVT.MEDIA_TYPE_ID_LIST.delete;
2494: IEU_PVT.SEL_ENUM_PID_LIST.delete;
2495: IEU_PVT.NODE_PID_LIST.delete;
2496: IEU_PVT.NODE_WEIGHT_LIST.delete;
2497: IEU_PVT.WHERE_CLAUSE_LIST.delete;

Line 2494: IEU_PVT.SEL_ENUM_PID_LIST.delete;

2490: IEU_PVT.COUNT_LIST.delete;
2491: IEU_PVT.DATA_SOURCE_LIST.delete;
2492: IEU_PVT.VIEW_NAME_LIST.delete;
2493: IEU_PVT.MEDIA_TYPE_ID_LIST.delete;
2494: IEU_PVT.SEL_ENUM_PID_LIST.delete;
2495: IEU_PVT.NODE_PID_LIST.delete;
2496: IEU_PVT.NODE_WEIGHT_LIST.delete;
2497: IEU_PVT.WHERE_CLAUSE_LIST.delete;
2498: IEU_PVT.HIDE_IF_EMPTY_LIST.delete;

Line 2495: IEU_PVT.NODE_PID_LIST.delete;

2491: IEU_PVT.DATA_SOURCE_LIST.delete;
2492: IEU_PVT.VIEW_NAME_LIST.delete;
2493: IEU_PVT.MEDIA_TYPE_ID_LIST.delete;
2494: IEU_PVT.SEL_ENUM_PID_LIST.delete;
2495: IEU_PVT.NODE_PID_LIST.delete;
2496: IEU_PVT.NODE_WEIGHT_LIST.delete;
2497: IEU_PVT.WHERE_CLAUSE_LIST.delete;
2498: IEU_PVT.HIDE_IF_EMPTY_LIST.delete;
2499: IEU_PVT.NOT_VALID_LIST.delete;

Line 2496: IEU_PVT.NODE_WEIGHT_LIST.delete;

2492: IEU_PVT.VIEW_NAME_LIST.delete;
2493: IEU_PVT.MEDIA_TYPE_ID_LIST.delete;
2494: IEU_PVT.SEL_ENUM_PID_LIST.delete;
2495: IEU_PVT.NODE_PID_LIST.delete;
2496: IEU_PVT.NODE_WEIGHT_LIST.delete;
2497: IEU_PVT.WHERE_CLAUSE_LIST.delete;
2498: IEU_PVT.HIDE_IF_EMPTY_LIST.delete;
2499: IEU_PVT.NOT_VALID_LIST.delete;
2500: IEU_PVT.REFRESH_VIEW_NAME_LIST.delete;

Line 2497: IEU_PVT.WHERE_CLAUSE_LIST.delete;

2493: IEU_PVT.MEDIA_TYPE_ID_LIST.delete;
2494: IEU_PVT.SEL_ENUM_PID_LIST.delete;
2495: IEU_PVT.NODE_PID_LIST.delete;
2496: IEU_PVT.NODE_WEIGHT_LIST.delete;
2497: IEU_PVT.WHERE_CLAUSE_LIST.delete;
2498: IEU_PVT.HIDE_IF_EMPTY_LIST.delete;
2499: IEU_PVT.NOT_VALID_LIST.delete;
2500: IEU_PVT.REFRESH_VIEW_NAME_LIST.delete;
2501: IEU_PVT.RES_CAT_ENUM_FLAG_LIST.delete;

Line 2498: IEU_PVT.HIDE_IF_EMPTY_LIST.delete;

2494: IEU_PVT.SEL_ENUM_PID_LIST.delete;
2495: IEU_PVT.NODE_PID_LIST.delete;
2496: IEU_PVT.NODE_WEIGHT_LIST.delete;
2497: IEU_PVT.WHERE_CLAUSE_LIST.delete;
2498: IEU_PVT.HIDE_IF_EMPTY_LIST.delete;
2499: IEU_PVT.NOT_VALID_LIST.delete;
2500: IEU_PVT.REFRESH_VIEW_NAME_LIST.delete;
2501: IEU_PVT.RES_CAT_ENUM_FLAG_LIST.delete;
2502: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST.delete;

Line 2499: IEU_PVT.NOT_VALID_LIST.delete;

2495: IEU_PVT.NODE_PID_LIST.delete;
2496: IEU_PVT.NODE_WEIGHT_LIST.delete;
2497: IEU_PVT.WHERE_CLAUSE_LIST.delete;
2498: IEU_PVT.HIDE_IF_EMPTY_LIST.delete;
2499: IEU_PVT.NOT_VALID_LIST.delete;
2500: IEU_PVT.REFRESH_VIEW_NAME_LIST.delete;
2501: IEU_PVT.RES_CAT_ENUM_FLAG_LIST.delete;
2502: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST.delete;
2503: IEU_PVT.NODE_DEPTH_LIST.delete;

Line 2500: IEU_PVT.REFRESH_VIEW_NAME_LIST.delete;

2496: IEU_PVT.NODE_WEIGHT_LIST.delete;
2497: IEU_PVT.WHERE_CLAUSE_LIST.delete;
2498: IEU_PVT.HIDE_IF_EMPTY_LIST.delete;
2499: IEU_PVT.NOT_VALID_LIST.delete;
2500: IEU_PVT.REFRESH_VIEW_NAME_LIST.delete;
2501: IEU_PVT.RES_CAT_ENUM_FLAG_LIST.delete;
2502: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST.delete;
2503: IEU_PVT.NODE_DEPTH_LIST.delete;
2504:

Line 2501: IEU_PVT.RES_CAT_ENUM_FLAG_LIST.delete;

2497: IEU_PVT.WHERE_CLAUSE_LIST.delete;
2498: IEU_PVT.HIDE_IF_EMPTY_LIST.delete;
2499: IEU_PVT.NOT_VALID_LIST.delete;
2500: IEU_PVT.REFRESH_VIEW_NAME_LIST.delete;
2501: IEU_PVT.RES_CAT_ENUM_FLAG_LIST.delete;
2502: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST.delete;
2503: IEU_PVT.NODE_DEPTH_LIST.delete;
2504:
2505: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.delete;

Line 2502: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST.delete;

2498: IEU_PVT.HIDE_IF_EMPTY_LIST.delete;
2499: IEU_PVT.NOT_VALID_LIST.delete;
2500: IEU_PVT.REFRESH_VIEW_NAME_LIST.delete;
2501: IEU_PVT.RES_CAT_ENUM_FLAG_LIST.delete;
2502: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST.delete;
2503: IEU_PVT.NODE_DEPTH_LIST.delete;
2504:
2505: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.delete;
2506:

Line 2503: IEU_PVT.NODE_DEPTH_LIST.delete;

2499: IEU_PVT.NOT_VALID_LIST.delete;
2500: IEU_PVT.REFRESH_VIEW_NAME_LIST.delete;
2501: IEU_PVT.RES_CAT_ENUM_FLAG_LIST.delete;
2502: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST.delete;
2503: IEU_PVT.NODE_DEPTH_LIST.delete;
2504:
2505: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.delete;
2506:
2507: IEU_PVT.BIND_LAST_UPDATED_BY_LIST.delete;

Line 2505: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.delete;

2501: IEU_PVT.RES_CAT_ENUM_FLAG_LIST.delete;
2502: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST.delete;
2503: IEU_PVT.NODE_DEPTH_LIST.delete;
2504:
2505: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.delete;
2506:
2507: IEU_PVT.BIND_LAST_UPDATED_BY_LIST.delete;
2508: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST.delete;
2509: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST.delete;

Line 2507: IEU_PVT.BIND_LAST_UPDATED_BY_LIST.delete;

2503: IEU_PVT.NODE_DEPTH_LIST.delete;
2504:
2505: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.delete;
2506:
2507: IEU_PVT.BIND_LAST_UPDATED_BY_LIST.delete;
2508: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST.delete;
2509: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST.delete;
2510: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST.delete;
2511: IEU_PVT.BIND_RESOURCE_ID_LIST.delete;

Line 2508: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST.delete;

2504:
2505: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.delete;
2506:
2507: IEU_PVT.BIND_LAST_UPDATED_BY_LIST.delete;
2508: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST.delete;
2509: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST.delete;
2510: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST.delete;
2511: IEU_PVT.BIND_RESOURCE_ID_LIST.delete;
2512: IEU_PVT.BIND_NODE_ID_LIST.delete;

Line 2509: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST.delete;

2505: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST.delete;
2506:
2507: IEU_PVT.BIND_LAST_UPDATED_BY_LIST.delete;
2508: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST.delete;
2509: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST.delete;
2510: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST.delete;
2511: IEU_PVT.BIND_RESOURCE_ID_LIST.delete;
2512: IEU_PVT.BIND_NODE_ID_LIST.delete;
2513: IEU_PVT.BIND_VAR_NAME_LIST.delete;

Line 2510: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST.delete;

2506:
2507: IEU_PVT.BIND_LAST_UPDATED_BY_LIST.delete;
2508: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST.delete;
2509: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST.delete;
2510: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST.delete;
2511: IEU_PVT.BIND_RESOURCE_ID_LIST.delete;
2512: IEU_PVT.BIND_NODE_ID_LIST.delete;
2513: IEU_PVT.BIND_VAR_NAME_LIST.delete;
2514: IEU_PVT.BIND_VAR_VALUE_LIST.delete;

Line 2511: IEU_PVT.BIND_RESOURCE_ID_LIST.delete;

2507: IEU_PVT.BIND_LAST_UPDATED_BY_LIST.delete;
2508: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST.delete;
2509: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST.delete;
2510: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST.delete;
2511: IEU_PVT.BIND_RESOURCE_ID_LIST.delete;
2512: IEU_PVT.BIND_NODE_ID_LIST.delete;
2513: IEU_PVT.BIND_VAR_NAME_LIST.delete;
2514: IEU_PVT.BIND_VAR_VALUE_LIST.delete;
2515: IEU_PVT.BIND_VAR_DATATYPE_LIST.delete;

Line 2512: IEU_PVT.BIND_NODE_ID_LIST.delete;

2508: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST.delete;
2509: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST.delete;
2510: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST.delete;
2511: IEU_PVT.BIND_RESOURCE_ID_LIST.delete;
2512: IEU_PVT.BIND_NODE_ID_LIST.delete;
2513: IEU_PVT.BIND_VAR_NAME_LIST.delete;
2514: IEU_PVT.BIND_VAR_VALUE_LIST.delete;
2515: IEU_PVT.BIND_VAR_DATATYPE_LIST.delete;
2516: IEU_PVT.NOT_VALID_FLAG_LIST.delete;

Line 2513: IEU_PVT.BIND_VAR_NAME_LIST.delete;

2509: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST.delete;
2510: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST.delete;
2511: IEU_PVT.BIND_RESOURCE_ID_LIST.delete;
2512: IEU_PVT.BIND_NODE_ID_LIST.delete;
2513: IEU_PVT.BIND_VAR_NAME_LIST.delete;
2514: IEU_PVT.BIND_VAR_VALUE_LIST.delete;
2515: IEU_PVT.BIND_VAR_DATATYPE_LIST.delete;
2516: IEU_PVT.NOT_VALID_FLAG_LIST.delete;
2517:

Line 2514: IEU_PVT.BIND_VAR_VALUE_LIST.delete;

2510: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST.delete;
2511: IEU_PVT.BIND_RESOURCE_ID_LIST.delete;
2512: IEU_PVT.BIND_NODE_ID_LIST.delete;
2513: IEU_PVT.BIND_VAR_NAME_LIST.delete;
2514: IEU_PVT.BIND_VAR_VALUE_LIST.delete;
2515: IEU_PVT.BIND_VAR_DATATYPE_LIST.delete;
2516: IEU_PVT.NOT_VALID_FLAG_LIST.delete;
2517:
2518: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.delete;

Line 2515: IEU_PVT.BIND_VAR_DATATYPE_LIST.delete;

2511: IEU_PVT.BIND_RESOURCE_ID_LIST.delete;
2512: IEU_PVT.BIND_NODE_ID_LIST.delete;
2513: IEU_PVT.BIND_VAR_NAME_LIST.delete;
2514: IEU_PVT.BIND_VAR_VALUE_LIST.delete;
2515: IEU_PVT.BIND_VAR_DATATYPE_LIST.delete;
2516: IEU_PVT.NOT_VALID_FLAG_LIST.delete;
2517:
2518: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.delete;
2519:

Line 2516: IEU_PVT.NOT_VALID_FLAG_LIST.delete;

2512: IEU_PVT.BIND_NODE_ID_LIST.delete;
2513: IEU_PVT.BIND_VAR_NAME_LIST.delete;
2514: IEU_PVT.BIND_VAR_VALUE_LIST.delete;
2515: IEU_PVT.BIND_VAR_DATATYPE_LIST.delete;
2516: IEU_PVT.NOT_VALID_FLAG_LIST.delete;
2517:
2518: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.delete;
2519:
2520: RAISE;

Line 2518: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.delete;

2514: IEU_PVT.BIND_VAR_VALUE_LIST.delete;
2515: IEU_PVT.BIND_VAR_DATATYPE_LIST.delete;
2516: IEU_PVT.NOT_VALID_FLAG_LIST.delete;
2517:
2518: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST.delete;
2519:
2520: RAISE;
2521: END;
2522:

Line 2626: IEU_PVT.LAST_UPDATED_BY_LIST(i) := FND_GLOBAL.USER_ID;

2622: SELECT IEU_UWQ_SEL_RT_NODES_S1.NEXTVAL INTO L_SEL_RT_NODE_ID FROM DUAL;
2623: L_RTNODE_INSERT_FLAG := 'Y';
2624: END;
2625: IF NVL(L_RTNODE_INSERT_FLAG, 'X') = 'N' THEN
2626: IEU_PVT.LAST_UPDATED_BY_LIST(i) := FND_GLOBAL.USER_ID;
2627: IEU_PVT.LAST_UPDATE_DATE_LIST(i) := sysdate;
2628: IEU_PVT.LAST_UPDATE_LOGIN_LIST(i) := FND_GLOBAL.LOGIN_ID;
2629: IEU_PVT.RESOURCE_ID_LIST(i) := P_RESOURCE_ID;
2630: IEU_PVT.SEL_ENUM_ID_LIST(i) := P_S_ENUM_ID;

Line 2627: IEU_PVT.LAST_UPDATE_DATE_LIST(i) := sysdate;

2623: L_RTNODE_INSERT_FLAG := 'Y';
2624: END;
2625: IF NVL(L_RTNODE_INSERT_FLAG, 'X') = 'N' THEN
2626: IEU_PVT.LAST_UPDATED_BY_LIST(i) := FND_GLOBAL.USER_ID;
2627: IEU_PVT.LAST_UPDATE_DATE_LIST(i) := sysdate;
2628: IEU_PVT.LAST_UPDATE_LOGIN_LIST(i) := FND_GLOBAL.LOGIN_ID;
2629: IEU_PVT.RESOURCE_ID_LIST(i) := P_RESOURCE_ID;
2630: IEU_PVT.SEL_ENUM_ID_LIST(i) := P_S_ENUM_ID;
2631: IEU_PVT.NODE_ID_LIST(i) := l_curr_node_id;

Line 2628: IEU_PVT.LAST_UPDATE_LOGIN_LIST(i) := FND_GLOBAL.LOGIN_ID;

2624: END;
2625: IF NVL(L_RTNODE_INSERT_FLAG, 'X') = 'N' THEN
2626: IEU_PVT.LAST_UPDATED_BY_LIST(i) := FND_GLOBAL.USER_ID;
2627: IEU_PVT.LAST_UPDATE_DATE_LIST(i) := sysdate;
2628: IEU_PVT.LAST_UPDATE_LOGIN_LIST(i) := FND_GLOBAL.LOGIN_ID;
2629: IEU_PVT.RESOURCE_ID_LIST(i) := P_RESOURCE_ID;
2630: IEU_PVT.SEL_ENUM_ID_LIST(i) := P_S_ENUM_ID;
2631: IEU_PVT.NODE_ID_LIST(i) := l_curr_node_id;
2632: IEU_PVT.NODE_TYPE_LIST(i) := P_ENUM_REC_LIST(i).NODE_TYPE;

Line 2629: IEU_PVT.RESOURCE_ID_LIST(i) := P_RESOURCE_ID;

2625: IF NVL(L_RTNODE_INSERT_FLAG, 'X') = 'N' THEN
2626: IEU_PVT.LAST_UPDATED_BY_LIST(i) := FND_GLOBAL.USER_ID;
2627: IEU_PVT.LAST_UPDATE_DATE_LIST(i) := sysdate;
2628: IEU_PVT.LAST_UPDATE_LOGIN_LIST(i) := FND_GLOBAL.LOGIN_ID;
2629: IEU_PVT.RESOURCE_ID_LIST(i) := P_RESOURCE_ID;
2630: IEU_PVT.SEL_ENUM_ID_LIST(i) := P_S_ENUM_ID;
2631: IEU_PVT.NODE_ID_LIST(i) := l_curr_node_id;
2632: IEU_PVT.NODE_TYPE_LIST(i) := P_ENUM_REC_LIST(i).NODE_TYPE;
2633: IEU_PVT.NODE_LABEL_LIST(i) := P_ENUM_REC_LIST(i).NODE_LABEL;

Line 2630: IEU_PVT.SEL_ENUM_ID_LIST(i) := P_S_ENUM_ID;

2626: IEU_PVT.LAST_UPDATED_BY_LIST(i) := FND_GLOBAL.USER_ID;
2627: IEU_PVT.LAST_UPDATE_DATE_LIST(i) := sysdate;
2628: IEU_PVT.LAST_UPDATE_LOGIN_LIST(i) := FND_GLOBAL.LOGIN_ID;
2629: IEU_PVT.RESOURCE_ID_LIST(i) := P_RESOURCE_ID;
2630: IEU_PVT.SEL_ENUM_ID_LIST(i) := P_S_ENUM_ID;
2631: IEU_PVT.NODE_ID_LIST(i) := l_curr_node_id;
2632: IEU_PVT.NODE_TYPE_LIST(i) := P_ENUM_REC_LIST(i).NODE_TYPE;
2633: IEU_PVT.NODE_LABEL_LIST(i) := P_ENUM_REC_LIST(i).NODE_LABEL;
2634: IEU_PVT.COUNT_LIST(i) := null;

Line 2631: IEU_PVT.NODE_ID_LIST(i) := l_curr_node_id;

2627: IEU_PVT.LAST_UPDATE_DATE_LIST(i) := sysdate;
2628: IEU_PVT.LAST_UPDATE_LOGIN_LIST(i) := FND_GLOBAL.LOGIN_ID;
2629: IEU_PVT.RESOURCE_ID_LIST(i) := P_RESOURCE_ID;
2630: IEU_PVT.SEL_ENUM_ID_LIST(i) := P_S_ENUM_ID;
2631: IEU_PVT.NODE_ID_LIST(i) := l_curr_node_id;
2632: IEU_PVT.NODE_TYPE_LIST(i) := P_ENUM_REC_LIST(i).NODE_TYPE;
2633: IEU_PVT.NODE_LABEL_LIST(i) := P_ENUM_REC_LIST(i).NODE_LABEL;
2634: IEU_PVT.COUNT_LIST(i) := null;
2635: IEU_PVT.DATA_SOURCE_LIST(i) := P_ENUM_REC_LIST(i).DATA_SOURCE;

Line 2632: IEU_PVT.NODE_TYPE_LIST(i) := P_ENUM_REC_LIST(i).NODE_TYPE;

2628: IEU_PVT.LAST_UPDATE_LOGIN_LIST(i) := FND_GLOBAL.LOGIN_ID;
2629: IEU_PVT.RESOURCE_ID_LIST(i) := P_RESOURCE_ID;
2630: IEU_PVT.SEL_ENUM_ID_LIST(i) := P_S_ENUM_ID;
2631: IEU_PVT.NODE_ID_LIST(i) := l_curr_node_id;
2632: IEU_PVT.NODE_TYPE_LIST(i) := P_ENUM_REC_LIST(i).NODE_TYPE;
2633: IEU_PVT.NODE_LABEL_LIST(i) := P_ENUM_REC_LIST(i).NODE_LABEL;
2634: IEU_PVT.COUNT_LIST(i) := null;
2635: IEU_PVT.DATA_SOURCE_LIST(i) := P_ENUM_REC_LIST(i).DATA_SOURCE;
2636: IEU_PVT.VIEW_NAME_LIST(i) := P_ENUM_REC_LIST(i).VIEW_NAME;

Line 2633: IEU_PVT.NODE_LABEL_LIST(i) := P_ENUM_REC_LIST(i).NODE_LABEL;

2629: IEU_PVT.RESOURCE_ID_LIST(i) := P_RESOURCE_ID;
2630: IEU_PVT.SEL_ENUM_ID_LIST(i) := P_S_ENUM_ID;
2631: IEU_PVT.NODE_ID_LIST(i) := l_curr_node_id;
2632: IEU_PVT.NODE_TYPE_LIST(i) := P_ENUM_REC_LIST(i).NODE_TYPE;
2633: IEU_PVT.NODE_LABEL_LIST(i) := P_ENUM_REC_LIST(i).NODE_LABEL;
2634: IEU_PVT.COUNT_LIST(i) := null;
2635: IEU_PVT.DATA_SOURCE_LIST(i) := P_ENUM_REC_LIST(i).DATA_SOURCE;
2636: IEU_PVT.VIEW_NAME_LIST(i) := P_ENUM_REC_LIST(i).VIEW_NAME;
2637: IEU_PVT.MEDIA_TYPE_ID_LIST(i) := P_ENUM_REC_LIST(i).MEDIA_TYPE_ID;

Line 2634: IEU_PVT.COUNT_LIST(i) := null;

2630: IEU_PVT.SEL_ENUM_ID_LIST(i) := P_S_ENUM_ID;
2631: IEU_PVT.NODE_ID_LIST(i) := l_curr_node_id;
2632: IEU_PVT.NODE_TYPE_LIST(i) := P_ENUM_REC_LIST(i).NODE_TYPE;
2633: IEU_PVT.NODE_LABEL_LIST(i) := P_ENUM_REC_LIST(i).NODE_LABEL;
2634: IEU_PVT.COUNT_LIST(i) := null;
2635: IEU_PVT.DATA_SOURCE_LIST(i) := P_ENUM_REC_LIST(i).DATA_SOURCE;
2636: IEU_PVT.VIEW_NAME_LIST(i) := P_ENUM_REC_LIST(i).VIEW_NAME;
2637: IEU_PVT.MEDIA_TYPE_ID_LIST(i) := P_ENUM_REC_LIST(i).MEDIA_TYPE_ID;
2638: IEU_PVT.SEL_ENUM_PID_LIST(i) := null;

Line 2635: IEU_PVT.DATA_SOURCE_LIST(i) := P_ENUM_REC_LIST(i).DATA_SOURCE;

2631: IEU_PVT.NODE_ID_LIST(i) := l_curr_node_id;
2632: IEU_PVT.NODE_TYPE_LIST(i) := P_ENUM_REC_LIST(i).NODE_TYPE;
2633: IEU_PVT.NODE_LABEL_LIST(i) := P_ENUM_REC_LIST(i).NODE_LABEL;
2634: IEU_PVT.COUNT_LIST(i) := null;
2635: IEU_PVT.DATA_SOURCE_LIST(i) := P_ENUM_REC_LIST(i).DATA_SOURCE;
2636: IEU_PVT.VIEW_NAME_LIST(i) := P_ENUM_REC_LIST(i).VIEW_NAME;
2637: IEU_PVT.MEDIA_TYPE_ID_LIST(i) := P_ENUM_REC_LIST(i).MEDIA_TYPE_ID;
2638: IEU_PVT.SEL_ENUM_PID_LIST(i) := null;
2639: IEU_PVT.NODE_PID_LIST(i) := p_pid;

Line 2636: IEU_PVT.VIEW_NAME_LIST(i) := P_ENUM_REC_LIST(i).VIEW_NAME;

2632: IEU_PVT.NODE_TYPE_LIST(i) := P_ENUM_REC_LIST(i).NODE_TYPE;
2633: IEU_PVT.NODE_LABEL_LIST(i) := P_ENUM_REC_LIST(i).NODE_LABEL;
2634: IEU_PVT.COUNT_LIST(i) := null;
2635: IEU_PVT.DATA_SOURCE_LIST(i) := P_ENUM_REC_LIST(i).DATA_SOURCE;
2636: IEU_PVT.VIEW_NAME_LIST(i) := P_ENUM_REC_LIST(i).VIEW_NAME;
2637: IEU_PVT.MEDIA_TYPE_ID_LIST(i) := P_ENUM_REC_LIST(i).MEDIA_TYPE_ID;
2638: IEU_PVT.SEL_ENUM_PID_LIST(i) := null;
2639: IEU_PVT.NODE_PID_LIST(i) := p_pid;
2640: IEU_PVT.NODE_WEIGHT_LIST(i) := l_curr_node_id;

Line 2637: IEU_PVT.MEDIA_TYPE_ID_LIST(i) := P_ENUM_REC_LIST(i).MEDIA_TYPE_ID;

2633: IEU_PVT.NODE_LABEL_LIST(i) := P_ENUM_REC_LIST(i).NODE_LABEL;
2634: IEU_PVT.COUNT_LIST(i) := null;
2635: IEU_PVT.DATA_SOURCE_LIST(i) := P_ENUM_REC_LIST(i).DATA_SOURCE;
2636: IEU_PVT.VIEW_NAME_LIST(i) := P_ENUM_REC_LIST(i).VIEW_NAME;
2637: IEU_PVT.MEDIA_TYPE_ID_LIST(i) := P_ENUM_REC_LIST(i).MEDIA_TYPE_ID;
2638: IEU_PVT.SEL_ENUM_PID_LIST(i) := null;
2639: IEU_PVT.NODE_PID_LIST(i) := p_pid;
2640: IEU_PVT.NODE_WEIGHT_LIST(i) := l_curr_node_id;
2641: IEU_PVT.WHERE_CLAUSE_LIST(i) := P_ENUM_REC_LIST(i).WHERE_CLAUSE;

Line 2638: IEU_PVT.SEL_ENUM_PID_LIST(i) := null;

2634: IEU_PVT.COUNT_LIST(i) := null;
2635: IEU_PVT.DATA_SOURCE_LIST(i) := P_ENUM_REC_LIST(i).DATA_SOURCE;
2636: IEU_PVT.VIEW_NAME_LIST(i) := P_ENUM_REC_LIST(i).VIEW_NAME;
2637: IEU_PVT.MEDIA_TYPE_ID_LIST(i) := P_ENUM_REC_LIST(i).MEDIA_TYPE_ID;
2638: IEU_PVT.SEL_ENUM_PID_LIST(i) := null;
2639: IEU_PVT.NODE_PID_LIST(i) := p_pid;
2640: IEU_PVT.NODE_WEIGHT_LIST(i) := l_curr_node_id;
2641: IEU_PVT.WHERE_CLAUSE_LIST(i) := P_ENUM_REC_LIST(i).WHERE_CLAUSE;
2642: IEU_PVT.HIDE_IF_EMPTY_LIST(i) := P_ENUM_REC_LIST(i).HIDE_IF_EMPTY;

Line 2639: IEU_PVT.NODE_PID_LIST(i) := p_pid;

2635: IEU_PVT.DATA_SOURCE_LIST(i) := P_ENUM_REC_LIST(i).DATA_SOURCE;
2636: IEU_PVT.VIEW_NAME_LIST(i) := P_ENUM_REC_LIST(i).VIEW_NAME;
2637: IEU_PVT.MEDIA_TYPE_ID_LIST(i) := P_ENUM_REC_LIST(i).MEDIA_TYPE_ID;
2638: IEU_PVT.SEL_ENUM_PID_LIST(i) := null;
2639: IEU_PVT.NODE_PID_LIST(i) := p_pid;
2640: IEU_PVT.NODE_WEIGHT_LIST(i) := l_curr_node_id;
2641: IEU_PVT.WHERE_CLAUSE_LIST(i) := P_ENUM_REC_LIST(i).WHERE_CLAUSE;
2642: IEU_PVT.HIDE_IF_EMPTY_LIST(i) := P_ENUM_REC_LIST(i).HIDE_IF_EMPTY;
2643: IEU_PVT.NOT_VALID_LIST(i) := L_NOT_VALID_FLAG;

Line 2640: IEU_PVT.NODE_WEIGHT_LIST(i) := l_curr_node_id;

2636: IEU_PVT.VIEW_NAME_LIST(i) := P_ENUM_REC_LIST(i).VIEW_NAME;
2637: IEU_PVT.MEDIA_TYPE_ID_LIST(i) := P_ENUM_REC_LIST(i).MEDIA_TYPE_ID;
2638: IEU_PVT.SEL_ENUM_PID_LIST(i) := null;
2639: IEU_PVT.NODE_PID_LIST(i) := p_pid;
2640: IEU_PVT.NODE_WEIGHT_LIST(i) := l_curr_node_id;
2641: IEU_PVT.WHERE_CLAUSE_LIST(i) := P_ENUM_REC_LIST(i).WHERE_CLAUSE;
2642: IEU_PVT.HIDE_IF_EMPTY_LIST(i) := P_ENUM_REC_LIST(i).HIDE_IF_EMPTY;
2643: IEU_PVT.NOT_VALID_LIST(i) := L_NOT_VALID_FLAG;
2644: IEU_PVT.REFRESH_VIEW_NAME_LIST(i) := P_ENUM_REC_LIST(i).REFRESH_VIEW_NAME;

Line 2641: IEU_PVT.WHERE_CLAUSE_LIST(i) := P_ENUM_REC_LIST(i).WHERE_CLAUSE;

2637: IEU_PVT.MEDIA_TYPE_ID_LIST(i) := P_ENUM_REC_LIST(i).MEDIA_TYPE_ID;
2638: IEU_PVT.SEL_ENUM_PID_LIST(i) := null;
2639: IEU_PVT.NODE_PID_LIST(i) := p_pid;
2640: IEU_PVT.NODE_WEIGHT_LIST(i) := l_curr_node_id;
2641: IEU_PVT.WHERE_CLAUSE_LIST(i) := P_ENUM_REC_LIST(i).WHERE_CLAUSE;
2642: IEU_PVT.HIDE_IF_EMPTY_LIST(i) := P_ENUM_REC_LIST(i).HIDE_IF_EMPTY;
2643: IEU_PVT.NOT_VALID_LIST(i) := L_NOT_VALID_FLAG;
2644: IEU_PVT.REFRESH_VIEW_NAME_LIST(i) := P_ENUM_REC_LIST(i).REFRESH_VIEW_NAME;
2645: IEU_PVT.RES_CAT_ENUM_FLAG_LIST(i) := P_ENUM_REC_LIST(i).RES_CAT_ENUM_FLAG;

Line 2642: IEU_PVT.HIDE_IF_EMPTY_LIST(i) := P_ENUM_REC_LIST(i).HIDE_IF_EMPTY;

2638: IEU_PVT.SEL_ENUM_PID_LIST(i) := null;
2639: IEU_PVT.NODE_PID_LIST(i) := p_pid;
2640: IEU_PVT.NODE_WEIGHT_LIST(i) := l_curr_node_id;
2641: IEU_PVT.WHERE_CLAUSE_LIST(i) := P_ENUM_REC_LIST(i).WHERE_CLAUSE;
2642: IEU_PVT.HIDE_IF_EMPTY_LIST(i) := P_ENUM_REC_LIST(i).HIDE_IF_EMPTY;
2643: IEU_PVT.NOT_VALID_LIST(i) := L_NOT_VALID_FLAG;
2644: IEU_PVT.REFRESH_VIEW_NAME_LIST(i) := P_ENUM_REC_LIST(i).REFRESH_VIEW_NAME;
2645: IEU_PVT.RES_CAT_ENUM_FLAG_LIST(i) := P_ENUM_REC_LIST(i).RES_CAT_ENUM_FLAG;
2646: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST(i) := P_ENUM_REC_LIST(i).REFRESH_VIEW_SUM_COL;

Line 2643: IEU_PVT.NOT_VALID_LIST(i) := L_NOT_VALID_FLAG;

2639: IEU_PVT.NODE_PID_LIST(i) := p_pid;
2640: IEU_PVT.NODE_WEIGHT_LIST(i) := l_curr_node_id;
2641: IEU_PVT.WHERE_CLAUSE_LIST(i) := P_ENUM_REC_LIST(i).WHERE_CLAUSE;
2642: IEU_PVT.HIDE_IF_EMPTY_LIST(i) := P_ENUM_REC_LIST(i).HIDE_IF_EMPTY;
2643: IEU_PVT.NOT_VALID_LIST(i) := L_NOT_VALID_FLAG;
2644: IEU_PVT.REFRESH_VIEW_NAME_LIST(i) := P_ENUM_REC_LIST(i).REFRESH_VIEW_NAME;
2645: IEU_PVT.RES_CAT_ENUM_FLAG_LIST(i) := P_ENUM_REC_LIST(i).RES_CAT_ENUM_FLAG;
2646: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST(i) := P_ENUM_REC_LIST(i).REFRESH_VIEW_SUM_COL;
2647: IEU_PVT.NODE_DEPTH_LIST(i) := P_ENUM_REC_LIST(i).NODE_DEPTH;

Line 2644: IEU_PVT.REFRESH_VIEW_NAME_LIST(i) := P_ENUM_REC_LIST(i).REFRESH_VIEW_NAME;

2640: IEU_PVT.NODE_WEIGHT_LIST(i) := l_curr_node_id;
2641: IEU_PVT.WHERE_CLAUSE_LIST(i) := P_ENUM_REC_LIST(i).WHERE_CLAUSE;
2642: IEU_PVT.HIDE_IF_EMPTY_LIST(i) := P_ENUM_REC_LIST(i).HIDE_IF_EMPTY;
2643: IEU_PVT.NOT_VALID_LIST(i) := L_NOT_VALID_FLAG;
2644: IEU_PVT.REFRESH_VIEW_NAME_LIST(i) := P_ENUM_REC_LIST(i).REFRESH_VIEW_NAME;
2645: IEU_PVT.RES_CAT_ENUM_FLAG_LIST(i) := P_ENUM_REC_LIST(i).RES_CAT_ENUM_FLAG;
2646: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST(i) := P_ENUM_REC_LIST(i).REFRESH_VIEW_SUM_COL;
2647: IEU_PVT.NODE_DEPTH_LIST(i) := P_ENUM_REC_LIST(i).NODE_DEPTH;
2648: ELSE

Line 2645: IEU_PVT.RES_CAT_ENUM_FLAG_LIST(i) := P_ENUM_REC_LIST(i).RES_CAT_ENUM_FLAG;

2641: IEU_PVT.WHERE_CLAUSE_LIST(i) := P_ENUM_REC_LIST(i).WHERE_CLAUSE;
2642: IEU_PVT.HIDE_IF_EMPTY_LIST(i) := P_ENUM_REC_LIST(i).HIDE_IF_EMPTY;
2643: IEU_PVT.NOT_VALID_LIST(i) := L_NOT_VALID_FLAG;
2644: IEU_PVT.REFRESH_VIEW_NAME_LIST(i) := P_ENUM_REC_LIST(i).REFRESH_VIEW_NAME;
2645: IEU_PVT.RES_CAT_ENUM_FLAG_LIST(i) := P_ENUM_REC_LIST(i).RES_CAT_ENUM_FLAG;
2646: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST(i) := P_ENUM_REC_LIST(i).REFRESH_VIEW_SUM_COL;
2647: IEU_PVT.NODE_DEPTH_LIST(i) := P_ENUM_REC_LIST(i).NODE_DEPTH;
2648: ELSE
2649: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;

Line 2646: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST(i) := P_ENUM_REC_LIST(i).REFRESH_VIEW_SUM_COL;

2642: IEU_PVT.HIDE_IF_EMPTY_LIST(i) := P_ENUM_REC_LIST(i).HIDE_IF_EMPTY;
2643: IEU_PVT.NOT_VALID_LIST(i) := L_NOT_VALID_FLAG;
2644: IEU_PVT.REFRESH_VIEW_NAME_LIST(i) := P_ENUM_REC_LIST(i).REFRESH_VIEW_NAME;
2645: IEU_PVT.RES_CAT_ENUM_FLAG_LIST(i) := P_ENUM_REC_LIST(i).RES_CAT_ENUM_FLAG;
2646: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST(i) := P_ENUM_REC_LIST(i).REFRESH_VIEW_SUM_COL;
2647: IEU_PVT.NODE_DEPTH_LIST(i) := P_ENUM_REC_LIST(i).NODE_DEPTH;
2648: ELSE
2649: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2650: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATED_BY := FND_GLOBAL.USER_ID;

Line 2647: IEU_PVT.NODE_DEPTH_LIST(i) := P_ENUM_REC_LIST(i).NODE_DEPTH;

2643: IEU_PVT.NOT_VALID_LIST(i) := L_NOT_VALID_FLAG;
2644: IEU_PVT.REFRESH_VIEW_NAME_LIST(i) := P_ENUM_REC_LIST(i).REFRESH_VIEW_NAME;
2645: IEU_PVT.RES_CAT_ENUM_FLAG_LIST(i) := P_ENUM_REC_LIST(i).RES_CAT_ENUM_FLAG;
2646: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST(i) := P_ENUM_REC_LIST(i).REFRESH_VIEW_SUM_COL;
2647: IEU_PVT.NODE_DEPTH_LIST(i) := P_ENUM_REC_LIST(i).NODE_DEPTH;
2648: ELSE
2649: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2650: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2651: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATION_DATE := sysdate;

Line 2649: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;

2645: IEU_PVT.RES_CAT_ENUM_FLAG_LIST(i) := P_ENUM_REC_LIST(i).RES_CAT_ENUM_FLAG;
2646: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST(i) := P_ENUM_REC_LIST(i).REFRESH_VIEW_SUM_COL;
2647: IEU_PVT.NODE_DEPTH_LIST(i) := P_ENUM_REC_LIST(i).NODE_DEPTH;
2648: ELSE
2649: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2650: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2651: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATION_DATE := sysdate;
2652: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2653: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_DATE := sysdate;

Line 2650: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATED_BY := FND_GLOBAL.USER_ID;

2646: IEU_PVT.REFRESH_VIEW_SUM_COL_LIST(i) := P_ENUM_REC_LIST(i).REFRESH_VIEW_SUM_COL;
2647: IEU_PVT.NODE_DEPTH_LIST(i) := P_ENUM_REC_LIST(i).NODE_DEPTH;
2648: ELSE
2649: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2650: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2651: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATION_DATE := sysdate;
2652: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2653: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_DATE := sysdate;
2654: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line 2651: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATION_DATE := sysdate;

2647: IEU_PVT.NODE_DEPTH_LIST(i) := P_ENUM_REC_LIST(i).NODE_DEPTH;
2648: ELSE
2649: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2650: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2651: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATION_DATE := sysdate;
2652: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2653: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_DATE := sysdate;
2654: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2655: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).RESOURCE_ID := P_RESOURCE_ID;

Line 2652: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2648: ELSE
2649: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2650: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2651: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATION_DATE := sysdate;
2652: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2653: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_DATE := sysdate;
2654: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2655: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).RESOURCE_ID := P_RESOURCE_ID;
2656: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_ID := P_S_ENUM_ID;

Line 2653: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_DATE := sysdate;

2649: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2650: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2651: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATION_DATE := sysdate;
2652: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2653: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_DATE := sysdate;
2654: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2655: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).RESOURCE_ID := P_RESOURCE_ID;
2656: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_ID := P_S_ENUM_ID;
2657: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_ID := l_curr_node_id;

Line 2654: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2650: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2651: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATION_DATE := sysdate;
2652: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2653: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_DATE := sysdate;
2654: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2655: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).RESOURCE_ID := P_RESOURCE_ID;
2656: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_ID := P_S_ENUM_ID;
2657: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_ID := l_curr_node_id;
2658: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_TYPE := P_ENUM_REC_LIST(i).NODE_TYPE;

Line 2655: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).RESOURCE_ID := P_RESOURCE_ID;

2651: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).CREATION_DATE := sysdate;
2652: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2653: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_DATE := sysdate;
2654: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2655: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).RESOURCE_ID := P_RESOURCE_ID;
2656: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_ID := P_S_ENUM_ID;
2657: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_ID := l_curr_node_id;
2658: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_TYPE := P_ENUM_REC_LIST(i).NODE_TYPE;
2659: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_LABEL := P_ENUM_REC_LIST(i).NODE_LABEL;

Line 2656: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_ID := P_S_ENUM_ID;

2652: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2653: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_DATE := sysdate;
2654: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2655: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).RESOURCE_ID := P_RESOURCE_ID;
2656: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_ID := P_S_ENUM_ID;
2657: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_ID := l_curr_node_id;
2658: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_TYPE := P_ENUM_REC_LIST(i).NODE_TYPE;
2659: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_LABEL := P_ENUM_REC_LIST(i).NODE_LABEL;
2660: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).COUNT := null;

Line 2657: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_ID := l_curr_node_id;

2653: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_DATE := sysdate;
2654: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2655: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).RESOURCE_ID := P_RESOURCE_ID;
2656: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_ID := P_S_ENUM_ID;
2657: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_ID := l_curr_node_id;
2658: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_TYPE := P_ENUM_REC_LIST(i).NODE_TYPE;
2659: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_LABEL := P_ENUM_REC_LIST(i).NODE_LABEL;
2660: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).COUNT := null;
2661: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).DATA_SOURCE := P_ENUM_REC_LIST(i).DATA_SOURCE;

Line 2658: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_TYPE := P_ENUM_REC_LIST(i).NODE_TYPE;

2654: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2655: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).RESOURCE_ID := P_RESOURCE_ID;
2656: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_ID := P_S_ENUM_ID;
2657: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_ID := l_curr_node_id;
2658: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_TYPE := P_ENUM_REC_LIST(i).NODE_TYPE;
2659: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_LABEL := P_ENUM_REC_LIST(i).NODE_LABEL;
2660: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).COUNT := null;
2661: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).DATA_SOURCE := P_ENUM_REC_LIST(i).DATA_SOURCE;
2662: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).VIEW_NAME := P_ENUM_REC_LIST(i).VIEW_NAME;

Line 2659: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_LABEL := P_ENUM_REC_LIST(i).NODE_LABEL;

2655: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).RESOURCE_ID := P_RESOURCE_ID;
2656: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_ID := P_S_ENUM_ID;
2657: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_ID := l_curr_node_id;
2658: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_TYPE := P_ENUM_REC_LIST(i).NODE_TYPE;
2659: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_LABEL := P_ENUM_REC_LIST(i).NODE_LABEL;
2660: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).COUNT := null;
2661: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).DATA_SOURCE := P_ENUM_REC_LIST(i).DATA_SOURCE;
2662: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).VIEW_NAME := P_ENUM_REC_LIST(i).VIEW_NAME;
2663: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).MEDIA_TYPE_ID := P_ENUM_REC_LIST(i).MEDIA_TYPE_ID;

Line 2660: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).COUNT := null;

2656: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_ID := P_S_ENUM_ID;
2657: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_ID := l_curr_node_id;
2658: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_TYPE := P_ENUM_REC_LIST(i).NODE_TYPE;
2659: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_LABEL := P_ENUM_REC_LIST(i).NODE_LABEL;
2660: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).COUNT := null;
2661: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).DATA_SOURCE := P_ENUM_REC_LIST(i).DATA_SOURCE;
2662: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).VIEW_NAME := P_ENUM_REC_LIST(i).VIEW_NAME;
2663: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).MEDIA_TYPE_ID := P_ENUM_REC_LIST(i).MEDIA_TYPE_ID;
2664: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_PID := null;

Line 2661: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).DATA_SOURCE := P_ENUM_REC_LIST(i).DATA_SOURCE;

2657: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_ID := l_curr_node_id;
2658: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_TYPE := P_ENUM_REC_LIST(i).NODE_TYPE;
2659: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_LABEL := P_ENUM_REC_LIST(i).NODE_LABEL;
2660: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).COUNT := null;
2661: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).DATA_SOURCE := P_ENUM_REC_LIST(i).DATA_SOURCE;
2662: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).VIEW_NAME := P_ENUM_REC_LIST(i).VIEW_NAME;
2663: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).MEDIA_TYPE_ID := P_ENUM_REC_LIST(i).MEDIA_TYPE_ID;
2664: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_PID := null;
2665: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_PID := p_pid;

Line 2662: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).VIEW_NAME := P_ENUM_REC_LIST(i).VIEW_NAME;

2658: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_TYPE := P_ENUM_REC_LIST(i).NODE_TYPE;
2659: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_LABEL := P_ENUM_REC_LIST(i).NODE_LABEL;
2660: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).COUNT := null;
2661: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).DATA_SOURCE := P_ENUM_REC_LIST(i).DATA_SOURCE;
2662: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).VIEW_NAME := P_ENUM_REC_LIST(i).VIEW_NAME;
2663: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).MEDIA_TYPE_ID := P_ENUM_REC_LIST(i).MEDIA_TYPE_ID;
2664: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_PID := null;
2665: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_PID := p_pid;
2666: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_WEIGHT := l_curr_node_id;

Line 2663: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).MEDIA_TYPE_ID := P_ENUM_REC_LIST(i).MEDIA_TYPE_ID;

2659: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_LABEL := P_ENUM_REC_LIST(i).NODE_LABEL;
2660: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).COUNT := null;
2661: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).DATA_SOURCE := P_ENUM_REC_LIST(i).DATA_SOURCE;
2662: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).VIEW_NAME := P_ENUM_REC_LIST(i).VIEW_NAME;
2663: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).MEDIA_TYPE_ID := P_ENUM_REC_LIST(i).MEDIA_TYPE_ID;
2664: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_PID := null;
2665: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_PID := p_pid;
2666: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_WEIGHT := l_curr_node_id;
2667: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).WHERE_CLAUSE := P_ENUM_REC_LIST(i).WHERE_CLAUSE;

Line 2664: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_PID := null;

2660: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).COUNT := null;
2661: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).DATA_SOURCE := P_ENUM_REC_LIST(i).DATA_SOURCE;
2662: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).VIEW_NAME := P_ENUM_REC_LIST(i).VIEW_NAME;
2663: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).MEDIA_TYPE_ID := P_ENUM_REC_LIST(i).MEDIA_TYPE_ID;
2664: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_PID := null;
2665: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_PID := p_pid;
2666: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_WEIGHT := l_curr_node_id;
2667: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).WHERE_CLAUSE := P_ENUM_REC_LIST(i).WHERE_CLAUSE;
2668: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).HIDE_IF_EMPTY := P_ENUM_REC_LIST(i).HIDE_IF_EMPTY;

Line 2665: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_PID := p_pid;

2661: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).DATA_SOURCE := P_ENUM_REC_LIST(i).DATA_SOURCE;
2662: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).VIEW_NAME := P_ENUM_REC_LIST(i).VIEW_NAME;
2663: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).MEDIA_TYPE_ID := P_ENUM_REC_LIST(i).MEDIA_TYPE_ID;
2664: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_PID := null;
2665: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_PID := p_pid;
2666: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_WEIGHT := l_curr_node_id;
2667: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).WHERE_CLAUSE := P_ENUM_REC_LIST(i).WHERE_CLAUSE;
2668: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).HIDE_IF_EMPTY := P_ENUM_REC_LIST(i).HIDE_IF_EMPTY;
2669: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NOT_VALID := L_NOT_VALID_FLAG;

Line 2666: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_WEIGHT := l_curr_node_id;

2662: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).VIEW_NAME := P_ENUM_REC_LIST(i).VIEW_NAME;
2663: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).MEDIA_TYPE_ID := P_ENUM_REC_LIST(i).MEDIA_TYPE_ID;
2664: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_PID := null;
2665: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_PID := p_pid;
2666: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_WEIGHT := l_curr_node_id;
2667: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).WHERE_CLAUSE := P_ENUM_REC_LIST(i).WHERE_CLAUSE;
2668: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).HIDE_IF_EMPTY := P_ENUM_REC_LIST(i).HIDE_IF_EMPTY;
2669: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NOT_VALID := L_NOT_VALID_FLAG;
2670: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SECURITY_GROUP_ID := null;

Line 2667: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).WHERE_CLAUSE := P_ENUM_REC_LIST(i).WHERE_CLAUSE;

2663: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).MEDIA_TYPE_ID := P_ENUM_REC_LIST(i).MEDIA_TYPE_ID;
2664: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_PID := null;
2665: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_PID := p_pid;
2666: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_WEIGHT := l_curr_node_id;
2667: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).WHERE_CLAUSE := P_ENUM_REC_LIST(i).WHERE_CLAUSE;
2668: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).HIDE_IF_EMPTY := P_ENUM_REC_LIST(i).HIDE_IF_EMPTY;
2669: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NOT_VALID := L_NOT_VALID_FLAG;
2670: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SECURITY_GROUP_ID := null;
2671: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;

Line 2668: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).HIDE_IF_EMPTY := P_ENUM_REC_LIST(i).HIDE_IF_EMPTY;

2664: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SEL_ENUM_PID := null;
2665: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_PID := p_pid;
2666: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_WEIGHT := l_curr_node_id;
2667: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).WHERE_CLAUSE := P_ENUM_REC_LIST(i).WHERE_CLAUSE;
2668: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).HIDE_IF_EMPTY := P_ENUM_REC_LIST(i).HIDE_IF_EMPTY;
2669: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NOT_VALID := L_NOT_VALID_FLAG;
2670: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SECURITY_GROUP_ID := null;
2671: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;
2672: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).REFRESH_VIEW_NAME := P_ENUM_REC_LIST(i).REFRESH_VIEW_NAME;

Line 2669: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NOT_VALID := L_NOT_VALID_FLAG;

2665: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_PID := p_pid;
2666: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_WEIGHT := l_curr_node_id;
2667: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).WHERE_CLAUSE := P_ENUM_REC_LIST(i).WHERE_CLAUSE;
2668: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).HIDE_IF_EMPTY := P_ENUM_REC_LIST(i).HIDE_IF_EMPTY;
2669: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NOT_VALID := L_NOT_VALID_FLAG;
2670: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SECURITY_GROUP_ID := null;
2671: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;
2672: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).REFRESH_VIEW_NAME := P_ENUM_REC_LIST(i).REFRESH_VIEW_NAME;
2673: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).RES_CAT_ENUM_FLAG := P_ENUM_REC_LIST(i).RES_CAT_ENUM_FLAG;

Line 2670: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SECURITY_GROUP_ID := null;

2666: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_WEIGHT := l_curr_node_id;
2667: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).WHERE_CLAUSE := P_ENUM_REC_LIST(i).WHERE_CLAUSE;
2668: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).HIDE_IF_EMPTY := P_ENUM_REC_LIST(i).HIDE_IF_EMPTY;
2669: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NOT_VALID := L_NOT_VALID_FLAG;
2670: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SECURITY_GROUP_ID := null;
2671: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;
2672: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).REFRESH_VIEW_NAME := P_ENUM_REC_LIST(i).REFRESH_VIEW_NAME;
2673: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).RES_CAT_ENUM_FLAG := P_ENUM_REC_LIST(i).RES_CAT_ENUM_FLAG;
2674: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).REFRESH_VIEW_SUM_COL := P_ENUM_REC_LIST(i).REFRESH_VIEW_SUM_COL;

Line 2671: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;

2667: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).WHERE_CLAUSE := P_ENUM_REC_LIST(i).WHERE_CLAUSE;
2668: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).HIDE_IF_EMPTY := P_ENUM_REC_LIST(i).HIDE_IF_EMPTY;
2669: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NOT_VALID := L_NOT_VALID_FLAG;
2670: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SECURITY_GROUP_ID := null;
2671: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;
2672: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).REFRESH_VIEW_NAME := P_ENUM_REC_LIST(i).REFRESH_VIEW_NAME;
2673: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).RES_CAT_ENUM_FLAG := P_ENUM_REC_LIST(i).RES_CAT_ENUM_FLAG;
2674: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).REFRESH_VIEW_SUM_COL := P_ENUM_REC_LIST(i).REFRESH_VIEW_SUM_COL;
2675: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_DEPTH := P_ENUM_REC_LIST(i).NODE_DEPTH;

Line 2672: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).REFRESH_VIEW_NAME := P_ENUM_REC_LIST(i).REFRESH_VIEW_NAME;

2668: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).HIDE_IF_EMPTY := P_ENUM_REC_LIST(i).HIDE_IF_EMPTY;
2669: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NOT_VALID := L_NOT_VALID_FLAG;
2670: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SECURITY_GROUP_ID := null;
2671: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;
2672: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).REFRESH_VIEW_NAME := P_ENUM_REC_LIST(i).REFRESH_VIEW_NAME;
2673: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).RES_CAT_ENUM_FLAG := P_ENUM_REC_LIST(i).RES_CAT_ENUM_FLAG;
2674: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).REFRESH_VIEW_SUM_COL := P_ENUM_REC_LIST(i).REFRESH_VIEW_SUM_COL;
2675: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_DEPTH := P_ENUM_REC_LIST(i).NODE_DEPTH;
2676: IEU_PVT.L_RT_NODES_ITR := IEU_PVT.L_RT_NODES_ITR + 1;

Line 2673: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).RES_CAT_ENUM_FLAG := P_ENUM_REC_LIST(i).RES_CAT_ENUM_FLAG;

2669: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NOT_VALID := L_NOT_VALID_FLAG;
2670: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SECURITY_GROUP_ID := null;
2671: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;
2672: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).REFRESH_VIEW_NAME := P_ENUM_REC_LIST(i).REFRESH_VIEW_NAME;
2673: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).RES_CAT_ENUM_FLAG := P_ENUM_REC_LIST(i).RES_CAT_ENUM_FLAG;
2674: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).REFRESH_VIEW_SUM_COL := P_ENUM_REC_LIST(i).REFRESH_VIEW_SUM_COL;
2675: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_DEPTH := P_ENUM_REC_LIST(i).NODE_DEPTH;
2676: IEU_PVT.L_RT_NODES_ITR := IEU_PVT.L_RT_NODES_ITR + 1;
2677: END IF;

Line 2674: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).REFRESH_VIEW_SUM_COL := P_ENUM_REC_LIST(i).REFRESH_VIEW_SUM_COL;

2670: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).SECURITY_GROUP_ID := null;
2671: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;
2672: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).REFRESH_VIEW_NAME := P_ENUM_REC_LIST(i).REFRESH_VIEW_NAME;
2673: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).RES_CAT_ENUM_FLAG := P_ENUM_REC_LIST(i).RES_CAT_ENUM_FLAG;
2674: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).REFRESH_VIEW_SUM_COL := P_ENUM_REC_LIST(i).REFRESH_VIEW_SUM_COL;
2675: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_DEPTH := P_ENUM_REC_LIST(i).NODE_DEPTH;
2676: IEU_PVT.L_RT_NODES_ITR := IEU_PVT.L_RT_NODES_ITR + 1;
2677: END IF;
2678:

Line 2675: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_DEPTH := P_ENUM_REC_LIST(i).NODE_DEPTH;

2671: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;
2672: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).REFRESH_VIEW_NAME := P_ENUM_REC_LIST(i).REFRESH_VIEW_NAME;
2673: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).RES_CAT_ENUM_FLAG := P_ENUM_REC_LIST(i).RES_CAT_ENUM_FLAG;
2674: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).REFRESH_VIEW_SUM_COL := P_ENUM_REC_LIST(i).REFRESH_VIEW_SUM_COL;
2675: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_DEPTH := P_ENUM_REC_LIST(i).NODE_DEPTH;
2676: IEU_PVT.L_RT_NODES_ITR := IEU_PVT.L_RT_NODES_ITR + 1;
2677: END IF;
2678:
2679: -- Bind Variables are inserted into IEU_UWQ_RTNODE_BIND_VALS

Line 2676: IEU_PVT.L_RT_NODES_ITR := IEU_PVT.L_RT_NODES_ITR + 1;

2672: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).REFRESH_VIEW_NAME := P_ENUM_REC_LIST(i).REFRESH_VIEW_NAME;
2673: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).RES_CAT_ENUM_FLAG := P_ENUM_REC_LIST(i).RES_CAT_ENUM_FLAG;
2674: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).REFRESH_VIEW_SUM_COL := P_ENUM_REC_LIST(i).REFRESH_VIEW_SUM_COL;
2675: IEU_PVT.IEU_UWQ_SEL_RT_NODES_LIST(IEU_PVT.L_RT_NODES_ITR).NODE_DEPTH := P_ENUM_REC_LIST(i).NODE_DEPTH;
2676: IEU_PVT.L_RT_NODES_ITR := IEU_PVT.L_RT_NODES_ITR + 1;
2677: END IF;
2678:
2679: -- Bind Variables are inserted into IEU_UWQ_RTNODE_BIND_VALS
2680: -- based on sel_rt_node_id. So select sel_node_id from

Line 2769: IEU_PVT.BIND_LAST_UPDATED_BY_LIST(IEU_PVT.L_IND_LIST_ITR) := FND_GLOBAL.USER_ID;

2765: SELECT IEU_UWQ_RTNODE_BIND_VALS_S1.NEXTVAL INTO L_RTNODE_BIND_VAR_ID FROM DUAL;
2766: L_BINDVALS_INSERT_FLAG := 'Y';
2767: END;
2768: IF NVL(L_BINDVALS_INSERT_FLAG, 'X') = 'N' THEN
2769: IEU_PVT.BIND_LAST_UPDATED_BY_LIST(IEU_PVT.L_IND_LIST_ITR) := FND_GLOBAL.USER_ID;
2770: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST(IEU_PVT.L_IND_LIST_ITR) := SYSDATE;
2771: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST(IEU_PVT.L_IND_LIST_ITR) := FND_GLOBAL.LOGIN_ID;
2772: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_SEL_RT_NODE_ID;
2773: IEU_PVT.BIND_RESOURCE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := P_RESOURCE_ID ;

Line 2770: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST(IEU_PVT.L_IND_LIST_ITR) := SYSDATE;

2766: L_BINDVALS_INSERT_FLAG := 'Y';
2767: END;
2768: IF NVL(L_BINDVALS_INSERT_FLAG, 'X') = 'N' THEN
2769: IEU_PVT.BIND_LAST_UPDATED_BY_LIST(IEU_PVT.L_IND_LIST_ITR) := FND_GLOBAL.USER_ID;
2770: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST(IEU_PVT.L_IND_LIST_ITR) := SYSDATE;
2771: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST(IEU_PVT.L_IND_LIST_ITR) := FND_GLOBAL.LOGIN_ID;
2772: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_SEL_RT_NODE_ID;
2773: IEU_PVT.BIND_RESOURCE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := P_RESOURCE_ID ;
2774: IEU_PVT.BIND_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_CURR_NODE_ID ;

Line 2771: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST(IEU_PVT.L_IND_LIST_ITR) := FND_GLOBAL.LOGIN_ID;

2767: END;
2768: IF NVL(L_BINDVALS_INSERT_FLAG, 'X') = 'N' THEN
2769: IEU_PVT.BIND_LAST_UPDATED_BY_LIST(IEU_PVT.L_IND_LIST_ITR) := FND_GLOBAL.USER_ID;
2770: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST(IEU_PVT.L_IND_LIST_ITR) := SYSDATE;
2771: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST(IEU_PVT.L_IND_LIST_ITR) := FND_GLOBAL.LOGIN_ID;
2772: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_SEL_RT_NODE_ID;
2773: IEU_PVT.BIND_RESOURCE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := P_RESOURCE_ID ;
2774: IEU_PVT.BIND_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_CURR_NODE_ID ;
2775: IEU_PVT.BIND_VAR_NAME_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_NAME ;

Line 2772: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_SEL_RT_NODE_ID;

2768: IF NVL(L_BINDVALS_INSERT_FLAG, 'X') = 'N' THEN
2769: IEU_PVT.BIND_LAST_UPDATED_BY_LIST(IEU_PVT.L_IND_LIST_ITR) := FND_GLOBAL.USER_ID;
2770: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST(IEU_PVT.L_IND_LIST_ITR) := SYSDATE;
2771: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST(IEU_PVT.L_IND_LIST_ITR) := FND_GLOBAL.LOGIN_ID;
2772: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_SEL_RT_NODE_ID;
2773: IEU_PVT.BIND_RESOURCE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := P_RESOURCE_ID ;
2774: IEU_PVT.BIND_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_CURR_NODE_ID ;
2775: IEU_PVT.BIND_VAR_NAME_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_NAME ;
2776: IEU_PVT.BIND_VAR_VALUE_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_VALUE;

Line 2773: IEU_PVT.BIND_RESOURCE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := P_RESOURCE_ID ;

2769: IEU_PVT.BIND_LAST_UPDATED_BY_LIST(IEU_PVT.L_IND_LIST_ITR) := FND_GLOBAL.USER_ID;
2770: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST(IEU_PVT.L_IND_LIST_ITR) := SYSDATE;
2771: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST(IEU_PVT.L_IND_LIST_ITR) := FND_GLOBAL.LOGIN_ID;
2772: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_SEL_RT_NODE_ID;
2773: IEU_PVT.BIND_RESOURCE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := P_RESOURCE_ID ;
2774: IEU_PVT.BIND_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_CURR_NODE_ID ;
2775: IEU_PVT.BIND_VAR_NAME_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_NAME ;
2776: IEU_PVT.BIND_VAR_VALUE_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_VALUE;
2777: IEU_PVT.BIND_VAR_DATATYPE_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_DATA_TYPE;

Line 2774: IEU_PVT.BIND_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_CURR_NODE_ID ;

2770: IEU_PVT.BIND_LAST_UPDATE_DATE_LIST(IEU_PVT.L_IND_LIST_ITR) := SYSDATE;
2771: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST(IEU_PVT.L_IND_LIST_ITR) := FND_GLOBAL.LOGIN_ID;
2772: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_SEL_RT_NODE_ID;
2773: IEU_PVT.BIND_RESOURCE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := P_RESOURCE_ID ;
2774: IEU_PVT.BIND_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_CURR_NODE_ID ;
2775: IEU_PVT.BIND_VAR_NAME_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_NAME ;
2776: IEU_PVT.BIND_VAR_VALUE_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_VALUE;
2777: IEU_PVT.BIND_VAR_DATATYPE_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_DATA_TYPE;
2778: IEU_PVT.NOT_VALID_FLAG_LIST(IEU_PVT.L_IND_LIST_ITR) := L_NOT_VALID_FLAG;

Line 2775: IEU_PVT.BIND_VAR_NAME_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_NAME ;

2771: IEU_PVT.BIND_LAST_UPDATE_LOGIN_LIST(IEU_PVT.L_IND_LIST_ITR) := FND_GLOBAL.LOGIN_ID;
2772: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_SEL_RT_NODE_ID;
2773: IEU_PVT.BIND_RESOURCE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := P_RESOURCE_ID ;
2774: IEU_PVT.BIND_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_CURR_NODE_ID ;
2775: IEU_PVT.BIND_VAR_NAME_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_NAME ;
2776: IEU_PVT.BIND_VAR_VALUE_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_VALUE;
2777: IEU_PVT.BIND_VAR_DATATYPE_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_DATA_TYPE;
2778: IEU_PVT.NOT_VALID_FLAG_LIST(IEU_PVT.L_IND_LIST_ITR) := L_NOT_VALID_FLAG;
2779: IEU_PVT.L_IND_LIST_ITR := IEU_PVT.L_IND_LIST_ITR + 1;

Line 2776: IEU_PVT.BIND_VAR_VALUE_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_VALUE;

2772: IEU_PVT.BIND_SEL_RT_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_SEL_RT_NODE_ID;
2773: IEU_PVT.BIND_RESOURCE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := P_RESOURCE_ID ;
2774: IEU_PVT.BIND_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_CURR_NODE_ID ;
2775: IEU_PVT.BIND_VAR_NAME_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_NAME ;
2776: IEU_PVT.BIND_VAR_VALUE_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_VALUE;
2777: IEU_PVT.BIND_VAR_DATATYPE_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_DATA_TYPE;
2778: IEU_PVT.NOT_VALID_FLAG_LIST(IEU_PVT.L_IND_LIST_ITR) := L_NOT_VALID_FLAG;
2779: IEU_PVT.L_IND_LIST_ITR := IEU_PVT.L_IND_LIST_ITR + 1;
2780: ELSE

Line 2777: IEU_PVT.BIND_VAR_DATATYPE_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_DATA_TYPE;

2773: IEU_PVT.BIND_RESOURCE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := P_RESOURCE_ID ;
2774: IEU_PVT.BIND_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_CURR_NODE_ID ;
2775: IEU_PVT.BIND_VAR_NAME_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_NAME ;
2776: IEU_PVT.BIND_VAR_VALUE_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_VALUE;
2777: IEU_PVT.BIND_VAR_DATATYPE_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_DATA_TYPE;
2778: IEU_PVT.NOT_VALID_FLAG_LIST(IEU_PVT.L_IND_LIST_ITR) := L_NOT_VALID_FLAG;
2779: IEU_PVT.L_IND_LIST_ITR := IEU_PVT.L_IND_LIST_ITR + 1;
2780: ELSE
2781: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RTNODE_BIND_VAR_ID := L_RTNODE_BIND_VAR_ID;

Line 2778: IEU_PVT.NOT_VALID_FLAG_LIST(IEU_PVT.L_IND_LIST_ITR) := L_NOT_VALID_FLAG;

2774: IEU_PVT.BIND_NODE_ID_LIST(IEU_PVT.L_IND_LIST_ITR) := L_CURR_NODE_ID ;
2775: IEU_PVT.BIND_VAR_NAME_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_NAME ;
2776: IEU_PVT.BIND_VAR_VALUE_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_VALUE;
2777: IEU_PVT.BIND_VAR_DATATYPE_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_DATA_TYPE;
2778: IEU_PVT.NOT_VALID_FLAG_LIST(IEU_PVT.L_IND_LIST_ITR) := L_NOT_VALID_FLAG;
2779: IEU_PVT.L_IND_LIST_ITR := IEU_PVT.L_IND_LIST_ITR + 1;
2780: ELSE
2781: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RTNODE_BIND_VAR_ID := L_RTNODE_BIND_VAR_ID;
2782: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;

Line 2779: IEU_PVT.L_IND_LIST_ITR := IEU_PVT.L_IND_LIST_ITR + 1;

2775: IEU_PVT.BIND_VAR_NAME_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_NAME ;
2776: IEU_PVT.BIND_VAR_VALUE_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_VALUE;
2777: IEU_PVT.BIND_VAR_DATATYPE_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_DATA_TYPE;
2778: IEU_PVT.NOT_VALID_FLAG_LIST(IEU_PVT.L_IND_LIST_ITR) := L_NOT_VALID_FLAG;
2779: IEU_PVT.L_IND_LIST_ITR := IEU_PVT.L_IND_LIST_ITR + 1;
2780: ELSE
2781: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RTNODE_BIND_VAR_ID := L_RTNODE_BIND_VAR_ID;
2782: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;
2783: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATED_BY := FND_GLOBAL.USER_ID;

Line 2781: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RTNODE_BIND_VAR_ID := L_RTNODE_BIND_VAR_ID;

2777: IEU_PVT.BIND_VAR_DATATYPE_LIST(IEU_PVT.L_IND_LIST_ITR) := L_BIND_VAR_DATA_TYPE;
2778: IEU_PVT.NOT_VALID_FLAG_LIST(IEU_PVT.L_IND_LIST_ITR) := L_NOT_VALID_FLAG;
2779: IEU_PVT.L_IND_LIST_ITR := IEU_PVT.L_IND_LIST_ITR + 1;
2780: ELSE
2781: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RTNODE_BIND_VAR_ID := L_RTNODE_BIND_VAR_ID;
2782: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;
2783: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2784: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATION_DATE := sysdate;
2785: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line 2782: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;

2778: IEU_PVT.NOT_VALID_FLAG_LIST(IEU_PVT.L_IND_LIST_ITR) := L_NOT_VALID_FLAG;
2779: IEU_PVT.L_IND_LIST_ITR := IEU_PVT.L_IND_LIST_ITR + 1;
2780: ELSE
2781: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RTNODE_BIND_VAR_ID := L_RTNODE_BIND_VAR_ID;
2782: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;
2783: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2784: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATION_DATE := sysdate;
2785: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2786: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_DATE := sysdate;

Line 2783: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATED_BY := FND_GLOBAL.USER_ID;

2779: IEU_PVT.L_IND_LIST_ITR := IEU_PVT.L_IND_LIST_ITR + 1;
2780: ELSE
2781: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RTNODE_BIND_VAR_ID := L_RTNODE_BIND_VAR_ID;
2782: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;
2783: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2784: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATION_DATE := sysdate;
2785: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2786: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_DATE := sysdate;
2787: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line 2784: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATION_DATE := sysdate;

2780: ELSE
2781: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RTNODE_BIND_VAR_ID := L_RTNODE_BIND_VAR_ID;
2782: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;
2783: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2784: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATION_DATE := sysdate;
2785: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2786: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_DATE := sysdate;
2787: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2788: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SECURITY_GROUP_ID := null;

Line 2785: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2781: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RTNODE_BIND_VAR_ID := L_RTNODE_BIND_VAR_ID;
2782: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;
2783: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2784: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATION_DATE := sysdate;
2785: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2786: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_DATE := sysdate;
2787: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2788: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SECURITY_GROUP_ID := null;
2789: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;

Line 2786: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_DATE := sysdate;

2782: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).OBJECT_VERSION_NUMBER := L_OBJECT_VERSION_NUMBER;
2783: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2784: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATION_DATE := sysdate;
2785: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2786: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_DATE := sysdate;
2787: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2788: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SECURITY_GROUP_ID := null;
2789: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2790: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RESOURCE_ID := P_RESOURCE_ID;

Line 2787: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2783: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATED_BY := FND_GLOBAL.USER_ID;
2784: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATION_DATE := sysdate;
2785: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2786: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_DATE := sysdate;
2787: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2788: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SECURITY_GROUP_ID := null;
2789: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2790: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RESOURCE_ID := P_RESOURCE_ID;
2791: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NODE_ID := L_CURR_NODE_ID;

Line 2788: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SECURITY_GROUP_ID := null;

2784: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).CREATION_DATE := sysdate;
2785: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2786: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_DATE := sysdate;
2787: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2788: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SECURITY_GROUP_ID := null;
2789: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2790: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RESOURCE_ID := P_RESOURCE_ID;
2791: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NODE_ID := L_CURR_NODE_ID;
2792: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_NAME := L_BIND_VAR_NAME;

Line 2789: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;

2785: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2786: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_DATE := sysdate;
2787: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2788: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SECURITY_GROUP_ID := null;
2789: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2790: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RESOURCE_ID := P_RESOURCE_ID;
2791: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NODE_ID := L_CURR_NODE_ID;
2792: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_NAME := L_BIND_VAR_NAME;
2793: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_VALUE := L_BIND_VAR_VALUE;

Line 2790: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RESOURCE_ID := P_RESOURCE_ID;

2786: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_DATE := sysdate;
2787: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2788: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SECURITY_GROUP_ID := null;
2789: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2790: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RESOURCE_ID := P_RESOURCE_ID;
2791: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NODE_ID := L_CURR_NODE_ID;
2792: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_NAME := L_BIND_VAR_NAME;
2793: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_VALUE := L_BIND_VAR_VALUE;
2794: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_DATATYPE := L_BIND_VAR_DATA_TYPE;

Line 2791: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NODE_ID := L_CURR_NODE_ID;

2787: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2788: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SECURITY_GROUP_ID := null;
2789: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2790: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RESOURCE_ID := P_RESOURCE_ID;
2791: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NODE_ID := L_CURR_NODE_ID;
2792: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_NAME := L_BIND_VAR_NAME;
2793: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_VALUE := L_BIND_VAR_VALUE;
2794: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_DATATYPE := L_BIND_VAR_DATA_TYPE;
2795: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NOT_VALID_FLAG := L_NOT_VALID_FLAG;

Line 2792: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_NAME := L_BIND_VAR_NAME;

2788: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SECURITY_GROUP_ID := null;
2789: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2790: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RESOURCE_ID := P_RESOURCE_ID;
2791: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NODE_ID := L_CURR_NODE_ID;
2792: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_NAME := L_BIND_VAR_NAME;
2793: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_VALUE := L_BIND_VAR_VALUE;
2794: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_DATATYPE := L_BIND_VAR_DATA_TYPE;
2795: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NOT_VALID_FLAG := L_NOT_VALID_FLAG;
2796: IEU_PVT.L_BIND_VALS_ITR := IEU_PVT.L_BIND_VALS_ITR + 1;

Line 2793: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_VALUE := L_BIND_VAR_VALUE;

2789: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).SEL_RT_NODE_ID := L_SEL_RT_NODE_ID;
2790: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RESOURCE_ID := P_RESOURCE_ID;
2791: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NODE_ID := L_CURR_NODE_ID;
2792: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_NAME := L_BIND_VAR_NAME;
2793: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_VALUE := L_BIND_VAR_VALUE;
2794: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_DATATYPE := L_BIND_VAR_DATA_TYPE;
2795: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NOT_VALID_FLAG := L_NOT_VALID_FLAG;
2796: IEU_PVT.L_BIND_VALS_ITR := IEU_PVT.L_BIND_VALS_ITR + 1;
2797: END IF;

Line 2794: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_DATATYPE := L_BIND_VAR_DATA_TYPE;

2790: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).RESOURCE_ID := P_RESOURCE_ID;
2791: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NODE_ID := L_CURR_NODE_ID;
2792: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_NAME := L_BIND_VAR_NAME;
2793: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_VALUE := L_BIND_VAR_VALUE;
2794: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_DATATYPE := L_BIND_VAR_DATA_TYPE;
2795: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NOT_VALID_FLAG := L_NOT_VALID_FLAG;
2796: IEU_PVT.L_BIND_VALS_ITR := IEU_PVT.L_BIND_VALS_ITR + 1;
2797: END IF;
2798: END LOOP;

Line 2795: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NOT_VALID_FLAG := L_NOT_VALID_FLAG;

2791: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NODE_ID := L_CURR_NODE_ID;
2792: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_NAME := L_BIND_VAR_NAME;
2793: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_VALUE := L_BIND_VAR_VALUE;
2794: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_DATATYPE := L_BIND_VAR_DATA_TYPE;
2795: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NOT_VALID_FLAG := L_NOT_VALID_FLAG;
2796: IEU_PVT.L_BIND_VALS_ITR := IEU_PVT.L_BIND_VALS_ITR + 1;
2797: END IF;
2798: END LOOP;
2799: END IF;

Line 2796: IEU_PVT.L_BIND_VALS_ITR := IEU_PVT.L_BIND_VALS_ITR + 1;

2792: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_NAME := L_BIND_VAR_NAME;
2793: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_VALUE := L_BIND_VAR_VALUE;
2794: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).BIND_VAR_DATATYPE := L_BIND_VAR_DATA_TYPE;
2795: IEU_PVT.IEU_UWQ_RTNODE_BIND_VALS_LIST(IEU_PVT.L_BIND_VALS_ITR).NOT_VALID_FLAG := L_NOT_VALID_FLAG;
2796: IEU_PVT.L_BIND_VALS_ITR := IEU_PVT.L_BIND_VALS_ITR + 1;
2797: END IF;
2798: END LOOP;
2799: END IF;
2800:

Line 3089: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN

3085: BEGIN
3086:
3087: l_iterator := 0;
3088:
3089: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN
3090: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.DELETE;
3091: IEU_PVT.REF_COUNT_LIST.DELETE;
3092: END IF;
3093:

Line 3090: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.DELETE;

3086:
3087: l_iterator := 0;
3088:
3089: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN
3090: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.DELETE;
3091: IEU_PVT.REF_COUNT_LIST.DELETE;
3092: END IF;
3093:
3094: l_ref_flag := '';

Line 3091: IEU_PVT.REF_COUNT_LIST.DELETE;

3087: l_iterator := 0;
3088:
3089: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN
3090: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.DELETE;
3091: IEU_PVT.REF_COUNT_LIST.DELETE;
3092: END IF;
3093:
3094: l_ref_flag := '';
3095: For b in c_bindVal

Line 3161: IEU_PVT.REFRESH_NODE(p_node_id => node.node_id,

3157: -- and (curr_node_id = node.node_pid) then
3158:
3159: l_count := '';
3160: l_iterator := l_iterator + 1;
3161: IEU_PVT.REFRESH_NODE(p_node_id => node.node_id,
3162: p_node_pid => node.node_pid,
3163: p_sel_enum_id => node.sel_enum_id,
3164: p_where_clause => node.where_clause,
3165: p_res_cat_enum_flag => node.res_cat_enum_flag,

Line 3176: IEU_PVT.SEL_RT_NODE_ID_REF_LIST(l_iterator) := node.sel_rt_node_id;

3172: p_bindvallist => l_bindvallist,
3173: x_count => l_count);
3174: x_node_id_list := x_node_id_list||node.node_id||fnd_global.local_chr(20);
3175:
3176: IEU_PVT.SEL_RT_NODE_ID_REF_LIST(l_iterator) := node.sel_rt_node_id;
3177: IEU_PVT.REF_COUNT_LIST(l_iterator) := l_count;
3178:
3179: elsif (node.node_depth <= l_node_depth) and (nvl(l_ref_flag, 'F') = 'T') and (node.node_id <> l_node_id) then
3180: l_ref_flag := '';

Line 3177: IEU_PVT.REF_COUNT_LIST(l_iterator) := l_count;

3173: x_count => l_count);
3174: x_node_id_list := x_node_id_list||node.node_id||fnd_global.local_chr(20);
3175:
3176: IEU_PVT.SEL_RT_NODE_ID_REF_LIST(l_iterator) := node.sel_rt_node_id;
3177: IEU_PVT.REF_COUNT_LIST(l_iterator) := l_count;
3178:
3179: elsif (node.node_depth <= l_node_depth) and (nvl(l_ref_flag, 'F') = 'T') and (node.node_id <> l_node_id) then
3180: l_ref_flag := '';
3181: exit;

Line 3186: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN

3182: end if;
3183: end loop;
3184:
3185: BEGIN
3186: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN
3187: FORALL x IN IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST..IEU_PVT.SEL_RT_NODE_ID_REF_LIST.LAST SAVE EXCEPTIONS
3188: UPDATE IEU_UWQ_SEL_RT_NODES
3189: SET COUNT = IEU_PVT.REF_COUNT_LIST(x)
3190: WHERE SEL_RT_NODE_ID = IEU_PVT.SEL_RT_NODE_ID_REF_LIST(x)

Line 3187: FORALL x IN IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST..IEU_PVT.SEL_RT_NODE_ID_REF_LIST.LAST SAVE EXCEPTIONS

3183: end loop;
3184:
3185: BEGIN
3186: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN
3187: FORALL x IN IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST..IEU_PVT.SEL_RT_NODE_ID_REF_LIST.LAST SAVE EXCEPTIONS
3188: UPDATE IEU_UWQ_SEL_RT_NODES
3189: SET COUNT = IEU_PVT.REF_COUNT_LIST(x)
3190: WHERE SEL_RT_NODE_ID = IEU_PVT.SEL_RT_NODE_ID_REF_LIST(x)
3191: AND RESOURCE_ID = P_RESOURCE_ID;

Line 3189: SET COUNT = IEU_PVT.REF_COUNT_LIST(x)

3185: BEGIN
3186: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN
3187: FORALL x IN IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST..IEU_PVT.SEL_RT_NODE_ID_REF_LIST.LAST SAVE EXCEPTIONS
3188: UPDATE IEU_UWQ_SEL_RT_NODES
3189: SET COUNT = IEU_PVT.REF_COUNT_LIST(x)
3190: WHERE SEL_RT_NODE_ID = IEU_PVT.SEL_RT_NODE_ID_REF_LIST(x)
3191: AND RESOURCE_ID = P_RESOURCE_ID;
3192: COMMIT;
3193:

Line 3190: WHERE SEL_RT_NODE_ID = IEU_PVT.SEL_RT_NODE_ID_REF_LIST(x)

3186: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN
3187: FORALL x IN IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST..IEU_PVT.SEL_RT_NODE_ID_REF_LIST.LAST SAVE EXCEPTIONS
3188: UPDATE IEU_UWQ_SEL_RT_NODES
3189: SET COUNT = IEU_PVT.REF_COUNT_LIST(x)
3190: WHERE SEL_RT_NODE_ID = IEU_PVT.SEL_RT_NODE_ID_REF_LIST(x)
3191: AND RESOURCE_ID = P_RESOURCE_ID;
3192: COMMIT;
3193:
3194: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.delete;

Line 3194: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.delete;

3190: WHERE SEL_RT_NODE_ID = IEU_PVT.SEL_RT_NODE_ID_REF_LIST(x)
3191: AND RESOURCE_ID = P_RESOURCE_ID;
3192: COMMIT;
3193:
3194: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.delete;
3195: IEU_PVT.REF_COUNT_LIST.delete;
3196: END IF;
3197:
3198: EXCEPTION

Line 3195: IEU_PVT.REF_COUNT_LIST.delete;

3191: AND RESOURCE_ID = P_RESOURCE_ID;
3192: COMMIT;
3193:
3194: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.delete;
3195: IEU_PVT.REF_COUNT_LIST.delete;
3196: END IF;
3197:
3198: EXCEPTION
3199: WHEN OTHERS THEN

Line 3200: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.delete;

3196: END IF;
3197:
3198: EXCEPTION
3199: WHEN OTHERS THEN
3200: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.delete;
3201: IEU_PVT.REF_COUNT_LIST.delete;
3202: END;
3203:
3204: i := i + 1;

Line 3201: IEU_PVT.REF_COUNT_LIST.delete;

3197:
3198: EXCEPTION
3199: WHEN OTHERS THEN
3200: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.delete;
3201: IEU_PVT.REF_COUNT_LIST.delete;
3202: END;
3203:
3204: i := i + 1;
3205: x_node_id_list := x_node_id_list||l_node_id||fnd_global.local_chr(20);

Line 3208: IEU_PVT.REFRESH_NODE(p_node_id => l_node_id,

3204: i := i + 1;
3205: x_node_id_list := x_node_id_list||l_node_id||fnd_global.local_chr(20);
3206:
3207: l_count := '';
3208: IEU_PVT.REFRESH_NODE(p_node_id => l_node_id,
3209: p_node_pid => l_node_pid,
3210: p_sel_enum_id => l_sel_enum_id,
3211: p_where_clause => l_where_clause,
3212: p_res_cat_enum_flag => l_res_cat_enum_flag,

Line 3245: IEU_PVT.REFRESH_NODE(p_node_id => node.node_id,

3241: i := i + 1;
3242:
3243: l_count := '';
3244: l_iterator := l_iterator + 1;
3245: IEU_PVT.REFRESH_NODE(p_node_id => node.node_id,
3246: p_node_pid => node.node_pid,
3247: p_sel_enum_id => node.sel_enum_id,
3248: p_where_clause => node.where_clause,
3249: p_res_cat_enum_flag => node.res_cat_enum_flag,

Line 3261: IEU_PVT.SEL_RT_NODE_ID_REF_LIST(l_iterator) := node.sel_rt_node_id;

3257: x_count => l_count);
3258:
3259: x_node_id_list := x_node_id_list||node.node_id||fnd_global.local_chr(20);
3260:
3261: IEU_PVT.SEL_RT_NODE_ID_REF_LIST(l_iterator) := node.sel_rt_node_id;
3262: IEU_PVT.REF_COUNT_LIST(l_iterator) := l_count;
3263:
3264: end loop;
3265: end loop;

Line 3262: IEU_PVT.REF_COUNT_LIST(l_iterator) := l_count;

3258:
3259: x_node_id_list := x_node_id_list||node.node_id||fnd_global.local_chr(20);
3260:
3261: IEU_PVT.SEL_RT_NODE_ID_REF_LIST(l_iterator) := node.sel_rt_node_id;
3262: IEU_PVT.REF_COUNT_LIST(l_iterator) := l_count;
3263:
3264: end loop;
3265: end loop;
3266:

Line 3268: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN

3264: end loop;
3265: end loop;
3266:
3267: BEGIN
3268: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN
3269: FORALL x IN IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST..IEU_PVT.SEL_RT_NODE_ID_REF_LIST.LAST SAVE EXCEPTIONS
3270: UPDATE IEU_UWQ_SEL_RT_NODES
3271: SET COUNT = IEU_PVT.REF_COUNT_LIST(x)
3272: WHERE SEL_RT_NODE_ID = IEU_PVT.SEL_RT_NODE_ID_REF_LIST(x)

Line 3269: FORALL x IN IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST..IEU_PVT.SEL_RT_NODE_ID_REF_LIST.LAST SAVE EXCEPTIONS

3265: end loop;
3266:
3267: BEGIN
3268: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN
3269: FORALL x IN IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST..IEU_PVT.SEL_RT_NODE_ID_REF_LIST.LAST SAVE EXCEPTIONS
3270: UPDATE IEU_UWQ_SEL_RT_NODES
3271: SET COUNT = IEU_PVT.REF_COUNT_LIST(x)
3272: WHERE SEL_RT_NODE_ID = IEU_PVT.SEL_RT_NODE_ID_REF_LIST(x)
3273: AND RESOURCE_ID = P_RESOURCE_ID;

Line 3271: SET COUNT = IEU_PVT.REF_COUNT_LIST(x)

3267: BEGIN
3268: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN
3269: FORALL x IN IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST..IEU_PVT.SEL_RT_NODE_ID_REF_LIST.LAST SAVE EXCEPTIONS
3270: UPDATE IEU_UWQ_SEL_RT_NODES
3271: SET COUNT = IEU_PVT.REF_COUNT_LIST(x)
3272: WHERE SEL_RT_NODE_ID = IEU_PVT.SEL_RT_NODE_ID_REF_LIST(x)
3273: AND RESOURCE_ID = P_RESOURCE_ID;
3274: COMMIT;
3275:

Line 3272: WHERE SEL_RT_NODE_ID = IEU_PVT.SEL_RT_NODE_ID_REF_LIST(x)

3268: IF IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST IS NOT NULL THEN
3269: FORALL x IN IEU_PVT.SEL_RT_NODE_ID_REF_LIST.FIRST..IEU_PVT.SEL_RT_NODE_ID_REF_LIST.LAST SAVE EXCEPTIONS
3270: UPDATE IEU_UWQ_SEL_RT_NODES
3271: SET COUNT = IEU_PVT.REF_COUNT_LIST(x)
3272: WHERE SEL_RT_NODE_ID = IEU_PVT.SEL_RT_NODE_ID_REF_LIST(x)
3273: AND RESOURCE_ID = P_RESOURCE_ID;
3274: COMMIT;
3275:
3276: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.delete;

Line 3276: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.delete;

3272: WHERE SEL_RT_NODE_ID = IEU_PVT.SEL_RT_NODE_ID_REF_LIST(x)
3273: AND RESOURCE_ID = P_RESOURCE_ID;
3274: COMMIT;
3275:
3276: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.delete;
3277: IEU_PVT.REF_COUNT_LIST.delete;
3278: END IF;
3279:
3280: EXCEPTION

Line 3277: IEU_PVT.REF_COUNT_LIST.delete;

3273: AND RESOURCE_ID = P_RESOURCE_ID;
3274: COMMIT;
3275:
3276: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.delete;
3277: IEU_PVT.REF_COUNT_LIST.delete;
3278: END IF;
3279:
3280: EXCEPTION
3281: WHEN OTHERS THEN

Line 3282: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.delete;

3278: END IF;
3279:
3280: EXCEPTION
3281: WHEN OTHERS THEN
3282: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.delete;
3283: IEU_PVT.REF_COUNT_LIST.delete;
3284: END;
3285:
3286: l_count := '';

Line 3283: IEU_PVT.REF_COUNT_LIST.delete;

3279:
3280: EXCEPTION
3281: WHEN OTHERS THEN
3282: IEU_PVT.SEL_RT_NODE_ID_REF_LIST.delete;
3283: IEU_PVT.REF_COUNT_LIST.delete;
3284: END;
3285:
3286: l_count := '';
3287: IEU_PVT.REFRESH_NODE(p_node_id => l_node_id,

Line 3287: IEU_PVT.REFRESH_NODE(p_node_id => l_node_id,

3283: IEU_PVT.REF_COUNT_LIST.delete;
3284: END;
3285:
3286: l_count := '';
3287: IEU_PVT.REFRESH_NODE(p_node_id => l_node_id,
3288: p_node_pid => l_node_pid,
3289: p_sel_enum_id => l_sel_enum_id,
3290: p_where_clause => l_where_clause,
3291: p_res_cat_enum_flag => l_res_cat_enum_flag,

Line 3327: ieu_pvt.check_ao_manual_mode(p_resource_id, l_ao_man_mode);

3323: l_ao_man_mode BOOLEAN := False;
3324:
3325: BEGIN
3326:
3327: ieu_pvt.check_ao_manual_mode(p_resource_id, l_ao_man_mode);
3328:
3329: IF (NOT l_ao_man_mode)
3330: THEN
3331: l_media_UUID_OUT := '50BFCF20B6F511D3A05000C04F53FBA6'; -- AO Normal Mode

Line 3375: IEU_PVT.REFRESH_CUR_NODE_COUNTS(p_resource_id, current_node_id, p_node_id_list);

3371:
3372: if temp = 0 then
3373:
3374: current_node_id := to_number(p_node_id_string);
3375: IEU_PVT.REFRESH_CUR_NODE_COUNTS(p_resource_id, current_node_id, p_node_id_list);
3376:
3377: x_node_id_list := p_node_id_list;
3378:
3379: else

Line 3389: IEU_PVT.REFRESH_CUR_NODE_COUNTS(p_resource_id, current_node_id, p_node_id_list);

3385: temp := (instr(p_node_id_string, fnd_global.local_chr(20), 1, j)) - l_counter;
3386:
3387: current_node_id := to_number(substr(p_node_id_string, l_counter, temp));
3388:
3389: IEU_PVT.REFRESH_CUR_NODE_COUNTS(p_resource_id, current_node_id, p_node_id_list);
3390:
3391: x_node_id_list := x_node_id_list||p_node_id_list;
3392:
3393: l_counter := (instr(p_node_id_string, fnd_global.local_chr(20),1,j))+1;

Line 3437: END IEU_PVT;

3433:
3434: END;
3435:
3436: -- PL/SQL Block
3437: END IEU_PVT;