The following lines contain the word 'select', 'insert', 'update' or 'delete':
09-JUN-2005 A.Logue 115.15 Added PLSQL_PROC_INSERT.
20-MAY-2005 A.Logue 115.13 Added LAT_BAL_CHECK_MODE.
17-MAY-2005 A.Logue 115.13 Added RESET_PTO_ACCRUALS.
10-MAY-2005 A.Logue 115.12 Added HRLEGDEL_SLEEP.
09-MAY-2005 A.Logue 115.11 Added COST_API_IMODE.
05-MAY-2005 SuSivasu 115.10 Added ADVANCE_PAY_OFFSET.
26-APR-2005 A.Logue 115.9 Added US_ADVANCE_EARNING_TEMPLATE.
04-APR-2005 A.Logue 115.8 Added REV_LAT_BAL.
17-JAN-2005 A.Logue 115.7 Added RETRO_DELETE,
US_ADVANCED_WAGE_ATTACHMENT.
12-JAN-2005 A.Logue 115.6 Added ASSIGNMENT_SET_DATE,
TGL_REVB_ACC_DATE.
11-JAN-2005 A.Logue 115.5 Added SUPPRESS_INSIG_INDIRECTS
16-DEC-2004 D.Vickers 115.4 Added OLD_LOW_VOLUME
06-SEP-2004 A.Logue 115.3 Added further Parameters.
16-AUG-2004 A.Logue 115.2 Added further Parameters.
30-JUL-2004 N.Bristow 115.1 Added further Parameters.
24-JUL-2004 N.Bristow 115.0 Created.
*/
function check_act_param(parameter_name varchar2) return boolean is
begin
if (replace(parameter_name, ' ', '_')
in
(
'ADD_MAG_REP_FILES', -- Number of additional mag tape files that can be created
'ADVANCE_PAY_OFFSET', -- Obsoletes the arrear payroll and allows different offset payrolls for Advance Pay.
'ASSIGNMENT_SET_DATE', -- Whether date_earned context for assignment sets in eff date
'BAL_BUFFER_SIZE', -- Size of the Balance Buffer in the Payroll Run
'BEE_INTERVAL_WAIT_SEC',
'BEE_LOCK_INTERVAL_WAIT_SEC',
'BEE_LOCK_MAX_WAIT_SEC',
'BEE_MAX_WAIT_SEC',
'CHANGED_BALANCE_VALUE_CHECK', -- Disable changed balance value check
'CHUNK_SHUFFLE', -- Randomise the order in which chunks are processed Y/N
'CHUNK_SIZE', -- Size of the Chunks (Commit Units)
'COST_BUFFER_SIZE', -- Size of the Buffer used in Costing
'COST_API_IMODE', -- Use PL/SQL keyflex API in ID mode
'COST_DATE_PAID', -- Cost retro element on date paid.
'COST_NO_AT', -- Use PL/SQL keyflex API in non-autonomous transaction mode
'COST_PLS_VAL', -- Use PL/SQL keyflex validation Y/N
'COST_VAL_SEGS', -- Enable server side validation on the segment.
'COST_ZEROS', -- Enable costing of zero value run result values
'COSTBAL', -- Use hierarchy in Balance costs too
'DATA_MIGRATOR_MODE',
'DATA_PUMP_DISABLE_CONT_CALC',
'DATA_PUMP_NO_FND_AUDIT',
'DATA_PUMP_NO_LOOKUP_CHECKS',
'DBC_FILE', -- DBC File to use to get JAVA connection (used in Dev DBs only
'EE_BUFFER_SIZE', -- Element Entry Buffer size for Payroll Run
'EE_ORIG_TERM_RULE_DATE_FUNC', -- Use original functionality when deriving EE term rule dates
'FF_MAX_OPEN_CURSORS',
'FREQ_RULE_WHOLE_PERIOD',
'FREQ_RULE_TERM_EMP', -- Enable Frequency Rules for Terminated Emp
'GARN_DEBUG_ON', -- Debug Wage Attachment logic
'HR_DM_DEBUG_LOG',
'HR_DM_DEBUG_PIPE',
'HR_DU_DEBUG_LOG',
'HR_DU_DEBUG_PIPE',
'HRLEGDEL_SLEEP', -- Sleep Time for Disable HRMS Access
'INIT_PAY_ARCHIVE', -- Switch for data corruption workaround in Archive processes
'INTERLOCK', -- Use the assignment level interlocking procedures Y/N
'JP_DIM_EXC_REV_FLAG',
'JRE_VERBOSE', -- Java Debuging statements
'JRE_XMS', -- Java Min Heap Size
'JRE_XMX', -- Java Max Heap Size
'JRE_XSS', -- Java Min Shared Heap Size
'LAT_BAL_CHECK_MODE',
'LOGGING', -- Debug messaging level
'LOG_AREA', -- Procedure to Debug
'LOG_ASSIGN_END', -- Ending Assignment to Debug
'LOG_ASSIGN_START', -- Starting Assignment to Debug
'LOW_VOLUME', -- Use the Rule hint Y/N
'MANY_PROCS_IN_PERIOD',
'MAX_SINGLE_UNDO', -- Number od assignments that can be rolled back from the form
'MAX_ERRORS_ALLOWED', -- Maximum number of consecutive errors that can be encoutered before a full failure.
'MAX_ITERATIONS', -- Maximum number of attempted Runs in iteration
'MESSAGE_NAMES', -- Switch to only output message names instead of text (for test harness)
'OLD_LOW_VOLUME', -- Save for rule hint
'PAY_ACTION_PARAMETER_GROUPS', -- Use the new Grouping functionality Y/N
'PAYROLL_WF_NOTIFY_ACTION', -- Process Workflow wait switch
'PLSQL_PROC_INSERT', -- Enable/Disable PL/SQL based range processing code
'PPE_BATCH_SIZE', -- Batch Size for Purge Process Events
'PPE_BULK_LIMIT', -- Bulk Collect Size for Purge Process Events
'PPM_PERC_GTR_100', -- Sum of percentages in personal payment methods can be greater than 100
'PRINT_FILES', -- Use Concurrent request to print files
'PRINTER_MEM_SIZE', -- Overriding printer memory size in Kbytes
'PROCESS_TIMEOUT', -- Time in minutes before a process times out.
'PROCOST', -- Costing of Proration.
'PUMP_DEBUG_LEVEL',
'PUMP_DT_ENFORCE_FOREIGN_LOCKS',
'PURGE_SKIP_TERM_ASG', -- Skip Terminated Assignments in Purge Y/N
'PURGE_TIMEOUT', -- Time in SECONDS before Purge will timeout.
'QUICKPAY_INTERVAL_WAIT_SEC',
'QUICKPAY_MAX_WAIT_SEC',
'RANGE_PERSON_ID', -- Switch to use person_id in pay_population_ranges
'REMOVE_ACT', -- switch to disable the deletion of Reoprt assignment actions
'REPORT_URL', -- location used for the report output url.
'RESET_PTO_ACCRUALS',
'RETRO_DELETE', -- Avoid delete of run results in Retropay
'RETRO_POP_COST_KEYFLEX', -- Retropay by Element populate cost keyflex_id from orig
'RETRO_RECALC_ALL_COMP',
'REV_LAT_BAL', -- Reversals maintain Latest Balances
'RR_BUFFER_SIZE', -- Run Result Buffer size for the Payroll Run
'RRV_BUFFER_SIZE', -- Run Result Value size for the Payroll Run
'RUN_XDO', -- Run XDO interface
'SET_DATE_EARNED', -- Set the Date Earned on child processes, Default N
'STD_FILE_NAME', -- Use the Standard payroll filenaming convention Y/N
'SUPPRESS_INSIG_INDIRECTS', -- Suppress creation of insignifcant indirect run results
'TAX_CACHE_SIZE', -- Quantum Cache size
'TAX_CHECK_OVERRIDE', -- Quantum Override Version checking
'TAX_DATA', -- Quantum Location of Taxation files
'TAX_DEBUG_FLAG', -- Quantum Switch debugging on
'TAX_LIBRARIES', -- Quantum Location of the Libaries
'TGL_DATE_USED', -- Date to transfer Run on (date_earned, effective_date)
'TGL_GROUP_ID', -- Populate group_id in gl_interface
'TGL_REVB_ACC_DATE', -- Date to transfer Reversals and Balance Adjustments
'TGL_SLA_MODE', -- Switch for use of Sub Ledger Accounting
'THREADS', -- Number of Slave processes to use
'TRACE', -- Switch Database Tracing on Y/N
'TRACE_LEVEL', -- Trace Level to use
'TRANSGL_THREAD', -- Switch for Multi-threded TGL version
'TR_BUFFER_SIZE', -- Taxability Rules Bufffer size for Payroll Run
'US_ADVANCE_EARNING_TEMPLATE', -- Switch for US Earning Element Template
'US_ADVANCED_WAGE_ATTACHMENT', -- Switch for US Wage Attachment functionality
'USER_MESSAGING', -- Switch User Messaging on Y/N
'UTF8_RESTRICTION_MODE',
'VOID_REVERSAL_SET_CHQOVR', -- Used by void and reversal process to set cheque override asg set id
'WAGE_ACCUMULATION_ENABLED', -- Switch for Enhanced Wage Accumulation functionality on Y/N
'WAGE_ACCUMULATION_YEAR', -- YEAR YYYY on which Wage Accukulation enabled
'JRE_LIBRARY', --location of libraries for dynamic linking in c-code
'US_SOE_VIEW_FROM_ASG_FP_SCREEN', -- Switch for US SOE
'PDF_TEMP_DIR', -- temp dir for pdf merging
'BALANCES_DISPLAY_ALL_GRES', -- Bug 9380771. Hidden Featre for GSI to
-- display all Gre's in the US tax balance
-- formas.
'PROC_REG_SAL_INACT', -- This parameter is used to override the
-- check for the Assignment status of
-- ACTIVE_ASSIGNMETN wehn determining to
-- the Regular Salary / Wages Fast formula.
'VAL_BKPAY_COST_ON_RUN_DATE' -- Validate backpay cost combination on run date
)
)
then
return true;