APPS.ISC_EDW_BOOKINGS_F_C dependencies on ISC_EDW_BOOKINGS_F_C

Line 1: PACKAGE BODY ISC_EDW_BOOKINGS_F_C AS

1: PACKAGE BODY ISC_EDW_BOOKINGS_F_C AS
2: /* $Header: ISCSCF0B.pls 120.1 2005/09/07 11:55:23 scheung noship $ */
3:
4: g_row_count NUMBER := 0;
5: g_rows_collected NUMBER := 0;

Line 1037: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date := nvl(l_from_date,

1033: g_errbuf := 'Error in function Setup : '||fnd_message.get;
1034: RAISE l_failure;
1035: END IF;
1036:
1037: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date := nvl(l_from_date,
1038: EDW_COLLECTION_UTIL.G_Local_Last_Push_Start_Date - EDW_COLLECTION_UTIL.G_Offset);
1039:
1040: ISC_EDW_BOOKINGS_F_C.G_Push_To_Date := nvl(l_to_date,
1041: EDW_COLLECTION_UTIL.G_Local_Curr_Push_Start_Date);

Line 1040: ISC_EDW_BOOKINGS_F_C.G_Push_To_Date := nvl(l_to_date,

1036:
1037: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date := nvl(l_from_date,
1038: EDW_COLLECTION_UTIL.G_Local_Last_Push_Start_Date - EDW_COLLECTION_UTIL.G_Offset);
1039:
1040: ISC_EDW_BOOKINGS_F_C.G_Push_To_Date := nvl(l_to_date,
1041: EDW_COLLECTION_UTIL.G_Local_Curr_Push_Start_Date);
1042:
1043: EDW_LOG.Put_Line( 'The collection range is from '||
1044: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||

Line 1394: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date,

1390: EDW_COLLECTION_UTIL.Wrapup(
1391: FALSE,
1392: g_rows_collected,
1393: NULL,
1394: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date,
1395: ISC_EDW_BOOKINGS_F_C.G_Push_To_Date);
1396: ELSE
1397: EDW_COLLECTION_UTIL.Wrapup(
1398: TRUE,

Line 1395: ISC_EDW_BOOKINGS_F_C.G_Push_To_Date);

1391: FALSE,
1392: g_rows_collected,
1393: NULL,
1394: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date,
1395: ISC_EDW_BOOKINGS_F_C.G_Push_To_Date);
1396: ELSE
1397: EDW_COLLECTION_UTIL.Wrapup(
1398: TRUE,
1399: g_rows_collected,

Line 1401: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date,

1397: EDW_COLLECTION_UTIL.Wrapup(
1398: TRUE,
1399: g_rows_collected,
1400: NULL,
1401: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date,
1402: ISC_EDW_BOOKINGS_F_C.G_Push_To_Date);
1403: END IF;
1404:
1405: COMMIT;

Line 1402: ISC_EDW_BOOKINGS_F_C.G_Push_To_Date);

1398: TRUE,
1399: g_rows_collected,
1400: NULL,
1401: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date,
1402: ISC_EDW_BOOKINGS_F_C.G_Push_To_Date);
1403: END IF;
1404:
1405: COMMIT;
1406:

Line 1422: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date,

1418: EDW_COLLECTION_UTIL.Wrapup(
1419: FALSE,
1420: g_rows_collected,
1421: NULL,
1422: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date,
1423: ISC_EDW_BOOKINGS_F_C.G_Push_To_Date);
1424: WHEN OTHERS THEN
1425: ROLLBACK;
1426: g_errbuf := sqlerrm ||' - '|| sqlcode;

Line 1423: ISC_EDW_BOOKINGS_F_C.G_Push_To_Date);

1419: FALSE,
1420: g_rows_collected,
1421: NULL,
1422: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date,
1423: ISC_EDW_BOOKINGS_F_C.G_Push_To_Date);
1424: WHEN OTHERS THEN
1425: ROLLBACK;
1426: g_errbuf := sqlerrm ||' - '|| sqlcode;
1427: EDW_LOG.Put_Line('Other errors : '|| g_errbuf);

Line 1433: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date,

1429: EDW_COLLECTION_UTIL.Wrapup(
1430: FALSE,
1431: g_rows_collected,
1432: NULL,
1433: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date,
1434: ISC_EDW_BOOKINGS_F_C.G_Push_To_Date);
1435: END;
1436: END ISC_EDW_BOOKINGS_F_C;

Line 1434: ISC_EDW_BOOKINGS_F_C.G_Push_To_Date);

1430: FALSE,
1431: g_rows_collected,
1432: NULL,
1433: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date,
1434: ISC_EDW_BOOKINGS_F_C.G_Push_To_Date);
1435: END;
1436: END ISC_EDW_BOOKINGS_F_C;

Line 1436: END ISC_EDW_BOOKINGS_F_C;

1432: NULL,
1433: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date,
1434: ISC_EDW_BOOKINGS_F_C.G_Push_To_Date);
1435: END;
1436: END ISC_EDW_BOOKINGS_F_C;