1 PACKAGE PAY_DK_PR_ASG AUTHID CURRENT_USER AS
2 /* $Header: pydkprasg.pkh 120.5 2006/01/27 06:50:12 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_assignment_set_id OUT NOCOPY NUMBER
18 ,p_payroll_id OUT NOCOPY NUMBER
19 ,p_fromdate OUT NOCOPY DATE
20 ,p_todate OUT NOCOPY DATE
21 ) ;
22
23 /*GET DEFINED BALANCE ID*/
24 FUNCTION GET_DEFINED_BALANCE_ID
25 (p_input_value_id IN VARCHAR2
26 ,p_dbi_suffix IN VARCHAR2 ) RETURN NUMBER;
27
28
29
30 /* RANGE CODE */
31 PROCEDURE RANGE_CODE (pactid IN NUMBER
32 ,sqlstr OUT NOCOPY VARCHAR2) ;
33
34
35 /* INITIALIZATION CODE */
36 PROCEDURE INITIALIZATION_CODE(p_payroll_action_id IN NUMBER) ;
37
38
39 /*Funtion to get the costed value*/
40 FUNCTION COSTED_CODE
41 (p_run_result_id IN NUMBER
42 ,p_input_value_id IN NUMBER)
43 RETURN VARCHAR2 ;
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_ASG;