APPS.ENG_SUB_COMPONENT_UTIL dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 184: UPDATE BOM_SUBSTITUTE_COMPONENTS

180: );
181: dbms_output.put_line('Acd_Type : ' || to_Char(p_sub_component_rec.acd_type));
182:
183:
184: UPDATE BOM_SUBSTITUTE_COMPONENTS
185: SET SUBSTITUTE_ITEM_QUANTITY =
186: p_sub_component_rec.substitute_item_quantity
187: , ATTRIBUTE_CATEGORY = p_sub_component_rec.attribute_category
188: , ATTRIBUTE1 = p_sub_component_rec.attribute1

Line 259: * Bom_Substitute_Components table.

255: * Parameters OUT: Substitute Component Record
256: * Return_Status - Indicating success or faliure
257: * Mesg_Token_Tbl - Filled with any errors or warnings
258: * Purpose : Will Insert a new substitute component record in
259: * Bom_Substitute_Components table.
260: *
261: ********************************************************************/
262: PROCEDURE Insert_Row
263: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

Line 276: INSERT INTO BOM_SUBSTITUTE_COMPONENTS

272: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
273: BEGIN
274:
275:
276: INSERT INTO BOM_SUBSTITUTE_COMPONENTS
277: ( SUBSTITUTE_COMPONENT_ID
278: , LAST_UPDATE_DATE
279: , LAST_UPDATED_BY
280: , CREATION_DATE

Line 401: DELETE FROM BOM_SUBSTITUTE_COMPONENTS

397: Bom_GLOBALS.Get_org_id,
398: l_err_text);
399: end if;
400:
401: DELETE FROM BOM_SUBSTITUTE_COMPONENTS
402: WHERE SUBSTITUTE_COMPONENT_ID = p_substitute_component_id
403: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
404: AND ACD_TYPE = p_acd_type
405: ;

Line 502: FROM BOM_SUBSTITUTE_COMPONENTS

498: , l_Sub_Component_Rec.Eco_Name
499: , l_Sub_Component_Rec.Acd_Type
500: , x_Sub_comp_Unexp_Rec.Substitute_Component_Id
501: , x_Sub_Comp_Unexp_Rec.Component_Sequence_Id
502: FROM BOM_SUBSTITUTE_COMPONENTS
503: WHERE SUBSTITUTE_COMPONENT_ID = p_substitute_component_id
504: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
505: AND ACD_TYPE = p_acd_type
506: ;