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_DIAGNOSTICS_PVT dependencies on IEU_UWQ_SEL_ENUMERATORS

Line 696: l_work_q_enable_profile_option IEU_UWQ_SEL_ENUMERATORS.WORK_Q_ENABLE_PROFILE_OPTION%TYPE;

692: l_responsibility_name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE;
693:
694: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;
695:
696: l_work_q_enable_profile_option IEU_UWQ_SEL_ENUMERATORS.WORK_Q_ENABLE_PROFILE_OPTION%TYPE;
697:
698: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;
699:
700: l_language VARCHAR2(4);

Line 702: l_media_type_id IEU_UWQ_SEL_ENUMERATORS.MEDIA_TYPE_ID%TYPE;

698: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;
699:
700: l_language VARCHAR2(4);
701:
702: l_media_type_id IEU_UWQ_SEL_ENUMERATORS.MEDIA_TYPE_ID%TYPE;
703:
704: l_valid boolean;
705: l_media_type_name IEU_UWQ_MEDIA_TYPES_TL.MEDIA_TYPE_NAME%TYPE;
706:

Line 720: from ieu_uwq_sel_enumerators

716:
717:
718: CURSOR c_types IS
719: select media_type_id
720: from ieu_uwq_sel_enumerators
721: where ((not_valid_flag is null) or (not_valid_flag = 'N')) and
722: work_q_register_type = 'M' order by media_type_id;
723:
724: i integer ;

Line 755: from ieu_uwq_sel_enumerators

751:
752: BEGIN
753: select work_q_enable_profile_option
754: into l_work_q_enable_profile_option
755: from ieu_uwq_sel_enumerators
756: where media_type_id = c_rec.media_type_id ;
757:
758:
759: EXCEPTION

Line 806: ieu_uwq_sel_enumerators s

802: select count(s.SEL_ENUM_ID) into l_media_count
803: from
804: ieu_uwq_media_types_b b,
805: ieu_uwq_media_types_tl tl,
806: ieu_uwq_sel_enumerators s
807: where
808: b.media_type_id = tl.media_type_id and
809: tl.language = l_language and
810: s.media_type_id = b.media_type_id and

Line 962: l_media_type_id IEU_UWQ_SEL_ENUMERATORS.MEDIA_TYPE_ID%TYPE;

958: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;
959:
960: l_language VARCHAR2(4);
961:
962: l_media_type_id IEU_UWQ_SEL_ENUMERATORS.MEDIA_TYPE_ID%TYPE;
963:
964: l_valid boolean;
965: l_media_type_name IEU_UWQ_MEDIA_TYPES_TL.MEDIA_TYPE_NAME%TYPE;
966:

Line 1216: IEU_UWQ_SEL_ENUMERATORS e,

1212: SELECT
1213: distinct l.meaning node_name,
1214: e.SEL_ENUM_ID enum_id
1215: FROM
1216: IEU_UWQ_SEL_ENUMERATORS e,
1217: fnd_lookup_values l
1218: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b
1219: where upper(b.PROFILE_OPTION_NAME) = upper(e.work_q_enable_profile_option))
1220: AND ((e.NOT_VALID_FLAG is NULL) OR (e.NOT_VALID_FLAG = 'N')) AND

Line 1396: l_profle_name IEU_UWQ_SEL_ENUMERATORS.WORK_Q_ENABLE_PROFILE_OPTION%TYPE;

1392: l_language VARCHAR2(4);
1393:
1394: l_valid_nodes IEU_DIAG_VNODE_NST;
1395:
1396: l_profle_name IEU_UWQ_SEL_ENUMERATORS.WORK_Q_ENABLE_PROFILE_OPTION%TYPE;
1397:
1398: v_count BINARY_INTEGER ;
1399:
1400: --x_valid_nodes IEU_DIAG_VNODE_NST;

Line 1439: from ieu_uwq_sel_enumerators a,

1435: --dbms_output.put_line('count: -->'|| v_count);
1436: --dbms_output.put_line('id-->'||l_valid_nodes(v_count).enum_id);
1437: BEGIN
1438: select a.WORK_Q_ENABLE_PROFILE_OPTION into l_profle_name
1439: from ieu_uwq_sel_enumerators a,
1440: ieu_uwq_sel_enumerators b
1441: where
1442: a.sel_enum_id = b.sel_enum_id and
1443: a.sel_enum_id = l_valid_nodes(v_count).enum_id and

Line 1440: ieu_uwq_sel_enumerators b

1436: --dbms_output.put_line('id-->'||l_valid_nodes(v_count).enum_id);
1437: BEGIN
1438: select a.WORK_Q_ENABLE_PROFILE_OPTION into l_profle_name
1439: from ieu_uwq_sel_enumerators a,
1440: ieu_uwq_sel_enumerators b
1441: where
1442: a.sel_enum_id = b.sel_enum_id and
1443: a.sel_enum_id = l_valid_nodes(v_count).enum_id and
1444: (upper(a.WORK_Q_ENABLE_PROFILE_OPTION) <> b.WORK_Q_ENABLE_PROFILE_OPTION

Line 1652: l_temp_eproc IEU_UWQ_SEL_ENUMERATORS.ENUM_PROC%TYPE;

1648: l_node_label VARCHAR2(80);
1649:
1650: l_count NUMBER(10) ;
1651:
1652: l_temp_eproc IEU_UWQ_SEL_ENUMERATORS.ENUM_PROC%TYPE;
1653:
1654: l_temp_pkg_name IEU_UWQ_SEL_ENUMERATORS.ENUM_PROC%TYPE;
1655:
1656: l_media_type_name IEU_UWQ_MEDIA_TYPES_TL.MEDIA_TYPE_NAME%TYPE;

Line 1654: l_temp_pkg_name IEU_UWQ_SEL_ENUMERATORS.ENUM_PROC%TYPE;

1650: l_count NUMBER(10) ;
1651:
1652: l_temp_eproc IEU_UWQ_SEL_ENUMERATORS.ENUM_PROC%TYPE;
1653:
1654: l_temp_pkg_name IEU_UWQ_SEL_ENUMERATORS.ENUM_PROC%TYPE;
1655:
1656: l_media_type_name IEU_UWQ_MEDIA_TYPES_TL.MEDIA_TYPE_NAME%TYPE;
1657:
1658: l_temp_count NUMBER(10) ;

Line 1709: IEU_UWQ_SEL_ENUMERATORS e

1705: e.application_id,
1706: e.work_q_label_lu_type,
1707: e.work_q_label_lu_code
1708: FROM
1709: IEU_UWQ_SEL_ENUMERATORS e
1710: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b
1711: where upper(b.PROFILE_OPTION_NAME) = upper(e.work_q_enable_profile_option))
1712: AND ((e.NOT_VALID_FLAG is NULL) OR (e.NOT_VALID_FLAG = 'N')) AND
1713: (nvl(fnd_profile.value(e.work_q_enable_profile_option),'Y') = 'Y')

Line 1720: from ieu_uwq_sel_enumerators s,

1716:
1717:
1718: cursor c_dproc (enum_id NUMBER, app_id NUMBER, l_type VARCHAR2, l_code VARCHAR2)is
1719: select distinct v.meaning, s.sel_enum_id, s.enum_proc, tl.application_name
1720: from ieu_uwq_sel_enumerators s,
1721: fnd_application_tl tl,
1722: fnd_lookup_values v
1723: where s.sel_enum_id = enum_id
1724: and tl.application_id = app_id

Line 1794: from IEU_UWQ_SEL_ENUMERATORS u, FND_LOOKUP_VALUES lu

1790: t1 := DBMS_UTILITY.GET_TIME;
1791:
1792: --get the details of a node
1793: /* SELECT lu.MEANING into l_vnode_label
1794: from IEU_UWQ_SEL_ENUMERATORS u, FND_LOOKUP_VALUES lu
1795: where
1796: u.WORK_Q_LABEL_LU_TYPE = lu.LOOKUP_TYPE
1797: and u.WORK_Q_LABEL_LU_CODE = lu.LOOKUP_CODE
1798: and u.SEL_ENUM_ID =c_rec.SEL_ENUM_ID;*/

Line 1802: from ieu_uwq_sel_enumerators s,

1798: and u.SEL_ENUM_ID =c_rec.SEL_ENUM_ID;*/
1799:
1800:
1801: select distinct v.meaning into l_vnode_label
1802: from ieu_uwq_sel_enumerators s,
1803: fnd_application_tl tl,
1804: fnd_lookup_values v
1805: where s.sel_enum_id = c_rec.SEL_ENUM_ID
1806: and tl.application_id = s.APPLICATION_ID

Line 1832: select count(sel_enum_id) into l_count from ieu_uwq_sel_enumerators

1828: end if;*/
1829:
1830: begin
1831:
1832: select count(sel_enum_id) into l_count from ieu_uwq_sel_enumerators
1833: where enum_proc = c_rec.enum_proc;
1834:
1835:
1836: --DBMS_OUTPUT.put_line('count of duplicate enum_proc-->'||l_count);

Line 2462: l_temp_rproc IEU_UWQ_SEL_ENUMERATORS.REFRESH_PROC%TYPE;

2458: l_valid_nodes IEU_DIAG_NODE_NST;
2459:
2460: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
2461:
2462: l_temp_rproc IEU_UWQ_SEL_ENUMERATORS.REFRESH_PROC%TYPE;
2463:
2464: l_temp_pkg_name IEU_UWQ_SEL_ENUMERATORS.REFRESH_PROC%TYPE;
2465:
2466: l_temp_count NUMBER(10) ;

Line 2464: l_temp_pkg_name IEU_UWQ_SEL_ENUMERATORS.REFRESH_PROC%TYPE;

2460: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
2461:
2462: l_temp_rproc IEU_UWQ_SEL_ENUMERATORS.REFRESH_PROC%TYPE;
2463:
2464: l_temp_pkg_name IEU_UWQ_SEL_ENUMERATORS.REFRESH_PROC%TYPE;
2465:
2466: l_temp_count NUMBER(10) ;
2467:
2468: i integer ;

Line 2564: IEU_UWQ_SEL_ENUMERATORS e

2560: e.application_id,
2561: e.work_q_label_lu_type,
2562: e.work_q_label_lu_code
2563: FROM
2564: IEU_UWQ_SEL_ENUMERATORS e
2565: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b
2566: where upper(b.PROFILE_OPTION_NAME) = upper(e.work_q_enable_profile_option))
2567: AND ((e.NOT_VALID_FLAG is NULL) OR (e.NOT_VALID_FLAG = 'N')) AND
2568: (nvl(fnd_profile.value(e.work_q_enable_profile_option),'Y') = 'Y')

Line 2574: from ieu_uwq_sel_enumerators s,

2570:
2571:
2572: cursor c_dproc (enum_id NUMBER, app_id NUMBER, l_type VARCHAR2, l_code VARCHAR2)is
2573: select distinct v.meaning, s.sel_enum_id, s.refresh_proc, tl.application_name
2574: from ieu_uwq_sel_enumerators s,
2575: fnd_application_tl tl,
2576: fnd_lookup_values v
2577: where s.sel_enum_id = enum_id
2578: and tl.application_id = app_id

Line 2586: from ieu_uwq_sel_enumerators s,

2582: and v.language = l_language;
2583:
2584: cursor c_temp (enum_id NUMBER)is
2585: select tl.application_name
2586: from ieu_uwq_sel_enumerators s,
2587: fnd_application_tl tl
2588: where s.sel_enum_id = enum_id
2589: and tl.application_id = s.application_id
2590: and tl.language = l_language;

Line 2736: from ieu_uwq_sel_enumerators s,

2732: where object_name = node.view_name and object_type = 'VIEW'
2733: and status = 'VALID' and owner = 'APPS';
2734:
2735: select tl.application_name into l_appli_name
2736: from ieu_uwq_sel_enumerators s,
2737: fnd_application_tl tl
2738: where s.sel_enum_id = node.sel_enum_id
2739: and tl.application_id = s.application_id
2740: and tl.language = l_language;

Line 2854: from ieu_uwq_sel_enumerators s,

2850: where object_name = l_view_name and object_type = 'VIEW'
2851: and status = 'VALID' and owner = 'APPS';
2852:
2853: select tl.application_name into l_appli_name
2854: from ieu_uwq_sel_enumerators s,
2855: fnd_application_tl tl
2856: where s.sel_enum_id = l_sel_enum_id
2857: and tl.application_id = s.application_id
2858: and tl.language = l_language;

Line 3189: ieu_uwq_sel_enumerators

3185: refresh_proc
3186: into
3187: l_refresh_proc
3188: from
3189: ieu_uwq_sel_enumerators
3190: where
3191: sel_enum_id = p_sel_enum_id;
3192: EXCEPTION
3193: WHEN NO_DATA_FOUND THEN

Line 3209: from ieu_uwq_sel_enumerators s,

3205: BEGIN
3206: -- If any refresh proc produces an error
3207:
3208: select tl.application_name into l_appli_name
3209: from ieu_uwq_sel_enumerators s,
3210: fnd_application_tl tl
3211: where s.sel_enum_id = p_sel_enum_id
3212: and tl.application_id = s.application_id
3213: and tl.language = l_language;