1 PACKAGE PAY_NO_TAX_LEVY AUTHID CURRENT_USER AS
2 /* $Header: pynotaxlevy.pkh 120.0.12000000.1 2007/05/20 08:04:23 rlingama noship $ */
3
4 TYPE xml_rec_type IS RECORD( xmlstring VARCHAR2(32000) );
5
6 -- Table Type for XML Table
7 TYPE xml_tab_type IS TABLE OF xml_rec_type INDEX BY BINARY_INTEGER;
8
9 -- Global declaration of Pl/Sql Table for storing Xml Data
10 xml_tab xml_tab_type;
11
12 /* GET PARAMETER */
13 FUNCTION GET_PARAMETER
14 (
15 p_parameter_string IN VARCHAR2
16 ,p_token IN VARCHAR2
17 ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2 ;
18
19 /* GET ALL PARAMETERS */
20 PROCEDURE GET_ALL_PARAMETERS
21 (
22 p_payroll_action_id IN NUMBER
23 ,p_business_group_id OUT NOCOPY NUMBER
24 ,p_legal_employer_id OUT NOCOPY NUMBER
25 ,p_effective_date OUT NOCOPY DATE
26 ,p_bimonth_term OUT NOCOPY VARCHAR2
27 ,p_archive OUT NOCOPY VARCHAR2
28 ,p_payee_org OUT NOCOPY NUMBER
29 ) ;
30
31 /* RANGE CODE */
32 PROCEDURE RANGE_CODE
33 (pactid IN NUMBER
34 ,sqlstr OUT NOCOPY VARCHAR2) ;
35
36
37 /* INITIALIZATION CODE */
38 PROCEDURE INITIALIZATION_CODE
39 (p_payroll_action_id IN NUMBER) ;
40
41
42 /* ASSIGNMENT ACTION CODE */
43 PROCEDURE ASSIGNMENT_ACTION_CODE
44 (p_payroll_action_id IN NUMBER
45 ,p_start_person IN NUMBER
46 ,p_end_person IN NUMBER
47 ,p_chunk IN NUMBER) ;
48
49
50 /* ARCHIVE CODE */
51 PROCEDURE ARCHIVE_CODE
52 (p_assignment_action_id IN NUMBER
53 ,p_effective_date IN DATE) ;
54
55
56 /*Main Procedure to populate details For Reporting*/
57 Procedure populate_details
58 (p_payroll_action_id in varchar2,
59 p_template_name in varchar2,
60 p_xml out nocopy clob);
61
62 /*Procedure to write to clob object*/
63 PROCEDURE write_to_clob
64 (p_xml out nocopy clob);
65
66 -- End of Package Header
67
68 END PAY_NO_TAX_LEVY;