APPS.BSC_SYS_CALENDARS_PKG dependencies on BSC_SYS_CALENDARS_B

Line 21: insert into BSC_SYS_CALENDARS_B (

17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: begin
21: insert into BSC_SYS_CALENDARS_B (
22: CALENDAR_ID,
23: EDW_FLAG,
24: FISCAL_YEAR,
25: FISCAL_CHANGE,

Line 119: from BSC_SYS_CALENDARS_B

115: RANGE_YR_MOD ,
116: CURRENT_YEAR ,
117: START_MONTH ,
118: START_DAY
119: from BSC_SYS_CALENDARS_B
120: where CALENDAR_ID = X_CALENDAR_ID
121: for update of CALENDAR_ID nowait;
122: recinfo c%rowtype;
123:

Line 191: update BSC_SYS_CALENDARS_B set

187: X_LAST_UPDATED_BY in NUMBER,
188: X_LAST_UPDATE_LOGIN in NUMBER
189: ) is
190: begin
191: update BSC_SYS_CALENDARS_B set
192: EDW_FLAG = X_EDW_FLAG,
193: FISCAL_YEAR = DECODE(LAST_UPDATED_BY,1,X_FISCAL_YEAR,FISCAL_YEAR),
194: FISCAL_CHANGE =DECODE(LAST_UPDATED_BY,1,X_FISCAL_CHANGE,FISCAL_CHANGE),
195: RANGE_YR_MOD =DECODE(LAST_UPDATED_BY,1,X_RANGE_YR_MOD,RANGE_YR_MOD),

Line 230: delete from BSC_SYS_CALENDARS_B

226: if (sql%notfound) then
227: raise no_data_found;
228: end if;
229:
230: delete from BSC_SYS_CALENDARS_B
231: where CALENDAR_ID = X_CALENDAR_ID;
232:
233: if (sql%notfound) then
234: raise no_data_found;

Line 244: from BSC_SYS_CALENDARS_B B

240: begin
241: delete from BSC_SYS_CALENDARS_TL T
242: where not exists
243: (select NULL
244: from BSC_SYS_CALENDARS_B B
245: where B.CALENDAR_ID = T.CALENDAR_ID
246: );
247:
248: update BSC_SYS_CALENDARS_TL T set (