APPS.ISC_EDW_BACKLOGS_F_C dependencies on ISC_EDW_BACKLOGS_F_C

Line 1: PACKAGE BODY ISC_EDW_BACKLOGS_F_C AS

1: PACKAGE BODY ISC_EDW_BACKLOGS_F_C AS
2: /* $Header: ISCSCF1B.pls 115.17 2004/03/30 14:37:20 adwajan ship $ */
3:
4: g_row_count NUMBER := 0;
5: g_rows_collected NUMBER := 0;

Line 653: ISC_EDW_BACKLOGS_F_C.G_Push_From_Date := nvl(l_from_date,

649: g_errbuf := 'Error in function Setup : '||fnd_message.get;
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 '||

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 899: ISC_EDW_BACKLOGS_F_C.G_Push_From_Date,

895: EDW_COLLECTION_UTIL.Wrapup(
896: FALSE,
897: g_rows_collected,
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,

Line 900: ISC_EDW_BACKLOGS_F_C.G_Push_To_Date);

896: FALSE,
897: g_rows_collected,
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,

Line 906: ISC_EDW_BACKLOGS_F_C.G_Push_From_Date,

902: EDW_COLLECTION_UTIL.Wrapup(
903: TRUE,
904: g_rows_collected,
905: NULL,
906: ISC_EDW_BACKLOGS_F_C.G_Push_From_Date,
907: ISC_EDW_BACKLOGS_F_C.G_Push_To_Date);
908: END IF;
909:
910: COMMIT;

Line 907: ISC_EDW_BACKLOGS_F_C.G_Push_To_Date);

903: TRUE,
904: g_rows_collected,
905: NULL,
906: ISC_EDW_BACKLOGS_F_C.G_Push_From_Date,
907: ISC_EDW_BACKLOGS_F_C.G_Push_To_Date);
908: END IF;
909:
910: COMMIT;
911:

Line 926: ISC_EDW_BACKLOGS_F_C.G_Push_From_Date,

922: EDW_COLLECTION_UTIL.Wrapup(
923: FALSE,
924: g_rows_collected,
925: NULL,
926: ISC_EDW_BACKLOGS_F_C.G_Push_From_Date,
927: ISC_EDW_BACKLOGS_F_C.G_Push_To_Date);
928:
929: WHEN OTHERS THEN
930: ROLLBACK;

Line 927: ISC_EDW_BACKLOGS_F_C.G_Push_To_Date);

923: FALSE,
924: g_rows_collected,
925: NULL,
926: ISC_EDW_BACKLOGS_F_C.G_Push_From_Date,
927: ISC_EDW_BACKLOGS_F_C.G_Push_To_Date);
928:
929: WHEN OTHERS THEN
930: ROLLBACK;
931: g_errbuf := sqlerrm ||' - '|| sqlcode;

Line 938: ISC_EDW_BACKLOGS_F_C.G_Push_From_Date,

934: EDW_COLLECTION_UTIL.Wrapup(
935: FALSE,
936: g_rows_collected,
937: NULL,
938: ISC_EDW_BACKLOGS_F_C.G_Push_From_Date,
939: ISC_EDW_BACKLOGS_F_C.G_Push_To_Date);
940:
941: END;
942: END ISC_EDW_BACKLOGS_F_C;

Line 939: ISC_EDW_BACKLOGS_F_C.G_Push_To_Date);

935: FALSE,
936: g_rows_collected,
937: NULL,
938: ISC_EDW_BACKLOGS_F_C.G_Push_From_Date,
939: ISC_EDW_BACKLOGS_F_C.G_Push_To_Date);
940:
941: END;
942: END ISC_EDW_BACKLOGS_F_C;

Line 942: END ISC_EDW_BACKLOGS_F_C;

938: ISC_EDW_BACKLOGS_F_C.G_Push_From_Date,
939: ISC_EDW_BACKLOGS_F_C.G_Push_To_Date);
940:
941: END;
942: END ISC_EDW_BACKLOGS_F_C;