1 PACKAGE AHL_UMP_SR_GRP AUTHID CURRENT_USER AS
2 /* $Header: AHLGUSRS.pls 115.0 2003/09/17 22:40:06 jaramana noship $ */
3
4 ------------------------
5 -- Declare Procedures --
6 ------------------------
7
8 -- Start of Comments --
9 -- Procedure name : Create_SR_Unit_Effectivity
10 -- Type : Public
11 -- Function : Group Hook API to create a SR type unit effectivity.
12 -- Called by the CMRO type Service Request as Post Insert Internal hook.
13 -- Uses CS_SERVICEREQUEST_PVT.USER_HOOKS_REC to get SR Details.
14 -- Pre-reqs :
15 -- Parameters :
16 --
17 -- x_return_status OUT VARCHAR2 Required
18 --
19 -- Version :
20 -- Initial Version 1.0
21 --
22 -- End of Comments.
23
24 PROCEDURE Create_SR_Unit_Effectivity
25 (
26 x_return_status OUT NOCOPY VARCHAR2
27 );
28
29 ----------------------------------------
30 -- Start of Comments --
31 -- Procedure name : Process_SR_Updates
32 -- Type : Public
33 -- Function : Group Hook API to process updates to a (current or former) CMRO type
34 -- SR by adding, removing or updating SR type unit effectivities.
35 -- Called by the Service Request as Post Update internal hook.
36 -- Uses CS_SERVICEREQUEST_PVT.USER_HOOKS_REC to get SR Details.
37 -- Pre-reqs :
38 -- Parameters :
39 --
40 -- x_return_status OUT VARCHAR2 Required
41 --
42 -- Version :
43 -- Initial Version 1.0
44 --
45 -- End of Comments.
46
47 PROCEDURE Process_SR_Updates
48 (
49 x_return_status OUT NOCOPY VARCHAR2
50 );
51
52 ----------------------------------------
53 -- Start of Comments --
54 -- Procedure name : Process_SR_MR_Associations
55 -- Type : Public
56 -- Function : Processes new and removed MR associations with a CMRO type SR.
57 -- This API will be called by the Service Request module whenever new MRs
58 -- are associated to or existing MRs are disassociated from a CMRO type SR.
59 -- Pre-reqs :
60 -- Parameters :
61 --
62 -- Standard IN Parameters :
63 -- p_api_version IN NUMBER Required
64 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
65 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
66 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
67 --
68 -- Standard OUT Parameters :
69 -- x_return_status OUT VARCHAR2 Required
70 -- x_msg_count OUT NUMBER Required
71 -- x_msg_data OUT VARCHAR2 Required
72 --
73 -- Process_SR_MR_Associations Parameters:
74 -- p_user_id IN NUMBER Required
75 -- The Id of the user calling this API
76 -- p_login_id IN NUMBER Required
77 -- The Login Id of the user calling this API
78 -- p_request_id IN NUMBER Required if p_request_number is null
79 -- The Id of the Service Request
80 -- p_object_version_number IN NUMBER Required
81 -- The object version number of the Service Request
82 -- p_request_number IN VARCHAR2 Required if p_request_id is null
83 -- The request number of the Service Request
84 -- p_x_sr_mr_association_tbl IN OUT NOCOPY AHL_UMP_SR_PVT.SR_MR_Association_Tbl_Type Required
85 -- The Table of records containing the details about the associations and disassociations
86 --
87 -- Version :
88 -- Initial Version 1.0
89 --
90 -- End of Comments.
91
92 PROCEDURE Process_SR_MR_Associations
93 (
94 p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
96 p_commit IN VARCHAR2 := FND_API.G_FALSE,
97 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 p_user_id IN NUMBER,
102 p_login_id IN NUMBER,
103 p_request_id IN NUMBER,
104 p_object_version_number IN NUMBER,
105 p_request_number IN VARCHAR2,
106 p_x_sr_mr_association_tbl IN OUT NOCOPY AHL_UMP_SR_PVT.SR_MR_Association_Tbl_Type
107 );
108
109 ----------------------------------------
110
111 End AHL_UMP_SR_GRP;