APPS.AHL_APPR_DEPT_SHIFTS_PUB dependencies on AHL_DEPARTMENT_SHIFTS_S

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 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 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,