1 PACKAGE AMS_REL_ITEM_PVT AUTHID CURRENT_USER as
2 /* $Header: amsvrits.pls 115.3 2002/11/11 22:07:01 abhola ship $ */
3 -- Start of Comments
4 -- Package name : AMS_REL_ITEM_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:REL_ITEM_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- INVENTORY_ITEM_ID
19 -- ORGANIZATION_ID
20 -- RELATED_ITEM_ID
21 -- RELATIONSHIP_TYPE_ID
22 -- RECIPROCAL_FLAG
23 -- LAST_UPDATE_DATE
24 -- LAST_UPDATED_BY
25 -- CREATION_DATE
26 -- CREATED_BY
27 -- LAST_UPDATE_LOGIN
28 -- REQUEST_ID
29 -- PROGRAM_APPLICATION_ID
30 -- PROGRAM_ID
31 -- PROGRAM_UPDATE_DATE
32 --
33 -- Required:
34 -- Defaults:
35 -- Note: This is automatic generated record definition, it includes all columns
36 -- defined in the table, developer must manually add or delete some of the attributes.
37 --
38 -- End of Comments
39
40 TYPE REL_ITEM_Rec_Type IS RECORD
41 (
42 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
43 ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
44 RELATED_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
45 RELATIONSHIP_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
46 RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
48 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
49 CREATION_DATE DATE := FND_API.G_MISS_DATE,
50 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
51 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
52 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
53 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
54 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
55 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
56 );
57
58 G_MISS_REL_ITEM_REC REL_ITEM_Rec_Type;
59 TYPE REL_ITEM_Tbl_Type IS TABLE OF REL_ITEM_Rec_Type
60 INDEX BY BINARY_INTEGER;
61 G_MISS_REL_ITEM_TBL REL_ITEM_Tbl_Type;
62
63 -- *******************************************************
64 -- Start of Comments
65 -- *******************************************************
66 -- API Name: Create_rel_item
67 -- Type : Private
68 -- Pre-Req :
69 -- Parameters:
70 -- IN
71 -- p_api_version_number IN NUMBER Required
72 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
73 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
74 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
75 -- P_REL_ITEM_Rec IN REL_ITEM_Rec_Type Required
76 --
77 -- OUT:
78 -- x_return_status OUT VARCHAR2
79 -- x_msg_count OUT NUMBER
80 -- x_msg_data OUT VARCHAR2
81 -- Version : Current version 1.0
82 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
83 -- and basic operation, developer must manually add parameters and business logic as necessary.
84 --
85 -- End of Comments
86 --
87 PROCEDURE Create_rel_item(
88 P_Api_Version_Number IN NUMBER,
89 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
90 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
91 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92
93 X_Return_Status OUT NOCOPY VARCHAR2,
94 X_Msg_Count OUT NOCOPY NUMBER,
95 X_Msg_Data OUT NOCOPY VARCHAR2,
96
97 P_REL_ITEM_Rec IN REL_ITEM_Rec_Type := G_MISS_REL_ITEM_REC
98 );
99
100 -- *******************************************************
101 -- Start of Comments
102 -- *******************************************************
103 -- API Name: Update_rel_item
104 -- Type : Private
105 -- Pre-Req :
106 -- Parameters:
107 -- IN
108 -- p_api_version_number IN NUMBER Required
109 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
110 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
112 -- P_REL_ITEM_Rec IN REL_ITEM_Rec_Type Required
113 --
114 -- OUT:
115 -- x_return_status OUT NOCOPY VARCHAR2
116 -- x_msg_count OUT NOCOPY NUMBER
117 -- x_msg_data OUT NOCOPY VARCHAR2
118 -- Version : Current version 1.0
119 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
120 -- and basic operation, developer must manually add parameters and business logic as necessary.
121 --
122 -- End of Comments
123 --
124 PROCEDURE Update_rel_item(
125 P_Api_Version_Number IN NUMBER,
126 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
127 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
128 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
129
130 X_Return_Status OUT NOCOPY VARCHAR2,
131 X_Msg_Count OUT NOCOPY NUMBER,
132 X_Msg_Data OUT NOCOPY VARCHAR2,
133
134 P_REL_ITEM_Rec IN REL_ITEM_Rec_Type
135 );
136
137 -- *******************************************************
138 -- Start of Comments
139 -- *******************************************************
140 -- API Name: Delete_rel_item
141 -- Type : Private
142 -- Pre-Req :
143 -- Parameters:
144 -- IN
145 -- p_api_version_number IN NUMBER Required
146 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
147 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
148 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
149 -- p_RELATED_ITEM_ID IN NUMBER
150 -- p_object_version_number IN NUMBER Optional Default = NULL
151 --
152 -- OUT:
153 -- x_return_status OUT VARCHAR2
154 -- x_msg_count OUT NUMBER
155 -- x_msg_data OUT VARCHAR2
156 -- Version : Current version 1.0
157 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
158 -- and basic operation, developer must manually add parameters and business logic as necessary.
159 --
160 -- End of Comments
161 --
162 PROCEDURE Delete_rel_item(
163 P_Api_Version_Number IN NUMBER,
164 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
165 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
166 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167 X_Return_Status OUT NOCOPY VARCHAR2,
168 X_Msg_Count OUT NOCOPY NUMBER,
169 X_Msg_Data OUT NOCOPY VARCHAR2,
170 P_REL_ITEM_Rec IN REL_ITEM_Rec_Type
171 );
172
173
174 -- Start of Comments
175 --
176 -- Record level validation procedures
177 --
178 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
179 -- For create: G_CREATE, for update: G_UPDATE
180 -- Note: 1. This is automated generated item level validation procedure.
181 -- The actual validation detail is needed to be added.
182 -- 2. Developer can manually added inter-field level validation.
183 -- End of Comments
184
185 PROCEDURE Validate_REL_ITEM_rec(
186 P_Api_Version_Number IN NUMBER,
187 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
188 X_Return_Status OUT NOCOPY VARCHAR2,
189 X_Msg_Count OUT NOCOPY NUMBER,
190 X_Msg_Data OUT NOCOPY VARCHAR2,
191 P_REL_ITEM_Rec IN REL_ITEM_Rec_Type
192 );
193
194 -- Start of Comments
195 --
196 -- validation procedures
197 --
198 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
199 -- For create: G_CREATE, for update: G_UPDATE
200 -- Note: 1. This is automated generated item level validation procedure.
201 -- The actual validation detail is needed to be added.
202 -- 2. We can also validate table instead of record. There will be an option for user to choose.
203 -- End of Comments
204
205 PROCEDURE Validate_rel_item(
206 P_Api_Version_Number IN NUMBER,
207 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
208 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209 P_REL_ITEM_Rec IN REL_ITEM_Rec_Type,
210 X_Return_Status OUT NOCOPY VARCHAR2,
211 X_Msg_Count OUT NOCOPY NUMBER,
212 X_Msg_Data OUT NOCOPY VARCHAR2
213 );
214 End AMS_REL_ITEM_PVT;