APPS.AHL_UA_FLIGHT_SCHEDULES_PVT SQL Statements

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

Line: 52

SELECT *
FROM AHL_VISITS_B
WHERE unit_schedule_id = p_unit_schedule_id
AND STATUS_CODE NOT IN ('DELETED', 'CANCELLED' , 'CLOSED');

Line: 112

SELECT 'X'
FROM AHL_UNIT_SCHEDULES
WHERE unit_schedule_id = p_unit_schedule_id
AND object_version_number = p_object_version_number;

Line: 309

SELECT unit_config_header_id
FROM AHL_UNIT_CONFIG_HEADERS
WHERE name = p_uc_name
--priyan Bug # 5303188
-- AND ahl_util_uc_pkg.get_uc_status_code (unit_config_header_id) IN ('COMPLETE', 'INCOMPLETE');

Line: 323

SELECT mtlp.organization_id
FROM MTL_PARAMETERS mtlp
WHERE mtlp.eam_enabled_flag = 'Y'
AND mtlp.organization_code = p_org_code;

Line: 331

SELECT DEPARTMENT_ID
FROM BOM_DEPARTMENTS BD
WHERE BD.DEPARTMENT_CODE = p_dept_code AND
      BD.ORGANIZATION_ID = p_org_id;

Line: 338

 * (query is similar to space LOV in Update Visit UI - VisitSpacesLovVO.xml)
 */
CURSOR space_name_to_id_csr (c_org_id     NUMBER,
                             c_dept_id    NUMBER,
                             c_space_name VARCHAR2) IS
SELECT distinct space_id
FROM   AHL_SPACE_CAPBLTS_V
WHERE  status_code       = 'Y'
AND    organization_id   = c_org_id
AND    bom_department_id = c_dept_id
AND    space_name        = c_space_name;

Line: 650

SELECT *
FROM AHL_UNIT_SCHEDULES
WHERE unit_schedule_id = p_unit_shcedule_id;

Line: 1069

PROCEDURE validate_update(
  p_x_flight_schedule_rec   IN OUT NOCOPY   FLIGHT_SCHEDULE_REC_TYPE,
  x_return_status       OUT NOCOPY      VARCHAR2
)
IS
-- Cursor for getting a Unit Schedule record.
CURSOR get_current_us_csr(p_unit_shcedule_id IN NUMBER) IS
SELECT *
FROM AHL_UNIT_SCHEDULES
WHERE unit_schedule_id = p_unit_shcedule_id;

Line: 1081

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

Line: 1083

l_update_allowed VARCHAR2(1);

Line: 1101

      l_update_allowed := is_update_allowed(
                        p_x_flight_schedule_rec.unit_schedule_id,
                        is_super_user
                          );

Line: 1139

        FND_MESSAGE.set_name( 'AHL','AHL_UA_UNIT_NO_UPDATE' );

Line: 1147

            'Unit config header id cannot be updated for '
            ||p_x_flight_schedule_rec.unit_schedule_id
              );

Line: 1160

        FND_MESSAGE.set_name( 'AHL','AHL_UA_FLIGHT_NO_UPDATE' );

Line: 1168

            'Flight Number cannot be updated for '
            ||p_x_flight_schedule_rec.unit_schedule_id
              );

Line: 1179

        FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NO_UPDATE' );

Line: 1187

            'Flight Segment cannot be updated for '
            ||p_x_flight_schedule_rec.unit_schedule_id
              );

Line: 1199

        l_update_allowed = FND_API.G_FALSE
      THEN
        FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DEP_DEPT_NO_UPDATE' );

Line: 1209

            'Departure deparment cannot be updated for '
            ||p_x_flight_schedule_rec.unit_schedule_id
          );

Line: 1219

        l_update_allowed = FND_API.G_FALSE
      THEN
        FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DEP_ORG_NO_UPDATE' );

Line: 1229

            'Departure org cannot be updated for '
            ||p_x_flight_schedule_rec.unit_schedule_id
          );

Line: 1239

        l_update_allowed = FND_API.G_FALSE
      THEN
        FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_DEP_NO_UPDATE' );

Line: 1249

            'Arrival Department cannot be updated for'
            ||p_x_flight_schedule_rec.unit_schedule_id
          );

Line: 1259

        l_update_allowed = FND_API.G_FALSE
      THEN
        FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_ORG_NO_UPDATE' );

Line: 1269

            'Arrival org cannot be updated for '
            ||p_x_flight_schedule_rec.unit_schedule_id
          );

Line: 1279

        l_update_allowed = FND_API.G_FALSE
      THEN
        FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_DEP_NO_UPDATE' );

Line: 1289

            'Estimated Departure time cannot be updated for '
            ||p_x_flight_schedule_rec.unit_schedule_id
          );

Line: 1299

        l_update_allowed = FND_API.G_FALSE
      THEN
        FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_ARR_NO_UPDATE' );

Line: 1309

            'Estimated Arrival time cannot be updated for '
            ||p_x_flight_schedule_rec.unit_schedule_id
          );

Line: 1325

END validate_update;

Line: 1339

/*SELECT unit_schedule_id, actual_departure_time, actual_arrival_time
FROM AHL_UNIT_SCHEDULES_V
WHERE unit_schedule_id = (
             SELECT preceding_us_id
             FROM AHL_UNIT_SCHEDULES_V
             WHERE unit_schedule_id = p_unit_schedule_id
            );*/

Line: 1348

SELECT
     UNIT_SCHEDULE_ID,
     ACTUAL_DEPARTURE_TIME,
     ACTUAL_ARRIVAL_TIME
FROM
     AHL_UNIT_SCHEDULES
WHERE
     UNIT_SCHEDULE_ID = (
         SELECT PRECEDING_US_ID
         FROM AHL_UNIT_SCHEDULES
         WHERE UNIT_SCHEDULE_ID = p_unit_schedule_id
                         );

Line: 1365

SELECT unit_schedule_id, actual_departure_time, actual_arrival_time
FROM AHL_UNIT_SCHEDULES
WHERE unit_config_header_id = p_uc_header_id AND
Est_arrival_time < p_est_arrival_date;

Line: 1371

SELECT actual_departure_time, actual_arrival_time
FROM AHL_UNIT_SCHEDULES
WHERE unit_schedule_id = p_unit_schedule_id;

Line: 1380

SELECT unit_config_header_id,
       EST_DEPARTURE_TIME,
       EST_ARRIVAL_TIME,
       ACTUAL_DEPARTURE_TIME,
       ACTUAL_ARRIVAL_TIME
FROM AHL_UNIT_SCHEDULES
WHERE unit_schedule_id = p_unit_schedule_id;

Line: 1390

 * (query is similar to space LOV in Update Visit UI - VisitSpacesLovVO.xml)
 */
CURSOR validate_space_id_csr (c_space_id NUMBER,
                              c_org_id   NUMBER,
                              c_dept_id  NUMBER) IS
SELECT 'X'
FROM   AHL_SPACE_CAPBLTS_V
WHERE  space_id          = c_space_id
AND    status_code       = 'Y'
AND    organization_id   = c_org_id
AND    bom_department_id = c_dept_id;

Line: 1442

           AND is_delete_allowed(p_unit_schedule_id => p_x_flight_schedule_rec.unit_schedule_id,
                     p_is_super_user => is_super_user
                       ) = FND_API.G_FALSE
        THEN
            FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ACT_NO_DEL' );

Line: 1455

                ||'so delete not allowed'
               );

Line: 1463

        SELECT count(unit_schedule_id) INTO l_us_dup_count
        FROM AHL_UNIT_SCHEDULES
        WHERE UNIT_CONFIG_HEADER_ID = p_x_flight_schedule_rec.UNIT_CONFIG_HEADER_ID
              AND FLIGHT_NUMBER = p_x_flight_schedule_rec.FLIGHT_NUMBER
              AND SEGMENT = p_x_flight_schedule_rec.SEGMENT
              AND EST_ARRIVAL_TIME = p_x_flight_schedule_rec.EST_ARRIVAL_TIME
              AND EST_DEPARTURE_TIME = p_x_flight_schedule_rec.EST_DEPARTURE_TIME
              AND unit_schedule_id <> nvl(p_x_flight_schedule_rec.unit_schedule_id,-100);

Line: 1645

        SELECT count(unit_schedule_id) into l_est_violation_count
        FROM AHL_UNIT_SCHEDULES
        WHERE est_arrival_time > p_x_flight_schedule_rec.EST_ARRIVAL_TIME AND
              unit_config_header_id = p_x_flight_schedule_rec.unit_config_header_id
              AND (
                   actual_departure_time is not null OR actual_arrival_time is not null
                  )
              AND unit_schedule_id <> nvl(p_x_flight_schedule_rec.unit_schedule_id,-110);

Line: 1753

    SELECT unit_schedule_id,
           est_departure_time,
           est_arrival_time,
           preceding_us_id
    FROM   AHL_UNIT_SCHEDULES
    WHERE  unit_schedule_id = c_unit_schedule_id;

Line: 1762

    SELECT visit_id,
           start_date_time,
           close_date_time
    FROM   AHL_VISITS_B
    WHERE  unit_schedule_id = c_unit_schedule_id
    -- SATRAJEN :: Bug 14347661 :: To retrieve only Active Visits and Downtime Visits(Operational Visits):: 26-07-2012
    AND    status_code NOT IN ('DELETED', 'CANCELLED', 'CLOSED')
    -- To support old flight schedules, assumpting NULL Visit as Downtime Visit to process further.
    AND    NVL(auto_visit_type_flag,'T') = 'T';

Line: 1776

    SELECT unit_schedule_id,
           est_departure_time,
           est_arrival_time
    FROM   AHL_UNIT_SCHEDULES
    WHERE  preceding_us_id = c_unit_schedule_id;

Line: 1784

    SELECT 'Y'
    FROM   AHL_VISIT_TASKS_B
    WHERE  visit_id       = c_visit_id
    AND    task_type_code = 'PLANNED'
    AND    status_code    NOT IN ('DELETED', 'CANCELLED', 'CLOSED');

Line: 1936

SELECT  unit_schedule_id, nvl(actual_arrival_time, est_arrival_time) "ARRIVAL_TIME"
FROM AHL_UNIT_SCHEDULES
WHERE unit_config_header_id = p_unit_config_header_id
ORDER BY nvl(actual_arrival_time, est_arrival_time) DESC;

Line: 1944

SELECT  unit_schedule_id, est_arrival_time "ARRIVAL_TIME"
FROM AHL_UNIT_SCHEDULES
WHERE unit_config_header_id = p_unit_config_header_id
ORDER BY est_arrival_time DESC;

Line: 2015

        UPDATE AHL_UNIT_SCHEDULES
        SET preceding_us_id = l_pre_us_tbl(j).preceding_us_id
        WHERE unit_schedule_id = l_pre_us_tbl(j).unit_schedule_id;

Line: 2114

        ELSIF ( p_visit_sync_rec.VISIT_RESCHEDULE_MODE = 'DELETE')

        THEN
            -- Bug # 9075539 -- start
            -- delete all associations of the flight schedule to its own transit visits
            AHL_VWP_VISITS_PVT.DELETE_FLIGHT_ASSOC(
             p_visit_sync_rec.UNIT_SCHEDULE_ID,
             x_return_status
            );

Line: 2156

		x_return_status := 'V';-- status assigned to force flight schedule updates

Line: 2168

		 x_return_status := 'V';-- status assigned to force flight schedule updates

Line: 2175

		   	'Visit could not be deleted or cancelled...Please refer error stack for more details..'
		   );

Line: 2403

            INSERT INTO AHL_UNIT_SCHEDULES
            (
                UNIT_SCHEDULE_ID,
                FLIGHT_NUMBER,
                SEGMENT,
                DEPARTURE_DEPT_ID,
                DEPARTURE_ORG_ID,
                ARRIVAL_DEPT_ID,
                ARRIVAL_ORG_ID,
                EST_DEPARTURE_TIME,
                EST_ARRIVAL_TIME,
                ACTUAL_DEPARTURE_TIME,
                ACTUAL_ARRIVAL_TIME,
                PRECEDING_US_ID,
                UNIT_CONFIG_HEADER_ID,
                VISIT_RESCHEDULE_MODE,
                -- MANESING::Auto Visit Forecasting, 17-Oct-2011,
                -- added autovisit process status, flight category code and spaces
                AUTOVISIT_PROCESS_STATUS,
                FLIGHT_CATEGORY_CODE,
                DEPARTURE_SPACE_ID,
                ARRIVAL_SPACE_ID,
                LAST_UPDATE_DATE,
                LAST_UPDATED_BY,
                CREATION_DATE,
                CREATED_BY,
                LAST_UPDATE_LOGIN,
                OBJECT_VERSION_NUMBER,
                ATTRIBUTE_CATEGORY,
                ATTRIBUTE1,
                ATTRIBUTE2,
                ATTRIBUTE3,
                ATTRIBUTE4,
                ATTRIBUTE5,
                ATTRIBUTE6,
                ATTRIBUTE7,
                ATTRIBUTE8,
                ATTRIBUTE9,
                ATTRIBUTE10,
                ATTRIBUTE11,
                ATTRIBUTE12,
                ATTRIBUTE13,
                ATTRIBUTE14,
                ATTRIBUTE15
            ) VALUES
            (
                AHL_UNIT_SCHEDULES_S.NEXTVAL,
                p_x_flight_schedules_tbl(i).FLIGHT_NUMBER,
                p_x_flight_schedules_tbl(i).SEGMENT,
                p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_ID,
                p_x_flight_schedules_tbl(i).DEPARTURE_ORG_ID,
                p_x_flight_schedules_tbl(i).ARRIVAL_DEPT_ID,
                p_x_flight_schedules_tbl(i).ARRIVAL_ORG_ID,
                p_x_flight_schedules_tbl(i).EST_DEPARTURE_TIME,
                p_x_flight_schedules_tbl(i).EST_ARRIVAL_TIME,
                p_x_flight_schedules_tbl(i).ACTUAL_DEPARTURE_TIME,
                p_x_flight_schedules_tbl(i).ACTUAL_ARRIVAL_TIME,
                p_x_flight_schedules_tbl(i).PRECEDING_US_ID,
                p_x_flight_schedules_tbl(i).UNIT_CONFIG_HEADER_ID,
                p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MODE,
                -- MANESING::Auto Visit Forecasting, 17-Oct-2011,
                -- added autovisit process status, flight category code and spaces
                l_autovisit_process_status,
                p_x_flight_schedules_tbl(i).FLIGHT_CATEGORY_CODE,
                p_x_flight_schedules_tbl(i).DEPARTURE_SPACE_ID,
                p_x_flight_schedules_tbl(i).ARRIVAL_SPACE_ID,
                G_SYSDATE,
                G_USER_ID,
                G_SYSDATE,
                G_USER_ID,
                G_LOGIN_ID,
                1,
                p_x_flight_schedules_tbl(i).ATTRIBUTE_CATEGORY,
                p_x_flight_schedules_tbl(i).ATTRIBUTE1,
                p_x_flight_schedules_tbl(i).ATTRIBUTE2,
                p_x_flight_schedules_tbl(i).ATTRIBUTE3,
                p_x_flight_schedules_tbl(i).ATTRIBUTE4,
                p_x_flight_schedules_tbl(i).ATTRIBUTE5,
                p_x_flight_schedules_tbl(i).ATTRIBUTE6,
                p_x_flight_schedules_tbl(i).ATTRIBUTE7,
                p_x_flight_schedules_tbl(i).ATTRIBUTE8,
                p_x_flight_schedules_tbl(i).ATTRIBUTE9,
                p_x_flight_schedules_tbl(i).ATTRIBUTE10,
                p_x_flight_schedules_tbl(i).ATTRIBUTE11,
                p_x_flight_schedules_tbl(i).ATTRIBUTE12,
                p_x_flight_schedules_tbl(i).ATTRIBUTE13,
                p_x_flight_schedules_tbl(i).ATTRIBUTE14,
                p_x_flight_schedules_tbl(i).ATTRIBUTE15
            );

Line: 2492

            SELECT AHL_UNIT_SCHEDULES_S.CURRVAL INTO p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID FROM DUAL ;

Line: 2499

            SELECT count(unit_schedule_id) INTO l_overlap_us_count
            FROM AHL_UNIT_SCHEDULES
            WHERE unit_config_header_id = p_x_flight_schedules_tbl(i).unit_config_header_id
            AND (
                  (
                (p_x_flight_schedules_tbl(i).actual_departure_time between ACTUAL_DEPARTURE_TIME and ACTUAL_ARRIVAL_TIME)
                AND
                ( p_x_flight_schedules_tbl(i).actual_arrival_time between ACTUAL_DEPARTURE_TIME and ACTUAL_ARRIVAL_TIME)
                  )
                  OR (ACTUAL_DEPARTURE_TIME between p_x_flight_schedules_tbl(i).actual_departure_time and p_x_flight_schedules_tbl(i).actual_arrival_time)
                  OR (ACTUAL_ARRIVAL_TIME between p_x_flight_schedules_tbl(i).actual_departure_time and p_x_flight_schedules_tbl(i).actual_arrival_time)
                )
            AND unit_schedule_id <> p_x_flight_schedules_tbl(i).unit_schedule_id;

Line: 2514

            SELECT count(unit_schedule_id) INTO l_overlap_us_count
            FROM AHL_UNIT_SCHEDULES
            WHERE unit_config_header_id = p_x_flight_schedules_tbl(i).unit_config_header_id
            /*AND (
                  (
                   (p_x_flight_schedules_tbl(i).est_departure_time  between EST_DEPARTURE_TIME and EST_ARRIVAL_TIME)
                   AND
                   ( p_x_flight_schedules_tbl(i).est_arrival_time between EST_DEPARTURE_TIME and EST_ARRIVAL_TIME)
                  )
                  OR (EST_DEPARTURE_TIME between p_x_flight_schedules_tbl(i).est_departure_time  and p_x_flight_schedules_tbl(i).est_arrival_time)
                  OR (EST_ARRIVAL_TIME between p_x_flight_schedules_tbl(i).est_departure_time  and p_x_flight_schedules_tbl(i).est_arrival_time)
                )*/
            AND (
                  (
                   ((p_x_flight_schedules_tbl(i).est_departure_time>EST_DEPARTURE_TIME  AND p_x_flight_schedules_tbl(i).est_departure_timeEST_DEPARTURE_TIME and p_x_flight_schedules_tbl(i).est_arrival_timep_x_flight_schedules_tbl(i).est_departure_time  and EST_DEPARTURE_TIMEp_x_flight_schedules_tbl(i).est_departure_time  and EST_ARRIVAL_TIME p_x_flight_schedules_tbl(i).unit_schedule_id;

Line: 2560

PROCEDURE Update_Flight_Schedules(
 p_module_type               IN             VARCHAR2,
 x_return_status             OUT NOCOPY         VARCHAR2,
 p_x_flight_schedules_tbl    IN OUT NOCOPY      FLIGHT_SCHEDULES_TBL_TYPE
)
IS

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

Line: 2577

SELECT departure_org_id,
       departure_dept_id,
       arrival_org_id,
       arrival_dept_id,
       est_departure_time,
       est_arrival_time,
       autovisit_process_status
FROM AHL_UNIT_SCHEDULES
WHERE unit_schedule_id = p_unit_schedule_id;

Line: 2677

                    'default_unchanged_attributes for update operation. Module type is '||p_module_type
                 );

Line: 2736

            validate_update
            (
              p_x_flight_schedules_tbl(i),
              x_return_status
            );

Line: 2749

                        'validate_update returned with expected error..'
                    );

Line: 2759

                        'validate_update returned with un-expected error..'
                    );

Line: 2845

             * When a Flight Schedule record is Updated,
             * 1. If autovisit process status is Reviewed, then it's set to Updated.
             *    This signifies that a Visit corresponding to this Flight record needs to be Updated as well.
             * 2. If autovisit process status is Created, then it remains as it is.
             *    This signifies that a Visit corresponding to this Flight record is yet to be Created.
             */
            IF ((l_old_flight_rec.departure_org_id   <> p_x_flight_schedules_tbl(i).departure_org_id   OR
                 l_old_flight_rec.departure_dept_id  <> p_x_flight_schedules_tbl(i).departure_dept_id  OR
                 l_old_flight_rec.arrival_org_id     <> p_x_flight_schedules_tbl(i).arrival_org_id     OR
                 l_old_flight_rec.arrival_dept_id    <> p_x_flight_schedules_tbl(i).arrival_dept_id    OR
                 l_old_flight_rec.est_departure_time <> p_x_flight_schedules_tbl(i).est_departure_time OR
                 l_old_flight_rec.est_arrival_time   <> p_x_flight_schedules_tbl(i).est_arrival_time)  AND
                l_old_flight_rec.autovisit_process_status = 'R') THEN
                l_autovisit_process_status := 'U';

Line: 2864

            UPDATE AHL_UNIT_SCHEDULES SET
                UNIT_SCHEDULE_ID    =   p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID,
                FLIGHT_NUMBER       =   p_x_flight_schedules_tbl(i).FLIGHT_NUMBER,
                SEGMENT         =   p_x_flight_schedules_tbl(i).SEGMENT,
                DEPARTURE_DEPT_ID   =   p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_ID,
                DEPARTURE_ORG_ID    =   p_x_flight_schedules_tbl(i).DEPARTURE_ORG_ID,
                ARRIVAL_DEPT_ID     =   p_x_flight_schedules_tbl(i).ARRIVAL_DEPT_ID,
                ARRIVAL_ORG_ID      =   p_x_flight_schedules_tbl(i).ARRIVAL_ORG_ID,
                EST_DEPARTURE_TIME  =   p_x_flight_schedules_tbl(i).EST_DEPARTURE_TIME,
                EST_ARRIVAL_TIME    =   p_x_flight_schedules_tbl(i).EST_ARRIVAL_TIME,
                ACTUAL_DEPARTURE_TIME   =   p_x_flight_schedules_tbl(i).ACTUAL_DEPARTURE_TIME,
                ACTUAL_ARRIVAL_TIME =   p_x_flight_schedules_tbl(i).ACTUAL_ARRIVAL_TIME,
                PRECEDING_US_ID     =   p_x_flight_schedules_tbl(i).PRECEDING_US_ID,
                UNIT_CONFIG_HEADER_ID   =   p_x_flight_schedules_tbl(i).UNIT_CONFIG_HEADER_ID,
                VISIT_RESCHEDULE_MODE   =   p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MODE,
                -- MANESING::Auto Visit Forecasting, 17-Oct-2011,
                -- added autovisit process status, flight category code and spaces
                AUTOVISIT_PROCESS_STATUS = l_autovisit_process_status,
                FLIGHT_CATEGORY_CODE     = p_x_flight_schedules_tbl(i).FLIGHT_CATEGORY_CODE,
                DEPARTURE_SPACE_ID       = p_x_flight_schedules_tbl(i).DEPARTURE_SPACE_ID,
                ARRIVAL_SPACE_ID         = p_x_flight_schedules_tbl(i).ARRIVAL_SPACE_ID,
                LAST_UPDATE_DATE    =   G_SYSDATE,
                LAST_UPDATED_BY     =   G_USER_ID,
                CREATION_DATE       =   G_SYSDATE,
                CREATED_BY      =   G_USER_ID,
                LAST_UPDATE_LOGIN   =   G_LOGIN_ID,
                OBJECT_VERSION_NUMBER   =   p_x_flight_schedules_tbl(i).OBJECT_VERSION_NUMBER + 1,
                ATTRIBUTE_CATEGORY  =   p_x_flight_schedules_tbl(i).ATTRIBUTE_CATEGORY,
                ATTRIBUTE1      =   p_x_flight_schedules_tbl(i).ATTRIBUTE1,
                ATTRIBUTE2      =   p_x_flight_schedules_tbl(i).ATTRIBUTE2,
                ATTRIBUTE3      =   p_x_flight_schedules_tbl(i).ATTRIBUTE3,
                ATTRIBUTE4      =   p_x_flight_schedules_tbl(i).ATTRIBUTE4,
                ATTRIBUTE5      =   p_x_flight_schedules_tbl(i).ATTRIBUTE5,
                ATTRIBUTE6      =   p_x_flight_schedules_tbl(i).ATTRIBUTE6,
                ATTRIBUTE7      =   p_x_flight_schedules_tbl(i).ATTRIBUTE7,
                ATTRIBUTE8      =   p_x_flight_schedules_tbl(i).ATTRIBUTE8,
                ATTRIBUTE9      =   p_x_flight_schedules_tbl(i).ATTRIBUTE9,
                ATTRIBUTE10     =   p_x_flight_schedules_tbl(i).ATTRIBUTE10,
                ATTRIBUTE11     =   p_x_flight_schedules_tbl(i).ATTRIBUTE11,
                ATTRIBUTE12     =   p_x_flight_schedules_tbl(i).ATTRIBUTE12,
                ATTRIBUTE13     =   p_x_flight_schedules_tbl(i).ATTRIBUTE13,
                ATTRIBUTE14     =   p_x_flight_schedules_tbl(i).ATTRIBUTE14,
                ATTRIBUTE15     =   p_x_flight_schedules_tbl(i).ATTRIBUTE15
            WHERE
                unit_schedule_id = p_x_flight_schedules_tbl(i).unit_schedule_id
                AND object_version_number= p_x_flight_schedules_tbl(i).object_version_number;

Line: 2923

                    'SQL Error, Update failed..'
                 );

Line: 3012

            SELECT count(unit_schedule_id) INTO l_overlap_us_count
            FROM AHL_UNIT_SCHEDULES
            WHERE unit_config_header_id = p_x_flight_schedules_tbl(i).unit_config_header_id
            AND (
                  (
                (p_x_flight_schedules_tbl(i).actual_departure_time between ACTUAL_DEPARTURE_TIME and ACTUAL_ARRIVAL_TIME)
                AND
                ( p_x_flight_schedules_tbl(i).actual_arrival_time between ACTUAL_DEPARTURE_TIME and ACTUAL_ARRIVAL_TIME)
                  )
                  OR (ACTUAL_DEPARTURE_TIME between p_x_flight_schedules_tbl(i).actual_departure_time and p_x_flight_schedules_tbl(i).actual_arrival_time)
                  OR (ACTUAL_ARRIVAL_TIME between p_x_flight_schedules_tbl(i).actual_departure_time and p_x_flight_schedules_tbl(i).actual_arrival_time)
                )
            AND unit_schedule_id <> p_x_flight_schedules_tbl(i).unit_schedule_id;

Line: 3027

            SELECT count(unit_schedule_id) INTO l_overlap_us_count
            FROM AHL_UNIT_SCHEDULES
            WHERE unit_config_header_id = p_x_flight_schedules_tbl(i).unit_config_header_id
            /*AND (
                  (
                   (p_x_flight_schedules_tbl(i).est_departure_time  between EST_DEPARTURE_TIME and EST_ARRIVAL_TIME)
                   AND
                   ( p_x_flight_schedules_tbl(i).est_arrival_time between EST_DEPARTURE_TIME and EST_ARRIVAL_TIME)
                  )
                  OR (EST_DEPARTURE_TIME between p_x_flight_schedules_tbl(i).est_departure_time  and p_x_flight_schedules_tbl(i).est_arrival_time)
                  OR (EST_ARRIVAL_TIME between p_x_flight_schedules_tbl(i).est_departure_time  and p_x_flight_schedules_tbl(i).est_arrival_time)
                )*/
            AND (
                  (
                   ((p_x_flight_schedules_tbl(i).est_departure_time>EST_DEPARTURE_TIME  AND p_x_flight_schedules_tbl(i).est_departure_timeEST_DEPARTURE_TIME and p_x_flight_schedules_tbl(i).est_arrival_timep_x_flight_schedules_tbl(i).est_departure_time  and EST_DEPARTURE_TIMEp_x_flight_schedules_tbl(i).est_departure_time  and EST_ARRIVAL_TIME p_x_flight_schedules_tbl(i).unit_schedule_id;

Line: 3071

END Update_Flight_Schedules;

Line: 3074

PROCEDURE Delete_Flight_Schedules(
 x_return_status             OUT NOCOPY         VARCHAR2,
 x_msg_count                 OUT NOCOPY         NUMBER,
 x_msg_data                  OUT NOCOPY         VARCHAR2,
 p_x_flight_schedules_tbl    IN OUT NOCOPY      FLIGHT_SCHEDULES_TBL_TYPE
)
IS

-- Bug # 9075539 -- start
-- Cursor for fetching synchronization rule for a given flight.
CURSOR c_get_sync_rule(c_unit_sch_id IN NUMBER)
IS
SELECT visit_reschedule_mode
FROM   ahl_unit_schedules
WHERE  unit_schedule_id = c_unit_sch_id;

Line: 3093

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

Line: 3186

            AHL_VWP_VISITS_PVT.DELETE_FLIGHT_ASSOC(
             p_x_flight_schedules_tbl(i).unit_schedule_id,
             x_return_status
            );

Line: 3236

                  l_sync_rule = 'ALWAYS_RESCHEDULE'  OR l_sync_rule = 'DELETE'
              )
            THEN

                    -- delete the transit visits found
                    AHL_VWP_VISITS_PVT.Process_Visit (
                    p_api_version       => 1.0,
                    p_init_msg_list     => FND_API.g_false,
                    p_commit            => FND_API.g_false,
                    p_validation_level  => FND_API.g_valid_level_full,
                    p_module_type       => 'JSP',
                    p_x_Visit_tbl       => l_visit_tbl,
                    x_return_status     => x_return_status,
                    x_msg_count         => l_msg_count,
                    x_msg_data          => l_msg_data
                    );

Line: 3265

		    	x_return_status := 'V';-- status assigned to force flight schedule updates

Line: 3277

		    	x_return_status := 'V';-- status assigned to force flight schedule updates

Line: 3284

		    		'Visit could not be deleted or cancelled...Please refer error stack for more details..'
		    	    );

Line: 3292

            DELETE FROM AHL_UNIT_SCHEDULES
            WHERE unit_schedule_id = p_x_flight_schedules_tbl(i).unit_schedule_id
                  AND object_version_number= p_x_flight_schedules_tbl(i).object_version_number;

Line: 3308

                       'SQL Error, Delete failed..'
                   );

Line: 3314

END Delete_Flight_Schedules;

Line: 3366

    Delete_Flight_Schedules(
     x_return_status        =>  x_return_status,
     x_msg_count            =>  x_msg_count,
     x_msg_data         =>  x_msg_data,
     p_x_flight_schedules_tbl   =>  p_x_flight_schedules_tbl
    );

Line: 3381

    Update_Flight_Schedules(
     p_module_type          =>  p_module_type,
     x_return_status        =>  x_return_status,
     p_x_flight_schedules_tbl   =>  p_x_flight_schedules_tbl
    );

Line: 3495

SELECT 'X'
FROM AHL_UNIT_SCHEDULES
WHERE unit_schedule_id = p_unit_schedule_id
AND unit_config_header_id = nvl(p_unit_config_id, unit_config_header_id);

Line: 3629

   FUNCTION is_delete_allowed
   (
    p_unit_schedule_id  IN  NUMBER,
    p_is_super_user     IN  VARCHAR2
   )
   RETURN VARCHAR2
   IS
   --Cursor for checking if actuals are entered for the current unit schedule record.
   CURSOR get_curr_actuals_csr(p_unit_schedule_id IN NUMBER)
   IS
   SELECT actual_departure_time, actual_arrival_time
   FROM AHL_UNIT_SCHEDULES
   WHERE unit_schedule_id = p_unit_schedule_id;

Line: 3645

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

Line: 3687

   END is_delete_allowed;

Line: 3693

   FUNCTION is_update_allowed
   (
    p_unit_schedule_id  IN  NUMBER,
    p_is_super_user     IN  VARCHAR2
   )
   RETURN VARCHAR2
   IS

   --Cursor for getting the succeeding event of an Unit Schedule.
   CURSOR get_succeeding_us_csr(p_unit_schedule_id IN NUMBER) IS
   SELECT actual_departure_time, actual_arrival_time
   FROM AHL_UNIT_SCHEDULES
   WHERE preceding_us_id = p_unit_schedule_id;

Line: 3707

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

Line: 3753

   END is_update_allowed;