1 package hr_user_init_earn AUTHID CURRENT_USER as
2 /* $Header: pyusuiet.pkh 115.5 2002/10/10 23:08:24 ekim ship $ */
3 /*
4 */
5 --
6 /*
7 ******************************************************************
8 * *
9 * Copyright (C) 1993 Oracle Corporation. *
10 * All rights reserved. *
11 * *
12 * This material has been provided pursuant to an agreement *
13 * containing restrictions on its use. The material is also *
14 * protected by copyright law. No part of this material may *
15 * be copied or distributed, transmitted or transcribed, in *
16 * any form or by any means, electronic, mechanical, magnetic, *
17 * manual, or otherwise, or disclosed to third parties without *
18 * the express written permission of Oracle Corporation, *
19 * 500 Oracle Parkway, Redwood City, CA, 94065. *
20 * *
21 ******************************************************************
22
23 Name : hr_pyusuiet
24 Filename : pyusuiet.pkh
25 Change List
26 -----------
27 Date Name Vers Bug No Description
28 ---- ---- ---- ------ -----------
29 21-SEP-93 H.Parichabutr 1.0 First Created.
30 Initial Procedures
31 03-NOV-93 hparicha 1.1 Added in locking and deletion
32 procedures.
33 22-NOV-94 hparicha 40.4 G1529 Fixes for decoupling
34 G1601 "Deduction Processing" inpval
35 from Separate Check processing.
36 19-DEC-94 hparicha 40.13 G1564 New calculation of OT Base
37 Rate
38 15-JUN-95 hparicha 40.6 Use "associated balance" ids
39 for deletion of those balances.
40 New params for do_deletions.
41 09-MAY-96 hparicha 40.8 337007 Added param for p_reduce_regular
42 340391 new seggie on ele type ddf.
43 Requires client side
44 PAYSUDEE.fmb
45 17-Mar-02 ekim 115.4 Added p_termination_rule
46 10-Oct-02 ekim 115.5 fixed GSCC warning.
47 */
48
49 /* NOTE:
50 Data used for certain inserts depend on the calculation method
51 selected. Calls to these procedures may be bundled in a procedure
52 that will handle putting together a logical set of calls - ie.
53 instead of repeating the same logic in each of the insert procedures,
54 the logic can be performed once and the appropriate calls made
55 immediately. The data involved includes input values, status
56 processing rules, formula result rules, and skip rules.
57 See ins_uie_formula below.
58
59 Also note, *could* make insertion (and validation) procedures
60 externally callable. Consider usefulness of such a design.
61 */
62
63 /*
64 ---------------------------------------------------------------------
65 The procedures responsible for creating
66 appropriate records based on data entered on the User-Initiated Earnings form
67 must perform simple logic to determine the exact attributes required for the
68 earnings template. Attributes (and their determining factors) are:
69 - skip rules (Class): will be determined during insert of ele type.
70 - calculation formulas (CalcMeth)
71 - status processing rules (CalcMeth)
72 - input values (Class/Cat, Calc Method)
73 - formula result rules (CalcMeth)
74 ---------------------------------------------------------------------
75 */
76
77 -- Legislation Subgroup Code for all template elements.
78 g_template_leg_code VARCHAR2(30) := 'US';
79 g_template_leg_subgroup VARCHAR2(30);
80 --
81 FUNCTION do_insertions (
82 p_ele_name in varchar2,
83 p_ele_reporting_name in varchar2,
84 p_ele_description in varchar2 default NULL,
85 p_ele_classification in varchar2,
86 p_ele_category in varchar2 default NULL,
87 p_ele_ot_base in varchar2 default 'N',
88 p_flsa_hours in varchar2 default 'N',
89 p_ele_processing_type in varchar2,
90 p_ele_priority in number default NULL,
91 p_ele_standard_link in varchar2 default 'N',
92 p_ele_calc_ff_id in number,
93 p_ele_calc_ff_name in varchar2 default NULL,
94 p_sep_check_option in varchar2 default 'N',
95 p_dedn_proc in varchar2 default 'A',
96 p_mix_flag in varchar2 default 'N',
97 p_reduce_regular in varchar2 default 'N',
98 p_ele_eff_start_date in date default NULL,
99 p_ele_eff_end_date in date default NULL,
100 p_bg_id in number,
101 p_termination_rule in varchar2 default 'F'
102 ) RETURN NUMBER;
103 --
104 PROCEDURE lock_template_rows (
105 p_ele_type_id in number,
106 p_ele_eff_start_date in date default NULL,
107 p_ele_eff_end_date in date default NULL,
108 p_ele_name in varchar2,
109 p_ele_reporting_name in varchar2,
110 p_ele_description in varchar2 default NULL,
111 p_ele_classification in varchar2,
112 p_ele_category in varchar2 default NULL,
113 p_ele_ot_base in varchar2 default 'N',
114 p_ele_processing_type in varchar2,
115 p_ele_priority in number default NULL,
116 p_ele_standard_link in varchar2 default 'N',
117 p_ele_calculation_rule in varchar2);
118 --
119 PROCEDURE do_deletions (p_business_group_id in number,
120 p_ele_type_id in number,
121 p_ele_name in varchar2,
122 p_ele_priority in number,
123 p_ele_info_10 in varchar2 default null,
124 p_ele_info_12 in varchar2 default null,
125 p_del_sess_date in date,
126 p_del_val_start_date in date,
127 p_del_val_end_date in date);
128 --
129 END hr_user_init_earn;