[Home] [Help]
PACKAGE: APPS.NTG_EARNINGS_TEMPLATE
Source
1 PACKAGE ntg_earnings_template AUTHID CURRENT_USER AS
2 /* $Header: pyusntgf.pkh 115.3 2003/08/14 12:29:59 ekim noship $ */
3
4 /*========================================================================
5 * CREATE_ELE_TEMPLATE_OBJECTS
6 *=======================================================================*/
7 FUNCTION create_ele_ntg_objects
8 (p_ele_name in varchar2
9 ,p_ele_reporting_name in varchar2
10 ,p_ele_description in varchar2 default NULL
11 ,p_ele_classification in varchar2
12 ,p_ele_category in varchar2 default NULL
13 ,p_ele_processing_type in varchar2
14 ,p_ele_priority in number default NULL
15 ,p_ele_standard_link in varchar2 default 'N'
16 ,p_ele_ot_base in varchar2 default 'N'
17 ,p_flsa_hours in varchar2 default 'N'
18 ,p_sep_check_option in varchar2 default 'N'
19 ,p_ele_eff_start_date in date default NULL
20 ,p_ele_eff_end_date in date default NULL
21 ,p_supp_category in varchar2
22 ,p_legislation_code in varchar2
23 ,p_bg_id in number
24 ,p_termination_rule in varchar2 default 'F'
25 )
26 RETURN NUMBER;
27 --
28 ----------------------------------------------------------------------
29 -- Input-Name Valid Values/Explaination
30 -- ---------- --------------------------------------
31 -- p_ele_name - User i/p Element name
32 -- p_ele_reporting_name - User i/p reporting name
33 -- p_ele_description - User i/p Description
34 -- p_ele_classification - Supp/Regular Earnings
35 -- p_ele_category - Supp/Regular categories
36 -- p_ele_processing_type - R/N (Recurring/Non-recurring)
37 -- p_ele_priority - User i/p priority
38 -- p_ele_standard_link - Y/N (default N)
39 -- p_ele_ot_base - Y/N (INCLUDE_IN_OT_BASE)
40 -- p_flsa_hours - FLSA hours
41 -- p_ele_calc_ff_name - current earnings formulas
42 -- p_sep_check_option - Y/N
43 -- p_dedn_proc - A-All, T-Tax, PTT-Pretax
44 -- p_reduce_regular - Y/N
45 -- p_ele_eff_start_date - Trunc(start date)
46 -- p_ele_eff_end_date - Trunc(end date)
47 -- p_supp_category - Supplemental element category
48 -- p_legislation_code - legislation code
49 -- p_bg_id - Business group id
50 --
51 --===========================================================================
52 -- Deletion procedure
53 --===========================================================================
54 --
55 PROCEDURE delete_user_template_objects
56 (p_business_group_id in number
57 ,p_ele_name in varchar2
58 );
59 --
60 END ntg_earnings_template;