Lifecycle Management - Expert Oracle Application Express - page 397

Directory Description

src/apex/plugin

If our application uses any plug-ins, we will store them here.
Once you install a plug-in into your application, it will become
part of the application. You don't have to deploy it on the target
system because it will be included in the application export
automatically.

src/apex/workspace image In this folder we store all files (*.css, *.js, *.jpg, *.png, etc.) which

will be uploaded into the workspace (independent of a specific
application). They will be referenced in your application using
the #WORKSPACE IMAGES# <filename> syntax.

src/apex custom This is for the virtual directory on the application server, in the

web server you will create a virtual directory for that:
http:// <server> : <port> /apex custom/

src/apex custom/ <application name> All files that are referenced by the application are stored here
(*.css, *.js, *.jpg, *.png, etc.).

src/apex custom/ <application
name> /lib

We even store all explicitly referenced libraries here, even if this
means that we will have multiple copies on the application
server. The rationale behind this decision is to easily see all
dependencies of the application. This way an application can be
moved easily from one server to another, you will know which
files are relevant and which not.

src/apex custom/ <application
name> / <theme name>

Here we store the files that are relevant for our custom theme.
You could share the theme among all applications, then you
should store the theme here: src/apex custom/ <theme name>
Nevertheless, we store the theme locally with the application,
even in a redundant fashion. It gives you more control and you
are isolated from other developer's modifications on the shared
theme. Somebody might break your application when the
shared theme is modified.

src/java All Java source code files, if required.

src/jasper Any Jasper Report definition files, if required.

src/excel Any relevant Excel files or templates, if required.

src/sql Here we store all files that create or modify objects in the

database. Typically, this is PL/SQL code as well as SQL scripts.