APPS.OKS_COVERAGE_UTIL_PVT SQL Statements

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

Line: 15

   * been processed and inserted into the GT table within a session.
   */
  FUNCTION isTimezoneAlreadyProcessed (cov_timezone_id NUMBER)
  RETURN VARCHAR2
  IS
     l_count number := 0;

Line: 30

    SELECT
    count(*)
    into l_count
    from oks_coverage_times_gt
    where COV_TZE_LINE_ID = cov_timezone_id;

Line: 214

        SELECT
            to_number(START_HOUR||decode(LENGTH(START_MINUTE),1,'0'||START_MINUTE,START_MINUTE)) time,
            to_char(to_date(start_hour||':'||start_minute, 'HH24:MI'), 'HH24:MI') concatenate_time
        FROM OKS_COVERAGE_TIMES
        WHERE
            COV_TZE_LINE_ID = cov_timezone_id
        UNION ALL
        SELECT to_number(END_HOUR||decode(LENGTH(END_MINUTE),1,'0'||END_MINUTE,END_MINUTE)) time,
             to_char(to_date(end_hour||':'||end_minute, 'HH24:MI'), 'HH24:MI') concatenate_time
        FROM OKS_COVERAGE_TIMES
        WHERE
            COV_TZE_LINE_ID = cov_timezone_id
        ORDER BY time;

Line: 271

        SELECT
            NVL(MONDAY_YN, 'N') MONDAY_YN,
            NVL(TUESDAY_YN, 'N') TUESDAY_YN,
            NVL(WEDNESDAY_YN, 'N') WEDNESDAY_YN,
            NVL(THURSDAY_YN, 'N') THURSDAY_YN,
            NVL(FRIDAY_YN, 'N') FRIDAY_YN,
            NVL(SATURDAY_YN, 'N') SATURDAY_YN,
            NVL(SUNDAY_YN, 'N') SUNDAY_YN,
            COV_TZE_LINE_ID,
            null start_time,
            null end_time,
            to_number(START_HOUR||decode(LENGTH(START_MINUTE),1,'0'||START_MINUTE,START_MINUTE)) START_HOUR_MINUTE,
            to_number(END_HOUR||decode(LENGTH(END_MINUTE),1,'0'||END_MINUTE,END_MINUTE))END_HOUR_MINUTE
             BULK COLLECT INTO coverage_times_recs
        FROM
            OKS_COVERAGE_TIMES
        WHERE
            COV_TZE_LINE_ID = cov_timezone_id
        ORDER BY start_hour asc;

Line: 355

        INSERT INTO OKS_COVERAGE_TIMES_GT VALUES new_coverage_times_recs(k);