1 PACKAGE PAY_DK_PR_LE AUTHID CURRENT_USER AS
2 /* $Header: pydkprle.pkh 120.6 2006/01/27 06:52:38 pgopal noship $ */
3
4 /* GET PARAMETER */
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
11 /* GET ALL PARAMETERS */
12 PROCEDURE GET_ALL_PARAMETERS(
13 p_payroll_action_id IN NUMBER
14 ,p_business_group_id OUT NOCOPY NUMBER
15 ,p_effective_date OUT NOCOPY DATE
16 ,p_archive OUT NOCOPY VARCHAR2
17 ,p_element_set_id OUT NOCOPY NUMBER
18 ,p_legal_employer_id OUT NOCOPY NUMBER
19 ,p_payroll_id OUT NOCOPY NUMBER
20 ,p_fromdate OUT NOCOPY DATE
21 ,p_todate OUT NOCOPY DATE
22 ) ;
23
24 /*GET DEFINED BALANCE ID*/
25 FUNCTION GET_DEFINED_BALANCE_ID(
26 p_input_value_id IN VARCHAR2
27 ,p_dbi_suffix IN VARCHAR2)
28 RETURN NUMBER;
29
30
31 /*Funtion to get the costed code*/
32 FUNCTION COSTED_CODE
33 (p_run_result_id IN NUMBER
34 ,p_input_value_id IN NUMBER)
35 RETURN VARCHAR2 ;
36
37
38 /* RANGE CODE */
39 PROCEDURE RANGE_CODE (pactid IN NUMBER
40 ,sqlstr OUT NOCOPY VARCHAR2) ;
41
42
43 /* INITIALIZATION CODE */
44 PROCEDURE INITIALIZATION_CODE(p_payroll_action_id IN NUMBER) ;
45
46
47 /* ASSIGNMENT ACTION CODE */
48 PROCEDURE ASSIGNMENT_ACTION_CODE
49 (p_payroll_action_id IN NUMBER
50 ,p_start_person IN NUMBER
51 ,p_end_person IN NUMBER
52 ,p_chunk IN NUMBER) ;
53
54
55 /* ARCHIVE CODE */
56 PROCEDURE ARCHIVE_CODE(p_assignment_action_id IN NUMBER
57 ,p_effective_date IN DATE) ;
58
59
60
61 -- Main Procedure to populate details for reporting
62
63 PROCEDURE populate_details
64 (
65 p_payroll_action_id in varchar2,
66 p_template_name in varchar2,
67 p_xml out nocopy clob
68 );
69
70 END PAY_DK_PR_LE;