DBA Data[Home] [Help]

APPS.BOM_VALIDATE_BOM_HEADER dependencies on BOM_STRUCTURES_B

Line 69: /* bug 4133037, For creates we need to check for existance in bom_structures_b */

65:
66: If Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Quering Assembly item ' || to_char(p_bom_head_unexp_rec.assembly_item_id)); END IF;
67: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug(' Org: ' || to_char(p_bom_head_unexp_rec.organization_id) || ' Alt: ' || p_bom_header_rec.alternate_bom_code ); END IF;
68:
69: /* bug 4133037, For creates we need to check for existance in bom_structures_b */
70:
71: If(p_bom_header_rec.transaction_type = BOM_Globals.G_OPR_CREATE) then
72: Bom_Bom_Header_Util.Query_Table_Row
73: ( p_assembly_item_id =>

Line 1043: FROM bom_structures_b

1039: AND organization_id = p_bom_head_unexp_rec.organization_id;
1040:
1041: SELECT assembly_type
1042: INTO assmtype
1043: FROM bom_structures_b
1044: WHERE bill_sequence_id = p_bom_head_unexp_rec.source_bill_sequence_id;
1045:
1046: SELECT count(*)
1047: INTO l_count