1 package hr_user_dedn_drv AUTHID CURRENT_USER as
2 /* $Header: pyusddwp.pkh 115.3 2004/01/29 05:28:11 kaverma 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_drv
29 Filename : pyusddwp.pkh
30 Change List
31 -----------
32 Date Name Vers Bug No Description
33 ---- ---- ---- ------ -----------
34 26-APR-98 PMADORE 1.0 First Created.
35 Initial Procedures
36 25-Mar-02 EKIM 115.1 2276457 Added p_termination_rule
37 to ins_deduction_template.
38 26-Mar-02 ekim 115.2 Added commit
39 29-Jan-04 kaverma 115.3 3349575 Corrected GSCC warning
40 */
41
42 g_template_leg_code varchar2(2) := 'US';
43 g_template_leg_subgroup varchar2(30) := null;
44
45 FUNCTION ins_deduction_template (
46 p_ele_name in varchar2,
47 p_ele_reporting_name in varchar2,
48 p_ele_description in varchar2 default NULL,
49 p_ele_classification in varchar2,
50 p_ben_class_id in number,
51 p_ele_category in varchar2 default NULL,
52 p_ele_processing_type in varchar2,
53 p_ele_priority in number default NULL,
54 p_ele_standard_link in varchar2 default 'N',
55 p_ele_proc_runtype in varchar2,
56 p_ele_start_rule in varchar2,
57 p_ele_stop_rule in varchar2,
58 p_ele_ee_bond in varchar2 default 'N',
59 p_ele_amount_rule in varchar2,
60 p_ele_paytab_name in varchar2 default NULL,
61 p_ele_paytab_col in varchar2 default NULL,
62 p_ele_paytab_row_type in varchar2 default NULL,
63 p_ele_arrearage in varchar2 default 'N',
64 p_ele_partial_dedn in varchar2 default 'N',
65 p_mix_flag in varchar2 default NULL,
66 p_ele_er_match in varchar2 default 'N',
67 p_ele_at_component in varchar2 default 'N',
68 p_ele_eff_start_date in date default NULL,
69 p_ele_eff_end_date in date default NULL,
70 p_bg_id in number,
71 p_termination_rule in varchar2 default 'F'
72 ) RETURN NUMBER;
73
74 end hr_user_dedn_drv;