APPS.BSC_PERIODICITY_PVT dependencies on BSC_SYS_PERIODS

Line 75: INSERT INTO bsc_sys_periods

71: l_Start_Date := NULL;
72: l_End_Date := NULL;
73: END IF;
74:
75: INSERT INTO bsc_sys_periods
76: ( periodicity_id
77: , year
78: , period_id
79: , start_date

Line 209: DELETE bsc_sys_periods

205: SAVEPOINT DeletePeriodsPVTSP;
206: FND_MSG_PUB.Initialize;
207: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
208:
209: DELETE bsc_sys_periods
210: WHERE periodicity_id = p_Period_Record.Periodicity_Id;
211:
212: DELETE bsc_sys_periods_tl
213: WHERE periodicity_id = p_Period_Record.Periodicity_Id;

Line 212: DELETE bsc_sys_periods_tl

208:
209: DELETE bsc_sys_periods
210: WHERE periodicity_id = p_Period_Record.Periodicity_Id;
211:
212: DELETE bsc_sys_periods_tl
213: WHERE periodicity_id = p_Period_Record.Periodicity_Id;
214:
215: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN
216: COMMIT;