292: --update or delete the component once the profile is unset (meaning you cannot insert, update
293: --or delete a substitute component on it
294:
295: IF
296: nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1 AND
297: l_parent_BIT = Bom_Globals.G_STANDARD AND
298: l_parent_PTO_Flag = 'Y' AND
299: l_rec_ATO_Flag = 'Y' AND
300: l_rec_BIT = Bom_Globals.G_STANDARD
310:
311:
312:
313: IF
314: nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1 AND
315: l_parent_BIT = Bom_Globals.G_MODEL AND
316: l_parent_PTO_Flag = 'Y' AND
317: l_rec_ATO_Flag = 'Y' AND
318: l_rec_BIT = Bom_Globals.G_STANDARD AND
895: NULL;
896: END;
897:
898: IF
899: nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1 AND
900: l_parent_BIT = Bom_Globals.G_STANDARD AND
901: l_parent_PTO_Flag = 'Y' AND
902: l_rec_ATO_Flag = 'Y' AND
903: l_rec_BIT = Bom_Globals.G_STANDARD
915: --update or delete the component once the profile is unset (meaning you cannot insert, update
916: --or delete a substitute component on it
917:
918: IF
919: nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1 AND
920: l_parent_BIT = Bom_Globals.G_MODEL AND
921: l_parent_PTO_Flag = 'Y' AND
922: l_rec_ATO_Flag = 'Y' AND
923: l_rec_BIT = Bom_Globals.G_STANDARD AND