APPS.AHL_VWP_DEPT_SHIFTS_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 129

 SELECT ORGANIZATION_ID
 FROM HR_ALL_ORGANIZATION_UNITS
 WHERE NAME=C_NAME;

Line: 135

 SELECT  DEPARTMENT_ID
 FROM BOM_DEPARTMENTS_V
 WHERE ORGANIZATION_ID=C_ORG_ID
 AND DESCRIPTION=C_DESCRIPTION;

Line: 142

 SELECT CALENDAR_CODE
 FROM  BOM_CALENDARS
 WHERE DESCRIPTION=C_CALENDAR;

Line: 149

 SELECT SHIFT_NUM
 FROM BOM_SHIFT_TIMES
 WHERE CALENDAR_CODE=C_CALENDAR_CODE
 AND SHIFT_NUM=C_SHIFT_NUM;

Line: 156

 SELECT SEQ_NUM
 FROM BOM_WORKDAY_PATTERNS
 WHERE CALENDAR_CODE=C_CALENDAR_CODE
 AND SHIFT_NUM=C_SHIFT
 AND DESCRIPTION=C_DESCRIPTION;

Line: 371

                       SELECT   AHL_DEPARTMENT_SHIFTS_ID INTO l_prim_key
                        FROM AHL_DEPARTMENT_SHIFTS
                        WHERE AHL_DEPARTMENT_SHIFTS_ID=p_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;

Line: 376

                Select COUNT(DEPARTMENT_ID) INTO l_counter
                FROM AHL_DEPARTMENT_SHIFTS
                WHERE DEPARTMENT_ID=p_vwp_deptshift_rec.DEPARTMENT_ID;

Line: 528

        AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- before insert shift_num' || l_vwp_deptshift_rec.SHIFT_NUM);

Line: 532

                 Select  AHL_DEPARTMENT_SHIFTS_S.nextval into
                          l_department_shifts_id
                         from dual;

Line: 537

                 l_vwp_deptshift_rec.LAST_UPDATE_DATE:=sysdate;

Line: 538

                 l_vwp_deptshift_rec.LAST_UPDATED_BY:=fnd_global.user_id;

Line: 541

                 l_vwp_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;

Line: 544

                INSERT INTO AHL_DEPARTMENT_SHIFTS
                (
                 AHL_DEPARTMENT_SHIFTS_ID,
                 OBJECT_VERSION_NUMBER,
                 LAST_UPDATE_DATE,
                 LAST_UPDATED_BY,
                 CREATION_DATE,
                 CREATED_BY,
                 LAST_UPDATE_LOGIN,
                 DEPARTMENT_ID,
                 CALENDAR_CODE,
                 SHIFT_NUM,
                 SEQ_NUM,
                 ATTRIBUTE_CATEGORY,
                 ATTRIBUTE1,
                 ATTRIBUTE2,
                 ATTRIBUTE3,
                 ATTRIBUTE4,
                 ATTRIBUTE5,
                 ATTRIBUTE6,
                 ATTRIBUTE7,
                 ATTRIBUTE8,
                 ATTRIBUTE9,
                 ATTRIBUTE10,
                 ATTRIBUTE11,
                 ATTRIBUTE12,
                 ATTRIBUTE13,
                 ATTRIBUTE14,
                 ATTRIBUTE15
                )
                VALUES
                (
                 l_DEPARTMENT_SHIFTS_ID,
                 l_vwp_deptshift_rec.OBJECT_VERSION_NUMBER,
                 l_vwp_deptshift_rec.LAST_UPDATE_DATE,
                 l_vwp_deptshift_rec.LAST_UPDATED_BY,
                 l_vwp_deptshift_rec.CREATION_DATE,
                 l_vwp_deptshift_rec.CREATED_BY,
                 l_vwp_deptshift_rec.LAST_UPDATE_LOGIN,
                 l_vwp_deptshift_rec.DEPARTMENT_ID,
                 l_vwp_deptshift_rec.CALENDAR_CODE,
                 l_vwp_deptshift_rec.SHIFT_NUM,
                 l_vwp_deptshift_rec.SEQ_NUM,
                 l_vwp_deptshift_rec.ATTRIBUTE_CATEGORY,
                 l_vwp_deptshift_rec.ATTRIBUTE1,
                 l_vwp_deptshift_rec.ATTRIBUTE2,
                 l_vwp_deptshift_rec.ATTRIBUTE3,
                 l_vwp_deptshift_rec.ATTRIBUTE4,
                 l_vwp_deptshift_rec.ATTRIBUTE5,
                 l_vwp_deptshift_rec.ATTRIBUTE6,
                 l_vwp_deptshift_rec.ATTRIBUTE7,
                 l_vwp_deptshift_rec.ATTRIBUTE8,
                 l_vwp_deptshift_rec.ATTRIBUTE9,
                 l_vwp_deptshift_rec.ATTRIBUTE10,
                 l_vwp_deptshift_rec.ATTRIBUTE11,
                 l_vwp_deptshift_rec.ATTRIBUTE12,
                 l_vwp_deptshift_rec.ATTRIBUTE13,
                 l_vwp_deptshift_rec.ATTRIBUTE14,
                 l_vwp_deptshift_rec.ATTRIBUTE15);

Line: 640

PROCEDURE DELETE_VWP_DEPT_SHIFTS
 (
 p_api_version               IN         NUMBER:=  1.0,
 p_init_msg_list             IN         VARCHAR2,
 p_commit                    IN         VARCHAR2,
 p_validation_level          IN         NUMBER,
 p_default                   IN         VARCHAR2   := FND_API.G_FALSE,
 p_module_type               IN         VARCHAR2,
 x_return_status                OUT NOCOPY     VARCHAR2,
 x_msg_count                    OUT NOCOPY     NUMBER,
 x_msg_data                     OUT NOCOPY     VARCHAR2,
 p_x_vwp_deptshift_rec      IN OUT NOCOPY VWP_DEPTSHIFT_REC
 )
 AS
 l_vwp_deptshift_rec      VWP_DEPTSHIFT_REC:=p_x_vwp_deptshift_rec;

Line: 656

 l_api_name     CONSTANT VARCHAR2(30) := 'DELETE_VWP_DEPT_SHIFTS';

Line: 670

        SAVEPOINT DELETE_DEPT_SHIFTS;

Line: 704

                AHL_DEBUG_PUB.debug( 'AHL_VWP_DEPT_SHITS_PUB.','+delete_VWP_DEPT_SHIFTS+');

Line: 732

                DELETE AHL_DEPARTMENT_SHIFTS
                WHERE  AHL_DEPARTMENT_SHIFTS_ID=l_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID
                AND OBJECT_VERSION_NUMBER=l_vwp_deptshift_rec.OBJECT_VERSION_NUMBER;

Line: 751

    ROLLBACK TO DELETE_DEPT_SHIFTS;

Line: 757

    ROLLBACK TO DELETE_DEPT_SHIFTS;

Line: 764

    ROLLBACK TO DELETE_DEPT_SHIFTS;