DBA Data[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;