1 PACKAGE PAY_DK_ABSR_PKG AUTHID CURRENT_USER AS
2 /* $Header: pydkabsr.pkh 120.0.12010000.1 2009/07/29 07:27:48 rsahai noship $ */
3
4 FUNCTION GET_LOOKUP_MEANING (p_lookup_type varchar2,p_lookup_code varchar2) RETURN VARCHAR2;
5
6 FUNCTION GET_PARAMETER
7 (p_parameter_string IN VARCHAR2
8 ,p_token IN VARCHAR2
9 ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2;
10
11 PROCEDURE GET_ALL_PARAMETERS
12 (p_payroll_action_id IN NUMBER
13 ,p_business_group_id OUT NOCOPY NUMBER
14 ,p_payroll_id OUT NOCOPY NUMBER
15 ,p_sender_id OUT NOCOPY NUMBER
16 ,p_year OUT NOCOPY VARCHAR2
17 ,p_effective_date OUT NOCOPY DATE
18 ,p_report_end_date OUT NOCOPY DATE
19 ,p_archive OUT NOCOPY VARCHAR2);
20
21 FUNCTION GET_GLOBAL_VALUE
22 (p_global_name VARCHAR2
23 ,p_effective_date DATE) RETURN ff_globals_f.global_value%TYPE;
24
25 /******** PROCEDURES FOR ARCHIVING THE REPORT DATA ********/
26
27 PROCEDURE RANGE_CODE
28 (pactid IN NUMBER
29 ,sqlstr OUT NOCOPY VARCHAR2) ;
30
31 PROCEDURE ASSIGNMENT_ACTION_CODE
32 (p_payroll_action_id IN NUMBER
33 ,p_start_person IN NUMBER
34 ,p_end_person IN NUMBER
35 ,p_chunk IN NUMBER);
36
37 PROCEDURE INITIALIZATION_CODE
38 (p_payroll_action_id IN NUMBER);
39
40
41 PROCEDURE ARCHIVE_CODE
42 (p_assignment_action_id IN NUMBER
43 ,p_effective_date IN DATE);
44
45 /*PROCEDURE DEINITIALIZATION_CODE
46 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);*/
47
48
49 /******** PROCEDURES FOR WRITING THE REPORT ********/
50
51 TYPE xml_rec_type IS RECORD
52 (
53 TagName VARCHAR2(240),
54 TagValue VARCHAR2(240)
55 );
56
57 TYPE xml_tab_type
58 IS TABLE OF xml_rec_type
59 INDEX BY BINARY_INTEGER;
60
61 xml_tab xml_tab_type;
62
63
64
65 PROCEDURE POPULATE_DATA
66 (p_business_group_id IN NUMBER,
67 p_payroll_action_id IN VARCHAR2 ,
68 p_template_name IN VARCHAR2,
69 p_xml OUT NOCOPY CLOB);
70
71 PROCEDURE WritetoCLOB
72 (p_xfdf_clob OUT NOCOPY CLOB);
73
74 END PAY_DK_ABSR_PKG;