DBA Data[Home] [Help]

PACKAGE: APPS.PAY_FUNCTIONAL_AREAS_PKG

Source


1 PACKAGE pay_functional_areas_pkg AUTHID CURRENT_USER AS
2 -- $Header: pypfaapi.pkh 115.3 2002/12/11 15:13:24 exjones noship $
3 --
4 	PROCEDURE lock_row(
5 		p_row_id        IN VARCHAR2,
6  		p_area_id	IN NUMBER,
7  		p_short_name	IN VARCHAR2,
8  		p_description 	IN VARCHAR2
9  	);
10 --
11 	PROCEDURE insert_row(
12 		p_row_id        IN out nocopy VARCHAR2,
13  		p_area_id	IN out nocopy NUMBER,
14  		p_short_name	IN VARCHAR2,
15  		p_description 	IN VARCHAR2
16  	);
17 --
18 	PROCEDURE update_row(
19 		p_row_id        IN VARCHAR2,
20  		p_area_id	IN NUMBER,
21  		p_short_name	IN VARCHAR2,
22  		p_description 	IN VARCHAR2
23  	);
24 --
25 	PROCEDURE delete_row(
26 		p_row_id        IN VARCHAR2,
27  		p_area_id	IN NUMBER
28  	);
29 --
30 	FUNCTION name_is_not_unique(
31 		p_short_name       VARCHAR2,
32 		p_area_id          NUMBER  default null
33 	) return BOOLEAN;
34 --
35 END pay_functional_areas_pkg;