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 SQL Statements

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

Line: 162


 SELECT ORGANIZATION_ID
 FROM HR_ALL_ORGANIZATION_UNITS
 WHERE NAME=C_NAME;

Line: 168


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

Line: 175


 SELECT CALENDAR_CODE
 FROM  BOM_CALENDARS
 WHERE DESCRIPTION=C_CALENDAR;

Line: 182


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

Line: 189


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

Line: 198


 SELECT INVENTORY_LOCATION_ID
 FROM MTL_ITEM_LOCATIONS_KFV
 WHERE ORGANIZATION_ID = C_ORGANIZATION_ID
   AND SUBINVENTORY_CODE = C_SUBINVENTORY
   AND CONCATENATED_SEGMENTS = C_LOCATOR_SEGMENTS;

Line: 419


 SELECT status_id
   FROM MTL_SECONDARY_INVENTORIES
   WHERE organization_id = C_ORGANIZATION_ID
     AND secondary_inventory_name = C_SUBINVENTORY;

Line: 425


 SELECT 1
 FROM MTL_ITEM_LOCATIONS
 WHERE ORGANIZATION_ID = C_ORGANIZATION_ID
   AND SUBINVENTORY_CODE = C_SUBINVENTORY
   AND INVENTORY_LOCATION_ID = C_INVENTORY_LOCATION_ID
   AND SEGMENT19 IS NULL
   AND SEGMENT20 IS NULL;

Line: 469


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

Line: 475


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

Line: 687


    FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to insert into table.');

Line: 691


                 Select  AHL_DEPARTMENT_SHIFTS_S.nextval into
                          l_department_shifts_id
                         from dual;

Line: 696


                 l_appr_deptshift_rec.LAST_UPDATE_DATE:=sysdate;

Line: 697


                 l_appr_deptshift_rec.LAST_UPDATED_BY:=fnd_global.user_id;

Line: 700


                 l_appr_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;

Line: 703


                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,
-- Following two columns added by rbhavsar on Nov 27, 2007 for ER 5854712
                 SUBINVENTORY,
                 INV_LOCATOR_ID,
                 MAX_SERVICE_CATEGORY, --added by sansatpa
                 DESCRIPTION, --added by sansatpa
                 ATTRIBUTE_CATEGORY,
                 ATTRIBUTE1,
                 ATTRIBUTE2,
                 ATTRIBUTE3,
                 ATTRIBUTE4,
                 ATTRIBUTE5,
                 ATTRIBUTE6,
                 ATTRIBUTE7,
                 ATTRIBUTE8,
                 ATTRIBUTE9,
                 ATTRIBUTE10,
                 ATTRIBUTE11,
                 ATTRIBUTE12,
                 ATTRIBUTE13,
                 ATTRIBUTE14,
                 ATTRIBUTE15
                )
                VALUES
                (
                 l_DEPARTMENT_SHIFTS_ID,
                 l_appr_deptshift_rec.OBJECT_VERSION_NUMBER,
                 l_appr_deptshift_rec.LAST_UPDATE_DATE,
                 l_appr_deptshift_rec.LAST_UPDATED_BY,
                 l_appr_deptshift_rec.CREATION_DATE,
                 l_appr_deptshift_rec.CREATED_BY,
                 l_appr_deptshift_rec.LAST_UPDATE_LOGIN,
                 l_appr_deptshift_rec.DEPARTMENT_ID,
                 l_appr_deptshift_rec.CALENDAR_CODE,
                 l_appr_deptshift_rec.SHIFT_NUM,
                 l_appr_deptshift_rec.SEQ_NUM,
-- Following two columns added by rbhavsar on Nov 27, 2007 for ER 5854712
                 l_appr_deptshift_rec.SUBINVENTORY,
                 l_appr_deptshift_rec.INV_LOCATOR_ID,
                 l_appr_deptshift_rec.MAX_SERVICE_CATEGORY, --added by sansatpa
                 l_appr_deptshift_rec.DESCRIPTION, --added by sansatpa
                 l_appr_deptshift_rec.ATTRIBUTE_CATEGORY,
                 l_appr_deptshift_rec.ATTRIBUTE1,
                 l_appr_deptshift_rec.ATTRIBUTE2,
                 l_appr_deptshift_rec.ATTRIBUTE3,
                 l_appr_deptshift_rec.ATTRIBUTE4,
                 l_appr_deptshift_rec.ATTRIBUTE5,
                 l_appr_deptshift_rec.ATTRIBUTE6,
                 l_appr_deptshift_rec.ATTRIBUTE7,
                 l_appr_deptshift_rec.ATTRIBUTE8,
                 l_appr_deptshift_rec.ATTRIBUTE9,
                 l_appr_deptshift_rec.ATTRIBUTE10,
                 l_appr_deptshift_rec.ATTRIBUTE11,
                 l_appr_deptshift_rec.ATTRIBUTE12,
                 l_appr_deptshift_rec.ATTRIBUTE13,
                 l_appr_deptshift_rec.ATTRIBUTE14,
                 l_appr_deptshift_rec.ATTRIBUTE15)
                 returning l_DEPARTMENT_SHIFTS_ID into p_x_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;

Line: 825


PROCEDURE DELETE_APPR_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_appr_deptshift_rec      IN OUT NOCOPY APPR_DEPTSHIFT_REC
 )
 AS
 l_appr_deptshift_rec      APPR_DEPTSHIFT_REC:=p_x_appr_deptshift_rec;

Line: 841


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

Line: 853


 L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.DELETE_APPR_DEPT_SHIFTS';

Line: 860


        SAVEPOINT DELETE_DEPT_SHIFTS;

Line: 915


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

Line: 934


    ROLLBACK TO DELETE_DEPT_SHIFTS;

Line: 940


    ROLLBACK TO DELETE_DEPT_SHIFTS;

Line: 947


    ROLLBACK TO DELETE_DEPT_SHIFTS;

Line: 1078


    FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to insert into table.');

Line: 1082


                 /*Select  AHL_DEPARTMENT_SHIFTS_S.nextval into
                          l_department_shifts_id
                         from dual; */

Line: 1086


                l_appr_deptshift_rec.LAST_UPDATE_DATE:=sysdate;

Line: 1087


                l_appr_deptshift_rec.LAST_UPDATED_BY:=fnd_global.user_id;

Line: 1090


                l_appr_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;

Line: 1093


                UPDATE AHL_DEPARTMENT_SHIFTS SET
                OBJECT_VERSION_NUMBER =    l_appr_deptshift_rec.OBJECT_VERSION_NUMBER + 1,
                LAST_UPDATE_DATE =         l_appr_deptshift_rec.LAST_UPDATE_DATE,
                LAST_UPDATED_BY =          l_appr_deptshift_rec.LAST_UPDATED_BY,
                CREATION_DATE =            l_appr_deptshift_rec.CREATION_DATE,
                CREATED_BY =               l_appr_deptshift_rec.CREATED_BY,
                LAST_UPDATE_LOGIN =        l_appr_deptshift_rec.LAST_UPDATE_LOGIN,
                DEPARTMENT_ID =            l_appr_deptshift_rec.DEPARTMENT_ID,
                CALENDAR_CODE =            l_appr_deptshift_rec.CALENDAR_CODE,
                SHIFT_NUM =                l_appr_deptshift_rec.SHIFT_NUM,
                SEQ_NUM =                  l_appr_deptshift_rec.SEQ_NUM,
                SUBINVENTORY =             l_appr_deptshift_rec.SUBINVENTORY,
                INV_LOCATOR_ID =           l_appr_deptshift_rec.INV_LOCATOR_ID,
                MAX_SERVICE_CATEGORY =     l_appr_deptshift_rec.MAX_SERVICE_CATEGORY,
                DESCRIPTION =              l_appr_deptshift_rec.DESCRIPTION,
                ATTRIBUTE_CATEGORY =       l_appr_deptshift_rec.ATTRIBUTE_CATEGORY,
                ATTRIBUTE1 =               l_appr_deptshift_rec.ATTRIBUTE1,
                ATTRIBUTE2 =               l_appr_deptshift_rec.ATTRIBUTE2,
                ATTRIBUTE3 =               l_appr_deptshift_rec.ATTRIBUTE3,
                ATTRIBUTE4 =               l_appr_deptshift_rec.ATTRIBUTE4,
                ATTRIBUTE5 =               l_appr_deptshift_rec.ATTRIBUTE5,
                ATTRIBUTE6 =               l_appr_deptshift_rec.ATTRIBUTE6,
                ATTRIBUTE7 =               l_appr_deptshift_rec.ATTRIBUTE7,
                ATTRIBUTE8 =               l_appr_deptshift_rec.ATTRIBUTE8,
                ATTRIBUTE9 =               l_appr_deptshift_rec.ATTRIBUTE9,
                ATTRIBUTE10 =              l_appr_deptshift_rec.ATTRIBUTE10,
                ATTRIBUTE11 =              l_appr_deptshift_rec.ATTRIBUTE11,
                ATTRIBUTE12 =              l_appr_deptshift_rec.ATTRIBUTE12,
                ATTRIBUTE13 =              l_appr_deptshift_rec.ATTRIBUTE13,
                ATTRIBUTE14 =              l_appr_deptshift_rec.ATTRIBUTE14,
                ATTRIBUTE15 =              l_appr_deptshift_rec.ATTRIBUTE15
                where
                AHL_DEPARTMENT_SHIFTS_ID = l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID
                and OBJECT_VERSION_NUMBER =l_appr_deptshift_rec.OBJECT_VERSION_NUMBER;