1 PACKAGE AHL_LTP_MATERIALS_GRP AUTHID CURRENT_USER AS
2 /* $Header: AHLGMTLS.pls 120.0.12010000.1 2010/02/25 06:45:23 skpathak noship $ */
3 /*
4 * This Group package spec provides the apis which will be invoked from the PS
5 * basically for updating material requirement date and serial reservation dates
6 * with WO scheduled start date
7 */
8
9 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_LTP_MATERIALS_GRP';
10
11
12 ----------------------------------------
13 -- Start of Comments --
14 -- Procedure name : Update_mtl_resv_dates
15 -- Type : Public
16 -- Function : Update material requirement date and serial
17 -- reservation dates with WO scheduled start date
18 -- Pre-reqs :
19 -- Parameters :
20 --
21 -- Standard IN Parameters :
22 -- p_api_version IN NUMBER Required
23 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
24 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
25 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
26 --
27 -- Standard OUT Parameters :
28 -- x_return_status OUT VARCHAR2 Required
29 -- x_msg_count OUT NUMBER Required
30 -- x_msg_data OUT VARCHAR2 Required
31 --
32 -- Update_mtl_resv_dates Parameters:
33 -- p_wip_entity_id IN NUMBER Required
34 --
35 -- Version :
36 -- Initial Version 1.0
37 --
38 -- End of Comments.
39
40 PROCEDURE Update_mtl_resv_dates
41 (
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44 p_commit IN VARCHAR2 := FND_API.G_FALSE,
45 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2,
49 p_wip_entity_id IN NUMBER
50 );
51
52
53 END AHL_LTP_MATERIALS_GRP;