1 PACKAGE PV_EXT_TEAM_COMMON_PVT AS
2 /* $Header: pvxvcoms.pls 120.0 2005/05/27 15:46:50 appldev noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_EXT_TEAM_COMMON_PVT';
5 G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvcoms.pls';
6
7
8 /*============================================================================
9 -- Start of comments
10 -- API name : chk_oppty_approver
11 -- Type : Function.
12 -- Function : This function return the value 'Y' or 'N' based on the
13 -- findings that the given user is a Opportunity Approver
14 -- or not.
15 --
16 --
17 --
18 --
19 --
20 --
21 --
22 -- Pre-reqs :
23 -- Parameters :
24 -- IN :
25 -- p_user_name In VARCHAR2
26 --
27 -- OUT :
28 --
29 -- Version : Current version 1.0
30 --
31 -- Notes : Note text
32 --
33 -- End of comments
34 ============================================================================*/
35 FUNCTION chk_oppty_approver(p_user_name IN VARCHAR2 )
36 RETURN VARCHAR2 ;
37
38 END PV_EXT_TEAM_COMMON_PVT;