[Home] [Help]
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;
66:
67: v_svr_plugin_class IEU_UWQ_SVR_MPS_PLUGINS.SVR_PLUGIN_CLASS%type;
68:
69: v_media_type_uuid IEU_UWQ_MEDIA_TYPES_B.MEDIA_TYPE_UUID%type;
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;
66:
67: v_svr_plugin_class IEU_UWQ_SVR_MPS_PLUGINS.SVR_PLUGIN_CLASS%type;
68:
69: v_media_type_uuid IEU_UWQ_MEDIA_TYPES_B.MEDIA_TYPE_UUID%type;
70:
71: v_svr_login_rule_id IEU_UWQ_MEDIA_TYPES_B.SVR_LOGIN_RULE_ID%type;
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;
97:
441: if (rec_obj.svr_mps_plugin_id IS NULL) then
442:
443: if rec_obj.is_server_side = 'Y' then
444:
445: select count(*) into class_name_count from IEU_UWQ_SVR_MPS_PLUGINS
446: where lower(SVR_PLUGIN_CLASS) like lower(temp_svr_class);
447:
448:
449:
723: if rec_obj.svr_mps_plugin_id IS NULL then
724:
725: select IEU_UWQ_SVR_MPS_MMAPS_S2.NEXTVAL into l_svr_mps_mmap_id from sys.dual;
726:
727: select IEU_UWQ_SVR_MPS_PLUGINS_S2.NEXTVAL into l_svr_mps_plugin_id from sys.dual;
728: insert into IEU_UWQ_SVR_MPS_MMAPS
729: ( SVR_MPS_MMAP_ID,
730: CREATED_BY,
731: CREATION_DATE,
750: null,
751: 1
752: );
753:
754: insert into IEU_UWQ_SVR_MPS_PLUGINS
755: ( SVR_MPS_PLUGIN_ID,
756: CREATED_BY,
757: CREATION_DATE,
758: LAST_UPDATED_BY,
779:
780: else
781:
782:
783: 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;
784:
785:
786: select IEU_UWQ_SVR_MPS_MMAPS_S2.NEXTVAL into l_svr_mps_mmap_id from sys.dual;
787:
1048: if rec_obj.svr_mps_plugin_id IS NULL AND NOT (rec_obj.svr_type_id IS NULL) then
1049:
1050: -- select IEU_UWQ_SVR_MPS_MMAPS_S2.NEXTVAL into l_svr_mps_mmap_id from sys.dual;
1051:
1052: select IEU_UWQ_SVR_MPS_PLUGINS_S2.NEXTVAL into l_svr_mps_plugin_id from sys.dual;
1053:
1054:
1055:
1056: update IEU_UWQ_SVR_MPS_MMAPS set
1060: SVR_TYPE_ID = rec_obj.svr_type_id
1061: where MEDIA_TYPE_ID = rec_obj.media_type_id;
1062:
1063:
1064: insert into IEU_UWQ_SVR_MPS_PLUGINS
1065: ( SVR_MPS_PLUGIN_ID,
1066: CREATED_BY,
1067: CREATION_DATE,
1068: LAST_UPDATED_BY,
1090: elsif NOT (rec_obj.svr_mps_plugin_id IS NULL) AND rec_obj.svr_type_id IS NULL then
1091:
1092:
1093: begin
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,
1383:
1384:
1385: if media_count = 1 then
1386:
1387: delete from IEU_UWQ_SVR_MPS_PLUGINS
1388: where svr_type_id = temp_svr_type_id;
1389:
1390: if (sql%notfound) then
1391: null;