Geometry of the Space of Phylogenetic Trees LouisJ. Billera

Geometry of the Space of Phylogenetic Trees LouisJ. Billera

-

English
518 Pages
Read
Download
Downloading requires you to have access to the YouScribe library
Learn all about the services we offer

Description

  • fiche de synthèse - matière potentielle : the paper
Geometry of the Space of Phylogenetic Trees Louis J. Billera Department of Mathematics, Malott Hall, Cornell University, Ithaca, NY 14853 E-mail: and Susan P. Holmes INRA, Montpellier, France and Department of Statistics, Stanford University, Stanford, CA 94305 E-mail: and Karen Vogtmann Department of Mathematics, Malott Hall, Cornell University, Ithaca, NY 14853 E-mail: vogtmann@math.
  • geometric model for tree space
  • data from difierent genes
  • branch lengths of the trees
  • single tree
  • dna sequence
  • regions
  • tree
  • trees
  • space
  • data

Subjects

Informations

Published by
Reads 17
Language English
Document size 4 MB
Report a problem

Implementing
Oracle HRMS
(Canada)
RELEASE 11i
November 2001Implementing Oracle HRMS (Canada) Release 11i
The part number for this book is A95904–01.
Copyright 1996, 2000, 2001 Oracle Corporation. All rights reserved.
Contributing Authors: Louise Raffo, Juliette Fleming, John Cafolla and Alison Chambers.
Contributors: Bill Kerr, John Thuringer and Janet Harrington–Kuller.
The Programs (which include both the software and documentation) contain proprietary
information of Oracle Corporation; they are provided under a license agreement containing
restrictions on use and disclosure and are also protected by copyright, patent and other
intellectual property law. Reverse engineering of the Programs is prohibited. No part of this
document may be reproduced or transmitted in any form or by any means, electronic or
mechanical, for any purpose, without the express written permission of Oracle Corporation.
Program Documentation is licensed for use solely to support the deployment of the
Programs and not for any other purpose.
The information contained in this document is subject to change without notice. If you find
any problems in the documentation, please report them to us in writing. Oracle Corporation
does not warrant that this document is error free. Except as may be expressly permitted in
your license agreement for these Programs, no part of these Programs may be reproduced or
transmitted in any form or by any means, electronic or mechanical, for any purpose, without
the express written permission of Oracle Corporation.
If the Programs are delivered to the US Government or anyone licensing or
using the Programs on behalf of the US government, the following notice is
applicable:
RESTRICTED RIGHTS NOTICE
Programs delivered subject to the DOD FAR Supplement are ‘commercial
computer software’ and use, duplication and disclosure of the Programs
including documentation, shall be subject to the licensing restrictions set forth
in the applicable Oracle license agreement. Otherwise, Programs delivered
subject to the Federal Acquisition Regulations are ‘restricted computer software’
and use, duplication and disclosure of the Programs shall be subject to the
restrictions in FAR 52.227–19, Commercial Computer Software – Restricted
Rights (June 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA
94065.
The Programs are not intended for use in any nuclear, aviation, mass transit,
medical, or other inherently dangerous applications. It shall be licensee’s
responsibility to take all appropriate fail–safe, back–up redundancy and other
measures to ensure the safe use of such applications if the Programs are used for
such purposes, and Oracle disclaims liability for any damages caused by such
use of the Programs.
Oracle is a registered trademark, and Oracle Financials, Oracle Discoverer,
OracleMetalink, PL/SQL, and SQL*Plus, are trademarks or registered
trademarks of Oracle Corporation. Other names may be trademarks of their
respective owners. Contents
Preface Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xi
Audience for This Guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xii
How To Use This Guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xii
Do Not Use Database Tools to Modify Oracle
Applications Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxi
About Oracle. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxi
Your Feedback. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxii
PART I IMPLEMENTATION
Chapter 1 Planning Your Implementation . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 –1
Implementation Steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 –2
Implementation Checklist . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 –4
Implementation Flowchart . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 –5
Chapter 2 Implementation Steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –1
Post Install Steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –2
DataInstall . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –2
AutoPatch (adpatch) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –3
Administration 2 –7
Key Flexfields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –7
Descriptive Flexfields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –22
Extra Information Types (EITs) . . . . . . . . . . . . . . . . . . . . . . . . . 2 –25
Contents iiiSystem Administration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –26
Application Data Exchange (ADE) . . . . . . . . . . . . . . . . . . . . . . 2 –27
Work Structures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –28
Define Organization Structures . . . . . . . . . . . . . . . . . . . . . . . . . 2 –28
Define Jobs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –32
Set Up Workflow for Transactions 2 –32
Enable Position Control . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –36
Set up Positions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –36
Define Grade Related Information . . . . . . . . . . . . . . . . . . . . . . 2 –38
Define Payroll Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –40
Compensation and Benefits 2 –42
Define Input Value Validation . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –42
Define Compensation and Benefits . . . . . . . . . . . . . . . . . . . . . 2 –43
Define Earnings and Deductions for Payroll Processing . . . 2 –45
Configure the Generated Definitions . . . . . . . . . . . . . . . . . . . . 2 –48
Salary Administration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –49
Absence Management and Accruals of Paid Time Off (PTO) 2 –51
Element Sets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –54
Total Compensation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –56
Administration 2 –56
Benefits Eligibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –56
Derived Eligibility Factors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –57
Eligibility Profiles 2 –59
Define Life Events (Advanced Benefits) . . . . . . . . . . . . . . . . . 2 –59
Program Setup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –60
Enrollment Requirements 2 –62
Activity Rates and Coverage Calculations . . . . . . . . . . . . . . . 2 –63
Reporting Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –65
Flex Credit Calculations (Advanced Benefits) . . . . . . . . . . . . 2 –65
Administration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –66
Define Online Benefits Services . . . . . . . . . . . . . . . . . . . . . . . . . 2 –66
People and Assignments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –67
Person Types and Assignment Statuses . . . . . . . . . . . . . . . . . . 2 –67
Special Personal Information (Personal Analysis
Key Flexfield Structures) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –67
Medical Assessments, Disabilities and Work Incidents . . . . 2 –70
Specific Business Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –71
Workers Compensation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –71
Provincial Medical (PMED) . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –72
Vacation Banking . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –73
Human Resource Budgets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –73
Evaluation Systems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –74
iv Implementing Oracle HRMS (Canada)Requirements Matching . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –75
Career and Succession Management . . . . . . . . . . . . . . . . . . . . . . . . 2 –77
Recruitment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –77
Career Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –77
Evaluations and Appraisals . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –80
Career and Succession Planning 2 –81
Control . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –83
Define Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –83
Standard Letter Generation 2 –83
Configure the People Management Templates . . . . . . . . . . . . 2 –87e Oracle HRMS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –88
Create Task Flows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –89
Define Menus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –91
Define User Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –93
Define Audit Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 –98
PART II TECHNICAL ESSAYS
Chapter 3 DateTrack . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 –1
How DateTrack Works . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 –2
Behavior of DateTracked Forms . . . . . . . . . . . . . . . . . . . . . . . . 3 –2
Table Structure for DateTracked Tables . . . . . . . . . . . . . . . . . . 3 –4
Creating a DateTracked Table and View . . . . . . . . . . . . . . . . . 3 –5
Restricting Datetrack Options Available to Forms Users . . . 3 –7
Create and Modify DateTrack History Views . . . . . . . . . . . . . . . . 3 –10
What Can You Create and Modify? . . . . . . . . . . . . . . . . . . . . . 3 –10
What Happens When You Request DateTrack History? . . . . 3 –10
Rules for Creating or Modifying DateTrack History Views . 3 –11
Using Alternative DateTrack History Views . . . . . . . . . . . . . . 3 –12
List of DateTrack History Views . . . . . . . . . . . . . . . . . . . . . . . . 3 –15
Chapter 4 Batch Element Entry . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 –1
Creating Control Totals for the Batch Element Entry Process . . . 4 –2
Setting Up Control Totals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 –2
Creating the SQL Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 –2
Chapter 5 Payroll Processes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –1
Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –2
Contents vPYUGEN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –2
Payroll Action Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –4
Overview of the Payroll Processes . . . . . . . . . . . . . . . . . . . . . . 5 –4
Assignment Level Interlocks . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –5
Payroll Run Process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –6
Determine Assignments and Elements . . . . . . . . . . . . . . . . . . 5 –6
Process Each Assignment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –7
Create Run Results and Values . . . . . . . . . . . . . . . . . . . . . . . . . 5 –9
Set Up Contexts 5 –9
Run Element Skip Rules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –10
Create and Maintain Balances . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –10
Run Formulas . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –13
Pre–Payments Process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –18
Setting Up Payment Methods 5 –18
Consolidation Sets 5 –19
Third Party Payments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –19
Exchange Rates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –20
Overriding Payment Method . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –20
The Process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –21
Payment Processes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –23
Magnetic Tape Process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –24
Running the Magnetic Tape Payments Process . . . . . . . . . . . 5 –24
Running Magnetic Tape Reports . . . . . . . . . . . . . . . . . . . . . . . . 5 –26
SRS Definitions 5 –27
How the Magnetic Tape Process Works . . . . . . . . . . . . . . . . . . 5 –28
The PL/SQL Driving Procedure 5 –30
The Generic PL/SQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –31
The Formula Interface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –36
Error Handling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –38
Example PL/SQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –39
Cheque Writer/Check Writer Process . . . . . . . . . . . . . . . . . . . . . . . 5 –43
The Process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –43
Cheque Numbering . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –46
Voiding and Reissuing Cheques . . . . . . . . . . . . . . . . . . . . . . . . 5 –47
Mark for Retry . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –48
Rolling Back the Payments . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –48
SRW2 Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –48
Using or Changing the PL/SQL Procedure . . . . . . . . . . . . . . 5 –50
Payroll Action Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –52
Action Parameter Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –52
Summary of Action Parameters . . . . . . . . . . . . . . . . . . . . . . . . 5 –52
vi Implementing Oracle HRMS (Canada)Parallel Processing Parameters . . . . . . . . . . . . . . . . . . . . . . . . . 5 –53
Array Select, Update and Insert Buffer Size Parameters . . . . 5 –54
Costing Specific Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –55
Magnetic Tape Specific Parameters . . . . . . . . . . . . . . . . . . . . . 5 –56
Error Reporting Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –56
Rollback Specific Parameters 5 –57
Payroll Process Logging . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –57
Logging Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –59
Miscellaneous Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –60
System Management of QuickPay Processing . . . . . . . . . . . . 5 –61
Assignment Level Interlocks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –63
Action Classifications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –63
Rules For Rolling Back and Marking for Retry . . . . . . . . . . . . 5 –66
Transfer to the General Ledger Process . . . . . . . . . . . . . . . . . . . . . . 5 –68
Costing Process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 –69
Example of Payroll Costs Allocation . . . . . . . . . . . . . . . . . . . . 5 –69
Example of Employer Charge Distribution . . . . . . . . . . . . . . . 5 –70
Chapter 6 The Payroll Archive Reporter (PAR) Process . . . . . . . . . . . . . . . . 6 –1
PAR Modes 6 –2
Overview of the PAR Process . . . . . . . . . . . . . . . . . . . . . . . . . . 6 –3
Overview of the Setup Steps . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 –3
Create Database Items for Archiving . . . . . . . . . . . . . . . . . . . . 6 –4
Write Formulas . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 –8
Write Package Procedures For Assignments And
Assignment Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 –8
Provide an SRS Definition for the PAR Process . . . . . . . . . . . 6 –10
Populate Rows in the
PAY_REPORT_FORMAT_MAPPINGS_F Table 6 –11
Examples: INITIALIZATION_CODE and
ARCHIVE_CODE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 –13
Chapter 7 Balances in Oracle Payroll . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 –1
Overview of Balances . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 –2
Latest Balances . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 –3
Balance Dimensions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 –5
Initial Balance Loading for Oracle Payroll . . . . . . . . . . . . . . . . . . . 7 –9
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 –9
Steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 –10
Balance Loading Process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 –10
Latest Balances 7 –11
Contents viiSetting Up an Element to Feed Initial Balances . . . . . . . . . . . 7 –12
Setting Up the Initial Balance Values . . . . . . . . . . . . . . . . . . . . 7 –13
Running the Initial Balance Upload Process . . . . . . . . . . . . . . 7 –17
Balance Initialization Steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 –21
Including Balance Values in Reports . . . . . . . . . . . . . . . . . . . . . . . . 7 –24
The Balance Function . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 –24
Chapter 8 FastFormula . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 –1
The FastFormula Application Dictionary . . . . . . . . . . . . . . . . . . . . 8 –2
Entities in the Dictionary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 –2
Defining New Database Items . . . . . . . . . . . . . . . . . . . . . . . . . . 8 –5
Calling FastFormula from PL/SQL . . . . . . . . . . . . . . . . . . . . . . . . . 8 –14
The Execution Engine Interface 8 –14
Changes in R11i . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 –16
Server Side Interface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 –16
Client Side Call Interface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 –21
Special Forms Call Interface . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 –24
Logging Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 –26
Chapter 9 Validation of Flexfield Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 –1
Referencing User Profile Options . . . . . . . . . . . . . . . . . . . . . . . 9 –2
Referencing Form block.field Items . . . . . . . . . . . . . . . . . . . . . 9 –4
Referencing FND_SESSIONS Row . . . . . . . . . . . . . . . . . . . . . . 9 –5
Incomplete Context Field Value Lists . . . . . . . . . . . . . . . . . . . . 9 –6
Chapter 10 Extending Security in Oracle HRMS . . . . . . . . . . . . . . . . . . . . . . . 10 –1
Security Profiles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 –2ocesses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 –8
Securing Custom Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 –11
Chapter 11 APIs in Oracle HRMS 11 –1
API Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 –3
Understanding the Object Version Number (OVN) . . . . . . . 11 –6
API Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 –8
API Features . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 –23
Flexfields with APIs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 –24
Multilingual Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 –25
Alternative APIs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 –26
API Errors and Warnings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 –28
viii Implementing Oracle HRMS (Canada)Example PL/SQL Batch Program . . . . . . . . . . . . . . . . . . . . . . . 11 –30
WHO Columns and Oracle Alert 11 –33
API User Hooks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 –34
Using APIs as Building Blocks . . . . . . . . . . . . . . . . . . . . . . . . . 11 –55
Handling Object Version Numbers in Oracle Forms . . . . . . . 11 –56
Chapter 12 Oracle HRMS Data Pump . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 –1
Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 –3
Using Data Pump . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 –7
Running the Meta–Mapper . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 –8
Loading Data Into the Batch Tables . . . . . . . . . . . . . . . . . . . . . 12 –14
Running the Data Pump Process . . . . . . . . . . . . . . . . . . . . . . . 12 –17
Finding and Fixing Errors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 –18
Purging Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 –22
Sample Code 12 –23
Notes on Using The Generated Interfaces . . . . . . . . . . . . . . . . 12 –26
Utility Procedures Available With Data Pump . . . . . . . . . . . . 12 –29
Table and View Descriptions . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 –31
Chapter 13 Oracle Generic Third Party Payroll Backfeed . . . . . . . . . . . . . . . 13 –1
Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 –4
Setting Up the Generic Payroll Backfeed . . . . . . . . . . . . . . . . . . . . 13 –5
Installing the Oracle Generic Third Party Payroll Backfeed . 13 –5
Payment Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 –7
Balance Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 –7
APIs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 –9
Setting Up Data Pump . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 –9
Deciding Which Upload Option to Use . . . . . . . . . . . . . . . . . . 13 –10
Setting Up Data Uploader . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 –11
Using Backfeed to Upload Payroll Run Results . . . . . . . . . . . . . . . 13 –16
Creating an Upload Workbook . . . . . . . . . . . . . . . . . . . . . . . . . 13 –16
Using the Load Sheets Macro . . . . . . . . . . . . . . . . . . . . . . . . . . 13 –17
Using the Save Sheets Macro . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 –18
Running Data Uploader . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 –19
Running Data Pump . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 –19
Viewing Third Party Payroll Results in Oracle HRMS . . . . . . . . . 13 –21
Reference Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 –23
Data Pump Functions for Backfeed . . . . . . . . . . . . . . . . . . . . . 13 –23
Table Descriptions 13 –25
Data Pump Generated Packages and Views . . . . . . . . . . . . . . 13 –30
Contents ixBusiness Process APIs Used by Backfeed . . . . . . . . . . . . . . . . 13 –37
Chapter 14 SQL Trace . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 –1
Using SQL Trace . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 –2
Enabling SQL Trace . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 –3
Locating the Trace File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 –7
What is TKPROF? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 –8
Formatting a Trace File using TKPROF . . . . . . . . . . . . . . . . . . 14 –9
TKPROF Sort Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 –11
Understanding a TKPROF Report . . . . . . . . . . . . . . . . . . . . . . 14 –12
Raw SQL Trace File Example . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 –19
Advanced SQL Tracing Using Event 10046 . . . . . . . . . . . . . . . 14 –19
Glossary
Index
x Implementing Oracle HRMS (Canada)