DBA Data[Home] [Help]

APPS.ISC_EDW_BOOK_SUM1_F_C dependencies on ISC_EDW_BOOK_SUM1_F_C

Line 1: PACKAGE BODY ISC_EDW_BOOK_SUM1_F_C AS

1: PACKAGE BODY ISC_EDW_BOOK_SUM1_F_C AS
2: /* $Header: ISCSCF2B.pls 115.14 2003/03/11 02:32:57 blindaue ship $ */
3:
4: g_errbuf VARCHAR2(2000) := NULL;
5: g_retcode VARCHAR2(200) := NULL;

Line 512: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date := nvl(l_from_date,

508: THEN errbuf := fnd_message.get;
509: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
510: END IF;
511:
512: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date := nvl(l_from_date,
513: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
514:
515: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date := nvl(l_to_date,
516: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

Line 515: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date := nvl(l_to_date,

511:
512: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date := nvl(l_from_date,
513: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
514:
515: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date := nvl(l_to_date,
516: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
517:
518: ISC_EDW_BOOK_SUM1_F_C.g_push_from_booked_date := nvl(l_from_booked_date,
519: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);

Line 518: ISC_EDW_BOOK_SUM1_F_C.g_push_from_booked_date := nvl(l_from_booked_date,

514:
515: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date := nvl(l_to_date,
516: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
517:
518: ISC_EDW_BOOK_SUM1_F_C.g_push_from_booked_date := nvl(l_from_booked_date,
519: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
520:
521: ISC_EDW_BOOK_SUM1_F_C.g_push_to_booked_date := nvl(l_to_booked_date,
522: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

Line 521: ISC_EDW_BOOK_SUM1_F_C.g_push_to_booked_date := nvl(l_to_booked_date,

517:
518: ISC_EDW_BOOK_SUM1_F_C.g_push_from_booked_date := nvl(l_from_booked_date,
519: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
520:
521: ISC_EDW_BOOK_SUM1_F_C.g_push_to_booked_date := nvl(l_to_booked_date,
522: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
523:
524: EDW_LOG.Put_Line( 'The collection range is from '||
525: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||

Line 654: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,

650: EDW_COLLECTION_UTIL.Wrapup(
651: TRUE,
652: g_row_count,
653: NULL,
654: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,
655: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date);
656:
657:
658: /*--------------------------------------------------------------------------

Line 655: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date);

651: TRUE,
652: g_row_count,
653: NULL,
654: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,
655: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date);
656:
657:
658: /*--------------------------------------------------------------------------
659: END OF Collection , Developer Customizable Section

Line 674: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,

670: EDW_COLLECTION_UTIL.Wrapup(
671: FALSE,
672: g_row_count,
673: NULL,
674: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,
675: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date);
676: RAISE;
677:
678: WHEN L_PUSH_REMOTE_FAILURE THEN

Line 675: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date);

671: FALSE,
672: g_row_count,
673: NULL,
674: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,
675: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date);
676: RAISE;
677:
678: WHEN L_PUSH_REMOTE_FAILURE THEN
679: errbuf := g_errbuf;

Line 689: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,

685: EDW_COLLECTION_UTIL.Wrapup(
686: FALSE,
687: g_row_count,
688: NULL,
689: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,
690: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date);
691: RAISE;
692:
693: WHEN L_SET_STATUS_FAILURE THEN

Line 690: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date);

686: FALSE,
687: g_row_count,
688: NULL,
689: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,
690: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date);
691: RAISE;
692:
693: WHEN L_SET_STATUS_FAILURE THEN
694: errbuf := g_errbuf;

Line 705: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,

701: EDW_COLLECTION_UTIL.Wrapup(
702: FALSE,
703: g_row_count,
704: NULL,
705: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,
706: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date);
707: RAISE;
708:
709: WHEN L_IDEN_CHANGE_FAILURE THEN

Line 706: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date);

702: FALSE,
703: g_row_count,
704: NULL,
705: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,
706: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date);
707: RAISE;
708:
709: WHEN L_IDEN_CHANGE_FAILURE THEN
710: errbuf := g_errbuf;

Line 721: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,

717: EDW_COLLECTION_UTIL.Wrapup(
718: FALSE,
719: g_row_count,
720: NULL,
721: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,
722: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date);
723: RAISE;
724:
725: WHEN OTHERS THEN

Line 722: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date);

718: FALSE,
719: g_row_count,
720: NULL,
721: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,
722: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date);
723: RAISE;
724:
725: WHEN OTHERS THEN
726: errbuf := g_errbuf;

Line 735: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,

731: EDW_COLLECTION_UTIL.Wrapup(
732: FALSE,
733: g_row_count,
734: NULL,
735: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,
736: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date);
737: RAISE;
738: END;
739: END ISC_EDW_BOOK_SUM1_F_C;

Line 736: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date);

732: FALSE,
733: g_row_count,
734: NULL,
735: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,
736: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date);
737: RAISE;
738: END;
739: END ISC_EDW_BOOK_SUM1_F_C;

Line 739: END ISC_EDW_BOOK_SUM1_F_C;

735: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,
736: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date);
737: RAISE;
738: END;
739: END ISC_EDW_BOOK_SUM1_F_C;