APPS.BOM_VALIDATE_BOM_REVISION dependencies on BOM_BO_PUB

Line 29: , p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type

25:
26: PROCEDURE Check_Entity
27: ( x_return_status IN OUT NOCOPY VARCHAR2
28: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
29: , p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
30: , p_bom_rev_Unexp_Rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
31: , p_old_bom_revision_Rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
32: , p_old_bom_Rev_Unexp_Rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
33: )

Line 30: , p_bom_rev_Unexp_Rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type

26: PROCEDURE Check_Entity
27: ( x_return_status IN OUT NOCOPY VARCHAR2
28: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
29: , p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
30: , p_bom_rev_Unexp_Rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
31: , p_old_bom_revision_Rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
32: , p_old_bom_Rev_Unexp_Rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
33: )
34: IS

Line 31: , p_old_bom_revision_Rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type

27: ( x_return_status IN OUT NOCOPY VARCHAR2
28: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
29: , p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
30: , p_bom_rev_Unexp_Rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
31: , p_old_bom_revision_Rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
32: , p_old_bom_Rev_Unexp_Rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
33: )
34: IS
35: CURSOR c_Get_Revision IS

Line 32: , p_old_bom_Rev_Unexp_Rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type

28: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
29: , p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
30: , p_bom_rev_Unexp_Rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
31: , p_old_bom_revision_Rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
32: , p_old_bom_Rev_Unexp_Rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
33: )
34: IS
35: CURSOR c_Get_Revision IS
36: SELECT revision, effectivity_date

Line 185: , p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type

181:
182: PROCEDURE Check_Required
183: ( x_return_status IN OUT NOCOPY VARCHAR2
184: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
185: , p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
186: )
187: IS
188: BEGIN
189: IF p_bom_revision_rec.revision IS NULL OR

Line 205: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_revision_Rec_Type

201: END Check_Required;
202:
203:
204: PROCEDURE Check_Existence
205: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_revision_Rec_Type
206: , p_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
207: , x_old_bom_revision_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Rec_Type
208: , x_old_bom_rev_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
209: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 206: , p_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type

202:
203:
204: PROCEDURE Check_Existence
205: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_revision_Rec_Type
206: , p_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
207: , x_old_bom_revision_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Rec_Type
208: , x_old_bom_rev_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
209: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
210: , x_return_status IN OUT NOCOPY VARCHAR2

Line 207: , x_old_bom_revision_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Rec_Type

203:
204: PROCEDURE Check_Existence
205: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_revision_Rec_Type
206: , p_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
207: , x_old_bom_revision_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Rec_Type
208: , x_old_bom_rev_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
209: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
210: , x_return_status IN OUT NOCOPY VARCHAR2
211: )

Line 208: , x_old_bom_rev_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type

204: PROCEDURE Check_Existence
205: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_revision_Rec_Type
206: , p_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
207: , x_old_bom_revision_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Rec_Type
208: , x_old_bom_rev_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
209: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
210: , x_return_status IN OUT NOCOPY VARCHAR2
211: )
212: IS