APPS.ISC_EDW_BACKLOGS_F_C dependencies on EDW_COLLECTION_UTIL

Line 647: IF (Not EDW_COLLECTION_UTIL.Setup(l_fact_name))

643: l_to_date := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
644:
645: g_all_or_nothing_flag := upper(p_coll_flag);
646:
647: IF (Not EDW_COLLECTION_UTIL.Setup(l_fact_name))
648: THEN
649: g_errbuf := 'Error in function Setup : '||fnd_message.get;
650: RAISE l_failure;
651: END IF;

Line 654: EDW_COLLECTION_UTIL.G_Local_Last_Push_Start_Date - EDW_COLLECTION_UTIL.G_Offset);

650: RAISE l_failure;
651: END IF;
652:
653: ISC_EDW_BACKLOGS_F_C.G_Push_From_Date := nvl(l_from_date,
654: EDW_COLLECTION_UTIL.G_Local_Last_Push_Start_Date - EDW_COLLECTION_UTIL.G_Offset);
655: ISC_EDW_BACKLOGS_F_C.G_Push_To_Date := nvl(l_to_date,EDW_COLLECTION_UTIL.G_Local_Curr_Push_Start_Date);
656:
657: EDW_LOG.Put_Line( 'The collection range is from '||
658: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||

Line 655: ISC_EDW_BACKLOGS_F_C.G_Push_To_Date := nvl(l_to_date,EDW_COLLECTION_UTIL.G_Local_Curr_Push_Start_Date);

651: END IF;
652:
653: ISC_EDW_BACKLOGS_F_C.G_Push_From_Date := nvl(l_from_date,
654: EDW_COLLECTION_UTIL.G_Local_Last_Push_Start_Date - EDW_COLLECTION_UTIL.G_Offset);
655: ISC_EDW_BACKLOGS_F_C.G_Push_To_Date := nvl(l_to_date,EDW_COLLECTION_UTIL.G_Local_Curr_Push_Start_Date);
656:
657: EDW_LOG.Put_Line( 'The collection range is from '||
658: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
659: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));

Line 895: EDW_COLLECTION_UTIL.Wrapup(

891: EDW_LOG.Put_Line(' ');
892:
893: IF retcode = -1
894: THEN
895: EDW_COLLECTION_UTIL.Wrapup(
896: FALSE,
897: g_rows_collected,
898: NULL,
899: ISC_EDW_BACKLOGS_F_C.G_Push_From_Date,

Line 902: EDW_COLLECTION_UTIL.Wrapup(

898: NULL,
899: ISC_EDW_BACKLOGS_F_C.G_Push_From_Date,
900: ISC_EDW_BACKLOGS_F_C.G_Push_To_Date);
901: ELSE
902: EDW_COLLECTION_UTIL.Wrapup(
903: TRUE,
904: g_rows_collected,
905: NULL,
906: ISC_EDW_BACKLOGS_F_C.G_Push_From_Date,

Line 922: EDW_COLLECTION_UTIL.Wrapup(

918: WHEN L_FAILURE THEN
919: ROLLBACK;
920: EDW_LOG.Put_Line(g_errbuf);
921: retcode := -1;
922: EDW_COLLECTION_UTIL.Wrapup(
923: FALSE,
924: g_rows_collected,
925: NULL,
926: ISC_EDW_BACKLOGS_F_C.G_Push_From_Date,

Line 934: EDW_COLLECTION_UTIL.Wrapup(

930: ROLLBACK;
931: g_errbuf := sqlerrm ||' - '|| sqlcode;
932: EDW_LOG.Put_Line('Other errors : '|| g_errbuf);
933: retcode := -1;
934: EDW_COLLECTION_UTIL.Wrapup(
935: FALSE,
936: g_rows_collected,
937: NULL,
938: ISC_EDW_BACKLOGS_F_C.G_Push_From_Date,