1 package PAY_NL_RULES AUTHID CURRENT_USER as
2 /* $Header: pynlrule.pkh 120.3 2006/11/07 06:05:06 vbattu noship $ */
3
4
5 -- +********************************************************************+
6 -- | PUBLIC FUNCTIONS |
7 -- +********************************************************************+
8
9 ---------------------------------------------------------------------------
10 -- Procedure: get_override_ctx_value
11 -- Procedure returns current system effective date in canonical format
12 ---------------------------------------------------------------------------
13
14 PROCEDURE get_override_ctx_value (p_retro_asg_action_id IN Number,
15 p_run_asg_action_id IN Number,
16 p_element_type_id IN Number,
17 p_retro_component_id IN Number,
18 p_override_date IN OUT NOCOPY varchar2);
19
20 -- Added an additional parameter p_element_type_id as a part of 11.5.10 changes
21 PROCEDURE get_retro_component_id (p_ee_id IN Number,
22 p_element_type_id IN Number default -1,
23 p_retro_component_id IN OUT NOCOPY Number);
24
25
26 ---------------------------------------------------------------------------
27 -- Procedure : get_asg_process_group
28 -- This procedure gives the process group name for an assignment
29 ---------------------------------------------------------------------------
30
31 Procedure get_asg_process_group(p_assignment_id IN Number,
32 p_effective_start_date IN Date,
33 p_effective_end_date IN Date,
34 p_process_group_name OUT NOCOPY Varchar2);
35
36
37 ---------------------------------------------------------------------------
38 -- Procedure : get_main_tax_unit_id
39 -- This procedure gives the tax unit id for an assignment
40 ---------------------------------------------------------------------------
41
42 PROCEDURE get_main_tax_unit_id(p_assignment_id IN NUMBER,
43 p_effective_date IN DATE,
44 p_tax_unit_id IN OUT NOCOPY NUMBER);
45 --
46 ---------------------------------------------------------------------------
47 -- Function : get_object_group_type
48 -- This Function returns the type, the object group is based on
49 -- 'PAYROLL' if based on payroll_id
50 -- 'EMPLOYER' if based on HR Organization
51 ---------------------------------------------------------------------------
52 FUNCTION get_object_group_type RETURN VARCHAR2 ;
53
54 END PAY_NL_RULES;