1: package body isc_dbi_bsa_objects_c as
2: /* $Header: ISCSCFAB.pls 120.12 2006/09/15 12:03:39 achandak noship $ */
3:
4: g_batch_size number;
5: g_global_currency varchar2(30);
654: bis_collection_utilities.wrapup(
655: true,
656: g_row_count,
657: null,
658: isc_dbi_bsa_objects_c.g_push_from_date,
659: isc_dbi_bsa_objects_c.g_push_to_date
660: );
661:
662: return (1);
655: true,
656: g_row_count,
657: null,
658: isc_dbi_bsa_objects_c.g_push_from_date,
659: isc_dbi_bsa_objects_c.g_push_to_date
660: );
661:
662: return (1);
663:
695: if (CHECK_SETUP = -1)
696: then raise l_failure;
697: end if;
698:
699: isc_dbi_bsa_objects_c.g_push_from_date := g_global_start_date;
700: isc_dbi_bsa_objects_c.g_push_to_date := sysdate;
701:
702: bis_collection_utilities.put_line( 'The collection date range is from '||
703: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
696: then raise l_failure;
697: end if;
698:
699: isc_dbi_bsa_objects_c.g_push_from_date := g_global_start_date;
700: isc_dbi_bsa_objects_c.g_push_to_date := sysdate;
701:
702: bis_collection_utilities.put_line( 'The collection date range is from '||
703: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
704: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
776: bis_collection_utilities.wrapup(
777: false,
778: g_row_count,
779: g_errbuf,
780: isc_dbi_bsa_objects_c.g_push_from_date,
781: isc_dbi_bsa_objects_c.g_push_to_date
782: );
783:
784: when others then
777: false,
778: g_row_count,
779: g_errbuf,
780: isc_dbi_bsa_objects_c.g_push_from_date,
781: isc_dbi_bsa_objects_c.g_push_to_date
782: );
783:
784: when others then
785: rollback;
792: bis_collection_utilities.wrapup(
793: false,
794: g_row_count,
795: g_errbuf,
796: isc_dbi_bsa_objects_c.g_push_from_date,
797: isc_dbi_bsa_objects_c.g_push_to_date
798: );
799:
800: end load_fact;
793: false,
794: g_row_count,
795: g_errbuf,
796: isc_dbi_bsa_objects_c.g_push_from_date,
797: isc_dbi_bsa_objects_c.g_push_to_date
798: );
799:
800: end load_fact;
801:
1475: raise_application_error(-20000,'Error in SETUP: ' || errbuf);
1476: return;
1477: end if;
1478:
1479: isc_dbi_bsa_objects_c.g_push_from_date := null;
1480: isc_dbi_bsa_objects_c.g_push_to_date := sysdate;
1481:
1482: if (CHECK_SETUP = -1)
1483: then raise l_failure;
1476: return;
1477: end if;
1478:
1479: isc_dbi_bsa_objects_c.g_push_from_date := null;
1480: isc_dbi_bsa_objects_c.g_push_to_date := sysdate;
1481:
1482: if (CHECK_SETUP = -1)
1483: then raise l_failure;
1484: end if;
1545: bis_collection_utilities.wrapup(
1546: false,
1547: g_row_count,
1548: g_errbuf,
1549: isc_dbi_bsa_objects_c.g_push_from_date,
1550: isc_dbi_bsa_objects_c.g_push_to_date
1551: );
1552:
1553: when others then
1546: false,
1547: g_row_count,
1548: g_errbuf,
1549: isc_dbi_bsa_objects_c.g_push_from_date,
1550: isc_dbi_bsa_objects_c.g_push_to_date
1551: );
1552:
1553: when others then
1554: rollback;
1561: bis_collection_utilities.wrapup(
1562: false,
1563: g_row_count,
1564: g_errbuf,
1565: isc_dbi_bsa_objects_c.g_push_from_date,
1566: isc_dbi_bsa_objects_c.g_push_to_date
1567: );
1568:
1569: end update_fact;
1562: false,
1563: g_row_count,
1564: g_errbuf,
1565: isc_dbi_bsa_objects_c.g_push_from_date,
1566: isc_dbi_bsa_objects_c.g_push_to_date
1567: );
1568:
1569: end update_fact;
1570:
1567: );
1568:
1569: end update_fact;
1570:
1571: end isc_dbi_bsa_objects_c;