DBA Data[Home] [Help]

PACKAGE: APPS.PAY_SE_TAX_CARD

Source


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