APPS.BSC_CUSTOM_VIEW_UI_WRAPPER dependencies on BSC_SYS_IMAGES

Line 1109: BSC_SYS_IMAGES_PKG.INSERT_ROW (

1105: SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL INTO l_next_image_id FROM dual;
1106: x_image_id := l_next_image_id;
1107:
1108: BEGIN
1109: BSC_SYS_IMAGES_PKG.INSERT_ROW (
1110: X_IMAGE_ID => l_next_image_id,
1111: X_FILE_NAME => p_file_name,
1112: X_DESCRIPTION => p_description,
1113: X_WIDTH => p_width,

Line 1124: x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;

1120:
1121: EXCEPTION
1122: WHEN others THEN
1123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1124: x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;
1125: RAISE;
1126: END;
1127:
1128: BSC_SYS_IMAGES_MAP_PKG.INSERT_ROW (

Line 1128: BSC_SYS_IMAGES_MAP_PKG.INSERT_ROW (

1124: x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;
1125: RAISE;
1126: END;
1127:
1128: BSC_SYS_IMAGES_MAP_PKG.INSERT_ROW (
1129: X_ROWID => l_str,
1130: X_SOURCE_TYPE => 1,
1131: X_SOURCE_CODE => p_tab_id,
1132: X_TYPE => p_tab_view_id,

Line 1149: -- Create or udpate tab view's background in BSC_SYS_IMAGES and BSC_SYS_IMAGES_MAP_PKG

1145: RAISE;
1146: END create_tab_view_bg;
1147:
1148:
1149: -- Create or udpate tab view's background in BSC_SYS_IMAGES and BSC_SYS_IMAGES_MAP_PKG
1150: PROCEDURE add_or_update_tab_view_bg (
1151: p_tab_id IN NUMBER
1152: ,p_tab_view_id IN NUMBER
1153: ,p_image_id IN NUMBER

Line 1174: FROM BSC_SYS_IMAGES bsi, BSC_SYS_IMAGES_MAP_VL bsim

1170: fnd_msg_pub.initialize;
1171: x_return_status := FND_API.G_RET_STS_SUCCESS;
1172:
1173: SELECT count(1) INTO l_count
1174: FROM BSC_SYS_IMAGES bsi, BSC_SYS_IMAGES_MAP_VL bsim
1175: WHERE bsim.source_code = p_tab_id
1176: AND bsim.type = p_tab_view_id
1177: AND bsim.image_id = p_image_id
1178: AND bsim.image_id = bsi.image_id;

Line 1184: FROM BSC_SYS_IMAGES_MAP_TL

1180: if (l_count > 0)
1181: THEN
1182: --check if the image is owned by current NLS session
1183: SELECT count(1) INTO l_count
1184: FROM BSC_SYS_IMAGES_MAP_TL
1185: WHERE source_code = p_tab_id
1186: AND type = p_tab_view_id
1187: AND image_id = p_image_id
1188: AND source_lang = userenv('LANG');

Line 1195: UPDATE BSC_SYS_IMAGES

1191: --image owned by this NLS session, just simply update the same image
1192: x_image_id := p_image_id;
1193:
1194: BEGIN
1195: UPDATE BSC_SYS_IMAGES
1196: SET FILE_NAME = p_file_name,
1197: DESCRIPTION = p_description,
1198: WIDTH = p_width,
1199: HEIGHT = p_height,

Line 1211: x_msg_data := 'Update to BSC_SYS_IMAGES failed' || SQLERRM;

1207: EXCEPTION
1208: WHEN others THEN
1209: ROLLBACK TO RollBackPt;
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211: x_msg_data := 'Update to BSC_SYS_IMAGES failed' || SQLERRM;
1212: RETURN;
1213: END;
1214:
1215: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW (

Line 1215: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW (

1211: x_msg_data := 'Update to BSC_SYS_IMAGES failed' || SQLERRM;
1212: RETURN;
1213: END;
1214:
1215: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW (
1216: X_SOURCE_TYPE => 1,
1217: X_SOURCE_CODE => p_tab_id,
1218: X_TYPE => p_tab_view_id,
1219: X_IMAGE_ID => p_image_id,

Line 1233: BSC_SYS_IMAGES_PKG.INSERT_ROW (

1229: SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL INTO l_next_image_id FROM dual;
1230: x_image_id := l_next_image_id;
1231:
1232: BEGIN
1233: BSC_SYS_IMAGES_PKG.INSERT_ROW (
1234: X_IMAGE_ID => l_next_image_id,
1235: X_FILE_NAME => p_file_name,
1236: X_DESCRIPTION => p_description,
1237: X_WIDTH => p_width,

Line 1249: x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;

1245: EXCEPTION
1246: WHEN others THEN
1247: ROLLBACK TO RollBackPt;
1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1249: x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;
1250: RETURN;
1251: END;
1252:
1253: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW (

Line 1253: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW (

1249: x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;
1250: RETURN;
1251: END;
1252:
1253: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW (
1254: X_SOURCE_TYPE => 1,
1255: X_SOURCE_CODE => p_tab_id,
1256: X_TYPE => p_tab_view_id,
1257: X_IMAGE_ID => l_next_image_id,