1 PACKAGE INV_Kanban_GRP AUTHID CURRENT_USER as
2 /* $Header: INVGKBNS.pls 115.1 2003/08/21 00:40:24 cjandhya noship $ */
3
4
5
6 /*****************************************************************
7 ** API name INV_KANBAN_GRP
8 ** Type Group
9 **
10 **
11 **Version Current version = 1.0
12 ** Initial version = 1.0
13 **Name
14 ** PROCEDURE UPDATE_CARD_SUPPLY_STATUS
15 **
16 ** Purpose
17 ** This procedure updates the supply status of the kanban card.
18 ** Input parameters
19 ** p_api_version IN NUMBER (required)
20 ** API Version of this procedure
21 ** p_init_msg_level IN VARCHAR2 (optional)
22 ** DEFAULT = FND_API.G_FALSE,
23 ** p_commit IN VARCHAR2 (optional)
24 ** DEFAULT = FND_API.G_FALSE,
25 ** p_kanban_card_id In VARCHAR2 (required)
26 ** kanban card id to be updated
27 ** p_supply_status IN varchar2 (required)
28 ** INV_KANBAN_PVT.G_Supply_Status_New
29 ** INV_KANBAN_PVT.G_Supply_Status_Full
30 ** INV_KANBAN_PVT.G_Supply_Status_Empty
31 ** INV_KANBAN_PVT.G_Supply_Status_InProcess
32 ** INV_KANBAN_PVT.G_Supply_Status_InTransit
33 ** p_document_type IN NUMBER
34 ** INV_KANBAN_PVT.G_Doc_type_PO 1;
35 ** INV_KANBAN_PVT.G_Doc_type_Release 2;
36 ** INV_KANBAN_PVT.G_Doc_type_Internal_Req 3;
37 ** INV_KANBAN_PVT.G_Doc_type_Transfer_Order 4;
38 ** INV_KANBAN_PVT.G_Doc_type_Discrete_Job 5;
39 ** INV_KANBAN_PVT.G_Doc_type_Rep_Schedule 6;
40 ** INV_KANBAN_PVT.G_Doc_type_Flow_Schedule 7;
41 ** INV_KANBAN_PVT.G_Doc_type_lot_job 8;
42 ** p_Document_Header_Id IN NUMBER
43 ** Document header id displayed on card activity
44 ** p_Document_detail_Id IN NUMBER
45 ** Document detail id displayed on card activity
46 ** p_need_by_date IN DATE
47 ** Need by date to be specified on the requisition
48 ** P_replenish_quantity IN NUMBER
49 ** Overrides the kanban size if passed
50 ** p_source_wip_entity_id IN NUMBER
51 ** SOURCE_WIP_ENTITY diplayed on card activity.
52 ** Output Parameters
53 ** x_msg_count - number of error messages in the buffer
54 ** x_msg_data - error messages
55 ** x_return_status - fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_success,
56 ** fnd_api.g_ret_unexp_error
57 ******************************************************************/
58
59
60 Procedure UPDATE_CARD_SUPPLY_STATUS
61 (x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2,
63 x_return_status OUT NOCOPY VARCHAR2,
64 p_api_version_number IN NUMBER,
65 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
66 p_commit IN VARCHAR2 := FND_API.G_FALSE,
67 p_kanban_card_id IN NUMBER,
68 p_supply_status IN NUMBER,
69 p_document_type IN NUMBER DEFAULT NULL,
70 p_document_header_id IN NUMBER DEFAULT NULL,
71 p_document_detail_id IN NUMBER DEFAULT NULL,
72 p_replenish_quantity IN NUMBER DEFAULT NULL,
73 p_need_by_date IN DATE DEFAULT NULL,
74 p_source_wip_entity_id IN NUMBER DEFAULT NULL
75 );
76
77 /*****************************************************************
78 **API name INV_KANBAN_GRP
79 **Type Group
80 **
81 **Version Current version = 1.0
82 ** Initial version = 1.0
83 **Name
84 ** PROCEDURE CREATE_NON_REPLENISHABLE_CARD
85 **
86 ** Purpose
87 ** This procedure creates a non replenishable card
88 ** Input parameters
89 ** p_pull_sequence_id IN NUMBER
90 ** Pullsequence id to be associated with the non
91 ** replenishable kanban card
92 **** Output Parameters
93 ** x_msg_count number of error messages in the buffer
94 ** x_msg_data error messages
95 ** x_return_status fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_success,
96 ** fnd_api.g_ret_unexp_error
97 ** x_kanban_card_id Kanban_card_id of the card generated
98 ******************************************************************/
99
100 PROCEDURE CREATE_NON_REPLENISHABLE_CARD
101 (x_return_status Out NOCOPY VARCHAR2,
102 x_msg_data OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_kanban_card_id OUT NOCOPY NUMBER,
105 p_pull_sequence_id IN NUMBER,
106 p_kanban_size IN NUMBER);
107
108 END INV_KANBAN_GRP;