APPS.MRP_CALENDAR SQL Statements

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

Line: 44

        SELECT   /*+ index_ffs(bom) */ min(calendar_date), max(calendar_date), min(seq_num),
                    max(seq_num)
        INTO    min_date, max_date, min_seq_num, max_seq_num
        FROM    bom_calendar_dates bom
        WHERE   calendar_code = arg_calendar_code
        AND     seq_num is not null
        AND     exception_set_id = arg_exception_set_id;

Line: 52

        SELECT  min(period_start_date), max(period_start_date)
        INTO    min_period_date, max_period_date
        FROM    bom_period_start_dates
        WHERE   calendar_code = arg_calendar_code
        AND     exception_set_id = arg_exception_set_id;

Line: 58

        SELECT  min(week_start_date), max(week_start_date), min(seq_num),
                max(seq_num)
        INTO    min_week_date, max_week_date, min_week_seq_num,
                max_week_seq_num
        FROM    bom_cal_week_start_dates
        WHERE   calendar_code = arg_calendar_code
        AND     exception_set_id = arg_exception_set_id;

Line: 95

      SELECT  period_start_date
      FROM    bom_period_start_dates cal
      WHERE   cal.exception_set_id = var_exception_set_id
        AND   cal.calendar_code = var_calendar_code
        AND   cal.period_start_date > TRUNC(arg_date);

Line: 114

      SELECT  period_start_date
      FROM    bom_period_start_dates cal
      WHERE   cal.exception_set_id = var_exception_set_id
        AND   cal.calendar_code = var_calendar_code
        AND   cal.period_start_date < TRUNC(arg_date)
      ORDER BY period_start_date DESC;

Line: 146

        SELECT calendar_date
        INTO   var_return_date
        FROM   bom_calendar_dates  cal
        WHERE  cal.exception_set_id = var_exception_set_id
          AND  cal.calendar_code = var_calendar_code
          AND  cal.seq_num = arg_seq_num + arg_offset;

Line: 176

        SELECT week_start_date
        INTO   var_return_date
        FROM   bom_cal_week_start_dates  cal
        WHERE  cal.exception_set_id = var_exception_set_id
          AND  cal.calendar_code = var_calendar_code
          AND  cal.seq_num = arg_seq_num + arg_offset;

Line: 210

   mrp_calendar.select_calendar_defaults(arg_org_id,
            var_calendar_code, var_exception_set_id);

Line: 222

            SELECT  cal.next_date
            INTO    var_return_date
            FROM    bom_calendar_dates  cal
            WHERE   cal.exception_set_id = var_exception_set_id
              AND   cal.calendar_code = var_calendar_code
              AND   cal.calendar_date = TRUNC(arg_date);

Line: 236

            SELECT  MIN(cal.week_start_date)
            INTO    var_return_date
            FROM    bom_cal_week_start_dates  cal
            WHERE   cal.exception_set_id = var_exception_set_id
              AND   cal.calendar_code = var_calendar_code
              AND   cal.week_start_date >= TRUNC(arg_date);

Line: 250

            SELECT  MIN(cal.period_start_date)
            INTO    var_return_date
            FROM    bom_period_start_dates  cal
             WHERE  cal.exception_set_id = var_exception_set_id
               AND  cal.calendar_code = var_calendar_code
               AND  cal.period_start_date >= TRUNC(arg_date);

Line: 273

    mrp_calendar.select_calendar_defaults(arg_org_id,
            var_calendar_code, var_exception_set_id);

Line: 283

            SELECT  cal.prior_date
            INTO    var_return_date
            FROM    bom_calendar_dates  cal
            WHERE   cal.exception_set_id = var_exception_set_id
              AND   cal.calendar_code = var_calendar_code
              AND   cal.calendar_date = TRUNC(arg_date);

Line: 296

            SELECT  MAX(cal.week_start_date)
            INTO    var_return_date
            FROM    bom_cal_week_start_dates  cal
            WHERE   cal.exception_set_id = var_exception_set_id
              AND   cal.calendar_code = var_calendar_code
              AND   cal.week_start_date <= TRUNC(arg_date);

Line: 309

            SELECT  MAX(cal.period_start_date)
            INTO    var_return_date
            FROM    bom_period_start_dates  cal
            WHERE   cal.exception_set_id = var_exception_set_id
              AND   cal.calendar_code = var_calendar_code
              AND   cal.period_start_date <= TRUNC(arg_date);

Line: 329

    mrp_calendar.select_calendar_defaults(arg_org_id,
            var_calendar_code, var_exception_set_id);

Line: 338

            SELECT  cal.next_seq_num
            INTO    var_return_number
            FROM    bom_calendar_dates  cal
            WHERE   cal.exception_set_id = var_exception_set_id
              AND   cal.calendar_code = var_calendar_code
              AND   cal.calendar_date = TRUNC(arg_date);

Line: 351

            SELECT  MIN(cal.seq_num)
            INTO    var_return_number
            FROM    bom_cal_week_start_dates  cal
            WHERE   cal.exception_set_id = var_exception_set_id
              AND   cal.calendar_code = var_calendar_code
              AND   cal.week_start_date >= TRUNC(arg_date);

Line: 372

    mrp_calendar.select_calendar_defaults(arg_org_id,
            var_calendar_code, var_exception_set_id);

Line: 381

            SELECT  cal.prior_seq_num
            INTO    var_return_number
            FROM    bom_calendar_dates  cal
            WHERE   cal.exception_set_id = var_exception_set_id
              AND   cal.calendar_code = var_calendar_code
              AND   cal.calendar_date = TRUNC(arg_date);

Line: 394

            SELECT  MAX(cal.seq_num)
            INTO    var_return_number
            FROM    bom_cal_week_start_dates  cal
            WHERE   cal.exception_set_id = var_exception_set_id
              AND   cal.calendar_code = var_calendar_code
              AND   cal.week_start_date <= TRUNC(arg_date);

Line: 426

    mrp_calendar.select_calendar_defaults(arg_org_id,
            var_calendar_code, var_exception_set_id);

Line: 456

    mrp_calendar.select_calendar_defaults(arg_org_id,
            var_calendar_code, var_exception_set_id);

Line: 472

      SELECT count(period_start_date)
      INTO var_return_number
      FROM bom_period_start_dates cal
      WHERE cal.exception_set_id = var_exception_set_id
      AND   cal.calendar_code = var_calendar_code
      AND   cal.period_start_date between var_prev_work_day
        and var_prev_work_day2
      AND   cal.period_start_date <> var_prev_work_day2;

Line: 490

PROCEDURE select_calendar_defaults(
		arg_org_id IN NUMBER,
                arg_calendar_code OUT NOCOPY VARCHAR2, --2663505
                arg_exception_set_id OUT NOCOPY NUMBER) IS --2663505

BEGIN
    SELECT   calendar_code,
             calendar_exception_set_id
    INTO     arg_calendar_code,
             arg_exception_set_id
    FROM     mtl_parameters
    WHERE    organization_id = arg_org_id;

Line: 504

        raise_application_error(-200000, 'Cannot select calendar defaults');

Line: 507

END select_calendar_defaults;