DBA Data[Home] [Help]

PACKAGE: APPS.AHL_FMP_MR_REVISION_PVT

Source


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;