DBA Data[Home] [Help]

APPS.IEU_UWQ_MEDIA_TYPES_PVT dependencies on DUAL

Line 614: select IEU_UWQ_MEDIA_TYPES_B_S2.NEXTVAL into l_media_type_id from sys.dual;

610: x_msg_data,
611: rec_obj, true);
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

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 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 727: select IEU_UWQ_SVR_MPS_PLUGINS_S2.NEXTVAL into l_svr_mps_plugin_id from sys.dual;

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,

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 817: select IEU_CLI_PROV_PLUGINS_S1.NEXTVAL into l_plugin_id from sys.dual;

813:
814: end if;
815: else
816: --client side media provider
817: select IEU_CLI_PROV_PLUGINS_S1.NEXTVAL into l_plugin_id from sys.dual;
818:
819: insert into IEU_CLI_PROV_PLUGINS
820: (PLUGIN_ID,
821: PLUGIN_CLASS_NAME,

Line 843: select IEU_CLI_PROV_PLUGIN_MED_MAP_S1.NEXTVAL into l_plugin_med_map_id from sys.dual;

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
845: (PLUGIN_MED_MAP_ID,
846: PLUGIN_ID,
847: MEDIA_TYPE_ID,

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 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 1052: select IEU_UWQ_SVR_MPS_PLUGINS_S2.NEXTVAL into l_svr_mps_plugin_id from sys.dual;

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

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 1179: select IEU_CLI_PROV_PLUGIN_MED_MAP_S1.NEXTVAL into l_plugin_med_map_id from sys.dual;

1175: where MEDIA_TYPE_ID = rec_obj.media_type_id;
1176:
1177: if (sql%notfound) then
1178:
1179: select IEU_CLI_PROV_PLUGIN_MED_MAP_S1.NEXTVAL into l_plugin_med_map_id from sys.dual;
1180:
1181: insert into IEU_CLI_PROV_PLUGIN_MED_MAPS
1182: (PLUGIN_MED_MAP_ID,
1183: PLUGIN_ID,

Line 1209: select IEU_CLI_PROV_PLUGINS_S1.NEXTVAL into l_plugin_id from sys.dual;

1205:
1206:
1207: else
1208:
1209: select IEU_CLI_PROV_PLUGINS_S1.NEXTVAL into l_plugin_id from sys.dual;
1210:
1211: insert into IEU_CLI_PROV_PLUGINS
1212: (PLUGIN_ID,
1213: PLUGIN_CLASS_NAME,

Line 1235: select IEU_CLI_PROV_PLUGIN_MED_MAP_S1.NEXTVAL into l_plugin_med_map_id from sys.dual;

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:
1237: insert into IEU_CLI_PROV_PLUGIN_MED_MAPS
1238: (PLUGIN_MED_MAP_ID,
1239: PLUGIN_ID,