APPS.IEU_DIAGNOSTICS_PVT dependencies on IEU_UWQ_SEL_RT_NODES

Line 1682: l_node_weight ieu_uwq_sel_rt_nodes.node_weight%type;

1678:
1679:
1680: l_node_id number(10);
1681: l_node_pid number(10);
1682: l_node_weight ieu_uwq_sel_rt_nodes.node_weight%type;
1683: l_vnode_label varchar2(512);
1684:
1685: t1 NUMBER; -- start time
1686: t2 NUMBER; -- end time

Line 1774: UPDATE IEU_UWQ_SEL_RT_NODES

1770: INTO l_resource_id
1771: USING l_user_id;
1772:
1773:
1774: UPDATE IEU_UWQ_SEL_RT_NODES
1775: SET not_valid = 'Y'
1776: WHERE resource_id = l_resource_id;
1777:
1778: UPDATE IEU_UWQ_RTNODE_BIND_VALS

Line 2035: IEU_UWQ_SEL_RT_NODES

2031: rownum
2032: into
2033: l_media_count
2034: from
2035: IEU_UWQ_SEL_RT_NODES
2036: where
2037: (resource_id = l_resource_id) and
2038: (not_valid = 'N') and
2039: (media_type_id IS NOT NULL) and

Line 2061: IEU_UWQ_SEL_RT_NODES_PKG.LOAD_ROW (

2057: (lookup_type = 'IEU_NODE_LABELS') and
2058: (view_application_id = 696) and
2059: (lookup_code = 'IEU_MEDIA_LBL');
2060:
2061: IEU_UWQ_SEL_RT_NODES_PKG.LOAD_ROW (
2062: X_RESOURCE_ID => l_resource_id,
2063: X_SEL_ENUM_ID => 0,
2064: X_NODE_ID => IEU_CONSTS_PUB.G_SNID_MEDIA,
2065: X_NODE_TYPE => 0,

Line 2249: FROM ieu_uwq_sel_rt_nodes

2245:
2246: CURSOR c_node IS
2247: SELECT
2248: node_id, node_label, node_pid, node_weight
2249: FROM ieu_uwq_sel_rt_nodes
2250: WHERE
2251: (resource_id = l_resource_id) and
2252: ((not_valid is null) or (not_valid <> 'Y'))order by node_pid, node_weight;
2253:

Line 2488: l_node_weight ieu_uwq_sel_rt_nodes.node_weight%type;

2484: l_sel_enum_id number(15);
2485: l_res_cat_enum_flag varchar2(1);
2486: l_view_name varchar2(512);
2487: l_node_label varchar2(512);
2488: l_node_weight ieu_uwq_sel_rt_nodes.node_weight%type;
2489:
2490: l_temp_view_name varchar2(512);
2491: l_temp_view_count number(2);
2492:

Line 2525: ieu_uwq_sel_rt_nodes rt_nodes

2521: rt_nodes.node_label,
2522: rt_nodes.node_weight
2523: FROM
2524:
2525: ieu_uwq_sel_rt_nodes rt_nodes
2526: WHERE
2527: (rt_nodes.resource_id = l_resource_id) AND
2528: (rt_nodes.node_id <> 0) AND
2529: (rt_nodes.node_id <> IEU_CONSTS_PUB.G_SNID_MEDIA) and

Line 2547: ieu_uwq_sel_rt_nodes rt_nodes

2543: rt_nodes.view_name,
2544: rt_nodes.node_label,
2545: rt_nodes.node_weight
2546: FROM
2547: ieu_uwq_sel_rt_nodes rt_nodes
2548: WHERE
2549: (rt_nodes.resource_id = l_resource_id) AND
2550: (rt_nodes.node_id = IEU_CONSTS_PUB.G_SNID_MEDIA) and
2551: (rt_nodes.not_valid = 'N')

Line 3418: IEU_UWQ_SEL_RT_NODES nodes

3414: --
3415: -- now update the count for the row
3416: --
3417: UPDATE
3418: IEU_UWQ_SEL_RT_NODES nodes
3419: SET
3420:
3421: nodes.count = l_count
3422: WHERE

Line 3496: FROM ieu_uwq_sel_rt_nodes

3492:
3493: CURSOR c_node IS
3494: SELECT
3495: node_id, view_name
3496: FROM ieu_uwq_sel_rt_nodes
3497: WHERE
3498: (resource_id = l_resource_id) and
3499: ((not_valid is null) or (not_valid <> 'Y'))order by node_pid, node_weight;
3500: