507: * Log Error will also make sure that the error propogates to the right levels of the business object
508: * and that the rest of the entities get the appropriate status and message.This will log the error based on the
509: * error level whether its Bill Header,Revision,Revised Components,Reference Designator,Substitute Components etc.
510: * @param p_bom_header_rec IN BOM Header Exposed Column Record
511: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
512: * @param p_bom_revision_tbl IN Revision Exposed Column Table
513: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Revision_Tbl_Type}
514: * @param p_bom_component_tbl IN Components Exposed Column Table
515: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Comps_Tbl_Type}
509: * error level whether its Bill Header,Revision,Revised Components,Reference Designator,Substitute Components etc.
510: * @param p_bom_header_rec IN BOM Header Exposed Column Record
511: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
512: * @param p_bom_revision_tbl IN Revision Exposed Column Table
513: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Revision_Tbl_Type}
514: * @param p_bom_component_tbl IN Components Exposed Column Table
515: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Comps_Tbl_Type}
516: * @param p_bom_ref_Designator_tbl IN Reference Designator Exposed Column Table
517: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type}
511: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
512: * @param p_bom_revision_tbl IN Revision Exposed Column Table
513: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Revision_Tbl_Type}
514: * @param p_bom_component_tbl IN Components Exposed Column Table
515: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Comps_Tbl_Type}
516: * @param p_bom_ref_Designator_tbl IN Reference Designator Exposed Column Table
517: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type}
518: * @param p_bom_sub_component_tbl IN Substitute Components Exposed Column Table
519: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type}
513: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Revision_Tbl_Type}
514: * @param p_bom_component_tbl IN Components Exposed Column Table
515: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Comps_Tbl_Type}
516: * @param p_bom_ref_Designator_tbl IN Reference Designator Exposed Column Table
517: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type}
518: * @param p_bom_sub_component_tbl IN Substitute Components Exposed Column Table
519: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type}
520: * @param p_Mesg_Token_tbl IN Message Token Table
521: * @rep:paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
515: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Comps_Tbl_Type}
516: * @param p_bom_ref_Designator_tbl IN Reference Designator Exposed Column Table
517: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type}
518: * @param p_bom_sub_component_tbl IN Substitute Components Exposed Column Table
519: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type}
520: * @param p_Mesg_Token_tbl IN Message Token Table
521: * @rep:paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
522: * @param p_error_status IN S-Success,E-Error,F-Fatal Error,U-Enexpected Error
523: * @param p_error_scope IN R-error affects Current Record,S-error affects Sibling and Child Records,C-error affects
538: * @param p_row_identifier IN Any unique identifier value for the entity record.
539: * In case of bulk load from interface table this can
540: * be used to store the transaction_id
541: * @param x_bom_header_rec IN OUT NOCOPY processed BOM Header Exposed Column Record
542: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Bo_Pub.Bom_Head_Rec_Type}
543: * @param x_bom_revision_tbl IN OUT NOCOPY processed Revision Exposed Column Table
544: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Revision_Tbl_Type}
545: * @param x_bom_component_tbl IN OUT NOCOPY processed Components Exposed Column Table
546: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Comps_Tbl_Type}
540: * be used to store the transaction_id
541: * @param x_bom_header_rec IN OUT NOCOPY processed BOM Header Exposed Column Record
542: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Bo_Pub.Bom_Head_Rec_Type}
543: * @param x_bom_revision_tbl IN OUT NOCOPY processed Revision Exposed Column Table
544: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Revision_Tbl_Type}
545: * @param x_bom_component_tbl IN OUT NOCOPY processed Components Exposed Column Table
546: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Comps_Tbl_Type}
547: * @param x_bom_ref_Designator_tbl IN OUT NOCOPY processed Reference Designator Exposed Column Table
548: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type}
542: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Bo_Pub.Bom_Head_Rec_Type}
543: * @param x_bom_revision_tbl IN OUT NOCOPY processed Revision Exposed Column Table
544: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Revision_Tbl_Type}
545: * @param x_bom_component_tbl IN OUT NOCOPY processed Components Exposed Column Table
546: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Comps_Tbl_Type}
547: * @param x_bom_ref_Designator_tbl IN OUT NOCOPY processed Reference Designator Exposed Column Table
548: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type}
549: * @param x_bom_sub_component_tbl IN OUT NOCOPY processed Substitute Components Exposed Column Table
550: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type}
544: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Revision_Tbl_Type}
545: * @param x_bom_component_tbl IN OUT NOCOPY processed Components Exposed Column Table
546: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Comps_Tbl_Type}
547: * @param x_bom_ref_Designator_tbl IN OUT NOCOPY processed Reference Designator Exposed Column Table
548: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type}
549: * @param x_bom_sub_component_tbl IN OUT NOCOPY processed Substitute Components Exposed Column Table
550: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type}
551: * @rep:scope public
552: * @rep:lifecycle active
546: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Comps_Tbl_Type}
547: * @param x_bom_ref_Designator_tbl IN OUT NOCOPY processed Reference Designator Exposed Column Table
548: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type}
549: * @param x_bom_sub_component_tbl IN OUT NOCOPY processed Substitute Components Exposed Column Table
550: * @rep:paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type}
551: * @rep:scope public
552: * @rep:lifecycle active
553: * @rep:compatibility S
554: * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
556: */
557:
558:
559: PROCEDURE Log_Error
560: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
561: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
562: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
563: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
564: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
557:
558:
559: PROCEDURE Log_Error
560: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
561: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
562: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
563: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
564: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
565: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
558:
559: PROCEDURE Log_Error
560: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
561: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
562: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
563: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
564: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
565: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
566: , p_bom_ref_Designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
559: PROCEDURE Log_Error
560: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
561: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
562: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
563: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
564: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
565: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
566: , p_bom_ref_Designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
567: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
560: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
561: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
562: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
563: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
564: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
565: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
566: , p_bom_ref_Designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
567: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
568: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
561: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
562: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
563: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
564: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
565: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
566: , p_bom_ref_Designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
567: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
568: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
569: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
562: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
563: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
564: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
565: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
566: , p_bom_ref_Designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
567: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
568: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
569: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
570:
563: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
564: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
565: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
566: , p_bom_ref_Designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
567: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
568: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
569: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
570:
571: , p_Mesg_Token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
564: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
565: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
566: , p_bom_ref_Designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
567: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
568: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
569: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
570:
571: , p_Mesg_Token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
572: := Error_Handler.G_MISS_MESG_TOKEN_TBL
565: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
566: , p_bom_ref_Designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
567: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
568: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
569: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
570:
571: , p_Mesg_Token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
572: := Error_Handler.G_MISS_MESG_TOKEN_TBL
573: , p_error_status IN VARCHAR2
578: , p_other_token_tbl IN Error_Handler.Token_Tbl_Type
579: := Error_Handler.G_MISS_TOKEN_TBL
580: , p_error_level IN NUMBER
581: , p_entity_index IN NUMBER := 1 -- := NULL
582: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
583: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
584: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
585: , x_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
586: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
579: := Error_Handler.G_MISS_TOKEN_TBL
580: , p_error_level IN NUMBER
581: , p_entity_index IN NUMBER := 1 -- := NULL
582: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
583: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
584: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
585: , x_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
586: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
587: , p_row_identifier IN NUMBER := NULL
580: , p_error_level IN NUMBER
581: , p_entity_index IN NUMBER := 1 -- := NULL
582: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
583: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
584: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
585: , x_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
586: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
587: , p_row_identifier IN NUMBER := NULL
588: );
581: , p_entity_index IN NUMBER := 1 -- := NULL
582: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
583: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
584: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
585: , x_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
586: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
587: , p_row_identifier IN NUMBER := NULL
588: );
589:
582: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
583: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
584: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
585: , x_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
586: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
587: , p_row_identifier IN NUMBER := NULL
588: );
589:
590:
631: , p_row_identifier IN NUMBER := NULL
632: , p_table_name IN VARCHAR2 := NULL
633: , p_entity_code IN VARCHAR2 := NULL
634: , p_mesg_name IN VARCHAR2 := NULL
635: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
636: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
637: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
638: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
639: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
632: , p_table_name IN VARCHAR2 := NULL
633: , p_entity_code IN VARCHAR2 := NULL
634: , p_mesg_name IN VARCHAR2 := NULL
635: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
636: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
637: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
638: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
639: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
640: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_ops_Tbl_Type
633: , p_entity_code IN VARCHAR2 := NULL
634: , p_mesg_name IN VARCHAR2 := NULL
635: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
636: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
637: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
638: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
639: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
640: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_ops_Tbl_Type
641: );
634: , p_mesg_name IN VARCHAR2 := NULL
635: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
636: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
637: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
638: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
639: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
640: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_ops_Tbl_Type
641: );
642:
635: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
636: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
637: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
638: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
639: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
640: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_ops_Tbl_Type
641: );
642:
643:
636: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
637: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
638: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
639: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
640: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_ops_Tbl_Type
641: );
642:
643:
644:
679: , p_application_id IN VARCHAR2 := 'ENG'
680: , p_row_identifier IN NUMBER := NULL
681: , p_table_name IN VARCHAR2 := NULL
682: , p_entity_code IN VARCHAR2 := NULL
683: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
684: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
685: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
686: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
687: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
680: , p_row_identifier IN NUMBER := NULL
681: , p_table_name IN VARCHAR2 := NULL
682: , p_entity_code IN VARCHAR2 := NULL
683: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
684: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
685: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
686: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
687: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
688: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
681: , p_table_name IN VARCHAR2 := NULL
682: , p_entity_code IN VARCHAR2 := NULL
683: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
684: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
685: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
686: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
687: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
688: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
689: );
682: , p_entity_code IN VARCHAR2 := NULL
683: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
684: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
685: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
686: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
687: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
688: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
689: );
690:
683: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
684: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
685: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
686: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
687: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
688: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
689: );
690:
691:
684: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
685: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
686: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
687: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
688: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
689: );
690:
691:
692:
802: , p_entity_index IN NUMBER := NULL
803: , p_table_name IN VARCHAR2 := NULL
804: , p_entity_code IN VARCHAR2 := NULL
805: , p_addto_fnd_stack IN VARCHAR2 := 'N'
806: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
807: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
808: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
809: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
810: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
803: , p_table_name IN VARCHAR2 := NULL
804: , p_entity_code IN VARCHAR2 := NULL
805: , p_addto_fnd_stack IN VARCHAR2 := 'N'
806: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
807: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
808: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
809: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
810: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
811: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
804: , p_entity_code IN VARCHAR2 := NULL
805: , p_addto_fnd_stack IN VARCHAR2 := 'N'
806: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
807: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
808: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
809: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
810: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
811: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
812: );
805: , p_addto_fnd_stack IN VARCHAR2 := 'N'
806: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
807: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
808: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
809: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
810: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
811: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
812: );
813:
806: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
807: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
808: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
809: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
810: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
811: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
812: );
813:
814:
807: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
808: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
809: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
810: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
811: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
812: );
813:
814:
815:
826: FUNCTION Get_Bo_Identifier RETURN VARCHAR2;
827:
828: /* One to many operations support */
829:
830: PROCEDURE Set_Bom_Specific( p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_type);
831:
832: PROCEDURE Get_Bom_Specific( x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_type);
833:
834:
828: /* One to many operations support */
829:
830: PROCEDURE Set_Bom_Specific( p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_type);
831:
832: PROCEDURE Get_Bom_Specific( x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_type);
833:
834:
835: PROCEDURE Set_Debug (p_debug_flag IN VARCHAR2 := 'N');
836: