APPS.IEU_UWQ_MEDIA_TYPES_PVT dependencies on IEU_CLI_PROV_PLUGIN_MED_MAPS

Line 844: insert into IEU_CLI_PROV_PLUGIN_MED_MAPS

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,
848: CONDITIONAL_FUNC,

Line 1147: delete from IEU_CLI_PROV_PLUGIN_MED_MAPS where media_type_id = rec_obj.media_type_id;

1143:
1144: --delete an entry in client side media provider
1145: begin
1146:
1147: delete from IEU_CLI_PROV_PLUGIN_MED_MAPS where media_type_id = rec_obj.media_type_id;
1148:
1149: if (sql%notfound) then
1150: RAISE no_data_found;
1151:

Line 1164: --select PLUGIN_ID into temp_plugin_id from IEU_CLI_PROV_PLUGIN_MED_MAPS where

1160:
1161: else
1162: -- client side media provider
1163: begin
1164: --select PLUGIN_ID into temp_plugin_id from IEU_CLI_PROV_PLUGIN_MED_MAPS where
1165: -- MEDIA_TYPE_ID = rec_obj.media_type_id;
1166: if NOT(rec_obj.svr_mps_plugin_id IS NULL) then
1167:
1168:

Line 1170: update IEU_CLI_PROV_PLUGIN_MED_MAPS set

1166: if NOT(rec_obj.svr_mps_plugin_id IS NULL) then
1167:
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

Line 1181: insert into IEU_CLI_PROV_PLUGIN_MED_MAPS

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,
1184: MEDIA_TYPE_ID,
1185: CONDITIONAL_FUNC,

Line 1237: insert into IEU_CLI_PROV_PLUGIN_MED_MAPS

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,
1240: MEDIA_TYPE_ID,
1241: CONDITIONAL_FUNC,