1 PACKAGE PO_VMI_ENABLED AUTHID CURRENT_USER AS
2 /* $Header: POXPVIES.pls 115.2 2002/11/23 02:08:38 sbull noship $ */
3
4 /*
5 ** -------------------------------------------------------------------------
6 ** Function: check_vmi_enabled
7 ** Description: This function is called from Inventory OrganizationParameters
8 ** form(INVSDOIO.fmb). When a value of true is returned by the API, the form
9 ** disallows enabling of wms for that organization.
10 ** Output:
11 ** x_return_status
12 ** return status indicating success, error, unexpected error
13 ** x_msg_count
14 ** number of messages in message list
15 ** x_msg_data
16 ** if the number of messages in message list is 1, contains
17 ** message text
18 ** Input:
19 ** p_organization_id
20 ** -specific organization to be checked if VMI enabled.
21 **
22 ** Returns:
23 ** TRUE if VMI enabled, else FALSE
24 **
25 ** Please use return value to determine if VMI is installed or not.
26 ** Do not use x_return_status for this purpose as
27 ** . x_return_status could be success and yet VMI not be installed.
28 ** . x_return_status is set to error when an error(such as SQL error)
29 ** occurs.
30 ** --------------------------------------------------------------------------*/
31
32 function check_vmi_enabled(
33 x_return_status OUT NOCOPY VARCHAR2
34 ,x_msg_count OUT NOCOPY NUMBER
35 ,x_msg_data OUT NOCOPY VARCHAR2
36 ,p_organization_id IN NUMBER)
37 return boolean;
38
39 end PO_VMI_ENABLED;