APPS.BOM_REF_DESIGNATOR_UTIL dependencies on BOM_REFERENCE_DESIGNATORS

Line 169: UPDATE BOM_REFERENCE_DESIGNATORS

165: l_Token_Tbl Error_Handler.Token_Tbl_Type;
166: l_BO_Id VARCHAR2(3) := Bom_Globals.Get_Bo_Identifier;
167: BEGIN
168: --bug:3254815 Update request id, prog id, prog appl id and prog update date.
169: UPDATE BOM_REFERENCE_DESIGNATORS
170: SET COMPONENT_REFERENCE_DESIGNATOR =
171: DECODE(p_ref_designator_rec.new_reference_designator,
172: NULL,p_ref_designator_rec.Reference_Designator_Name,
173: FND_API.G_MISS_CHAR,

Line 307: INSERT INTO BOM_REFERENCE_DESIGNATORS

303: l_src_comp_seq_id := Common_CompSeqIdRD( p_comp_seq_id => p_Ref_Desg_Unexp_Rec.component_sequence_id
304: );
305: END IF;
306: --Bug 7712832 changes end
307: INSERT INTO BOM_REFERENCE_DESIGNATORS
308: ( COMPONENT_REFERENCE_DESIGNATOR
309: , LAST_UPDATE_DATE
310: , LAST_UPDATED_BY
311: , CREATION_DATE

Line 434: DELETE FROM BOM_REFERENCE_DESIGNATORS

430: l_BO_Id VARCHAR2(3) := Bom_Globals.Get_Bo_Identifier;
431:
432: BEGIN
433:
434: DELETE FROM BOM_REFERENCE_DESIGNATORS
435: WHERE COMPONENT_REFERENCE_DESIGNATOR = p_ref_designator
436: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
437: AND ( ( l_BO_Id = Bom_Globals.G_ECO_BO AND
438: ACD_TYPE = p_acd_type

Line 543: FROM BOM_REFERENCE_DESIGNATORS

539: , l_ref_designator_rec.attribute12
540: , l_ref_designator_rec.attribute13
541: , l_ref_designator_rec.attribute14
542: , l_ref_designator_rec.attribute15
543: FROM BOM_REFERENCE_DESIGNATORS
544: WHERE COMPONENT_REFERENCE_DESIGNATOR = p_ref_designator
545: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
546: AND NVL(DECODE(ACD_TYPE, FND_API.G_MISS_NUM, null, acd_type), 1) =
547: NVL(DECODE(p_acd_type, FND_API.G_MISS_NUM, null, p_acd_type), 1)