DBA Data[Home] [Help]

PACKAGE: APPS.PAY_NO_TC_DP_UPLOAD

Source


1 PACKAGE pay_no_tc_dp_upload AS
2 /* $Header: pynotaxu.pkh 120.0 2005/05/29 07:02:10 appldev noship $ */
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 		);
40 
41 
42 FUNCTION get_element_link_id
43 	(
44 	p_assignment_id      IN NUMBER
45 	,p_business_group_id IN NUMBER
46 	,p_effective_date    IN VARCHAR2
47 	,p_element_name pay_element_types_f.ELEMENT_NAME%TYPE
48 	) RETURN NUMBER ;
49 
50 
51 END pay_no_tc_dp_upload;