APPS.AHL_LTP_RESRC_LEVL_PVT dependencies on BOM_CALENDARS

Line 3395: SELECT CALENDAR_START_DATE, CALENDAR_END_DATE FROM bom_calendars

3391: WHERE CALENDAR_CODE = p_calendar_code AND
3392: SHIFT_NUM = p_shift_num;
3393:
3394: CURSOR l_calendar_csr(p_calendar_code IN VARCHAR2) IS
3395: SELECT CALENDAR_START_DATE, CALENDAR_END_DATE FROM bom_calendars
3396: WHERE CALENDAR_CODE = p_calendar_code;
3397:
3398: CURSOR l_dept_name_csr (c_org_id IN NUMBER,
3399: c_dept_id IN NUMBER)

Line 3469: Ahl_Debug_Pub.debug('No BOM_CALENDARS entry for calendar code: ' || L_CALENDAR_CODE, 'LTP: Create_Time_Periods');

3465: Fnd_Message.Set_Name('AHL','AHL_LTP_CAL_CODE_INVALID');
3466: Fnd_Message.Set_Token('CAL_CODE', L_CALENDAR_CODE);
3467: Fnd_Msg_Pub.ADD;
3468: CLOSE l_calendar_csr;
3469: Ahl_Debug_Pub.debug('No BOM_CALENDARS entry for calendar code: ' || L_CALENDAR_CODE, 'LTP: Create_Time_Periods');
3470: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3471: END IF;
3472: CLOSE l_calendar_csr;
3473: -- Truncate the date values

Line 4067: SELECT CALENDAR_START_DATE, CALENDAR_END_DATE FROM bom_calendars

4063: WHERE CALENDAR_CODE = p_calendar_code AND
4064: SHIFT_NUM = p_shift_num;
4065:
4066: CURSOR l_calendar_csr(p_calendar_code IN VARCHAR2) IS
4067: SELECT CALENDAR_START_DATE, CALENDAR_END_DATE FROM bom_calendars
4068: WHERE CALENDAR_CODE = p_calendar_code;
4069:
4070: CURSOR l_exceptions_csr(p_calendar_code IN VARCHAR2) IS
4071: SELECT EXCEPTION_DATE FROM bom_calendar_exceptions

Line 4117: Ahl_Debug_Pub.debug('No BOM_CALENDARS entry for calendar code: ' || G_CALENDAR_CODE, 'LTP: Init_Time_Vars');

4113: Fnd_Message.Set_Name('AHL','AHL_LTP_CAL_CODE_INVALID');
4114: Fnd_Message.Set_Token('CAL_CODE', G_CALENDAR_CODE);
4115: Fnd_Msg_Pub.ADD;
4116: CLOSE l_calendar_csr;
4117: Ahl_Debug_Pub.debug('No BOM_CALENDARS entry for calendar code: ' || G_CALENDAR_CODE, 'LTP: Init_Time_Vars');
4118: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4119: END IF;
4120: CLOSE l_calendar_csr;
4121: -- Truncate the date values