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_UWQ_MEDIA_TYPES_PVT dependencies on FND_GLOBAL

Line 258: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

254: fnd_msg_pub.delete_msg();
255: x_return_status := fnd_api.g_ret_sts_success;
256: FND_MSG_PUB.initialize;
257:
258: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
259:
260: valid_name := true;
261: valid_uuid := true;
262: valid_cli_class := true;

Line 616: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

612: if x_return_status = 'S' then
613:
614: select IEU_UWQ_MEDIA_TYPES_B_S2.NEXTVAL into l_media_type_id from sys.dual;
615:
616: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
617:
618: insert INTO IEU_UWQ_MEDIA_TYPES_B
619: (MEDIA_TYPE_ID,
620: CREATED_BY,

Line 640: FND_GLOBAL.USER_ID,

636: BLENDED_DIR
637: )
638: values (
639: l_media_type_id,
640: FND_GLOBAL.USER_ID,
641: SYSDATE,
642: FND_GLOBAL.USER_ID,
643: SYSDATE,
644: FND_GLOBAL.LOGIN_ID,

Line 642: FND_GLOBAL.USER_ID,

638: values (
639: l_media_type_id,
640: FND_GLOBAL.USER_ID,
641: SYSDATE,
642: FND_GLOBAL.USER_ID,
643: SYSDATE,
644: FND_GLOBAL.LOGIN_ID,
645: null,
646: 1,

Line 644: FND_GLOBAL.LOGIN_ID,

640: FND_GLOBAL.USER_ID,
641: SYSDATE,
642: FND_GLOBAL.USER_ID,
643: SYSDATE,
644: FND_GLOBAL.LOGIN_ID,
645: null,
646: 1,
647: null,
648: LTRIM(RTRIM(rec_obj.media_type_uuid)),

Line 675: FND_GLOBAL.USER_ID,

671: OBJECT_VERSION_NUMBER
672: )
673: values ( l_media_type_id,
674: l_language,
675: FND_GLOBAL.USER_ID,
676: SYSDATE,
677: FND_GLOBAL.USER_ID,
678: SYSDATE,
679: FND_GLOBAL.LOGIN_ID,

Line 677: FND_GLOBAL.USER_ID,

673: values ( l_media_type_id,
674: l_language,
675: FND_GLOBAL.USER_ID,
676: SYSDATE,
677: FND_GLOBAL.USER_ID,
678: SYSDATE,
679: FND_GLOBAL.LOGIN_ID,
680: LTRIM(RTRIM(rec_obj.media_type_name)),
681: l_language,

Line 679: FND_GLOBAL.LOGIN_ID,

675: FND_GLOBAL.USER_ID,
676: SYSDATE,
677: FND_GLOBAL.USER_ID,
678: SYSDATE,
679: FND_GLOBAL.LOGIN_ID,
680: LTRIM(RTRIM(rec_obj.media_type_name)),
681: l_language,
682: rec_obj.media_type_description,
683: null,

Line 706: FND_GLOBAL.USER_ID,

702: OBJECT_VERSION_NUMBER,
703: APPLICATION_ID
704: )
705: values ( l_cli_plugin_id,
706: FND_GLOBAL.USER_ID,
707: SYSDATE,
708: FND_GLOBAL.USER_ID,
709: SYSDATE,
710: FND_GLOBAL.LOGIN_ID,

Line 708: FND_GLOBAL.USER_ID,

704: )
705: values ( l_cli_plugin_id,
706: FND_GLOBAL.USER_ID,
707: SYSDATE,
708: FND_GLOBAL.USER_ID,
709: SYSDATE,
710: FND_GLOBAL.LOGIN_ID,
711: l_media_type_id,
712: LTRIM(RTRIM(rec_obj.cli_plugin_class)),

Line 710: FND_GLOBAL.LOGIN_ID,

706: FND_GLOBAL.USER_ID,
707: SYSDATE,
708: FND_GLOBAL.USER_ID,
709: SYSDATE,
710: FND_GLOBAL.LOGIN_ID,
711: l_media_type_id,
712: LTRIM(RTRIM(rec_obj.cli_plugin_class)),
713: null,
714: 1,

Line 742: FND_GLOBAL.USER_ID,

738: SECURITY_GROUP_ID,
739: OBJECT_VERSION_NUMBER
740: )
741: values ( l_svr_mps_mmap_id,
742: FND_GLOBAL.USER_ID,
743: SYSDATE,
744: FND_GLOBAL.USER_ID,
745: SYSDATE,
746: FND_GLOBAL.LOGIN_ID,

Line 744: FND_GLOBAL.USER_ID,

740: )
741: values ( l_svr_mps_mmap_id,
742: FND_GLOBAL.USER_ID,
743: SYSDATE,
744: FND_GLOBAL.USER_ID,
745: SYSDATE,
746: FND_GLOBAL.LOGIN_ID,
747: l_media_type_id,
748: rec_obj.svr_type_id,

Line 746: FND_GLOBAL.LOGIN_ID,

742: FND_GLOBAL.USER_ID,
743: SYSDATE,
744: FND_GLOBAL.USER_ID,
745: SYSDATE,
746: FND_GLOBAL.LOGIN_ID,
747: l_media_type_id,
748: rec_obj.svr_type_id,
749: null,
750: null,

Line 768: FND_GLOBAL.USER_ID,

764: OBJECT_VERSION_NUMBER,
765: APPLICATION_ID
766: )
767: values ( l_svr_mps_plugin_id,
768: FND_GLOBAL.USER_ID,
769: SYSDATE,
770: FND_GLOBAL.USER_ID,
771: SYSDATE,
772: FND_GLOBAL.LOGIN_ID,

Line 770: FND_GLOBAL.USER_ID,

766: )
767: values ( l_svr_mps_plugin_id,
768: FND_GLOBAL.USER_ID,
769: SYSDATE,
770: FND_GLOBAL.USER_ID,
771: SYSDATE,
772: FND_GLOBAL.LOGIN_ID,
773: rec_obj.svr_type_id,
774: LTRIM(RTRIM(rec_obj.svr_plugin_class)),

Line 772: FND_GLOBAL.LOGIN_ID,

768: FND_GLOBAL.USER_ID,
769: SYSDATE,
770: FND_GLOBAL.USER_ID,
771: SYSDATE,
772: FND_GLOBAL.LOGIN_ID,
773: rec_obj.svr_type_id,
774: LTRIM(RTRIM(rec_obj.svr_plugin_class)),
775: null,
776: 1,

Line 802: FND_GLOBAL.USER_ID,

798: SECURITY_GROUP_ID,
799: OBJECT_VERSION_NUMBER
800: )
801: values ( l_svr_mps_mmap_id,
802: FND_GLOBAL.USER_ID,
803: SYSDATE,
804: FND_GLOBAL.USER_ID,
805: SYSDATE,
806: FND_GLOBAL.LOGIN_ID,

Line 804: FND_GLOBAL.USER_ID,

800: )
801: values ( l_svr_mps_mmap_id,
802: FND_GLOBAL.USER_ID,
803: SYSDATE,
804: FND_GLOBAL.USER_ID,
805: SYSDATE,
806: FND_GLOBAL.LOGIN_ID,
807: l_media_type_id,
808: temp_svr_type_id,

Line 806: FND_GLOBAL.LOGIN_ID,

802: FND_GLOBAL.USER_ID,
803: SYSDATE,
804: FND_GLOBAL.USER_ID,
805: SYSDATE,
806: FND_GLOBAL.LOGIN_ID,
807: l_media_type_id,
808: temp_svr_type_id,
809: null,
810: null,

Line 836: FND_GLOBAL.USER_ID,

832: LTRIM(RTRIM(rec_obj.svr_plugin_class)),
833: 'Y',
834: rec_obj.application_id,
835: 1,
836: FND_GLOBAL.USER_ID,
837: SYSDATE,
838: FND_GLOBAL.USER_ID,
839: SYSDATE,
840: FND_GLOBAL.LOGIN_ID

Line 838: FND_GLOBAL.USER_ID,

834: rec_obj.application_id,
835: 1,
836: FND_GLOBAL.USER_ID,
837: SYSDATE,
838: FND_GLOBAL.USER_ID,
839: SYSDATE,
840: FND_GLOBAL.LOGIN_ID
841: );
842:

Line 840: FND_GLOBAL.LOGIN_ID

836: FND_GLOBAL.USER_ID,
837: SYSDATE,
838: FND_GLOBAL.USER_ID,
839: SYSDATE,
840: FND_GLOBAL.LOGIN_ID
841: );
842:
843: select IEU_CLI_PROV_PLUGIN_MED_MAP_S1.NEXTVAL into l_plugin_med_map_id from sys.dual;
844: insert into IEU_CLI_PROV_PLUGIN_MED_MAPS

Line 861: FND_GLOBAL.USER_ID,

857: l_plugin_id,
858: l_media_type_id,
859: null,
860: 1,
861: FND_GLOBAL.USER_ID,
862: SYSDATE,
863: SYSDATE,
864: FND_GLOBAL.USER_ID,
865: FND_GLOBAL.LOGIN_ID

Line 864: FND_GLOBAL.USER_ID,

860: 1,
861: FND_GLOBAL.USER_ID,
862: SYSDATE,
863: SYSDATE,
864: FND_GLOBAL.USER_ID,
865: FND_GLOBAL.LOGIN_ID
866: );
867:
868: end if;

Line 865: FND_GLOBAL.LOGIN_ID

861: FND_GLOBAL.USER_ID,
862: SYSDATE,
863: SYSDATE,
864: FND_GLOBAL.USER_ID,
865: FND_GLOBAL.LOGIN_ID
866: );
867:
868: end if;
869: end if;

Line 938: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

934:
935:
936: BEGIN
937: x_return_status := fnd_api.g_ret_sts_success;
938: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
939:
940:
941:
942: IEU_UWQ_MEDIA_TYPES_PVT.VALIDATE ( x_return_status,

Line 951: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

947: if x_return_status = 'S' then
948:
949:
950: update IEU_UWQ_MEDIA_TYPES_B set
951: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
952: LAST_UPDATE_DATE = SYSDATE,
953: LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID,
954: TEL_REQD_FLAG = rec_obj.tel_reqd_flag,
955: APPLICATION_ID = rec_obj.application_id,

Line 953: LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID,

949:
950: update IEU_UWQ_MEDIA_TYPES_B set
951: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
952: LAST_UPDATE_DATE = SYSDATE,
953: LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID,
954: TEL_REQD_FLAG = rec_obj.tel_reqd_flag,
955: APPLICATION_ID = rec_obj.application_id,
956: SVR_LOGIN_RULE_ID = rec_obj.svr_login_rule_id,
957: CLASSIFICATION_QUERY_PROC = rec_obj.classfn_query_proc

Line 963: LAST_UPDATED_BY =FND_GLOBAL.USER_ID ,

959:
960:
961: update IEU_UWQ_MEDIA_TYPES_TL set
962: LANGUAGE = l_language,
963: LAST_UPDATED_BY =FND_GLOBAL.USER_ID ,
964: LAST_UPDATE_DATE = SYSDATE,
965: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
966: MEDIA_TYPE_NAME = rec_obj.media_type_name,
967: SOURCE_LANG = l_language,

Line 965: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

961: update IEU_UWQ_MEDIA_TYPES_TL set
962: LANGUAGE = l_language,
963: LAST_UPDATED_BY =FND_GLOBAL.USER_ID ,
964: LAST_UPDATE_DATE = SYSDATE,
965: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
966: MEDIA_TYPE_NAME = rec_obj.media_type_name,
967: SOURCE_LANG = l_language,
968: MEDIA_TYPE_DESCRIPTION = rec_obj.media_type_description
969: where MEDIA_TYPE_ID = rec_obj.media_type_id

Line 979: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

975: begin
976: select cli_plugin_id into temp_cli_plugin_id from IEU_UWQ_CLI_MED_PLUGINS where media_type_id = rec_obj.media_type_id;
977:
978: update IEU_UWQ_CLI_MED_PLUGINS set
979: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
980: LAST_UPDATE_DATE = SYSDATE,
981: LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID,
982: CLI_PLUGIN_CLASS = rec_obj.cli_plugin_class,
983: MEDIA_TYPE_ID = rec_obj.media_type_id,

Line 981: LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID,

977:
978: update IEU_UWQ_CLI_MED_PLUGINS set
979: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
980: LAST_UPDATE_DATE = SYSDATE,
981: LAST_UPDATE_LOGIN =FND_GLOBAL.LOGIN_ID,
982: CLI_PLUGIN_CLASS = rec_obj.cli_plugin_class,
983: MEDIA_TYPE_ID = rec_obj.media_type_id,
984: APPLICATION_ID = rec_obj.application_id
985: where CLI_PLUGIN_ID = temp_cli_plugin_id;

Line 1007: FND_GLOBAL.USER_ID,

1003: OBJECT_VERSION_NUMBER,
1004: APPLICATION_ID
1005: )
1006: values ( l_cli_plugin_id,
1007: FND_GLOBAL.USER_ID,
1008: SYSDATE,
1009: FND_GLOBAL.USER_ID,
1010: SYSDATE,
1011: FND_GLOBAL.LOGIN_ID,

Line 1009: FND_GLOBAL.USER_ID,

1005: )
1006: values ( l_cli_plugin_id,
1007: FND_GLOBAL.USER_ID,
1008: SYSDATE,
1009: FND_GLOBAL.USER_ID,
1010: SYSDATE,
1011: FND_GLOBAL.LOGIN_ID,
1012: rec_obj.media_type_id,
1013: rec_obj.cli_plugin_class,

Line 1011: FND_GLOBAL.LOGIN_ID,

1007: FND_GLOBAL.USER_ID,
1008: SYSDATE,
1009: FND_GLOBAL.USER_ID,
1010: SYSDATE,
1011: FND_GLOBAL.LOGIN_ID,
1012: rec_obj.media_type_id,
1013: rec_obj.cli_plugin_class,
1014: null,
1015: 1,

Line 1057: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1053:
1054:
1055:
1056: update IEU_UWQ_SVR_MPS_MMAPS set
1057: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1058: LAST_UPDATE_DATE = SYSDATE,
1059: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1060: SVR_TYPE_ID = rec_obj.svr_type_id
1061: where MEDIA_TYPE_ID = rec_obj.media_type_id;

Line 1059: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

1055:
1056: update IEU_UWQ_SVR_MPS_MMAPS set
1057: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1058: LAST_UPDATE_DATE = SYSDATE,
1059: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1060: SVR_TYPE_ID = rec_obj.svr_type_id
1061: where MEDIA_TYPE_ID = rec_obj.media_type_id;
1062:
1063:

Line 1078: FND_GLOBAL.USER_ID,

1074: OBJECT_VERSION_NUMBER,
1075: APPLICATION_ID
1076: )
1077: values ( l_svr_mps_plugin_id,
1078: FND_GLOBAL.USER_ID,
1079: SYSDATE,
1080: FND_GLOBAL.USER_ID,
1081: SYSDATE,
1082: FND_GLOBAL.LOGIN_ID,

Line 1080: FND_GLOBAL.USER_ID,

1076: )
1077: values ( l_svr_mps_plugin_id,
1078: FND_GLOBAL.USER_ID,
1079: SYSDATE,
1080: FND_GLOBAL.USER_ID,
1081: SYSDATE,
1082: FND_GLOBAL.LOGIN_ID,
1083: rec_obj.svr_type_id,
1084: rec_obj.svr_plugin_class,

Line 1082: FND_GLOBAL.LOGIN_ID,

1078: FND_GLOBAL.USER_ID,
1079: SYSDATE,
1080: FND_GLOBAL.USER_ID,
1081: SYSDATE,
1082: FND_GLOBAL.LOGIN_ID,
1083: rec_obj.svr_type_id,
1084: rec_obj.svr_plugin_class,
1085: null,
1086: 1,

Line 1098: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1094: select svr_type_id into temp_svr_type_id from ieu_uwq_svr_mps_plugins where svr_mps_plugin_id = rec_obj.svr_mps_plugin_id;
1095:
1096:
1097: update IEU_UWQ_SVR_MPS_MMAPS set
1098: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1099: LAST_UPDATE_DATE = SYSDATE,
1100: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1101: SVR_TYPE_ID = temp_svr_type_id
1102: where MEDIA_TYPE_ID = rec_obj.media_type_id;

Line 1100: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

1096:
1097: update IEU_UWQ_SVR_MPS_MMAPS set
1098: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1099: LAST_UPDATE_DATE = SYSDATE,
1100: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1101: SVR_TYPE_ID = temp_svr_type_id
1102: where MEDIA_TYPE_ID = rec_obj.media_type_id;
1103:
1104: EXCEPTION

Line 1128: FND_GLOBAL.USER_ID,

1124: SECURITY_GROUP_ID,
1125: OBJECT_VERSION_NUMBER
1126: )
1127: values ( l_svr_mps_mmap_id,
1128: FND_GLOBAL.USER_ID,
1129: SYSDATE,
1130: FND_GLOBAL.USER_ID,
1131: SYSDATE,
1132: FND_GLOBAL.LOGIN_ID,

Line 1130: FND_GLOBAL.USER_ID,

1126: )
1127: values ( l_svr_mps_mmap_id,
1128: FND_GLOBAL.USER_ID,
1129: SYSDATE,
1130: FND_GLOBAL.USER_ID,
1131: SYSDATE,
1132: FND_GLOBAL.LOGIN_ID,
1133: rec_obj.media_type_id,
1134: temp_svr_type_id,

Line 1132: FND_GLOBAL.LOGIN_ID,

1128: FND_GLOBAL.USER_ID,
1129: SYSDATE,
1130: FND_GLOBAL.USER_ID,
1131: SYSDATE,
1132: FND_GLOBAL.LOGIN_ID,
1133: rec_obj.media_type_id,
1134: temp_svr_type_id,
1135: null,
1136: null,

Line 1172: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1168:
1169:
1170: update IEU_CLI_PROV_PLUGIN_MED_MAPS set
1171: PLUGIN_ID = rec_obj.svr_mps_plugin_id,
1172: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1173: LAST_UPDATE_DATE = SYSDATE,
1174: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1175: where MEDIA_TYPE_ID = rec_obj.media_type_id;
1176:

Line 1174: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1170: update IEU_CLI_PROV_PLUGIN_MED_MAPS set
1171: PLUGIN_ID = rec_obj.svr_mps_plugin_id,
1172: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1173: LAST_UPDATE_DATE = SYSDATE,
1174: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1175: where MEDIA_TYPE_ID = rec_obj.media_type_id;
1176:
1177: if (sql%notfound) then
1178:

Line 1198: FND_GLOBAL.USER_ID,

1194: rec_obj.svr_mps_plugin_id,
1195: rec_obj.media_type_id,
1196: null,
1197: null,
1198: FND_GLOBAL.USER_ID,
1199: SYSDATE,
1200: SYSDATE,
1201: FND_GLOBAL.USER_ID,
1202: FND_GLOBAL.LOGIN_ID

Line 1201: FND_GLOBAL.USER_ID,

1197: null,
1198: FND_GLOBAL.USER_ID,
1199: SYSDATE,
1200: SYSDATE,
1201: FND_GLOBAL.USER_ID,
1202: FND_GLOBAL.LOGIN_ID
1203: );
1204: end if;
1205:

Line 1202: FND_GLOBAL.LOGIN_ID

1198: FND_GLOBAL.USER_ID,
1199: SYSDATE,
1200: SYSDATE,
1201: FND_GLOBAL.USER_ID,
1202: FND_GLOBAL.LOGIN_ID
1203: );
1204: end if;
1205:
1206:

Line 1228: FND_GLOBAL.USER_ID,

1224: LTRIM(RTRIM(rec_obj.svr_plugin_class)),
1225: 'Y',
1226: rec_obj.application_id,
1227: 1,
1228: FND_GLOBAL.USER_ID,
1229: SYSDATE,
1230: FND_GLOBAL.USER_ID,
1231: SYSDATE,
1232: FND_GLOBAL.LOGIN_ID

Line 1230: FND_GLOBAL.USER_ID,

1226: rec_obj.application_id,
1227: 1,
1228: FND_GLOBAL.USER_ID,
1229: SYSDATE,
1230: FND_GLOBAL.USER_ID,
1231: SYSDATE,
1232: FND_GLOBAL.LOGIN_ID
1233: );
1234:

Line 1232: FND_GLOBAL.LOGIN_ID

1228: FND_GLOBAL.USER_ID,
1229: SYSDATE,
1230: FND_GLOBAL.USER_ID,
1231: SYSDATE,
1232: FND_GLOBAL.LOGIN_ID
1233: );
1234:
1235: select IEU_CLI_PROV_PLUGIN_MED_MAP_S1.NEXTVAL into l_plugin_med_map_id from sys.dual;
1236:

Line 1254: FND_GLOBAL.USER_ID,

1250: l_plugin_id,
1251: rec_obj.media_type_id,
1252: null,
1253: 1,
1254: FND_GLOBAL.USER_ID,
1255: SYSDATE,
1256: SYSDATE,
1257: FND_GLOBAL.USER_ID,
1258: FND_GLOBAL.LOGIN_ID

Line 1257: FND_GLOBAL.USER_ID,

1253: 1,
1254: FND_GLOBAL.USER_ID,
1255: SYSDATE,
1256: SYSDATE,
1257: FND_GLOBAL.USER_ID,
1258: FND_GLOBAL.LOGIN_ID
1259: );
1260: end if;
1261:

Line 1258: FND_GLOBAL.LOGIN_ID

1254: FND_GLOBAL.USER_ID,
1255: SYSDATE,
1256: SYSDATE,
1257: FND_GLOBAL.USER_ID,
1258: FND_GLOBAL.LOGIN_ID
1259: );
1260: end if;
1261:
1262: