DBA Data[Home] [Help]

APPS.ENG_REF_DESIGNATOR_UTIL dependencies on BOM_REFERENCE_DESIGNATORS

Line 151: UPDATE BOM_REFERENCE_DESIGNATORS

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 =

Line 221: INSERT INTO BOM_REFERENCE_DESIGNATORS

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

Line 334: DELETE FROM BOM_REFERENCE_DESIGNATORS

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: ;

Line 428: FROM BOM_REFERENCE_DESIGNATORS

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: ;