1 package hr_user_init_dedn AUTHID CURRENT_USER as
2 /* $Header: pyusuidt.pkh 120.0.12010000.1 2008/07/27 23:58:16 appldev ship $ */
3 /*
4 +======================================================================+
5 | Copyright (c) 1993 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +======================================================================+
9 */
10
11 /*
12 ******************************************************************
13 * *
14 * Copyright (C) 1993 Oracle Corporation. *
15 * All rights reserved. *
16 * *
17 * This material has been provided pursuant to an agreement *
18 * containing restrictions on its use. The material is also *
19 * protected by copyright law. No part of this material may *
20 * be copied or distributed, transmitted or transcribed, in *
21 * any form or by any means, electronic, mechanical, magnetic, *
22 * manual, or otherwise, or disclosed to third parties without *
23 * the express written permission of Oracle Corporation, *
24 * 500 Oracle Parkway, Redwood City, CA, 94065. *
25 * *
26 ******************************************************************
27
28 Name : hr_user_init_dedn
29 Filename : pyusuidt.pkh
30 Change List
31 -----------
32 Date Name Vers Bug No Description
33 ---- ---- ---- ------ -----------
34 29-OCT-93 H.Parichabutr 1.0 First Created.
35 Initial Procedures
36 04-NOV-93 hparicha 1.1 Completed initial version;
37 Added locking and delete
38 procedures.
39 14-JUN-95 hparicha 40.6 286491 Deletion of all balances via
40 assoc bal ids held in
41 ELEMENT_INFORMATIONxx columns.
42 New params to "do_deletions".
43 ??? ??? 40.7
44
45 5-Nov-1996 hparicha 40.8 413211 Added params to deletion
46 procedure to handle latest
47 dedn configurations - esp.
48 30-APR-98 pmadore 40.9 Added additional parameters
49 for employer match
50 and Aftertax Component
51 25-Mar-02 ekim 115.3 Added p_termination_rule to
52 ins_deduction_template
53 27-DEC-2002 meshah 115.4 fixed gscc warnings.
54 */
55
56 /* NOTE:
57 Data used for certain inserts depend on the calculation method
58 (or Amount Rule for deductions)
59 selected. Calls to these procedures may be bundled in a procedure
60 that will handle putting together a logical set of calls - ie.
61 instead of repeating the same logic in each of the insert procedures,
62 the logic can be performed once and the appropriate calls made
63 immediately. The data involved includes input values, status
64 processing rules, formula result rules, and skip rules.
65 See ins_uie_formula below.
66
67 Also note, *could* make insertion (and validation) procedures
68 externally callable. Consider usefulness of such a design.
69 */
70
71 /*
72 ---------------------------------------------------------------------
73 This package contains calls to core API used to insert records comprising an
74 entire deduction template.
75
76 The procedures responsible for creating
77 appropriate records based on data entered on the User-Initiated Deductions form
78 must perform simple logic to determine the exact attributes required for the
79 deduction template. Attributes (and their determining factors) are:
80 - skip rules (Start Rule, Deduction Frequency): will be determined
81 during insert of ele type.
82 - calculation formulas (Amount Rule, EE Bond, Arrearage, Stop Rule)
83 - status processing rules (CalcMeth)
84 - input values (Class/Cat, Calc Method)
85 - formula result rules (CalcMeth)
86 ---------------------------------------------------------------------
87 */
88
89 -- Legislation Subgroup Code for all template elements.
90 g_template_leg_code VARCHAR2(30) := 'US';
91 g_template_leg_subgroup VARCHAR2(30) := 'TEMPLATE';
92 --
93 -- Controlling procedure that calls all insert procedures according to
94 -- locking ladder. May perform some simple logic. More involved logic
95 -- is handled inside various insertion procedures as required,
96 -- especially ins_uie_formula_processing.
97 FUNCTION ins_deduction_template (
98 p_ele_name in varchar2,
99 p_ele_reporting_name in varchar2,
100 p_ele_description in varchar2 default NULL,
101 p_ele_classification in varchar2,
102 p_ben_class_id in number,
103 p_ele_category in varchar2 default NULL,
104 p_ele_processing_type in varchar2,
105 p_ele_priority in number default NULL,
106 p_ele_standard_link in varchar2 default 'N',
107 p_ele_proc_runtype in varchar2,
108 p_ele_start_rule in varchar2,
109 p_ele_stop_rule in varchar2,
110 p_ele_ee_bond in varchar2 default 'N',
111 p_ele_amount_rule in varchar2,
112 p_ele_paytab_name in varchar2 default NULL,
113 p_ele_paytab_col in varchar2 default NULL,
114 p_ele_paytab_row_type in varchar2 default NULL,
115 p_ele_arrearage in varchar2 default 'N',
116 p_ele_partial_dedn in varchar2 default 'N',
117 p_mix_flag in varchar2 default NULL,
118 p_ele_er_match in varchar2 default 'N',
119 p_ele_at_component in varchar2 default 'N',
120 p_ele_eff_start_date in date default NULL,
121 p_ele_eff_end_date in date default NULL,
122 p_bg_id in number,
123 p_termination_rule in varchar2 default 'F'
124 ) RETURN NUMBER;
125 --
126 PROCEDURE lock_template_rows (
127 p_ele_type_id in number,
128 p_ele_eff_start_date in date default NULL,
129 p_ele_eff_end_date in date default NULL,
130 p_ele_name in varchar2,
131 p_ele_reporting_name in varchar2,
132 p_ele_description in varchar2 default NULL,
133 p_ele_classification in varchar2,
134 p_ele_category in varchar2 default NULL,
135 p_ele_processing_type in varchar2,
136 p_ele_priority in number default NULL,
137 p_ele_standard_link in varchar2 default 'N');
138 --
139 PROCEDURE do_deletions (p_business_group_id in number,
140 p_ele_type_id in number,
141 p_ele_name in varchar2,
142 p_ele_priority in number,
143 p_ele_amount_rule in varchar2,
144 p_ele_ee_bond in varchar2,
145 p_ele_arrearage in varchar2,
146 p_ele_stop_rule in varchar2,
147 p_ele_info_10 in varchar2 default null,
148 p_ele_info_11 in varchar2 default null,
149 p_ele_info_12 in varchar2 default null,
150 p_ele_info_13 in varchar2 default null,
151 p_ele_info_14 in varchar2 default null,
152 p_ele_info_15 in varchar2 default null,
153 p_ele_info_16 in varchar2 default null,
154 p_ele_info_17 in varchar2 default null,
155 p_ele_info_18 in varchar2 default null,
156 p_ele_info_19 in varchar2 default null,
157 p_ele_info_20 in varchar2 default null,
158 p_del_sess_date in date,
159 p_del_val_start_date in date,
160 p_del_val_end_date in date);
161 --
162
163 FUNCTION get_assoc_ele(p_ele_type_id in NUMBER
164 ,p_suffix in VARCHAR2
165 ,p_eff_start_date in DATE
166 ,p_bg_id in NUMBER) RETURN varchar2;
167 PRAGMA RESTRICT_REFERENCES(get_assoc_ele, WNDS);
168 END hr_user_init_dedn;