38: -- Procedure Clear_Dependent_Attr
39:
40: PROCEDURE Clear_Dependent_Attr
41: ( p_attr_id IN NUMBER :=NULL -- FND_API.G_MISS_NUM
42: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
43: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
44: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
45: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
46: );
39:
40: PROCEDURE Clear_Dependent_Attr
41: ( p_attr_id IN NUMBER :=NULL -- FND_API.G_MISS_NUM
42: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
43: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
44: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
45: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
46: );
47:
40: PROCEDURE Clear_Dependent_Attr
41: ( p_attr_id IN NUMBER :=NULL -- FND_API.G_MISS_NUM
42: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
43: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
44: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
45: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
46: );
47:
48: -- Procedure Apply_Attribute_Changes
41: ( p_attr_id IN NUMBER :=NULL -- FND_API.G_MISS_NUM
42: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
43: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
44: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
45: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
46: );
47:
48: -- Procedure Apply_Attribute_Changes
49:
47:
48: -- Procedure Apply_Attribute_Changes
49:
50: PROCEDURE Apply_Attribute_Changes
51: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
52: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
53: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
54: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
55: );
48: -- Procedure Apply_Attribute_Changes
49:
50: PROCEDURE Apply_Attribute_Changes
51: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
52: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
53: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
54: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
55: );
56:
49:
50: PROCEDURE Apply_Attribute_Changes
51: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
52: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
53: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
54: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
55: );
56:
57: -- Function Convert_Miss_To_Null
50: PROCEDURE Apply_Attribute_Changes
51: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
52: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
53: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
54: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
55: );
56:
57: -- Function Convert_Miss_To_Null
58:
56:
57: -- Function Convert_Miss_To_Null
58:
59: FUNCTION Convert_Miss_To_Null
60: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
61: ) RETURN Bom_Bo_Pub.Ref_Designator_Rec_Type;
62:
63: -- Function Query_Row
64:
57: -- Function Convert_Miss_To_Null
58:
59: FUNCTION Convert_Miss_To_Null
60: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
61: ) RETURN Bom_Bo_Pub.Ref_Designator_Rec_Type;
62:
63: -- Function Query_Row
64:
65: PROCEDURE Query_Row
65: PROCEDURE Query_Row
66: ( p_ref_designator IN VARCHAR2
67: , p_component_sequence_id IN NUMBER
68: , p_acd_type IN NUMBER
69: , x_Ref_Designator_Rec OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
70: , x_Ref_Desg_Unexp_Rec OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
71: , x_Return_Status OUT NOCOPY VARCHAR2
72: );
73:
66: ( p_ref_designator IN VARCHAR2
67: , p_component_sequence_id IN NUMBER
68: , p_acd_type IN NUMBER
69: , x_Ref_Designator_Rec OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
70: , x_Ref_Desg_Unexp_Rec OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
71: , x_Return_Status OUT NOCOPY VARCHAR2
72: );
73:
74: PROCEDURE Perform_Writes
71: , x_Return_Status OUT NOCOPY VARCHAR2
72: );
73:
74: PROCEDURE Perform_Writes
75: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_rec_Type
76: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
77: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
78: , x_return_status OUT NOCOPY VARCHAR2
79: );
72: );
73:
74: PROCEDURE Perform_Writes
75: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_rec_Type
76: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
77: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
78: , x_return_status OUT NOCOPY VARCHAR2
79: );
80: