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.

[Home] [Help]

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 506: l_msc_plan_buckets.bucket_index,

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

Line 507: l_msc_plan_buckets.bkt_start_date,

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

Line 508: l_msc_plan_buckets.bkt_end_date,

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

Line 509: l_msc_plan_buckets.bucket_type,

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

Line 510: l_msc_plan_buckets.days_in_bkt

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

Line 527: l_msc_plan_buckets,

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

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

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

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

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

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

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

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

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

Line 542: l_msc_plan_buckets := NULL;

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

Line 561: l_msc_plan_buckets.bucket_index,

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

Line 562: l_msc_plan_buckets.bkt_start_date,

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

Line 563: l_msc_plan_buckets.bkt_end_date,

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

Line 564: l_msc_plan_buckets.bucket_type,

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

Line 565: l_msc_plan_buckets.days_in_bkt

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

Line 580: l_msc_plan_buckets,

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

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

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

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

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

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

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

Line 594: l_msc_plan_buckets := NULL;

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

Line 615: l_msc_plan_buckets.bucket_index,

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

Line 616: l_msc_plan_buckets.bkt_start_date,

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

Line 617: l_msc_plan_buckets.bkt_end_date,

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

Line 618: l_msc_plan_buckets.bucket_type,

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

Line 619: l_msc_plan_buckets.days_in_bkt

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

Line 636: l_msc_plan_buckets,

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

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

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

Line 1307: p_msc_plan_buckets IN OUT NOCOPY msc_plan_buckets_typ,

1303: p_plan_id NUMBER,
1304: p_sr_instance_id NUMBER,
1305: p_org_id NUMBER,
1306: p_bucket_index NUMBER,
1307: p_msc_plan_buckets IN OUT NOCOPY msc_plan_buckets_typ,
1308: p_err_mesg OUT NOCOPY VARCHAR2
1309: ) IS
1310: j NUMBER;
1311: k NUMBER;

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

1310: j NUMBER;
1311: k NUMBER;
1312: BEGIN
1313:
1314: FOR j IN 1..p_msc_plan_buckets.bucket_index.COUNT LOOP
1315: p_msc_plan_buckets.bucket_index(j) := j+p_bucket_index;
1316: END LOOP;
1317: /*
1318: IF mrdebug = TRUE THEN

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

1311: k NUMBER;
1312: BEGIN
1313:
1314: FOR j IN 1..p_msc_plan_buckets.bucket_index.COUNT LOOP
1315: p_msc_plan_buckets.bucket_index(j) := j+p_bucket_index;
1316: END LOOP;
1317: /*
1318: IF mrdebug = TRUE THEN
1319: NULL;

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

1316: END LOOP;
1317: /*
1318: IF mrdebug = TRUE THEN
1319: NULL;
1320: FOR j IN 1..p_msc_plan_buckets.bucket_index.COUNT LOOP
1321: LOG_MESSAGE(p_msc_plan_buckets.bucket_index(j)||' '||
1322: p_msc_plan_buckets.bkt_start_date(j)||' '||
1323: p_msc_plan_buckets.bkt_end_date(j)||' '||
1324: p_msc_plan_buckets.bucket_type(j)||' '||

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

1317: /*
1318: IF mrdebug = TRUE THEN
1319: NULL;
1320: FOR j IN 1..p_msc_plan_buckets.bucket_index.COUNT LOOP
1321: LOG_MESSAGE(p_msc_plan_buckets.bucket_index(j)||' '||
1322: p_msc_plan_buckets.bkt_start_date(j)||' '||
1323: p_msc_plan_buckets.bkt_end_date(j)||' '||
1324: p_msc_plan_buckets.bucket_type(j)||' '||
1325: p_msc_plan_buckets.days_in_bkt(j));

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

1318: IF mrdebug = TRUE THEN
1319: NULL;
1320: FOR j IN 1..p_msc_plan_buckets.bucket_index.COUNT LOOP
1321: LOG_MESSAGE(p_msc_plan_buckets.bucket_index(j)||' '||
1322: p_msc_plan_buckets.bkt_start_date(j)||' '||
1323: p_msc_plan_buckets.bkt_end_date(j)||' '||
1324: p_msc_plan_buckets.bucket_type(j)||' '||
1325: p_msc_plan_buckets.days_in_bkt(j));
1326: END LOOP;

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

1319: NULL;
1320: FOR j IN 1..p_msc_plan_buckets.bucket_index.COUNT LOOP
1321: LOG_MESSAGE(p_msc_plan_buckets.bucket_index(j)||' '||
1322: p_msc_plan_buckets.bkt_start_date(j)||' '||
1323: p_msc_plan_buckets.bkt_end_date(j)||' '||
1324: p_msc_plan_buckets.bucket_type(j)||' '||
1325: p_msc_plan_buckets.days_in_bkt(j));
1326: END LOOP;
1327:

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

1320: FOR j IN 1..p_msc_plan_buckets.bucket_index.COUNT LOOP
1321: LOG_MESSAGE(p_msc_plan_buckets.bucket_index(j)||' '||
1322: p_msc_plan_buckets.bkt_start_date(j)||' '||
1323: p_msc_plan_buckets.bkt_end_date(j)||' '||
1324: p_msc_plan_buckets.bucket_type(j)||' '||
1325: p_msc_plan_buckets.days_in_bkt(j));
1326: END LOOP;
1327:
1328: LOG_MESSAGE(p_msc_plan_buckets.bucket_index.count||' '||

Line 1325: p_msc_plan_buckets.days_in_bkt(j));

1321: LOG_MESSAGE(p_msc_plan_buckets.bucket_index(j)||' '||
1322: p_msc_plan_buckets.bkt_start_date(j)||' '||
1323: p_msc_plan_buckets.bkt_end_date(j)||' '||
1324: p_msc_plan_buckets.bucket_type(j)||' '||
1325: p_msc_plan_buckets.days_in_bkt(j));
1326: END LOOP;
1327:
1328: LOG_MESSAGE(p_msc_plan_buckets.bucket_index.count||' '||
1329: p_msc_plan_buckets.bkt_start_date.count||' '||

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

1324: p_msc_plan_buckets.bucket_type(j)||' '||
1325: p_msc_plan_buckets.days_in_bkt(j));
1326: END LOOP;
1327:
1328: LOG_MESSAGE(p_msc_plan_buckets.bucket_index.count||' '||
1329: p_msc_plan_buckets.bkt_start_date.count||' '||
1330: p_msc_plan_buckets.bkt_end_date.count||' '||
1331: p_msc_plan_buckets.bucket_type.count||' '||
1332: p_msc_plan_buckets.days_in_bkt.count);

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

1325: p_msc_plan_buckets.days_in_bkt(j));
1326: END LOOP;
1327:
1328: LOG_MESSAGE(p_msc_plan_buckets.bucket_index.count||' '||
1329: p_msc_plan_buckets.bkt_start_date.count||' '||
1330: p_msc_plan_buckets.bkt_end_date.count||' '||
1331: p_msc_plan_buckets.bucket_type.count||' '||
1332: p_msc_plan_buckets.days_in_bkt.count);
1333:

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

1326: END LOOP;
1327:
1328: LOG_MESSAGE(p_msc_plan_buckets.bucket_index.count||' '||
1329: p_msc_plan_buckets.bkt_start_date.count||' '||
1330: p_msc_plan_buckets.bkt_end_date.count||' '||
1331: p_msc_plan_buckets.bucket_type.count||' '||
1332: p_msc_plan_buckets.days_in_bkt.count);
1333:
1334: END IF;

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

1327:
1328: LOG_MESSAGE(p_msc_plan_buckets.bucket_index.count||' '||
1329: p_msc_plan_buckets.bkt_start_date.count||' '||
1330: p_msc_plan_buckets.bkt_end_date.count||' '||
1331: p_msc_plan_buckets.bucket_type.count||' '||
1332: p_msc_plan_buckets.days_in_bkt.count);
1333:
1334: END IF;
1335: */

Line 1332: p_msc_plan_buckets.days_in_bkt.count);

1328: LOG_MESSAGE(p_msc_plan_buckets.bucket_index.count||' '||
1329: p_msc_plan_buckets.bkt_start_date.count||' '||
1330: p_msc_plan_buckets.bkt_end_date.count||' '||
1331: p_msc_plan_buckets.bucket_type.count||' '||
1332: p_msc_plan_buckets.days_in_bkt.count);
1333:
1334: END IF;
1335: */
1336:

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

1333:
1334: END IF;
1335: */
1336:
1337: FORALL k IN 1..p_msc_plan_buckets.bucket_index.COUNT
1338: insert into msc_plan_buckets(
1339: PLAN_ID
1340: ,ORGANIZATION_ID
1341: ,SR_INSTANCE_ID

Line 1338: insert into msc_plan_buckets(

1334: END IF;
1335: */
1336:
1337: FORALL k IN 1..p_msc_plan_buckets.bucket_index.COUNT
1338: insert into msc_plan_buckets(
1339: PLAN_ID
1340: ,ORGANIZATION_ID
1341: ,SR_INSTANCE_ID
1342: ,BUCKET_INDEX

Line 1357: p_msc_plan_buckets.bucket_index(k),

1353: (
1354: p_plan_id,
1355: p_org_id,
1356: p_sr_instance_id,
1357: p_msc_plan_buckets.bucket_index(k),
1358: To_date(p_msc_plan_buckets.bkt_start_date(k), 'YYYY/MM/DD'),
1359: To_date(p_msc_plan_buckets.bkt_end_date(k), 'YYYY/MM/DD')+(86399/86400),
1360: p_msc_plan_buckets.bucket_type(k),
1361: p_msc_plan_buckets.days_in_bkt(k),

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

1354: p_plan_id,
1355: p_org_id,
1356: p_sr_instance_id,
1357: p_msc_plan_buckets.bucket_index(k),
1358: To_date(p_msc_plan_buckets.bkt_start_date(k), 'YYYY/MM/DD'),
1359: To_date(p_msc_plan_buckets.bkt_end_date(k), 'YYYY/MM/DD')+(86399/86400),
1360: p_msc_plan_buckets.bucket_type(k),
1361: p_msc_plan_buckets.days_in_bkt(k),
1362: 1,

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

1355: p_org_id,
1356: p_sr_instance_id,
1357: p_msc_plan_buckets.bucket_index(k),
1358: To_date(p_msc_plan_buckets.bkt_start_date(k), 'YYYY/MM/DD'),
1359: To_date(p_msc_plan_buckets.bkt_end_date(k), 'YYYY/MM/DD')+(86399/86400),
1360: p_msc_plan_buckets.bucket_type(k),
1361: p_msc_plan_buckets.days_in_bkt(k),
1362: 1,
1363: Sysdate,

Line 1360: p_msc_plan_buckets.bucket_type(k),

1356: p_sr_instance_id,
1357: p_msc_plan_buckets.bucket_index(k),
1358: To_date(p_msc_plan_buckets.bkt_start_date(k), 'YYYY/MM/DD'),
1359: To_date(p_msc_plan_buckets.bkt_end_date(k), 'YYYY/MM/DD')+(86399/86400),
1360: p_msc_plan_buckets.bucket_type(k),
1361: p_msc_plan_buckets.days_in_bkt(k),
1362: 1,
1363: Sysdate,
1364: 1,

Line 1361: p_msc_plan_buckets.days_in_bkt(k),

1357: p_msc_plan_buckets.bucket_index(k),
1358: To_date(p_msc_plan_buckets.bkt_start_date(k), 'YYYY/MM/DD'),
1359: To_date(p_msc_plan_buckets.bkt_end_date(k), 'YYYY/MM/DD')+(86399/86400),
1360: p_msc_plan_buckets.bucket_type(k),
1361: p_msc_plan_buckets.days_in_bkt(k),
1362: 1,
1363: Sysdate,
1364: 1,
1365: Sysdate,

Line 1406: FROM msc_plan_buckets

1402: --LOG_MESSAGE(' 1 : '||p_min_cutoff_bucket||' '||p_hour_cutoff_bucket);
1403:
1404: SELECT NVL(MIN(bkt_start_date), TRUNC(SYSDATE))
1405: INTO first_date
1406: FROM msc_plan_buckets
1407: WHERE plan_id = p_plan_id
1408: AND bucket_type = 1;
1409:
1410: --LOG_MESSAGE(' 2 : '||first_date);

Line 1440: from msc_plan_buckets

1436:
1437: SELECT NVL(max(bkt_end_date), TRUNC(SYSDATE)),
1438: NVL(max(bucket_index), 0)
1439: INTO l_daily_cutoff_date, p_daily_cutoff_bucket
1440: from msc_plan_buckets
1441: where plan_id = p_plan_id
1442: AND bucket_type = 1;
1443:
1444: if p_daily_cutoff_bucket = 0

Line 1460: from msc_plan_buckets

1456: SELECT
1457: Nvl(max(bkt_end_date),l_daily_cutoff_date),
1458: Nvl(max(bucket_index), p_daily_cutoff_bucket)
1459: INTO l_weekly_cutoff_date, p_weekly_cutoff_bucket
1460: from msc_plan_buckets
1461: where plan_id = p_plan_id
1462: AND bucket_type = 2;
1463:
1464: --LOG_MESSAGE(' 9 : '||l_weekly_cutoff_date||' '||p_weekly_cutoff_bucket);

Line 1470: from msc_plan_buckets

1466: SELECT
1467: Nvl(max(bkt_end_date),l_weekly_cutoff_date),
1468: Nvl(max(bucket_index), p_weekly_cutoff_bucket)
1469: INTO l_period_cutoff_date, p_period_cutoff_bucket
1470: from msc_plan_buckets
1471: where plan_id = p_plan_id
1472: AND bucket_type = 3;
1473:
1474: --LOG_MESSAGE(' 10 : '||l_period_cutoff_date||' '||p_period_cutoff_bucket);

Line 1610: from msc_plan_buckets own_org_bkt,

1606: into l_bucket_type,
1607: l_bucket_index,
1608: l_bkt_end_date,
1609: l_bkt_end_date1
1610: from msc_plan_buckets own_org_bkt,
1611: msc_plan_buckets org_bkt
1612: where own_org_bkt.plan_id = p_plan_id
1613: and own_org_bkt.organization_id = p_owning_org_id
1614: and own_org_bkt.sr_instance_id = p_owning_instance_id

Line 1611: msc_plan_buckets org_bkt

1607: l_bucket_index,
1608: l_bkt_end_date,
1609: l_bkt_end_date1
1610: from msc_plan_buckets own_org_bkt,
1611: msc_plan_buckets org_bkt
1612: where own_org_bkt.plan_id = p_plan_id
1613: and own_org_bkt.organization_id = p_owning_org_id
1614: and own_org_bkt.sr_instance_id = p_owning_instance_id
1615: and own_org_bkt.curr_flag = 1

Line 1647: from msc_plan_buckets org_bkt,

1643: and cal2.exception_set_id = -1;
1644: ELSE
1645: select to_number(to_char(cal2.calendar_date,'J'))
1646: into l_calendar_date
1647: from msc_plan_buckets org_bkt,
1648: msc_calendar_dates cal1,
1649: msc_calendar_dates cal2
1650: where org_bkt.plan_id = p_plan_id
1651: and org_bkt.organization_id = p_owning_org_id

Line 1707: from msc_plan_buckets own_org_bkt,

1703: BEGIN
1704: IF (p_plan_type <> 4 AND p_plan_type <> 9) THEN
1705: select to_number(to_char(cal1.prior_date,'J'))
1706: into l_calendar_date
1707: from msc_plan_buckets own_org_bkt,
1708: msc_plan_buckets org_bkt,
1709: msc_calendar_dates cal1
1710: where own_org_bkt.plan_id = p_plan_id
1711: and own_org_bkt.organization_id = p_owning_org_id

Line 1708: msc_plan_buckets org_bkt,

1704: IF (p_plan_type <> 4 AND p_plan_type <> 9) THEN
1705: select to_number(to_char(cal1.prior_date,'J'))
1706: into l_calendar_date
1707: from msc_plan_buckets own_org_bkt,
1708: msc_plan_buckets org_bkt,
1709: msc_calendar_dates cal1
1710: where own_org_bkt.plan_id = p_plan_id
1711: and own_org_bkt.organization_id = p_owning_org_id
1712: and own_org_bkt.sr_instance_id = p_owning_instance_id

Line 1730: from msc_plan_buckets org_bkt,

1726: and cal1.sr_instance_id = p_ss_instance_id ;
1727: ELSE
1728: select to_number(to_char(cal1.next_date,'J'))
1729: into l_calendar_date
1730: from msc_plan_buckets org_bkt,
1731: msc_calendar_dates cal1
1732: where org_bkt.plan_id = p_plan_id
1733: and org_bkt.organization_id = p_owning_org_id
1734: and org_bkt.sr_instance_id = p_owning_instance_id