DBA Data[Home] [Help]

PACKAGE: APPS.PAY_DK_PR_ORG

Source


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;