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