1 PACKAGE AHL_UMP_UNPLANNED_PVT AS
2 /* $Header: AHLVUUNS.pls 120.0 2005/05/26 00:09:02 appldev noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_UNPLANNED_PVT';
5
6 -------------------------------
7 -- Define records and tables --
8 -------------------------------
9
10 -----------------------
11 -- Define procedures --
12 -----------------------
13 -- Start of Comments --
14 --
15 -- Procedure name : Create_Unit_Effectivity
16 -- Type : Private
17 -- Function : API to create Unit Effectivities for a particular Instance Number and Maintenance Requirement
18 -- and all the related MRS of that MR and the corresponding Unit Effectivity Relationsships
19 -- Pre-reqs :
20 --
21 -- Standard IN Parameters :
22 -- p_api_version IN NUMBER Required
23 --
24 -- Standard OUT Parameters :
25 -- x_return_status OUT VARCHAR2 Required
26 -- x_msg_count OUT NUMBER Required
27 -- x_msg_data OUT VARCHAR2 Required
28 --
29 -- Create_Unit_Effectivity :
30 -- p_mr_header_id IN NUMBER Required
31 -- p_instance_id IN NUMBER Required
32 -- x_orig_ue_id OUT
33 --
34 -- Version :
35 -- Initial Version 1.0
36 --
37 -- End of Comments --
38
39
40 PROCEDURE Create_Unit_Effectivity
41 (
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
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_mr_header_id IN NUMBER ,
50 p_instance_id IN NUMBER ,
51 x_orig_ue_id OUT NOCOPY NUMBER
52 );
53
54 -----------------------
55 -- Define procedures --
56 -----------------------
57 -- Start of Comments --
58 --
59 -- Procedure name : Delete_Unit_Effectivity
60 -- Type : Private
61 -- Function : API to delete Unit Effectivities and the corresponding Unit Effectivities relationships
62 -- for a particular Unit Effectivity Id given as input.
63 --
64 -- Pre-reqs :
65 --
66 -- Standard IN Parameters :
67 -- p_api_version IN NUMBER Required
68 --
69 -- Standard OUT Parameters :
70 -- x_return_status OUT VARCHAR2 Required
71 -- x_msg_count OUT NUMBER Required
72 -- x_msg_data OUT VARCHAR2 Required
73 --
74 -- Delete_Unit_Effectivity :
75 -- p_ue_effectivity_id IN NUMBER
76 -- Version :
77 -- Initial Version 1.0
78 --
79 -- End of Comments --
80
81 PROCEDURE Delete_Unit_Effectivity
82 (
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
85 p_commit IN VARCHAR2 := FND_API.G_FALSE,
86 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 p_unit_effectivity_id IN NUMBER
91 );
92
93 End AHL_UMP_UNPLANNED_PVT;