1 package body pay_action_parameters_pkg as
2 /* $Header: pyactpar.pkb 120.27.12010000.2 2008/09/09 10:41:33 pparate ship $*/
3 --
4 /*
5 Copyright (c) Oracle Corporation 1993,1994,1995. All rights reserved
6
7 /*
8
9 Name : pyactpar.pkb
10 Description : procedures required fofor check to pay_olegislation_rules
11 Author : N.Bristow
12 Date Created : 20-NOV-2003
13
14 Change List
15 -----------
16 Date Name Vers Bug No Description
17 +-----------+--------------+--------+---------+-----------------------+
18 09-SEP-2008 P.Parate 115.42 7279918 Added COST_DATE_PAID
19 23-NOV-2006 A.Logue 115.41 Added COST_ZEROS.
20 18-JUN-2007 ckesanap 115.38 6065892 Added WAGE_ACCUMULATION_ENABLED
21 01-FEB-2007 T.Battoo 115.37 Added PDF_TEMP_DIR
22 03-NOV-2006 S.Winton 115.36 5616075 Added EE_ORIG_TERM_RULE_DATE_FUNC.
23 24-OCT-2006 A.Logue 115.35 Added PRINT_FILES.
24 14-SEP-2006 N.Bristow 115.34 Removed JRE_LIBRARY.
25 22-AUG-2006 N.Bristow 115.33 Added REPORT_URL.
26 10-AUG-2006 A.Logue 115.32 Added CHANGED_BALANCE_VALUE_CHECK.
27 27-JUN-2006 T.Battoo 115.31 Added JRE_LIBRARY.
28 09-JUN-2006 A.Logue 115.30 5295555 Added REMOVE_ACT.
29 05-MAY-2006 N.Bristow 115.29 Added SET_DATE_EARNED.
30 17-APR-2006 A.Handa 115.28 5136327 Added US_SOE_VIEW_FROM_ASG_FP_SCREEN.
31 16-MAR-2006 A.Logue 115.27 5092363 Added COST_NO_AT.
32 17-FEB-2006 A.Logue 115.26 5044463 Added PAYROLL_WF_NOTIFY_ACTION.
33 09-JAN-2006 A.Logue 115.25 4919912 Added INIT_PAY_ARCHIVE.
34 21-DEC-2005 T.Habara 115.24 4726174 Added PURGE_SKIP_TERM_ASG.
35 09-DEC-2005 M.Reid 115.23 4871533 Added PURGE_TIMEOUT.
36 29-NOV-2005 SuSivasu 115.22 Added COST_VAL_SEG.
37 22-NOV-2005 A.Logue 115.21 Added TGL_SLA_MODE.
38 21-NOV-2005 N.Bristow 115.20 Added PRINTER_MEM_SIZE
39 and DBC_FILE.
40 20-SEP-2005 A.Logue 115.19 Added TGL_GROUP_ID.
41 12-SEP-2005 nbristow 115.18 Added JRE_LIBRARY.
42 03-Aug-2005 SuSivasu 115.17 Added FREQ_RULE_WHOLE_PERIOD.
43 13-JUN-2005 A.Logue 115.16 Added MANY_PROCS_IN_PERIOD.
44 09-JUN-2005 A.Logue 115.15 Added PLSQL_PROC_INSERT.
45 20-MAY-2005 A.Logue 115.13 Added LAT_BAL_CHECK_MODE.
46 17-MAY-2005 A.Logue 115.13 Added RESET_PTO_ACCRUALS.
47 10-MAY-2005 A.Logue 115.12 Added HRLEGDEL_SLEEP.
48 09-MAY-2005 A.Logue 115.11 Added COST_API_IMODE.
49 05-MAY-2005 SuSivasu 115.10 Added ADVANCE_PAY_OFFSET.
50 26-APR-2005 A.Logue 115.9 Added US_ADVANCE_EARNING_TEMPLATE.
51 04-APR-2005 A.Logue 115.8 Added REV_LAT_BAL.
52 17-JAN-2005 A.Logue 115.7 Added RETRO_DELETE,
53 US_ADVANCED_WAGE_ATTACHMENT.
54 12-JAN-2005 A.Logue 115.6 Added ASSIGNMENT_SET_DATE,
55 TGL_REVB_ACC_DATE.
56 11-JAN-2005 A.Logue 115.5 Added SUPPRESS_INSIG_INDIRECTS
57 16-DEC-2004 D.Vickers 115.4 Added OLD_LOW_VOLUME
58 06-SEP-2004 A.Logue 115.3 Added further Parameters.
59 16-AUG-2004 A.Logue 115.2 Added further Parameters.
60 30-JUL-2004 N.Bristow 115.1 Added further Parameters.
61 24-JUL-2004 N.Bristow 115.0 Created.
62 */
63
64 function check_act_param(parameter_name varchar2) return boolean is
65 begin
66 if (replace(parameter_name, ' ', '_')
67 in
68 (
69 'ADD_MAG_REP_FILES', -- Number of additional mag tape files that can be created
70 'ADVANCE_PAY_OFFSET', -- Obsoletes the arrear payroll and allows different offset payrolls for Advance Pay.
71 'ASSIGNMENT_SET_DATE', -- Whether date_earned context for assignment sets in eff date
72 'BAL_BUFFER_SIZE', -- Size of the Balance Buffer in the Payroll Run
73 'BEE_INTERVAL_WAIT_SEC',
74 'BEE_LOCK_INTERVAL_WAIT_SEC',
75 'BEE_LOCK_MAX_WAIT_SEC',
76 'BEE_MAX_WAIT_SEC',
77 'CHANGED_BALANCE_VALUE_CHECK', -- Disable changed balance value check
78 'CHUNK_SHUFFLE', -- Randomise the order in which chunks are processed Y/N
79 'CHUNK_SIZE', -- Size of the Chunks (Commit Units)
80 'COST_BUFFER_SIZE', -- Size of the Buffer used in Costing
81 'COST_API_IMODE', -- Use PL/SQL keyflex API in ID mode
82 'COST_DATE_PAID', -- Cost retro element on date paid.
83 'COST_NO_AT', -- Use PL/SQL keyflex API in non-autonomous transaction mode
84 'COST_PLS_VAL', -- Use PL/SQL keyflex validation Y/N
85 'COST_VAL_SEGS', -- Enable server side validation on the segment.
86 'COST_ZEROS', -- Enable costing of zero value run result values
87 'COSTBAL', -- Use hierarchy in Balance costs too
88 'DATA_MIGRATOR_MODE',
89 'DATA_PUMP_DISABLE_CONT_CALC',
90 'DATA_PUMP_NO_FND_AUDIT',
91 'DATA_PUMP_NO_LOOKUP_CHECKS',
92 'DBC_FILE', -- DBC File to use to get JAVA connection (used in Dev DBs only
93 'EE_BUFFER_SIZE', -- Element Entry Buffer size for Payroll Run
94 'EE_ORIG_TERM_RULE_DATE_FUNC', -- Use original functionality when deriving EE term rule dates
95 'FF_MAX_OPEN_CURSORS',
96 'FREQ_RULE_WHOLE_PERIOD',
97 'HR_DM_DEBUG_LOG',
98 'HR_DM_DEBUG_PIPE',
99 'HR_DU_DEBUG_LOG',
100 'HR_DU_DEBUG_PIPE',
101 'HRLEGDEL_SLEEP', -- Sleep Time for Disable HRMS Access
102 'INIT_PAY_ARCHIVE', -- Switch for data corruption workaround in Archive processes
103 'INTERLOCK', -- Use the assignment level interlocking procedures Y/N
104 'JP_DIM_EXC_REV_FLAG',
105 'JRE_VERBOSE', -- Java Debuging statements
106 'JRE_XMS', -- Java Min Heap Size
107 'JRE_XMX', -- Java Max Heap Size
108 'JRE_XSS', -- Java Min Shared Heap Size
109 'LAT_BAL_CHECK_MODE',
110 'LOGGING', -- Debug messaging level
111 'LOG_AREA', -- Procedure to Debug
112 'LOG_ASSIGN_END', -- Ending Assignment to Debug
113 'LOG_ASSIGN_START', -- Starting Assignment to Debug
114 'LOW_VOLUME', -- Use the Rule hint Y/N
115 'MANY_PROCS_IN_PERIOD',
116 'MAX_SINGLE_UNDO', -- Number od assignments that can be rolled back from the form
117 'MAX_ERRORS_ALLOWED', -- Maximum number of consecutive errors that can be encoutered before a full failure.
118 'MAX_ITERATIONS', -- Maximum number of attempted Runs in iteration
119 'MESSAGE_NAMES', -- Switch to only output message names instead of text (for test harness)
120 'OLD_LOW_VOLUME', -- Save for rule hint
121 'PAY_ACTION_PARAMETER_GROUPS', -- Use the new Grouping functionality Y/N
122 'PAYROLL_WF_NOTIFY_ACTION', -- Process Workflow wait switch
123 'PLSQL_PROC_INSERT', -- Enable/Disable PL/SQL based range processing code
124 'PRINT_FILES', -- Use Concurrent request to print files
125 'PRINTER_MEM_SIZE', -- Overriding printer memory size in Kbytes
126 'PROCESS_TIMEOUT', -- Time in minutes before a process times out.
127 'PROCOST', -- Costing of Proration.
128 'PUMP_DEBUG_LEVEL',
129 'PUMP_DT_ENFORCE_FOREIGN_LOCKS',
130 'PURGE_SKIP_TERM_ASG', -- Skip Terminated Assignments in Purge Y/N
131 'PURGE_TIMEOUT', -- Time in SECONDS before Purge will timeout.
132 'QUICKPAY_INTERVAL_WAIT_SEC',
133 'QUICKPAY_MAX_WAIT_SEC',
134 'RANGE_PERSON_ID', -- Switch to use person_id in pay_population_ranges
135 'REMOVE_ACT', -- switch to disable the deletion of Reoprt assignment actions
136 'REPORT_URL', -- location used for the report output url.
137 'RESET_PTO_ACCRUALS',
138 'RETRO_DELETE', -- Avoid delete of run results in Retropay
139 'RETRO_POP_COST_KEYFLEX', -- Retropay by Element populate cost keyflex_id from orig
140 'RETRO_RECALC_ALL_COMP',
141 'REV_LAT_BAL', -- Reversals maintain Latest Balances
142 'RR_BUFFER_SIZE', -- Run Result Buffer size for the Payroll Run
143 'RRV_BUFFER_SIZE', -- Run Result Value size for the Payroll Run
144 'RUN_XDO', -- Run XDO interface
145 'SET_DATE_EARNED', -- Set the Date Earned on child processes, Default N
146 'STD_FILE_NAME', -- Use the Standard payroll filenaming convention Y/N
147 'SUPPRESS_INSIG_INDIRECTS', -- Suppress creation of insignifcant indirect run results
148 'TAX_CACHE_SIZE', -- Quantum Cache size
149 'TAX_CHECK_OVERRIDE', -- Quantum Override Version checking
150 'TAX_DATA', -- Quantum Location of Taxation files
151 'TAX_DEBUG_FLAG', -- Quantum Switch debugging on
152 'TAX_LIBRARIES', -- Quantum Location of the Libaries
153 'TGL_DATE_USED', -- Date to transfer Run on (date_earned, effective_date)
154 'TGL_GROUP_ID', -- Populate group_id in gl_interface
155 'TGL_REVB_ACC_DATE', -- Date to transfer Reversals and Balance Adjustments
156 'TGL_SLA_MODE', -- Switch for use of Sub Ledger Accounting
157 'THREADS', -- Number of Slave processes to use
158 'TRACE', -- Switch Database Tracing on Y/N
159 'TRACE_LEVEL', -- Trace Level to use
160 'TRANSGL_THREAD', -- Switch for Multi-threded TGL version
161 'TR_BUFFER_SIZE', -- Taxability Rules Bufffer size for Payroll Run
162 'US_ADVANCE_EARNING_TEMPLATE', -- Switch for US Earning Element Template
163 'US_ADVANCED_WAGE_ATTACHMENT', -- Switch for US Wage Attachment functionality
164 'USER_MESSAGING', -- Switch User Messaging on Y/N
165 'UTF8_RESTRICTION_MODE',
166 'WAGE_ACCUMULATION_ENABLED', -- Switch for Enhanced Wage Accumulation functionality on Y/N
167 'JRE_LIBRARY', --location of libraries for dynamic linking in c-code
168 'US_SOE_VIEW_FROM_ASG_FP_SCREEN', -- Switch for US SOE
169 'PDF_TEMP_DIR' -- temp dir for pdf merging
170 )
171 )
172 then
173 return true;
174 else
175 return false;
176 end if;
177 end;
178
179 begin
180 null;
181 end;