[Home] [Help]
PACKAGE: APPS.BOM_SUB_COMPONENT_UTIL
Source
1 PACKAGE BOM_Sub_Component_Util AS
2 /* $Header: BOMUSBCS.pls 120.0 2005/05/25 05:41:28 appldev noship $ */
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 -- Function Query_Row
85
86 /*#
87 * This method will query the database record, seperate the values into exposed columns
88 * and unexposed columns and return with those records.This can be used with ECO
89 * @param p_substitute_component_id The IN parameters form the Substitute Component primary key
90 * @param p_component_sequence_id componenet sequence id
91 * @param p_acd_type acd type
92 * @param x_Sub_Component_Rec Substitute Component Record of exposed colmuns
93 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }
94 * @param x_Sub_Comp_Unexp_Rec Substitute Component record of unexposed columns
95 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type }
96 * @param x_return_status Indicating success or faliure
97 * @rep:scope private
98 * @rep:lifecycle active
99 * @rep:displayname Query Row
100 */
101
102 PROCEDURE Query_Row
103 ( p_substitute_component_id IN NUMBER
104 , p_component_sequence_id IN NUMBER
105 , p_acd_type IN NUMBER
106 , x_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
107 , x_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
108 , x_return_status IN OUT NOCOPY VARCHAR2
109 );
110
111 -- Procedure lock_Row
112 --
113
114 /*#
115 * Locks the row
116 * @param x_return_status Indicating success or faliure
117 * @param p_sub_component_rec Substitute Component Record
118 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }
119 * @param x_sub_component_rec Substitute Component Record
120 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }
121 * @param x_err_text error text
122 * @rep:scope private
123 * @rep:lifecycle active
124 * @rep:displayname Lock Row
125 */
126
127
128
129 PROCEDURE Lock_Row
130 ( x_return_status IN OUT NOCOPY VARCHAR2
131 , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
132 , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
133 , x_err_text IN OUT NOCOPY VARCHAR2
134 );
135
136 /*#
137 * Perform Writes is the only exposed method that the user will have access to
138 * perform any insert/update/deletes to corresponding database tables.This can be used with ECO
139 * @param p_Sub_Component_Rec Substitute Component Record of exposed colmuns
140 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type }
141 * @param p_Sub_Comp_Unexp_Rec Substitute Component record of unexposed columns
142 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type }
143 * @param x_Mesg_Token_Tbl Message token table
144 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
145 * @param x_Return_status Return Status
146 * @rep:scope private
147 * @rep:lifecycle active
148 * @rep:displayname Perform Writes
149 */
150
151
152 PROCEDURE Perform_Writes
153 ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
154 , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
155 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
156 , x_Return_Status IN OUT NOCOPY VARCHAR2
157 );
158
159 /*
160 ** Procedures for BOM Business Object
161 */
162
163 /*#
164 * This method will convert the missing values of some attributes that the user wishes to NULL
165 * @param p_bom_sub_component_rec the record that need to be converted
166 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Rec_Type }
167 * @return the converted record
168 * @rep:scope private
169 * @rep:lifecycle active
170 * @rep:displayname Convert Miss To Null
171 */
172
173 FUNCTION Convert_Miss_To_Null
174 ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
175 ) RETURN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
176
177 -- Function Query_Row
178
179 /*#
180 * This method will query the database record, seperate the values into exposed columns
181 * and unexposed columns and return with those records
182 * @param p_substitute_component_id The IN parameters form the Substitute Component primary key
183 * @param p_component_sequence_id componenet sequence id
184 * @param p_acd_type acd type
185 * @param x_bom_Sub_Component_Rec Bom Substitute Component Record of exposed colmuns
186 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Rec_Type }
187 * @param x_bom_Sub_Comp_Unexp_Rec Bom Substitute Component record of unexposed columns
188 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Comp_Unexposed_Rec_Type }
189 * @param x_return_status Indicating success or faliure
190 * @rep:scope private
191 * @rep:lifecycle active
192 * @rep:displayname Query Row
193 */
194
195
196 PROCEDURE Query_Row
197 ( p_substitute_component_id IN NUMBER
198 , p_component_sequence_id IN NUMBER
199 , p_acd_type IN NUMBER
200 , x_bom_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
201 , x_bom_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
202 , x_return_status IN OUT NOCOPY VARCHAR2
203 );
204
205 /*#
206 * Perform Writes is the only exposed method that the user will have access to perform any
207 * insert/update/deletes to corresponding database tables
208 * @param p_bom_Sub_Component_Rec Bom Substitute Component Record of exposed colmuns
209 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Rec_Type }
210 * @param p_bom_Sub_Comp_Unexp_Rec Bom Substitute Component record of unexposed columns
211 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Sub_Comp_Unexposed_Rec_Type }
212 * @param x_Mesg_Token_Tbl Message token table
213 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
214 * @param x_Return_status Return Status
215 * @rep:scope private
216 * @rep:lifecycle active
217 * @rep:displayname Perform Writes
218 */
219
220
221 PROCEDURE Perform_Writes
222 ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
223 , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
224 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
225 , x_Return_Status IN OUT NOCOPY VARCHAR2
226 );
227
228 END BOM_Sub_Component_Util;