47:
48: END Get_Bill_Sequence;
49:
50: PROCEDURE Get_Flex_Bom_Header
51: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
52: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
53: )
54: IS
55: BEGIN
48: END Get_Bill_Sequence;
49:
50: PROCEDURE Get_Flex_Bom_Header
51: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
52: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
53: )
54: IS
55: BEGIN
56:
136: * Purpose : Attribute Defaulting will default the necessary null
137: * attribute with appropriate values.
138: **********************************************************************/
139: PROCEDURE Attribute_Defaulting
140: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
141: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
142: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
143: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
144: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
137: * attribute with appropriate values.
138: **********************************************************************/
139: PROCEDURE Attribute_Defaulting
140: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
141: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
142: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
143: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
144: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
145: , x_return_status IN OUT NOCOPY VARCHAR2
138: **********************************************************************/
139: PROCEDURE Attribute_Defaulting
140: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
141: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
142: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
143: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
144: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
145: , x_return_status IN OUT NOCOPY VARCHAR2
146: )
139: PROCEDURE Attribute_Defaulting
140: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
141: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
142: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
143: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
144: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
145: , x_return_status IN OUT NOCOPY VARCHAR2
146: )
147: IS
273: * value from the old record.
274: * This procedure is not called CREATE
275: ********************************************************************/
276: PROCEDURE Populate_Null_Columns
277: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
278: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
279: , p_old_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
280: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
281: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
274: * This procedure is not called CREATE
275: ********************************************************************/
276: PROCEDURE Populate_Null_Columns
277: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
278: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
279: , p_old_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
280: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
281: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
282: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
275: ********************************************************************/
276: PROCEDURE Populate_Null_Columns
277: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
278: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
279: , p_old_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
280: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
281: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
282: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
283: )
276: PROCEDURE Populate_Null_Columns
277: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
278: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
279: , p_old_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
280: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
281: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
282: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
283: )
284: IS
277: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
278: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
279: , p_old_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
280: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
281: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
282: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
283: )
284: IS
285: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type; -- Bug 4909882
278: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
279: , p_old_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
280: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
281: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
282: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
283: )
284: IS
285: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type; -- Bug 4909882
286: BEGIN
281: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
282: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
283: )
284: IS
285: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type; -- Bug 4909882
286: BEGIN
287: x_bom_header_rec := p_bom_header_rec;
288: x_bom_head_unexp_rec := p_bom_head_unexp_rec;
289: