[Home] [Help]
PACKAGE: APPS.PAY_NO_TC_DP_UPLOAD
Source
1 PACKAGE pay_no_tc_dp_upload AUTHID CURRENT_USER 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;