34: * record with values from the database record, for all
35: * columns that the user has left NULL.
36: ********************************************************************/
37: PROCEDURE Populate_Null_Columns
38: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
39: , p_old_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
40: , p_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
41: , p_Old_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
42: , x_bom_revision_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Rec_Type
35: * columns that the user has left NULL.
36: ********************************************************************/
37: PROCEDURE Populate_Null_Columns
38: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
39: , p_old_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
40: , p_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
41: , p_Old_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
42: , x_bom_revision_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Rec_Type
43: , x_bom_rev_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
36: ********************************************************************/
37: PROCEDURE Populate_Null_Columns
38: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
39: , p_old_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
40: , p_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
41: , p_Old_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
42: , x_bom_revision_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Rec_Type
43: , x_bom_rev_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
44: )
37: PROCEDURE Populate_Null_Columns
38: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
39: , p_old_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
40: , p_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
41: , p_Old_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
42: , x_bom_revision_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Rec_Type
43: , x_bom_rev_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
44: )
45: IS
38: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
39: , p_old_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
40: , p_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
41: , p_Old_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
42: , x_bom_revision_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Rec_Type
43: , x_bom_rev_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
44: )
45: IS
46: l_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type:=
39: , p_old_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
40: , p_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
41: , p_Old_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
42: , x_bom_revision_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Rec_Type
43: , x_bom_rev_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
44: )
45: IS
46: l_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type:=
47: p_bom_revision_rec;
42: , x_bom_revision_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Rec_Type
43: , x_bom_rev_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
44: )
45: IS
46: l_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type:=
47: p_bom_revision_rec;
48: l_bom_rev_unexp_rec Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type:=
49: p_bom_rev_unexp_rec;
50: BEGIN
44: )
45: IS
46: l_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type:=
47: p_bom_revision_rec;
48: l_bom_rev_unexp_rec Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type:=
49: p_bom_rev_unexp_rec;
50: BEGIN
51: IF l_bom_revision_rec.description IS NULL
52: THEN