1 PACKAGE AHL_FMP_MR_REVISION_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVMRRS.pls 115.4 2004/01/13 23:25:19 rtadikon noship $ */
3 PROCEDURE CREATE_MR_REVISION
4 (
5 p_api_version IN NUMBER:=1.0,
6 p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
7 p_commit IN VARCHAR2:=FND_API.G_FALSE,
8 p_validation_level IN NUMBER:=FND_API.G_VALID_LEVEL_FULL,
9 p_default IN VARCHAR2:=FND_API.G_FALSE,
10 p_module_type IN VARCHAR2,
11 x_return_status OUT NOCOPY VARCHAR2,
12 x_msg_count OUT NOCOPY NUMBER,
13 x_msg_data OUT NOCOPY VARCHAR2,
14 p_source_mr_header_id IN NUMBER,
15 x_new_mr_header_id OUT NOCOPY NUMBER
16 );
17
18
19 PROCEDURE INITIATE_MR_APPROVAL
20 (
21 p_api_version IN NUMBER:=1.0,
22 p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
23 p_commit IN VARCHAR2:=FND_API.G_FALSE,
24 p_validation_level IN NUMBER:=FND_API.G_VALID_LEVEL_FULL,
25 p_default IN VARCHAR2:=FND_API.G_FALSE,
26 p_module_type IN VARCHAR2,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2,
30 p_source_mr_header_id IN NUMBER,
31 p_object_Version_number IN NUMBER,
32 p_apprv_type IN VARCHAR2:='COMPLETE'
33 );
34
35 PROCEDURE COMPLETE_MR_REVISION
36 (
37 p_api_version IN NUMBER:=1.0,
38 p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
39 p_commit IN VARCHAR2:=FND_API.G_FALSE,
40 p_validation_level IN NUMBER:=FND_API.G_VALID_LEVEL_FULL,
41 p_default IN VARCHAR2 := FND_API.G_FALSE,
42 p_module_type IN VARCHAR2,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_appr_status IN VARCHAR2,
47 p_mr_header_id IN NUMBER,
48 p_object_Version_number IN NUMBER
49 );
50
51 PROCEDURE VALIDATE_MR_REVISION
52 (
53 p_api_version IN NUMBER:=1.0,
54 p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
55 p_commit IN VARCHAR2:=FND_API.G_FALSE,
56 p_validation_level IN NUMBER:=FND_API.G_VALID_LEVEL_FULL,
57 p_default IN VARCHAR2 := FND_API.G_FALSE,
58 p_module_type IN VARCHAR2,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_source_mr_header_id IN NUMBER,
63 p_object_version_number IN NUMBER
64 );
65
66 END AHL_FMP_MR_REVISION_PVT;