1 PACKAGE PAY_NO_UNION_DUES AUTHID CURRENT_USER AS
2 /* $Header: pynouniondues.pkh 120.0.12020000.3 2012/10/31 10:49:27 dakhuran ship $ */
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
13 /* GET PARAMETER */
14 FUNCTION GET_PARAMETER(
15 p_parameter_string IN VARCHAR2
16 ,p_token IN VARCHAR2
17 ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2 ;
18
19
20 /* GET ALL PARAMETERS */
21 PROCEDURE GET_ALL_PARAMETERS(
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_archive OUT NOCOPY VARCHAR2
27 ,p_payee_org OUT NOCOPY NUMBER
28 ,p_fromdate OUT NOCOPY DATE
29 ,p_todate OUT NOCOPY DATE
30 ) ;
31
32
33 /* RANGE CODE */
34 PROCEDURE RANGE_CODE (pactid IN NUMBER
35 ,sqlstr OUT NOCOPY VARCHAR2) ;
36
37
38 /* INITIALIZATION CODE */
39 PROCEDURE INITIALIZATION_CODE(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(p_assignment_action_id IN NUMBER
52 ,p_effective_date IN DATE) ;
53
54
55
56 -- Main Procedure to populate details for reporting
57
58 procedure populate_details
59 (
60 p_payroll_action_id in varchar2,
61 p_template_name in varchar2,
62 p_xml out nocopy clob
63 );
64
65 -- Procedure to write to clob object
66
67 PROCEDURE write_to_clob (p_xml out nocopy clob);
68
69
70 FUNCTION GET_UNION_DUE_GLOBAL (
71 p_payroll_action_id IN NUMBER,
72 p_organization_id IN NUMBER,
73 p_exists IN OUT NOCOPY NUMBER) RETURN NUMBER ;
74
75 -- End of Package Header
76
77
78 END PAY_NO_UNION_DUES;