1 PACKAGE PAY_DK_PR_ORG AUTHID CURRENT_USER AS
2 /* $Header: pydkprorg.pkh 120.5 2006/01/27 07:00:54 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_organization_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 /*Funtion to get the costed code*/
31 FUNCTION COSTED_CODE
32 (p_run_result_id IN NUMBER
33 ,p_input_value_id IN NUMBER)
34 RETURN VARCHAR2 ;
35
36 /* RANGE CODE */
37 PROCEDURE RANGE_CODE (pactid IN NUMBER
38 ,sqlstr OUT NOCOPY VARCHAR2) ;
39
40
41 /* INITIALIZATION CODE */
42 PROCEDURE INITIALIZATION_CODE(p_payroll_action_id IN NUMBER) ;
43
44
45 /* ASSIGNMENT ACTION CODE */
46 PROCEDURE ASSIGNMENT_ACTION_CODE
47 (p_payroll_action_id IN NUMBER
48 ,p_start_person IN NUMBER
49 ,p_end_person IN NUMBER
50 ,p_chunk IN NUMBER) ;
51
52
53 /* ARCHIVE CODE */
54 PROCEDURE ARCHIVE_CODE(p_assignment_action_id IN NUMBER
55 ,p_effective_date IN DATE) ;
56
57
58
59 -- Main Procedure to populate details for reporting
60
61 PROCEDURE populate_details
62 (
63 p_payroll_action_id in varchar2,
64 p_template_name in varchar2,
65 p_xml out nocopy clob
66 );
67
68 END PAY_DK_PR_ORG;