eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_DEPT_SHIFTS_PUB dependencies on AHL_DEPARTMENT_SHIFTS

Line 366: IF p_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID IS NULL OR p_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID=FND_API.G_MISS_NUM

362: FND_MESSAGE.SET_NAME('AHL','AHL_COM_OBJECT_VERS_NUM_NULL');
363: FND_MSG_PUB.ADD;
364: END IF;
365:
366: IF p_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID IS NULL OR p_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID=FND_API.G_MISS_NUM
367: THEN
368: FND_MESSAGE.SET_NAME('AHL','AHL_DEPARTMENT_SHIFTS_ID_NULL');
369: FND_MSG_PUB.ADD;
370: ELSE

Line 368: FND_MESSAGE.SET_NAME('AHL','AHL_DEPARTMENT_SHIFTS_ID_NULL');

364: END IF;
365:
366: IF p_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID IS NULL OR p_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID=FND_API.G_MISS_NUM
367: THEN
368: FND_MESSAGE.SET_NAME('AHL','AHL_DEPARTMENT_SHIFTS_ID_NULL');
369: FND_MSG_PUB.ADD;
370: ELSE
371: SELECT AHL_DEPARTMENT_SHIFTS_ID INTO l_prim_key
372: FROM AHL_DEPARTMENT_SHIFTS

Line 371: SELECT AHL_DEPARTMENT_SHIFTS_ID INTO l_prim_key

367: THEN
368: FND_MESSAGE.SET_NAME('AHL','AHL_DEPARTMENT_SHIFTS_ID_NULL');
369: FND_MSG_PUB.ADD;
370: ELSE
371: SELECT AHL_DEPARTMENT_SHIFTS_ID INTO l_prim_key
372: FROM AHL_DEPARTMENT_SHIFTS
373: WHERE AHL_DEPARTMENT_SHIFTS_ID=p_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;
374: END IF;
375: ELSE

Line 372: FROM AHL_DEPARTMENT_SHIFTS

368: FND_MESSAGE.SET_NAME('AHL','AHL_DEPARTMENT_SHIFTS_ID_NULL');
369: FND_MSG_PUB.ADD;
370: ELSE
371: SELECT AHL_DEPARTMENT_SHIFTS_ID INTO l_prim_key
372: FROM AHL_DEPARTMENT_SHIFTS
373: WHERE AHL_DEPARTMENT_SHIFTS_ID=p_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;
374: END IF;
375: ELSE
376: Select COUNT(DEPARTMENT_ID) INTO l_counter

Line 373: WHERE AHL_DEPARTMENT_SHIFTS_ID=p_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;

369: FND_MSG_PUB.ADD;
370: ELSE
371: SELECT AHL_DEPARTMENT_SHIFTS_ID INTO l_prim_key
372: FROM AHL_DEPARTMENT_SHIFTS
373: WHERE AHL_DEPARTMENT_SHIFTS_ID=p_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;
374: END IF;
375: ELSE
376: Select COUNT(DEPARTMENT_ID) INTO l_counter
377: FROM AHL_DEPARTMENT_SHIFTS

Line 377: FROM AHL_DEPARTMENT_SHIFTS

373: WHERE AHL_DEPARTMENT_SHIFTS_ID=p_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;
374: END IF;
375: ELSE
376: Select COUNT(DEPARTMENT_ID) INTO l_counter
377: FROM AHL_DEPARTMENT_SHIFTS
378: WHERE DEPARTMENT_ID=p_vwp_deptshift_rec.DEPARTMENT_ID;
379:
380: IF l_counter>0
381: THEN

Line 532: Select AHL_DEPARTMENT_SHIFTS_S.nextval into

528: AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- before insert shift_num' || l_vwp_deptshift_rec.SHIFT_NUM);
529: END IF;
530: IF l_vwp_deptshift_rec.DML_OPERATION='C'
531: THEN
532: Select AHL_DEPARTMENT_SHIFTS_S.nextval into
533: l_department_shifts_id
534: from dual;
535:
536: l_vwp_deptshift_rec.OBJECT_VERSION_NUMBER:=1;

Line 542: l_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;

538: l_vwp_deptshift_rec.LAST_UPDATED_BY:=fnd_global.user_id;
539: l_vwp_deptshift_rec.CREATION_DATE:=sysdate;
540: l_vwp_deptshift_rec.CREATED_BY:=fnd_global.user_id;
541: l_vwp_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;
542: l_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;
543:
544: INSERT INTO AHL_DEPARTMENT_SHIFTS
545: (
546: AHL_DEPARTMENT_SHIFTS_ID,

Line 544: INSERT INTO AHL_DEPARTMENT_SHIFTS

540: l_vwp_deptshift_rec.CREATED_BY:=fnd_global.user_id;
541: l_vwp_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;
542: l_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;
543:
544: INSERT INTO AHL_DEPARTMENT_SHIFTS
545: (
546: AHL_DEPARTMENT_SHIFTS_ID,
547: OBJECT_VERSION_NUMBER,
548: LAST_UPDATE_DATE,

Line 546: AHL_DEPARTMENT_SHIFTS_ID,

542: l_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;
543:
544: INSERT INTO AHL_DEPARTMENT_SHIFTS
545: (
546: AHL_DEPARTMENT_SHIFTS_ID,
547: OBJECT_VERSION_NUMBER,
548: LAST_UPDATE_DATE,
549: LAST_UPDATED_BY,
550: CREATION_DATE,

Line 732: DELETE AHL_DEPARTMENT_SHIFTS

728: -- DELETE GOES HERE
729:
730: IF l_vwp_deptshift_rec.DML_OPERATION='D'
731: THEN
732: DELETE AHL_DEPARTMENT_SHIFTS
733: WHERE AHL_DEPARTMENT_SHIFTS_ID=l_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID
734: AND OBJECT_VERSION_NUMBER=l_vwp_deptshift_rec.OBJECT_VERSION_NUMBER;
735: IF (sql%ROWCOUNT=0)
736: THEN

Line 733: WHERE AHL_DEPARTMENT_SHIFTS_ID=l_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID

729:
730: IF l_vwp_deptshift_rec.DML_OPERATION='D'
731: THEN
732: DELETE AHL_DEPARTMENT_SHIFTS
733: WHERE AHL_DEPARTMENT_SHIFTS_ID=l_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID
734: AND OBJECT_VERSION_NUMBER=l_vwp_deptshift_rec.OBJECT_VERSION_NUMBER;
735: IF (sql%ROWCOUNT=0)
736: THEN
737: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');