[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