APPS.BOM_VALIDATE_BOM_HEADER dependencies on BOM_STRUCTURE_TYPES_B

Line 525: l_existing_str_type BOM_STRUCTURE_TYPES_B.STRUCTURE_TYPE_NAME%TYPE;

521: AND organization_id = p_bom_head_unexp_rec.organization_id
522: AND NVL(alternate_bom_designator, 'XXXX') =
523: NVL(p_bom_header_rec.alternate_bom_code, 'XXXX'); */
524:
525: l_existing_str_type BOM_STRUCTURE_TYPES_B.STRUCTURE_TYPE_NAME%TYPE;
526:
527: BEGIN
528:
529: --

Line 587: SELECT structure_type_id INTO struct_type_id FROM bom_structure_types_b

583: END IF;
584:
585: -- PackBom Related validations ..
586:
587: SELECT structure_type_id INTO struct_type_id FROM bom_structure_types_b
588: WHERE structure_type_name = 'Packaging Hierarchy';
589:
590: IF p_bom_head_unexp_rec.structure_type_id = struct_type_id
591: THEN

Line 705: FROM BOM_STRUCTURE_TYPES_B BST

701: BAD.ORGANIZATION_ID = p_bom_head_unexp_rec.organization_id
702: AND BAD.ALTERNATE_DESIGNATOR_CODE = p_bom_header_rec.alternate_bom_code
703: AND BAD.STRUCTURE_TYPE_ID IN
704: ( SELECT BST.STRUCTURE_TYPE_ID
705: FROM BOM_STRUCTURE_TYPES_B BST
706: START WITH BST.STRUCTURE_TYPE_ID = p_bom_head_unexp_rec.structure_type_id
707: CONNECT BY PRIOR BST.PARENT_STRUCTURE_TYPE_ID = BST.STRUCTURE_TYPE_ID
708: );
709:

Line 735: FROM BOM_STRUCTURE_TYPES_B BST

731: AND p_bom_head_unexp_rec.structure_type_id <> p_old_bom_head_unexp_rec.structure_type_id )
732: THEN
733: SELECT COUNT(1)
734: INTO l_count
735: FROM BOM_STRUCTURE_TYPES_B BST
736: WHERE BST.STRUCTURE_TYPE_ID = p_bom_head_unexp_rec.structure_type_id
737: START WITH BST.STRUCTURE_TYPE_ID = p_old_bom_head_unexp_rec.structure_type_id
738: CONNECT BY PRIOR BST.STRUCTURE_TYPE_ID = BST.PARENT_STRUCTURE_TYPE_ID;
739:

Line 748: FROM BOM_STRUCTURE_TYPES_B

744: l_token_tbl(1).token_name := 'OLD_STRTYPE';
745: BEGIN
746: SELECT STRUCTURE_TYPE_NAME
747: INTO l_existing_str_type
748: FROM BOM_STRUCTURE_TYPES_B
749: WHERE STRUCTURE_TYPE_ID = p_old_bom_head_unexp_rec.structure_type_id;
750:
751: l_token_tbl(1).token_value := l_existing_str_type;
752: EXCEPTION