1 PACKAGE BOM_Default_Sub_Component AUTHID CURRENT_USER AS
2 /* $Header: BOMDSBCS.pls 120.0 2005/05/25 04:11:22 appldev noship $ */
3 /*#
4 * This API contains methods that will try to copy over values from OLD record for all NULL columns found in
5 * business object Substitute Component record.It will also default in values either by retrieving
6 * them from the database, or by having the program assign values.
7 * @rep:scope private
8 * @rep:product BOM
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 * @rep:displayname Substitute Component Defaulting
12 */
13 /****************************************************************************
14 --
15 -- Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
16 -- All rights reserved.
17 --
18 -- FILENAME
19 --
20 -- BOMDSBCS.pls
21 --
22 -- DESCRIPTION
23 --
24 -- Spec of package BOM_Default_Sub_Component
25 --
26 -- NOTES
27 --
28 -- HISTORY
29 --
30 -- 17-JUL-1999 Rahul Chitko Initial Creation
31 --
32 ****************************************************************************/
33 -- Procedure Attributes
34 /*#
35 * This method will try to default in values,for all NULL columns found in business object Substitute Component
36 * record of type Bom_Bo_Pub.Sub_Component_Rec_Type either by retrieving them from the database, or by having the program
37 * assign values.For CREATEs, there is no OLD record. So the program must default
38 * in individual attribute values,independently of each other. This
39 * feature enables the user to enter minimal information for the
40 * operation to go through
41 * @param p_sub_component_rec IN Substitute Component Exposed Column Record
42 * @paraminfo {@rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type}
43 * @param p_Sub_Comp_Unexp_Rec IN Substitute Component Unexposed Column Record
44 * @paraminfo {@rep:innertype Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type}
45 * @param x_sub_component_rec IN OUT NOCOPY processed Substitute Component Exposed Column Record
46 * @paraminfo {@rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type}
47 * @param x_Sub_Comp_Unexp_Rec IN OUT NOCOPY processed Substitute Component Unexposed Column Record
48 * @paraminfo {@rep:innertype Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type}
49 * @param x_Mesg_Token_Tbl IN OUT NOCOPY Message Token Table
50 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
51 * @param x_return_status IN OUT NOCOPY Return Status
52 * @rep:scope private
53 * @rep:displayname Substitute Component-Attribute Defaulting
54 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
55 * @rep:lifecycle active
56 */
57 PROCEDURE Attribute_Defaulting
58 ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type :=
59 Bom_Bo_Pub.G_MISS_SUB_COMPONENT_REC
60 , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
61 , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
62 , x_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
63 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
64 , x_return_status IN OUT NOCOPY VARCHAR2
65 );
66
67 /*#
68 * This method will copy over values from OLD record for all NULL columns found in
69 * business object Substitute Component record of type Bom_Bo_Pub.Sub_Component_Rec_Type.
70 * The user may send in a record with
71 * certain values set to NULL. Values for all such columns are copied over
72 * from the OLD record. This feature enables the user to enter minimal
73 * information for the operation.
74 * @param p_sub_component_rec IN Substitute Component Exposed Column Record
75 * @paraminfo {@rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type}
76 * @param p_old_sub_component_rec IN Substitute Component Old Record Exposed Column Record
77 * @paraminfo {@rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type}
78 * @param p_sub_Comp_Unexp_Rec IN Substitute Component Unexposed Column Record
79 * @paraminfo {@rep:innertype Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type}
80 * @param p_Old_sub_Comp_Unexp_Rec IN Substitute Component Old Record Unexposed Column Record
81 * @paraminfo {@rep:innertype Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type}
82 * @param x_sub_Component_Rec IN OUT NOCOPY processed Substitute Component Exposed Column Record
83 * @paraminfo {@rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type}
84 * @param x_sub_Comp_Unexp_Rec IN OUT NOCOPY processed Substitute Component Unexposed Column Record
85 * @paraminfo {@rep:innertype Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type}
86 * @rep:scope private
87 * @rep:compatibility S
88 * @rep:displayname Substitute Component-Populate NULL Columns
89 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
90 * @rep:lifecycle active
91 */
92 PROCEDURE Populate_Null_Columns
93 ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
94 , p_old_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
95 , p_sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
96 , p_Old_sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
97 , x_sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
98 , x_sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
99 );
100
101 /*#
102 * This method will perform checks against Substitute Component record in the order
103 * Non-updateable columns (UPDATEs): Certain columns must not be changed by the user when updating the record.
104 * Cross-attribute checking: The validity of attributes may be checked, based on factors external to it.
105 * Business logic: The record must comply with business logic rules.
106 * @param p_sub_component_rec IN Substitute Component Exposed Column Record
107 * @paraminfo {@rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type}
108 * @param p_old_sub_component_rec IN Substitute Component Old Record Exposed Column Record
109 * @paraminfo {@rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type}
110 * @param x_sub_component_rec IN OUT NOCOPY processed Substitute Component Exposed Column Record
111 * @paraminfo {@rep:innertype Bom_Bo_Pub.Sub_Component_Rec_Type}
112 * @rep:scope private
113 * @rep:compatibility S
114 * @rep:displayname Substitute Component-Entity Defaulting
115 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
116 * @rep:lifecycle active
117 */
118
119 PROCEDURE Entity_Defaulting
120 ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
121 , p_old_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type :=
122 Bom_Bo_Pub.G_MISS_Sub_COMPONENT_REC
123 , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
124 );
125
126 /*
127 ** Procedures for BOM Business Object
128 */
129 /*#
130 * This method is the Attribute Defaulting method for BOM Business Object Substitute Component Record.
131 * This will try to default in values,for all NULL columns found in business object BOM Substitute Component
132 * record of type Bom_Bo_Pub.Bom_Sub_Component_Rec_Type either by retrieving them from the database, or by having the program
133 * assign values.For CREATEs, there is no OLD record. So the program must default
134 * in individual attribute values,independently of each other. This
135 * feature enables the user to enter minimal information for the
136 * operation to go through
137 * @param p_bom_sub_component_rec IN BOM Substitute Component Exposed Column Record
138 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Rec_Type}
139 * @param p_bom_Sub_Comp_Unexp_Rec IN BOM Substitute Component Unexposed Column Record
140 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type}
141 * @param x_bom_sub_component_rec IN OUT NOCOPY processed BOM Substitute Component Exposed Column Record
142 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Rec_Type}
143 * @param x_bom_Sub_Comp_Unexp_Rec IN OUT NOCOPY processed BOM Substitute Component Unexposed Column Record
144 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type}
145 * @param x_Mesg_Token_Tbl IN OUT NOCOPY Message Token Table
146 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
147 * @param x_return_status IN OUT NOCOPY Return Status
148 * @rep:scope private
149 * @rep:compatibility S
150 * @rep:displayname Substitute Component-Atribute Defaulting
151 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
152 * @rep:lifecycle active
153 */
154
155 PROCEDURE Attribute_Defaulting
156 ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type :=
157 Bom_Bo_Pub.G_MISS_Bom_SUB_COMPONENT_REC
158 , p_bom_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
159 , x_bom_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
160 , x_bom_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
161 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
162 , x_return_status IN OUT NOCOPY VARCHAR2
163 );
164
165 /*#
166 * This method is the Populate NULL Column procedure for BOM Business Object Substitute Component Record.
167 * This will copy over values from OLD record for all NULL columns found in
168 * business object BOM Substitute Component record of type Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
169 * The user may send in a record with
170 * certain values set to NULL. Values for all such columns are copied over
171 * from the OLD record. This feature enables the user to enter minimal
172 * information for the operation.
173 * @param p_bom_sub_component_rec IN BOM Substitute Component Exposed Column Record
174 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Rec_Type}
175 * @param p_old_bom_sub_component_rec IN BOM Substitute Component Old Record Exposed Column Record
176 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Rec_Type}
177 * @param p_bom_sub_Comp_Unexp_Rec IN BOM Substitute Component Unexposed Column Record
178 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type}
179 * @param p_Old_bom_sub_Comp_Unexp_Rec IN BOM Substitute Component Old Record Unexposed Column Record
180 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type}
181 * @param x_bom_sub_Component_Rec IN OUT NOCOPY processed BOM Substitute Component Exposed Column Record
182 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Rec_Type}
183 * @param x_bom_sub_Comp_Unexp_Rec IN OUT NOCOPY processed BOM Substitute Component Unexposed Column Record
184 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type}
185 * @rep:scope private
186 * @rep:compatibility S
187 * @rep:displayname Substitute Component-Populate NULL Columns
188 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
189 * @rep:lifecycle active
190 */
191 PROCEDURE Populate_Null_Columns
192 ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
193 , p_old_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
194 , p_bom_sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
195 , p_Old_bom_sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
196 , x_bom_sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
197 , x_bom_sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
198 );
199
200 END BOM_Default_Sub_Component;