1 package pay_ca_user_init_dedn AUTHID CURRENT_USER as
2 /* $Header: pycauidt.pkh 115.4 2002/04/11 15:35:55 pkm ship $ */
3 /*
4 */
5 --
6 /*
7 ******************************************************************
8 * *
9 * Copyright (C) 1998 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 : pycauidt
24 Filename : pycauidt.pkh
25 Change List
26 -----------
27 Date Name Vers Bug No Description
28 ---- ---- ---- ------ -----------
29 10-NOV-98 R.Murthy 110.0 First Created.
30
31 28-OCT-99 J.Bailie 110.1 Added function and procedure for
32 create_user_init_garnishment
33 delete_user_init_garnishment
34
35 19-APR-00 Acai 115.0 Rereated for 11i (no change).
36 09-AUG-00 mmukherj 115.2 Added update and insert of footnote
37 and registration no for Year end info
38 11-APR-02 SSattini 115.3 Added dbdrv line.
39 11-APR-2002 SSattini 115.4 Corrected GSCC complaint.
40 */
41
42 /*
43 ---------------------------------------------------------------------
44 These procedures call the template engine procedures to determine
45 the attributes with which a user-initiated deduction will be created
46 - i.e. the appropriate balances, formulas, result rules, etc.
47 ---------------------------------------------------------------------
48 */
49
50 -- Legislation Subgroup Code for all template elements.
51 g_template_leg_code VARCHAR2(30) := 'CA';
52 g_template_leg_subgroup VARCHAR2(30);
53 --
54 FUNCTION create_user_init_deduction (
55 p_ele_name in varchar2,
56 p_ele_reporting_name in varchar2,
57 p_ele_description in varchar2 default NULL,
58 p_ele_classification in varchar2,
59 p_ben_class_id in number,
60 p_ele_category in varchar2 default NULL,
61 p_ele_processing_type in varchar2,
62 p_ele_priority in number default NULL,
63 p_ele_standard_link in varchar2 default 'N',
64 p_ele_proc_runtype in varchar2,
65 p_ele_start_rule in varchar2,
66 p_ele_stop_rule in varchar2,
67 p_ele_calc_rule in varchar2,
68 p_ele_calc_rule_code in varchar2,
69 p_ele_insuff_funds in varchar2,
70 p_ele_insuff_funds_code in varchar2,
71 p_ele_t4a_footnote in varchar2,
72 p_ele_rl1_footnote in varchar2,
73 p_ele_registration_number in varchar2,
74 p_ele_eff_start_date in date default NULL,
75 p_ele_eff_end_date in date default NULL,
76 p_bg_id in number) RETURN NUMBER;
77 --
78 FUNCTION create_user_init_garnishment (
79 p_ele_name in varchar2,
80 p_ele_reporting_name in varchar2,
81 p_ele_description in varchar2 default NULL,
82 p_ele_classification in varchar2,
83 p_ben_class_id in number,
84 p_ele_category in varchar2 default NULL,
85 p_ele_processing_type in varchar2,
86 p_ele_priority in number default NULL,
87 p_ele_standard_link in varchar2 default 'N',
88 p_ele_proc_runtype in varchar2,
89 p_ele_start_rule in varchar2,
90 p_ele_stop_rule in varchar2,
91 p_ele_calc_rule in varchar2,
92 p_ele_calc_rule_code in varchar2,
93 p_ele_insuff_funds in varchar2,
94 p_ele_insuff_funds_code in varchar2,
95 p_ele_t4a_footnote in varchar2,
96 p_ele_rl1_footnote in varchar2,
97 p_ele_registration_number in varchar2,
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) RETURN NUMBER;
101 --
102 PROCEDURE delete_user_init_deduction (
103 p_business_group_id in number,
104 p_ele_type_id in number,
105 p_ele_name in varchar2,
106 p_ele_priority in number,
107 p_ele_info_10 in varchar2 default null,
108 p_ele_info_12 in varchar2 default null,
109 p_del_sess_date in date,
110 p_del_val_start_date in date,
111 p_del_val_end_date in date);
112 --
113 PROCEDURE delete_user_init_garnishment (
114 p_business_group_id in number,
115 p_ele_type_id in number,
116 p_ele_name in varchar2,
117 p_ele_priority in number,
118 p_ele_info_10 in varchar2 default null,
119 p_ele_info_12 in varchar2 default null,
120 p_del_sess_date in date,
121 p_del_val_start_date in date,
122 p_del_val_end_date in date);
123 --
124 END pay_ca_user_init_dedn;