1 package pay_ca_user_init_earn AUTHID CURRENT_USER as
2 /* $Header: pycauiet.pkh 115.6 2004/04/02 07:28:19 ssmukher 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 : pycauiet
24 Filename : pycauiet.pkh
25 Change List
26 -----------
27 Date Name Vers Bug No Description
28 ---- ---- ---- ------ -----------
29 10-NOV-98 R.Murthy 110.0 First Created.
30 17-FEB-2000 RThirlby 110.2 Added new procedure
31 update_jd_level_on_balance.
32 This updates jurisdiction_level
33 on pay_balance_types for all
34 balances. This procedure will
35 be used by balances created by
36 the deductions template too
37 (pycauidt.pkb).
38 18-FEB-2000 RThirlby 115.5 Added p_ele_eoy_type
39 20-FEB-2001 ekim 115.3 Added Procedure
40 update_ntg_element.
41 11-APR-2002 SSattini 115.4 Added dbdrv
42 11-APR-2002 SSattini 115.5 Corrected GSCC complaint.
43 22-MAR-2004 ssmukher 115.6 Bug#2646705 Enhancement for Termination rule
44 Added p_termination_rule in the
45 create_user_init_earn function
46 */
47
48 /*
49 ---------------------------------------------------------------------
50 These procedures call the template engine procedures to determine
51 the attributes with which a user-initiated earning will be created
52 - i.e. the appropriate balances, formulas, result rules, etc.
53 ---------------------------------------------------------------------
54 */
55
56 -- Legislation Subgroup Code for all template elements.
57 g_template_leg_code VARCHAR2(30) := 'CA';
58 g_template_leg_subgroup VARCHAR2(30);
59 --
60 FUNCTION create_user_init_earning (
61 p_ele_name in varchar2,
62 p_ele_reporting_name in varchar2,
63 p_ele_description in varchar2 default NULL,
64 p_ele_classification in varchar2,
65 p_ele_category in varchar2 default NULL,
66 p_ele_calc_method in varchar2,
67 p_ele_eoy_type in varchar2,
68 p_ele_t4a_footnote in varchar2,
69 p_ele_rl1_footnote in varchar2,
70 p_ele_registration_number in varchar2,
71 p_ele_ot_earnings in varchar2 default 'N',
72 p_ele_ot_hours in varchar2 default 'N',
73 p_ele_ei_hours in varchar2 default 'N',
74 p_ele_processing_type in varchar2,
75 p_ele_priority in number default NULL,
76 p_ele_standard_link in varchar2 default 'N',
77 p_ele_calc_rule in varchar2,
78 p_ele_calc_rule_code in varchar2 default NULL,
79 p_sep_check_option in varchar2 default 'N',
80 p_reduce_regular in varchar2 default 'N',
81 p_ele_eff_start_date in date default NULL,
82 p_ele_eff_end_date in date default NULL,
83 p_bg_id in number,
84 p_termination_rule in varchar2 default 'F')-- Bug2646705
85 RETURN NUMBER;
86 --
87 PROCEDURE delete_user_init_earning (
88 p_business_group_id in number,
89 p_ele_type_id in number,
90 p_ele_name in varchar2,
91 p_del_sess_date in date,
92 p_del_val_start_date in date,
93 p_del_val_end_date in date);
94 --
95 PROCEDURE UPDATE_JD_LEVEL_ON_BALANCE(p_template_id in number);
96 --
97 PROCEDURE update_ntg_element(p_base_element_type_id in number,
98 p_ele_eff_start_date in date,
99 p_bg_id in number);
100 --
101 END pay_ca_user_init_earn;