DBA Data[Home] [Help]

APPS.IEU_UWQ_MEDIA_TYPES_PVT dependencies on IEU_UWQ_SVR_MPS_MMAPS

Line 63: v_svr_type_id IEU_UWQ_SVR_MPS_MMAPS.SVR_TYPE_ID%type;

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;
66:
67: v_svr_plugin_class IEU_UWQ_SVR_MPS_PLUGINS.SVR_PLUGIN_CLASS%type;

Line 93: ' IEU_UWQ_SVR_MPS_MMAPS svm, IEU_UWQ_SVR_MPS_PLUGINS svp ' ||

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:

Line 725: select IEU_UWQ_SVR_MPS_MMAPS_S2.NEXTVAL into l_svr_mps_mmap_id from sys.dual;

721: if rec_obj.is_server_side = 'Y' then
722:
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,

Line 728: insert into IEU_UWQ_SVR_MPS_MMAPS

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,
732: LAST_UPDATED_BY,

Line 786: select IEU_UWQ_SVR_MPS_MMAPS_S2.NEXTVAL into l_svr_mps_mmap_id from sys.dual;

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:
788: insert into IEU_UWQ_SVR_MPS_MMAPS
789: ( SVR_MPS_MMAP_ID,
790: CREATED_BY,

Line 788: insert into IEU_UWQ_SVR_MPS_MMAPS

784:
785:
786: select IEU_UWQ_SVR_MPS_MMAPS_S2.NEXTVAL into l_svr_mps_mmap_id from sys.dual;
787:
788: insert into IEU_UWQ_SVR_MPS_MMAPS
789: ( SVR_MPS_MMAP_ID,
790: CREATED_BY,
791: CREATION_DATE,
792: LAST_UPDATED_BY,

Line 1050: -- select IEU_UWQ_SVR_MPS_MMAPS_S2.NEXTVAL into l_svr_mps_mmap_id from sys.dual;

1046: if rec_obj.is_server_side = 'Y' then
1047:
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:

Line 1056: update IEU_UWQ_SVR_MPS_MMAPS set

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

Line 1097: update IEU_UWQ_SVR_MPS_MMAPS set

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,
1099: LAST_UPDATE_DATE = SYSDATE,
1100: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1101: SVR_TYPE_ID = temp_svr_type_id

Line 1113: select IEU_UWQ_SVR_MPS_MMAPS_S2.NEXTVAL into l_svr_mps_mmap_id from sys.dual;

1109: end;
1110:
1111: if (SQL%NOTFOUND) then
1112:
1113: select IEU_UWQ_SVR_MPS_MMAPS_S2.NEXTVAL into l_svr_mps_mmap_id from sys.dual;
1114: insert into IEU_UWQ_SVR_MPS_MMAPS
1115: ( SVR_MPS_MMAP_ID,
1116: CREATED_BY,
1117: CREATION_DATE,

Line 1114: insert into IEU_UWQ_SVR_MPS_MMAPS

1110:
1111: if (SQL%NOTFOUND) then
1112:
1113: select IEU_UWQ_SVR_MPS_MMAPS_S2.NEXTVAL into l_svr_mps_mmap_id from sys.dual;
1114: insert into IEU_UWQ_SVR_MPS_MMAPS
1115: ( SVR_MPS_MMAP_ID,
1116: CREATED_BY,
1117: CREATION_DATE,
1118: LAST_UPDATED_BY,

Line 1274: delete from IEU_UWQ_SVR_MPS_MMAPS where MEDIA_TYPE_ID = rec_obj.media_type_id;

1270: end;
1271:
1272: -- delete server side media provider
1273: begin
1274: delete from IEU_UWQ_SVR_MPS_MMAPS where MEDIA_TYPE_ID = rec_obj.media_type_id;
1275:
1276: if (sql%notfound) then
1277: RAISE no_data_found;
1278:

Line 1370: select svr_type_id into temp_svr_type_id from IEU_UWQ_SVR_MPS_MMAPS where MEDIA_TYPE_ID = x_media_type_id;

1366:
1367:
1368: begin
1369:
1370: select svr_type_id into temp_svr_type_id from IEU_UWQ_SVR_MPS_MMAPS where MEDIA_TYPE_ID = x_media_type_id;
1371:
1372:
1373: select count(MEDIA_TYPE_ID) into media_count from IEU_UWQ_SVR_MPS_MMAPS where svr_type_id = temp_svr_type_id;
1374:

Line 1373: select count(MEDIA_TYPE_ID) into media_count from IEU_UWQ_SVR_MPS_MMAPS where svr_type_id = temp_svr_type_id;

1369:
1370: select svr_type_id into temp_svr_type_id from IEU_UWQ_SVR_MPS_MMAPS where MEDIA_TYPE_ID = x_media_type_id;
1371:
1372:
1373: select count(MEDIA_TYPE_ID) into media_count from IEU_UWQ_SVR_MPS_MMAPS where svr_type_id = temp_svr_type_id;
1374:
1375: delete from IEU_UWQ_SVR_MPS_MMAPS
1376: where MEDIA_TYPE_ID = x_media_type_id;
1377:

Line 1375: delete from IEU_UWQ_SVR_MPS_MMAPS

1371:
1372:
1373: select count(MEDIA_TYPE_ID) into media_count from IEU_UWQ_SVR_MPS_MMAPS where svr_type_id = temp_svr_type_id;
1374:
1375: delete from IEU_UWQ_SVR_MPS_MMAPS
1376: where MEDIA_TYPE_ID = x_media_type_id;
1377:
1378:
1379: if (sql%notfound) then