1 PACKAGE INV_CHECK_PRODUCT_INSTALL AUTHID CURRENT_USER AS
2 /* $Header: INVNLINS.pls 120.0 2005/05/25 05:28:35 appldev noship $ */
3
4 g_cse_installation_status VARCHAR2(10):= NULL;
5 g_eam_installed VARCHAR2(1) := NULL ;
6 g_fte_installed VARCHAR2(1) := NULL;
7 /*
8 ** -------------------------------------------------------------------------
9 ** Function: check_cse_install
10 ** Description: Checks to see if CSE is installed
11 ** Output:
12 ** x_return_status
13 ** return status indicating success, error, unexpected error
14 ** x_msg_count
15 ** number of messages in message list
16 ** x_msg_data
17 ** if the number of messages in message list is 1, contains
18 ** message text
19 ** Input:
20 ** Returns:
21 ** TRUE if CSE installed, else FALSE
22 **
23 ** Please use return value to determine if WMS is installed or not.
24 ** Do not use x_return_status for this purpose as
25 ** . x_return_status could be success and yet WMS not be installed.
26 ** . x_return_status is set to error when an error(such as SQL error)
27 ** occurs.
28 ** --------------------------------------------------------------------------
29 */
30
31 FUNCTION check_cse_install (
32 x_return_status OUT NOCOPY VARCHAR2
33 , x_msg_count OUT NOCOPY NUMBER
34 , x_msg_data OUT NOCOPY VARCHAR2
35 ) return boolean;
36
37 FUNCTION check_cse_install return varchar2;
38
39 PROCEDURE check_eam_installed
40 (x_eam_installed OUT NOCOPY VARCHAR2
41 , x_industry OUT NOCOPY VARCHAR2
42 , x_return_status OUT NOCOPY VARCHAR2
43 , x_msg_count OUT NOCOPY NUMBER
44 , x_msg_data OUT NOCOPY VARCHAR2) ;
45
46 PROCEDURE check_fte_installed
47 (x_fte_installed OUT NOCOPY VARCHAR2
48 , x_industry OUT NOCOPY VARCHAR2
49 , x_return_status OUT NOCOPY VARCHAR2
50 , x_msg_count OUT NOCOPY NUMBER
51 , x_msg_data OUT NOCOPY VARCHAR2) ;
52
53 END INV_CHECK_PRODUCT_INSTALL;