eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEU_PVT dependencies on IEU_UWQ_SEL_RT_NODES

Line 4: IEU_UWQ_SEL_RT_NODES_LIST IEU_UWQ_SEL_RT_NODES_TAB;

1: PACKAGE BODY IEU_PVT AS
2: /* $Header: IEU_VB.pls 120.9 2011/09/15 17:38:13 spamujul 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;
6:
7: SEL_RT_NODE_ID_LIST NUMBER_TAB;
8: CREATED_BY_LIST NUMBER_TAB;

Line 713: UPDATE IEU_UWQ_SEL_RT_NODES

709: display_order;
710:
711: BEGIN
712:
713: UPDATE IEU_UWQ_SEL_RT_NODES
714: SET not_valid = 'Y'
715: WHERE resource_id = P_RESOURCE_ID;
716:
717: UPDATE IEU_UWQ_RTNODE_BIND_VALS

Line 842: IEU_UWQ_SEL_RT_NODES

838: rownum
839: into
840: l_media_count
841: from
842: IEU_UWQ_SEL_RT_NODES
843: where
844: (resource_id = p_resource_id) and
845: (not_valid = 'N') and
846: (media_type_id IS NOT NULL) and

Line 868: IEU_UWQ_SEL_RT_NODES_PKG.LOAD_ROW (

864: (lookup_type = 'IEU_NODE_LABELS') and
865: (view_application_id = 696) and
866: (lookup_code = 'IEU_MEDIA_LBL');
867:
868: IEU_UWQ_SEL_RT_NODES_PKG.LOAD_ROW (
869: X_RESOURCE_ID => p_resource_id,
870: X_SEL_ENUM_ID => 0,
871: X_NODE_ID => IEU_CONSTS_PUB.G_SNID_MEDIA,
872: X_NODE_TYPE => 0,

Line 952: ieu_uwq_sel_rt_nodes rt_nodes

948: rt_nodes.res_cat_enum_flag,
949: rt_nodes.node_depth
950: FROM
951:
952: ieu_uwq_sel_rt_nodes rt_nodes
953: WHERE
954: (rt_nodes.resource_id = p_resource_id) AND
955: (rt_nodes.node_id > 0) AND
956: /* (rt_nodes.node_id <> IEU_CONSTS_PUB.G_SNID_MEDIA) and */

Line 972: ieu_uwq_sel_rt_nodes rt_nodes

968: rt_nodes.refresh_view_sum_col,
969: rt_nodes.res_cat_enum_flag,
970: rt_nodes.view_name
971: FROM
972: ieu_uwq_sel_rt_nodes rt_nodes
973: WHERE
974: (rt_nodes.resource_id = p_resource_id) AND
975: (rt_nodes.node_id = IEU_CONSTS_PUB.G_SNID_MEDIA) and
976: (rt_nodes.not_valid = 'N');

Line 1062: UPDATE IEU_UWQ_SEL_RT_NODES

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;
1066: COMMIT;

Line 1090: UPDATE IEU_UWQ_SEL_RT_NODES

1086: l_res_cat_enum_flag, l_refresh_view_name, l_refresh_view_sum_col,
1087: l_sel_rt_node_id, l_count, p_resource_id,l_view_name, l_bindvallist, l_bulk_count);
1088:
1089: BEGIN
1090: UPDATE IEU_UWQ_SEL_RT_NODES
1091: SET COUNT = l_bulk_count
1092: WHERE SEL_RT_NODE_ID = l_sel_rt_node_id
1093: AND RESOURCE_ID = P_RESOURCE_ID;
1094: COMMIT;

Line 1112: UPDATE IEU_UWQ_SEL_RT_NODES

1108: l_tsk_res_cat_enum_flag, l_tsk_refresh_view_name, l_tsk_refresh_view_sum_col,
1109: l_tsk_sel_rt_node_id, l_tsk_count, p_resource_id,l_tsk_view_name, l_bindvallist, l_bulk_count);
1110:
1111: BEGIN
1112: UPDATE IEU_UWQ_SEL_RT_NODES
1113: SET COUNT = l_bulk_count
1114: WHERE SEL_RT_NODE_ID = l_tsk_sel_rt_node_id
1115: AND RESOURCE_ID = P_RESOURCE_ID;
1116: COMMIT;

Line 1477: IEU_UWQ_SEL_RT_NODES nodes

1473: --
1474: -- now update the count for the row
1475: --
1476: /* UPDATE
1477: IEU_UWQ_SEL_RT_NODES nodes
1478: SET
1479:
1480: nodes.count = l_count
1481: WHERE

Line 2340: ieu_uwq_sel_rt_nodes

2336: (max(node_id)+1)
2337: into
2338: l_curr_node_id
2339: from
2340: ieu_uwq_sel_rt_nodes
2341: where
2342: (resource_id = p_resource_id) and
2343: (not_valid = 'N');
2344:

Line 2390: UPDATE IEU_UWQ_SEL_RT_NODES SET

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),
2394: NODE_WEIGHT = IEU_PVT.NODE_WEIGHT_LIST(i),

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 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 2540: ieu_uwq_sel_rt_nodes

2536: where
2537: e.sel_enum_id = p_sel_enum_id;
2538:
2539: update
2540: ieu_uwq_sel_rt_nodes
2541: set
2542: node_weight = l_node_weight
2543: where
2544: resource_id = p_resource_id and

Line 2561: l_sel_rt_node_id ieu_uwq_sel_rt_nodes.sel_rt_node_id%type;

2557: X_NEW_CURR_NODE_ID IN OUT NOCOPY PLS_INTEGER) AS
2558:
2559: l_curr_node_id PLS_INTEGER;
2560: i PLS_INTEGER;
2561: l_sel_rt_node_id ieu_uwq_sel_rt_nodes.sel_rt_node_id%type;
2562: l_bind_var_name IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_NAME%TYPE;
2563: L_BIND_VAR_VALUE IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_VALUE%TYPE;
2564: L_BIND_VAR_DATA_TYPE IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_DATATYPE%TYPE;
2565: tempString varchar2(2000);

Line 2587: IEU_UWQ_SEL_RT_NODES_PKG.LOAD_ROW (

2583:
2584: loop
2585: /*
2586: -- insert or update IEU_UWQ_RTNODE_BIND_VALS
2587: IEU_UWQ_SEL_RT_NODES_PKG.LOAD_ROW (
2588: X_RESOURCE_ID => p_resource_id,
2589: X_SEL_ENUM_ID => p_s_enum_id,
2590: X_NODE_ID => l_curr_node_id,
2591: X_NODE_TYPE => P_ENUM_REC_LIST(i).NODE_TYPE ,

Line 2615: from ieu_uwq_sel_rt_nodes

2611: L_SEL_RT_NODE_ID := '';
2612: BEGIN
2613: select sel_rt_node_id
2614: into l_sel_rt_node_id
2615: from ieu_uwq_sel_rt_nodes
2616: where RESOURCE_ID = P_RESOURCE_ID
2617: and NODE_ID = l_curr_node_id;
2618:
2619: L_RTNODE_INSERT_FLAG := 'N';

Line 2622: SELECT IEU_UWQ_SEL_RT_NODES_S1.NEXTVAL INTO L_SEL_RT_NODE_ID FROM DUAL;

2618:
2619: L_RTNODE_INSERT_FLAG := 'N';
2620: EXCEPTION
2621: WHEN NO_DATA_FOUND THEN
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;

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 2681: -- ieu_uwq_sel_rt_nodes based on resource_id and node_id.

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
2681: -- ieu_uwq_sel_rt_nodes based on resource_id and node_id.
2682: /*
2683: select
2684: sel_rt_node_id
2685: into

Line 2688: ieu_uwq_sel_rt_nodes

2684: sel_rt_node_id
2685: into
2686: l_sel_rt_node_id
2687: from
2688: ieu_uwq_sel_rt_nodes
2689: where
2690: RESOURCE_ID = P_RESOURCE_ID and
2691: NODE_ID = l_curr_node_id;
2692: */

Line 3028: ieu_uwq_sel_rt_nodes rt_nodes

3024: rt_nodes.refresh_view_name,
3025: rt_nodes.refresh_view_sum_col,
3026: rt_nodes.res_cat_enum_flag
3027: FROM
3028: ieu_uwq_sel_rt_nodes rt_nodes
3029: WHERE
3030: (rt_nodes.resource_id = p_resource_id) AND
3031: (rt_nodes.sel_enum_id = p_sel_enum_id) AND
3032: (rt_nodes.not_valid = 'N')

Line 3052: ieu_uwq_sel_rt_nodes rt_nodes

3048: rt_nodes.refresh_view_name,
3049: rt_nodes.refresh_view_sum_col,
3050: rt_nodes.res_cat_enum_flag
3051: FROM
3052: ieu_uwq_sel_rt_nodes rt_nodes
3053: WHERE
3054: (rt_nodes.resource_id = p_resource_id) AND
3055: (rt_nodes.sel_enum_id = p_sel_enum_id) AND
3056: (rt_nodes.not_valid = 'N');

Line 3063: ieu_uwq_sel_rt_nodes rt_nodes

3059: cursor c_media_nodes is
3060: SELECT
3061: rt_nodes.sel_enum_id, rt_nodes.node_depth
3062: FROM
3063: ieu_uwq_sel_rt_nodes rt_nodes
3064: WHERE
3065: (rt_nodes.resource_id = p_resource_id) AND
3066: (rt_nodes.node_pid = 4000) AND
3067: (rt_nodes.not_valid = 'N');

Line 3130: ieu_uwq_sel_rt_nodes rt_nodes

3126: l_refresh_view_name,
3127: l_refresh_view_sum_col,
3128: l_res_cat_enum_flag
3129: FROM
3130: ieu_uwq_sel_rt_nodes rt_nodes
3131: WHERE
3132: (rt_nodes.resource_id = p_resource_id) AND
3133: (rt_nodes.node_id = p_node_id) AND
3134: (rt_nodes.not_valid = 'N');

Line 3188: UPDATE IEU_UWQ_SEL_RT_NODES

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;
3192: COMMIT;

Line 3223: UPDATE IEU_UWQ_SEL_RT_NODES

3219: p_bindvallist => l_bindvallist,
3220: x_count => l_count);
3221:
3222: BEGIN
3223: UPDATE IEU_UWQ_SEL_RT_NODES
3224: SET COUNT = l_count
3225: WHERE SEL_RT_NODE_ID = l_sel_rt_node_id
3226: AND RESOURCE_ID = P_RESOURCE_ID;
3227: COMMIT;

Line 3270: UPDATE IEU_UWQ_SEL_RT_NODES

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;
3274: COMMIT;

Line 3302: UPDATE IEU_UWQ_SEL_RT_NODES

3298: p_bindvallist => l_bindvallist,
3299: x_count => l_count);
3300:
3301: BEGIN
3302: UPDATE IEU_UWQ_SEL_RT_NODES
3303: SET COUNT = l_count
3304: WHERE SEL_RT_NODE_ID = l_sel_rt_node_id
3305: AND RESOURCE_ID = P_RESOURCE_ID;
3306: COMMIT;