DBA Data[Home] [Help]

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 275: INSERT INTO BOM_REFERENCE_DESIGNATORS

271: IS
272: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
273: BEGIN
274:
275: INSERT INTO BOM_REFERENCE_DESIGNATORS
276: ( COMPONENT_REFERENCE_DESIGNATOR
277: , LAST_UPDATE_DATE
278: , LAST_UPDATED_BY
279: , CREATION_DATE

Line 398: DELETE FROM BOM_REFERENCE_DESIGNATORS

394: l_BO_Id VARCHAR2(3) := Bom_Globals.Get_Bo_Identifier;
395:
396: BEGIN
397:
398: DELETE FROM BOM_REFERENCE_DESIGNATORS
399: WHERE COMPONENT_REFERENCE_DESIGNATOR = p_ref_designator
400: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
401: AND ( ( l_BO_Id = Bom_Globals.G_ECO_BO AND
402: ACD_TYPE = p_acd_type

Line 507: FROM BOM_REFERENCE_DESIGNATORS

503: , l_ref_designator_rec.attribute12
504: , l_ref_designator_rec.attribute13
505: , l_ref_designator_rec.attribute14
506: , l_ref_designator_rec.attribute15
507: FROM BOM_REFERENCE_DESIGNATORS
508: WHERE COMPONENT_REFERENCE_DESIGNATOR = p_ref_designator
509: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
510: AND NVL(DECODE(ACD_TYPE, FND_API.G_MISS_NUM, null, acd_type), 1) =
511: NVL(DECODE(p_acd_type, FND_API.G_MISS_NUM, null, p_acd_type), 1)