43: * But a record being created must not. Such an error in a record must cause all children
44: * to error out, since they are referencing an invalid parent.This raises a Severe Error III.
45: * It also queries up the database record into the corresponding Old Record.
46: * @param p_bom_header_rec IN BOM Header Exposed Column Record
47: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
48: * @param p_bom_head_unexp_rec IN BOM Header Unexposed Column Record
49: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
50: * @param x_old_bom_header_rec IN OUT NOCOPY queried BOM Header Old Record Exposed Column Record.
51: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
45: * It also queries up the database record into the corresponding Old Record.
46: * @param p_bom_header_rec IN BOM Header Exposed Column Record
47: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
48: * @param p_bom_head_unexp_rec IN BOM Header Unexposed Column Record
49: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
50: * @param x_old_bom_header_rec IN OUT NOCOPY queried BOM Header Old Record Exposed Column Record.
51: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
52: * @param x_old_bom_head_unexp_rec IN OUT NOCOPY queried BOM Header Old Record Unexposed Column Record.
53: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
47: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
48: * @param p_bom_head_unexp_rec IN BOM Header Unexposed Column Record
49: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
50: * @param x_old_bom_header_rec IN OUT NOCOPY queried BOM Header Old Record Exposed Column Record.
51: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
52: * @param x_old_bom_head_unexp_rec IN OUT NOCOPY queried BOM Header Old Record Unexposed Column Record.
53: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
54: * @param x_Mesg_Token_Tbl IN OUT NOCOPY Message Token Table
55: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
49: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
50: * @param x_old_bom_header_rec IN OUT NOCOPY queried BOM Header Old Record Exposed Column Record.
51: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
52: * @param x_old_bom_head_unexp_rec IN OUT NOCOPY queried BOM Header Old Record Unexposed Column Record.
53: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
54: * @param x_Mesg_Token_Tbl IN OUT NOCOPY Message Token Table
55: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
56: * @param x_return_status IN OUT NOCOPY Return Status
57: * @rep:scope private
60: * @rep:lifecycle active
61: * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
62: */
63: PROCEDURE Check_Existence
64: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
65: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
66: , x_old_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
67: , x_old_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
68: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
61: * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
62: */
63: PROCEDURE Check_Existence
64: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
65: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
66: , x_old_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
67: , x_old_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
68: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
69: , x_return_status IN OUT NOCOPY VARCHAR2
62: */
63: PROCEDURE Check_Existence
64: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
65: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
66: , x_old_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
67: , x_old_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
68: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
69: , x_return_status IN OUT NOCOPY VARCHAR2
70: );
63: PROCEDURE Check_Existence
64: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
65: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
66: , x_old_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
67: , x_old_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
68: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
69: , x_return_status IN OUT NOCOPY VARCHAR2
70: );
71:
107: * @param x_return_status IN OUT NOCOPY Return Status
108: * @param x_Mesg_Token_Tbl IN OUT NOCOPY output Message Token Table with proper error or warning messages
109: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
110: * @param p_bom_header_Rec IN BOM Header Exposed Column Record
111: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
112: * @param p_bom_head_unexp_rec IN BOM Header Unexposed Column Record
113: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
114: * @param p_old_bom_header_rec IN BOM Header Old Record Exposed Column Record
115: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
109: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
110: * @param p_bom_header_Rec IN BOM Header Exposed Column Record
111: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
112: * @param p_bom_head_unexp_rec IN BOM Header Unexposed Column Record
113: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
114: * @param p_old_bom_header_rec IN BOM Header Old Record Exposed Column Record
115: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
116: * @param p_old_bom_head_unexp_rec IN BOM Header Old Record Unexposed Column Record
117: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
111: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
112: * @param p_bom_head_unexp_rec IN BOM Header Unexposed Column Record
113: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
114: * @param p_old_bom_header_rec IN BOM Header Old Record Exposed Column Record
115: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
116: * @param p_old_bom_head_unexp_rec IN BOM Header Old Record Unexposed Column Record
117: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
118: * @rep:scope private
119: * @rep:displayname Check Header Attributes
113: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
114: * @param p_old_bom_header_rec IN BOM Header Old Record Exposed Column Record
115: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
116: * @param p_old_bom_head_unexp_rec IN BOM Header Old Record Unexposed Column Record
117: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
118: * @rep:scope private
119: * @rep:displayname Check Header Attributes
120: * @rep:compatibility S
121: * @rep:lifecycle active
124:
125: PROCEDURE Check_Attributes
126: ( x_return_status IN OUT NOCOPY VARCHAR2
127: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
128: , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
129: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
130: , p_old_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
131: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
132: );
125: PROCEDURE Check_Attributes
126: ( x_return_status IN OUT NOCOPY VARCHAR2
127: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
128: , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
129: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
130: , p_old_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
131: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
132: );
133:
126: ( x_return_status IN OUT NOCOPY VARCHAR2
127: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
128: , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
129: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
130: , p_old_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
131: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
132: );
133:
134: /*#
127: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
128: , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
129: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
130: , p_old_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
131: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
132: );
133:
134: /*#
135: * This method does the required fields checking for the BOM Header Record.
141: * @param x_return_status IN OUT NOCOPY Return Status
142: * @param x_Mesg_Token_Tbl IN OUT NOCOPY output Message Token Table with proper error or warning messages
143: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
144: * @param p_bom_header_Rec IN BOM Header Exposed Column Record
145: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
146: * @rep:scope private
147: * @rep:displayname Check Header Required Fields
148: * @rep:compatibility S
149: * @rep:lifecycle active
151: */
152: PROCEDURE Check_Required
153: ( x_return_status IN OUT NOCOPY VARCHAR2
154: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
155: , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
156: );
157: /*#
158: * This is where the whole record is checked. The following are checked
159: * Non-updateable columns (UPDATEs): Certain columns must not be changed by the user when updating the record
162: * It raises
163: * 1 Severe Error IV for Create transaction type.
164: * 2 Standard Error for Update transaction type.
165: * @param p_bom_header_Rec IN BOM Header Exposed Column Record
166: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
167: * @param p_bom_head_unexp_rec IN BOM Header Unexposed Column Record
168: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
169: * @param p_old_bom_head_rec IN BOM Header Old Record Exposed Column Record
170: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
164: * 2 Standard Error for Update transaction type.
165: * @param p_bom_header_Rec IN BOM Header Exposed Column Record
166: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
167: * @param p_bom_head_unexp_rec IN BOM Header Unexposed Column Record
168: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
169: * @param p_old_bom_head_rec IN BOM Header Old Record Exposed Column Record
170: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
171: * @param p_old_bom_head_unexp_rec IN BOM Header Old Record Unexposed Column Record
172: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
166: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
167: * @param p_bom_head_unexp_rec IN BOM Header Unexposed Column Record
168: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
169: * @param p_old_bom_head_rec IN BOM Header Old Record Exposed Column Record
170: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
171: * @param p_old_bom_head_unexp_rec IN BOM Header Old Record Unexposed Column Record
172: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
173: * @param x_mesg_token_tbl IN OUT NOCOPY output Message Token Table with proper error or warning messages
174: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
168: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
169: * @param p_old_bom_head_rec IN BOM Header Old Record Exposed Column Record
170: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
171: * @param p_old_bom_head_unexp_rec IN BOM Header Old Record Unexposed Column Record
172: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
173: * @param x_mesg_token_tbl IN OUT NOCOPY output Message Token Table with proper error or warning messages
174: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
175: * @param x_return_status IN OUT NOCOPY Return Status
176: * @rep:scope private
179: * @rep:lifecycle active
180: * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
181: */
182: PROCEDURE Check_Entity
183: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
184: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
185: , p_old_bom_head_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
186: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
187: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
180: * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
181: */
182: PROCEDURE Check_Entity
183: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
184: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
185: , p_old_bom_head_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
186: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
187: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
188: , x_return_status IN OUT NOCOPY VARCHAR2
181: */
182: PROCEDURE Check_Entity
183: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
184: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
185: , p_old_bom_head_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
186: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
187: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
188: , x_return_status IN OUT NOCOPY VARCHAR2
189: );
182: PROCEDURE Check_Entity
183: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
184: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
185: , p_old_bom_head_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
186: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
187: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
188: , x_return_status IN OUT NOCOPY VARCHAR2
189: );
190:
196: * @param x_return_status IN OUT NOCOPY Return Status
197: * @param x_Mesg_Token_Tbl IN OUT NOCOPY output Message Token Table with proper error or warning messages
198: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
199: * @param p_bom_header_Rec IN BOM Header Exposed Column Record
200: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
201: * @param p_bom_head_unexp_rec IN BOM Header Unexposed Column Record
202: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
203: * @param x_bom_head_unexp_rec IN OUT NOCOPY processed BOM Header Unexposed Column Record
204: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
198: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
199: * @param p_bom_header_Rec IN BOM Header Exposed Column Record
200: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
201: * @param p_bom_head_unexp_rec IN BOM Header Unexposed Column Record
202: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
203: * @param x_bom_head_unexp_rec IN OUT NOCOPY processed BOM Header Unexposed Column Record
204: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
205: * @rep:scope private
206: * @rep:displayname Check Header Delete Entity
200: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
201: * @param p_bom_head_unexp_rec IN BOM Header Unexposed Column Record
202: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
203: * @param x_bom_head_unexp_rec IN OUT NOCOPY processed BOM Header Unexposed Column Record
204: * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
205: * @rep:scope private
206: * @rep:displayname Check Header Delete Entity
207: * @rep:compatibility S
208: * @rep:lifecycle active
210: */
211: PROCEDURE Check_Entity_Delete
212: ( x_return_status IN OUT NOCOPY VARCHAR2
213: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
214: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
215: , p_bom_head_Unexp_Rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
216: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
217: );
218:
211: PROCEDURE Check_Entity_Delete
212: ( x_return_status IN OUT NOCOPY VARCHAR2
213: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
214: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
215: , p_bom_head_Unexp_Rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
216: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
217: );
218:
219: END Bom_Validate_Bom_Header;
212: ( x_return_status IN OUT NOCOPY VARCHAR2
213: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
214: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
215: , p_bom_head_Unexp_Rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
216: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
217: );
218:
219: END Bom_Validate_Bom_Header;