69:
70: -- PROCEDURE Convert_Miss_To_Null
71:
72: PROCEDURE Convert_Miss_To_Null
73: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
74: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
75: , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
76: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
77: );
70: -- PROCEDURE Convert_Miss_To_Null
71:
72: PROCEDURE Convert_Miss_To_Null
73: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
74: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
75: , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
76: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
77: );
78:
71:
72: PROCEDURE Convert_Miss_To_Null
73: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
74: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
75: , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
76: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
77: );
78:
79: -- Function Query_Row
72: PROCEDURE Convert_Miss_To_Null
73: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
74: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
75: , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
76: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
77: );
78:
79: -- Function Query_Row
80:
83: , p_Operation_Sequence_Number IN NUMBER
84: , p_Effectivity_Date IN DATE
85: , p_Bill_Sequence_Id IN NUMBER
86: , p_from_end_item_number IN VARCHAR2 := NULL
87: , x_Rev_Component_Rec OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
88: , x_Rev_Comp_Unexp_Rec OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
89: , x_Return_Status OUT NOCOPY VARCHAR2
90: );
91:
84: , p_Effectivity_Date IN DATE
85: , p_Bill_Sequence_Id IN NUMBER
86: , p_from_end_item_number IN VARCHAR2 := NULL
87: , x_Rev_Component_Rec OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
88: , x_Rev_Comp_Unexp_Rec OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
89: , x_Return_Status OUT NOCOPY VARCHAR2
90: );
91:
92: -- Procedure lock_Row
93: --
94:
95: PROCEDURE Lock_Row
96: ( x_return_status OUT NOCOPY VARCHAR2
97: , p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
98: , x_rev_component_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
99: , x_err_text OUT NOCOPY VARCHAR2
100: );
101:
94:
95: PROCEDURE Lock_Row
96: ( x_return_status OUT NOCOPY VARCHAR2
97: , p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
98: , x_rev_component_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
99: , x_err_text OUT NOCOPY VARCHAR2
100: );
101:
102:
115: );
116:
117:
118: PROCEDURE Perform_Writes( p_rev_component_rec IN
119: Bom_Bo_Pub.Rev_Component_Rec_Type
120: , p_rev_comp_unexp_rec IN
121: Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
122: , x_Mesg_Token_Tbl OUT NOCOPY
123: Error_Handler.Mesg_Token_Tbl_Type
117:
118: PROCEDURE Perform_Writes( p_rev_component_rec IN
119: Bom_Bo_Pub.Rev_Component_Rec_Type
120: , p_rev_comp_unexp_rec IN
121: Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
122: , x_Mesg_Token_Tbl OUT NOCOPY
123: Error_Handler.Mesg_Token_Tbl_Type
124: , x_Return_Status OUT NOCOPY VARCHAR2
125: );