APPS.IEU_DIAGNOSTICS_PVT dependencies on IEU_UWQ_MEDIA_TYPES_TL

Line 705: l_media_type_name IEU_UWQ_MEDIA_TYPES_TL.MEDIA_TYPE_NAME%TYPE;

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:
707: l_msg_count NUMBER(2);
708:
709: l_msg_data VARCHAR2(2000);

Line 774: from ieu_uwq_media_types_tl

770: begin
771: x_media_types.EXTEND;
772:
773: select media_type_name INTO x_media_types(i)
774: from ieu_uwq_media_types_tl
775: where media_type_id = c_rec.MEDIA_TYPE_ID
776: and language = l_language order by media_type_name;
777:
778:

Line 805: ieu_uwq_media_types_tl tl,

801: begin
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

Line 965: l_media_type_name IEU_UWQ_MEDIA_TYPES_TL.MEDIA_TYPE_NAME%TYPE;

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:
967: l_msg_count NUMBER(2);
968:
969: l_msg_data VARCHAR2(2000);

Line 1028: IEU_UWQ_MEDIA_TYPES_TL mtltab

1024: select mmptab.SVR_TYPE_ID into l_server_type_id from
1025: IEO_SVR_SERVERS svrtab,
1026: IEU_UWQ_SVR_MPS_MMAPS mmptab,
1027: IEU_UWQ_MEDIA_TYPES_B mttab,
1028: IEU_UWQ_MEDIA_TYPES_TL mtltab
1029: where (mtltab.MEDIA_TYPE_NAME = l_media_types(i)) and
1030: (mtltab.LANGUAGE = l_language) and
1031: (mtltab.MEDIA_TYPE_ID = mttab.MEDIA_TYPE_ID) and
1032: (mmptab.MEDIA_TYPE_ID = mttab.MEDIA_TYPE_ID) and

Line 1656: l_media_type_name IEU_UWQ_MEDIA_TYPES_TL.MEDIA_TYPE_NAME%TYPE;

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) ;
1659:
1660: i integer ;