1 PACKAGE AHL_UMP_SR_PVT AS
2 /* $Header: AHLVUSRS.pls 120.2 2005/12/01 09:02:55 sracha noship $ */
3
4 ---------------------------------------------------------------------
5 -- Define Record Types for record structures needed by the APIs --
6 ---------------------------------------------------------------------
7 TYPE SR_MR_Association_Rec_Type IS RECORD (
8 OPERATION_FLAG VARCHAR2(1), -- 'C' (Create) or 'D' (Delete) Only
9 MR_TITLE VARCHAR2(80),
10 MR_VERSION NUMBER,
11 MR_HEADER_ID NUMBER,
12 UE_RELATIONSHIP_ID NUMBER, -- OUT parameter for Create Operation
13 UNIT_EFFECTIVITY_ID NUMBER, -- OUT parameter for Create Operation
14 OBJECT_VERSION_NUMBER NUMBER, -- OVN of Unit Effectivity, Mandatory for Delete
15 RELATIONSHIP_CODE VARCHAR2(30), -- Always 'PARENT' or null
16 CSI_INSTANCE_ID NUMBER, -- Instance to which the MR is associated
17 CSI_INSTANCE_NUMBER VARCHAR2(30)
18 );
19
20 ----------------------------------------------
21 -- Define Table Type for records structures --
22 ----------------------------------------------
23 TYPE SR_MR_Association_Tbl_Type IS TABLE OF SR_MR_Association_Rec_Type INDEX BY BINARY_INTEGER;
24
25 ------------------------
26 -- Declare Procedures --
27 ------------------------
28
29 -- Start of Comments --
30 -- Procedure name : Create_SR_Unit_Effectivity
31 -- Type : Private
32 -- Function : Private API to create a SR type unit effectivity. Called by corresponding Public procedure.
33 -- Uses CS_SERVICEREQUEST_PVT.USER_HOOKS_REC to get SR Details.
34 -- Pre-reqs :
35 -- Parameters :
36 -- x_return_status OUT VARCHAR2 Required
37 --
38 -- Version :
39 -- Initial Version 1.0
40 --
41 -- End of Comments.
42
43 PROCEDURE Create_SR_Unit_Effectivity
44 (
45 x_return_status OUT NOCOPY VARCHAR2
46 );
47
48 ----------------------------------------
49 -- Start of Comments --
50 -- Procedure name : Process_SR_Updates
51 -- Type : Private
52 -- Function : Private API to process changes to a (current or former) CMRO type SR
53 -- by adding, removing or updating SR type unit effectivities.
54 -- Called by the corresponding public procedure.
55 -- Uses CS_SERVICEREQUEST_PVT.USER_HOOKS_REC to get SR Details.
56 -- Pre-reqs :
57 -- Parameters :
58 -- x_return_status OUT VARCHAR2 Required
59 --
60 -- Version :
61 -- Initial Version 1.0
62 --
63 -- End of Comments.
64
65 PROCEDURE Process_SR_Updates
66 (
67 x_return_status OUT NOCOPY VARCHAR2
68 );
69
70 ----------------------------------------
71 -- Start of Comments --
72 -- Procedure name : Process_SR_MR_Associations
73 -- Type : Private
74 -- Function : Processes new and removed MR associations with a CMRO type SR by
75 -- creating or removing unit effectivities and corresponding relationships.
76 -- Called by the corresponding public procedure.
77 -- Pre-reqs :
78 -- Parameters :
79 --
80 -- Standard IN Parameters :
81 -- p_api_version IN NUMBER Required
82 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
83 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
84 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
85 --
86 -- Standard OUT Parameters :
87 -- x_return_status OUT VARCHAR2 Required
88 -- x_msg_count OUT NUMBER Required
89 -- x_msg_data OUT VARCHAR2 Required
90 --
91 -- Process_SR_MR_Associations Parameters:
92 -- p_user_id IN NUMBER Required
93 -- The Id of the user calling this API
94 -- p_login_id IN NUMBER Required
95 -- The Login Id of the user calling this API
96 -- p_request_id IN NUMBER Required if p_request_number is null
97 -- The Id of the Service Request
98 -- p_object_version_number IN NUMBER Required
99 -- The object version number of the Service Request
100 -- p_request_number IN VARCHAR2 Required if p_request_id is null
101 -- The request number of the Service Request
102 -- p_x_sr_mr_association_tbl IN OUT AHL_UMP_SR_PVT.SR_MR_Association_Tbl_Type Required
103 -- The Table of records containing the details about the associations and disassociations
104 --
105 -- Version :
106 -- Initial Version 1.0
107 --
108 -- End of Comments.
109
110 PROCEDURE Process_SR_MR_Associations
111 (
112 p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114 p_commit IN VARCHAR2 := FND_API.G_FALSE,
115 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2,
119 p_user_id IN NUMBER,
120 p_login_id IN NUMBER,
121 p_request_id IN NUMBER,
122 p_object_version_number IN NUMBER,
123 p_request_number IN VARCHAR2,
124 p_x_sr_mr_association_tbl IN OUT NOCOPY AHL_UMP_SR_PVT.SR_MR_Association_Tbl_Type
125 );
126
127 ----------------------------------------
128
129 End AHL_UMP_SR_PVT;