/*MAIN
 Overview
 
 PWIW_ORDER_TIME is a sub-procedure of the main reconstruction procedure 
    RECONSTRUCTION1.  When turned on, this procedure reverses the time order in
    which the data will be processed, from spacecraft time to ground receipt
    time.  The latter is done by transposing the FP_UMNFGR_DATETIME column of 
    BFST to the FP_UMF_DATETIME column, and the FP_UMFGR_DATETIME columm of the
    GFST to the FP_UMF_DATETIME column.  
MAIN*/

/*ARGUMENTS
  Arguments
 
  PWIW_ORDER_TIME takes the following arguments, all of which have an IN 
  parameter mode:
   - GFST (VARCHAR2).  This variable represents the name of the Good Frames
     Statistics Table 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.

   - BFST (VARCHAR2).  This variable represents the name of the bad Frames 
     Statistics Table that was posted by Labview just prior to the onset of 
     reconstruction.  Entries in the BFST were built and logged into a script
     file during processing of the annotated minor frames file by AD.
ARGUMENTS*/

/*DEPENDENCIES
 Dependencies
 
 The following are the procedures called by PWIW_ORDER_TIME (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 PWIW_ORDER_TIME:
 
   BEGIN
       PWIW_ORDER_TIME ('PWIW1997287095646983GOOD','PWIW1997287095644634BAD');
   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. This is the Good Frames Statistics Table that was posted by
    AD just prior to the onset of reconstruction.

  - BFST. This is the Bad Frame statistics Table that was posted by AD
    just prior to the onset of reconstruction.

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

/*OTHERS
 Others
 
 It should be noted that changing the time order of frame is currently only a 
   requirement for the PWIW instrument of the POLAR spacecraft, therefore this
   rule is only turned on to process PWIW data by ground receipt time rather 
   than by spacecraft time.

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