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 IEU_UWQ_CLI_MED_PLUGINS

Line 59: v_cli_plugin_id IEU_UWQ_CLI_MED_PLUGINS.CLI_PLUGIN_ID%type;

55: v_media_type_name IEU_UWQ_MEDIA_TYPES_TL.MEDIA_TYPE_NAME%type;
56:
57: v_media_type_description IEU_UWQ_MEDIA_TYPES_TL.MEDIA_TYPE_DESCRIPTION%type;
58:
59: v_cli_plugin_id IEU_UWQ_CLI_MED_PLUGINS.CLI_PLUGIN_ID%type;
60:
61: v_cli_plugin_class IEU_UWQ_CLI_MED_PLUGINS.CLI_PLUGIN_CLASS%type;
62:
63: v_svr_type_id IEU_UWQ_SVR_MPS_MMAPS.SVR_TYPE_ID%type;

Line 61: v_cli_plugin_class IEU_UWQ_CLI_MED_PLUGINS.CLI_PLUGIN_CLASS%type;

57: v_media_type_description IEU_UWQ_MEDIA_TYPES_TL.MEDIA_TYPE_DESCRIPTION%type;
58:
59: v_cli_plugin_id IEU_UWQ_CLI_MED_PLUGINS.CLI_PLUGIN_ID%type;
60:
61: v_cli_plugin_class IEU_UWQ_CLI_MED_PLUGINS.CLI_PLUGIN_CLASS%type;
62:
63: v_svr_type_id IEU_UWQ_SVR_MPS_MMAPS.SVR_TYPE_ID%type;
64:
65: v_svr_mps_plugin_id IEU_UWQ_SVR_MPS_PLUGINS.SVR_MPS_PLUGIN_ID%type;

Line 92: ' b.SVR_LOGIN_RULE_ID, b.APPLICATION_ID,b.CLASSIFICATION_QUERY_PROC from IEU_UWQ_MEDIA_TYPES_B b, IEU_UWQ_MEDIA_TYPES_TL tl, IEU_UWQ_CLI_MED_PLUGINS cl, ' ||

88: v_is_server_side := 'N';
89:
90: v_selectStmt := ' select b.MEDIA_TYPE_ID, b.TEL_REQD_FLAG, tl.MEDIA_TYPE_NAME, tl.MEDIA_TYPE_DESCRIPTION, cl.CLI_PLUGIN_ID,' ||
91: ' cl.CLI_PLUGIN_CLASS, svm.SVR_TYPE_ID, svp.SVR_MPS_PLUGIN_ID, svp.SVR_PLUGIN_CLASS, b.MEDIA_TYPE_UUID, ' ||
92: ' b.SVR_LOGIN_RULE_ID, b.APPLICATION_ID,b.CLASSIFICATION_QUERY_PROC from IEU_UWQ_MEDIA_TYPES_B b, IEU_UWQ_MEDIA_TYPES_TL tl, IEU_UWQ_CLI_MED_PLUGINS cl, ' ||
93: ' IEU_UWQ_SVR_MPS_MMAPS svm, IEU_UWQ_SVR_MPS_PLUGINS svp ' ||
94: ' where b.MEDIA_TYPE_ID = tl.MEDIA_TYPE_ID and b.MEDIA_TYPE_ID = cl.MEDIA_TYPE_ID ' ||
95: ' and tl.LANGUAGE = '||''''||p_language||''''||' and b.MEDIA_TYPE_ID = svm.MEDIA_TYPE_ID ' ||
96: ' and svm.SVR_TYPE_ID = svp.SVR_TYPE_ID order by ' || p_order_by || ' ' || p_asc;

Line 395: select count(*) into cli_class_name_count from IEU_UWQ_CLI_MED_PLUGINS

391: x_return_status := FND_API.G_RET_STS_ERROR;
392: end if;
393:
394: if (rec_obj.cli_plugin_id IS NULL) then
395: select count(*) into cli_class_name_count from IEU_UWQ_CLI_MED_PLUGINS
396: where lower(CLI_PLUGIN_CLASS) like lower(temp_cli_class);
397:
398:
399:

Line 690: select IEU_UWQ_CLI_MED_PLUGINS_S2.NEXTVAL into l_cli_plugin_id from sys.dual;

686:
687: if NOT (rec_obj.cli_plugin_class IS NULL) then
688:
689:
690: select IEU_UWQ_CLI_MED_PLUGINS_S2.NEXTVAL into l_cli_plugin_id from sys.dual;
691:
692: insert into IEU_UWQ_CLI_MED_PLUGINS
693: ( CLI_PLUGIN_ID,
694: CREATED_BY,

Line 692: insert into IEU_UWQ_CLI_MED_PLUGINS

688:
689:
690: select IEU_UWQ_CLI_MED_PLUGINS_S2.NEXTVAL into l_cli_plugin_id from sys.dual;
691:
692: insert into IEU_UWQ_CLI_MED_PLUGINS
693: ( CLI_PLUGIN_ID,
694: CREATED_BY,
695: CREATION_DATE,
696: LAST_UPDATED_BY,

Line 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;

972:
973: if NOT (rec_obj.cli_plugin_class IS NULL) then
974:
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,

Line 978: update IEU_UWQ_CLI_MED_PLUGINS set

974:
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,

Line 992: select IEU_UWQ_CLI_MED_PLUGINS_S2.NEXTVAL into l_cli_plugin_id from sys.dual;

988: EXCEPTION
989:
990: WHEN NO_DATA_FOUND THEN
991:
992: select IEU_UWQ_CLI_MED_PLUGINS_S2.NEXTVAL into l_cli_plugin_id from sys.dual;
993: insert into IEU_UWQ_CLI_MED_PLUGINS
994: ( CLI_PLUGIN_ID,
995: CREATED_BY,
996: CREATION_DATE,

Line 993: insert into IEU_UWQ_CLI_MED_PLUGINS

989:
990: WHEN NO_DATA_FOUND THEN
991:
992: select IEU_UWQ_CLI_MED_PLUGINS_S2.NEXTVAL into l_cli_plugin_id from sys.dual;
993: insert into IEU_UWQ_CLI_MED_PLUGINS
994: ( CLI_PLUGIN_ID,
995: CREATED_BY,
996: CREATION_DATE,
997: LAST_UPDATED_BY,

Line 1026: select cli_plugin_id into temp_cli_plugin_id from IEU_UWQ_CLI_MED_PLUGINS where media_type_id = rec_obj.media_type_id;

1022:
1023: begin
1024:
1025:
1026: select cli_plugin_id into temp_cli_plugin_id from IEU_UWQ_CLI_MED_PLUGINS where media_type_id = rec_obj.media_type_id;
1027:
1028: delete from IEU_UWQ_CLI_MED_PLUGINS where cli_plugin_id = temp_cli_plugin_id;
1029:
1030: if (sql%notfound) then

Line 1028: delete from IEU_UWQ_CLI_MED_PLUGINS where cli_plugin_id = temp_cli_plugin_id;

1024:
1025:
1026: select cli_plugin_id into temp_cli_plugin_id from IEU_UWQ_CLI_MED_PLUGINS where media_type_id = rec_obj.media_type_id;
1027:
1028: delete from IEU_UWQ_CLI_MED_PLUGINS where cli_plugin_id = temp_cli_plugin_id;
1029:
1030: if (sql%notfound) then
1031: RAISE no_data_found;
1032:

Line 1360: delete from IEU_UWQ_CLI_MED_PLUGINS

1356: if (sql%notfound) then
1357: null;
1358: end if;
1359:
1360: delete from IEU_UWQ_CLI_MED_PLUGINS
1361: where MEDIA_TYPE_ID = x_media_type_id;
1362:
1363: if (sql%notfound) then
1364: null;