Pre/Post Helper Processes for Batch Programs (prepost)
| 
                               Module Name  | 
                           
                               prepost.pc  | 
                        
| 
                               Description  | 
                           
                               Pre/Post Helper Processes for Batch Programs  | 
                        
| 
                               Functional Area  | 
                           
                               Administration  | 
                        
| 
                               Module Type  | 
                           
                               Business Processing  | 
                        
| 
                               Module Technology  | 
                           
                               ProC  | 
                        
| 
                               Catalog ID  | 
                           
                               N/A Individual pre/post jobs have Catalog IDs  | 
                        
| 
                               Wrapper Script  | 
                           
                               rmswrap.ksh  | 
                        
Design Overview
The pre/post module facilitates multi-threading by allowing general system administration functions (such as table deletions or mass updates) to be completed after all threads of a particular program have been processed.
This program will take three parameters: username/password to log on to Oracle, a program before or after which this script must run and an indicator telling whether the script is a pre or post function. It will act as a shell script for running all pre-program and post-program updates and purges (the logic was removed from the programs themselves to enable multi-threading and restart/recovery).
Pre/Post contains the following helper functions, which are should be individually scheduled with the related main programs.
Table 2-2 Pre/Post Helper Functions
| Catalog ID | Prepost Job | Related Main Program Catalog ID | Related Main Program | 
|---|---|---|---|
| 
                                  RMS400  | 
                              
                                  prepost rpl pre  | 
                              
                                  RMS315  | 
                              
                                  rplext  | 
                           
| 
                                  RMS401  | 
                              
                                  prepost salweek post  | 
                              
                                  RMS346  | 
                              
                                  salweek  | 
                           
| 
                                  RMS402  | 
                              
                                  prepost salmth post  | 
                              
                                  RMS343  | 
                              
                                  salmth  | 
                           
| 
                                  RMS403  | 
                              
                                  prepost rplapprv pre  | 
                              
                                  RMS300  | 
                              
                                  rplapprv  | 
                           
| 
                                  RMS404  | 
                              
                                  prepost rplatupd pre  | 
                              
                                  RMS313  | 
                              
                                  rplatupd  | 
                           
| 
                                  RMS405  | 
                              
                                  prepost rplatupd post  | 
                              
                                  RMS313  | 
                              
                                  rplatupd  | 
                           
| 
                                  RMS406  | 
                              
                                  prepost rilmaint pre  | 
                              
                                  RMS311  | 
                              
                                  rilmaint  | 
                           
| 
                                  RMS407  | 
                              
                                  prepost rilmaint post  | 
                              
                                  RMS311  | 
                              
                                  rilmaint  | 
                           
| 
                                  RMS408  | 
                              
                                  prepost supmth post  | 
                              
                                  RMS369  | 
                              
                                  supmth  | 
                           
| 
                                  RMS409  | 
                              
                                  prepost sccext post  | 
                              
                                  RMS355  | 
                              
                                  sccext  | 
                           
| 
                                  RMS410  | 
                              
                                  prepost hstbld pre  | 
                              
                                  RMS239  | 
                              
                                  hstbld  | 
                           
| 
                                  RMS411  | 
                              
                                  prepost hstbld post  | 
                              
                                  RMS239  | 
                              
                                  hstbld  | 
                           
| 
                                  RMS413  | 
                              
                                  prepost edidlprd post  | 
                              
                                  RMS47  | 
                              
                                  edidlprd  | 
                           
| 
                                  RMS414  | 
                              
                                  prepost edidlprd pre  | 
                              
                                  RMS47  | 
                              
                                  edidlprd  | 
                           
| 
                                  RMS417  | 
                              
                                  prepost cntrordb post  | 
                              
                                  RMS232  | 
                              
                                  cntrordb  | 
                           
| 
                                  RMS418  | 
                              
                                  prepost fsadnld post  | 
                              
                                  N/A  | 
                              
                                  N/A  | 
                           
| 
                                  RMS419  | 
                              
                                  prepost btchcycl  | 
                              
                                  N/A  | 
                              
                                  No related main process. Is used to enable DB policies that might have been disabled in order to run batch.  | 
                           
| 
                                  RMS421  | 
                              
                                  prepost poscdnld post  | 
                              
                                  N/A  | 
                              
                                  poscdnld  | 
                           
| 
                                  RMS423  | 
                              
                                  prepost htsupld pre  | 
                              
                                  N/A  | 
                              
                                  htsupld  | 
                           
| 
                                  RMS425  | 
                              
                                  prepost reclsdly pre  | 
                              
                                  RMS302  | 
                              
                                  reclsdly  | 
                           
| 
                                  RMS426  | 
                              
                                  prepost reclsdly post  | 
                              
                                  RMS302  | 
                              
                                  reclsdly  | 
                           
| 
                                  RMS427  | 
                              
                                  prepost ibcalc pre  | 
                              
                                  RMS249  | 
                              
                                  ibcalc  | 
                           
| 
                                  RMS428  | 
                              
                                  prepost fcstprg pre  | 
                              
                                  RMS227  | 
                              
                                  fcstprg  | 
                           
| 
                                  RMS429  | 
                              
                                  prepost fcstprg post  | 
                              
                                  RMS249  | 
                              
                                  fcstprg  | 
                           
| 
                                  RMS430  | 
                              
                                  prepost reqext pre  | 
                              
                                  RMS310  | 
                              
                                  reqext  | 
                           
| 
                                  RMS431  | 
                              
                                  prepost reqext post  | 
                              
                                  RMS310  | 
                              
                                  reqext  | 
                           
| 
                                  RMS432  | 
                              
                                  prepost stkupd pre  | 
                              
                                  N/A  | 
                              
                                  Stkupd  | 
                           
| 
                                  RMS433  | 
                              
                                  prepost replroq pre  | 
                              
                                  RMS308  | 
                              
                                  Replroq  | 
                           
| 
                                  RMS434  | 
                              
                                  prepost rplext post  | 
                              
                                  RMS315  | 
                              
                                  Rplext  | 
                           
| 
                                  RMS438  | 
                              
                                  prepost saleoh pre  | 
                              
                                  RMS337  | 
                              
                                  Saleoh  | 
                           
| 
                                  RMS440  | 
                              
                                  prepost salweek pre  | 
                              
                                  RMS346  | 
                              
                                  salweek  | 
                           
| 
                                  RMS441  | 
                              
                                  prepost dealinc pre  | 
                              
                                  RMS211  | 
                              
                                  Dealinc  | 
                           
| 
                                  RMS442  | 
                              
                                  prepost dealday pre  | 
                              
                                  RMS208  | 
                              
                                  dealday  | 
                           
| 
                                  RMS443  | 
                              
                                  prepost dealday post  | 
                              
                                  RMS208  | 
                              
                                  dealday  | 
                           
| 
                                  RMS444  | 
                              
                                  prepost dealact_nor pre  | 
                              
                                  RMS206  | 
                              
                                  Dealact  | 
                           
| 
                                  RMS445  | 
                              
                                  prepost dealact_po pre  | 
                              
                                  RMS206  | 
                              
                                  Dealact  | 
                           
| 
                                  RMS446  | 
                              
                                  prepost dealact_sales pre  | 
                              
                                  RMS206  | 
                              
                                  Dealact  | 
                           
| 
                                  RMS447  | 
                              
                                  prepost dealfct pre  | 
                              
                                  RMS209  | 
                              
                                  Dealfct  | 
                           
| 
                                  RMS448  | 
                              
                                  prepost dealcls post  | 
                              
                                  RMS209  | 
                              
                                  Dealcls  | 
                           
| 
                                  RMS449  | 
                              
                                  prepost hstbldmth post  | 
                              
                                  RMS241  | 
                              
                                  hstbldmth  | 
                           
| 
                                  RMS450  | 
                              
                                  prepost vendinvc pre  | 
                              
                                  N/A  | 
                              
                                  vendinvc  | 
                           
| 
                                  RMS451  | 
                              
                                  prepost vendinvf pre  | 
                              
                                  N/A  | 
                              
                                  vendinvf  | 
                           
| 
                                  RMS452  | 
                              
                                  prepost vendinvc post  | 
                              
                                  N/A  | 
                              
                                  vendinvc  | 
                           
| 
                                  RMS453  | 
                              
                                  prepost vendinvf post  | 
                              
                                  N/A  | 
                              
                                  vendinvf  | 
                           
| 
                                  RMS454  | 
                              
                                  prepost docclose pre  | 
                              
                                  RMS219  | 
                              
                                  docclose  | 
                           
| 
                                  RMS455  | 
                              
                                  prepost stkprg post  | 
                              
                                  RMS360  | 
                              
                                  stkprg  | 
                           
| 
                                  RMS456  | 
                              
                                  prepost wfordupld pre  | 
                              
                                  RMS392  | 
                              
                                  wfordupld  | 
                           
| 
                                  RMS457  | 
                              
                                  prepost wfretupld pre  | 
                              
                                  N/A  | 
                              
                                  wfretupld  | 
                           
| 
                                  RMS458  | 
                              
                                  prepost replsizeprofile pre  | 
                              
                                  RMS309  | 
                              
                                  replsizeprofile  | 
                           
| 
                                  RMS459  | 
                              
                                  prepost supsplit pre  | 
                              
                                  RMS370  | 
                              
                                  supsplit  | 
                           
| 
                                  RMS461  | 
                              
                                  prepost batch_ordcostcompupd pre  | 
                              
                                  RMS190  | 
                              
                                  batch_ordcostcompupd  | 
                           
| 
                                  RMS462  | 
                              
                                  prepost batch_ordcostcompupd post  | 
                              
                                  RMS190  | 
                              
                                  batch_ordcostcompupd  | 
                           
| 
                                  RMS463  | 
                              
                                  prepost batch_costcompupd post  | 
                              
                                  RMS190  | 
                              
                                  batch_ordcostcompupd  | 
                           
| 
                                  RMS465  | 
                              
                                  prepost dlyprg post  | 
                              
                                  RMS218  | 
                              
                                  dlyprg  | 
                           
| 
                                  RMS466  | 
                              
                                  prepost tsfprg pre  | 
                              
                                  RMS380  | 
                              
                                  tsfprg  | 
                           
| 
                                  RMS467  | 
                              
                                  prepost tsfprg post  | 
                              
                                  RMS380  | 
                              
                                  tsfprg  | 
                           
| 
                                  RMS468  | 
                              
                                  prepost fcexec pre  | 
                              
                                  RMS223  | 
                              
                                  fcexec  | 
                           
| 
                                  RMS469  | 
                              
                                  prepost start_batch pre  | 
                              
                                  N/A  | 
                              
                                  Sets the batch running ind to ‘Y' to limit front end use of the system.  | 
                           
| 
                                  RMS470  | 
                              
                                  prepost end_batch post  | 
                              
                                  N/A  | 
                              
                                  Sets the batch running ind to ‘N' to reenable all front end use of the system. This should be the last job in the batch cycle.  | 
                           
| 
                                  RMS488  | 
                              
                                  prepost btchcycl post  | 
                              
                                  N/A  | 
                              
                                  This job reenables all policies in the Merchandising owning schema.  | 
                           
| 
                                  RMS489  | 
                              
                                  prepost dealfct post  | 
                              
                                  RMS209  | 
                              
                                  Dealfct  | 
                           
| 
                                  prepost sitmain pre  | 
                              
                                  RMS357  | 
                              
                                  sitmain  | 
                           |
| 
                                  prepost sitmain post  | 
                              
                                  RMS357  | 
                              
                                  sitmain  |