APPS.BSC_CALENDAR_PVT dependencies on BSC_SYS_CALENDARS_B

Line 36: INSERT INTO bsc_sys_calendars_b

32: SAVEPOINT CreateCalendarSP;
33: FND_MSG_PUB.Initialize;
34: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
35:
36: INSERT INTO bsc_sys_calendars_b
37: ( calendar_id
38: , edw_flag
39: , edw_calendar_id
40: , edw_calendar_type_id

Line 146: UPDATE bsc_sys_calendars_b

142: FND_MSG_PUB.Initialize;
143: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
144:
145: -- added for Bug#4565308
146: UPDATE bsc_sys_calendars_b
147: SET fiscal_year = p_Calendar_Record.Fiscal_Year
148: , current_year = p_Calendar_Record.Current_Year
149: , start_month = p_Calendar_Record.Start_Month
150: , start_day = p_Calendar_Record.Start_Day

Line 247: --dbms_output.put_line(' deleting from bsc_sys_calendars_b with calendar id as :- ' || p_Calendar_Record.Calendar_Id);

243: WHERE calendar_id = p_Calendar_Record.Calendar_Id;
244:
245: DELETE bsc_sys_calendars_tl
246: WHERE calendar_id = p_Calendar_Record.Calendar_Id;
247: --dbms_output.put_line(' deleting from bsc_sys_calendars_b with calendar id as :- ' || p_Calendar_Record.Calendar_Id);
248:
249: DELETE bsc_sys_calendars_b
250: WHERE calendar_id = p_Calendar_Record.Calendar_Id;
251:

Line 249: DELETE bsc_sys_calendars_b

245: DELETE bsc_sys_calendars_tl
246: WHERE calendar_id = p_Calendar_Record.Calendar_Id;
247: --dbms_output.put_line(' deleting from bsc_sys_calendars_b with calendar id as :- ' || p_Calendar_Record.Calendar_Id);
248:
249: DELETE bsc_sys_calendars_b
250: WHERE calendar_id = p_Calendar_Record.Calendar_Id;
251:
252: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN
253: COMMIT;

Line 288: UPDATE bsc_sys_calendars_b

284: SAVEPOINT DeleteCalendarSP;
285: FND_MSG_PUB.Initialize;
286: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
287:
288: UPDATE bsc_sys_calendars_b
289: SET fiscal_change = 1
290: WHERE calendar_id = p_Calendar_Id;
291:
292: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN