DBA Data[Home] [Help]

APPS.BOM_CALENDARS_PKG dependencies on BOM_CALENDAR_EXCEPTIONS

Line 49: from BOM_CALENDAR_EXCEPTIONS

45: shift_except_date DATE;
46: BEGIN
47:
48: select max(exception_date) into cal_except_date
49: from BOM_CALENDAR_EXCEPTIONS
50: where calendar_code = x_calendar_code;
51:
52: select max(exception_date) into shift_except_date
53: from BOM_SHIFT_EXCEPTIONS

Line 76: from BOM_CALENDAR_EXCEPTIONS

72: cal_except_date := NULL;
73: shift_except_date := NULL;
74:
75: select min(exception_date) into cal_except_date
76: from BOM_CALENDAR_EXCEPTIONS
77: where calendar_code = x_calendar_code;
78: select min(exception_date) into shift_except_date
79: from BOM_SHIFT_EXCEPTIONS
80: where calendar_code = x_calendar_code;

Line 109: (select 1 from BOM_CALENDAR_EXCEPTIONS

105: x_exception_date DATE) IS
106: dummy NUMBER;
107: BEGIN
108: select 1 into dummy from DUAL where not exists
109: (select 1 from BOM_CALENDAR_EXCEPTIONS
110: where calendar_code = x_calendar_code
111: and exception_date = x_exception_date
112: );
113: