1 PACKAGE PER_NL_FDR_ARCHIVE as
2 /* $Header: penlfdra.pkh 120.0.12000000.1 2007/04/10 11:59:15 rajesrin noship $ */
3
4 /*Record for storing XML tag and its value*/
5
6 TYPE XMLRec IS RECORD (TagName VARCHAR2(1000),
7 TagValue VARCHAR2(1000));
8
9 TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
10
11 vXMLTable tXMLTable;
12
13
14 /*------------------------------------------------------------------------------
15 |Name : GET_PARAMETER |
16 |Type : Function |
17 |Description : Funtion to get the parameters of the archive process |
18 -------------------------------------------------------------------------------*/
19
20
21 FUNCTION get_parameter (p_parameter_string in varchar2
22 ,p_token in varchar2
23 ,p_segment_number in number default null ) RETURN varchar2;
24
25
26
27 /*-----------------------------------------------------------------------------
28 |Name : GET_ALL_PARAMETERS |
29 |Type : Procedure |
30 |Description: Procedure which returns all the parameters of the archive process|
31 -------------------------------------------------------------------------------*/
32
33
34 PROCEDURE get_all_parameters (p_payroll_action_id IN NUMBER
35 ,p_report_date OUT NOCOPY VARCHAR2
36 ,p_org_struct_id OUT NOCOPY NUMBER
37 ,p_person_id OUT NOCOPY NUMBER
38 ,p_org_id OUT NOCOPY NUMBER
39 ,p_bg_id OUT NOCOPY NUMBER);
40
41
42
43 /*-----------------------------------------------------------------------------
44 |Name : WRITETOCLOB_RTF |
45 |Type : Procedure |
46 |Description: Procedure to write contents of XML file as CLOB |
47 -------------------------------------------------------------------------------*/
48
49
50 PROCEDURE WritetoCLOB_rtf(p_xfdf_clob out nocopy clob, p_XMLTable IN tXMLTable);
51
52
53
54 /*------------------------------------------------------------------------------
55 |Name : CHECK_TAX_DETAILS |
56 |Type : Function |
57 |Description : Returns 1 if the organization has tax details attached |
58 -------------------------------------------------------------------------------*/
59
60
61 FUNCTION check_tax_details (p_org_id IN NUMBER) RETURN NUMBER;
62
63
64 /*------------------------------------------------------------------------------
65 |Name : GET_REF_DATE |
66 |Type : Function |
67 |Description : Function to return the date at which the assignment record |
68 | needs to be picked for an employee. |
69 -------------------------------------------------------------------------------*/
70
71
72 FUNCTION get_ref_date (p_person_id IN NUMBER) return DATE;
73
74
75 /*------------------------------------------------------------------------------
76 |Name : ORG_CHECK |
77 |Type : Function |
78 |Description : Function required for valueset HR_NL_EMPLOYER_FDR |
79 -------------------------------------------------------------------------------*/
80
81
82 FUNCTION org_check (p_bg_id IN NUMBER
83 ,p_org_struct_id IN NUMBER
84 ,p_org_id IN NUMBER
85 ,p_report_date IN DATE) return NUMBER;
86
87
88
89 /*------------------------------------------------------------------------------
90 |Name : EMP_CHECK |
91 |Type : Function |
92 |Description : Function required for valueset HR_NL_EMPLOYEE_FDR |
93 -------------------------------------------------------------------------------*/
94
95
96 FUNCTION emp_check (p_bg_id IN NUMBER
97 ,p_org_struct_id IN NUMBER
98 ,p_org_id IN NUMBER
99 ,p_person_id IN NUMBER
100 ,p_report_date IN DATE) return NUMBER;
101
102
103
104 /*--------------------------------------------------------------------
105 |Name : RANGE_CODE |
106 |Type : Procedure |
107 |Description: This procedure returns an sql string to select a range |
108 | of assignments eligible for reporting |
109 ----------------------------------------------------------------------*/
110
111
112 PROCEDURE RANGE_CODE (pactid IN NUMBER
113 ,sqlstr OUT NOCOPY VARCHAR2);
114
115
116
117 /*--------------------------------------------------------------------
118 |Name : ASSIGNMENT_ACTION_CODE |
119 |Type : Procedure |
120 |Description: This procedure further filters which assignments are |
121 | eligible for reporting |
122 ----------------------------------------------------------------------*/
123
124
125 PROCEDURE ASSIGNMENT_ACTION_CODE (p_payroll_action_id in number
126 ,p_start_person_id in number
127 ,p_end_person_id in number
128 ,p_chunk in number);
129
130
131
132 /*-------------------------------------------------------------------------------
133 |Name : ARCHIVE_CODE |
134 |Type : Procedure |
135 |Description : Archival code |
136 -------------------------------------------------------------------------------*/
137
138
139 PROCEDURE ARCHIVE_CODE (p_assignment_action_id IN NUMBER
140 ,p_effective_date IN DATE);
141
142
143
144 /*-------------------------------------------------------------------------------
145 |Name : ARCHIVE_DEINIT_CODE |
146 |Type : Procedure |
147 |Description : Deinitialization code |
148 -------------------------------------------------------------------------------*/
149
150
151 PROCEDURE archive_deinit_code(p_actid IN NUMBER);
152
153
154 END PER_NL_FDR_ARCHIVE;
155