/*MAIN
 Overview
 
 CP_LPOINTER is a sub-procedure of the main reconstruction procedure 
    RECONSTRUCTION1.  Its purpose is to add a new column to the GFST:
    LPOINTER.  This new column stores the long pointer, a unique 
    integer that points to a specific session (already archived or
    still online).
MAIN*/

/*ARGUMENTS
  Arguments
 
  CP_LPOINTER takes the following argument, which has an IN parameter
  mode:
   - GFST_EX (VARCHAR2).  This variable represents the name of the Good Frames 
     Statistics Table Expanded that was posted by Labview just prior to the onset 
     of reconstruction.  Entries in the GFST were built and logged into a script
     file during processing of the annotated minor frames file by AD.  Note that
     the original GFST is expanded during reconstruction because new columns 
     are created dynamically.
ARGUMENTS*/

/*DEPENDENCIES
 Dependencies
 
 The following are the procedures called by CP_LPOINTER (listed in their
 order of call):
   - SWITCH.  This is the package that manipulates the switches for all 
     the reconstruction rules.

   - RULES_STATES.  This is a package of three procedures and one function all
     of which track and post reconstruction states for all rules as they become
     available, in the temporary table LOGT.

   - RULE.  This is the stored package that manipulates the reconstruction rules
     numbers, name and version number.

   - OPEN_AND_PARSE.  This function combines what would otherwise have
     been separate calls to the native Oracle DBMS_SQL.OPEN_CURSOR and
     DBMS_SQL.PARSE procedures, into a single function.

   - EXECUTE_AND_CLOSE.  This function combines what would otherwise have
     been separate calls to the native Oracle DBMS_SQL.EXECUTE and
     DBMS_SQL.CLOSE procedures, into a single function.

   - LOG_FILE.  This is a package of procedures which handle the tasks of 
     creating the file in which reconstruction output messages will be written
     to, writing to the latter file, and closing it at the end of 
     reconstruction.
   
   - POST_STATE.  This is a package of three procedures and one function all
     of which serve the role of writing the states of all rules as they become
     available, in the system_state table.
DEPENDENCIES*/

/*VARIABLES
 Variables

 The following are variables used in the procedure:
   - C (INTEGER). Cursor handle.

   - EXECUTE1 (INTEGER).  The number of rows processed by the SQL statement
     if that statement is an UPDATE, INSERT, or DELETE.  If the SQL statement is
     not an UPDATE, INSERT, or DELETE, this value should be ignored.
VARIABLES*/

/*EXAMPLES
  Examples
 
  Here is a call to CP_LPOINTER:
 
   BEGIN
       CP_LPOINTER ('GEOTAIL1997274142242671GOOD');
   END;
   /

 The arguments of this procedure are passed in from Assembly/Decommutation. 
EXAMPLES*/

/*EXCEPTIONS
 Exceptions

 There are no named exceptions for this procedure, except for the generic one
   WHEN OTHERS.  When the latter is triggered, the error message is outputted
   along with the name of the module that erred, and any cursors that may still
   be opened are closed.  
EXCEPTIONS*/

/*ERRORS
 Errors

 There are no errors that this procedure is known to generate.  Should an
   error occur, take action based on the description of the error.
ERRORS*/

/*TABLES
 Tables
 
 The following tables are referenced in this procedure:
  - GFST_EX. This is the Expanded Good Frames Statistics Table that was posted by
    AD just prior to the onset of reconstruction.  It is expanded because during
    reconstruction more columns are added to the original GFST.

 For more information on these and other tables, see the documentation on tables.
TABLES*/

/*OTHERS
 Others
 
 For more details on this procedure see the reconstruction documentation.
OTHERS*/
