[Home] [Help]
PACKAGE BODY: APPS.PAY_LEGISLATION_RULES_PKG
Source
1 package body pay_legislation_rules_pkg as
2 /* $Header: pylegrul.pkb 120.9.12020000.2 2012/07/06 11:54:19 vmaripal ship $*/
3 --
4 /*
5 Copyright (c) Oracle Corporation 1993,1994,1995. All rights reserved
6
7 /*
8
9 Name : pylegrul.pkb
10 Description : procedures required to check for pay_legislation_rules
11
12 Change List
13 -----------
14 Date Name Vers Bug No Description
15 +-----------+--------------+--------+---------+-----------------------+
16 14-MAR-2001 T.Battoo 115.0 created
17 21-DEC-2001 RThirlby 115.2 Added new rule SEED_FEEDS
18 and dbdrv lines.
19 27-DEC-2001 KKawol 115.3 Added ENABLE_QP_OFFSET and
20 removed PDO. This is to enable
21 positive offset processing.
22 07-JAN-2002 NBristow 115.4 Added RUN_RETRO_FORMULA for
23 the control of retropay
24 elements.
25 14-JAN-2002 KKawol 115.7 Put PDO back in. Bug 2182484.
26 12-FEB-2002 KKawol Added FREQ_RULE_DATE to allow
27 freq rule calculation as of check date.
28 09-APR-2002 NBristow 115.9 Added rule DEFAULT_RUN_TYPE.
29 26-JUL-2002 nbristow 115.10 Added rule SAVE_RUN_BAL.
30 30-AUG-2002 nbristow 115.11 Added rule DYNAMIC_TAX_UNIT.
31 13-SEP-2002 RThirlby 115.12 Added rule BAL_CATEGORY_MANDATORY.
32 09-OCT-2002 JHobbs 115.13 Added rule BAL_INIT_VALIDATION
33 10-OCT-2002 ALogue 115.14 Added rule PAY_ACTION_PARAMETER_GROUPS
34 16-OCT-2002 NBristow 115.15 Added SAVE_ASG_RUN_BAL.
35 20_NOV-2002 NBristow 115.16 Added MULTI_TAX_UNIT_PAYMENT
36 16-JAN-2003 NBristow 115.17 Added JURISDICTION_IV
37 28-FEB-2003 ALogue 115.18 Added RETRO_STD_CONTEXTS
38 05-MAR-2003 ALogue 115.19 Added SUPPRESS_INSIG_INDIRECTS
39 20-MAR-2003 ALogue 115.20 Added RETRO_CONTEXT_OVERRIDE
40 20-MAR-2003 NBristow 115.21 Added RETRO_DELETE
41 05-SEP-2003 KKawol 115.22 Added ADVANCED_RETRO,
42 RETRO_TU_CONTEXT,CWK_S,CWK_SDL
43 17-OCT-2003 NBristow 115.23 Added RR_SPARSE.
44 14-Nov-2003 SuSivasu 115.24 Added ADV_EE_SUBPRIORITY.
45 14-JAN-2004 jford 115.26 Added RETRO_COMP_DFLT_OVERRIDE
46 02-MAR-2004 nbristow 115.27 Added ITERATE_DYN_GRS_FACTOR_FLAG.
47 02-MAR-2004 nbristow 115.28 Renamed ITERATE_DYN_GRS_FACTOR_FLAG
48 to ITERATE_DYN_HI_GRS_FACTOR.
49 20-APR-2004 thabara 115.29 Added BAL_INIT_INCLUDE_ADJ.
50 06-AUG-2004 tbattoo 115.30 Added PRENOTE_DEFAULT.
51 25-AUG-2004 jford 115.31 Added RETRO_STATUS_USER_UPD
52 06-SEP-2004 nbristow 115.32 Added MULTITHREAD_MAGPAY
53 and MAGTAPE_FILE_SAVE
54 10-Dec-2004 SuSivasu 115.33 Added OVERRIDE_CHEQUE_DATE
55 08-Apr-2005 M.Reid 115.34 Added PAYSLIP_MODE
56 22-APR-2005 NBristow 115.35 Added LOCAL_UNIT_CONTEXT
57 11-MAY-2005 NBristow 115.36 Added NON_ORACLE_LOC
58 31-AUG-2005 ARashid 115.36 Added FF_TRANSLATE_DATABASE_ITEMS
59 02-MAR-2006 NBristow 115.38 Added REHIRE_BEFORE_FPD and
60 AMEND_HIRE_WITH_PAYACT for
61 Core HR.
62 22-MAR-2006 TBattoo 115.39 Added RETRO_LABEL_ENTRY
63 27-JUN-2006 TBattoo 115.40 Added ADDITIONAL_CHQ_DATA
64 and XML_FILE_CREATION_NO
65 16-OCT-2006 NBristow 115.41 Added PRINT_FILES
66 24-OCT-2006 ALogue 115.42 Remove PRINT_FILES
67 05-JAN-2007 NBristow 115.43 Added RETRO_OVERLAP.
68 14-FEB-2007 SuSivasu 115.44 Added TIME_PERIOD_ID.
69 10-SEP-2007 KKawol 115.45 Added ADJUST_RETRO_INDIRECT.
70 27-DEC-2011 vpallapo 115.46 Added RETRO_DYNAMIC_TIMESPAN
71 */
72
73 function check_leg_rule(rule_type varchar2) return boolean is
74 begin
75 if (rule_type in ('L', 'ADA_DIS', 'ADA_DIS_ACC', 'S', 'A',
76 'D', 'P', 'C', 'I', 'DC', 'SDL', 'ENABLE_QP_OFFSET', 'E', 'OSHA', 'SSP',
77 'PAY_ADVANCE_INDICATOR', 'ADVANCE_INDICATOR', 'ADVANCE','PAI_START_DATE',
78 'PAI_END_DATE','AI_DEFER_PAY_FLAG', 'AI_ADVANCE_FLAG','ADV_CLEARUP',
79 'ADVOUTS_BAL','DEFERPAY_BAL', 'ADVSRC_BAL','DEFER_PAY',
80 'ADV_CLEARUP_OFFSET', 'ADV_DEDUCTION_DEDUCTION',
81 'ADV_DEDUCTION','PDR', 'PAYWSACT_SOE', 'PAYWSDPM_TPP',
82 'PAYWSDET_TPB', 'PAYWSDET_BEN', 'PAYWSRQP_DS', 'PERWSMMV_GRE',
83 'PERWSDCL_OSHA', 'PERWSDCL_ADA', 'ACTION_CONTEXTS',
84 'LEGISLATION_CHECK_FORMULA', 'SOE','SOURCE_IV',
85 'DEFAULT_JURISDICTION','TAX_UNIT', 'RETROELEMENT_CHECK',
86 'PAYWSDPG_OFFSET1', 'PAYWSDPG_OFFSET2', 'PAYWSDPG_OFFSET3',
87 'PAYWSDPG_OFFSET4', 'RUN_TYPE_FLAG', 'PROC_SEPARATE_IV',
88 'PROC_RUN_METH_IV', 'PROC_RUN_METH_VALUE', 'SEP_CHEQUE_IV',
89 'BALANCE_DBITEM_TYPE', 'PTO_BALANCE_TYPE', 'ADJUSTMENT_EE_SOURCE',
90 'SOURCE_TEXT_IV', 'BAL_ADJ_LAT_BAL','SKIP_TERMINATED_ASG', 'SEED_FEEDS',
91 'RUN_RETRO_FORMULA','PDO', 'FREQ_RULE_DATE', 'DEFAULT_RUN_TYPE',
92 'DYNAMIC_TAX_UNIT', 'SAVE_RUN_BAL', 'BAL_CATEGORY_MANDATORY',
93 'BAL_INIT_VALIDATION','PAY_ACTION_PARAMETER_GROUPS', 'SAVE_ASG_RUN_BAL',
94 'MULTI_TAX_UNIT_PAYMENT', 'JURISDICTION_IV', 'RETRO_STD_CONTEXTS',
95 'SUPPRESS_INSIG_INDIRECTS','RETRO_CONTEXT_OVERRIDE', 'RETRO_DELETE',
96 'ADVANCED_RETRO','RETRO_TU_CONTEXT','CWK_S','CWK_SDL', 'RR_SPARSE',
97 'ADV_EE_SUBPRIORITY','RETRO_COMP_DFLT_OVERRIDE',
98 'ITERATE_DYN_HI_GRS_FACTOR', 'BAL_INIT_INCLUDE_ADJ','PRENOTE_DEFAULT',
99 'RETRO_STATUS_USER_UPD', 'MULTITHREAD_MAGPAY', 'MAGTAPE_FILE_SAVE',
100 'OVERRIDE_CHEQUE_DATE', 'PAYSLIP_MODE', 'LOCAL_UNIT_CONTEXT',
101 'NON_ORACLE_LOC', 'FF_TRANSLATE_DATABASE_ITEMS',
102 'REHIRE_BEFORE_FPD', -- Core HR Legislation Rule
103 'AMEND_HIRE_WITH_PAYACT',-- Core HR Legislation Rule
104 'RETRO_ENTRY_LABEL','ADE_ENTRY_LABEL','ADDITIONAL_CHQ_DATA','XML_FILE_CREATION_NO',
105 'RETRO_OVERLAP','TIME_PERIOD_ID',
106 'ADJUST_RETRO_INDIRECT','RETRO_DYNAMIC_TIMESPAN'
107 ))
108 then
109 return true;
110 else
111 return false;
112 end if;
113 end;
114
115 begin
116 null;
117 end;