DBA Data[Home] [Help]

PACKAGE: APPS.WSM_LOTATTR_PVT

Source


1 PACKAGE WSM_LotAttr_PVT AUTHID CURRENT_USER as
2 /* $Header: WSMVATRS.pls 120.1 2006/06/01 13:21:42 sisankar noship $ */
3 
4 g_debug BOOLEAN:=(FND_PROFILE.VALUE('MRP_DEBUG')='Y');
5 
6 l_miss_char  CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
7 l_miss_date  CONSTANT DATE        := FND_API.G_MISS_DATE;
8 l_miss_num   CONSTANT NUMBER      := FND_API.G_MISS_NUM;
9 
10 PROCEDURE create_update_lotattr(x_err_code	 OUT NOCOPY VARCHAR2,
11 		                x_err_msg        OUT NOCOPY VARCHAR2,
12 				p_lot_number     IN   VARCHAR2,
13                                 p_inv_item_id    IN   NUMBER,
14                                 p_org_id         IN   NUMBER,
15 		 		p_intf_txn_id    IN   NUMBER,
16 	                        p_intf_src_code  IN   VARCHAR2,
17 				p_src_lot_number IN   VARCHAR2 DEFAULT NULL,
18                                 p_src_inv_item_id IN  NUMBER   DEFAULT NULL);
19 
20 Procedure create_update_lotattr(x_err_code	 OUT NOCOPY VARCHAR2,
21 		                x_err_msg        OUT NOCOPY VARCHAR2,
22 				p_wip_entity_id  IN   NUMBER, --*WIP_ENTITY_ID
23                                 --****p_inv_item_id    IN   NUMBER,
24                                 p_org_id         IN   NUMBER,
25 		 		p_intf_txn_id    IN   NUMBER,
26 	                        p_intf_src_code  IN   VARCHAR2,
27 				p_src_lot_number IN   VARCHAR2 DEFAULT NULL,
28                                 p_src_inv_item_id IN  NUMBER   DEFAULT NULL);
29 
30 END WSM_LotAttr_PVT;