[Home] [Help]
PACKAGE: APPS.BOM_REF_DESIGNATOR_UTIL
Source
1 PACKAGE BOM_Ref_Designator_Util AUTHID CURRENT_USER AS
2 /* $Header: BOMURFDS.pls 120.0.12010000.2 2010/02/03 17:19:56 umajumde ship $ */
3 /*#
4 * This API contains entity utility method for the Bill of Materials Reference
5 * Designators.
6 * @rep:scope private
7 * @rep:product BOM
8 * @rep:displayname BOM Reference Designator Util Package
9 * @rep:lifecycle active
10 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
11 */
12 /***************************************************************************
13 --
14 -- Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
15 -- All rights reserved.
16 --
17 -- FILENAME
18 --
19 -- BOMURFDS.pls
20 --
21 -- DESCRIPTION
22 --
23 -- Spec of package BOM_Ref_Designator_Util
24 --
25 -- NOTES
26 --
27 -- HISTORY
28 --
29 -- 19-JUL-1999 Rahul Chitko Initial Creation
30 --
31 *****************************************************************************/
32 -- Attributes global constants
33
34 G_REF_DESIGNATOR CONSTANT NUMBER := 1;
35 G_LAST_UPDATE_DATE CONSTANT NUMBER := 2;
36 G_LAST_UPDATED_BY CONSTANT NUMBER := 3;
37 G_CREATION_DATE CONSTANT NUMBER := 4;
38 G_CREATED_BY CONSTANT NUMBER := 5;
39 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 6;
40 G_REF_DESIGNATOR_COMMENT CONSTANT NUMBER := 7;
41 G_CHANGE_NOTICE CONSTANT NUMBER := 8;
42 G_COMPONENT_SEQUENCE CONSTANT NUMBER := 9;
43 G_ACD_TYPE CONSTANT NUMBER := 10;
44 G_REQUEST CONSTANT NUMBER := 11;
45 G_PROGRAM_APPLICATION CONSTANT NUMBER := 12;
46 G_PROGRAM CONSTANT NUMBER := 13;
47 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 14;
48 G_ATTRIBUTE_CATEGORY CONSTANT NUMBER := 15;
49 G_ATTRIBUTE1 CONSTANT NUMBER := 16;
50 G_ATTRIBUTE2 CONSTANT NUMBER := 17;
51 G_ATTRIBUTE3 CONSTANT NUMBER := 18;
52 G_ATTRIBUTE4 CONSTANT NUMBER := 19;
53 G_ATTRIBUTE5 CONSTANT NUMBER := 20;
54 G_ATTRIBUTE6 CONSTANT NUMBER := 21;
55 G_ATTRIBUTE7 CONSTANT NUMBER := 22;
56 G_ATTRIBUTE8 CONSTANT NUMBER := 23;
57 G_ATTRIBUTE9 CONSTANT NUMBER := 24;
58 G_ATTRIBUTE10 CONSTANT NUMBER := 25;
59 G_ATTRIBUTE11 CONSTANT NUMBER := 26;
60 G_ATTRIBUTE12 CONSTANT NUMBER := 27;
61 G_ATTRIBUTE13 CONSTANT NUMBER := 28;
62 G_ATTRIBUTE14 CONSTANT NUMBER := 29;
63 G_ATTRIBUTE15 CONSTANT NUMBER := 30;
64 G_MAX_ATTR_ID CONSTANT NUMBER := 31;
65
66 -- Procedure Clear_Dependent_Attr
67
68 /*#
69 * Clear Dependent Attributes
70 * @param p_attr_id attribute id
71 * @param p_ref_designator_rec reference designator record
72 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
73 * @param p_old_ref_designator_rec old reference designator record. This is defaulted to
74 * Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
75 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
76 * @param x_ref_designator_rec returned reference designator record
77 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
78 * @rep:scope private
79 * @rep:lifecycle active
80 * @rep:displayname Clear Dependent Attributes
81 */
82
83
84 PROCEDURE Clear_Dependent_Attr
85 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
86 , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
87 , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
88 Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
89 , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
90 );
91
92 --added for bug 7713832
93 FUNCTION Common_CompSeqIdRD( p_comp_seq_id NUMBER)
94 RETURN NUMBER;
95
96 -- Procedure Apply_Attribute_Changes
97
98 /*#
99 * Apply Attribute Changes
100 * @param p_ref_designator_rec reference designator record
101 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
102 * @param p_old_ref_designator_rec old reference designator record. This is defaulted to
103 * Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
104 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
105 * @param x_ref_designator_rec returned reference designator record
106 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
107 * @rep:scope private
108 * @rep:lifecycle active
109 * @rep:displayname Apply Attribute Changes
110 */
111
112 PROCEDURE Apply_Attribute_Changes
113 ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
114 , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
115 Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
116 , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
117 );
118
119 -- Function Convert_Miss_To_Null
120
121 /*#
122 * This method will convert the missing values of some attributes that the user wishes to NULL
123 * This can be used with ECO
124 * @param p_ref_designator_rec the record that need to be converted
125 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
126 * @return the converted record
127 * @rep:scope private
128 * @rep:lifecycle active
129 * @rep:displayname Convert Miss To Null
130 */
131
132
133 FUNCTION Convert_Miss_To_Null
134 ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
135 ) RETURN Bom_Bo_Pub.Ref_Designator_Rec_Type;
136
137 -- Function Query_Row
138
139 /*#
140 * This method will query the database record, seperate the values into exposed columns
141 * and unexposed columns and return with those records.This can be used with ECO
142 * @param p_ref_designator This with the next two parameters form Reference Designator Key
143 * @param p_component_sequence_id component sequence id
144 * @param p_acd_type acd type
145 * @param x_Ref_Designator_Rec Reference Designator Record of exposed columns
146 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
147 * @param x_Ref_Desg_Unexp_Rec Reference Designator Record of Unexposed Columns
148 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type}
149 * @param x_Return_Status Indicating success or faliure
150 * @rep:scope private
151 * @rep:lifecycle active
152 * @rep:displayname Query Row
153 */
154
155
156 PROCEDURE Query_Row
157 ( p_ref_designator IN VARCHAR2
158 , p_component_sequence_id IN NUMBER
159 , p_acd_type IN NUMBER
160 , x_Ref_Designator_Rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
161 , x_Ref_Desg_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
162 , x_Return_Status IN OUT NOCOPY VARCHAR2
163 );
164
165 /*#
166 * Perform Writes is the only exposed method that the user will have access, to perform
167 * any insert/update/deletes to corresponding database tables . This can be used with ECO
168 * @param p_ref_designator_rec Reference Designator exposed column record
169 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_rec_Type }
170 * @param p_ref_desg_unexp_rec Reference Designator unexposed column record
171 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }
172 * @param p_control_rec control record.This is defaulted as BOM_BO_PUB.G_DEFAULT_CONTROL_REC
173 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Control_Rec_Type }
174 * @param x_Mesg_Token_Tbl Message token table
175 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
176 * @param x_Return_status Return Status
177 * @rep:scope private
178 * @rep:lifecycle active
179 * @rep:displayname Perform Writes
180 */
181
182 PROCEDURE Perform_Writes
183 ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_rec_Type
184 , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
185 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
186 := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
187 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
188 , x_return_status IN OUT NOCOPY VARCHAR2
189 );
190
191 /*
192 ** Definitions for the BOM Business Object
193 */
194
195
196 /*#
197 * This method will convert the missing values of some attributes that the user wishes to NULL
198 * @param p_bom_ref_designator_rec the record that need to be converted
199 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }
200 * @return the converted record
201 * @rep:scope private
202 * @rep:lifecycle active
203 * @rep:displayname Convert Miss To Null
204 */
205 FUNCTION Convert_Miss_To_Null
206 ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
207 ) RETURN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
208
209 -- Function Query_Row
210
211
212 /*#
213 * This method will query the database record, seperate the values into exposed columns
214 * and unexposed columns and return with those records
215 * @param p_bom_ref_designator This with the next two parameters form Reference Designator Key
216 * @param p_component_sequence_id component sequence id
217 * @param p_acd_type acd type
218 * @param x_bom_Ref_Designator_Rec Reference Designator Record of exposed columns
219 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }
220 * @param x_bom_Ref_Desg_Unexp_Rec Reference Designator Record of Unexposed Columns
221 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexposed_Rec_Type}
222 * @param x_Return_Status Indicating success or faliure
223 * @rep:scope private
224 * @rep:lifecycle active
225 * @rep:displayname Query Row
226 */
227
228 PROCEDURE Query_Row
229 ( p_bom_ref_designator IN VARCHAR2
230 , p_component_sequence_id IN NUMBER
231 , p_acd_type IN NUMBER
232 , x_bom_Ref_Designator_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
233 , x_bom_Ref_Desg_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
234 , x_Return_Status IN OUT NOCOPY VARCHAR2
235 );
236
237 /*#
238 * Perform Writes is the only exposed method that the user will have access to perform any
239 * insert/update/deletes to corresponding database tables
240 * @param p_bom_ref_designator_rec BomReference Designator exposed column record
241 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_rec_Type }
242 * @param p_bom_ref_desg_unexp_rec Bom Reference Designator unexposed column record
243 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexposed_Rec_Type }
244 * @param x_Mesg_Token_Tbl Message token table
245 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
246 * @param x_Return_status Return Status
247 * @rep:scope private
248 * @rep:lifecycle active
249 * @rep:displayname Perform Writes
250 */
251
252 PROCEDURE Perform_Writes
253 ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_rec_Type
254 , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
255 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
256 , x_return_status IN OUT NOCOPY VARCHAR2
257 );
258
259 END BOM_Ref_Designator_Util;