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.MSC_SNAPSHOT_PK dependencies on MSC_PLAN_BUCKETS

Line 32: p_msc_plan_buckets IN OUT NOCOPY msc_plan_buckets_typ,

28: p_plan_id NUMBER,
29: p_sr_instance_id NUMBER,
30: p_org_id NUMBER,
31: p_bucket_index NUMBER,
32: p_msc_plan_buckets IN OUT NOCOPY msc_plan_buckets_typ,
33: p_err_mesg OUT NOCOPY VARCHAR2
34: );
35:
36: -- ********************** complete_task *************************

Line 316: l_msc_plan_buckets msc_plan_buckets_typ;

312: l_plan_cutoff_date DATE;
313: l_org_id Number;
314: l_sr_instance_id Number;
315:
316: l_msc_plan_buckets msc_plan_buckets_typ;
317:
318: m_calendar_code VARCHAR2(14);
319: m_cal_exception_set_id Number;
320: m_sr_instance_id Number;

Line 335: DELETE FROM msc_plan_buckets

331: -- IF mrdebug = TRUE THEN
332: -- dbms_output.enable(1000000);
333: -- END IF;
334:
335: DELETE FROM msc_plan_buckets
336: WHERE plan_id = p_plan_id;
337:
338: OPEN plan_orgs_cur;
339: FETCH plan_orgs_cur

Line 504: l_msc_plan_buckets.bucket_index,

500: ,To_char(cal.calendar_date,'YYYY/MM/DD')
501: ,1 bucket_type
502: ,1 days_in_bucket
503: BULK COLLECT INTO
504: l_msc_plan_buckets.bucket_index,
505: l_msc_plan_buckets.bkt_start_date,
506: l_msc_plan_buckets.bkt_end_date,
507: l_msc_plan_buckets.bucket_type,
508: l_msc_plan_buckets.days_in_bkt

Line 505: l_msc_plan_buckets.bkt_start_date,

501: ,1 bucket_type
502: ,1 days_in_bucket
503: BULK COLLECT INTO
504: l_msc_plan_buckets.bucket_index,
505: l_msc_plan_buckets.bkt_start_date,
506: l_msc_plan_buckets.bkt_end_date,
507: l_msc_plan_buckets.bucket_type,
508: l_msc_plan_buckets.days_in_bkt
509: FROM

Line 506: l_msc_plan_buckets.bkt_end_date,

502: ,1 days_in_bucket
503: BULK COLLECT INTO
504: l_msc_plan_buckets.bucket_index,
505: l_msc_plan_buckets.bkt_start_date,
506: l_msc_plan_buckets.bkt_end_date,
507: l_msc_plan_buckets.bucket_type,
508: l_msc_plan_buckets.days_in_bkt
509: FROM
510: MSC_CALENDAR_DATES cal

Line 507: l_msc_plan_buckets.bucket_type,

503: BULK COLLECT INTO
504: l_msc_plan_buckets.bucket_index,
505: l_msc_plan_buckets.bkt_start_date,
506: l_msc_plan_buckets.bkt_end_date,
507: l_msc_plan_buckets.bucket_type,
508: l_msc_plan_buckets.days_in_bkt
509: FROM
510: MSC_CALENDAR_DATES cal
511: WHERE

Line 508: l_msc_plan_buckets.days_in_bkt

504: l_msc_plan_buckets.bucket_index,
505: l_msc_plan_buckets.bkt_start_date,
506: l_msc_plan_buckets.bkt_end_date,
507: l_msc_plan_buckets.bucket_type,
508: l_msc_plan_buckets.days_in_bkt
509: FROM
510: MSC_CALENDAR_DATES cal
511: WHERE
512: cal.sr_instance_id = m_sr_instance_id

Line 525: l_msc_plan_buckets,

521: p_plan_id,
522: l_sr_instance_id,
523: l_org_id,
524: l_bkt_index,
525: l_msc_plan_buckets,
526: p_err_mesg);
527:
528: IF p_err_mesg IS NOT NULL THEN
529: /* IF mrdebug = TRUE THEN

Line 535: p_daily_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;

531: END IF; */
532: RETURN;
533: END IF;
534:
535: p_daily_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
536: p_weekly_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
537: p_period_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
538:
539: l_bkt_index := l_bkt_index + l_msc_plan_buckets.bucket_index.count;

Line 536: p_weekly_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;

532: RETURN;
533: END IF;
534:
535: p_daily_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
536: p_weekly_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
537: p_period_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
538:
539: l_bkt_index := l_bkt_index + l_msc_plan_buckets.bucket_index.count;
540: l_msc_plan_buckets := NULL;

Line 537: p_period_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;

533: END IF;
534:
535: p_daily_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
536: p_weekly_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
537: p_period_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
538:
539: l_bkt_index := l_bkt_index + l_msc_plan_buckets.bucket_index.count;
540: l_msc_plan_buckets := NULL;
541: END IF;

Line 539: l_bkt_index := l_bkt_index + l_msc_plan_buckets.bucket_index.count;

535: p_daily_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
536: p_weekly_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
537: p_period_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
538:
539: l_bkt_index := l_bkt_index + l_msc_plan_buckets.bucket_index.count;
540: l_msc_plan_buckets := NULL;
541: END IF;
542:
543:

Line 540: l_msc_plan_buckets := NULL;

536: p_weekly_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
537: p_period_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
538:
539: l_bkt_index := l_bkt_index + l_msc_plan_buckets.bucket_index.count;
540: l_msc_plan_buckets := NULL;
541: END IF;
542:
543:
544: IF l_weekly_cutoff_date IS NOT NULL THEN

Line 559: l_msc_plan_buckets.bucket_index,

555: ,trunc(Least(
556: Greatest(cal.next_date - 1, cal.week_start_date),
557: l_weekly_cutoff_date)) - trunc(cal.week_start_date) + 1 days_in_bucket
558: BULK COLLECT INTO
559: l_msc_plan_buckets.bucket_index,
560: l_msc_plan_buckets.bkt_start_date,
561: l_msc_plan_buckets.bkt_end_date,
562: l_msc_plan_buckets.bucket_type,
563: l_msc_plan_buckets.days_in_bkt

Line 560: l_msc_plan_buckets.bkt_start_date,

556: Greatest(cal.next_date - 1, cal.week_start_date),
557: l_weekly_cutoff_date)) - trunc(cal.week_start_date) + 1 days_in_bucket
558: BULK COLLECT INTO
559: l_msc_plan_buckets.bucket_index,
560: l_msc_plan_buckets.bkt_start_date,
561: l_msc_plan_buckets.bkt_end_date,
562: l_msc_plan_buckets.bucket_type,
563: l_msc_plan_buckets.days_in_bkt
564: FROM

Line 561: l_msc_plan_buckets.bkt_end_date,

557: l_weekly_cutoff_date)) - trunc(cal.week_start_date) + 1 days_in_bucket
558: BULK COLLECT INTO
559: l_msc_plan_buckets.bucket_index,
560: l_msc_plan_buckets.bkt_start_date,
561: l_msc_plan_buckets.bkt_end_date,
562: l_msc_plan_buckets.bucket_type,
563: l_msc_plan_buckets.days_in_bkt
564: FROM
565: MSC_CAL_WEEK_START_DATES cal

Line 562: l_msc_plan_buckets.bucket_type,

558: BULK COLLECT INTO
559: l_msc_plan_buckets.bucket_index,
560: l_msc_plan_buckets.bkt_start_date,
561: l_msc_plan_buckets.bkt_end_date,
562: l_msc_plan_buckets.bucket_type,
563: l_msc_plan_buckets.days_in_bkt
564: FROM
565: MSC_CAL_WEEK_START_DATES cal
566: WHERE cal.sr_instance_id = m_sr_instance_id

Line 563: l_msc_plan_buckets.days_in_bkt

559: l_msc_plan_buckets.bucket_index,
560: l_msc_plan_buckets.bkt_start_date,
561: l_msc_plan_buckets.bkt_end_date,
562: l_msc_plan_buckets.bucket_type,
563: l_msc_plan_buckets.days_in_bkt
564: FROM
565: MSC_CAL_WEEK_START_DATES cal
566: WHERE cal.sr_instance_id = m_sr_instance_id
567: AND cal.calendar_code = m_calendar_code

Line 578: l_msc_plan_buckets,

574: p_plan_id,
575: l_sr_instance_id,
576: l_org_id,
577: l_bkt_index,
578: l_msc_plan_buckets,
579: p_err_mesg);
580:
581: IF p_err_mesg IS NOT NULL THEN
582: /* IF mrdebug = TRUE THEN

Line 588: p_weekly_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;

584: END IF; */
585: RETURN;
586: END IF;
587:
588: p_weekly_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
589: p_period_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
590:
591: l_bkt_index := l_bkt_index + l_msc_plan_buckets.bucket_index.count;
592: l_msc_plan_buckets := NULL;

Line 589: p_period_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;

585: RETURN;
586: END IF;
587:
588: p_weekly_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
589: p_period_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
590:
591: l_bkt_index := l_bkt_index + l_msc_plan_buckets.bucket_index.count;
592: l_msc_plan_buckets := NULL;
593:

Line 591: l_bkt_index := l_bkt_index + l_msc_plan_buckets.bucket_index.count;

587:
588: p_weekly_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
589: p_period_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
590:
591: l_bkt_index := l_bkt_index + l_msc_plan_buckets.bucket_index.count;
592: l_msc_plan_buckets := NULL;
593:
594:
595: END IF;

Line 592: l_msc_plan_buckets := NULL;

588: p_weekly_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
589: p_period_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
590:
591: l_bkt_index := l_bkt_index + l_msc_plan_buckets.bucket_index.count;
592: l_msc_plan_buckets := NULL;
593:
594:
595: END IF;
596:

Line 613: l_msc_plan_buckets.bucket_index,

609: l_period_cutoff_date)) - trunc(cal.period_start_date)
610: + 1 days_in_bucket
611: -- days between needs a + 1
612: BULK COLLECT INTO
613: l_msc_plan_buckets.bucket_index,
614: l_msc_plan_buckets.bkt_start_date,
615: l_msc_plan_buckets.bkt_end_date,
616: l_msc_plan_buckets.bucket_type,
617: l_msc_plan_buckets.days_in_bkt

Line 614: l_msc_plan_buckets.bkt_start_date,

610: + 1 days_in_bucket
611: -- days between needs a + 1
612: BULK COLLECT INTO
613: l_msc_plan_buckets.bucket_index,
614: l_msc_plan_buckets.bkt_start_date,
615: l_msc_plan_buckets.bkt_end_date,
616: l_msc_plan_buckets.bucket_type,
617: l_msc_plan_buckets.days_in_bkt
618: FROM

Line 615: l_msc_plan_buckets.bkt_end_date,

611: -- days between needs a + 1
612: BULK COLLECT INTO
613: l_msc_plan_buckets.bucket_index,
614: l_msc_plan_buckets.bkt_start_date,
615: l_msc_plan_buckets.bkt_end_date,
616: l_msc_plan_buckets.bucket_type,
617: l_msc_plan_buckets.days_in_bkt
618: FROM
619: msc_period_start_dates cal

Line 616: l_msc_plan_buckets.bucket_type,

612: BULK COLLECT INTO
613: l_msc_plan_buckets.bucket_index,
614: l_msc_plan_buckets.bkt_start_date,
615: l_msc_plan_buckets.bkt_end_date,
616: l_msc_plan_buckets.bucket_type,
617: l_msc_plan_buckets.days_in_bkt
618: FROM
619: msc_period_start_dates cal
620: WHERE

Line 617: l_msc_plan_buckets.days_in_bkt

613: l_msc_plan_buckets.bucket_index,
614: l_msc_plan_buckets.bkt_start_date,
615: l_msc_plan_buckets.bkt_end_date,
616: l_msc_plan_buckets.bucket_type,
617: l_msc_plan_buckets.days_in_bkt
618: FROM
619: msc_period_start_dates cal
620: WHERE
621: cal.sr_instance_id = m_sr_instance_id

Line 634: l_msc_plan_buckets,

630: p_plan_id,
631: l_sr_instance_id,
632: l_org_id,
633: l_bkt_index,
634: l_msc_plan_buckets,
635: p_err_mesg);
636: IF p_err_mesg IS NOT NULL THEN
637: /* IF mrdebug = TRUE THEN
638: LOG_MESSAGE(' 301 ');

Line 642: p_period_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;

638: LOG_MESSAGE(' 301 ');
639: END IF; */
640: RETURN;
641: END IF;
642: p_period_cutoff_bucket := l_bkt_index + l_msc_plan_buckets.bucket_index.COUNT;
643:
644: END IF;
645:
646: EXCEPTION

Line 1281: p_msc_plan_buckets IN OUT NOCOPY msc_plan_buckets_typ,

1277: p_plan_id NUMBER,
1278: p_sr_instance_id NUMBER,
1279: p_org_id NUMBER,
1280: p_bucket_index NUMBER,
1281: p_msc_plan_buckets IN OUT NOCOPY msc_plan_buckets_typ,
1282: p_err_mesg OUT NOCOPY VARCHAR2
1283: ) IS
1284: j NUMBER;
1285: k NUMBER;

Line 1288: FOR j IN 1..p_msc_plan_buckets.bucket_index.COUNT LOOP

1284: j NUMBER;
1285: k NUMBER;
1286: BEGIN
1287:
1288: FOR j IN 1..p_msc_plan_buckets.bucket_index.COUNT LOOP
1289: p_msc_plan_buckets.bucket_index(j) := j+p_bucket_index;
1290: END LOOP;
1291: /*
1292: IF mrdebug = TRUE THEN

Line 1289: p_msc_plan_buckets.bucket_index(j) := j+p_bucket_index;

1285: k NUMBER;
1286: BEGIN
1287:
1288: FOR j IN 1..p_msc_plan_buckets.bucket_index.COUNT LOOP
1289: p_msc_plan_buckets.bucket_index(j) := j+p_bucket_index;
1290: END LOOP;
1291: /*
1292: IF mrdebug = TRUE THEN
1293: NULL;

Line 1294: FOR j IN 1..p_msc_plan_buckets.bucket_index.COUNT LOOP

1290: END LOOP;
1291: /*
1292: IF mrdebug = TRUE THEN
1293: NULL;
1294: FOR j IN 1..p_msc_plan_buckets.bucket_index.COUNT LOOP
1295: LOG_MESSAGE(p_msc_plan_buckets.bucket_index(j)||' '||
1296: p_msc_plan_buckets.bkt_start_date(j)||' '||
1297: p_msc_plan_buckets.bkt_end_date(j)||' '||
1298: p_msc_plan_buckets.bucket_type(j)||' '||

Line 1295: LOG_MESSAGE(p_msc_plan_buckets.bucket_index(j)||' '||

1291: /*
1292: IF mrdebug = TRUE THEN
1293: NULL;
1294: FOR j IN 1..p_msc_plan_buckets.bucket_index.COUNT LOOP
1295: LOG_MESSAGE(p_msc_plan_buckets.bucket_index(j)||' '||
1296: p_msc_plan_buckets.bkt_start_date(j)||' '||
1297: p_msc_plan_buckets.bkt_end_date(j)||' '||
1298: p_msc_plan_buckets.bucket_type(j)||' '||
1299: p_msc_plan_buckets.days_in_bkt(j));

Line 1296: p_msc_plan_buckets.bkt_start_date(j)||' '||

1292: IF mrdebug = TRUE THEN
1293: NULL;
1294: FOR j IN 1..p_msc_plan_buckets.bucket_index.COUNT LOOP
1295: LOG_MESSAGE(p_msc_plan_buckets.bucket_index(j)||' '||
1296: p_msc_plan_buckets.bkt_start_date(j)||' '||
1297: p_msc_plan_buckets.bkt_end_date(j)||' '||
1298: p_msc_plan_buckets.bucket_type(j)||' '||
1299: p_msc_plan_buckets.days_in_bkt(j));
1300: END LOOP;

Line 1297: p_msc_plan_buckets.bkt_end_date(j)||' '||

1293: NULL;
1294: FOR j IN 1..p_msc_plan_buckets.bucket_index.COUNT LOOP
1295: LOG_MESSAGE(p_msc_plan_buckets.bucket_index(j)||' '||
1296: p_msc_plan_buckets.bkt_start_date(j)||' '||
1297: p_msc_plan_buckets.bkt_end_date(j)||' '||
1298: p_msc_plan_buckets.bucket_type(j)||' '||
1299: p_msc_plan_buckets.days_in_bkt(j));
1300: END LOOP;
1301:

Line 1298: p_msc_plan_buckets.bucket_type(j)||' '||

1294: FOR j IN 1..p_msc_plan_buckets.bucket_index.COUNT LOOP
1295: LOG_MESSAGE(p_msc_plan_buckets.bucket_index(j)||' '||
1296: p_msc_plan_buckets.bkt_start_date(j)||' '||
1297: p_msc_plan_buckets.bkt_end_date(j)||' '||
1298: p_msc_plan_buckets.bucket_type(j)||' '||
1299: p_msc_plan_buckets.days_in_bkt(j));
1300: END LOOP;
1301:
1302: LOG_MESSAGE(p_msc_plan_buckets.bucket_index.count||' '||

Line 1299: p_msc_plan_buckets.days_in_bkt(j));

1295: LOG_MESSAGE(p_msc_plan_buckets.bucket_index(j)||' '||
1296: p_msc_plan_buckets.bkt_start_date(j)||' '||
1297: p_msc_plan_buckets.bkt_end_date(j)||' '||
1298: p_msc_plan_buckets.bucket_type(j)||' '||
1299: p_msc_plan_buckets.days_in_bkt(j));
1300: END LOOP;
1301:
1302: LOG_MESSAGE(p_msc_plan_buckets.bucket_index.count||' '||
1303: p_msc_plan_buckets.bkt_start_date.count||' '||

Line 1302: LOG_MESSAGE(p_msc_plan_buckets.bucket_index.count||' '||

1298: p_msc_plan_buckets.bucket_type(j)||' '||
1299: p_msc_plan_buckets.days_in_bkt(j));
1300: END LOOP;
1301:
1302: LOG_MESSAGE(p_msc_plan_buckets.bucket_index.count||' '||
1303: p_msc_plan_buckets.bkt_start_date.count||' '||
1304: p_msc_plan_buckets.bkt_end_date.count||' '||
1305: p_msc_plan_buckets.bucket_type.count||' '||
1306: p_msc_plan_buckets.days_in_bkt.count);

Line 1303: p_msc_plan_buckets.bkt_start_date.count||' '||

1299: p_msc_plan_buckets.days_in_bkt(j));
1300: END LOOP;
1301:
1302: LOG_MESSAGE(p_msc_plan_buckets.bucket_index.count||' '||
1303: p_msc_plan_buckets.bkt_start_date.count||' '||
1304: p_msc_plan_buckets.bkt_end_date.count||' '||
1305: p_msc_plan_buckets.bucket_type.count||' '||
1306: p_msc_plan_buckets.days_in_bkt.count);
1307:

Line 1304: p_msc_plan_buckets.bkt_end_date.count||' '||

1300: END LOOP;
1301:
1302: LOG_MESSAGE(p_msc_plan_buckets.bucket_index.count||' '||
1303: p_msc_plan_buckets.bkt_start_date.count||' '||
1304: p_msc_plan_buckets.bkt_end_date.count||' '||
1305: p_msc_plan_buckets.bucket_type.count||' '||
1306: p_msc_plan_buckets.days_in_bkt.count);
1307:
1308: END IF;

Line 1305: p_msc_plan_buckets.bucket_type.count||' '||

1301:
1302: LOG_MESSAGE(p_msc_plan_buckets.bucket_index.count||' '||
1303: p_msc_plan_buckets.bkt_start_date.count||' '||
1304: p_msc_plan_buckets.bkt_end_date.count||' '||
1305: p_msc_plan_buckets.bucket_type.count||' '||
1306: p_msc_plan_buckets.days_in_bkt.count);
1307:
1308: END IF;
1309: */

Line 1306: p_msc_plan_buckets.days_in_bkt.count);

1302: LOG_MESSAGE(p_msc_plan_buckets.bucket_index.count||' '||
1303: p_msc_plan_buckets.bkt_start_date.count||' '||
1304: p_msc_plan_buckets.bkt_end_date.count||' '||
1305: p_msc_plan_buckets.bucket_type.count||' '||
1306: p_msc_plan_buckets.days_in_bkt.count);
1307:
1308: END IF;
1309: */
1310:

Line 1311: FORALL k IN 1..p_msc_plan_buckets.bucket_index.COUNT

1307:
1308: END IF;
1309: */
1310:
1311: FORALL k IN 1..p_msc_plan_buckets.bucket_index.COUNT
1312: insert into msc_plan_buckets(
1313: PLAN_ID
1314: ,ORGANIZATION_ID
1315: ,SR_INSTANCE_ID

Line 1312: insert into msc_plan_buckets(

1308: END IF;
1309: */
1310:
1311: FORALL k IN 1..p_msc_plan_buckets.bucket_index.COUNT
1312: insert into msc_plan_buckets(
1313: PLAN_ID
1314: ,ORGANIZATION_ID
1315: ,SR_INSTANCE_ID
1316: ,BUCKET_INDEX

Line 1331: p_msc_plan_buckets.bucket_index(k),

1327: (
1328: p_plan_id,
1329: p_org_id,
1330: p_sr_instance_id,
1331: p_msc_plan_buckets.bucket_index(k),
1332: To_date(p_msc_plan_buckets.bkt_start_date(k), 'YYYY/MM/DD'),
1333: To_date(p_msc_plan_buckets.bkt_end_date(k), 'YYYY/MM/DD')+(86399/86400),
1334: p_msc_plan_buckets.bucket_type(k),
1335: p_msc_plan_buckets.days_in_bkt(k),

Line 1332: To_date(p_msc_plan_buckets.bkt_start_date(k), 'YYYY/MM/DD'),

1328: p_plan_id,
1329: p_org_id,
1330: p_sr_instance_id,
1331: p_msc_plan_buckets.bucket_index(k),
1332: To_date(p_msc_plan_buckets.bkt_start_date(k), 'YYYY/MM/DD'),
1333: To_date(p_msc_plan_buckets.bkt_end_date(k), 'YYYY/MM/DD')+(86399/86400),
1334: p_msc_plan_buckets.bucket_type(k),
1335: p_msc_plan_buckets.days_in_bkt(k),
1336: 1,

Line 1333: To_date(p_msc_plan_buckets.bkt_end_date(k), 'YYYY/MM/DD')+(86399/86400),

1329: p_org_id,
1330: p_sr_instance_id,
1331: p_msc_plan_buckets.bucket_index(k),
1332: To_date(p_msc_plan_buckets.bkt_start_date(k), 'YYYY/MM/DD'),
1333: To_date(p_msc_plan_buckets.bkt_end_date(k), 'YYYY/MM/DD')+(86399/86400),
1334: p_msc_plan_buckets.bucket_type(k),
1335: p_msc_plan_buckets.days_in_bkt(k),
1336: 1,
1337: Sysdate,

Line 1334: p_msc_plan_buckets.bucket_type(k),

1330: p_sr_instance_id,
1331: p_msc_plan_buckets.bucket_index(k),
1332: To_date(p_msc_plan_buckets.bkt_start_date(k), 'YYYY/MM/DD'),
1333: To_date(p_msc_plan_buckets.bkt_end_date(k), 'YYYY/MM/DD')+(86399/86400),
1334: p_msc_plan_buckets.bucket_type(k),
1335: p_msc_plan_buckets.days_in_bkt(k),
1336: 1,
1337: Sysdate,
1338: 1,

Line 1335: p_msc_plan_buckets.days_in_bkt(k),

1331: p_msc_plan_buckets.bucket_index(k),
1332: To_date(p_msc_plan_buckets.bkt_start_date(k), 'YYYY/MM/DD'),
1333: To_date(p_msc_plan_buckets.bkt_end_date(k), 'YYYY/MM/DD')+(86399/86400),
1334: p_msc_plan_buckets.bucket_type(k),
1335: p_msc_plan_buckets.days_in_bkt(k),
1336: 1,
1337: Sysdate,
1338: 1,
1339: Sysdate,

Line 1380: FROM msc_plan_buckets

1376: --LOG_MESSAGE(' 1 : '||p_min_cutoff_bucket||' '||p_hour_cutoff_bucket);
1377:
1378: SELECT NVL(MIN(bkt_start_date), TRUNC(SYSDATE))
1379: INTO first_date
1380: FROM msc_plan_buckets
1381: WHERE plan_id = p_plan_id
1382: AND bucket_type = 1;
1383:
1384: --LOG_MESSAGE(' 2 : '||first_date);

Line 1414: from msc_plan_buckets

1410:
1411: SELECT NVL(max(bkt_end_date), TRUNC(SYSDATE)),
1412: NVL(max(bucket_index), 0)
1413: INTO l_daily_cutoff_date, p_daily_cutoff_bucket
1414: from msc_plan_buckets
1415: where plan_id = p_plan_id
1416: AND bucket_type = 1;
1417:
1418: if p_daily_cutoff_bucket = 0

Line 1434: from msc_plan_buckets

1430: SELECT
1431: Nvl(max(bkt_end_date),l_daily_cutoff_date),
1432: Nvl(max(bucket_index), p_daily_cutoff_bucket)
1433: INTO l_weekly_cutoff_date, p_weekly_cutoff_bucket
1434: from msc_plan_buckets
1435: where plan_id = p_plan_id
1436: AND bucket_type = 2;
1437:
1438: --LOG_MESSAGE(' 9 : '||l_weekly_cutoff_date||' '||p_weekly_cutoff_bucket);

Line 1444: from msc_plan_buckets

1440: SELECT
1441: Nvl(max(bkt_end_date),l_weekly_cutoff_date),
1442: Nvl(max(bucket_index), p_weekly_cutoff_bucket)
1443: INTO l_period_cutoff_date, p_period_cutoff_bucket
1444: from msc_plan_buckets
1445: where plan_id = p_plan_id
1446: AND bucket_type = 3;
1447:
1448: --LOG_MESSAGE(' 10 : '||l_period_cutoff_date||' '||p_period_cutoff_bucket);

Line 1584: from msc_plan_buckets own_org_bkt,

1580: into l_bucket_type,
1581: l_bucket_index,
1582: l_bkt_end_date,
1583: l_bkt_end_date1
1584: from msc_plan_buckets own_org_bkt,
1585: msc_plan_buckets org_bkt
1586: where own_org_bkt.plan_id = p_plan_id
1587: and own_org_bkt.organization_id = p_owning_org_id
1588: and own_org_bkt.sr_instance_id = p_owning_instance_id

Line 1585: msc_plan_buckets org_bkt

1581: l_bucket_index,
1582: l_bkt_end_date,
1583: l_bkt_end_date1
1584: from msc_plan_buckets own_org_bkt,
1585: msc_plan_buckets org_bkt
1586: where own_org_bkt.plan_id = p_plan_id
1587: and own_org_bkt.organization_id = p_owning_org_id
1588: and own_org_bkt.sr_instance_id = p_owning_instance_id
1589: and own_org_bkt.curr_flag = 1

Line 1621: from msc_plan_buckets org_bkt,

1617: and cal2.exception_set_id = -1;
1618: ELSE
1619: select to_number(to_char(cal2.calendar_date,'J'))
1620: into l_calendar_date
1621: from msc_plan_buckets org_bkt,
1622: msc_calendar_dates cal1,
1623: msc_calendar_dates cal2
1624: where org_bkt.plan_id = p_plan_id
1625: and org_bkt.organization_id = p_owning_org_id

Line 1681: from msc_plan_buckets own_org_bkt,

1677: BEGIN
1678: IF (p_plan_type <> 4 AND p_plan_type <> 9) THEN
1679: select to_number(to_char(cal1.prior_date,'J'))
1680: into l_calendar_date
1681: from msc_plan_buckets own_org_bkt,
1682: msc_plan_buckets org_bkt,
1683: msc_calendar_dates cal1
1684: where own_org_bkt.plan_id = p_plan_id
1685: and own_org_bkt.organization_id = p_owning_org_id

Line 1682: msc_plan_buckets org_bkt,

1678: IF (p_plan_type <> 4 AND p_plan_type <> 9) THEN
1679: select to_number(to_char(cal1.prior_date,'J'))
1680: into l_calendar_date
1681: from msc_plan_buckets own_org_bkt,
1682: msc_plan_buckets org_bkt,
1683: msc_calendar_dates cal1
1684: where own_org_bkt.plan_id = p_plan_id
1685: and own_org_bkt.organization_id = p_owning_org_id
1686: and own_org_bkt.sr_instance_id = p_owning_instance_id

Line 1704: from msc_plan_buckets org_bkt,

1700: and cal1.sr_instance_id = p_ss_instance_id ;
1701: ELSE
1702: select to_number(to_char(cal1.next_date,'J'))
1703: into l_calendar_date
1704: from msc_plan_buckets org_bkt,
1705: msc_calendar_dates cal1
1706: where org_bkt.plan_id = p_plan_id
1707: and org_bkt.organization_id = p_owning_org_id
1708: and org_bkt.sr_instance_id = p_owning_instance_id