1 package pay_us_vertex_interface as
2 /* $Header: payusvertexetusg.pkh 120.0.12000000.1 2007/01/17 14:56:07 appldev noship $ */
3 /*
4 +======================================================================+
5 | Copyright (c) 1993 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +======================================================================+
9
10 Name :
11 Filename : payusvertexetusg.pkh
12 Description : This Package contains Procedures and Funbction required for
13 managing lement_type_usages for VERTEX and US_TAX_VERTEX
14 elements
15 Change List
16 -----------
17 Date Name Vers Bug No Description
18 ---- ---- ---- ------ -----------
19 12-DEC-2004 ppanda 115.0 Initial Version
20 02-FEB-2005 ppanda 115.1 4155064 Modified various procedure and
21 function to support Business
22 Group
23
24
25 */
26 -- This procedure makes entry into pay_element_types_usages_f
27 -- depending on the Run_Type and Element details passed to it.
28 PROCEDURE create_ele_tp_usg ( p_element_type_id in number
29 ,p_run_type_id in number
30 ,p_element_name in varchar2
31 ,p_run_type_name in varchar2
32 ,p_inclusion_flag in varchar2
33 ,p_effective_date in date
34 ,p_legislation_code in varchar2
35 ,p_business_group_id in number
36 );
37 --
38 -- This procedure removes entries from the pay_element_type_usages_f
39 -- for an element and run types used for processing vertex elements
40 --
41 PROCEDURE delete_ele_type_usages (p_element_name in varchar2,
42 p_business_group_id in number);
43 --
44 -- This function determines whether Payroll Run exist for the given
45 -- Business group or Not.
46 --
47 FUNCTION payroll_run_exist (p_business_group_id in number
48 )Return varchar2;
49 -- This function used to determine the current Tax Interface used to Calculate
50 -- the TAX
51 FUNCTION Current_Tax_Interface (p_lookup_code in varchar2,
52 p_business_group_id in number)
53 Return varchar2;
54
55 -- This function determines whether element_type is excluded for processing
56 -- in Payroll or Not
57 -- If this function returns 'Y' it means input element is excluded
58 -- ELSIF the return value is 'N', Element is included in Payroll process
59 --
60 FUNCTION vertex_eletype_usage_exist (p_element_name varchar2,
61 p_business_group_id number)
62 Return varchar2;
63
64
65 -- This procedure Excudes the TAX Element from processing depending on
66 -- customer selection
67 -- IF Customer selection is STANDARD interface
68 -- New Tax Element US_TAX_VERTEX will be excluded
69 -- ELSIF Customer selection is ENHANCED interface
70 -- Old Tax Element VERTEX will be excluded
71 PROCEDURE select_tax_interface(errbuf OUT nocopy VARCHAR2,
72 retcode OUT nocopy NUMBER,
73 p_business_group_id IN NUMBER,
74 p_vertex_interface IN VARCHAR2);
75
76
77 END pay_us_vertex_interface;