DBA Data[Home] [Help]

APPS.BSC_UPDATE_INC dependencies on BSC_SYS_CALENDARS_B

Line 242: UPDATE bsc_sys_calendars_b

238: IF NOT BSC_UPDATE_LOCK.Lock_Calendar(h_calendar_id) THEN
239: RAISE e_could_not_get_lock;
240: END IF;
241:
242: UPDATE bsc_sys_calendars_b
243: SET fiscal_change = 0
244: WHERE calendar_id = h_calendar_id;
245:
246: --LOCKING: commit to release the locks

Line 430: FROM bsc_sys_calendars_b

426: TYPE t_cursor IS REF CURSOR;
427:
428: cursor c_calendars( pFiscalChg number) is
429: SELECT calendar_id
430: FROM bsc_sys_calendars_b
431: WHERE fiscal_change = pFiscalChg ;
432:
433: h_calendar NUMBER;
434: