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