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 464: 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

460: FND_MESSAGE.SET_NAME('AHL','AHL_COM_OBJECT_VERS_NUM_NULL');
461: FND_MSG_PUB.ADD;
462: END IF;
463:
464: 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
465: THEN
466: FND_MESSAGE.SET_NAME('AHL','AHL_DEPARTMENT_SHIFTS_ID_NULL');
467: FND_MSG_PUB.ADD;
468: ELSE

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

462: END IF;
463:
464: 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
465: THEN
466: FND_MESSAGE.SET_NAME('AHL','AHL_DEPARTMENT_SHIFTS_ID_NULL');
467: FND_MSG_PUB.ADD;
468: ELSE
469: SELECT AHL_DEPARTMENT_SHIFTS_ID INTO l_prim_key
470: FROM AHL_DEPARTMENT_SHIFTS

Line 469: SELECT AHL_DEPARTMENT_SHIFTS_ID INTO l_prim_key

465: THEN
466: FND_MESSAGE.SET_NAME('AHL','AHL_DEPARTMENT_SHIFTS_ID_NULL');
467: FND_MSG_PUB.ADD;
468: ELSE
469: SELECT AHL_DEPARTMENT_SHIFTS_ID INTO l_prim_key
470: FROM AHL_DEPARTMENT_SHIFTS
471: WHERE AHL_DEPARTMENT_SHIFTS_ID=p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;
472: END IF;
473: ELSIF p_appr_deptshift_rec.DML_OPERATION <> 'U'

Line 470: FROM AHL_DEPARTMENT_SHIFTS

466: FND_MESSAGE.SET_NAME('AHL','AHL_DEPARTMENT_SHIFTS_ID_NULL');
467: FND_MSG_PUB.ADD;
468: ELSE
469: SELECT AHL_DEPARTMENT_SHIFTS_ID INTO l_prim_key
470: FROM AHL_DEPARTMENT_SHIFTS
471: WHERE AHL_DEPARTMENT_SHIFTS_ID=p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;
472: END IF;
473: ELSIF p_appr_deptshift_rec.DML_OPERATION <> 'U'
474: THEN

Line 471: WHERE AHL_DEPARTMENT_SHIFTS_ID=p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;

467: FND_MSG_PUB.ADD;
468: ELSE
469: SELECT AHL_DEPARTMENT_SHIFTS_ID INTO l_prim_key
470: FROM AHL_DEPARTMENT_SHIFTS
471: WHERE AHL_DEPARTMENT_SHIFTS_ID=p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;
472: END IF;
473: ELSIF p_appr_deptshift_rec.DML_OPERATION <> 'U'
474: THEN
475: Select COUNT(DEPARTMENT_ID) INTO l_counter

Line 476: FROM AHL_DEPARTMENT_SHIFTS

472: END IF;
473: ELSIF p_appr_deptshift_rec.DML_OPERATION <> 'U'
474: THEN
475: Select COUNT(DEPARTMENT_ID) INTO l_counter
476: FROM AHL_DEPARTMENT_SHIFTS
477: WHERE DEPARTMENT_ID=p_appr_deptshift_rec.DEPARTMENT_ID;
478:
479: IF l_counter>0
480: THEN

Line 691: Select AHL_DEPARTMENT_SHIFTS_S.nextval into

687: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to insert into table.');
688: END IF;
689: IF l_appr_deptshift_rec.DML_OPERATION='C'
690: THEN
691: Select AHL_DEPARTMENT_SHIFTS_S.nextval into
692: l_department_shifts_id
693: from dual;
694:
695: l_appr_deptshift_rec.OBJECT_VERSION_NUMBER:=1;

Line 701: l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;

697: l_appr_deptshift_rec.LAST_UPDATED_BY:=fnd_global.user_id;
698: l_appr_deptshift_rec.CREATION_DATE:=sysdate;
699: l_appr_deptshift_rec.CREATED_BY:=fnd_global.user_id;
700: l_appr_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;
701: l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;
702:
703: INSERT INTO AHL_DEPARTMENT_SHIFTS
704: (
705: AHL_DEPARTMENT_SHIFTS_ID,

Line 703: INSERT INTO AHL_DEPARTMENT_SHIFTS

699: l_appr_deptshift_rec.CREATED_BY:=fnd_global.user_id;
700: l_appr_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;
701: l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;
702:
703: INSERT INTO AHL_DEPARTMENT_SHIFTS
704: (
705: AHL_DEPARTMENT_SHIFTS_ID,
706: OBJECT_VERSION_NUMBER,
707: LAST_UPDATE_DATE,

Line 705: AHL_DEPARTMENT_SHIFTS_ID,

701: l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;
702:
703: INSERT INTO AHL_DEPARTMENT_SHIFTS
704: (
705: AHL_DEPARTMENT_SHIFTS_ID,
706: OBJECT_VERSION_NUMBER,
707: LAST_UPDATE_DATE,
708: LAST_UPDATED_BY,
709: CREATION_DATE,

Line 772: returning l_DEPARTMENT_SHIFTS_ID into p_x_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;

768: l_appr_deptshift_rec.ATTRIBUTE12,
769: l_appr_deptshift_rec.ATTRIBUTE13,
770: l_appr_deptshift_rec.ATTRIBUTE14,
771: l_appr_deptshift_rec.ATTRIBUTE15)
772: returning l_DEPARTMENT_SHIFTS_ID into p_x_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;
773:
774: --p_x_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID := l_DEPARTMENT_SHIFTS_ID;
775:
776: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 774: --p_x_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID := l_DEPARTMENT_SHIFTS_ID;

770: l_appr_deptshift_rec.ATTRIBUTE14,
771: l_appr_deptshift_rec.ATTRIBUTE15)
772: returning l_DEPARTMENT_SHIFTS_ID into p_x_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;
773:
774: --p_x_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID := l_DEPARTMENT_SHIFTS_ID;
775:
776: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
777: THEN
778: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY,

Line 779: ' AHL_DEPARTMENT_SHIFTS_ID = ' || p_x_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID ||

775:
776: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
777: THEN
778: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY,
779: ' AHL_DEPARTMENT_SHIFTS_ID = ' || p_x_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID ||
780: ' OBJECT_VERSION_NUMBER = ' || p_x_appr_deptshift_rec.OBJECT_VERSION_NUMBER ||
781: ' DEPARTMENT_ID = ' || p_x_appr_deptshift_rec.DEPARTMENT_ID ||
782: ' CALENDAR_CODE = ' || p_x_appr_deptshift_rec.CALENDAR_CODE ||
783: ' SHIFT_NUM = ' || p_x_appr_deptshift_rec.SHIFT_NUM ||

Line 915: DELETE AHL_DEPARTMENT_SHIFTS

911: -- DELETE GOES HERE
912:
913: IF l_appr_deptshift_rec.DML_OPERATION='D'
914: THEN
915: DELETE AHL_DEPARTMENT_SHIFTS
916: WHERE AHL_DEPARTMENT_SHIFTS_ID=l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID
917: AND OBJECT_VERSION_NUMBER=l_appr_deptshift_rec.OBJECT_VERSION_NUMBER;
918: IF (sql%ROWCOUNT=0)
919: THEN

Line 916: WHERE AHL_DEPARTMENT_SHIFTS_ID=l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID

912:
913: IF l_appr_deptshift_rec.DML_OPERATION='D'
914: THEN
915: DELETE AHL_DEPARTMENT_SHIFTS
916: WHERE AHL_DEPARTMENT_SHIFTS_ID=l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID
917: AND OBJECT_VERSION_NUMBER=l_appr_deptshift_rec.OBJECT_VERSION_NUMBER;
918: IF (sql%ROWCOUNT=0)
919: THEN
920: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

Line 1082: /*Select AHL_DEPARTMENT_SHIFTS_S.nextval into

1078: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to insert into table.');
1079: END IF;
1080: IF l_appr_deptshift_rec.DML_OPERATION = 'U'
1081: THEN
1082: /*Select AHL_DEPARTMENT_SHIFTS_S.nextval into
1083: l_department_shifts_id
1084: from dual; */
1085:
1086: l_appr_deptshift_rec.LAST_UPDATE_DATE:=sysdate;

Line 1091: --l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;

1087: l_appr_deptshift_rec.LAST_UPDATED_BY:=fnd_global.user_id;
1088: l_appr_deptshift_rec.CREATION_DATE:=sysdate;
1089: l_appr_deptshift_rec.CREATED_BY:=fnd_global.user_id;
1090: l_appr_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;
1091: --l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;
1092:
1093: UPDATE AHL_DEPARTMENT_SHIFTS SET
1094: OBJECT_VERSION_NUMBER = l_appr_deptshift_rec.OBJECT_VERSION_NUMBER + 1,
1095: LAST_UPDATE_DATE = l_appr_deptshift_rec.LAST_UPDATE_DATE,

Line 1093: UPDATE AHL_DEPARTMENT_SHIFTS SET

1089: l_appr_deptshift_rec.CREATED_BY:=fnd_global.user_id;
1090: l_appr_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;
1091: --l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;
1092:
1093: UPDATE AHL_DEPARTMENT_SHIFTS SET
1094: OBJECT_VERSION_NUMBER = l_appr_deptshift_rec.OBJECT_VERSION_NUMBER + 1,
1095: LAST_UPDATE_DATE = l_appr_deptshift_rec.LAST_UPDATE_DATE,
1096: LAST_UPDATED_BY = l_appr_deptshift_rec.LAST_UPDATED_BY,
1097: CREATION_DATE = l_appr_deptshift_rec.CREATION_DATE,

Line 1125: AHL_DEPARTMENT_SHIFTS_ID = l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID

1121: ATTRIBUTE13 = l_appr_deptshift_rec.ATTRIBUTE13,
1122: ATTRIBUTE14 = l_appr_deptshift_rec.ATTRIBUTE14,
1123: ATTRIBUTE15 = l_appr_deptshift_rec.ATTRIBUTE15
1124: where
1125: AHL_DEPARTMENT_SHIFTS_ID = l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID
1126: and OBJECT_VERSION_NUMBER =l_appr_deptshift_rec.OBJECT_VERSION_NUMBER;
1127: END IF;
1128:
1129: -- If the record does not exist, then, abort API.