PACKAGE: APPS.PAY_DK_PR_ELE

Source

1 PACKAGE PAY_DK_PR_ELE AUTHID CURRENT_USER AS
2 /* $Header: pydkprele.pkh 120.7 2006/01/27 06:55:53 pgopal noship $ */
3 
4 
5 /* GET PARAMETER */
6 FUNCTION GET_PARAMETER(
7 	 p_parameter_string IN VARCHAR2
8 	,p_token            IN VARCHAR2
9 	,p_segment_number   IN NUMBER default NULL ) RETURN VARCHAR2 ;
10 
11 
12 /* GET ALL PARAMETERS */
13 PROCEDURE GET_ALL_PARAMETERS(
14  		 p_payroll_action_id	IN           NUMBER
15 		,p_business_group_id    OUT  NOCOPY  NUMBER
16 		,p_effective_date	OUT  NOCOPY  DATE
17 		,p_archive		OUT  NOCOPY  VARCHAR2
18 		,p_element_set_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 /* RANGE CODE */
31 PROCEDURE RANGE_CODE (pactid    IN    NUMBER
32 		      ,sqlstr    OUT   NOCOPY VARCHAR2) ;
33 
34 
35 
36 /*Funtion to get the costed code*/
37 FUNCTION COSTED_CODE
38 	(p_run_result_id IN NUMBER
39 	,p_input_value_id IN NUMBER)
40 	RETURN 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_ELE;