[Home] [Help]
Skip to content
PACKAGE: APPS.BOM_SUB_COMPONENT_UTIL
Source
1 PACKAGE BOM_Sub_Component_Util AUTHID CURRENT_USER AS
2 /* $Header: BOMUSBCS.pls 120.0.12010000.2 2010/02/03 17:25:58 umajumde ship $ */
3 /*#
4 * This API contains entity utility methods for the Bill of Materials Sub
5 * Components
6 * @rep:scope private
7 * @rep:product BOM
8 * @rep:displayname BOM Sub Component 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 -- BOMUSBCS.pls
20 --
21 -- DESCRIPTION
22 --
23 -- Spec of package BOM_Sub_Component_Util
24 --
25 -- NOTES
26 --
27 -- HISTORY
28 --
29 -- 17-JUL-1999 Rahul Chitko Initial Creation
30 --
31 ****************************************************************************/
32 -- Attributes global constants
33
34 G_SUBSTITUTE_COMPONENT 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_SUBSTITUTE_ITEM_QUANTITY CONSTANT NUMBER := 7;
41 G_COMPONENT_SEQUENCE CONSTANT NUMBER := 8;
42 G_ACD_TYPE CONSTANT NUMBER := 9;
43 G_CHANGE_NOTICE CONSTANT NUMBER := 10;
44 G_REQUEST CONSTANT NUMBER := 11;
45 G_PROGRAM_APPLICATION CONSTANT NUMBER := 12;
46 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 13;
47 G_ATTRIBUTE_CATEGORY CONSTANT NUMBER := 14;
48 G_ATTRIBUTE1 CONSTANT NUMBER := 15;
49 G_ATTRIBUTE2 CONSTANT NUMBER := 16;
50 G_ATTRIBUTE4 CONSTANT NUMBER := 17;
51 G_ATTRIBUTE5 CONSTANT NUMBER := 18;
52 G_ATTRIBUTE6 CONSTANT NUMBER := 19;
53 G_ATTRIBUTE8 CONSTANT NUMBER := 20;
54 G_ATTRIBUTE9 CONSTANT NUMBER := 21;
55 G_ATTRIBUTE10 CONSTANT NUMBER := 22;
56 G_ATTRIBUTE12 CONSTANT NUMBER := 23;
57 G_ATTRIBUTE13 CONSTANT NUMBER := 24;
58 G_ATTRIBUTE14 CONSTANT NUMBER := 25;
59 G_ATTRIBUTE15 CONSTANT NUMBER := 26;
60 G_PROGRAM CONSTANT NUMBER := 27;
61 G_ATTRIBUTE3 CONSTANT NUMBER := 28;
62 G_ATTRIBUTE7 CONSTANT NUMBER := 29;
63 G_ATTRIBUTE11 CONSTANT NUMBER := 30;
64 G_MAX_ATTR_ID CONSTANT NUMBER := 31;
65
66 -- Function Convert_Miss_To_Null
67
68 /*#
69 * This method will convert the missing values of some attributes that the user wishes to NULL
70 * This can be used with ECO
71 * @param p_sub_component_rec the record that need to be converted
72 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }
73 * @return the converted record
74 * @rep:scope private
75 * @rep:lifecycle active
76 * @rep:displayname Convert Miss To Null
77 */
78
79
80 FUNCTION Convert_Miss_To_Null
81 ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
82 ) RETURN Bom_Bo_Pub.Sub_Component_Rec_Type;
83
84 --added for bug 7713832
85 FUNCTION Common_CompSeqIdSC( p_comp_seq_id NUMBER)
86 RETURN NUMBER;
87
88 -- Function Query_Row
89
90 /*#
91 * This method will query the database record, seperate the values into exposed columns
92 * and unexposed columns and return with those records.This can be used with ECO
93 * @param p_substitute_component_id The IN parameters form the Substitute Component primary key
94 * @param p_component_sequence_id componenet sequence id
95 * @param p_acd_type acd type
96 * @param x_Sub_Component_Rec Substitute Component Record of exposed colmuns
97 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }
98 * @param x_Sub_Comp_Unexp_Rec Substitute Component record of unexposed columns
99 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type }
100 * @param x_return_status Indicating success or faliure
101 * @rep:scope private
102 * @rep:lifecycle active
103 * @rep:displayname Query Row
104 */
105
106 PROCEDURE Query_Row
107 ( p_substitute_component_id IN NUMBER
108 , p_component_sequence_id IN NUMBER
109 , p_acd_type IN NUMBER
110 , x_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
111 , x_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
112 , x_return_status IN OUT NOCOPY VARCHAR2
113 );
114
115 -- Procedure lock_Row
116 --
117
118 /*#
119 * Locks the row
120 * @param x_return_status Indicating success or faliure
121 * @param p_sub_component_rec Substitute Component Record
122 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }
123 * @param x_sub_component_rec Substitute Component Record
124 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }
125 * @param x_err_text error text
126 * @rep:scope private
127 * @rep:lifecycle active
128 * @rep:displayname Lock Row
129 */
130
131
132
133 PROCEDURE Lock_Row
134 ( x_return_status IN OUT NOCOPY VARCHAR2
135 , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
136 , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
137 , x_err_text IN OUT NOCOPY VARCHAR2
138 );
139
140 /*#
141 * Perform Writes is the only exposed method that the user will have access to
142 * perform any insert/update/deletes to corresponding database tables.This can be used with ECO
143 * @param p_Sub_Component_Rec Substitute Component Record of exposed colmuns
144 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }
145 * @param p_Sub_Comp_Unexp_Rec Substitute Component record of unexposed columns
146 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type }
147 * @param x_Mesg_Token_Tbl Message token table
148 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
149 * @param x_Return_status Return Status
150 * @rep:scope private
151 * @rep:lifecycle active
152 * @rep:displayname Perform Writes
153 */
154
155
156 PROCEDURE Perform_Writes
157 ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
158 , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
159 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
160 , x_Return_Status IN OUT NOCOPY VARCHAR2
161 );
162
163 /*
164 ** Procedures for BOM Business Object
165 */
166
167 /*#
168 * This method will convert the missing values of some attributes that the user wishes to NULL
169 * @param p_bom_sub_component_rec the record that need to be converted
170 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Rec_Type }
171 * @return the converted record
172 * @rep:scope private
173 * @rep:lifecycle active
174 * @rep:displayname Convert Miss To Null
175 */
176
177 FUNCTION Convert_Miss_To_Null
178 ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
179 ) RETURN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
180
181 -- Function Query_Row
182
183 /*#
184 * This method will query the database record, seperate the values into exposed columns
185 * and unexposed columns and return with those records
186 * @param p_substitute_component_id The IN parameters form the Substitute Component primary key
187 * @param p_component_sequence_id componenet sequence id
188 * @param p_acd_type acd type
189 * @param x_bom_Sub_Component_Rec Bom Substitute Component Record of exposed colmuns
190 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Rec_Type }
191 * @param x_bom_Sub_Comp_Unexp_Rec Bom Substitute Component record of unexposed columns
192 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Comp_Unexposed_Rec_Type }
193 * @param x_return_status Indicating success or faliure
194 * @rep:scope private
195 * @rep:lifecycle active
196 * @rep:displayname Query Row
197 */
198
199
200 PROCEDURE Query_Row
201 ( p_substitute_component_id IN NUMBER
202 , p_component_sequence_id IN NUMBER
203 , p_acd_type IN NUMBER
204 , x_bom_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
205 , x_bom_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
206 , x_return_status IN OUT NOCOPY VARCHAR2
207 );
208
209 /*#
210 * Perform Writes is the only exposed method that the user will have access to perform any
211 * insert/update/deletes to corresponding database tables
212 * @param p_bom_Sub_Component_Rec Bom Substitute Component Record of exposed colmuns
213 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Rec_Type }
214 * @param p_bom_Sub_Comp_Unexp_Rec Bom Substitute Component record of unexposed columns
215 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Comp_Unexposed_Rec_Type }
216 * @param x_Mesg_Token_Tbl Message token table
217 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
218 * @param x_Return_status Return Status
219 * @rep:scope private
220 * @rep:lifecycle active
221 * @rep:displayname Perform Writes
222 */
223
224
225 PROCEDURE Perform_Writes
226 ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
227 , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
228 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
229 , x_Return_Status IN OUT NOCOPY VARCHAR2
230 );
231
232 END BOM_Sub_Component_Util;