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