[Home] [Help]
203:
204: Error_Handler.Write_Debug ('Updating SCOMP Perform Writes ...');
205:
206: --bug:3254815 Update request id, prog id, prog appl id and prog update date.
207: UPDATE BOM_SUBSTITUTE_COMPONENTS
208: SET SUBSTITUTE_COMPONENT_ID = DECODE(p_sub_comp_Unexp_rec.new_substitute_component_id,
209: NULL, p_sub_comp_Unexp_rec.substitute_component_id,
210: FND_API.G_MISS_NUM,
211: p_sub_comp_Unexp_rec.substitute_component_id,
325: * Parameters OUT: Substitute Component Record
326: * Return_Status - Indicating success or faliure
327: * Mesg_Token_Tbl - Filled with any errors or warnings
328: * Purpose : Will Insert a new substitute component record in
329: * Bom_Substitute_Components table.
330: *
331: ********************************************************************/
332: PROCEDURE Insert_Row
333: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
351: );
352: END IF;
353: --Bug 7712832 changes end
354:
355: INSERT INTO BOM_SUBSTITUTE_COMPONENTS
356: ( SUBSTITUTE_COMPONENT_ID
357: , LAST_UPDATE_DATE
358: , LAST_UPDATED_BY
359: , CREATION_DATE
489: l_err_text);
490: end if;
491: END IF;
492:
493: DELETE FROM BOM_SUBSTITUTE_COMPONENTS
494: WHERE SUBSTITUTE_COMPONENT_ID = p_substitute_component_id
495: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
496: AND (( l_BO_Id = Bom_Globals.G_ECO_BO AND
497: ACD_TYPE = p_acd_type
599: , l_Sub_Component_Rec.Acd_Type
600: , x_Sub_comp_Unexp_Rec.Substitute_Component_Id
601: , x_Sub_Comp_Unexp_Rec.Component_Sequence_Id
602: , x_Sub_Comp_Unexp_Rec.enforce_int_requirements_code
603: FROM BOM_SUBSTITUTE_COMPONENTS
604: WHERE SUBSTITUTE_COMPONENT_ID = p_substitute_component_id
605: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
606: AND NVL(DECODE(ACD_TYPE, FND_API.G_MISS_NUM, null, acd_type), 1) =
607: NVL(DECODE(p_acd_type, FND_API.G_MISS_NUM, null, p_acd_type), 1)