[Home] [Help]
PACKAGE: APPS.PAY_FI_TC_DP_UPLOAD
Source
1 PACKAGE pay_fi_tc_dp_upload AS
2 /* $Header: pyfitaxu.pkh 120.0.12000000.1 2007/01/17 19:29:38 appldev noship $ */
3
4 PROCEDURE upload(
5 errbuf OUT NOCOPY VARCHAR2,
6 retcode OUT NOCOPY NUMBER,
7 p_file_name IN VARCHAR2,
8 p_effective_date IN VARCHAR2,
9 p_business_group_id IN per_business_groups.business_group_id%TYPE,
10 p_batch_name IN VARCHAR2 DEFAULT NULL ,
11 p_reference IN VARCHAR2 DEFAULT NULL
12 );
13
14 PROCEDURE read_record
15 (
16 p_line IN VARCHAR2
17 ,p_entry_value1 OUT NOCOPY VARCHAR2
18 ,p_entry_value2 OUT NOCOPY VARCHAR2
19 ,p_entry_value3 OUT NOCOPY VARCHAR2
20 ,p_entry_value4 OUT NOCOPY VARCHAR2
21 ,p_entry_value5 OUT NOCOPY VARCHAR2
22 ,p_entry_value6 OUT NOCOPY VARCHAR2
23 ,p_entry_value7 OUT NOCOPY VARCHAR2
24 ,p_entry_value8 OUT NOCOPY VARCHAR2
25 ,p_entry_value9 OUT NOCOPY VARCHAR2
26 ,p_entry_value10 OUT NOCOPY VARCHAR2
27 ,p_entry_value11 OUT NOCOPY VARCHAR2
28 ,p_entry_value12 OUT NOCOPY VARCHAR2
29 ,p_entry_value13 OUT NOCOPY VARCHAR2
30 ,p_entry_value14 OUT NOCOPY VARCHAR2
31 ,p_entry_value15 OUT NOCOPY VARCHAR2
32 ,p_return_value1 OUT NOCOPY VARCHAR2
33 ,p_return_value2 OUT NOCOPY VARCHAR2
34 ,p_return_value3 OUT NOCOPY VARCHAR2
35 );
36
37 FUNCTION get_element_link_id
38 (
39 p_assignment_id IN NUMBER
40 ,p_business_group_id IN NUMBER
41 ,p_effective_date IN VARCHAR2
42 ,p_element_name pay_element_types_f.ELEMENT_NAME%TYPE
43 ) RETURN NUMBER ;
44
45 END pay_fi_tc_dp_upload;