DBA Data[Home] [Help]

PACKAGE: APPS.PAY_DK_TC_DP_UPLOAD

Source


1 PACKAGE pay_dk_tc_dp_upload AUTHID CURRENT_USER AS
2 /* $Header: pydktaxu.pkh 120.1.12010000.1 2008/07/27 22:27:34 appldev ship $ */
3 
4 
5 
6    PROCEDURE upload(
7       errbuf                     OUT NOCOPY   VARCHAR2,
8       retcode                    OUT NOCOPY   NUMBER,
9       p_file_name                IN       VARCHAR2,
10       p_effective_date           IN       VARCHAR2,
11       p_business_group_id        IN       per_business_groups.business_group_id%TYPE,
12       p_batch_name               IN       VARCHAR2 DEFAULT NULL	,
13       p_reference                IN       VARCHAR2 DEFAULT NULL
14    );
15 
16 
17 
18 
19    PROCEDURE read_record
20 	        (
21 		 p_line     IN VARCHAR2
22 		,p_entry_value1   OUT NOCOPY VARCHAR2
23 		,p_entry_value2   OUT NOCOPY VARCHAR2
24 		,p_entry_value3   OUT NOCOPY VARCHAR2
25 		,p_entry_value4   OUT NOCOPY VARCHAR2
26 		,p_entry_value5   OUT NOCOPY VARCHAR2
27 		,p_entry_value6   OUT NOCOPY VARCHAR2
28 		,p_entry_value7   OUT NOCOPY VARCHAR2
29 		,p_entry_value8   OUT NOCOPY VARCHAR2
30 		,p_entry_value9   OUT NOCOPY VARCHAR2
31 		,p_entry_value10  OUT NOCOPY VARCHAR2
32 		,p_entry_value11  OUT NOCOPY VARCHAR2
33 		,p_entry_value12  OUT NOCOPY VARCHAR2
34 		,p_entry_value13  OUT NOCOPY VARCHAR2
35 		,p_entry_value14  OUT NOCOPY VARCHAR2
36 		,p_entry_value15  OUT NOCOPY VARCHAR2
37 		,p_return_value1  OUT NOCOPY VARCHAR2
38 		,p_return_value2  OUT NOCOPY VARCHAR2
39 		,p_return_value3  OUT NOCOPY VARCHAR2
40 		);
41 
42 
43 FUNCTION get_element_link_id
44 	(
45 	 p_assignment_id     IN NUMBER
46 	,p_business_group_id IN NUMBER
47 	,p_date              IN per_all_assignments_f.effective_start_date%TYPE
48 	,p_element_name pay_element_types_f.ELEMENT_NAME%TYPE
49 	) RETURN NUMBER ;
50 
51 
52 END pay_dk_tc_dp_upload;
53