494: FND_MSG_PUB.Initialize;
495:
496: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
497:
498: DELETE BSC_SYS_PERIODS_TL
499: WHERE PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_Id;
500:
501: DELETE BSC_SYS_PERIODS
502: WHERE PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_Id;
497:
498: DELETE BSC_SYS_PERIODS_TL
499: WHERE PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_Id;
500:
501: DELETE BSC_SYS_PERIODS
502: WHERE PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_Id;
503:
504: DELETE BSC_SYS_PERIODICITIES_TL
505: WHERE PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_Id;