1 PACKAGE INV_Kanban_PUB AUTHID CURRENT_USER as
2 /* $Header: INVPKBNS.pls 120.1 2005/06/14 06:02:33 appldev $ */
3 /*#
4 * This package provides routines for performing replenishment through
5 * Kanban cards
6 * @rep:scope public
7 * @rep:product INV
8 * @rep:lifecycle active
9 * @rep:displayname Kanban Replenishment
10 * @rep:category BUSINESS_ENTITY INV_REPLENISHMENT
11 */
12 -- API name Update_Card_Supply_Status
13 -- Type Public
14 --
15 -- Version Current version = 1.0
16 -- Initial version = 1.0
17 --
18 -- Name
19 -- PROCEDURE Update_Card_Supply_Status
20 --
21 -- Purpose
22 -- This procedure updates the supply status of the kanban card.
23 -- Input parameters
24 -- p_api_version IN NUMBER (required)
25 -- API Version of this procedure
26 -- p_init_msg_level IN VARCHAR2 (optional)
27 -- DEFAULT = FND_API.G_FALSE,
28 -- p_commit IN VARCHAR2 (optional)
29 -- DEFAULT = FND_API.G_FALSE,
30 -- p_kanban_card_id In VARCHAR2 (required)
31 -- kanban card id to be updated
32 -- p_supply_status IN varchar2 (required)
33 -- INV_KANBAN_PVT.G_Supply_Status_New
34 -- INV_KANBAN_PVT.G_Supply_Status_Full
35 -- INV_KANBAN_PVT.G_Supply_Status_Empty
36 -- INV_KANBAN_PVT.G_Supply_Status_InProcess
37 -- INV_KANBAN_PVT.G_Supply_Status_InTransit
38 --
39 -- Output Parameters
40 -- x_msg_count - number of error messages in the buffer
41 -- x_msg_data - error messages
42 -- x_return_status - fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_success,
43 -- fnd_api.g_ret_unexp_error
44 --
45 /*#
46 * This procedure updates the supply status of the kanban card to the given
47 * status, triggering
48 * a replenishment if the status is being changed to Empty.
49 * @param p_api_version_number API Version of this procedure. Current version is 1.0
50 * @param p_init_msg_list Indicates whether message stack is to be initialized
51 * @param p_commit Indicates whether a commit has to performed within the procedure on successful processing
52 * @param p_kanban_card_id Kanban Card Identifier to be processed
53 * @param p_supply_status Indicates the supply status to which kanban card is to be updated to.
54 * @param x_msg_data return variable holding the error message
55 * @param x_msg_count return variable holding the number of error messages returned
56 * @param x_return_status return variable holding the status of the procedure call
57 * @rep:displayname Update Kanban Card Supply Status
58 */
59 Procedure Update_Card_Supply_Status
60 (p_api_version_number IN NUMBER,
61 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62 p_commit IN VARCHAR2 := FND_API.G_FALSE,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 X_Return_Status OUT NOCOPY Varchar2,
66 p_Kanban_Card_Id Number,
67 p_Supply_Status Number);
68
69 END INV_Kanban_PUB;