6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ENG_Default_Ref_Designator';
7:
8: -- Package global used within the package.
9:
10: g_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
11:
12: PROCEDURE Get_Flex_Ref_Designator
13: IS
14: BEGIN
83:
84: -- Procedure Attributes
85:
86: PROCEDURE Attribute_Defaulting
87: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
88: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
89: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
90: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
91: , x_Ref_Desg_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
84: -- Procedure Attributes
85:
86: PROCEDURE Attribute_Defaulting
87: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
88: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
89: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
90: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
91: , x_Ref_Desg_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
92: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
85:
86: PROCEDURE Attribute_Defaulting
87: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
88: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
89: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
90: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
91: , x_Ref_Desg_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
92: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
93: , x_Return_Status OUT NOCOPY VARCHAR2
86: PROCEDURE Attribute_Defaulting
87: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
88: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
89: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
90: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
91: , x_Ref_Desg_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
92: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
93: , x_Return_Status OUT NOCOPY VARCHAR2
94: )
87: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
88: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
89: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
90: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
91: , x_Ref_Desg_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
92: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
93: , x_Return_Status OUT NOCOPY VARCHAR2
94: )
95: IS
146: * even if the values do not match.
147: ********************************************************************/
148:
149: PROCEDURE Populate_Null_Columns
150: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
151: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
152: , p_old_Ref_Designator_Rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
153: , p_old_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
154: , x_Ref_Designator_Rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
147: ********************************************************************/
148:
149: PROCEDURE Populate_Null_Columns
150: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
151: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
152: , p_old_Ref_Designator_Rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
153: , p_old_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
154: , x_Ref_Designator_Rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
155: , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
148:
149: PROCEDURE Populate_Null_Columns
150: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
151: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
152: , p_old_Ref_Designator_Rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
153: , p_old_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
154: , x_Ref_Designator_Rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
155: , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
156: )
149: PROCEDURE Populate_Null_Columns
150: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
151: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
152: , p_old_Ref_Designator_Rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
153: , p_old_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
154: , x_Ref_Designator_Rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
155: , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
156: )
157: IS
150: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
151: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
152: , p_old_Ref_Designator_Rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
153: , p_old_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
154: , x_Ref_Designator_Rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
155: , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
156: )
157: IS
158: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type :=
151: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
152: , p_old_Ref_Designator_Rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
153: , p_old_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
154: , x_Ref_Designator_Rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
155: , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
156: )
157: IS
158: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type :=
159: p_ref_designator_rec;
154: , x_Ref_Designator_Rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
155: , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
156: )
157: IS
158: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type :=
159: p_ref_designator_rec;
160: l_err_text VARCHAR2(2000);
161: BEGIN
162: