1 PACKAGE PAY_NO_PACCR_PKG AUTHID CURRENT_USER AS
2 /* $Header: pynopaccr.pkh 120.0.12000000.2 2007/05/20 06:54:32 rlingama noship $ */
3
4
5 FUNCTION GET_PARAMETER
6 (p_parameter_string IN VARCHAR2
7 ,p_token IN VARCHAR2
8 ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2;
9
10 PROCEDURE GET_ALL_PARAMETERS
11 (p_payroll_action_id IN NUMBER
12 ,p_business_group_id OUT NOCOPY NUMBER
13 ,p_payroll_id OUT NOCOPY NUMBER
14 ,p_le_id OUT NOCOPY NUMBER
15 ,p_ele_id OUT NOCOPY NUMBER
16 ,p_restr_econtr OUT NOCOPY VARCHAR2
17 ,p_eoy_code OUT NOCOPY VARCHAR2
18 ,p_cost_seg OUT NOCOPY VARCHAR2
19 ,p_effective_date OUT NOCOPY DATE
20 ,p_report_start_date OUT NOCOPY DATE
21 ,p_report_end_date OUT NOCOPY DATE
22 ,p_archive OUT NOCOPY VARCHAR2);
23
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 NUMBER);
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_SUMMARY
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 POPULATE_DATA_DETAIL
72 (p_business_group_id IN NUMBER,
73 p_payroll_action_id IN VARCHAR2 ,
74 p_template_name IN VARCHAR2,
75 p_xml OUT NOCOPY CLOB);
76
77 PROCEDURE WritetoCLOB
78 (p_xfdf_clob OUT NOCOPY CLOB);
79
80 END PAY_NO_PACCR_PKG;