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_APPR_DEPT_SHIFTS_PUB dependencies on AHL_DEPARTMENT_SHIFTS

Line 439: IF p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID IS NULL OR p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID=FND_API.G_MISS_NUM

435: FND_MESSAGE.SET_NAME('AHL','AHL_COM_OBJECT_VERS_NUM_NULL');
436: FND_MSG_PUB.ADD;
437: END IF;
438:
439: IF p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID IS NULL OR p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID=FND_API.G_MISS_NUM
440: THEN
441: FND_MESSAGE.SET_NAME('AHL','AHL_DEPARTMENT_SHIFTS_ID_NULL');
442: FND_MSG_PUB.ADD;
443: ELSE

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

437: END IF;
438:
439: IF p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID IS NULL OR p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID=FND_API.G_MISS_NUM
440: THEN
441: FND_MESSAGE.SET_NAME('AHL','AHL_DEPARTMENT_SHIFTS_ID_NULL');
442: FND_MSG_PUB.ADD;
443: ELSE
444: SELECT AHL_DEPARTMENT_SHIFTS_ID INTO l_prim_key
445: FROM AHL_DEPARTMENT_SHIFTS

Line 444: SELECT AHL_DEPARTMENT_SHIFTS_ID INTO l_prim_key

440: THEN
441: FND_MESSAGE.SET_NAME('AHL','AHL_DEPARTMENT_SHIFTS_ID_NULL');
442: FND_MSG_PUB.ADD;
443: ELSE
444: SELECT AHL_DEPARTMENT_SHIFTS_ID INTO l_prim_key
445: FROM AHL_DEPARTMENT_SHIFTS
446: WHERE AHL_DEPARTMENT_SHIFTS_ID=p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;
447: END IF;
448: ELSE

Line 445: FROM AHL_DEPARTMENT_SHIFTS

441: FND_MESSAGE.SET_NAME('AHL','AHL_DEPARTMENT_SHIFTS_ID_NULL');
442: FND_MSG_PUB.ADD;
443: ELSE
444: SELECT AHL_DEPARTMENT_SHIFTS_ID INTO l_prim_key
445: FROM AHL_DEPARTMENT_SHIFTS
446: WHERE AHL_DEPARTMENT_SHIFTS_ID=p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;
447: END IF;
448: ELSE
449: Select COUNT(DEPARTMENT_ID) INTO l_counter

Line 446: WHERE AHL_DEPARTMENT_SHIFTS_ID=p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;

442: FND_MSG_PUB.ADD;
443: ELSE
444: SELECT AHL_DEPARTMENT_SHIFTS_ID INTO l_prim_key
445: FROM AHL_DEPARTMENT_SHIFTS
446: WHERE AHL_DEPARTMENT_SHIFTS_ID=p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;
447: END IF;
448: ELSE
449: Select COUNT(DEPARTMENT_ID) INTO l_counter
450: FROM AHL_DEPARTMENT_SHIFTS

Line 450: FROM AHL_DEPARTMENT_SHIFTS

446: WHERE AHL_DEPARTMENT_SHIFTS_ID=p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;
447: END IF;
448: ELSE
449: Select COUNT(DEPARTMENT_ID) INTO l_counter
450: FROM AHL_DEPARTMENT_SHIFTS
451: WHERE DEPARTMENT_ID=p_appr_deptshift_rec.DEPARTMENT_ID;
452:
453: IF l_counter>0
454: THEN

Line 665: Select AHL_DEPARTMENT_SHIFTS_S.nextval into

661: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to insert into table.');
662: END IF;
663: IF l_appr_deptshift_rec.DML_OPERATION='C'
664: THEN
665: Select AHL_DEPARTMENT_SHIFTS_S.nextval into
666: l_department_shifts_id
667: from dual;
668:
669: l_appr_deptshift_rec.OBJECT_VERSION_NUMBER:=1;

Line 675: l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;

671: l_appr_deptshift_rec.LAST_UPDATED_BY:=fnd_global.user_id;
672: l_appr_deptshift_rec.CREATION_DATE:=sysdate;
673: l_appr_deptshift_rec.CREATED_BY:=fnd_global.user_id;
674: l_appr_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;
675: l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;
676:
677: INSERT INTO AHL_DEPARTMENT_SHIFTS
678: (
679: AHL_DEPARTMENT_SHIFTS_ID,

Line 677: INSERT INTO AHL_DEPARTMENT_SHIFTS

673: l_appr_deptshift_rec.CREATED_BY:=fnd_global.user_id;
674: l_appr_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;
675: l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;
676:
677: INSERT INTO AHL_DEPARTMENT_SHIFTS
678: (
679: AHL_DEPARTMENT_SHIFTS_ID,
680: OBJECT_VERSION_NUMBER,
681: LAST_UPDATE_DATE,

Line 679: AHL_DEPARTMENT_SHIFTS_ID,

675: l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;
676:
677: INSERT INTO AHL_DEPARTMENT_SHIFTS
678: (
679: AHL_DEPARTMENT_SHIFTS_ID,
680: OBJECT_VERSION_NUMBER,
681: LAST_UPDATE_DATE,
682: LAST_UPDATED_BY,
683: CREATION_DATE,

Line 869: DELETE AHL_DEPARTMENT_SHIFTS

865: -- DELETE GOES HERE
866:
867: IF l_appr_deptshift_rec.DML_OPERATION='D'
868: THEN
869: DELETE AHL_DEPARTMENT_SHIFTS
870: WHERE AHL_DEPARTMENT_SHIFTS_ID=l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID
871: AND OBJECT_VERSION_NUMBER=l_appr_deptshift_rec.OBJECT_VERSION_NUMBER;
872: IF (sql%ROWCOUNT=0)
873: THEN

Line 870: WHERE AHL_DEPARTMENT_SHIFTS_ID=l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID

866:
867: IF l_appr_deptshift_rec.DML_OPERATION='D'
868: THEN
869: DELETE AHL_DEPARTMENT_SHIFTS
870: WHERE AHL_DEPARTMENT_SHIFTS_ID=l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID
871: AND OBJECT_VERSION_NUMBER=l_appr_deptshift_rec.OBJECT_VERSION_NUMBER;
872: IF (sql%ROWCOUNT=0)
873: THEN
874: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');