147: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
148: l_Token_Tbl Error_Handler.Token_Tbl_Type;
149: BEGIN
150:
151: UPDATE BOM_REFERENCE_DESIGNATORS
152: SET LAST_UPDATE_DATE = SYSDATE
153: , LAST_UPDATED_BY = Bom_Globals.Get_User_Id
154: , LAST_UPDATE_LOGIN = Bom_Globals.Get_User_Id
155: , REF_DESIGNATOR_COMMENT =
217: IS
218: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
219: BEGIN
220:
221: INSERT INTO BOM_REFERENCE_DESIGNATORS
222: ( COMPONENT_REFERENCE_DESIGNATOR
223: , LAST_UPDATE_DATE
224: , LAST_UPDATED_BY
225: , CREATION_DATE
330: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
331:
332: BEGIN
333:
334: DELETE FROM BOM_REFERENCE_DESIGNATORS
335: WHERE COMPONENT_REFERENCE_DESIGNATOR = p_ref_designator
336: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
337: AND ACD_TYPE = p_acd_type
338: ;
424: , l_ref_designator_rec.attribute12
425: , l_ref_designator_rec.attribute13
426: , l_ref_designator_rec.attribute14
427: , l_ref_designator_rec.attribute15
428: FROM BOM_REFERENCE_DESIGNATORS
429: WHERE COMPONENT_REFERENCE_DESIGNATOR = p_ref_designator
430: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
431: AND ACD_TYPE = p_acd_type
432: ;