1 PACKAGE GMD_STATUS_PUB AUTHID CURRENT_USER AS
2 /* $Header: GMDPSTSS.pls 115.1 2004/04/16 14:35:52 srsriran noship $ */
3 /*#
4 * This interface is used to modify the Status of an entity (Formula, Recipe,
5 * Operation, Routing, Validity Rule). This package defines and implements the
6 * procedure and datatypes required to modify entity status after proper validations.
7 * @rep:scope public
8 * @rep:product GMD
9 * @rep:lifecycle active
10 * @rep:displayname Status package
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY GMD_STATUS_PUB
13 */
14
15 m_api_version CONSTANT NUMBER := 1;
16 m_pkg_name CONSTANT VARCHAR2 (30) := 'GMD_STATUS_PUB';
17
18 /*#
19 * Modify Entity Status
20 * This is a PL/SQL procedure to modify the Status of an entity.
21 * Proper validations are performed before modifying the entity status.
22 * @param p_api_version API version field
23 * @param p_init_msg_list Flag to check if message list intialized
24 * @param p_entity_name Entity Name (eg. Formula Name)
25 * @param p_entity_id Entity ID (eg. Formula ID)
26 * @param p_entity_no Entity Number (eg. Formula Number)
27 * @param p_entity_version Entity Version (eg. Formula Version)
28 * @param p_to_status Target Status
29 * @param p_ignore_flag Flag to check if Validity rule status is to be changed along with Recipe
30 * @param x_message_count Number of msg's on message stack
31 * @param x_message_list Message list
32 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
33 * @rep:scope public
34 * @rep:lifecycle active
35 * @rep:displayname Modify Status procedure
36 * @rep:compatibility S
37 */
38 PROCEDURE modify_status
39 ( p_api_version IN NUMBER := 1
40 , p_init_msg_list IN BOOLEAN := TRUE
41 , p_entity_name IN VARCHAR2
42 , p_entity_id IN NUMBER := NULL
43 , p_entity_no IN VARCHAR2 := NULL
44 , p_entity_version IN NUMBER := NULL
45 , p_to_status IN VARCHAR2
46 , p_ignore_flag IN BOOLEAN := FALSE
47 , x_message_count OUT NOCOPY NUMBER
48 , x_message_list OUT NOCOPY VARCHAR2
49 , x_return_status OUT NOCOPY VARCHAR2
50 );
51
52
53 END GMD_STATUS_PUB;