37:
38: -- Function Convert_Miss_To_Null
39:
40: FUNCTION Convert_Miss_To_Null
41: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
42: ) RETURN Bom_Bo_Pub.Sub_Component_Rec_Type;
43:
44: -- Function Query_Row
45:
38: -- Function Convert_Miss_To_Null
39:
40: FUNCTION Convert_Miss_To_Null
41: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
42: ) RETURN Bom_Bo_Pub.Sub_Component_Rec_Type;
43:
44: -- Function Query_Row
45:
46: PROCEDURE Query_Row
46: PROCEDURE Query_Row
47: ( p_substitute_component_id IN NUMBER
48: , p_component_sequence_id IN NUMBER
49: , p_acd_type IN NUMBER
50: , x_Sub_Component_Rec OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
51: , x_Sub_Comp_Unexp_Rec OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
52: , x_return_status OUT NOCOPY VARCHAR2
53: );
54:
47: ( p_substitute_component_id IN NUMBER
48: , p_component_sequence_id IN NUMBER
49: , p_acd_type IN NUMBER
50: , x_Sub_Component_Rec OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
51: , x_Sub_Comp_Unexp_Rec OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
52: , x_return_status OUT NOCOPY VARCHAR2
53: );
54:
55: -- Procedure lock_Row
56: --
57:
58: PROCEDURE Lock_Row
59: ( x_return_status OUT NOCOPY VARCHAR2
60: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
61: , x_sub_component_rec OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
62: , x_err_text OUT NOCOPY VARCHAR2
63: );
64:
57:
58: PROCEDURE Lock_Row
59: ( x_return_status OUT NOCOPY VARCHAR2
60: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
61: , x_sub_component_rec OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
62: , x_err_text OUT NOCOPY VARCHAR2
63: );
64:
65: PROCEDURE Perform_Writes
62: , x_err_text OUT NOCOPY VARCHAR2
63: );
64:
65: PROCEDURE Perform_Writes
66: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
67: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
68: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
69: , x_Return_Status OUT NOCOPY VARCHAR2
70: );
63: );
64:
65: PROCEDURE Perform_Writes
66: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
67: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
68: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
69: , x_Return_Status OUT NOCOPY VARCHAR2
70: );
71: