11: /*********************** Entity **********************************************/
12:
13: PROCEDURE CHECK_REQUIRED( x_return_status OUT NOCOPY VARCHAR2
14: , p_sub_component_rec IN
15: Bom_Bo_Pub.Sub_Component_Rec_Type
16: , x_Mesg_Token_tbl OUT NOCOPY
17: Error_Handler.Mesg_Token_Tbl_Type
18: )
19: IS
64: *********************************************************************/
65: PROCEDURE Check_Entity
66: ( x_return_status OUT NOCOPY VARCHAR2
67: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
68: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
69: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
70: )
71: IS
72: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
65: PROCEDURE Check_Entity
66: ( x_return_status OUT NOCOPY VARCHAR2
67: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
68: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
69: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
70: )
71: IS
72: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
73: l_sub_comp_unique VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
511:
512: PROCEDURE Check_Attributes
513: ( x_return_status OUT NOCOPY VARCHAR2
514: , x_Mesg_Token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
515: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
516: )
517: IS
518: l_err_text VARCHAR2(255);
519: l_token_tbl Error_Handler.Token_Tbl_Type;
560:
561: PROCEDURE Check_Entity_Delete
562: ( x_return_status OUT NOCOPY VARCHAR2
563: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
564: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
565: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
566: )
567: IS
568: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
561: PROCEDURE Check_Entity_Delete
562: ( x_return_status OUT NOCOPY VARCHAR2
563: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
564: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
565: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
566: )
567: IS
568: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
569: l_err_text VARCHAR2(255);
590: * the procedure will query the existing record and return them
591: * as old records.
592: ***************************************************************************/
593: PROCEDURE Check_Existence
594: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
595: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
596: , x_old_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
597: , x_old_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
598: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
591: * as old records.
592: ***************************************************************************/
593: PROCEDURE Check_Existence
594: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
595: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
596: , x_old_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
597: , x_old_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
598: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
599: , x_Return_Status OUT NOCOPY VARCHAR2
592: ***************************************************************************/
593: PROCEDURE Check_Existence
594: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
595: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
596: , x_old_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
597: , x_old_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
598: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
599: , x_Return_Status OUT NOCOPY VARCHAR2
600: )
593: PROCEDURE Check_Existence
594: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
595: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
596: , x_old_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
597: , x_old_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
598: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
599: , x_Return_Status OUT NOCOPY VARCHAR2
600: )
601: IS
674: * hold good in the production tables based on the data that
675: * the user has given.
676: *****************************************************************************/
677: PROCEDURE Check_Lineage
678: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
679: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
680: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
681: , x_Return_Status OUT NOCOPY VARCHAR2
682: )
675: * the user has given.
676: *****************************************************************************/
677: PROCEDURE Check_Lineage
678: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
679: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
680: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
681: , x_Return_Status OUT NOCOPY VARCHAR2
682: )
683: IS
738: * Component. It will also verify that the revised item is not
739: * already implemented or canceled.
740: ****************************************************************************/
741: PROCEDURE Check_Access
742: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
743: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
744: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
745: , x_Return_Status OUT NOCOPY VARCHAR2
746: )
739: * already implemented or canceled.
740: ****************************************************************************/
741: PROCEDURE Check_Access
742: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
743: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
744: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
745: , x_Return_Status OUT NOCOPY VARCHAR2
746: )
747: IS