DBA Data[Home] [Help]

APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on BOM_REFERENCE_DESIGNATORS

Line 3088: FROM bom_reference_designators

3084: l_RC_Duplicate_Comps NUMBER :=0;
3085:
3086: CURSOR c_RefDesgs IS
3087: SELECT count(component_sequence_id) number_of_desgs
3088: FROM bom_reference_designators
3089: WHERE component_sequence_id =
3090: p_rev_comp_unexp_rec.component_sequence_id;
3091:
3092: CURSOR c_NewBill IS

Line 3235: select count(*) into l_total_rds from bom_reference_designators

3231: -- Basis type cannot be Lot if there are existing Reference Desigantors.
3232: IF (p_rev_component_rec.transaction_type = Bom_Globals.G_OPR_UPDATE) THEN
3233:
3234: If(p_rev_component_rec.Basis_type = 2) THEN
3235: select count(*) into l_total_rds from bom_reference_designators
3236: where nvl(p_rev_component_rec.acd_type,1) <>3 and component_sequence_id=p_Rev_Comp_Unexp_Rec.component_sequence_id;
3237: IF(l_total_rds <>0) THEN
3238: l_Token_Tbl(1).Token_Name := 'REVISED_COMPONENT_NAME';
3239: l_Token_Tbl(1).Token_Value := p_rev_component_rec.component_item_name;