[Home] [Help]
PACKAGE: APPS.PQP_EARNINGS_TEMPLATE
Source
1 PACKAGE pqp_earnings_template AUTHID CURRENT_USER AS
2 /* $Header: pqeetdrv.pkh 115.3 2003/04/22 21:32:35 tmehra ship $ */
3
4 /*========================================================================
5 * CREATE_ELE_TEMPLATE_OBJECTS
6 *=======================================================================*/
7 FUNCTION create_ele_template_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
18 ,p_ele_calc_ff_name in varchar2
19 ,p_sep_check_option in varchar2 default 'N'
20 ,p_dedn_proc in varchar2
21 ,p_reduce_regular in varchar2 default 'N'
22 ,p_ele_eff_start_date in date default NULL
23 ,p_ele_eff_end_date in date default NULL
24 ,p_supp_category in varchar2
25 ,p_legislation_code in varchar2
26 ,p_bg_id in number
27 ,p_termination_rule in varchar2 default 'F'
28 )
29 RETURN NUMBER;
30 --
31 ----------------------------------------------------------------------
32 -- Input-Name Valid Values/Explaination
33 -- ---------- --------------------------------------
34 -- p_ele_name - User i/p Element name
35 -- p_ele_reporting_name - User i/p reporting name
36 -- p_ele_description - User i/p Description
37 -- p_ele_classification - 'Alien/Expat Earnings'
38 -- p_ele_category - alien/expat categories
39 -- p_ele_processing_type - R/N (Recurring/Non-recurring)
40 -- p_ele_priority - User i/p priority
41 -- p_ele_standard_link - Y/N (default N)
42 -- p_ele_ot_base - Y/N (INCLUDE_IN_OT_BASE)
43 -- p_flsa_hours - FLSA hours
44 -- p_ele_calc_ff_name - current earnings formulas
45 -- p_sep_check_option - Y/N
46 -- p_dedn_proc - A-All, T-Tax, PTT-Pretax
47 -- p_reduce_regular - Y/N
48 -- p_ele_eff_start_date - Trunc(start date)
49 -- p_ele_eff_end_date - Trunc(end date)
50 -- p_supp_category - Supplemental element category
51 -- p_legislation_code - legislation code
52 -- p_bg_id - Business group id
53 --
54 /*===========================================================================
55 * FUNCTION get_obj_id
56 *==========================================================================*/
57 --
58 -- function used to fetch the object ids for balance, input values and
59 -- elements
60 --
61 FUNCTION get_obj_id (p_object_type in varchar2,
62 p_object_name in varchar2,
63 p_object_id in number default NULL)
64 RETURN NUMBER;
65
66 /*===========================================================================
67 * Add_Flsa_Reduce_Reg_Feeds procedure
68 *==========================================================================*/
69 --
70 -- Procedure used to create the feeds for the reduce regular and FLSA hours
71 --
72 PROCEDURE add_flsa_reduce_reg_feeds
73 (p_ele_ot_base in varchar2
74 ,p_flsa_hours in varchar2
75 ,p_reduce_regular in varchar2
76 ,p_pri_ele_type_id in number
77 ,p_ssf_ele_type_id in number
78 ,p_asf_ele_type_id in number
79 ,p_ele_eff_start_date in date );
80
81 /*===========================================================================
82 * Deletion procedure
83 *==========================================================================*/
84 --
85 PROCEDURE delete_ele_template_objects
86 (p_business_group_id in number
87 ,p_ele_type_id in number
88 ,p_ele_name in varchar2
89 ,p_effective_date in date
90 );
91 --
92 END pqp_earnings_template;